Pro SQL Server relational database design and implementation: best practices for scalability and performance
Learn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other de...
Gespeichert in:
| Beteilige Person: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
[Place of publication not identified]
Apress
2021
|
| Ausgabe: | 6th ed. |
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9781484264973/?ar |
| Zusammenfassung: | Learn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features. This book will help you design OLTP databases that are high-quality, protect the integrity of your data, and perform fast on-premises, in the cloud, or in hybrid configurations. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for well over 30 years, using technology that is constantly changing. This book covers everything from design logic that business users will understand to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, author Louis Davidson shows you how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. You will: Develop conceptual models of client data using interviews and client documentation Implement designs that work on premises, in the cloud, or in a hybrid approach Recognize and apply common database design patterns Normalize data models to enhance integrity and scalability of your databases for the long-term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Understand the concepts of concurrency |
| Beschreibung: | Includes index. - Online resource; title from PDF title page (SpringerLink, viewed February 26, 2021) |
| Umfang: | 1 Online-Ressource |
| ISBN: | 9781484264973 1484264975 1484264983 |
Internformat
MARC
| LEADER | 00000cam a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-060761504 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228121239.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 201219s2021 xx |||||o 00| ||eng c | ||
| 020 | |a 9781484264973 |c electronic bk. |9 978-1-4842-6497-3 | ||
| 020 | |a 1484264975 |c electronic bk. |9 1-4842-6497-5 | ||
| 020 | |a 1484264983 |9 1-4842-6498-3 | ||
| 035 | |a (DE-627-1)060761504 | ||
| 035 | |a (DE-599)KEP060761504 | ||
| 035 | |a (ORHE)9781484264973 | ||
| 035 | |a (DE-627-1)060761504 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 072 | 7 | |a UN |2 bicssc | |
| 072 | 7 | |a COM021000 |2 bisacsh | |
| 082 | 0 | |a 005.75/85 |2 23 | |
| 082 | 0 | |a 005.74 |2 23 | |
| 100 | 1 | |a Davidson, Louis |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a Pro SQL Server relational database design and implementation |b best practices for scalability and performance |c Louis Davidson |
| 250 | |a 6th ed. | ||
| 264 | 1 | |a [Place of publication not identified] |b Apress |c 2021 | |
| 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 | ||
| 500 | |a Includes index. - Online resource; title from PDF title page (SpringerLink, viewed February 26, 2021) | ||
| 520 | |a Learn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features. This book will help you design OLTP databases that are high-quality, protect the integrity of your data, and perform fast on-premises, in the cloud, or in hybrid configurations. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for well over 30 years, using technology that is constantly changing. This book covers everything from design logic that business users will understand to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, author Louis Davidson shows you how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. You will: Develop conceptual models of client data using interviews and client documentation Implement designs that work on premises, in the cloud, or in a hybrid approach Recognize and apply common database design patterns Normalize data models to enhance integrity and scalability of your databases for the long-term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Understand the concepts of concurrency | ||
| 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 Relational databases | |
| 650 | 4 | |a Client/server computing | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Microsoft software | |
| 776 | 1 | |z 1484264967 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 1484264967 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781484264973/?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-060761504 |
|---|---|
| _version_ | 1821494835060670464 |
| adam_text | |
| any_adam_object | |
| author | Davidson, Louis |
| author_facet | Davidson, Louis |
| author_role | aut |
| author_sort | Davidson, Louis |
| author_variant | l d ld |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)060761504 (DE-599)KEP060761504 (ORHE)9781484264973 |
| dewey-full | 005.75/85 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 005.74 |
| dewey-search | 005.75/85 005.74 |
| dewey-sort | 15.75 285 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 6th ed. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03643cam a22005772 4500</leader><controlfield tag="001">ZDB-30-ORH-060761504</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228121239.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">201219s2021 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484264973</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-4842-6497-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1484264975</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-4842-6497-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1484264983</subfield><subfield code="9">1-4842-6498-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)060761504</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP060761504</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781484264973</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)060761504</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">UN</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM021000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/85</subfield><subfield code="2">23</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</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="b">best practices for scalability and performance</subfield><subfield code="c">Louis Davidson</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">6th ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[Place of publication not identified]</subfield><subfield code="b">Apress</subfield><subfield code="c">2021</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="500" ind1=" " ind2=" "><subfield code="a">Includes index. - Online resource; title from PDF title page (SpringerLink, viewed February 26, 2021)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Learn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features. This book will help you design OLTP databases that are high-quality, protect the integrity of your data, and perform fast on-premises, in the cloud, or in hybrid configurations. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for well over 30 years, using technology that is constantly changing. This book covers everything from design logic that business users will understand to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, author Louis Davidson shows you how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. You will: Develop conceptual models of client data using interviews and client documentation Implement designs that work on premises, in the cloud, or in a hybrid approach Recognize and apply common database design patterns Normalize data models to enhance integrity and scalability of your databases for the long-term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Understand the concepts of concurrency</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">Relational databases</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">Microsoft software</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">1484264967</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">1484264967</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/-/9781484264973/?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-060761504 |
| illustrated | Not Illustrated |
| indexdate | 2025-01-17T11:20:41Z |
| institution | BVB |
| isbn | 9781484264973 1484264975 1484264983 |
| 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 | 2021 |
| publishDateSearch | 2021 |
| publishDateSort | 2021 |
| publisher | Apress |
| record_format | marc |
| spelling | Davidson, Louis VerfasserIn aut Pro SQL Server relational database design and implementation best practices for scalability and performance Louis Davidson 6th ed. [Place of publication not identified] Apress 2021 1 Online-Ressource Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Includes index. - Online resource; title from PDF title page (SpringerLink, viewed February 26, 2021) Learn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server versions. This book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features. This book will help you design OLTP databases that are high-quality, protect the integrity of your data, and perform fast on-premises, in the cloud, or in hybrid configurations. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for well over 30 years, using technology that is constantly changing. This book covers everything from design logic that business users will understand to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, author Louis Davidson shows you how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. You will: Develop conceptual models of client data using interviews and client documentation Implement designs that work on premises, in the cloud, or in a hybrid approach Recognize and apply common database design patterns Normalize data models to enhance integrity and scalability of your databases for the long-term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Understand the concepts of concurrency SQL server Client/server computing Relational databases Database management Architecture client-serveur (Informatique) Bases de données relationnelles Bases de données ; Gestion Microsoft software 1484264967 Erscheint auch als Druck-Ausgabe 1484264967 |
| spellingShingle | Davidson, Louis Pro SQL Server relational database design and implementation best practices for scalability and performance SQL server Client/server computing Relational databases Database management Architecture client-serveur (Informatique) Bases de données relationnelles Bases de données ; Gestion Microsoft software |
| title | Pro SQL Server relational database design and implementation best practices for scalability and performance |
| title_auth | Pro SQL Server relational database design and implementation best practices for scalability and performance |
| title_exact_search | Pro SQL Server relational database design and implementation best practices for scalability and performance |
| title_full | Pro SQL Server relational database design and implementation best practices for scalability and performance Louis Davidson |
| title_fullStr | Pro SQL Server relational database design and implementation best practices for scalability and performance Louis Davidson |
| title_full_unstemmed | Pro SQL Server relational database design and implementation best practices for scalability and performance Louis Davidson |
| title_short | Pro SQL Server relational database design and implementation |
| title_sort | pro sql server relational database design and implementation best practices for scalability and performance |
| title_sub | best practices for scalability and performance |
| topic | SQL server Client/server computing Relational databases Database management Architecture client-serveur (Informatique) Bases de données relationnelles Bases de données ; Gestion Microsoft software |
| 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 Microsoft software |
| work_keys_str_mv | AT davidsonlouis prosqlserverrelationaldatabasedesignandimplementationbestpracticesforscalabilityandperformance |