Upgrade to Pro — share decks privately, control downloads, hide ads and more …

GDPR & You: The Nightmare Disproved with Graphs

Gianni Ceresa
September 08, 2018

GDPR & You: The Nightmare Disproved with Graphs

GDPR: 4 letters, an acronym being a nightmare for many companies. For the first time companies are really required to manage their data storage, workflows, security processes and processing. This session is about how graph database can support a GDPR compliance assessment.

Gianni Ceresa

September 08, 2018
Tweet

More Decks by Gianni Ceresa

Other Decks in Technology

Transcript













  1. Still didn’t hear of any,
    did you?

    View full-size slide





  2. View full-size slide

  3. GDPR compliant

    View full-size slide










  4. View full-size slide

  5. vertex (node)
    vertex
    properties
    vertex ID
    edge
    edge label
    edge
    properties
    edge ID
    directed
    edge

    View full-size slide





  6. View full-size slide

  7. mapped to reference
    reference
    page contains
    contains
    Catalog ACL
    member of
    member of

    View full-size slide





  8. View full-size slide









  9. View full-size slide



  10. BEGIN
    OPG_APIS.CREATE_PG('sa607', 4, 8, '');
    END;

    View full-size slide









  11. View full-size slide









  12. View full-size slide

  13. GraalVM will make this part useless thanks to its polyglot feature
    • Python will have direct access to Java objects and methods

    View full-size slide

  14. WITH properties AS (
    SELECT DISTINCT k, t, 'Vertex' AS kind
    FROM sa607vt$
    UNION ALL
    SELECT DISTINCT k, t, 'Edge' AS kind
    FROM sa607ge$
    )
    ,cfg AS (
    SELECT '.add' || kind || 'Property("' || k || '",PropertyTypeClass.'
    || CASE WHEN t = 1 THEN 'STRING' WHEN t = 5 THEN 'DATE' END
    || ')' AS prop
    FROM properties
    ) SELECT LISTAGG(prop,'') WITHIN GROUP(ORDER BY prop) FROM cfg;

    View full-size slide

  15. From 45700 nodes
    with 105406 edges,
    to 85 nodes with
    218 edges in
    seconds
    Catalog
    RPD

    View full-size slide