Title :
An extended model for integration between the Oracle DBMS and WWW
Author :
Jang, Gi-Hwa ; Mun, Hyeon Jeong ; Ok, Soo-Ho ; Woo, Yong-Tae
Author_Institution :
Dept. of Comput. Sci., Changwon Nat. Univ., South Korea
Abstract :
In this paper, we propose a new type of gateway for WWW-Oracle interface, called ORAWIS (ORAcle Web Interface System). It supports various types of relational queries on the WWW such as join between two tables, one level nested queries, ORDER BY and GROUP BY operations in a conditional clause. In addition, a application designer can suggest an access method for a table by query selection with a hint option on the WWW. It causes the Oracle optimizer to choose the specified access path. By this function, an application designer can choose more efficient way than the optimizer can determine. The designer can also check the execution time of the SQL statement on the WWW
Keywords :
Internet; SQL; query processing; relational databases; ORAWIS; Oracle Web Interface System; Oracle optimizer; SQL statement; WWW-Oracle interface; access method; application designer; conditional clause; hint option; query selection; Computer science; Design optimization; Educational institutions; Facsimile; Information retrieval; Internet; Optimization methods; Relational databases; TV; World Wide Web;
Conference_Titel :
Information, Communications and Signal Processing, 1997. ICICS., Proceedings of 1997 International Conference on
Print_ISBN :
0-7803-3676-3
DOI :
10.1109/ICICS.1997.647163
