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

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

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

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)
Title of host publicationProceedings - Annual Meeting of the Decision Sciences Institute
Editors Anon
PublisherDecis Sci Inst
Pages814
Number of pages1
Volume2
StatePublished - 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

Fingerprint

Query processing
Data base
Subsystem
Electronic commerce
Query
Engines
Processing

ASJC Scopus subject areas

  • Management Information Systems
  • Hardware and Architecture

Cite this

Chen, N. K. A., Goes, P. B., & Marsden, J. R. (1997). LAS: A dynamically adaptive database subsystem for better query processing performances. In Anon (Ed.), Proceedings - Annual Meeting of the Decision Sciences Institute (Vol. 2, pp. 814). Decis Sci Inst.

LAS : A dynamically adaptive database subsystem for better query processing performances. / Chen, Nai Kuang Andrew; Goes, Paulo B; Marsden, James R.

Proceedings - Annual Meeting of the Decision Sciences Institute. ed. / Anon. Vol. 2 Decis Sci Inst, 1997. p. 814.

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

Chen, NKA, Goes, PB & Marsden, JR 1997, LAS: A dynamically adaptive database subsystem for better query processing performances. in Anon (ed.), Proceedings - Annual Meeting of the Decision Sciences Institute. vol. 2, Decis Sci Inst, pp. 814, Proceedings of the 1997 Annual Meeting of the Decision Sciences Institute. Part 1 (of 3), San Diego, CA, USA, 11/22/97.
Chen NKA, Goes PB, Marsden JR. LAS: A dynamically adaptive database subsystem for better query processing performances. In Anon, editor, Proceedings - Annual Meeting of the Decision Sciences Institute. Vol. 2. Decis Sci Inst. 1997. p. 814
Chen, Nai Kuang Andrew ; Goes, Paulo B ; Marsden, James R. / LAS : A dynamically adaptive database subsystem for better query processing performances. Proceedings - Annual Meeting of the Decision Sciences Institute. editor / Anon. Vol. 2 Decis Sci Inst, 1997. pp. 814
@inproceedings{566a44486632490f883cd5032bef0c35,
title = "LAS: A dynamically adaptive database subsystem for better query processing performances",
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.",
author = "Chen, {Nai Kuang Andrew} and Goes, {Paulo B} and Marsden, {James R.}",
year = "1997",
language = "English (US)",
volume = "2",
pages = "814",
editor = "Anon",
booktitle = "Proceedings - Annual Meeting of the Decision Sciences Institute",
publisher = "Decis Sci Inst",

}

TY - GEN

T1 - LAS

T2 - A dynamically adaptive database subsystem for better query processing performances

AU - Chen, Nai Kuang Andrew

AU - Goes, Paulo B

AU - Marsden, James R.

PY - 1997

Y1 - 1997

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=0031326610&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0031326610&partnerID=8YFLogxK

M3 - Conference contribution

AN - SCOPUS:0031326610

VL - 2

SP - 814

BT - Proceedings - Annual Meeting of the Decision Sciences Institute

A2 - Anon, null

PB - Decis Sci Inst

ER -