| Document Type
|
:
|
BL
|
| Record Number
|
:
|
851027
|
| Main Entry
|
:
|
Bell, Charles
|
| Title & Author
|
:
|
Introducing the MySQL 8 document store /\ Charles Bell.
|
| Publication Statement
|
:
|
[New York, NY] :: Apress,, [2018]
|
|
|
:
|
, ©2018
|
| Page. NO
|
:
|
1 online resource (xxiii, 532 pages) :: illustrations
|
| ISBN
|
:
|
1484227247
|
|
|
:
|
: 1484227255
|
|
|
:
|
: 9781484227244
|
|
|
:
|
: 9781484227251
|
|
|
:
|
9781484227244
|
| Notes
|
:
|
Includes index.
|
| Contents
|
:
|
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
|
|
|
:
|
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
|
|
|
:
|
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
|
|
|
:
|
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
|
|
|
:
|
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
|
| Abstract
|
:
|
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.
|
| Subject
|
:
|
Database management.
|
| Subject
|
:
|
Databases.
|
| Subject
|
:
|
Computer programming-- software development.
|
| Subject
|
:
|
COMPUTERS-- Programming Languages-- SQL.
|
| Subject
|
:
|
Database management.
|
| Subject
|
:
|
Databases.
|
| Subject
|
:
|
Databases.
|
| Subject
|
:
|
MySQL (Electronic resource)
|
|
|
:
|
MySQL (Electronic resource)
|
| Dewey Classification
|
:
|
005.75/85
|
| LC Classification
|
:
|
QA76.73.S67
|