Database design in the modern organization - Identifying robust structures under changing query patterns and arrival rate conditions

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

Research output: Contribution to journalArticle

5 Citations (Scopus)

Abstract

We summarize the problem tackled here in the following way: Given a modern database application environment, how can we identify and select the database structure that provides robust performance across changing query patterns and arrival rate conditions? We demonstrate the importance of investigating the underlying relationships and then utilize this information in formulating robust structures. Our work is pre-theory in the philosophy of science sense. That is, the careful identification and observation of relationships will subsequently be utilized in formulating a testable theory of the development of robust database structures under dynamic query patterns and arrival rates. Our first step in providing a database design or "structure selection" method is to determine potential good performers among different database structures. These potential good performers are selected and analyzed across arrays of query patterns. The next step is to identify database structures that are robust structures, that is good performers across the different types of query patterns and arrival rate levels. The presentation includes illustrations of the determination of actual query pattern processing times and the use of these times within a queuing analysis. In fact, for the database layout analyzed, application of our methods demonstrates the existence of such robust database structures.

Original languageEnglish (US)
Pages (from-to)435-447
Number of pages13
JournalDecision Support Systems
Volume37
Issue number3
DOIs
StatePublished - Jun 2004
Externally publishedYes

Fingerprint

Databases
Query
Database design
Data Base
Data base
Observation
Processing
Performer

Keywords

  • Database design
  • Query pattern
  • Query processing
  • Queueing

ASJC Scopus subject areas

  • Management Information Systems
  • Information Systems
  • Information Systems and Management

Cite this

Database design in the modern organization - Identifying robust structures under changing query patterns and arrival rate conditions. / Chen, Andrew N K; Goes, Paulo B; Gupta, Alok; Marsden, James R.

In: Decision Support Systems, Vol. 37, No. 3, 06.2004, p. 435-447.

Research output: Contribution to journalArticle

@article{bfe99536bb024e11ba6964c34a0dc465,
title = "Database design in the modern organization - Identifying robust structures under changing query patterns and arrival rate conditions",
abstract = "We summarize the problem tackled here in the following way: Given a modern database application environment, how can we identify and select the database structure that provides robust performance across changing query patterns and arrival rate conditions? We demonstrate the importance of investigating the underlying relationships and then utilize this information in formulating robust structures. Our work is pre-theory in the philosophy of science sense. That is, the careful identification and observation of relationships will subsequently be utilized in formulating a testable theory of the development of robust database structures under dynamic query patterns and arrival rates. Our first step in providing a database design or {"}structure selection{"} method is to determine potential good performers among different database structures. These potential good performers are selected and analyzed across arrays of query patterns. The next step is to identify database structures that are robust structures, that is good performers across the different types of query patterns and arrival rate levels. The presentation includes illustrations of the determination of actual query pattern processing times and the use of these times within a queuing analysis. In fact, for the database layout analyzed, application of our methods demonstrates the existence of such robust database structures.",
keywords = "Database design, Query pattern, Query processing, Queueing",
author = "Chen, {Andrew N K} and Goes, {Paulo B} and Alok Gupta and Marsden, {James R.}",
year = "2004",
month = "6",
doi = "10.1016/S0167-9236(03)00048-4",
language = "English (US)",
volume = "37",
pages = "435--447",
journal = "Decision Support Systems",
issn = "0167-9236",
publisher = "Elsevier",
number = "3",

}

TY - JOUR

T1 - Database design in the modern organization - Identifying robust structures under changing query patterns and arrival rate conditions

AU - Chen, Andrew N K

AU - Goes, Paulo B

AU - Gupta, Alok

AU - Marsden, James R.

PY - 2004/6

Y1 - 2004/6

N2 - We summarize the problem tackled here in the following way: Given a modern database application environment, how can we identify and select the database structure that provides robust performance across changing query patterns and arrival rate conditions? We demonstrate the importance of investigating the underlying relationships and then utilize this information in formulating robust structures. Our work is pre-theory in the philosophy of science sense. That is, the careful identification and observation of relationships will subsequently be utilized in formulating a testable theory of the development of robust database structures under dynamic query patterns and arrival rates. Our first step in providing a database design or "structure selection" method is to determine potential good performers among different database structures. These potential good performers are selected and analyzed across arrays of query patterns. The next step is to identify database structures that are robust structures, that is good performers across the different types of query patterns and arrival rate levels. The presentation includes illustrations of the determination of actual query pattern processing times and the use of these times within a queuing analysis. In fact, for the database layout analyzed, application of our methods demonstrates the existence of such robust database structures.

AB - We summarize the problem tackled here in the following way: Given a modern database application environment, how can we identify and select the database structure that provides robust performance across changing query patterns and arrival rate conditions? We demonstrate the importance of investigating the underlying relationships and then utilize this information in formulating robust structures. Our work is pre-theory in the philosophy of science sense. That is, the careful identification and observation of relationships will subsequently be utilized in formulating a testable theory of the development of robust database structures under dynamic query patterns and arrival rates. Our first step in providing a database design or "structure selection" method is to determine potential good performers among different database structures. These potential good performers are selected and analyzed across arrays of query patterns. The next step is to identify database structures that are robust structures, that is good performers across the different types of query patterns and arrival rate levels. The presentation includes illustrations of the determination of actual query pattern processing times and the use of these times within a queuing analysis. In fact, for the database layout analyzed, application of our methods demonstrates the existence of such robust database structures.

KW - Database design

KW - Query pattern

KW - Query processing

KW - Queueing

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

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

U2 - 10.1016/S0167-9236(03)00048-4

DO - 10.1016/S0167-9236(03)00048-4

M3 - Article

AN - SCOPUS:2442425340

VL - 37

SP - 435

EP - 447

JO - Decision Support Systems

JF - Decision Support Systems

SN - 0167-9236

IS - 3

ER -