Muutke küpsiste eelistusi

Introducing the MySQL 8 Document Store 1st ed. [Pehme köide]

  • Formaat: Paperback / softback, 532 pages, kõrgus x laius: 254x178 mm, 40 Illustrations, black and white; XXIII, 532 p. 40 illus., 1 Paperback / softback
  • Ilmumisaeg: 21-Jun-2018
  • Kirjastus: APress
  • ISBN-10: 1484227247
  • ISBN-13: 9781484227244
Teised raamatud teemal:
  • Pehme köide
  • Hind: 53,33 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 62,74 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Introducing the MySQL 8 Document Store 1st ed.Suurem pilt
  • Formaat: Paperback / softback, 532 pages, kõrgus x laius: 254x178 mm, 40 Illustrations, black and white; XXIII, 532 p. 40 illus., 1 Paperback / softback
  • Ilmumisaeg: 21-Jun-2018
  • Kirjastus: APress
  • ISBN-10: 1484227247
  • ISBN-13: 9781484227244
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781484227244.html
Märksõnad:
Learn the new Document Store feature of MySQL 8 and build applications around a mix of the best features from SQL and NoSQL database paradigms. Don’t allow yourself to be forced into one paradigm or the other, but combine both approaches by using the Document Store. 

MySQL 8 was designed from the beginning to bridge the gap between NoSQL and SQL. Oracle recognizes that many solutions need the capabilities of both. More specifically, developers need to store objects as loose collections of schema-less documents, but those same developers also need the ability to run structured queries on their data. With MySQL 8, you can do both!
Introducing the MySQL 8 Document Store presents new tools and features that make creating a hybrid database solution far easier than ever before. This book covers the vitally important MySQL Document Store, the new X Protocol for developing applications, and a new client shell called the MySQL Shell. Also covered are supporting technologies and concepts such as JSON, schema-less documents, and more. The book gives insight into how features work and how to apply them to get the most out of your MySQL experience. The book covers topics such as:
  • The headline feature in MySQL 8
  • MySQL's answer to NoSQL
  • New APIs and client protocols
What You'll Learn
  • Create NoSQL-style applications by using the Document Store
  • Mix the NoSQL and SQL approaches by using each to its best advantage in a hybrid solution
  • Work with the new X Protocol for application connectivity in MySQL 8
  • Master the new X Developer Application Programming Interfaces
  • Combine SQL and JSON in the same database and application
  • Migrate existing applications to MySQL Document Store
Who This Book Is For

Developers and database professionals wanting to learn about the most profound paradigm-changing features of the MySQL 8 Document Store



