- 1. Home
- 2. Introduction
❱
- 2.1. Overview of OrientDB
❱
- 2.1.1. Editions
- 2.2. Release 3.2
❱
- 2.2.1. What's new in OrientDB 3.2?
- 2.2.2. Available Packages
- 2.2.3. SQL Changes
- 2.2.4. API Changes
- 2.2.5. Known Issues
- 2.2.6. Upgrading to OrientDB 3.2
- 2.3. How to Report Bugs or Problems
- 2.4. How to Get in Touch with OrientDB
- 2.5. How to Contribute to OrientDB
- 2.6. OrientDB Roadmap
- 3. OrientDB in Five Minutes
❱
- 3.1. Install
- 3.2. Create a DB
- 3.3. Create the Java Application
- 3.4. Connect to the DB and create the Schema
- 3.5. Create your First Graph and Run Queries
- 4. Getting Started
❱
- 4.1. Installation
- 4.2. Run the server
- 4.3. Run the console
- 4.4. Run the Studio
- 4.5. Documents, Vertices and Edges
- 4.6. Classes, Schema and Constraints
- 4.7. Demo Database
❱
- 4.7.1. Introduction
- 4.7.2. Data Model
- 4.7.3. Queries
❱
- 4.7.3.1. Profiles
- 4.7.3.2. Friendship
- 4.7.3.3. Customers
- 4.7.3.4. Countries
- 4.7.3.5. Orders
- 4.7.3.6. Attractions
- 4.7.3.7. Services
- 4.7.3.8. Locations
- 4.7.3.9. Reviews
- 4.7.3.10. Recommendations
- 4.7.3.11. Business Opportunities
- 4.7.3.12. Polymorphism
- 4.7.3.13. Shortest Paths
- 4.7.3.14. Traverses
- 4.7.4. Graph Portions
- 4.8. Basic SQL
- 4.9. Users, Roles and Security
- 4.10. Distributed Architecture
- 4.11. Tutorials
❱
- 4.11.1. Working with Graphs
- 4.11.2. Using Schema with Graphs
- 4.11.3. Setup a Distributed Database
- 4.11.4. Working with Distributed Graphs
- 4.11.5. Time Series
- 4.11.6. Chat
- 4.11.7. Key Value
- 4.11.8. Queue system
- 4.11.9. Import Tutorials
❱
- 4.11.9.1. Importing the Open Beer Database into OrientDB
- 5. General Information
❱
- 5.1. Supported Types
- 5.2. Schema
- 5.3. Inheritance
- 5.4. Concurrency
- 5.5. Indexing
❱
- 5.5.1. SB-Tree
- 5.5.2. Hash
- 5.5.3. Auto-Sharding
- 5.5.4. Full Text
- 5.5.5. Lucene Full Text
- 5.5.6. Lucene Spatial Index
- 5.6. Managing Dates
- 5.7. Transactions
- 5.8. Embedding the Server
- 5.9. Available OrientDB Plugins
❱
- 5.9.1. Automatic Backup
- 5.9.2. SysLog
- 5.9.3. Mail
- 5.9.4. JMX
- 5.9.5. Rexster
- 5.9.6. Gephi Graph Render
- 5.9.7. spider-box
- 5.9.8. 3rd Party Plugins
- 6. Data Modeling
❱
- 6.1. Multi Tenant
- 6.2. Basic Concepts
- 7. OrientDB Programs
❱
- 7.1. OrientDB Server-Startup Programs
❱
- 7.1.1. server.sh
- 7.1.2. dserver.sh
- 7.1.3. Server Process
- 7.2. OrientDB Client Programs
❱
- 7.2.1. Console
❱
- 7.2.1.1. Console Modes
- 7.2.1.2. Console Commands
❱
- 7.2.1.2.1. Backup
- 7.2.1.2.2. Browse Class
- 7.2.1.2.3. Browse Cluster
- 7.2.1.2.4. List Classes
- 7.2.1.2.5. Cluster Status
- 7.2.1.2.6. List Clusters
- 7.2.1.2.7. List Servers
- 7.2.1.2.8. List Server Users
- 7.2.1.2.9. Check Database
- 7.2.1.2.10. Config
- 7.2.1.2.11. Config Get
- 7.2.1.2.12. Config Set
- 7.2.1.2.13. Connect
- 7.2.1.2.14. Connect Env
- 7.2.1.2.15. Create Database
- 7.2.1.2.16. Declare Intent
- 7.2.1.2.17. Dictionary Get
- 7.2.1.2.18. Dictionary Keys
- 7.2.1.2.19. Dictionary Put
- 7.2.1.2.20. Dictionary Remove
- 7.2.1.2.21. Disconnect
- 7.2.1.2.22. Display Record
- 7.2.1.2.23. Display Raw Record
- 7.2.1.2.24. Drop Database
- 7.2.1.2.25. Drop Server User
- 7.2.1.2.26. Export Database
- 7.2.1.2.27. Export Record
- 7.2.1.2.28. Freeze DB
- 7.2.1.2.29. Get
- 7.2.1.2.30. Import Database
- 7.2.1.2.31. Indexes
- 7.2.1.2.32. Info
- 7.2.1.2.33. Info Class
- 7.2.1.2.34. Info Property
- 7.2.1.2.35. Js
- 7.2.1.2.36. Jss
- 7.2.1.2.37. List Databases
- 7.2.1.2.38. List Connections
- 7.2.1.2.39. Load Record
- 7.2.1.2.40. Load Script
- 7.2.1.2.41. Open
- 7.2.1.2.42. Profiler
- 7.2.1.2.43. Properties
- 7.2.1.2.44. Release DB
- 7.2.1.2.45. Reload Record
- 7.2.1.2.46. Repair Database
- 7.2.1.2.47. Restore
- 7.2.1.2.48. Set
- 7.2.1.2.49. Set Server User
- 7.3. OrientDB Administrative and Utility Programs
❱
- 7.3.1. backup
- 7.3.2. shutdown
- 7.3.3. stresstester
- 7.4. OrientDB Data Import Programs
❱
- 7.4.1. oetl
- 8. OrientDB Server Administration
❱
- 8.1. Installation
❱
- 8.1.1. Prerequisites
- 8.1.2. Installation from Source
- 8.1.3. Install as Service on Unix
- 8.1.4. Install as Service on Windows
- 8.1.5. Install with Docker
- 8.2. Configuration
- 8.3. Upgrade
❱
- 8.3.1. Backward Compatibility
- 8.3.2. Upgrading a Distributed Environment
- 8.4. Logs
- 8.5. Event Scheduler
- 8.6. Functions
❱
- 8.6.1. Creating Functions
- 8.6.2. Using Functions
- 8.6.3. Accessing the Database
- 8.6.4. Server-side Functions
- 8.7. Backup and Restore
❱
- 8.7.1. Incremental Backup and Restore
- 8.8. Export and Import
❱
- 8.8.1. Export to & Import from JSON
❱
- 8.8.1.1. Export format
- 8.8.2. Import From RDBMS
❱
- 8.8.2.1. To Document Model
- 8.8.2.2. To Graph Model
- 8.8.3. Import From Neo4j
❱
- 8.8.3.1. Import from Neo4j using GraphML
- 8.9. Monitoring
❱
- 8.9.1. JMX
- 9. OrientDB Tools
❱
- 9.1. Studio
❱
- 9.1.1. Overview of Menus and Panels
- 9.1.2. Working with Databases
❱
- 9.1.2.1. Common Database Operations
- 9.1.2.2. Database Management Panel
- 9.1.3. Working with Data
❱
- 9.1.3.1. Browse Panel
❱
- 9.1.3.1.1. Querying Data
- 9.1.3.1.2. Modifying Data
❱
- 9.1.3.1.2.1. Edit Document
- 9.1.3.1.2.2. Edit Vertex
- 9.1.3.1.2.3. Edit Edge
- 9.1.3.2. Graph Editor
- 9.1.4. Working with Schemas
❱
- 9.1.4.1. Schema Manager Panel
- 9.1.4.2. Classes
- 9.1.4.3. Properties
- 9.1.4.4. Indexes
- 9.1.5. Working with Functions
❱
- 9.1.5.1. Functions Management Panel
- 9.1.6. Working with Users and Roles
❱
- 9.1.6.1. Security Manager Panel
- 9.1.6.2. Users Management
- 9.1.6.3. Roles Management
- 9.2. Server-Level Commands
❱
- 9.2.1. CREATE DATABASE
- 9.2.2. DROP DATABASE
- 9.2.3. CREATE SYSTEM USER
- 9.2.4. ALTER SYSTEM ROLE
- 9.2.5. EXISTS SYSTEM USER
- 9.3. ETL
❱
- 9.3.1. Configuration
- 9.3.2. Blocks
- 9.3.3. Sources
- 9.3.4. Extractors
- 9.3.5. Transformers
- 9.3.6. Loaders
- 9.3.7. Import from CSV to a Graph
- 9.3.8. Import a tree structure
- 9.3.9. Import from JSON
- 9.3.10. Import from RDBMS
- 9.3.11. Import from DB-Pedia
- 9.3.12. Import from Parse (Facebook)
- 10. SQL Reference
❱
- 10.1. Introduction
❱
- 10.1.1. Querying Metadata
- 10.2. SQL Syntax
❱
- 10.2.1. Projections
- 10.3. SQL Commands
❱
- 10.3.1. Alter Class
- 10.3.2. Alter Cluster
- 10.3.3. Alter Database
- 10.3.4. Alter Property
- 10.3.5. Alter Security Policy
- 10.3.6. Alter Sequence
- 10.3.7. Create Class
- 10.3.8. Create Cluster
- 10.3.9. Create Edge
- 10.3.10. Create Function
- 10.3.11. Create Index
- 10.3.12. Create Link
- 10.3.13. Create Property
- 10.3.14. Create Security Policy
- 10.3.15. Create Sequence
- 10.3.16. Create User
- 10.3.17. Create Vertex
- 10.3.18. Create View
- 10.3.19. Delete
- 10.3.20. Delete Edge
- 10.3.21. Delete Vertex
- 10.3.22. Drop Class
- 10.3.23. Drop Cluster
- 10.3.24. Drop Index
- 10.3.25. Drop Property
- 10.3.26. Drop Sequence
- 10.3.27. Drop User
- 10.3.28. Drop View
- 10.3.29. Explain
- 10.3.30. Find References
- 10.3.31. Grant
- 10.3.32. HA Remove Server
- 10.3.33. HA Status
- 10.3.34. HA Sync Cluster
- 10.3.35. HA Sync Database
- 10.3.36. HA Set
- 10.3.37. Insert
- 10.3.38. Live Select
- 10.3.39. Live Unsubscribe
- 10.3.40. Match
- 10.3.41. Move Vertex
- 10.3.42. Optimize Database
- 10.3.43. Profile
- 10.3.44. Rebuild Index
- 10.3.45. Revoke
- 10.3.46. Select
- 10.3.47. Traverse
- 10.3.48. Truncate Class
- 10.3.49. Truncate Cluster
- 10.3.50. Truncate Record
- 10.3.51. Update
- 10.3.52. Update Edge
- 10.4. Filtering
- 10.5. Functions
- 10.6. Methods
- 10.7. Batch
- 10.8. Pagination
- 10.9. Sequences and auto increment
- 10.10. Pivoting with Query
- 10.11. Command Cache
- 11. APIs and Drivers
❱
- 11.1. Java API
❱
- 11.1.1. Java Multi-Model API
❱
- 11.1.1.1. Database creation and connection
- 11.1.1.2. Manipulating data in Java
- 11.1.1.3. Running SQL statements Java
- 11.1.1.4. Defining Database Schema
❱
- 11.1.1.4.1. Classes
- 11.1.1.4.2. Property
- 11.1.1.5. Lightweight Edges
- 11.1.2. Apache TinkerPop 3
- 11.1.3. Document API
❱
- 11.1.3.1. Documents
- 11.1.4. Live Query
❱
- 11.1.4.1. Live Query Intro
- 11.1.4.2. Live Query vs Traditional Query
- 11.1.4.3. Live Query in Java
- 11.1.5. Object API
❱
- 11.1.5.1. Database
- 11.1.5.2. POJO
- 11.1.5.3. Attach
- 11.1.5.4. Schema
- 11.1.5.5. Binding
- 11.1.6. Traverse
- 11.1.7. Multi-Threading
❱
- 11.1.7.1. Usage
- 11.1.7.2. Concurrency Control
- 11.1.8. Transactions
- 11.1.9. Fetching Strategies
- 11.1.10. Binary Data
- 11.1.11. JPA
- 11.2. JDBC Driver
- 11.3. Scala API
- 11.4. OrientJS Legacy - Node.js Driver
❱
- 11.4.1. Server API
- 11.4.2. Database API
- 11.4.3. Record API
- 11.4.4. Class API
❱
- 11.4.4.1. Class
- 11.4.4.2. Property
- 11.4.4.3. Records
- 11.4.5. Index API
- 11.4.6. Function API
- 11.4.7. Queries
❱
- 11.4.7.1. create()
- 11.4.7.2. delete()
- 11.4.7.3. fetch()
- 11.4.7.4. insert()
- 11.4.7.5. liveQuery()
- 11.4.7.6. select()
- 11.4.7.7. transform()
- 11.4.7.8. traverse()
- 11.4.7.9. update()
- 11.4.8. Transactions
- 11.4.9. Events
- 11.5. OrientJS - Node.js Driver
❱
- 11.5.1. Reference
❱
- 11.5.1.1. Client API
- 11.5.1.2. Session API
- 11.6. PyOrient - Python Driver
❱
- 11.6.1. Client
❱
- 11.6.1.1. command()
- 11.6.1.2. batch()
- 11.6.1.3. data_cluster_add()
- 11.6.1.4. data_cluster_count()
- 11.6.1.5. data_cluster_data_range()
- 11.6.1.6. data_cluster_drop()
- 11.6.1.7. db_count_records()
- 11.6.1.8. db_create()
- 11.6.1.9. db_drop()
- 11.6.1.10. db_exists()
- 11.6.1.11. db_list()
- 11.6.1.12. db_open()
- 11.6.1.13. db_reload()
- 11.6.1.14. db_size()
- 11.6.1.15. get_session_token()
- 11.6.1.16. query()
- 11.6.1.17. query_async()
- 11.6.1.18. record_create()
- 11.6.1.19. record_delete()
- 11.6.1.20. record_load()
- 11.6.1.21. record_update()
- 11.6.1.22. set_session_token()
- 11.6.1.23. tx_commit()
❱
- 11.6.1.23.1. attach()
- 11.6.1.23.2. begin()
- 11.6.1.23.3. commit()
- 11.6.1.23.4. rollback()
- 11.6.2. OGM
❱
- 11.6.2.1. Connection
- 11.6.2.2. Schemas
- 11.6.2.3. Brokers
- 11.6.2.4. Batch
- 11.6.2.5. Scripts
- 11.7. OrientDB-NET - C#/.NET Driver
❱
- 11.7.1. Server
❱
- 11.7.1.1. ConfigGet()
- 11.7.1.2. ConfigList()
- 11.7.1.3. ConfigSet()
- 11.7.1.4. CreateDatabase()
- 11.7.1.5. DatabaseExists()
- 11.7.1.6. Databases()
- 11.7.1.7. DropDatabase()
- 11.7.2. Database
❱
- 11.7.2.1. Clusters()
- 11.7.2.2. Command()
- 11.7.2.3. GetClusterIdFor()
- 11.7.2.4. GetClusterNameFor()
- 11.7.2.5. GetClusters()
- 11.7.2.6. Gremlin()
- 11.7.2.7. Insert()
- 11.7.2.8. JavaScript()
- 11.7.2.9. Query()
- 11.7.2.10. Select()
- 11.7.2.11. SqlBatch()
- 11.7.2.12. Update()
- 11.7.3. Query
❱
- 11.7.3.1. Conditionals
- 11.7.3.2. Limiters
- 11.7.3.3. Sort
- 11.7.4. Transaction
❱
- 11.7.4.1. Add()
- 11.7.4.2. AddEdge()
- 11.7.4.3. AddOrUpdate()
- 11.7.4.4. Delete()
- 11.7.4.5. GetPendingObject()
- 11.7.4.6. Update()
- 11.8. PhpOrient - PHP Driver
❱
- 11.8.1. Client
- 11.8.2. Server
❱
- 11.8.2.1. dbCreate()
- 11.8.2.2. dbDrop()
- 11.8.2.3. dbExists()
- 11.8.2.4. dbList()
- 11.8.3. Database
❱
- 11.8.3.1. command()
- 11.8.3.2. dataClusterAdd()
- 11.8.3.3. dataClusterCount()
- 11.8.3.4. dataClusterDrop()
- 11.8.3.5. dataClusterDataRange()
- 11.8.3.6. dbCountRecords()
- 11.8.3.7. dbReload()
- 11.8.3.8. dbSize()
- 11.8.3.9. query()
- 11.8.3.10. queryAsync()
- 11.8.3.11. recordCreate()
- 11.8.3.12. recordLoad()
- 11.8.3.13. recordUpdate()
- 11.8.3.14. sqlBatch()
- 11.8.4. ClusterMap
❱
- 11.8.4.1. dropClusterID()
- 11.8.4.2. getClusterID()
- 11.8.4.3. getIdList()
- 11.8.5. Record
❱
- 11.8.5.1. getOClass()
- 11.8.5.2. getOData()
- 11.8.5.3. getRid()
- 11.8.5.4. jsonSerialize()
- 11.8.5.5. recordSerialize()
- 11.8.5.6. setOClass()
- 11.8.5.7. setOData()
- 11.8.5.8. setRid()
- 11.8.6. ID
- 11.8.7. Transaction
❱
- 11.8.7.1. attach()
- 11.8.7.2. begin()
- 11.8.7.3. commit()
- 11.8.7.4. rollback()
- 11.9. MarcoPolo - Elixir Driver
❱
- 11.9.1. Server
❱
- 11.9.1.1. create_db()
- 11.9.1.2. db_exists?()
- 11.9.1.3. distrib-config()
- 11.9.1.4. drop_db()
- 11.9.2. Database
❱
- 11.9.2.1. command()
- 11.9.2.2. create_record()
- 11.9.2.3. db_countrecords()
- 11.9.2.4. db_reload()
- 11.9.2.5. db_size()
- 11.9.2.6. delete_record()
- 11.9.2.7. live_query()
- 11.9.2.8. live_query_unsubscribe()
- 11.9.2.9. load_record()
- 11.9.2.10. script()
- 11.9.2.11. update_record()
- 11.9.3. Types
- 11.9.4. Structs
❱
- 11.9.4.1. BinaryRecord
- 11.9.4.2. Date
- 11.9.4.3. DateTime
- 11.9.4.4. Document
- 11.9.4.5. FetchPlan
- 11.9.4.6. RID
- 11.10. Javascript (legacy)
❱
- 11.10.1. Javascript API
- 11.11. Rest API
- 11.12. Gremlin API
- 12. Security
❱
- 12.1. OrientDB Security Guide
- 12.2. OrientDB Data Protection and Privacy
- 12.3. Database security
- 12.4. Server security
- 12.5. Database encryption
- 12.6. Secure SSL connections
- 12.7. Security Configuration
- 12.8. Kerberos Example
- 12.9. Security v2.2 Code Changes
- 12.10. Security v2.2 New Features
- 12.11. Symmetric Key Authentication
- 13. Distributed Architecture
❱
- 13.1. Lifecycle
- 13.2. Configuration
❱
- 13.2.1. Server Manager
- 13.2.2. Runtime Configuration
- 13.3. Replication
- 13.4. Sharding
- 13.5. Data Centers
- 14. Troubleshooting
❱
- 14.1. Java
- 14.2. Memory Leak Detector
- 14.3. Direct Memory Tracing
- 15. Performance Tuning
❱
- 15.1. Tuning the Graph API
- 15.2. Tuning the Document API
- 15.3. Tuning the Object API
- 15.4. Profiler
- 15.5. Distributed Configuration Tuning
- 15.6. OrientDB Stress Test Tool
- 16. Enterprise Edition
❱
- 16.1. Dashboard
- 16.2. Server Management
- 16.3. Cluster Management
- 16.4. Backup Management
- 16.5. Server Profiler
- 16.6. Security
- 16.7. Teleporter
- 16.8. Neo4j Importer
- 16.9. Metrics
- 16.10. Auditing
- 16.11. Settings
- 17. Internals
❱
- 17.1. System database
- 17.2. Storages
❱
- 17.2.1. Memory storage
- 17.2.2. PLocal storage
❱
- 17.2.2.1. Engine
- 17.2.2.2. Disk-Cache
- 17.2.2.3. WAL (Journal)
- 17.2.3. Local storage (deprecated)
- 17.3. Clusters
- 17.4. Limits
- 17.5. RidBag
- 17.6. Custom Index Engine
- 17.7. Caching
- 17.8. Hooks - Triggers
❱
- 17.8.1. Dynamic Hooks
- 17.8.2. Java (Native) Hooks
- 17.9. Server
❱
- 17.9.1. Server Status
- 17.10. Web Server
- 17.11. Binary Protocol
❱
- 17.11.1. CSV Serialization
- 17.11.2. Schemaless Serialization
- 17.11.3. Commands
- 18. Release Notes