US 10,372,760 B2Granted

Building queries directed to objects hosted on clouds

AssigneeOracle International Corporation

InventorsNarayana Murthy Pedapudi, Kurien Kurien Kannukuzhiyil, Anuj Kaushal

Life of this patent

Estimating the term…

Loading patent…

Abstract

According to an aspect of the present disclosure, a query builder sends to a node in a cloud, a request for meta-data related to objects, and in response receives from the node, the meta-data specifying information related to objects exposed by the node. Upon receiving from a user a partial query and a current edit location during building of a corresponding complete query, the query builder determines, based on the received meta-data, the current edit location, and the partial query, a list of identifiers which are potential candidates for insertion at the current edit location. The query builder then displays the list of identifiers to the user, and receives a selection of an identifier from the displayed list. The query builder incorporates the selected identifier in the partial query at the current edit location to form a further developed query.

Claims20

Dependent claims

A method of facilitating building of queries directed to objects hosted on various nodes provided in a cloud, said method being implemented in a client system, said method comprising:

receiving, in said client system, from a user a first locator of a first node exposing objects based on which a complete query is to be built and thereafter executed, said first locator specifying an address at which said first node is accessible, said first node being contained in a plurality of nodes in said cloud;
after receiving of said first locator, sending over a network from said client system to said first node in said cloud, a first request for meta-data related to objects;
receiving, in said client system, from said first node a first meta-data specifying information related to objects exposed by said first node,
wherein said first meta-data is received in response to said sending of said first request, wherein said first meta-data comprises a plurality of identifiers, wherein each identifier is associated with a corresponding type of a plurality of types, said plurality of types comprising an object, an attribute of an object, and a relationship of an object with another object;
receiving, in said client system, from said user a partial query and a current edit location during building of said complete query;
determining, in said client system, a list of identifiers of said plurality of identifiers which are potential candidates for insertion at said current edit location, wherein said determining comprises identifying based on a syntax of said queries and said current edit location a suitable type of said plurality of types, wherein said list of identifiers comprise said plurality of identifiers associated with said suitable type;
sending for display said list of identifiers;
receiving, in said client system, selection of a first identifier of said list of identifiers;
and
incorporating said first identifier in said partial query at said current edit location to form a further developed query as a part of said complete query,
wherein said complete query is directed to objects exposed by said first node and therefore suitable for execution on said first node,
whereby said user can generate queries directed to different nodes of interest provided in said cloud by specifying the corresponding address at which the corresponding node is accessible.

9 more elements

A non-transitory machine readable medium storing one or more sequences of instructions for enabling a client system to facilitate building of queries directed to objects hosted on a cloud, wherein execution of said one or more instructions by one or more processors contained in said client system enables said client system to perform the actions of:

sending from said client system to a first node in said cloud, a first request for meta-data related to objects;
receiving in said client system, from said first node a first meta-data specifying information related to objects exposed by said first node, wherein said first meta-data comprises a plurality of identifiers,
wherein said first meta-data is received in response to said sending of said first request, wherein each identifier is associated with a corresponding type of a plurality of types, said plurality of types comprising an object, an attribute of an object, and a relationship of an object with another object;
receiving, in said client system, from a user a partial query and a current edit location during building of a corresponding complete query;
determining, in said client system, a list of identifiers of said plurality of identifiers which are potential candidates for insertion at said current edit location, wherein said determining comprises identifying based on a syntax of said queries and said current edit location a suitable type of said plurality of types, wherein said list of identifiers comprise said plurality of identifiers associated with said suitable type;
sending for display said list of identifiers;
receiving, in said client system, selection of a first identifier of said list of identifiers;
and
incorporating said first identifier in said partial query at said current edit location to form a further developed query,
wherein said complete query is directed to objects exposed by said first node and therefore suitable for execution on said first node,
whereby said user can generate queries directed to different nodes of interest provided in said cloud by specifying the corresponding address at which the corresponding node is accessible.

8 more elements

A computing system comprising:

a plurality of nodes forming a cloud;
a client system comprising at least one processor and a memory, said client system performing the actions of:
receiving from a user a first locator of a first node exposing objects based on which a complete query is to be built and thereafter executed, said first locator specifying an address at which said first node is accessible, said first node being contained in a plurality of nodes in said cloud;
after receiving of said first locator, sending to a first node in said cloud, a first request for meta-data related to objects;
receiving from said first node a first meta-data specifying information related to objects exposed by said first node,
wherein said first meta-data is received in response to said sending of said first request, wherein said first meta-data comprises a plurality of identifiers, wherein each identifier is associated with a corresponding type of a plurality of types, said plurality of types comprising an object, an attribute of an object, and a relationship of an object with another object;
receiving from a user a partial query and a current edit location during building of a corresponding complete query;
determining a list of identifiers of said plurality of identifiers which are potential candidates for insertion at said current edit location, wherein said determining comprises identifying based on a syntax of said queries and said current edit location a suitable type of said plurality of types, wherein said list of identifiers comprise said plurality of identifiers associated with said suitable type;
sending for display said list of identifiers;
receiving selection of a first identifier of said list of identifiers;
and
incorporating said first identifier in said partial query at said current edit location to form a further developed query,
wherein said complete query is directed to objects exposed by said first node and therefore suitable for execution on said first node,
whereby said user can generate queries directed to different nodes of interest provided in said cloud by specifying the corresponding address at which the corresponding node is accessible.

11 more elements

Dependencies are inferred from the claim text.