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

Volume

1

fYear

1997

fDate

9-12 Sep 1997

Firstpage

569

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Information, Communications and Signal Processing, 1997. ICICS., Proceedings of 1997 International Conference on

Print_ISBN

0-7803-3676-3

Type

conf

DOI

10.1109/ICICS.1997.647163

Filename

647163