Cargando…

Inside Relational Databases with Examples in Access

Inside Relational Databases was first published in 1997 and, rather to our surprise, rapidly reached the status of a classic work in the database field. Translated into three other languages and sold all over the world, it has helped thousands of people to understand the relational model that underp...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Whitehorn, Mark (Autor), Marklyn, Bill (Autor)
Autor Corporativo: SpringerLink (Online service)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: London : Springer London : Imprint: Springer, 2007.
Edición:1st ed. 2007.
Temas:
Acceso en línea:Texto Completo
Tabla de Contenidos:
  • A simple, single-table database
  • to Part 1
  • Tables
  • Queries/Views
  • Forms
  • Reports
  • Summary of Part 1
  • A multi-table database
  • to Part 2
  • Serious problems with single tables
  • Multiple tables cure serious problems
  • Making multiple tables work together
  • Getting the data into the correct tables
  • Relationships in the real world
  • How are relationships modeled?
  • Revisiting the big four - the synergy begins
  • Integrity
  • Summary of Part 2
  • Database Design & Architecture
  • Database design
  • The seven layers of wisdom
  • Database architecture
  • Related database topics
  • What exactly is a relational database?
  • 22 Triggers and stored procedures
  • Transactions, logs, backup, locking and concurrency
  • Codd's rules
  • Normalization
  • More about normalization
  • The system tables
  • More on queries: data manipulation
  • SQL
  • Domains
  • What does null mean?
  • Primary keys
  • Speeding up your database
  • Hardware considerations
  • Indexing
  • More on optimization
  • Denormalization.