Database query generation for project task management system for managing project schedules over a network
First Claim
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 is defined in a class package associated with said particular editor of said project schedule system;
wherein said particular query string contains one or more database commands and 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 the project schedule system;
examining the particular query string to identify the one or more placeholder strings contained therein;
generating a database query by automatically replacing said one or more placeholder strings in said particular query string with respective replacement strings;
submitting said database query with the respective replacement strings to the project schedule system for processing; and
returning results of processing the database query in response to said request.
1 Assignment
0 Petitions
Accused Products
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.
57 Citations
18 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 is defined in a class package associated with said particular editor of said project schedule system;
wherein said particular query string contains one or more database commands and 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 the project schedule system;examining the particular query string to identify the one or more placeholder strings contained therein; generating a database query by automatically replacing said one or more placeholder strings in said particular query string with respective replacement strings; submitting said database query with the respective replacement strings to the project schedule system for processing; and returning results of processing the database query in response to said request. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. 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, wherein said particular query string is defined in a class package associated with said particular editor of said project schedule system, wherein the particular query string contains one or more database commands; assigning said particular query string to a variable string; determining whether said particular query string contains any placeholder strings indicating with what type of replacement string a respective placeholder string is replaced to generate a database query for submission to the project schedule system; if said particular query string does not contain any placeholder strings, then submitting said particular query string to the project schedule system; returning results of said particular query string in response to said request; 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 replacement strings; submitting said database query to said database; and returning results of said database query in response to said request.
-
-
10. A computer-readable storage medium for automatic generation of database queries in a network based project schedule system comprising a database, the computer-readable storage medium carrying instructions which, when processed by one or more processors, causes:
-
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 of the project schedule system, wherein said particular query string is defined in a class package associated with said particular editor of said project schedule system;
wherein said particular query string contains one or more database commands and 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 the project schedule system;examining the particular query string to identify the one or more placeholder strings contained therein; generating a database query by automatically replacing said one or more placeholder strings in said particular query string with respective replacement strings; submitting said database query with the respective replacement strings to the project schedule system for processing; and returning results of processing the database query in response to said request. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17)
-
-
18. A computer-readable storage medium for automatic generation of database queries in a network based project schedule system, the computer-readable storage medium carrying instructions which, when processed by one or more processors, causes:
-
in response to a request, identifying a particular query string associated with a particular editor of the project schedule system with which said request is associated, wherein the particular query string contains one or more database commands; assigning said particular query string to a variable string; determining whether said particular query string contains any placeholder strings indicating with what type of replacement string a respective placeholder string is replaced to generate a database query for submission to the project schedule system; if said particular query string does not contain any placeholder strings, then submitting said particular query string to the project schedule system; returning results of said particular query string in response to said request; 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 replacement strings; submitting said database query to said database; and returning results of said database query in response to said request.
-
Specification