Creating your MySQL database practical design tips and techniques
Creating your MySQL database: practical design tips and techniques
Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: Delisle, Marc (VerfasserIn)
Format: Elektronisch E-Book
Sprache:English
Veröffentlicht: Birmingham Packt Pub. c2006
Schlagworte:
MySQL (Electronic resource)
COMPUTERS / Programming Languages / SQL.
Database management / Computer programs
Database management > Computer programs
Online-Zugang:FAW01
FAW02
Volltext
Beschreibung:Includes index
Cover -- TOC36;Table of Contents -- Preface -- CH36;Chapter 158; Introducing MySQL Design -- MySQL39;s Popularity and Impact -- The Need for MySQL Design -- 34;What do I do Next63;34; -- Data Design Steps -- Data as a Resource -- But this is my Data33; -- Data Modeling -- Overview of the Relational Model -- Simplified Design Technique -- Case Study -- Our Car Dealer -- The System39;s Goals -- The Tale of the Too Wide Table -- Summary -- CH36;Chapter 258; 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 -- Avoid Focusing on Reports and Screens -- Data Collected for our Case Study -- From the General Manager -- From the Salesperson -- From the Store Assistant -- Other Notes -- Summary -- CH36;Chapter 358; Data Naming -- Data Cleaning -- Subdividing Data Elements --
- Data Elements Containing Formatting Characters -- Data that are Results -- Data as a Column39;s or Table39;s Name -- Planning for Changes -- Pitfalls of the Free Fields Technique -- Naming Recommendations -- Designer39;s Creativity -- Abbreviations -- The Plural Form -- Naming Consistency -- MySQL39;s Possibilities versus Portability -- Table Name into a Column Name -- Summary -- CH36;Chapter 458; Data Grouping -- Initial List of Tables -- Rules for Table Layout -- Primary Keys and Table Names -- Data Redundancy and Dependency -- Improving the Structure -- Scalability over Time -- Empty Columns -- Avoiding ENUM and SET -- Multilingual Planning -- Validating the Structure -- Summary -- CH36;Chapter 558; Data Structure Tuning -- Data Access Policies -- Responsibility -- Security and Privileges -- Views -- Storage Engines -- Foreign Key Constraints -- Performance -- Indexes -- Accessing Replication Slave Servers -- Speed and Data Types -- Table Size Reduction --
- In45;Column Data Encoding -- Case Study39;s Final Structure -- Vehicle -- Person -- Sale -- Other tables -- Summary -- Supplemental Case Study -- Results from the Document Gathering Phase -- Preliminary List of Data Elements -- Tables and Sample Values -- Code Tables -- Themed Tables -- Composite45;Key Tables -- Airline System Data Schema -- Sample Queries -- Inserting Sample Values -- Boarding Pass -- Passenger List -- All Persons on a Flight -- Summary -- IDX36;Index -- Last Page
If you're creating a dynamic web application using open-source tools, then you're probably going to be setting up a MySQL database. Getting the design of this database right for your application and its data is vital, but it's often an intimidating and little-known process for non-developers and developers alike. Written by the creator of the popular phpMyAdmin tool, this book is a short but complete guide on how to design good data structures for MySQL. Anyone working with applications that use a MySQL database backend will benefit greatly from the advice and techniques in this book. Although a working knowledge of both SQL and MySQL is assumed, the book is suitable for both beginners and intermediate users alike. Whether you read it through and absorb the advice or work through it on a live project, the efficiency and maintainability of your databases will certainly improve as a result
Beschreibung:1 Online-Ressource (iii, 94 p.)
ISBN:1847190200
9781847190208

Es ist kein Print-Exemplar vorhanden.

Fernleihe Bestellen Achtung: Nicht im THWS-Bestand! Volltext öffnen

Ähnliche Einträge