Cargando…

Getting started with CockroachDB : a guide to using a modern, cloud-native, and distributed SQL database for your data-intensive apps /

Get hands-on with deploying and managing your database services to provide scalable and high-speed data access on CockroachDB. Getting Started with CockroachDB will introduce you to the inner workings of CockroachDB and help you to understand how it provides faster access to distributed data through...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Rajanna, Kishen Das Kondabagilu (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, UK : Packt Publishing, 2022.
Edición:[First edition].
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a22000007i 4500
001 OR_on1304905323
003 OCoLC
005 20231017213018.0
006 m o d
007 cr cnu|||unuuu
008 220322s2022 enk ob 000 0 eng d
040 |a ORMDA  |b eng  |e rda  |e pn  |c ORMDA  |d ORMDA  |d OCLCO  |d EBLCP  |d OCLCF  |d OCLCQ  |d OCLCO 
020 |z 9781800560659 
029 1 |a AU@  |b 000071520460 
035 |a (OCoLC)1304905323 
037 |a 9781800560659  |b O'Reilly Media 
050 4 |a QA76.9.D3 
082 0 4 |a 005.74 
049 |a UAMI 
100 1 |a Rajanna, Kishen Das Kondabagilu,  |e author. 
245 1 0 |a Getting started with CockroachDB :  |b a guide to using a modern, cloud-native, and distributed SQL database for your data-intensive apps /  |c Kishen Das Kondabagilu Rajanna. 
250 |a [First edition]. 
264 1 |a Birmingham, UK :  |b Packt Publishing,  |c 2022. 
300 |a 1 online resource (246 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
504 |a Includes bibliographical references. 
520 |a Get hands-on with deploying and managing your database services to provide scalable and high-speed data access on CockroachDB. Getting Started with CockroachDB will introduce you to the inner workings of CockroachDB and help you to understand how it provides faster access to distributed data through a SQL interface. The book will also uncover how you can use the database to provide solutions where the data is highly available. Starting with CockroachDB's installation, setup, and configuration, this SQL book will familiarize you with the database architecture and database design principles. You'll then discover several options that CockroachDB provides to store multiple copies of your data to ensure fast data access. The book covers the internals of CockroachDB, how to deploy and manage it on the cloud, performance tuning to get the best out of CockroachDB, and how to scale data across continents and serve it locally. In addition to this, you'll get to grips with fault tolerance and auto-rebalancing, how indexes work, and the CockroachDB Admin UI. The book will guide you in building scalable cloud services on top of CockroachDB, covering administrative and security aspects and tips for troubleshooting, performance enhancements, and a brief guideline on migrating from traditional databases. By the end of this book, you'll have gained sufficient knowledge to manage your data on CockroachDB and interact with it from your application layer. 
505 0 |a Cover -- Title page -- Copyright and Credits -- Dedications -- Contributors -- Table of Contents -- Preface -- Section 1: Getting to Know CockroachDB -- Chapter 1: CockroachDB -- A Brief Introduction -- The history and evolution of databases -- SQL -- Object-oriented databases -- NoSQL -- NewSQL -- Database concepts -- Cardinality -- Overview of database models -- Processing models -- Embedded and mobile databases -- Database storage engines -- CAP theorem -- Consistency and partition tolerance (CP) -- Availability and partition tolerance (AP) -- Consistency and availability (CA) 
505 8 |a CockroachDB -- Why yet another database? -- Inspiration -- Key terms and concepts -- High-level overview -- Summary -- Chapter 2: How Does CockroachDB Work Internally? -- Technical requirements -- Installing a single-node CockroachDB cluster using Docker -- Execution of a SQL query -- SQL query execution -- Parsing -- Logical planning -- Physical planning -- Query execution -- Managing a transactional key-value store -- Data distribution across multiple nodes -- The MSKVS -- Meta ranges -- Table data -- Data replication for resilience and availability -- What is consensus? 
505 8 |a The Raft distributed consensus protocol -- Interactions with the disk for data storage -- Storage engine -- Summary -- Section 2: Exploring the Important Features of CockroachDB -- Chapter 3: Atomicity, Consistency, Isolation, and Durability (ACID) -- An overview of ACID properties -- Atomicity -- Consistency -- Isolation -- Durability -- ACID from CockroachDB's perspective -- Atomicity -- Consistency -- Isolation -- Durability -- Summary -- Chapter 4: Geo-Partitioning -- Technical requirements -- Introduction to geo-partitioning -- Cloud, regions, and zones -- Region -- Zone 
505 8 |a Regions and zones on various cloud providers -- Geo-partitioning in CockroachDB -- Single region -- Multi-region -- Summary -- Chapter 5: Fault Tolerance and Auto-Rebalancing -- Technical requirements -- Achieving fault tolerance -- Achieving fault tolerance at the storage layer -- Working example of fault tolerance at play -- Automatic rebalancing -- Recovering from multi-node failures -- Summary -- Chapter 6: How Indexes Work in CockroachDB -- Technical requirements -- Introduction to indexes -- Different types of indexes -- Primary indexes -- Secondary indexes -- Hash-sharded indexes 
505 8 |a Duplicate indexes -- Inverted indexes -- Partial indexes -- Spatial indexes -- Table joins and indexes -- Best practices while using indexes -- Summary -- Section 3: Working with CockroachDB -- Chapter 7: Schema Creation and Management -- Technical requirements -- DDL -- CREATE -- ALTER -- DROP -- DML -- DQL -- Supported data types -- Column-level constraints -- Table joins -- Using sequences -- Managing schema changes -- Summary -- Chapter 8: Exploring the Admin User Interface -- Technical requirements -- Introducing the admin UI -- Cluster overview -- Metrics deep dive 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
650 0 |a Database management. 
650 0 |a SQL (Computer program language) 
650 0 |a Cloud computing. 
650 0 |a Application software  |x Development. 
650 0 |a Web applications. 
650 0 |a Relational databases. 
650 6 |a Bases de données  |x Gestion. 
650 6 |a SQL (Langage de programmation) 
650 6 |a Infonuagique. 
650 6 |a Logiciels d'application  |x Développement. 
650 6 |a Applications Web. 
650 6 |a Bases de données relationnelles. 
650 7 |a Application software  |x Development  |2 fast 
650 7 |a Cloud computing  |2 fast 
650 7 |a Database management  |2 fast 
650 7 |a Relational databases  |2 fast 
650 7 |a SQL (Computer program language)  |2 fast 
650 7 |a Web applications  |2 fast 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781800560659/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
938 |a ProQuest Ebook Central  |b EBLB  |n EBL6935370 
994 |a 92  |b IZTAP