Creating your MySQL database practical design tips and techniques
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham
Packt Pub.
c2006
|
| Schlagworte: | |
| Online-Zugang: | DE-1046 DE-1047 Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043098666 | ||
| 003 | DE-604 | ||
| 005 | 20190314 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151126s2006 xx o|||| 00||| eng d | ||
| 020 | |a 1847190200 |c electronic bk. |9 1-84719-020-0 | ||
| 020 | |a 9781847190208 |c electronic bk. |9 978-1-84719-020-8 | ||
| 035 | |a (OCoLC)248169826 | ||
| 035 | |a (DE-599)BVBBV043098666 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 |a DE-1047 | ||
| 082 | 0 | |a 005.75/65 |2 22 | |
| 100 | 1 | |a Delisle, Marc |e Verfasser |0 (DE-588)12987891X |4 aut | |
| 245 | 1 | 0 | |a Creating your MySQL database |b practical design tips and techniques |c Marc Delisle |
| 264 | 1 | |a Birmingham |b Packt Pub. |c c2006 | |
| 300 | |a 1 Online-Ressource (iii, 94 p.) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Includes index | ||
| 500 | |a 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 -- | ||
| 500 | |a - 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 -- | ||
| 500 | |a - 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 | ||
| 500 | |a 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 | ||
| 630 | 0 | 4 | |a MySQL (Electronic resource) |
| 650 | 7 | |a COMPUTERS / Programming Languages / SQL. |2 bisacsh | |
| 650 | 7 | |a MySQL (Electronic resource) |2 fast | |
| 650 | 7 | |a Database management / Computer programs |2 fast | |
| 650 | 4 | |a Database management |x Computer programs | |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=236611 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-028522857 | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=236611 |l DE-1046 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=236611 |l DE-1047 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1819295408452534273 |
|---|---|
| any_adam_object | |
| author | Delisle, Marc |
| author_GND | (DE-588)12987891X |
| author_facet | Delisle, Marc |
| author_role | aut |
| author_sort | Delisle, Marc |
| author_variant | m d md |
| building | Verbundindex |
| bvnumber | BV043098666 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)248169826 (DE-599)BVBBV043098666 |
| dewey-full | 005.75/65 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/65 |
| dewey-search | 005.75/65 |
| dewey-sort | 15.75 265 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05102nam a2200445zc 4500</leader><controlfield tag="001">BV043098666</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20190314 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151126s2006 xx o|||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1847190200</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-84719-020-0</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781847190208</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-84719-020-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)248169826</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043098666</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1046</subfield><subfield code="a">DE-1047</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/65</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Delisle, Marc</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)12987891X</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Creating your MySQL database</subfield><subfield code="b">practical design tips and techniques</subfield><subfield code="c">Marc Delisle</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham</subfield><subfield code="b">Packt Pub.</subfield><subfield code="c">c2006</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (iii, 94 p.)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">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 -- </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - 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 -- </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - 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</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">MySQL (Electronic resource)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">MySQL (Electronic resource)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management / Computer programs</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=236611</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028522857</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=236611</subfield><subfield code="l">DE-1046</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=236611</subfield><subfield code="l">DE-1047</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043098666 |
| illustrated | Not Illustrated |
| indexdate | 2024-12-24T04:41:44Z |
| institution | BVB |
| isbn | 1847190200 9781847190208 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028522857 |
| oclc_num | 248169826 |
| open_access_boolean | |
| owner | DE-1046 DE-1047 |
| owner_facet | DE-1046 DE-1047 |
| physical | 1 Online-Ressource (iii, 94 p.) |
| psigel | ZDB-4-EBA ZDB-4-EBA FAW_PDA_EBA |
| publishDate | 2006 |
| publishDateSearch | 2006 |
| publishDateSort | 2006 |
| publisher | Packt Pub. |
| record_format | marc |
| spelling | Delisle, Marc Verfasser (DE-588)12987891X aut Creating your MySQL database practical design tips and techniques Marc Delisle Birmingham Packt Pub. c2006 1 Online-Ressource (iii, 94 p.) txt rdacontent c rdamedia cr rdacarrier 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 MySQL (Electronic resource) COMPUTERS / Programming Languages / SQL. bisacsh MySQL (Electronic resource) fast Database management / Computer programs fast Database management Computer programs http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=236611 Aggregator Volltext |
| spellingShingle | Delisle, Marc Creating your MySQL database practical design tips and techniques MySQL (Electronic resource) COMPUTERS / Programming Languages / SQL. bisacsh MySQL (Electronic resource) fast Database management / Computer programs fast Database management Computer programs |
| title | Creating your MySQL database practical design tips and techniques |
| title_auth | Creating your MySQL database practical design tips and techniques |
| title_exact_search | Creating your MySQL database practical design tips and techniques |
| title_full | Creating your MySQL database practical design tips and techniques Marc Delisle |
| title_fullStr | Creating your MySQL database practical design tips and techniques Marc Delisle |
| title_full_unstemmed | Creating your MySQL database practical design tips and techniques Marc Delisle |
| title_short | Creating your MySQL database |
| title_sort | creating your mysql database practical design tips and techniques |
| title_sub | practical design tips and techniques |
| topic | MySQL (Electronic resource) COMPUTERS / Programming Languages / SQL. bisacsh MySQL (Electronic resource) fast Database management / Computer programs fast Database management Computer programs |
| topic_facet | MySQL (Electronic resource) COMPUTERS / Programming Languages / SQL. Database management / Computer programs Database management Computer programs |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=236611 |
| work_keys_str_mv | AT delislemarc creatingyourmysqldatabasepracticaldesigntipsandtechniques |