Techniques for integrating parameterized information request into a system for collaborative work

• US 8,805,879 B2
• Filed: 03/11/2009
• Issued: 08/12/2014
• Est. Priority Date: 03/11/2008
• Status: Active Grant

• Current Assignee: Virtualagility Incorporated
• Original Assignee: Virtualagility Incorporated
• Inventors: Kelley, Kevin, Moran, Gideon, Phan, Hung, Phan, Nhat, Rudolph, Stuart
• Primary Examiner(s): VU, BAI DUC
• Application Number:
  US12/921,744
• Publication Number:
  US 20110004621A1
• Time in Patent Office: 1,980 Days
• Field of Search: None
• US Class Current: 707/779
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

Techniques used in a system for collaborative work which gives collaborators unskilled in data processing technologies access to a variety of information resources to provide the collaborators with information resources which are obtained in response to parameterized information requests such as queries. The techniques use records in database tables to represent a class of parameterized information requests. Information for instances of the class includes queries that may be used in the instances and default values for bind parameters in the queries. Values for the bind parameters may also be specified for classes of user interfaces that employ the information sources returned by the parameterized information requests and for instances of the user interface. A user may also use specify values for bind parameters in his or her instance of the user interface.

Claims

1. Apparatus for specifying a class of parameterized information requests and making instances of parameterized information requests that belong to the class, the apparatus being implemented in a system having a processor and data storage accessible to the processor and the apparatus comprising:

objects in the data storage including a connector object in the data storage that represents the class of parameterized information requests;

a request parameter object in the data storage that defines a request parameter for parameterized information requests belonging to the class, the request parameter comprising a bind parameter that is replaced by a bind value before the requested parameter is used in an instance of a parameterized information request; and

an information source access object in the data storage that specifies attributes of an information source which will receive the instances of the parameterized information requests that belong to the class, the processor responding to an input specifying creation of an instance of the class of parameterized information requests represented by the connector object by using the request parameter defined in the request parameter object and the attributes of the source of information to make the instance of the class.

2. The apparatus set forth in claim 1 wherein:

the request parameter object defines a plurality of request parameters;

the input further specifies a request parameter of the plurality of request parameters; and

the processor further responds to the input by using the specified request parameter to make the instance of the class.

3. The apparatus set forth in claim 1 wherein the apparatus further comprises:

a bind parameter object in the data storage that specifies the bind value for the bind parameter; and

the processor further uses the bind value specified for the bind parameter in making the instance of the class.

4. The apparatus set forth in claim 3 wherein:

the bind parameter object specifies a default value for the bind value.

5. The apparatus set forth in claim 3 wherein:

the bind parameter object specifies a first overriding value for the bind value which is employed in a user interface which belongs to a particular class that uses the connector object and which overrides a default value for the bind value.

6. The apparatus set forth in claim 5 wherein:

the bind parameter object specifies a second overriding value for the bind value which is employed in a particular instance of the user interface and which overrides both the default value and any first overriding value.

7. The apparatus set forth in claim 6 wherein:

the first overriding value is provided by the particular instance of the user interface.

8. The apparatus set forth in claim 3, further comprising:

a bind parameter object in the data storage that is associated with the request parameter and specifies a value for the bind parameter in the request parameter; and

the processor further uses the bind value specified for the bind parameter in the request parameter in making the instance of the class when the input specifies the particular request parameter.

9. The apparatus set forth in claim 8 wherein:

the bind value specified for the bind parameter is provided by an instance of a user interface which uses the connector object.

10. The apparatus set forth in claim 1 wherein the processor provides the instance of the parameterized information request to the information source specified in the information source access object and receives a response from the source of information and the apparatus further comprises:

a response processing object in the data storage that specifies how the response resulting from the instance is to be processed and the processor processes the response as specified by the response processing object.

11. The apparatus set forth in claim 1 wherein:

the request parameter is a query that is interpreted by the information source.

12. The apparatus set forth in claim 1 wherein:

the data storage is a relational database system accessible to the processor; and

the objects are rows in tables of the relational database system.

13. A system for providing a user with a graphical user interface, the graphical user interface permitting specification of an information resource belonging to one of a plurality of different kinds of information resources and the system responding to the specification by providing the information resource to the user, the system being implemented using a processor that produces and responds to inputs from the graphical user interface and has access to the information resource and to a storage device, the system comprising:

a specification in the graphical user interface of an information resource that is obtained using an instance of a parameterized information request and objects in the storage device including a connector object in the storage device that represents a class of the parameterized information requests to which the instance belongs;

a request parameter object in the storage that defines a request parameter for parameterized information requests belonging to the class, the request parameter comprising a bind parameter that is replaced by a bind value before the request parameter is used in the instance of the parameterized information request; and

an information source access object in the storage device that specifies attributes of the information, the processor responding to the specification by using the request parameter defined in the request parameter object and the attributes of the source of information to make the instance.

14. A graphical user interface for specifying a class of parameterized information requests, the graphical user interface being implemented using a processor that produces and responds to inputs from the graphical user interface and has access to a storage device, the class of parameterized information requests being specified by objects in the storage device, the objects including a connector object that represents the class of the parameterized information requests, a request parameter object that defines a request parameter for parameterized information requests belonging to the class, and an information source access object that specifies attributes of an information source which will receive instances of the parameterized information request belonging to the class, and the graphical user interface comprising:

a connector specification interface for specifying the connector object that represents the class of parameterized information requests;

a request parameter specification interface for specifying a request parameter for parameterized information requests belonging to the class, the request parameter comprising a bind parameter that is replaced by a bind value before the request parameter is used in an instance of a parameterized information request; and

an information source access specification interface that specifies the attributes of the information source, the processor responding to the connector specification interface by producing the connector object, to the request parameter specification interface by producing the request parameter object for the request parameter and to the information source access object specification interface by producing the information source access object for the attributes of the information source.

15. The graphical user interface for specifying the class of parameterized information requests set forth in claim 14 wherein the objects in the storage device further include a template object that makes instances of parameterized information requests belonging to the class represented by the connector object available to a class of graphical user interfaces, the graphical user interfaces in the class including a specifier for an information resource that is returned by an instance of the class of parameterized information requests and the graphical user interface further comprises:

a request parameter mapping interface that maps the request parameter to the template object and the processor responds to the request parameter mapping interface by mapping the request parameter object to the template object.