Designing an efficient and scalable relational database schema: Principles of design for data modeling

Title

Designing an efficient and scalable relational database schema: Principles of design for data modeling

Creator

Rajendran R.K.; Priya T.M.

Description

Relational databases are a critical component of modern software applications, providing a reliable and scalable method for storing and managing data. A well-designed database schema can enhance the performance and flexibility of applications, making them more efficient and easier to maintain. Data modeling is an essential process in designing a database schema, and it involves identifying and organizing data entities, attributes, and relationships. In this chapter, the authors discuss the principles of designing an efficient and scalable relational database schema, with a focus on data modeling techniques. They explore the critical aspects of normalization, data types, relationships, indexes, and denormalization, as well as techniques for optimizing database queries and managing scalability challenges. The principles discussed in this chapter can be applied to various database management systems and can be useful for designing a schema that meets the demands of modern data-intensive applications. 2023, IGI Global. All rights reserved.

Source

The Software Principles of Design for Data Modeling, pp. 168-176.

Date

2023-01-01

Publisher

IGI Global

Coverage

Rajendran R.K., CHRIST University (Deemed), India; Priya T.M., CHRIST University (Deemed), India

Rights

Restricted Access

Relation

ISBN: 978-166849810-1; 978-166849809-5

Format

Online

Language

English

Type

Book chapter

Identifier

https://doi.org/10.4018/978-1-6684-9809-5.ch013

https://www.scopus.com/inward/record.uri?eid=2-s2.0-85174355568&doi=10.4018%2f978-1-6684-9809-5.ch013&partnerID=40&md5=5b60e36c0560e2354896755fa5210b20