Jeudis du Libre - MySQL comme Document Store

  • View
    185

  • Download
    0

Embed Size (px)

Text of Jeudis du Libre - MySQL comme Document Store

  • 1 / 90

  • 2 / 90

  • Safe Harbor StatementThe following is intended to outline our general product direction. It is intended forinformation purpose only, and may not be incorporated into any contract. It is not acommitment to deliver any material, code, or functionality, and should not be relied up inmaking purchasing decisions. The development, release and timing of any features orfunctionality described for Oracle's product remains at the sole discretion of Oracle.

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    3 / 90

  • about.me/lefred

    Qui suis-je ?

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    4 / 90

  • Frdric Descamps@lefredvangliste MySQLBidouille MySQL depuis la version 3.23devops croyant et praticantMySQL Community Manager depuis mai2016

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    5 / 90

  • SGDB & MySQL

    Base de donnes Relationnelles

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    6 / 90

  • Bases de donnes RelationnellesIntgrit des donnes

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    7 / 90

  • Bases de donnes RelationnellesIntgrit des donnes

    normalization

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    8 / 90

  • Bases de donnes RelationnellesIntgrit des donnes

    normalizationcontraintes (cls trangres, ...)

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    9 / 90

  • Bases de donnes RelationnellesIntgrit des donnes

    normalizationcontraintes (cls trangres, ...)

    Atomicit, Cohrence, Isolarion et Durabilit - ACID

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    10 / 90

  • Bases de donnes RelationnellesIntgrit des donnes

    normalizationcontraintes (cls trangres, ...)

    Atomicit, Cohrence, Isolarion et Durabilit - ACIDtransactions

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    11 / 90

  • Bases de donnes RelationnellesIntgrit des donnes

    normalizationcontraintes (cls trangres, ...)

    Atomicit, Cohrence, Isolarion et Durabilit - ACIDtransactions

    SQL

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    12 / 90

  • Bases de donnes RelationnellesIntgrit des donnes

    normalizationcontraintes (cls trangres, ...)

    Atomicit, Cohrence, Isolarion et Durabilit - ACIDtransactions

    SQLpuissant language de requtes

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    13 / 90

  • SGDB & MySQL

    Base de donnes NoSQL

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    14 / 90

  • NoSQL ou Document StoreSans schma

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    15 / 90

  • NoSQL ou Document StoreSans schma

    pas de design de schmas, pas de normalization, de cls trangres, decontraintes, de type de donnes (data types), etc...

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    16 / 90

  • NoSQL ou Document StoreSans schma

    pas de design de schmas, pas de normalization, de cls trangres, decontraintes, de type de donnes (data types), etc...dvelopement initial trs rapide

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    17 / 90

  • NoSQL ou Document StoreSans schma

    pas de design de schmas, pas de normalization, de cls trangres, decontraintes, de type de donnes (data types), etc...dvelopement initial trs rapide

    Structures flexibles des donnes

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    18 / 90

  • NoSQL ou Document StoreSans schma

    pas de design de schmas, pas de normalization, de cls trangres, decontraintes, de type de donnes (data types), etc...dvelopement initial trs rapide

    Structures flexibles des donnesobjets et tableaux imbriqus

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    19 / 90

  • NoSQL ou Document StoreSans schma

    pas de design de schmas, pas de normalization, de cls trangres, decontraintes, de type de donnes (data types), etc...dvelopement initial trs rapide

    Structures flexibles des donnesobjets et tableaux imbriquscertaines donnes sont simplement naturellement non structures et nepeuvent tre modlises de faon optimale dans un modle relationel

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    20 / 90

  • NoSQL ou Document StoreSans schma

    pas de design de schmas, pas de normalization, de cls trangres, decontraintes, de type de donnes (data types), etc...dvelopement initial trs rapide

    Structures flexibles des donnesobjets et tableaux imbriquscertaines donnes sont simplement naturellement non structures et nepeuvent tre modlises de faon optimale dans un modle relationelpersistence des objets sans utilisation d'un ORM (mapping objet-relationnel)

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    21 / 90

  • NoSQL ou Document Store (2)JSON

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    22 / 90

  • NoSQL ou Document Store (2)JSON

    proche du frontend

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    23 / 90

  • NoSQL ou Document Store (2)JSON

    proche du frontend"natif " en Javascript

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    24 / 90

  • NoSQL ou Document Store (2)JSON

    proche du frontend"natif " en Javascriptutilis en Node.js

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    25 / 90

  • NoSQL ou Document Store (2)JSON

    proche du frontend"natif " en Javascriptutilis en Node.js

    Aprentissage facile, et facile utiliser

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    26 / 90

  • Les challenges actuelsles dveloppeurs veulent avancer plus rapidement

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    27 / 90

  • Les challenges actuelsles dveloppeurs veulent avancer plus rapidementle dlai de mise en production est un cot suprieur

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    28 / 90

  • Les challenges actuelsles dveloppeurs veulent avancer plus rapidementle dlai de mise en production est un cot suprieurrapidit de cration de prototypes, itrations rapides, ...

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    29 / 90

  • Avantages de SQL et de NoSQL

    NoSQL SQL

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    30 / 90

  • Et donc, Bases de donnes Relationnelles ou Document Store ??

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    31 / 90

  • Et donc, Bases de donnes Relationnelles ou Document Store ??

    Pourquoi pas les deux ?

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    32 / 90

  • Quelles sont les tapes ?

    NoSQL avec MySQL

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    33 / 90

  • Faire de MySQL un Document Store

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    34 / 90

  • Faire de MySQL un Document Store1. support de JSON datatype

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    35 / 90

  • Faire de MySQL un Document Store1. support de JSON datatype2. CRUD Operations

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    36 / 90

  • Faire de MySQL un Document Store1. support de JSON datatype2. CRUD Operations3. X Plugin

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    37 / 90

  • Faire de MySQL un Document Store1. support de JSON datatype2. CRUD Operations3. X Plugin4. X protocol & MySQL Shell

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    38 / 90

  • MySQL 5.7

    Support de JSON

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    39 / 90

  • Support JSONType natif de donnes (native datatype)

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    40 / 90

  • Support JSONType natif de donnes (native datatype)Valeurs en JSON stockes dans des tables MySQL

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    41 / 90

  • Support JSONType natif de donnes (native datatype)Valeurs en JSON stockes dans des tables MySQLFormat de stokage JSON en binaire (UTF8MB4)

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    42 / 90

  • Support JSONType natif de donnes (native datatype)Valeurs en JSON stockes dans des tables MySQLFormat de stokage JSON en binaire (UTF8MB4)Conversion partir des types SQL "natifs" vers des valeurs JSON

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    43 / 90

  • Support JSONType natif de donnes (native datatype)Valeurs en JSON stockes dans des tables MySQLFormat de stokage JSON en binaire (UTF8MB4)Conversion partir des types SQL "natifs" vers des valeurs JSONFunctions de manipulation du JSON

    Copyright @ 2017 Oracle and/or its affiliates. All rights reserved.

    44 / 90

  • Support JSONType natif de donnes (native datatype)Valeurs en JSON stockes dans des tables MySQLFormat de stokage JSON en bina