Platform independent on-line project management tool

• US 7,069,511 B2
• Filed: 12/19/1996
• Issued: 06/27/2006
• Est. Priority Date: 12/19/1996
• Status: Expired due to Fees

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Maritzen, Lynn Michael, Dimaandal, Rolando D.
• Primary Examiner(s): BAUTISTA, XIOMARA L
• Application Number:
  US08/769,404
• Publication Number:
  US 20030107587A1
• Time in Patent Office: 3,477 Days
• Field of Search: 345/326, 345329-332, 345/346, 345/357, 345/336, 345/978, 345/968, 345/971, 345/705, 345/733, 345/751, 345/753, 345/759, 345/776, 345/804, 345/854, 707/10, 707/104, 709/201, 709203-205, 709/219
• US Class Current: 715/733
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

A platform- and browser-independent project tracking tool is described for tracking projects of interest to a large number of organizations connected via a wide area network. This project tracking tool includes a database server for managing project information and data, and a graphical user interface server for interacting with users in the interested organization. The graphical user interfaces are created such that they can be accessed over the wide area network using web browsers.

Claims

1. A system for sharing data over a wide area data network, comprising:

a database for including therein said shared data;

a database server, having read and write access to said database, for receiving read and write access requests for said database over said wide area data network; and

a graphical user interface server providing graphical user interfaces to allow user access to said shared data, said graphical user interfaces being generated at the time of said user access, each comprising a set of methods specific to said shared data and associated with user-selectable icons provided to allow users to interact with said database server via web browsers, said database server being located on a different computer system than said web browsers, said methods generating said read and write requests to access said shared data in response to user selection of said icons during said user access, wherein a user associates an object corresponding to at least one of said graphical user interfaces with at least one of said methods to handle an event.

2. A system as in claim 1, wherein said database is a project tracking data base.

3. A system as in claim 1, wherein said graphical user interface server generates said graphical user interfaces using applets.

4. The method of claim 3, wherein the generated graphical user interfaces allow a user to query the database server for data relating to one or more projects.

5. The method of claim 3, wherein the generated graphical user interfaces comprise text boxes for creating or editing data retrieved from the database server.

6. The method of claim 3, wherein at least one of the generated graphical user interfaces provides a list including names of one or more projects.

7. The method of claim 6, wherein selecting a name from said list displays a graphical user interface comprising plurality of data fields, each field configured to provide information about various aspects of a project.

8. A method for tracking projects over a wide area data network, comprising the steps of:

providing a project database for including therein data pertinent to said projects;

providing a database server, having read and write access to said database, for receiving read and write access requests for said database over said wide area data network; and

providing a graphical user interface server to generate graphical user interfaces at the time a user accesses said data, said graphical user interfaces each comprising a set of methods specific to said data and associated with user-selectable icons, said graphical user interfaces being provided for user interactions with said database server via web browsers, said database server being located on a different computer system than said web browsers, said methods generating said read and write requests to access said data in response to said icons being selected by a user during said user access, wherein a user associates an object corresponding to at least one of said graphical user interfaces with at least one of said methods to handle an event.

9. A method as in claim 8, wherein said project database stores for each project a record indicating a scope of the project, and according to said scope a number of documentation and review requirements to be met.

10. A method as in claim 9, further comprising the step of updating said project database as each documentation and review requirements is met.

11. A method as in claim 10, wherein said step of updating is achieved using a web browser on a client computer interacting with said graphical user interface server across said wide area data network through said graphical user interfaces.

12. A method as in claim 9, wherein in said record for each of said project, each of said documentation and review requirements is provided as a written description.

13. A method as in claim 8, wherein said graphical interfaces are managed by applets.

14. A web-based project management system comprising:

a graphical user interface (GUI) server in communication with a database server managing project information;

wherein, in response to a user browsing a web page associated with the GUI server, the GUI server provides one or more graphical user interfaces comprising one or more GUI objects;

wherein the GUI server in response to user interaction with the one or more GUI objects communicates with the database server to access or edit the project information based on user-supplied methods associated with each said one or more GUI objects; and

wherein said database server is located on a different computer system than a user computer system and a user associates an object corresponding to at least one of said graphical user interfaces with at least one of said methods to handle an event.

