Database design and modeling with PostgreSQL and MySQL : build efficient and scalable databases for modern applications using open source databases|RISS 상세보기

Database design and modeling with PostgreSQL and MySQL : build efficient and scalable databases for modern applications using open source databases

한글로보기

https://www.riss.kr/link?id=M17353561

저자

Tezuysal, Alkin ; Ahmed, Ibrar ; Zaitsev, Peter
발행사항
Birmingham : Packt Publishing, Limited, 2024
발행연도
2024
작성언어
영어
주제어

Database management ; Database design ; Application software ; COMPUTERS / Database Administration & Management ; COMPUTERS / Data Science / Data Warehousing ; COMPUTERS / Data Science / Data Modeling & Design ; Data Modeling & Design ; Databases ; COMPUTERS ; Data Warehousing
DDC
005.74 판사항(23/eng/20240805)
ISBN
1803240962
9781803240961
자료형태
EBOOK
발행국
England
형태사항
1 online resource (222 p.)
일반주기명
Cover -- Copyright -- Foreword -- Contributors -- Table of Contents -- Preface -- Part 1: Introduction to Databases -- Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs -- Understanding databases and data models -- Exploring the relational data model (SQL databases) -- Tables, rows, and columns -- Normalization -- Structured Query Language (SQL) -- ACID transactions -- Navigating the document data model (NoSQL databases) -- Data models in NoSQL -- Types of NoSQL databases -- Key-value stores -- Document stores -- Column-family stores -- Graph databases
Applying the CAP theorem and NoSQL design choices -- Consistency -- Availability -- Partition tolerance -- Consistency models in NoSQL databases -- NoSQL design choices and use cases -- Managing transaction management and concurrency control in NoSQL -- BASE transactions in NoSQL databases -- Reasons for the BASE model in NoSQL databases -- Implications for data integrity and concurrency control -- Analyzing the advantages and disadvantages of NoSQL databases -- Advantages of NoSQL databases -- Disadvantages of NoSQL databases -- Summary
Chapter 2: Building a Strong Foundation for Database Design -- The importance of a solid foundation in database design -- Key terms and data models -- Understanding the relational model in detail -- Identifying entities, attributes, and relationships in database design -- Creating an ER diagram -- Advanced database design -- Normalization -- reducing redundancy and improving data integrity -- Achieving normal forms -- 1NF, 2NF, and 3NF -- Ensuring database validity and integrity -- Concluding thoughts -- Summary -- Part 2: Practical Implementation
Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL -- Understanding the sample database -- EDA and preprocessing -- Database schema -- MySQL -- Concluding thoughts -- Summary -- Part 3: Core Concepts in Database Design -- Chapter 4: Mastering the Building Blocks of Database Design and Modeling -- Understanding database objects -- Understanding data types and constraints -- Keys and how to use them -- Database checks and constraints -- Check constraint -- Default constraint -- Not null constraint -- Checking data quality with constraints -- No date in the future
Value within a specific range -- How to avoid redundancy -- Database consistency and beyond -- Transactions -- ensuring data integrity -- Concurrency control -- managing multiple users -- PostgreSQL -- MySQL -- Summary -- Part 4: Advanced Database Techniques -- Chapter 5: Advanced Techniques for Advanced Databases -- Creating custom views of your data -- Understanding the purpose of views -- The advantages of using views in database management -- Indexing -- how to find data faster -- Understanding indexing -- Types of indexes -- How indexing works -- PostgreSQL indexes -- MySQL indexes
Stored procedures -- reusable code for your database
소장기관