.png){kind=icon}
Return
Heuristics for selecting robust database structures with dynamic query patterns
.png){kind=icon}
PRE
AI
DOI：10.1016/j.ejor.2004.04.035.png)
.png){kind=icon}
Original request for help.png){kind=icon}
Share.png){kind=icon}
Save
Abstract
En 中文
The success of a company increasingly depends on timely information (internal or external) being available to the right person at the right time for crucial managerial decision-making. Achieving such a right time/right place duet depends directly on database performance. A database system has been a core component that supports modern business system such as enterprise resource planning (ERP) system that integrates and supports all enterprise processes including product designing and engineering, manufacturing, and other business functions to achieve highest efficiency and effectiveness of operations. We develop and demonstrate through a proof-of-concept case study, a new query-driven heuristics for database design that seeks to identify database structures that perform robustly in dynamic settings with dynamic queries. Our focus is the design of efficient structures to process read-only queries in complex environments. Our heuristics begins with detailed analysis of relationships between diverse queries and the performance of different database structures. These relationships are then used in a series of steps that identify robust database structures that maintain high performance levels for a wide range of query patterns. We conjecture that our heuristics can facilitate efficient operations and effective decision-making of companies in today's dynamic environment. (c) 2004 Elsevier B.V. All rights reserved.
Keywords:
heuristics
computing science
database management
simulation
AI Summary
Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.
Journal
IF:
6
Papers:
2.2W
Citations:
6.4W
Organization
No organization information available
Cited Papers
ShareSave
ShareSaveAcceptance and Feasibility of a Guideline for the Animal Welfare Assessment of Fattening Pigs from Farmers’ Point of View.png)
Animals
OAAI
AnimalsIF0
OAAIShareSaveEffect of sialodacryoadenitis virus exposure on acinar epithelial cells from the rat lacrimal gland
PREAI
ShareSaveFunctional group effects on structure and topology of cadmium(ii) frameworks with mixed organic ligandsRSC Advances
RSC AdvancesIF0
PREAI
ShareSave
View more