Transforming and evaluating missing values in graph databases
The disclosed embodiments provide a system for processing queries of a graph database. During operation, the system executes one or more processes for providing the graph database storing a graph, wherein the graph includes a set of nodes, a set of edges between pairs of nodes in the set of nodes, and a set of predicates. Next, the system receives a query containing a missing value parameter, wherein the missing value parameter designates an attribute in the graph database with a nonexistent value. The system then produces, from the query, a transformed query comprising one or more parameters that do not include the missing value parameter. Finally, the system uses the transformed query and the graph database to generate a result of the query and provides the result in a response to the query.
1. A method, comprising:
executing, on a computer system, one or more processes for providing a graph database storing a graph, wherein the graph comprises a set of nodes, a set of edges between pairs of nodes in the set of nodes, and a set of predicates;
receiving, by the one or more processes, a query comprising a missing value parameter, wherein the missing value parameter designates an attribute in the graph database with a nonexistent value; and
processing the query, by the one or more processes, by:
producing, from the query, a transformed query comprising one or more parameters that do not include the missing value parameter by generating the transformed query as a conjunction of one or more additional parameters from the query that do not contain the nonexistent value and a negation of the query;
using the transformed query and the graph database to generate a result of the query; and
providing the result in a response to the query.
2. The method of claim 1 , wherein using the transformed query and the graph database to generate the result of the query comprises:
when the query comprises a write query, writing the one or more additional parameters to the graph database after verifying that the negation does not match any records in the graph database.
3. The method of claim 1 , wherein using the transformed query and the graph database to generate the result of the query comprises:
when the query comprises a read query, including one or more records in the graph database that match the one or more parameters and satisfy the negation in the result.
4. The method of claim 1 , wherein the negation of the query comprises an unbounded value for the attribute.
5. The method of claim 1 , further comprising:
generating the query during implementation of an outer join in the graph database.
6. The method of claim 5 , further comprising:
generating an additional query with a different missing value parameter during implementation of the outer join; and
including the result of the query and an additional result of the additional query in a result set of the outer join.
7. The method of claim 1 , wherein the query is associated with at least of:
an edge; and
a schema comprising the edge.
8. The method of claim 1 , wherein the one or more parameters comprise:
a subject;
an object; and
a predicate.
9. The method of claim 8 , wherein the predicate is associated with at least one of:
a connection;
an employment;
a group membership;
a following of a company;
a following of a member;
a skill of the member;
an education of the member at a school; and
a location of the member.
10. The method of claim 8 , wherein the subject is at least one of:
a member;
a score;
a date;
an employer;
an employee;
a position;
a group;
a membership;
a follower;
a followee;
an attribute; and
a flag.
11. The method of claim 1 , wherein the result generated by using the transformed query and the graph database is consistent with a result generated by using the query and the graph database.
12. An apparatus, comprising:
one or more processors; and
memory storing instructions that, when executed by the one or more processors, cause the apparatus to:
execute one or more processes for providing a graph database storing a graph, wherein the graph comprises a set of nodes, a set of edges between pairs of nodes in the set of nodes, and a set of predicates;
receive a query comprising a missing value parameter, wherein the missing value parameter designates an attribute in the graph database with a nonexistent value;
produce, from the query, a transformed query comprising one or more parameters that do not include the missing value parameter by generating the transformed query as a conjunction of one or more additional parameters from the query that do not contain the nonexistent value and a negation of the query;
use the transformed query and the graph database to generate a result of the query; and
provide the result in a response to the query.
13. The apparatus of claim 12 , wherein using the transformed query and the graph database to generate the result of the query comprises:
when the query comprises a write query, writing the one or more additional parameters to the graph database after verifying that the negation does not match any records in the graph database.
14. The apparatus of claim 12 , wherein using the transformed query and the graph database to generate the result of the query comprises:
when the query comprises a read query, including one or more records in the graph database that match the one or more parameters and satisfy the negation in the result.
15. The apparatus of claim 12 , wherein the negation of the query comprises an unbounded value for the attribute.
16. The apparatus of claim 12 , wherein the memory further stores instructions that, when executed by the one or more processors, cause the apparatus to:
use a schema to generate the query and an additional query with a different missing value parameter during implementation of an outer join in the graph database; and
include the result of the query and an additional result of the additional query in a result set of the outer join.
17. The apparatus of claim 12 , wherein the result generated by using the transformed query and the graph database is consistent with a result generated by using the query and the graph database.
18. A system, comprising:
a graph database storing a graph, wherein the graph comprises a set of nodes, a set of edges between pairs of nodes in the set of nodes, and a set of predicates;
a transformation module comprising a non-transitory computer-readable medium comprising instructions that, when executed, cause the system to:
receive a query comprising a missing value parameter, wherein the missing value parameter designates an attribute in the graph database with a nonexistent value;
produce, from the query, a transformed query comprising one or more parameters that do not include the missing value parameter by generating the transformed query as a conjunction of one or more additional parameters from the query that do not contain the nonexistent value and a negation of the query; and
a query-processing module comprising a non-transitory computer-readable medium comprising instructions that, when executed, cause the system to:
use the transformed query and the graph database to generate a result of the query; and
provide the result in a response to the query.
19. The system of claim 18 , wherein the non-transitory computer-readable medium of the transformation module further comprises instructions that, when executed, cause the system to:
use a schema to generate the query and an additional query with a different missing value parameter during implementation of an outer join in the graph database; and
include the result of the query and an additional result of the additional query in a result set of the outer join.
20. The system of claim 18 , wherein the result generated by using the transformed query and the graph database is consistent with a result generated by using the query and the graph database.