Creating your MySQL database practical design tips and techniques : a short guide for everyone on how to structure their data and set up their MySQL database tables efficiently and easily
A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, U.K. :
Packt Pub
2006.
|
| Edición: | 1st edition |
| Colección: | From technologies to solutions.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627594406719 |
Tabla de Contenidos:
- Creating your MySQL Database: Practical Design Tips and Techniques; Creating your MySQL Database: Practical Design Tips and Techniques; Credits; About the Author; About the Reviewer; 0. Preface; What This Book Covers; What You Need for This Book; Conventions; Reader Feedback; Customer Support; Downloading the Example Code for the Book; Errata; Questions; 1. Introducing MySQL Design; MySQL's Popularity and Impact; The Need for MySQL Design; ""What do I do Next?""; Data Design Steps; Data as a Resource; But this is my Data!; Data Modeling; Overview of the Relational Model; Rule #1; Rule #2
- Simplified Design TechniqueCase Study; Our Car Dealer; The System's Goals; The Tale of the Too Wide Table; Summary; 2. Data Collecting; System Boundaries Identification; Modular Development; Model Flexibility; Document Gathering; General Reading; Forms; Existing Computerized Systems; Interviews; Finding the Right Users; Perceptions; Asking the Right Questions; Existing Information Systems; Chronological Events; Sources and Destinations; Urgency; Avoid Focusing on Reports and Screens; Data Collected for our Case Study; From the General Manager; From the Salesperson; From the Store Assistant
- Other NotesSummary; 3. Data Naming; Data Cleaning; Subdividing Data Elements; Data Elements Containing Formatting Characters; Data that are Results; Data as a Column's or Table's Name; Planning for Changes; Pitfalls of the Free Fields Technique; Naming Recommendations; Designer's Creativity; Abbreviations; Clarity versus Length: an Art; Suffixing; The Plural Form; Naming Consistency; MySQL's Possibilities versus Portability; Table Name into a Column Name; Summary; 4. Data Grouping; Initial List of Tables; Rules for Table Layout; Primary Keys and Table Names; Data Redundancy and Dependency
- Composite KeysImproving the Structure; Scalability over Time; Empty Columns; Avoiding ENUM and SET; Multilingual Planning; Validating the Structure; Summary; 5. Data Structure Tuning; Data Access Policies; Responsibility; Security and Privileges; Views; Storage Engines; Foreign Key Constraints; Performance; Indexes; Helping the Query Optimizer: Analyze Table; Accessing Replication Slave Servers; Speed and Data Types; Table Size Reduction; In-Column Data Encoding; Case Study's Final Structure; Vehicle; Person; Sale; Other tables; Summary; 6. Supplemental Case Study
- Results from the Document Gathering PhasePreliminary List of Data Elements; Tables and Sample Values; Code Tables; Themed Tables; Composite-Key Tables; Airline System Data Schema; Sample Queries; Inserting Sample Values; Boarding Pass; Passenger List; All Persons on a Flight; Summary
