1 / 13

OrientDB

This presentation gives an overview of the OrientDB database project. It explains OrientDB in terms of it's functionality, its indexing and architecture. It examines the ETL functionality as well as the UI available. <br> <br>Links for further information and connecting<br><br>http://www.amazon.com/Michael-Frampton/e/B00NIQDOOM/<br><br>https://nz.linkedin.com/pub/mike-frampton/20/630/385<br><br>https://open-source-systems.blogspot.com/

semtechs
Télécharger la présentation

OrientDB

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What Is Apache OrientDB ? ● A NoSQL database ● Uses a multi model approach – supports models – Graph, document, key/value, object – Reactive, Geospatial ● Open source Apache 2.0 license ● Offers scaleability / high performance ● Supports polyglot persistence i.e. – The idea that different kinds of data benefit – From being stored in different formats

  2. What Is Apache OrientDB ? ● Offered from orientdb.com as – Community and enterprise editions ●Supports use of Tinkerpop 2.x and 3.x ● Has multi-master and sharded architecture ● Offers Gremlin and extended SQL interfaces ● Supports ACID transactions ● Offers record level security ● Supports schema-full, schema-less, schema mix ● Written in Java

  3. OrientDB Indexes ● SB-Tree Index – Default, durable, transactional and supports range queries ● Hash Index – Fast lookup, light on disk usage, no range queries ● Auto Sharding Index – Durable and transactional, no range queries ● Lucene Full Text Index – Durable and transactional, text only, supports range queries ● Lucene Spatial Index – Durable and transactional, spatial only, supports range queries

  4. OrientDB Studio ● Run Queries, edit graphs ● Manage schemas, security management ● Manage databases, servers + cluster ( enterprise edn ) ● Query profiler ( enterprise edn ) ● Query audit logs ( enterprise edn ) ● Backup management ( enterprise edn )

  5. OrientDB Studio

  6. OrientDB Integration ● Uses ETL tool ( JSON cfg ) for data import ● Compatible with most RDBMS with a JDBC driver – Tested Oracle, SQLServer, MySQL, PostgreSQL, HyperSQL ● Has an Apache Spark connector (2.2.7+) ● Has a Neo4j importer – Uses Neo4j Java API to extract graph – Uses OrientDB Java API to import graph

  7. OrientDB Backups ● Possible to export database in JSON format but – No locking so possibly not an exact replica ● Backups lock database and create an exact replica – Database in read only mode – Concurrent writes blocked ● Distributed cluster allows ( during backup ) – Read / write – Snapshots

  8. OrientDB Cluster ● Supports a distributed architecture ● Uses HazelCast for auto discovery of nodes ● Has a multi-master system ● Supports REPLICA nodes ( read only ) ● Records can be created in distributed mode ● Supports distributed transactions ● Cannot import DB in distributed mode

  9. OrientDB Teleporter ● Uses JDBC to import RDBMS database ● Enterprise version has a synchronisation function ● Tested Oracle, SQLServer, MySQL, PostgreSQL, HyperSQL ● Execution involves – Source DB Schema Building – Graph Model Building – OrientDB Schema Writing – OrientDB importing ● Default admin, reader, writer accounts created

  10. OrientDB Teleporter

  11. OrientDB API Stack

  12. Available Books ● See “Big Data Made Easy” Apress Jan 2015 – See “Mastering Apache Spark” ● Packt Oct 2015 – See “Complete Guide to Open Source Big Data Stack ● “Apress Jan 2018” – ● Find the author on Amazon www.amazon.com/Michael-Frampton/e/B00NIQDOOM/ – Connect on LinkedIn ● www.linkedin.com/in/mike-frampton-38563020 –

  13. Connect ● Feel free to connect on LinkedIn –www.linkedin.com/in/mike-frampton-38563020 ● See my open source blog at open-source-systems.blogspot.com/ – ● I am always interested in – New technology – Opportunities – Technology based issues – Big data integration

More Related