Arranging fact table records in a data warehouse to improve query performance

Computers and Operations Research

Volumn 31, Issue 13, 2004, Pages 2165-2182

  Lu, Xinjian ^a   Lowenthal, Franklin ^a  

^a CALIFORNIA STATE UNIVERSITY   (United States)

Author keywords

Computer disk; Cost model; Data warehouse; Optimization

Indexed keywords

ALGORITHMS; BUFFER STORAGE; DATA REDUCTION; DATA WAREHOUSES; HEURISTIC METHODS; RANDOM PROCESSES;

DIMENSIONAL TABLES; ROTATIONAL LATENCY;

OPERATIONS RESEARCH;

ALGORITHM;

EID: 2942714815     PISSN: 03050548     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0305-0548(03)00170-9     Document Type: Article

References (19)

1. Datta A. Thomas H. The cube data model: A conceptual model and algebra for on-line analytical processing in data warehouses Decision Support Systems 27 1999 289-301
2. Kimball R. The data warehouse toolkit 1996 Wiley New York
3. Vassiliadis P. Sellis T. A survey of logical models for OLAP databases SIGMOD Record 28 4 1999 64-69
4. Ramakrishnan R. Database management systems 1998 McGraw-Hill New York
5. Rob P, Coronel C. Database systems, design, implementation, - management. Thomson Learning, 2000.
6. Lu X. Gerchak Y. Minimizing the expected response time of an idled server on a line IIE Transactions 30 1998 401-408
7. Vickson R.G. Lu X. Optimal product and server locations in one-dimensional racks European Journal of Operational Research 105 1998 18-28
8. Chaudhuri S. Dayal U. An overview of data warehousing and OLAP technology SIGMOD Record 26 1 1997 65-74
9. Harinarayan V, Rajaraman A, Ullman JD. Implementing data cubes efficiently. ACM SIGMOD Conference on the Management of Data 1996, p. 205-16.
10. Ho CT, Agrawal R, Megiddo N, Srikant R. Range queries in OLAP data cubes. ACM SIGMOD Conference on the Management of Data 1997, p. 73-88.
11. O'Neill P. Graefe G. Multi-table joins though bitmapped join indexes SIGMOD Record 24 3 1995 8-11
12. Graefe H. Query evaluation techniques for large databases ACM Computing Survey 25 2 1995 73-171
13. Rao SG, Badia A, Gucht DV. Providing better support for a class of decision support queries. ACM SIGMOD Conference on the Management of Data 1996 217-27.
14. Ullman J.D. Principles of database and knowledge-base systems 1988 Computer Science Press Rockville, MD
15. Roussopoulos N, Kotidis Y, Roussopoulos M. Cube tree: organization of and bulk updates on the data cube. ACM SIGMOD Conference on the Management of Data 1997, p. 89-99.
16. Mumick IS, Quass D, Mumick BS. Maintenance of data cubes and summary tables in a warehouse. ACM SIGMOD Conference on the Management of Data 1997, p. 100-11.
17. Date CJ. An introduction to database systems, 7th ed. Reading, MA: Addison Wesley, NewYork: Longman, 2000.
18. Dodge G. Gorman T. Essential Oracle8i data warehousing 2000 Wiley New York
19. Aho A.V. Ullman J.D. Foundations of computer science 1992 W.H. Freeman and Company New York