Cargando…
Data modeling for Azure Data Services : implement professional data design and structures in Azure /
Choose the right Azure data service and correct model design for successful implementation of your data model with the help of this hands-on guide. Data is at the heart of all applications and forms the foundation of modern data-driven businesses. With the multitude of data-related use cases and the...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Publishing, Limited,
2021.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_on1260342895 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 210717s2021 enk o 001 0 eng d | ||
| 040 | |a EBLCP |b eng |c EBLCP |d YDX |d UKMGB |d OCLCF |d N$T |d UKAHL |d OCLCO |d OCLCQ |d CPV |d IEEEE |d OCLCO | ||
| 015 | |a GBC196819 |2 bnb | ||
| 016 | 7 | |a 020227031 |2 Uk | |
| 019 | |a 1260191376 |a 1263808684 | ||
| 020 | |a 1801076707 | ||
| 020 | |a 9781801076708 |q (electronic bk.) | ||
| 020 | |z 1801077347 | ||
| 020 | |z 9781801077347 | ||
| 029 | 1 | |a UKMGB |b 020227031 | |
| 035 | |a (OCoLC)1260342895 |z (OCoLC)1260191376 |z (OCoLC)1263808684 | ||
| 037 | |a 9781801076708 |b Packt Publishing Pvt. Ltd | ||
| 037 | |a 10163462 |b IEEE | ||
| 050 | 4 | |a QA76.9.D26 | |
| 050 | 4 | |a QA76.585 | |
| 082 | 0 | 4 | |a 005.743 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Braake, Peter ter, |e author. | |
| 245 | 1 | 0 | |a Data modeling for Azure Data Services : |b implement professional data design and structures in Azure / |c Peter ter Braake. |
| 264 | 1 | |a Birmingham, UK : |b Packt Publishing, Limited, |c 2021. | |
| 300 | |a 1 online resource (0 p.) | ||
| 336 | |a text |2 rdacontent | ||
| 337 | |a computer |2 rdamedia | ||
| 338 | |a online resource |2 rdacarrier | ||
| 500 | |a Includes index. | ||
| 520 | |a Choose the right Azure data service and correct model design for successful implementation of your data model with the help of this hands-on guide. Data is at the heart of all applications and forms the foundation of modern data-driven businesses. With the multitude of data-related use cases and the availability of different data services, choosing the right service and implementing the right design becomes paramount to successful implementation.Data Modeling for Azure Data Services starts with an introduction to databases, entity analysis, and normalizing data. The book then shows you how to design a NoSQL database for optimal performance and scalability and covers how to provision and implement Azure SQL DB, Azure Cosmos DB, and Azure Synapse SQL Pool. As you progress through the chapters, you'll learn about data analytics, Azure Data Lake, and Azure SQL Data Warehouse and explore dimensional modeling, data vault modeling, along with designing and implementing a Data Lake using Azure Storage. You'll also learn how to implement ETL with Azure Data Factory.By the end of this book, you'll have a solid understanding of which Azure data services are the best fit for your model and how to implement the best design for your solution. This book is for business intelligence developers and consultants who work on (modern) cloud data warehousing and design and implement databases. Beginner-level knowledge of cloud data management is expected. | ||
| 505 | 0 | |a Cover -- Title page -- Copyright and Credits -- Contributors -- Table of Contents -- Preface -- Section 1 -- Operational/OLTP Databases -- Chapter 1: Introduction to Databases -- Overview of relational databases -- Files -- Relational databases -- Introduction to Structured Query Language -- Different categories of SQL -- Understanding the database schema -- Impact of intended usage patterns on database design -- Understanding relational theory -- Pillar 1 -- Elements of a set are not ordered -- Pillar 2 -- All elements in a set are unique -- Keys -- Types of keys -- Choosing the primary key | |
| 505 | 8 | |a Integrity -- The Check and Unique constraints -- Types of workload -- OLTP -- OLAP -- Summary -- Chapter 2: Entity Analysis -- Scope -- Project scope -- Product scope -- Understanding entity relationship diagrams -- Entities -- Understanding super- and sub-entities -- Naming entities -- Relationships -- Types of relationships -- Drawing conventions -- Recap -- Creating your first ERD -- Context of an ERD -- Summary -- Exercises -- Exercise 1 -- student registration -- Exercise 2 -- airline -- Chapter 3: Normalizing Data -- When to use normalization as a design strategy | |
| 505 | 8 | |a Considering all the details -- Preventing redundancy -- How to avoid redundancy -- The normalization steps -- Step zero -- First normal form -- Second normal form -- Third normal form -- Boyce-Codd and the fourth normal form -- Normalizing -- a recap -- An alternative approach to normalizing data -- Step 1 -- Step 2 -- Step 3 -- Step 4 -- Integrating separate results -- Entity relationship diagram -- Summary -- Exercises -- Exercise 1 -- Stock management of a bicycle shop -- Chapter 4: Provisioning and Implementing an Azure SQL DB -- Technical requirements -- Understanding SQL Server data types | |
| 505 | 8 | |a Numerical data -- Alphanumerical data -- Varying-length data types -- Dates -- Other data types -- Quantifying the data model -- Estimating the database size -- Analyzing expected usage patterns -- Provisioning an Azure SQL database -- Provisioned versus serverless -- vCores versus DTU -- Hyperscale and Business Critical -- Elastic pool -- Networking -- Additional settings -- Tags -- Review + create -- Connecting to the database -- Azure portal -- Azure Data Studio -- Data definition language -- Creating a table -- Altering a table -- Dropping a table -- Inserting data -- Indexing | |
| 505 | 8 | |a Clustered index -- Nonclustered index -- Automatic tuning -- Summary -- Chapter 5: Designing a NoSQL Database -- Understanding big data -- Understanding big data clusters -- Partitioning -- Getting to know Cosmos DB -- JSON -- Modeling JSON -- Using embedding versus referencing -- Referring to objects -- Cosmos DB partitioning -- Putting it together -- Key-value databases -- Modeling key-value databases -- Other NoSQL databases -- Gremlin -- Cassandra -- Extra considerations -- Polyglot persistence -- Concurrency -- Summary -- Exercise | |
| 500 | |a Chapter 6: Provisioning and Implementing an Azure Cosmos DB Database. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Windows Azure. |
| 630 | 0 | 7 | |a Windows Azure |2 fast |
| 650 | 0 | |a Cloud computing. | |
| 650 | 0 | |a Database design. | |
| 650 | 0 | |a Computer architecture. | |
| 650 | 6 | |a Infonuagique. | |
| 650 | 6 | |a Bases de données |x Conception. | |
| 650 | 6 | |a Ordinateurs |x Architecture. | |
| 650 | 7 | |a Cloud computing |2 fast | |
| 650 | 7 | |a Computer architecture |2 fast | |
| 650 | 7 | |a Database design |2 fast | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781801077347/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH38807557 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6670235 | ||
| 938 | |a YBP Library Services |b YANK |n 302326628 | ||
| 938 | |a EBSCOhost |b EBSC |n 2961991 | ||
| 994 | |a 92 |b IZTAP | ||