Heuristics for selecting robust database structures with dynamic query patterns

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

• Type: Journal
• Year: 2006
• Where: EOR
• Authors: Andrew N. K. Chen, Paulo B. Goes, Alok Gupta, James R. Marsden
• Keywords: Crucial Managerial Decision-making, Database, Database Structures, EOR 2006