Tagline: Building Schema-less Database Solutions
About the Author xiii
About the Technical Reviewer xv
Acknowledgments xvii
Introduction xix
Chapter 1 Introducing MySQL 8---A New Beginning
1(36)
Old Features New Again
3(13)
JSON Data Type
4(4)
MySQL Shell
8(4)
X Plugin, X Protocol, and X DevAPI
12(2)
InnoDB Improvements
14(2)
New Features
16(3)
Data Dictionary
17(1)
Account Management
18(1)
Removed Options, Variables, and Features
19(1)
Paradigm Shifting Features
20(14)
Group Replication
21(4)
InnoDB Cluster
25(9)
Summary
34(3)
Chapter 2 Getting Started with MySQL
37(36)
Getting to Know MySQL
37(17)
How Do I Connect to MySQL?
39(3)
How to Get and Install MySQL
42(6)
Configuring and Managing Access to MySQL
48(6)
A MySQL Primer
54(16)
Creating Databases and Tables
54(3)
Searching for Data
57(4)
Creating Data
61(1)
Updating Data
62(1)
Deleting Data
63(1)
Using Indexes
64(1)
Views
65(1)
Triggers
65(1)
Simple Joins
66(3)
Stored Routines
69(1)
Summary
70(3)
Chapter 3 JSON Documents
73(62)
Concepts and Technologies: Jargon Explained
74(5)
Origins: Key, Value Mechanisms
74(2)
JSON
76(1)
Application Programming Interface
76(1)
NoSQL Interface
77(1)
Document Store
78(1)
Introducing JSON Documents
79(46)
JSON Format Rules
79(2)
Using JSON in MySQL
81(5)
Path Expressions
86(8)
JSON Functions
94(31)
Combining SQL and JSON - Indexing JSON Data
125(8)
Summary
133(2)
Chapter 4 The MySQL Shell
135(40)
Getting Started
136(14)
Features
137(2)
Shell Commands
139(2)
Options
141(3)
Sessions and Modes
144(2)
Connections
146(4)
Set Up and Install
150(8)
Install the MySQL Shell
151(4)
Setup the X Plugin
155(3)
Tutorial: MySQL Shell by Example
158(16)
Installing the Sample Database
159(3)
SQL
162(7)
JavaScript
169(3)
Python
172(2)
Summary
174(1)
Chapter 5 X Developer API
175(80)
Overview
176(5)
Clients
177(1)
Target Language Conformity
178(2)
MySQL X Module
180(1)
Classes and Methods
181(63)
Session Class
185(6)
CRUD Operations
191(28)
Example Data Used in this
Chapter
219(1)
Working with Data Sets
220(13)
Expressions
233(3)
Warnings and Errors
236(8)
Additional Features
244(8)
Parameter Binding
244(4)
Method Chaining
248(1)
CRUD Prepared Statements
249(2)
Asynchronous Execution
251(1)
For More Information
252(1)
Summary
253(2)
Chapter 6 X Plugin
255(30)
Overview
255(8)
Features
256(4)
Going Deeper---Journey into the Source Code
260(3)
Options and Variables
263(8)
How to View Values of Variables
263(3)
How to Set Values of Variables
266(3)
System Variables and Startup Options
269(2)
Status Variables
271(1)
Monitoring the X Plugin
271(11)
Communication
273(1)
Connections
274(1)
CRUD Operations
275(1)
Errors and Warnings
276(1)
Sessions
277(1)
SSL
278(2)
Statements
280(1)
Worker Threads
281(1)
Summary
282(3)
Chapter 7 X Protocol
285(46)
Overview
285(14)
Goals for the X Protocol
288(2)
X Protocol and Protocol Buffers
290(9)
X Protocol: Under the Hood
299(16)
Protobuf Implementation
299(5)
X Protocol Examples
304(5)
X Protocol Walkthrough
309(6)
Creating X Clients
315(14)
Setup for the Examples
317(2)
Document Store Example
319(6)
Relational Data Example
325(4)
Summary
329(2)
Chapter 8 Library Application: User Interface
331(68)
Getting Started
332(9)
Library Application
332(1)
Setup Your Environment
333(8)
Flask Primer
341(33)
Terminology
343(2)
Initialization and the Application Instance
345(9)
HTML Files and Templates
354(14)
Error Handlers
368(2)
Redirects
370(1)
Additional Features
371(1)
Flask Review: Sample Application
372(2)
Library Application User Interface Design
374(23)
Preparing the Directory Structure
375(1)
User Interface Features
376(4)
Form Classes
380(4)
View Functions
384(3)
Templates
387(6)
Application Code
393(4)
Summary
397(2)
Chapter 9 Library Application: Database Implementations
399(92)
Version 1 Relational Database
400(34)
Database Design
400(4)
Database Code
404(13)
Application Code
417(14)
Templates
431(1)
Executing the Code
431(2)
Observations
433(1)
Version 2 Relational Database + JSON Fields (Hybrid)
434(27)
Database Design
434(3)
Database Code
437(13)
Application Code
450(6)
Templates
456(2)
Executing the Code
458(3)
Observations
461(1)
Version 3 Document Store
461(28)
Database Design
462(1)
Database Code
463(14)
Application Code
477(7)
Templates
484(2)
Executing the Code
486(3)
Observations
489(1)
Challenges
489(1)
Summary
490(1)
Chapter 10 Planning for MySQL 8 and the Document Store
491(34)
Upgrading from MySQL 5.7 and Earlier
492(12)
Types of Upgrades
492(4)
Upgrade Practices
496(5)
Reasons for Upgrading
501(1)
Considerations for Upgrading to MySQL 8
502(2)
Migrating to Schemaless Documents
504(18)
Normalization vs. Denormalization
505(1)
Formal Rules vs. Heuristics
505(2)
Take Storage for Granted
507(1)
Embed or Separate?
507(1)
Strategies for Migrating to a Document Store
508(14)
Document Store Tips and Tricks
522(2)
Summary
524(1)
Index 525
Charles Bell conducts research in emerging technologies. He is a member of the Oracle MySQL Development team, and is a senior software developer for the MySQL Enterprise Backup team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005.  Charles is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, three-dimensional printing, database systems, software engineering, and sensor networks. He spends his limited free time as a practicing Maker, focusing on microcontroller projects and refinement of three-dimensional printers.