Graph database

In the mid-1960s, navigational databases such as IBM's IMS supported tree-like structures in its hierarchical model, but the strict tree structure could be circumvented with virtual records.{{cite book |last=Silberschatz |first=Avi |date=28 January 2010 |title=Database System Concepts, Sixth Edition |url=http://codex.cs.yale.edu/avi/db-book/db6/appendices-dir/e.pdf |publisher=McGraw-Hill |page=E-20 |isbn=978-0-07-352332-3}}{{cite web |url=http://www.people.vcu.edu/~lparker/IMS.html |title=IMS Notes |last1=Parker |first1=Lorraine |website=vcu.edu |access-date=31 May 2016}}

Graph structures could be represented in network model databases from the late 1960s. CODASYL, which had defined COBOL in 1959, defined the Network Database Language in 1969.

Labeled graphs could be represented in graph databases from the mid-1980s, such as the Logical Data Model.{{cite journal|last1=Angles|first1=Renzo|last2=Gutierrez|first2=Claudio|date=1 Feb 2008|title=Survey of graph database models|url=http://www.cse.iitk.ac.in/users/smitr/PhD%20Resources/Survey%20of%20Graph%20Databases%20Models.pdf|url-status=dead|journal=ACM Computing Surveys|volume=40|issue=1|pages=1–39|citeseerx=10.1.1.110.1072|doi=10.1145/1322432.1322433|archive-url=https://web.archive.org/web/20170815064527/https://www.cse.iitk.ac.in/users/smitr/PhD%20Resources/Survey%20of%20Graph%20Databases%20Models.pdf|archive-date=15 August 2017|access-date=28 May 2016|quote=network models [...] lack a good abstraction level: it is difficult to separate the db-model from the actual implementation|s2cid=207166126}}{{cite thesis |last=Kuper |first=Gabriel M. |date=1985 |title=The Logical Data Model: A New Approach to Database Logic |type=Ph.D. |docket=STAN-CS-85-1069 |url=http://apps.dtic.mil/dtic/tr/fulltext/u2/a323935.pdf |archive-url=https://web.archive.org/web/20160630154240/http://www.dtic.mil/dtic/tr/fulltext/u2/a323935.pdf |url-status=live |archive-date=June 30, 2016 |access-date=31 May 2016}}

Commercial object databases (ODBMSs) emerged in the early 1990s. In 2000, the Object Data Management Group published a standard language for defining object and relationship (graph) structures in their ODMG'93 publication.

Several improvements to graph databases appeared in the early 1990s, accelerating in the late 1990s with endeavors to index web pages.

In the mid-to-late 2000s, commercial graph databases with ACID guarantees such as Neo4j and Oracle Spatial and Graph became available.

In the 2010s, commercial ACID graph databases that could be scaled horizontally became available. Further, SAP HANA brought in-memory and columnar technologies to graph databases.{{cite web|url=http://www.dbta.com/Editorial/News-Flashes/SAP-Announces-New-Capabilities-in-the-Cloud-with-HANA-100186.aspx|title=SAP Announces New Capabilities in the Cloud with HANA|date=2014-10-22|access-date=2016-07-07}} Also in the 2010s, multi-model databases that supported graph models (and other models such as relational database or document-oriented database) became available, such as OrientDB, ArangoDB, and MarkLogic (starting with its 7.0 version). During this time, graph databases of various types have become especially popular with social network analysis with the advent of social media companies. Also during the decade, cloud-based graph databases such as Amazon Neptune and Neo4j AuraDB became available.

Graph databases portray the data as it is viewed conceptually. This is accomplished by transferring the data into nodes and its relationships into edges.

A graph database is a database that is based on graph theory. It consists of a set of objects, which can be a node or an edge.

• Nodes represent entities or instances such as people, businesses, accounts, or any other item to be tracked. They are roughly the equivalent of a record, relation, or row in a relational database, or a document in a document-store database.
• Edges, also termed graphs or relationships, are the lines that connect nodes to other nodes; representing the relationship between them. Meaningful patterns emerge when examining the connections and interconnections of nodes, properties and edges. The edges can either be directed or undirected. In an undirected graph, an edge connecting two nodes has a single meaning. In a directed graph, the edges connecting two different nodes have different meanings, depending on their direction. Edges are the key concept in graph databases, representing an abstraction that is not directly implemented in a relational model or a document-store model.
• Properties are information associated to nodes. For example, if Wikipedia were one of the nodes, it might be tied to properties such as website, reference material, or words that starts with the letter w, depending on which aspects of Wikipedia are germane to a given database.

File:GraphDatabase PropertyGraph.svg

A labeled-property graph model is represented by a set of nodes, relationships, properties, and labels. Both nodes of data and their relationships are named and can store properties represented by key–value pairs. Nodes can be labelled to be grouped. The edges representing the relationships have two qualities: they always have a start node and an end node, and are directed;{{cite web|url=http://www.dataversity.net/property-graphs-swiss-army-knife-data-modeling/|title=Property Graphs|last=Frisendal|first=Thomas|date=2017-09-22|website=graphdatamodeling.com|access-date=2018-10-23}} making the graph a directed graph. Relationships can also have properties. This is useful in providing additional metadata and semantics to relationships of the nodes.{{cite journal|last1=Das|first1=S|last2=Srinivasan|first2=J|last3=Perry|first3=Matthew|last4=Chong|first4=Eugene|last5=Banerjee|first5=Jay|date=2014-03-24|title=A Tale of Two Graphs: Property Graphs as RDF in Oracle|url=https://www.researchgate.net/publication/264702160}} Direct storage of relationships allows a constant-time traversal.{{cite journal|last1=Have|first1=Christian Theil|last2=Jensen|first2=Lars Juhl|date=2013-10-17|title=Are graph databases ready for bioinformatics?|journal=Bioinformatics|volume=29|issue=24|pages=3107–3108|doi=10.1093/bioinformatics/btt549|issn=1460-2059|pmc=3842757|pmid=24135261}}

{{main|RDF (computer science)}}

File:Rdf-graph3.png

In an RDF graph model, each addition of information is represented with a separate node. For example, imagine a scenario where a user has to add a name property for a person represented as a distinct node in the graph. In a labeled-property graph model, this would be done with an addition of a name property into the node of the person. However, in an RDF, the user has to add a separate node called hasName connecting it to the original person node. Specifically, an RDF graph model is composed of nodes and arcs. An RDF graph notation or a statement is represented by: a node for the subject, a node for the object, and an arc for the predicate. A node may be left blank, a literal and/or be identified by a URI. An arc may also be identified by a URI. A literal for a node may be of two types: plain (untyped) and typed. A plain literal has a lexical form and optionally a language tag. A typed literal is made up of a string with a URI that identifies a particular datatype. A blank node may be used to accurately illustrate the state of the data when the data does not have a URI.{{cite web|url=https://www.w3.org/TR/rdf-concepts/#section-Overview|title=Resource Description Framework (RDF): Concepts and Abstract Syntax|website=www.w3.org|access-date=2018-10-24}}

Graph databases are a powerful tool for graph-like queries. For example, computing the shortest path between two nodes in the graph. Other graph-like queries can be performed over a graph database in a natural way (for example graph's diameter computations or community detection).

Graphs are flexible, meaning it allows the user to insert new data into the existing graph without loss of application functionality. There is no need for the designer of the database to plan out extensive details of the database's future use cases.

The underlying storage mechanism of graph databases can vary. Some depend on a relational engine and "store" the graph data in a table (although a table is a logical element, therefore this approach imposes another level of abstraction between the graph database, the graph database management system and the physical devices where the data is actually stored). Others use a key–value store or document-oriented database for storage, making them inherently NoSQL structures. A node would be represented as any other document store, but edges that link two different nodes hold special attributes inside its document; a _from and _to attributes.

Data lookup performance is dependent on the access speed from one particular node to another. Because index-free adjacency enforces the nodes to have direct physical RAM addresses and physically point to other adjacent nodes, it results in a fast retrieval. A native graph system with index-free adjacency does not have to move through any other type of data structures to find links between the nodes. Directly related nodes in a graph are stored in the cache once one of the nodes are retrieved, making the data lookup even faster than the first time a user fetches a node. However, such advantage comes at a cost. Index-free adjacency sacrifices the efficiency of queries that do not use graph traversals. Native graph databases use index-free adjacency to process CRUD operations on the stored data.

Multiple categories of graphs by kind of data have been recognised. Gartner suggests the five broad categories of graphs:{{cite web|url=https://www.gartner.com/doc/2081316/competitive-dynamics-consumer-web-graphs|title=The Competitive Dynamics of the Consumer Web: Five Graphs Deliver a Sustainable Advantage|website=www.gartner.com|access-date=2018-10-23}}

• Social graph: this is about the connections between people; examples include Facebook, Twitter, and the idea of six degrees of separation
• Intent graph: this deals with reasoning and motivation.
• Consumption graph: also known as the "payment graph", the consumption graph is heavily used in the retail industry. E-commerce companies such as Amazon, eBay and Walmart use consumption graphs to track the consumption of individual customers.
• Interest graph: this maps a person's interests and is often complemented by a social graph. It has the potential to follow the previous revolution of web organization by mapping the web by interest rather than indexing webpages.
• Mobile graph: this is built from mobile data. Mobile data in the future may include data from the web, applications, digital wallets, GPS, and Internet of Things (IoT) devices.

Since Edgar F. Codd's 1970 paper on the relational model,{{cite journal|last=Codd|first=E. F.|date=1970-06-01|title=A relational model of data for large shared data banks|journal=Communications of the ACM|volume=13|issue=6|pages=377–387|doi=10.1145/362384.362685|s2cid=207549016|issn=0001-0782|doi-access=free}} relational databases have been the de facto industry standard for large-scale data storage systems. Relational models require a strict schema and data normalization which separates data into many tables and removes any duplicate data within the database. Data is normalized in order to preserve data consistency and support ACID transactions. However this imposes limitations on how relationships can be queried.

One of the relational model's design motivations was to achieve a fast row-by-row access. Problems arise when there is a need to form complex relationships between the stored data. Although relationships can be analyzed with the relational model, complex queries performing many join operations on many different attributes over several tables are required. In working with relational models, foreign key constraints should also be considered when retrieving relationships, causing additional overhead.

Compared with relational databases, graph databases are often faster for associative data sets{{Citation needed|date=August 2013}} and map more directly to the structure of object-oriented applications. They can scale more naturally{{Citation needed|date=August 2017}} to large datasets as they do not typically need join operations, which can often be expensive. As they depend less on a rigid schema, they are marketed as more suitable to manage ad hoc and changing data with evolving schemas.

Conversely, relational database management systems are typically faster at performing the same operation on large numbers of data elements, permitting the manipulation of the data in its natural structure. Despite the graph databases' advantages and recent popularity over {{Citation needed|date=May 2021}} relational databases, it is recommended the graph model itself should not be the sole reason to replace an existing relational database. A graph database may become relevant if there is an evidence for performance improvement by orders of magnitude and lower latency.{{cite news|url=https://www.safaribooksonline.com/library/view/graph-databases-2nd/9781491930885/|title=Graph Databases, 2nd Edition|work=O’Reilly {{!}} Safari|access-date=2018-10-23}}

The relational model gathers data together using information in the data. For example, one might look for all the "users" whose phone number contains the area code "311". This would be done by searching selected datastores, or tables, looking in the selected phone number fields for the string "311". This can be a time-consuming process in large tables, so relational databases offer indexes, which allow data to be stored in a smaller sub-table, containing only the selected data and a unique key (or primary key) of the record. If the phone numbers are indexed, the same search would occur in the smaller index table, gathering the keys of matching records, and then looking in the main data table for the records with those keys. Usually, a table is stored in a way that allows a lookup via a key to be very fast.{{cite web|url=http://neo4j.com/developer/graph-db-vs-rdbms/#_from_relational_to_graph_databases|title=From Relational to Graph Databases|website=Neo4j}}

Relational databases do not inherently contain the idea of fixed relationships between records. Instead, related data is linked to each other by storing one record's unique key in another record's data. For example, a table containing email addresses for users might hold a data item called userpk, which contains the primary key of the user record it is associated with. In order to link users and their email addresses, the system first looks up the selected user records primary keys, looks for those keys in the userpk column in the email table (or, more likely, an index of them), extracts the email data, and then links the user and email records to make composite records containing all the selected data. This operation, termed a join, can be computationally expensive. Depending on the complexity of the query, the number of joins, and indexing various keys, the system may have to search through multiple tables and indexes and then sort it all to match it together.

In contrast, graph databases directly store the relationships between records. Instead of an email address being found by looking up its user's key in the userpk column, the user record contains a pointer that directly refers to the email address record. That is, having selected a user, the pointer can be followed directly to the email records, there is no need to search the email table to find the matching records. This can eliminate the costly join operations. For example, if one searches for all of the email addresses for users in area code "311", the engine would first perform a conventional search to find the users in "311", but then retrieve the email addresses by following the links found in those records. A relational database would first find all the users in "311", extract a list of the primary keys, perform another search for any records in the email table with those primary keys, and link the matching records together. For these types of common operations, graph databases would theoretically be faster.

The true value of the graph approach becomes evident when one performs searches that are more than one level deep. For example, consider a search for users who have "subscribers" (a table linking users to other users) in the "311" area code. In this case a relational database has to first search for all the users with an area code in "311", then search the subscribers table for any of those users, and then finally search the users table to retrieve the matching users. In contrast, a graph database would search for all the users in "311", then follow the backlinks through the subscriber relationship to find the subscriber users. This avoids several searches, look-ups, and the memory usage involved in holding all of the temporary data from multiple records needed to construct the output. In terms of big O notation, this query would be $O(\backslash log\; n)\; +\; O(1)$ time – i.e., proportional to the logarithm of the size of the data. In contrast, the relational version would be multiple $O(\backslash log\; n)$ lookups, plus the $O(n)$ time needed to join all of the data records.

The relative advantage of graph retrieval grows with the complexity of a query. For example, one might want to know "that movie about submarines with the actor who was in that movie with that other actor that played the lead in Gone With the Wind". This first requires the system to find the actors in Gone With the Wind, find all the movies they were in, find all the actors in all of those movies who were not the lead in Gone With the Wind, and then find all of the movies they were in, finally filtering that list to those with descriptions containing "submarine". In a relational database, this would require several separate searches through the movies and actors tables, doing another search on submarine movies, finding all the actors in those movies, and then comparing the (large) collected results. In contrast, the graph database would walk from Gone With the Wind to Clark Gable, gather the links to the movies he has been in, gather the links out of those movies to other actors, and then follow the links out of those actors back to the list of movies. The resulting list of movies can then be searched for "submarine". All of this can be done via one search.{{citation|title=Examples where Graph databases shine: Neo4j edition|url=https://zeroturnaround.com/rebellabs/examples-where-graph-databases-shine-neo4j-edition/2/|website=ZeroTurnaround}}

Properties add another layer of abstraction to this structure that also improves many common queries. Properties are essentially labels that can be applied to any record, or in some cases, edges as well. For example, one might label Clark Gable as "actor", which would then allow the system to quickly find all the records that are actors, as opposed to director or camera operator. If labels on edges are allowed, one could also label the relationship between Gone With the Wind and Clark Gable as "lead", and by performing a search on people that are "lead" "actor" in the movie Gone With the Wind, the database would produce Vivien Leigh, Olivia de Havilland and Clark Gable. The equivalent SQL query would have to rely on added data in the table linking people and movies, adding more complexity to the query syntax. These sorts of labels may improve search performance under certain circumstances, but are generally more useful in providing added semantic data for end users.

Relational databases are very well suited to flat data layouts, where relationships between data are only one or two levels deep. For example, an accounting database might need to look up all the line items for all the invoices for a given customer, a three-join query. Graph databases are aimed at datasets that contain many more links. They are especially well suited to social networking systems, where the "friends" relationship is essentially unbounded. These properties make graph databases naturally suited to types of searches that are increasingly common in online systems, and in big data environments. For this reason, graph databases are becoming very popular for large online systems like Facebook, Google, Twitter, and similar systems with deep links between records.

To further illustrate, imagine a relational model with two tables: a people table (which has a person_id and person_name column) and a friend table (with friend_id and person_id, which is a foreign key from the people table). In this case, searching for all of Jack's friends would result in the following SQL query.

SELECT p2.person_name

FROM people p1

JOIN friend ON (p1.person_id = friend.person_id)

JOIN people p2 ON (p2.person_id = friend.friend_id)

WHERE p1.person_name = 'Jack';

The same query may be translated into --

• Cypher, a graph database query language

MATCH (p1:person {name: 'Jack'})-[:FRIEND_WITH]-(p2:person)

RETURN p2.name

• SPARQL, an RDF graph database query language standardized by W3C and used in multiple RDF Triple and Quad stores
• Long form

PREFIX foaf:

SELECT ?name

WHERE { ?s a foaf:Person .

?s foaf:name "Jack" .

?s foaf:knows ?o .

?o foaf:name ?name .

}

• Short form

PREFIX foaf:

SELECT ?name

WHERE { ?s foaf:name "Jack" ;

foaf:knows ?o .

?o foaf:name ?name .

}

• SPASQL, a hybrid database query language, that extends SQL with SPARQL

SELECT people.name

FROM (

SPARQL PREFIX foaf:

SELECT ?name

WHERE { ?s foaf:name "Jack" ;

foaf:knows ?o .

?o foaf:name ?name .

}

) AS people ;

The above examples are a simple illustration of a basic relationship query. They condense the idea of relational models' query complexity that increases with the total amount of data. In comparison, a graph database query is easily able to sort through the relationship graph to present the results.

There are also results that indicate simple, condensed, and declarative queries of the graph databases do not necessarily provide good performance in comparison to the relational databases. While graph databases offer an intuitive representation of data, relational databases offer better results when set operations are needed.

The following is a list of notable graph databases:

• AQL (ArangoDB Query Language): a SQL-like query language used in ArangoDB for both documents and graphs
• Cypher Query Language (Cypher): a graph query declarative language for Neo4j that enables ad hoc and programmatic (SQL-like) access to the graph.{{cite web |url=http://sdtimes.com/guest-view-relational-vs-graph-databases-use/ |title=Guest View: Relational vs. graph databases: Which to use and when? |last1=Svensson |first1=Johan |date=5 July 2016 |website=San Diego Times |publisher=BZ Media |access-date=30 August 2016}}
• GQL: proposed ISO standard graph query language
• GraphQL: an open-source data query and manipulation language for APIs. Dgraph implements modified GraphQL language called DQL (formerly GraphQL+-)
• Gremlin: a graph programming language that is a part of Apache TinkerPop open-source project{{cite web|url=https://tinkerpop.apache.org/gremlin.html|title=Apache TinkerPop|last=TinkerPop|first=Apache|website=Apache TinkerPop|access-date=2016-11-02}}
• SPARQL: a query language for RDF databases that can retrieve and manipulate data stored in RDF format
• regular path queries, a theoretical language for queries on graph databases

• Graph transformation
• Hierarchical database model
• Datalog
• Vadalog
• Object database
• RDF Database
• Structured storage
• Text graph
• Wikidata is a Wikipedia sister project that stores data in a graph database. Ordinary web browsing allows for viewing nodes, following edges, and running SPARQL queries.

{{Reflist}}

{{Database models}}

Category:Database models