公开(公告)号：US11562022B2

公开(公告)日：2023-01-24

申请号：US17193496

申请日：2021-03-05

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Jagannathan Srinivasan ,  Juan Francisco Garcia Navarro ,  Victor Antonio Lopez Villamar ,  Matthew Steven Perry ,  Souripriya Das ,  Zhe Wu

IPC: G06F16/838 ,  G06F16/81 ,  G06F16/80 ,  G06F16/901

Abstract: Embodiments use successive refinement to allow a user to systematically explore the result set of an arbitrary query over RDF, such as a SPARQL query. A user inputs an arbitrary base query and modifies this query by replacing selected variables with values to which each selected variable is bound within the result set of the base query. Embodiments present, via a GUI, variable facets that may be substituted for query variables. Embodiments also present, through a GUI, a query history graph that represents query versions that a user has created. A user may navigate this query history graph to return to previously-created query versions. The GUI also provides information about the facets, including a number of results that would be included in the result set of the query version resulting from substitution of the facet for the associated variable.

公开(公告)号：US10984042B2

公开(公告)日：2021-04-20

申请号：US15652044

申请日：2017-07-17

Applicant: Oracle International Corporation

Inventor： Jagannathan Srinivasan ,  Jayanta Banerjee ,  Vinh Thi Kim Nguyen

IPC: G06F16/80 ,  G06F16/951 ,  G06F16/9535

Abstract: A method, system, and computer program product for transforming RDF quads to relational views. The method commences by receiving a named graph, the named graph comprising at least one RDF quad, and analyzing the named graph to produce analysis metadata. The method uses the analysis metadata to generate relational views. The method further comprises publishing a relational view in the form of a SPARQL query. The quality of the results can be quantitatively measured and reported by calculating a goodness score based at least in part on aspects of the relational view definitions. Several variants for transformation include generating relational view definitions formed using a named-graph strict variant, or a named-graph relaxed variant, or a named-graph agnostic variant. The transformations can form outputs responsive to characteristics or properties such as a number of classes, a number of single-valued properties, a number of nullability properties, or a number of type-uniformed ranges.

公开(公告)号：US20170098009A1

公开(公告)日：2017-04-06

申请号：US15059864

申请日：2016-03-03

Applicant: Oracle International Corporation

Inventor： Jagannathan Srinivasan ,  Juan Francisco Garcia Navarro ,  Victor Antonio Lopez Villamar ,  Matthew Steven Perry ,  Souripriya Das ,  Zhe Wu

IPC: G06F17/30

CPC classification number: G06F16/838 ,  G06F16/80 ,  G06F16/81 ,  G06F16/9024

Abstract: Embodiments use successive refinement to allow a user to systematically explore the result set of an arbitrary query over RDF, such as a SPARQL query. A user inputs an arbitrary base query and modifies this query by replacing selected variables with values to which each selected variable is bound within the result set of the base query. Embodiments present, via a GUI, variable facets that may be substituted for query variables. Embodiments also present, through a GUI, a query history graph that represents query versions that a user has created. A user may navigate this query history graph to return to previously-created query versions. The GUI also provides information about the facets, including a number of results that would be included in the result set of the query version resulting from substitution of the facet for the associated variable.

公开(公告)号：US20210191980A1

公开(公告)日：2021-06-24

申请号：US17193496

申请日：2021-03-05

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Jagannathan Srinivasan ,  Juan Francisco Garcia Navarro ,  Victor Antonio Lopez Villamar ,  Matthew Steven Perry ,  Souripriya Das ,  Zhe Wu

IPC: G06F16/838 ,  G06F16/81 ,  G06F16/80 ,  G06F16/901

Abstract: Embodiments use successive refinement to allow a user to systematically explore the result set of an arbitrary query over RDF, such as a SPARQL query. A user inputs an arbitrary base query and modifies this query by replacing selected variables with values to which each selected variable is bound within the result set of the base query. Embodiments present, via a GUI, variable facets that may be substituted for query variables. Embodiments also present, through a GUI, a query history graph that represents query versions that a user has created. A user may navigate this query history graph to return to previously-created query versions. The GUI also provides information about the facets, including a number of results that would be included in the result set of the query version resulting from substitution of the facet for the associated variable.

公开(公告)号：US09785725B2

公开(公告)日：2017-10-10

申请号：US14498709

申请日：2014-09-26

Applicant: Oracle International Corporation

Inventor： Jagannathan Srinivasan ,  Souripriya Das ,  Matthew Steven Perry ,  Juan Francisco Garcia Navarro ,  Victor Antonio Lopez Villamar

IPC: G06F17/30

CPC classification number: G06F17/30958 ,  G06F17/30554

Abstract: Systems and methods for visualizing relational data as RDF graphs in order to explore connections between data in the relational schema. The relational data is first converted into an initial RDF graph. Referential constraints between tables in the relational data, including unasserted referential constraints and pseudo-referential constraints, are automatically detected and used to augment the RDF graph. In addition, datatype properties in the RDF graph may be folded into annotation objects for better visualization. The resulting graph may be an edge-node graph, with edges corresponding to referential constraints between nodes corresponding to relational table rows.

公开(公告)号：US09710568B2

公开(公告)日：2017-07-18

申请号：US13753329

申请日：2013-01-29

Applicant: Oracle International Corporation

Inventor： Jagannathan Srinivasan ,  Jayanta Banerjee ,  Vinh Thi Kim Nguyen

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30908 ,  G06F17/30864 ,  G06F17/30867

Abstract: A method, system, and computer program product for transforming RDF quads to relational views. The method commences by receiving a named graph, the named graph comprising at least one RDF quad, and analyzing the named graph to produce analysis metadata. The method uses the analysis metadata to generate relational views. The method further comprises publishing a relational view in the form of a SPARQL query. The quality of the results can be quantitatively measured and reported by calculating a goodness score based at least in part on aspects of the relational view definitions. Several variants for transformation include generating relational view definitions formed using a named-graph strict variant, or a named-graph relaxed variant, or a named-graph agnostic variant. The transformations can form outputs responsive to characteristics or properties such as a number of classes, a number of single-valued properties, a number of nullability properties, or a number of type-uniformed ranges.

公开(公告)号：US10984043B2

公开(公告)日：2021-04-20

申请号：US15059864

申请日：2016-03-03

Applicant: Oracle International Corporation

Inventor： Jagannathan Srinivasan ,  Juan Francisco Garcia Navarro ,  Victor Antonio Lopez Villamar ,  Matthew Steven Perry ,  Souripriya Das ,  Zhe Wu

IPC: G06F16/838 ,  G06F16/81 ,  G06F16/80 ,  G06F16/901

Abstract: Embodiments use successive refinement to allow a user to systematically explore the result set of an arbitrary query over RDF, such as a SPARQL query. A user inputs an arbitrary base query and modifies this query by replacing selected variables with values to which each selected variable is bound within the result set of the base query. Embodiments present, via a GUI, variable facets that may be substituted for query variables. Embodiments also present, through a GUI, a query history graph that represents query versions that a user has created. A user may navigate this query history graph to return to previously-created query versions. The GUI also provides information about the facets, including a number of results that would be included in the result set of the query version resulting from substitution of the facet for the associated variable.