From Conceptual Database Schemas to Logical Database Tuning

From Conceptual Database Schemas to Logical Database Tuning

Jean-Marc Petit, Mohand-Saïd Hacid
ISBN13: 9781591405276|ISBN10: 1591405270|EISBN13: 9781591405290
DOI: 10.4018/978-1-59140-527-6.ch003
Cite Chapter Cite Chapter

MLA

Petit, Jean-Marc, and Mohand-Saïd Hacid. "From Conceptual Database Schemas to Logical Database Tuning." Transformation of Knowledge, Information and Data: Theory and Applications, edited by Patrick van Bommel, IGI Global, 2005, pp. 52-74. https://doi.org/10.4018/978-1-59140-527-6.ch003

APA

Petit, J. & Hacid, M. (2005). From Conceptual Database Schemas to Logical Database Tuning. In P. Bommel (Ed.), Transformation of Knowledge, Information and Data: Theory and Applications (pp. 52-74). IGI Global. https://doi.org/10.4018/978-1-59140-527-6.ch003

Chicago

Petit, Jean-Marc, and Mohand-Saïd Hacid. "From Conceptual Database Schemas to Logical Database Tuning." In Transformation of Knowledge, Information and Data: Theory and Applications, edited by Patrick van Bommel, 52-74. Hershey, PA: IGI Global, 2005. https://doi.org/10.4018/978-1-59140-527-6.ch003

Export Reference

Mendeley
Favorite

Abstract

This chapter revisits conceptual database design and focuses on the so-called “logical database tuning”. We first recall fundamental differences between constructor-oriented models (like extended Entity-Relationship models) and attribute-oriented models (like the relational model). Then, we introduce an integrated algorithm for translating ER-like conceptual database schemas to relational database schemas. To consider the tuning of such logical databases, we highlight two extreme cases: null-free databases and efficient — though non redundant — databases. Finally, we point out how SQL workloads could be used a posteriori as a help for the designers and/or the database administrators to reach a compromise between these extreme cases. While a lot of papers and books have been devoted for many years to database design, we hope that this chapter will clarify the understanding of database designers when implementing their databases and database administrators when maintaining their databases.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.