Pro SQL Server relational database design and implementation:
Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in...
Gespeichert in:
| Beteiligte Personen: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
[United States]
Apress
[2016]
|
| Ausgabe: | Fifth edition. |
| Schriftenreihe: | The expert's voice in SQL
|
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9781484219720/?ar |
| Zusammenfassung: | Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. The pace of change in relational database management systems has been tremendous these past few years. Whereas in the past it was enough to think about optimizing data residing on spinning hard drives, today one also must consider solid-state storage as well as data that are constantly held in memory and never written to disk at all except as a backup. Furthermore, there is a trend toward hybrid cloud and on-premise database configurations as well a move toward preconfigured appliances. Pro SQL Server Relational Database Design and Implementation guides in the understanding of these massive changes and in their application toward sound database design. Gives a solid foundation in best practices and relational theory Covers the latest implementation features in SQL Server 2016 Helps you master in-memory OLTP and use it effectively Takes you from conceptual design to an effective, physical implementation |
| Beschreibung: | Includes bibliographical references and index. - Online resource; title from PDF title page (SpringerLink, viewed January 9, 2017) |
| Umfang: | 1 Online-Ressource |
| ISBN: | 9781484219737 1484219732 9781484219720 |
Internformat
MARC
| LEADER | 00000cam a22000002c 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-047604034 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228120215.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 191023s2016 xx |||||o 00| ||eng c | ||
| 020 | |a 9781484219737 |c electronic bk. |9 978-1-4842-1973-7 | ||
| 020 | |a 1484219732 |c electronic bk. |9 1-4842-1973-2 | ||
| 020 | |a 9781484219720 |9 978-1-4842-1972-0 | ||
| 035 | |a (DE-627-1)047604034 | ||
| 035 | |a (DE-599)KEP047604034 | ||
| 035 | |a (ORHE)9781484219720 | ||
| 035 | |a (DE-627-1)047604034 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 072 | 7 | |a COM |2 bisacsh | |
| 072 | 7 | |a UN |2 bicssc | |
| 072 | 7 | |a UMT |2 bicssc | |
| 082 | 0 | |a 005.75/85 |2 23 | |
| 100 | 1 | |a Davidson, Louis |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a Pro SQL Server relational database design and implementation |c Louis Davidson with Jessica Moss ; foreword by Kalen Delaney |
| 250 | |a Fifth edition. | ||
| 264 | 1 | |a [United States] |b Apress |c [2016] | |
| 264 | 4 | |c ©2016 | |
| 300 | |a 1 Online-Ressource | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 490 | 0 | |a The expert's voice in SQL | |
| 500 | |a Includes bibliographical references and index. - Online resource; title from PDF title page (SpringerLink, viewed January 9, 2017) | ||
| 520 | |a Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. The pace of change in relational database management systems has been tremendous these past few years. Whereas in the past it was enough to think about optimizing data residing on spinning hard drives, today one also must consider solid-state storage as well as data that are constantly held in memory and never written to disk at all except as a backup. Furthermore, there is a trend toward hybrid cloud and on-premise database configurations as well a move toward preconfigured appliances. Pro SQL Server Relational Database Design and Implementation guides in the understanding of these massive changes and in their application toward sound database design. Gives a solid foundation in best practices and relational theory Covers the latest implementation features in SQL Server 2016 Helps you master in-memory OLTP and use it effectively Takes you from conceptual design to an effective, physical implementation | ||
| 630 | 2 | 0 | |a SQL server |
| 650 | 0 | |a Client/server computing | |
| 650 | 0 | |a Relational databases | |
| 650 | 0 | |a Database management | |
| 650 | 4 | |a SQL server | |
| 650 | 4 | |a Architecture client-serveur (Informatique) | |
| 650 | 4 | |a Bases de données relationnelles | |
| 650 | 4 | |a Bases de données ; Gestion | |
| 650 | 4 | |a Databases | |
| 650 | 4 | |a COMPUTERS ; Client-Server Computing | |
| 650 | 4 | |a Client/server computing | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Relational databases | |
| 700 | 1 | |a Moss, Jessica M. |e VerfasserIn |4 aut | |
| 776 | 1 | |z 9781484219720 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9781484219720 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781484219720/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-047604034 |
|---|---|
| _version_ | 1829007782923206656 |
| adam_text | |
| any_adam_object | |
| author | Davidson, Louis Moss, Jessica M. |
| author_facet | Davidson, Louis Moss, Jessica M. |
| author_role | aut aut |
| author_sort | Davidson, Louis |
| author_variant | l d ld j m m jm jmm |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)047604034 (DE-599)KEP047604034 (ORHE)9781484219720 |
| dewey-full | 005.75/85 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 |
| dewey-search | 005.75/85 |
| dewey-sort | 15.75 285 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | Fifth edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>04030cam a22006252c 4500</leader><controlfield tag="001">ZDB-30-ORH-047604034</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228120215.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">191023s2016 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484219737</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-4842-1973-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1484219732</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-4842-1973-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484219720</subfield><subfield code="9">978-1-4842-1972-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)047604034</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP047604034</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781484219720</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)047604034</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">UN</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">UMT</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/85</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Davidson, Louis</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Pro SQL Server relational database design and implementation</subfield><subfield code="c">Louis Davidson with Jessica Moss ; foreword by Kalen Delaney</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Fifth edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[United States]</subfield><subfield code="b">Apress</subfield><subfield code="c">[2016]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2016</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">The expert's voice in SQL</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index. - Online resource; title from PDF title page (SpringerLink, viewed January 9, 2017)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. The pace of change in relational database management systems has been tremendous these past few years. Whereas in the past it was enough to think about optimizing data residing on spinning hard drives, today one also must consider solid-state storage as well as data that are constantly held in memory and never written to disk at all except as a backup. Furthermore, there is a trend toward hybrid cloud and on-premise database configurations as well a move toward preconfigured appliances. Pro SQL Server Relational Database Design and Implementation guides in the understanding of these massive changes and in their application toward sound database design. Gives a solid foundation in best practices and relational theory Covers the latest implementation features in SQL Server 2016 Helps you master in-memory OLTP and use it effectively Takes you from conceptual design to an effective, physical implementation</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Client/server computing</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Architecture client-serveur (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données relationnelles</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données ; Gestion</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Databases</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">COMPUTERS ; Client-Server Computing</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Client/server computing</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Moss, Jessica M.</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">9781484219720</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9781484219720</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9781484219720/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-047604034 |
| illustrated | Not Illustrated |
| indexdate | 2025-04-10T09:35:47Z |
| institution | BVB |
| isbn | 9781484219737 1484219732 9781484219720 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2016 |
| publishDateSearch | 2016 |
| publishDateSort | 2016 |
| publisher | Apress |
| record_format | marc |
| series2 | The expert's voice in SQL |
| spelling | Davidson, Louis VerfasserIn aut Pro SQL Server relational database design and implementation Louis Davidson with Jessica Moss ; foreword by Kalen Delaney Fifth edition. [United States] Apress [2016] ©2016 1 Online-Ressource Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier The expert's voice in SQL Includes bibliographical references and index. - Online resource; title from PDF title page (SpringerLink, viewed January 9, 2017) Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. The pace of change in relational database management systems has been tremendous these past few years. Whereas in the past it was enough to think about optimizing data residing on spinning hard drives, today one also must consider solid-state storage as well as data that are constantly held in memory and never written to disk at all except as a backup. Furthermore, there is a trend toward hybrid cloud and on-premise database configurations as well a move toward preconfigured appliances. Pro SQL Server Relational Database Design and Implementation guides in the understanding of these massive changes and in their application toward sound database design. Gives a solid foundation in best practices and relational theory Covers the latest implementation features in SQL Server 2016 Helps you master in-memory OLTP and use it effectively Takes you from conceptual design to an effective, physical implementation SQL server Client/server computing Relational databases Database management Architecture client-serveur (Informatique) Bases de données relationnelles Bases de données ; Gestion Databases COMPUTERS ; Client-Server Computing Moss, Jessica M. VerfasserIn aut 9781484219720 Erscheint auch als Druck-Ausgabe 9781484219720 |
| spellingShingle | Davidson, Louis Moss, Jessica M. Pro SQL Server relational database design and implementation SQL server Client/server computing Relational databases Database management Architecture client-serveur (Informatique) Bases de données relationnelles Bases de données ; Gestion Databases COMPUTERS ; Client-Server Computing |
| title | Pro SQL Server relational database design and implementation |
| title_auth | Pro SQL Server relational database design and implementation |
| title_exact_search | Pro SQL Server relational database design and implementation |
| title_full | Pro SQL Server relational database design and implementation Louis Davidson with Jessica Moss ; foreword by Kalen Delaney |
| title_fullStr | Pro SQL Server relational database design and implementation Louis Davidson with Jessica Moss ; foreword by Kalen Delaney |
| title_full_unstemmed | Pro SQL Server relational database design and implementation Louis Davidson with Jessica Moss ; foreword by Kalen Delaney |
| title_short | Pro SQL Server relational database design and implementation |
| title_sort | pro sql server relational database design and implementation |
| topic | SQL server Client/server computing Relational databases Database management Architecture client-serveur (Informatique) Bases de données relationnelles Bases de données ; Gestion Databases COMPUTERS ; Client-Server Computing |
| topic_facet | SQL server Client/server computing Relational databases Database management Architecture client-serveur (Informatique) Bases de données relationnelles Bases de données ; Gestion Databases COMPUTERS ; Client-Server Computing |
| work_keys_str_mv | AT davidsonlouis prosqlserverrelationaldatabasedesignandimplementation AT mossjessicam prosqlserverrelationaldatabasedesignandimplementation |