{"title":"An extended model for integration between the Oracle DBMS and WWW","authors":"Gi-Hwa Jang, Hyeonjeong Mun, Sooho Ok, Yong-Tae Woo","doi":"10.1109/ICICS.1997.647163","DOIUrl":null,"url":null,"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.","PeriodicalId":71361,"journal":{"name":"信息通信技术","volume":"16 1","pages":"569-572 vol.1"},"PeriodicalIF":0.0000,"publicationDate":"1997-09-09","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"信息通信技术","FirstCategoryId":"1093","ListUrlMain":"https://doi.org/10.1109/ICICS.1997.647163","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
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.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
