Databases Reference
In-Depth Information
TIPS AND INSIGHTS FOR DATABASE PROFESSIONALS
•
Tip 1. Indexes can greatly improve query time and should be an integral part of a
query optimizer.
Automated tools used by Microsoft and IBM integrate index design
with query optimization. Some basic estimates for query time for a given query execu-
tion plan can be manually estimated, with or without indexes.
3.7
Literature Summary
Burleson, D.
Physical Database Design Using Oracle
. Boca Raton, FL, Auerbach Publish-
ers, 2005.
Date, C. J.
An Introduction to Database Systems
, vol. 1, 8th ed. Boston: Addison-Wesley,
2003.
Elmasri, R., and Navathe, S. B.
Fundamentals of Database Systems
, 4th ed. Boston:
Addison-Wesley, and Redwood City, CA, 2004.
Garcia-Molina, H., Ullman, J., and Widom, J.
Database Systems: The Complete Book
.
Englewood Cliffs, NJ: Prentice-Hall, 2001.
O'Neil, P., and O'Neil, E.
Database: Principles, Programming, and Performance
, 2nd ed.
San Francisco: Morgan Kaufmann, 2001.
Ozsu, M. T., and Valduriez, P.
Principles of Distributed Database Systems
. Englewood
Cliffs, NJ: Prentice-Hall, 1991.
Roussopoulos, N. View Indexing in Relational Databases.
ACM Trans Database Systems
7(2), 1982: 258-290.
Ramakrishnan, R., and Gehrke, J.
Database Management Systems
, 3rd ed. New York:
McGraw-Hill, 2004.
Selinger, P. G., Astrahan, M. M., Chamberlin, D. D. Lorie, R. A., and Price, T. G.
Access Path Selection in a Relational Database Management System.
ACM SIG-
MOD Conference
, 1979, pp. 23-34.
Silberschatz, A., Korth, H. F., and Sudarshan, S.
Database System Concepts
, 5th ed. New
York: McGraw-Hill, 2006.