Query optimization for web BBS by analytic function and function-based index in oracle DBMS

Hyunho Lee, Wonsuk Lee

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

A web BBS is one of representative interfaces in a web community. Web queries for the BBS have the inefficiency that a query optimizer should read all the contents of the BBS stored in a database every query, since web mechanism cannot memorize the previous state. In addition, the queries in a web BBS should guarantee the 'random page jump' property characterizing the BBS. In this paper, a query optimization method and its SQL statements for a web BBS are proposed using Oracle's new facilities - a window-based analytic function and a function-based index. Also, the proposed queries are verified through applying them to a real web community, showing that they make meaningful improvements in query performance.

Original languageEnglish
Title of host publicationProceedings - ALPIT 2007 6th International Conference on Advanced Language Processing and Web Information Technology
Pages606-611
Number of pages6
DOIs
Publication statusPublished - 2007 Dec 1
Event6th International Conference on Advanced Language Processing and Web Information Technology, ALPIT 2007 - Luoyang, Henan, China
Duration: 2007 Aug 222007 Aug 24

Publication series

NameProceedings - ALPIT 2007 6th International Conference on Advanced Language Processing and Web Information Technology

Other

Other6th International Conference on Advanced Language Processing and Web Information Technology, ALPIT 2007
CountryChina
CityLuoyang, Henan
Period07/8/2207/8/24

All Science Journal Classification (ASJC) codes

  • Computer Science(all)
  • Information Systems

Fingerprint Dive into the research topics of 'Query optimization for web BBS by analytic function and function-based index in oracle DBMS'. Together they form a unique fingerprint.

  • Cite this

    Lee, H., & Lee, W. (2007). Query optimization for web BBS by analytic function and function-based index in oracle DBMS. In Proceedings - ALPIT 2007 6th International Conference on Advanced Language Processing and Web Information Technology (pp. 606-611). [4460710] (Proceedings - ALPIT 2007 6th International Conference on Advanced Language Processing and Web Information Technology). https://doi.org/10.1109/ALPIT.2007.85