عنوان

Introducing the MySQL 8 document store /

(Number (ISBN

1484227247

(Number (ISBN

1484227255

(Number (ISBN

9781484227244

(Number (ISBN

9781484227251

Erroneous ISBN

9781484227244

Title Proper

Introducing the MySQL 8 document store /

General Material Designation

[Book]

First Statement of Responsibility

Charles Bell.

Place of Publication, Distribution, etc.

[New York, NY] :

Name of Publisher, Distributor, etc.

Apress,

Date of Publication, Distribution, etc.

[2018]

Date of Publication, Distribution, etc.

©2018

Specific Material Designation and Extent of Item

1 online resource (xxiii, 532 pages) :

Other Physical Details

illustrations

Text of Note

Includes index.

Text of Note

Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Introducing MySQL 8-A New Beginning; Old Features New Again; JSON Data Type; MySQL Shell; X Plugin, X Protocol, and X DevAPI; InnoDB Improvements; New Features; Data Dictionary; Account Management; Removed Options, Variables, and Features; Paradigm Shifting Features; Group Replication; InnoDB Cluster; Summary; Chapter 2: Getting Started with MySQL; Getting to Know MySQL; How Do I Connect to MySQL?; How to Get and Install MySQL; Configuring and Managing Access to MySQL

Text of Note

Chapter 5: X Developer APIOverview; Clients; Target Language Conformity; MySQL X Module; Classes and Methods; Session Class; Schema Methods; Transaction Methods; Connection Methods; Miscellaneous Methods; CRUD Operations; Schema Class; Collection Class; Table Class; Example Data Used in this Chapter; Working with Data Sets; Document Identifiers; Auto Increment; Accessing Data in Data Sets; Accessing Metadata in Results; Column Metadata; Expressions; Expression Strings; Boolean Expression Strings; Warnings and Errors; Warnings from the Server; Errors from the X DevAPI; Additional Features

Text of Note

Configuration FilesCreating Users and Granting Access; Configuring the Document Store; A MySQL Primer; Creating Databases and Tables; Searching for Data; Creating Data; Updating Data; Deleting Data; Using Indexes; Views; Triggers; Simple Joins; Stored Routines; Summary; Chapter 3: JSON Documents; Concepts and Technologies: Jargon Explained; Origins: Key, Value Mechanisms; JSON; Application Programming Interface; NoSQL Interface; Document Store; Introducing JSON Documents; JSON Format Rules; Using JSON in MySQL; Path Expressions; JSON Functions; Creating JSON Data; Modifying JSON Data

Text of Note

Parameter BindingMethod Chaining; CRUD Prepared Statements; Asynchronous Execution; For More Information; Summary; Chapter 6: X Plugin; Overview; Features; Secure Socket Layer (SSL) Connections; Changing the Default Port; Going Deeper-Journey into the Source Code; Options and Variables; How to View Values of Variables; How to Set Values of Variables; System Variables and Startup Options; Status Variables; Monitoring the X Plugin; Communication; Connections; CRUD Operations; Errors and Warnings; Sessions; SSL; Statements; Worker Threads; Summary; Chapter 7: X Protocol; Overview

Text of Note

Searching JSON DataUtility Functions; Combining SQL and JSON -- Indexing JSON Data; Summary; Chapter 4: The MySQL Shell; Getting Started; Features; Shell Commands; Options; Sessions and Modes; Session Objects; Modes Supported; Connections; Using a URI; Using Individual Options; Using Connections in Scripts; Using SSL Connections; Set Up and Install; Install the MySQL Shell; Setup the X Plugin; Enable the X Plugin Using the MySQL Shell; Enable the X Plugin Using the MySQL Client; Tutorial: MySQL Shell by Example; Installing the Sample Database; SQL; JavaScript; Python; Summary

0

8

8

8

8

Text of Note

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.

Source for Acquisition/Subscription Address

Springer Nature

Stock Number

com.springer.onix.9781484227251

International Standard Book Number

9781484227244

MySQL (Electronic resource)

MySQL (Electronic resource)

Database management.

Databases.

Computer programming-- software development.

COMPUTERS-- Programming Languages-- SQL.

Database management.

Databases.

Databases.

COM-- 051170

UMT

UN

Number

Edition

Class number

Bell, Charles

Date of Transaction

20200823031948.0

Cataloguing Rules (Descriptive Conventions))

pn

Electronic name

[Book]

Y