TY - GEN
T1 - Query optimization for web BBS by analytic function and function-based index in oracle DBMS
AU - Lee, Hyunho
AU - Lee, Wonsuk
PY - 2007
Y1 - 2007
N2 - 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.
AB - 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.
UR - http://www.scopus.com/inward/record.url?scp=50049113864&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=50049113864&partnerID=8YFLogxK
U2 - 10.1109/ALPIT.2007.85
DO - 10.1109/ALPIT.2007.85
M3 - Conference contribution
AN - SCOPUS:50049113864
SN - 0769529305
SN - 9780769529301
T3 - Proceedings - ALPIT 2007 6th International Conference on Advanced Language Processing and Web Information Technology
SP - 606
EP - 611
BT - Proceedings - ALPIT 2007 6th International Conference on Advanced Language Processing and Web Information Technology
T2 - 6th International Conference on Advanced Language Processing and Web Information Technology, ALPIT 2007
Y2 - 22 August 2007 through 24 August 2007
ER -