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

Databases go Multi-model

Databases go Multi-model

Updated for DSTI on 2020-01-15
First presented at SIT Madrid on 2018-04-26

66a8e04959f652a198a2f9a910faa105?s=128

Vitaliy Rudnytskiy

January 16, 2020
Tweet

More Decks by Vitaliy Rudnytskiy

Other Decks in Programming

Transcript

  1. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 1 Public Vitaliy Rudnytskiy @Sygyzmundovych Databases go Multi-model
  2. 2 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ - aka Witalij Rudnicki, Віталій Рудницький - One of Developer Advocates in SAP Office of CTO - All things Data (with the focus on SAP HANA, SAP Data Intelligence, Analytics) - http://bit.ly/SAPDevsData - Based in Wrocław, Poland - Visiting lecturer at WSB university - Organizer of #sitWRO: SAP Inside Track Wrocław 51°04'40.3"N 16°57'48.8"E (WGS84) Vitaliy Rudnytskiy @Sygyzmundovych
  3. 3 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ
  4. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 4 Public Our customers produce more than 77% of the world’s beer
  5. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 5 Public Disclaimer The information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP. Except for your obligation to protect confidential information, this presentation is not subject to your license agreement or any other service or subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or any related document, or to develop or release any functionality mentioned therein. This presentation, or any related document and SAP's strategy and possible future developments, products and or platforms irections and functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information in this presentation is not a commitment, promise or legal obligation to deliver any material, code or functionality. This presentation is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. This presentation is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in this presentation, except if such damages were caused by SAP’s intentional or gross negligence. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.
  6. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 6 Public SAP Labs France SAS created over 20 years ago has over 400 employees in France almost 250 in its Mougins site (with 2 more sites in Paris and in Caen) Employs people of 17+ nationalities Engineering, maintenance, consulting and research: Cyber Security (SAP major center in research, training & testing) SAP Business One ERP for SMB SAP Solution Manager Hybris Billing
  7. (in the Data world) How did we get where we

    are?
  8. 9 © 2014 SAP SE or an SAP affiliate company.

    All rights reserved.
  9. 10 © 2014 SAP SE or an SAP affiliate company.

    All rights reserved.
  10. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 16 Public How did we get where we are? 1970s 1980s 1990s 2000s File systems Navigational DBs: Network Hierarchical RDBMS Desktop- based RDBMS SQL OODBMS Client-server i/o mainframes Relational model OOP Y2K! @sygyzmundovych
  11. „One Terabyte Club” 17 Sounds like terayears ago!

  12. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 21 Public How did we get where we are? 1970s 1980s 1990s 2000s File systems Navigational DBs: Network Hierarchical RDBMS Desktop- based RDBMS SQL OODBMS Client-server i/o mainframes Relational model Web OOP Y2K! Mobile @sygyzmundovych
  13. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 22 Public Changing human attention span https://time.com/3858309/attention-spans-goldfish/
  14. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 23 Public How did we get where we are? 1970s 1980s 1990s 2000s 2010s File systems Navigational DBs: Network Hierarchical RDBMS Desktop- based RDBMS SQL OODBMS NoSQL Client-server i/o mainframes Relational model Web OOP Y2K! IoT Mobile @sygyzmundovych
  15. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 27 Public The evolving database landscape
  16. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 29 Public Polyglot persistence
  17. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 30 Public What’s next? 1970s 1980s 1990s 2000s 2010s File systems Navigational DBs: Network Hierarchical RDBMS Desktop- based RDBMS SQL OODBMS Client-server i/o mainframes Relational model Web Mobile OOP Y2K! NoSQL IoT @sygyzmundovych
  18. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 31 Public „Neither fish nor fowl…”, Matthew Aslett, the451group.com https://blogs.the451group.com/information_management/2013/02/08/neither-fish-nor-fowl/
  19. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 32 Public Native multi-model @sygyzmundovych
  20. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 34 Public OrientDB @sygyzmundovych
  21. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 35 Public SHOW ME… @sygyzmundovych
  22. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 36 Public OrientDB - Index-free adjacency - Object-oriented - JSon Document (with links) - Graph - Schema-les/-full/-mix - ACID Transactions - Geospatial support - SQL interface @sygyzmundovych
  23. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 39 Public OrientDB at Udemy @sygyzmundovych
  24. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 41 Public The top 5 technologies the most companies are looking for technical skills in „…Database skills are important for both back-end and front-end developers so SQL stays in the second place. …” Devskiller Global Technical Hiring & Skills Report 2019 https://devskiller.com/technical-hiring-skills-report-2019/
  25. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 42 Public SAP HANA @sygyzmundovych
  26. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 43 Public The Forrester Wave™: Translytical Data Platforms, Q4 2017 “…Translytical data platforms, an emerging technology, deliver faster access to business data to support various workloads and use cases. EA pros can use them to drive new business initiatives…” source: https://reprints.forrester.com/#/assets/2/308/'RES134282'/reports “SAP crushes translytical workloads. SAP HANA is a shared-nothing, in-memory data platform, the core of SAP's translytical platform, which supports many use cases, including real- time applications, analytics, translytical apps, systems of insight, and advanced analytics…” @sygyzmundovych
  27. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 44 Public SAP HANA, Express edition developers.sap.com/sap-hana-express • targeted to run in resource-constrained environments and contains a rich set of capabilities for a developer to work with, including geospatial data types and algorithms • free productive use up to 32 GB of RAM, • comes as a binary installer, as a pre-configured virtual machine image (ova file), as a docker or cloud image Database management Web server JavaScript Graphic modeler Data virtualization Extract, load, transform and replication Columnar store – Transaction and analytical processing Multicore and parallelization Advanced compression Multitenancy Multitier storage Graph Predictive Search Series data Business functions Apache Hadoop and Apache Spark integration Streaming analytics Application lifecycle management High availability and disaster recovery Openness Data modeling Administration and security Spatial Text analytics SAP Fiori® user experience(UX) Application development Data integration and quality Advanced analytical processing Data quality Remote data sync @sygyzmundovych
  28. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 45 Public I SAID…
  29. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 46 Public All demos were taken from SAP Community blog https://people.sap.com/vitaliy.rudnytskiy#content:blogposts • Geospatial Tuesday • Graph Thursday https://people.sap.com/serban.petrescu#content:blogposts Understanding Containers: https://blogs.sap.com/tag/understandcontainers/ @sygyzmundovych
  30. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 47 Public SAP HANA - Relational, but from NewDB movement: - In-memory - Columnar (+ Row-based) - High compression - Multi-core built-in - Advanced text and search processing - Geospatial support - JSon Document store - Graph processing - Time series @sygyzmundovych
  31. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 48 Public openSAP course (archived): Full-Text Search with SAP HANA Platform Course Characteristics Duration: 4 weeks (4-5 hours in total) Course Content Unit 1: The Basics: Full-Text Indexing Unit 2: Matching: Fuzzy Search and Search Rules Unit 3: Search Models: Using Core Data Services Unit 4: API and Query Language: Using ESH_SEARCH Unit 5: User Interface: The SAPUI5 Search UI Unit 6: SAP Business Suite and SAP S/4HANA: SAP HANA Enterprise Search Unit 7: Beyond Search: SAP HANA File Processing and SAP HANA Graph https://open.sap.com/courses/hsesh1 @sygyzmundovych
  32. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 49 Public openSAP course (archived): Spatial Analysis with SAP HANA Course Characteristics Duration: 3 weeks (4-6 hours per week) Course Content Week 1: Introduction to SAP HANA Spatial Week 2: Spatial Analysis Week 3: Development of Spatial Applications Week 4: Final Exam https://open.sap.com/courses/hsgs1 @sygyzmundovych
  33. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. 50 Public openSAP course (archived): Analyzing Connected Data with SAP HANA Graph Course Characteristics Duration: 4 weeks (4-5 hours in total) Course Content Unit 1: Connected Data and SAP HANA Graph Unit 2: The Basics: Nodes, Edges, and Workspaces Unit 3: Pattern Matching Unit 4: Built-In Algorithms Unit 5: GraphScript Unit 6: SAP HANA Hierarchies Unit 7: Beyond Graph: Full-Text Search and Spatial https://open.sap.com/courses/hsgra1 @sygyzmundovych
  34. © 2014 SAP SE or an SAP affiliate company. All

    rights reserved. @sygyzmundovych Vitaliy Rudnytskiy Thank you! Danke! Dzięki! Дякую! Merci! http://bit.ly/MultiModelDBs