Database query generation for project task management system for managing project schedules over a network

• US 20080228739A1
• Filed: 03/15/2007
• Published: 09/18/2008
• Est. Priority Date: 03/15/2007
• Status: Active Grant

• Current Assignee: Ricoh Company Limited
• Original Assignee: Ricoh Company Limited
• Inventors: Motoyama, Tetsuro, Fong, Avery
• Granted Patent: US 7,668,800 B2
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: Y10S 707/947 Human resources
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A client-server based project schedule management system comprises multiple editors accessible through a web browser to perform various scheduling tasks by members of a project. Client-executable code is generated by the server for the client, which is passed to the client along with schedule-related information for populating the respective editors. The client executes the server-generated code to display the respective editor with pertinent information populated therein, and to manage and maintain any new or updated information in response to user interactions with the editor. Rows of tasks are represented by corresponding objects, where editor elements are object attributes which are directly accessible by the respective objects. Database queries are generated by the server based on constant strings containing placeholders which are replaced with information used by the query.

Claims

1. A computer-implemented method for automatic generation of database queries in a network based project schedule system comprising a database, the method comprising:

in response to a request associated with a particular editor of said project schedule system, locating a particular query string associated with said particular editor;

wherein said particular query string contains one or more placeholder strings and wherein each placeholder string indicates with what type of value said placeholder string is replaced to generate a database query for submission to said database;

generating a database query by automatically replacing said one or more placeholder strings in said particular query string with respective values;

submitting said database query to said database; and

returning results of said database query in response to said request.

2. The method of claim 1, further comprising:

assigning said particular query string to a variable string to allow replacement of said one or more placeholder strings with said respective values.

3. The method of claim 1, further comprising:

searching for placeholder strings in said particular query string based on execution of a set of one or more constant strings.

4. The method of claim 3, wherein automatically replacing said one or more placeholder strings comprises identifying said respective values based on execution of said set of one or more constant strings.

5. The method of claim 1, wherein said particular query string is defined in a class package associated with said particular editor of said project schedule system.

6. The method of claim 1, wherein generating a database query comprises generating said database query by execution of a private function of a database interface object class associated with said particular editor of said project schedule system.

7. The method of claim 6, further comprising:

obtaining said respective values from a user via said particular editor.

8. The method of claim 6, further comprising:

obtaining said respective values from said database.

9. The method of claim 1, wherein generating a database query comprises generating said database query by execution of a public function of a database query generator object class associated with said particular editor of said project schedule system.

12. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 1.

13. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 2.

14. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 3.

15. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 4.

16. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 5.

17. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 6.

18. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 7.

19. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 8.

20. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 9.

10. A computer-implemented method for automatic generation of database queries in a network based project schedule system comprising a database, the method comprising:

in response to a request, identifying a particular query string associated with a particular editor with which said request is associated;

assigning said particular query string to a variable string;

determining whether said particular query string contains any placeholder strings indicating with what type of value a respective placeholder string is replaced to generate a database query for submission to said database;

if said particular query string does not contain any placeholder strings, then submitting said particular query string to said database; and

returning results of said particular query string in response to said request.

11. The method of claim 10, further comprising:

if said particular query string contains one or more placeholder strings, then generating a database query for submission to said database by automatically replacing said one or more placeholder strings in said particular query string with respective values;

submitting said database query to said database; and

returning results of said database query in response to said request.

21. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 10.

22. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 11.