Cargando…
Pro SQL Server relational database design and implementation /
Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[United States] :
Apress,
[2016]
|
| Edición: | Fifth edition. |
| Colección: | Expert's voice in SQL.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- At a Glance; Contents; Foreword; About the Authors; About the Technical Reviewers; Acknowledgments; Introduction; Chapter 1: The Fundamentals; Taking a Brief Jaunt Through History; Introducing Codd's Rules for an RDBMS; Rule 1: The Information Principle; Rule 2: Guaranteed Access; Rule 3: Systematic Treatment of NULL Values; Rule 4: Dynamic Online Catalog Based on the Relational Model; Rule 5: Comprehensive Data Sublanguage Rule; Rule 6: View Updating Rule; Rule 7: High-Level Insert, Update, and Delete; Rule 8: Physical Data Independence; Rule 9: Logical Data Independence.
- Rule 10: Integrity IndependenceRule 11: Distribution Independence; Rule 12: Nonsubversion Rule; Nodding at SQL Standards; Recognizing Relational Data Structures; Introducing Databases and Schemas; Understanding Tables, Rows, and Columns; Working with Missing Values (NULLs); Defining Domains; Storing Metadata; Defining Uniqueness Constraints (Keys); Types of Keys; Choosing Keys; Natural Keys; Smart Keys; Surrogate Keys; Understanding Relationships; Working with Binary Relationships; One-to-Many Relationships; One-to-Many (The General Case); One-to-N Relationship; Many-to-Many Relationships.
- Working with Nonbinary RelationshipsUnderstanding Functional Dependencies; Understanding Functional Dependencies; Finding Determinants; Relational Programming; Outlining the Database-Specific Project Phases; Conceptual Phase; Logical Phase; Physical; Engine Adjustment Phase; Summary; Chapter 2: Introduction to Requirements; Documenting Requirements; Gathering Requirements; Interviewing Clients; Asking the Right Questions; What Data Is Needed?; How Will the Data Be Used?; What Rules Govern the Use of the Data?; What Data Is Reported On?; Where Is the Data Now?
- Will the Data Need to Be Integrated with Other Systems?How Much Is This Data Worth?; Who Will Use the Data?; Are Existing Systems Being Replaced?; Utilizing Other Types of Documentation; Early Project Documentation; Contracts or Client Work Orders; Level of Service Agreement; Audit Plans; Prototypes; Following Best Practices; Summary; Chapter 3: The Language of Data Modeling; Introducing Data Modeling; Entities; Attributes; Primary Keys; Alternate Keys; Foreign Keys; Domains; Relationships; Identifying Relationships; Nonidentifying Relationships; Role Names; Relationship Cardinality.
- Recursive RelationshipsSubtypes; Many-to-Many Relationships; Verb Phrases (Relationship Names); Descriptive Information; Alternative Modeling Methodologies; Information Engineering; Chen ERD; Best Practices; Summary; Chapter 4: Conceptual and Logical Data Model Production; Example Scenario; Building the Conceptual Model; Identifying Entities; Persons; Places; Objects; Ideas; Documents; Groups; Other Entities; Audit Trails; Events; Records and Journals; Entity Recap; Identifying Relationships Between Entities; One-to-N Relationships; Simple Relationships; Connection; Transactions.