15. The system of claim 14, wherein user-supplied methods are included in one or more programs segments capable of execution on the GUI server for providing the one or more graphical user interfaces, wherein based on the user-supplied methods the one or more program segments translate user interaction with each said one or more GUI objects to one or more requests submitted to the database server.

16. The system of claim 15, wherein the GUI server communicates with the database server through a communication interface that can interpret the submitted requests.

17. The system of claim 16, wherein the GUI server communicates with the database server through a communication socket.

18. The system of claim 17, wherein code capable of execution on the database server establishes an input-output stream with the communication interface so the submitted requests are transmitted to the communication interface via the input-output stream.

19. The system of claim 18, wherein the communication interface interprets the submitted requests so that the requests can be serviced by the database server.

20. The system of claim 19, wherein in response to the submitted requests the database server services the requests and communicates back with the GUI server by way of the communication interface.

21. The system of claim 15, wherein said one or more requests are submitted in the form of a database query language.

22. The system of claim 21, wherein the database language is SQL.

23. The system of claim 15, wherein the one or more program segments are java applets.

24. The system of claim 14, wherein the user-supplied methods are separately written code for action methods for handling events that result from user interaction with the GUI objects.

25. A method of managing data stored in a database, the method comprising:

instantiating a database server object to promote data communication between a graphical user interface (GUI) server and a database server that manages data stored in a database;

opening a communication socket between the database server and the GUI server; and

instantiating a connection object by the database server object for calling a communication interface program that provides for communication of data between the database server and the GUI server;

associating an object corresponding to at least a graphical user interface provided by the GUI server with a method to handle an event,

wherein in response to a request submitted by the GUI server via the socket, the connection object constructs an input/output data stream for transmitting the submitted request to the communication interface; and

wherein said database server is located on a different computer system than a user computer system.

26. The method of claim 25, wherein the communication interface forwards the request to the database server, the method further comprising:

servicing the submitted request.

27. The method of claim 26, further comprising:

providing a reply to the connection object when the request is serviced.

28. The method of claim 27, further comprising:

invoking program code on the GUI server to provide a user interface comprising one or more GUI objects, wherein the GUI server in response to user interaction with the one or more GUI objects communicates with the database server to access or edit the database on user-supplied methods associated with each said one or more GUI objects.

29. The method of claim 28, wherein user-supplied methods are included in one or more program segments capable of execution on the GUI server for providing the one or more graphical user interfaces.

30. The method of claim 29, wherein based on the user-supplied methods the one or more program segments translate user interaction with each said one or more GUI objects to one or more requests submitted to the database server.

31. A method of tracking projects over a network, comprising:

accessing shared data in a project database stored on a database server;

generating a plurality of graphical user interfaces to provide read and write access to the database server in response to a user access, the graphical user interfaces being generated from a set of user-selectable options to generate a plurality of read and write requests to access the project database;

associating an object corresponding to at least one of the graphical user interfaces with an action method to handle an event;

transmitting the graphical user interfaces over the network to a web browser; and

processing the read and write requests in a query processor on the database server.

32. The method of claim 31 wherein the set of user-selectable options is provided through a user-defined workspace.

33. The method of claim 32 wherein the user-defined workspace is designed using SpecTcl.

34. The method of claim 31 wherein the graphical user interface server is on a first device and the database server is located on a second device, the first and second devices being located on a local area network.

35. The method of claim 34 wherein the graphical user interface server and database server communicate via sockets over the local area network.

36. The method of claim 31 wherein the network is a wide-area network.

37. The method of claim 31 wherein the network is Internet.

38. The method of claim 31 wherein the graphical user interface server generates the graphical user interfaces using applets.

39. The method of claim 31 wherein the project database stores for each project information selected from a group comprising a record indicating a scope of the project, project documentation information, and a plurality of review requirements.

40. The method of claim 31 wherein the read and write requests are submitted in the form of a database query language.

41. The method of claim 40 wherein the database query language is SQL.

42. The method of claim 31 wherein the database server is one or more instances of a Sybase database system.

43. The method of claim 31 wherein the graphical user interface server includes information selected from a group comprising a software development architecture and a software release architecture.

44. The method of claim 31 wherein the web browser is a Netscape Navigator browser.