A query-driven approach to the design and management of flexible database systems

Andrew N K Chen, Paulo B Goes, James R. Marsden

Research output: Contribution to journalArticle

5 Citations (Scopus)

Abstract

The need for timely information in the e-business world provides the impetus to develop a flexible database system with the capability to adapt and maintain performance levels under changing queries and changing business environments. Recognizing the importance of providing fast access to a variety of read-only applications in today's e-business world, we introduce the systems architecture for developing and implementing a flexible database system to achieve considerable gains in processing times of read queries. The key component of a flexible database system is query mining, the concept of determining relationships among query properties, alternative database structures, and query processing times. We validate the flexible database system concept through extensive laboratory experiments, where we embed learning tools to demonstrate the implementation of query mining.

Original languageEnglish (US)
Pages (from-to)121-154
Number of pages34
JournalJournal of Management Information Systems
Volume19
Issue number3
StatePublished - Dec 2002
Externally publishedYes

Fingerprint

management
electronic business
Industry
Query processing
laboratory experiment
Data base
Query
Processing
learning
performance
Experiments
time
Electronic business
Laboratory experiments
Performance levels
System architecture
Business environment

ASJC Scopus subject areas

  • Management Information Systems
  • Management of Technology and Innovation
  • Strategy and Management
  • Information Systems
  • Library and Information Sciences

Cite this

A query-driven approach to the design and management of flexible database systems. / Chen, Andrew N K; Goes, Paulo B; Marsden, James R.

In: Journal of Management Information Systems, Vol. 19, No. 3, 12.2002, p. 121-154.

Research output: Contribution to journalArticle

@article{51eef0258c0547c68a2569d9e25794d0,
title = "A query-driven approach to the design and management of flexible database systems",
abstract = "The need for timely information in the e-business world provides the impetus to develop a flexible database system with the capability to adapt and maintain performance levels under changing queries and changing business environments. Recognizing the importance of providing fast access to a variety of read-only applications in today's e-business world, we introduce the systems architecture for developing and implementing a flexible database system to achieve considerable gains in processing times of read queries. The key component of a flexible database system is query mining, the concept of determining relationships among query properties, alternative database structures, and query processing times. We validate the flexible database system concept through extensive laboratory experiments, where we embed learning tools to demonstrate the implementation of query mining.",
author = "Chen, {Andrew N K} and Goes, {Paulo B} and Marsden, {James R.}",
year = "2002",
month = "12",
language = "English (US)",
volume = "19",
pages = "121--154",
journal = "Journal of Management Information Systems",
issn = "0742-1222",
publisher = "M.E. Sharpe Inc.",
number = "3",

}

TY - JOUR

T1 - A query-driven approach to the design and management of flexible database systems

AU - Chen, Andrew N K

AU - Goes, Paulo B

AU - Marsden, James R.

PY - 2002/12

Y1 - 2002/12

N2 - The need for timely information in the e-business world provides the impetus to develop a flexible database system with the capability to adapt and maintain performance levels under changing queries and changing business environments. Recognizing the importance of providing fast access to a variety of read-only applications in today's e-business world, we introduce the systems architecture for developing and implementing a flexible database system to achieve considerable gains in processing times of read queries. The key component of a flexible database system is query mining, the concept of determining relationships among query properties, alternative database structures, and query processing times. We validate the flexible database system concept through extensive laboratory experiments, where we embed learning tools to demonstrate the implementation of query mining.

AB - The need for timely information in the e-business world provides the impetus to develop a flexible database system with the capability to adapt and maintain performance levels under changing queries and changing business environments. Recognizing the importance of providing fast access to a variety of read-only applications in today's e-business world, we introduce the systems architecture for developing and implementing a flexible database system to achieve considerable gains in processing times of read queries. The key component of a flexible database system is query mining, the concept of determining relationships among query properties, alternative database structures, and query processing times. We validate the flexible database system concept through extensive laboratory experiments, where we embed learning tools to demonstrate the implementation of query mining.

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

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

M3 - Article

VL - 19

SP - 121

EP - 154

JO - Journal of Management Information Systems

JF - Journal of Management Information Systems

SN - 0742-1222

IS - 3

ER -