Корично изображение Електронна книга

Creating your MySQL database : practical design tips and techniques /

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-dev...

Пълно описание

Основен автор: Delisle, Marc.
Формат: Електронна книга
Език: English
Публикувано: Birmingham : Packt Pub., ℗♭2006.
Серия: From technologies to solutions.
Предмети:
MySQL (Electronic resource)
Database management > Computer programs.
COMPUTERS > Programming Languages > SQL.
Electronic books.
Онлайн достъп: http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=236611
Подобни документи: Print version:: Creating your MySQL database.
Съдържание:
  • 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.

Подобни библ. документи