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
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
Country/TerritoryChina
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