LAS: A dynamically adaptive database subsystem for better query processing performances

Nai Kuang Andrew Chen, Paulo B. Goes, James R. Marsden

Research output: Contribution to conferencePaper

Abstract

For today's information markets and electronic commerce, timely information is crucial to competitive survival. Most of this past research has been focused on designing a single `optimal' database to process foreseeable queries or adopting optimization techniques for existing databases to get better query processing speed. These traditional techniques fall short in meeting the new challenges of today's dynamically changing environment and uncertain/dynamic query patterns. Our objective is to investigate and compare maintenance of multiple databases and/or materialized views for optimally answering specific queries and dynamically redesigning database structures to adapt changing query patterns. We propose that using a learning/assigning subsystem (LAS) detect the changing patterns of queries and then dynamically assign each query to the most suitable database structures and/or materialized views for processing. The learning/assigning subsystem (LAS) includes a learning engine, a knowledge base, and a trigger mechanism. The initial experimental results indicate that the LAS with eight database structures had much better query processing performance with faster response times than the traditional database system using any single database structure.

Original languageEnglish (US)
Number of pages1
StatePublished - Dec 1 1997
Externally publishedYes
EventProceedings of the 1997 Annual Meeting of the Decision Sciences Institute. Part 1 (of 3) - San Diego, CA, USA
Duration: Nov 22 1997Nov 25 1997

Other

OtherProceedings of the 1997 Annual Meeting of the Decision Sciences Institute. Part 1 (of 3)
CitySan Diego, CA, USA
Period11/22/9711/25/97

ASJC Scopus subject areas

  • Management Information Systems
  • Hardware and Architecture

Fingerprint Dive into the research topics of 'LAS: A dynamically adaptive database subsystem for better query processing performances'. Together they form a unique fingerprint.

  • Cite this

    Chen, N. K. A., Goes, P. B., & Marsden, J. R. (1997). LAS: A dynamically adaptive database subsystem for better query processing performances. Paper presented at Proceedings of the 1997 Annual Meeting of the Decision Sciences Institute. Part 1 (of 3), San Diego, CA, USA, .