Web-based strategic client planning system for end-user creation of queries, reports and database updates

• US 20030018644A1
• Filed: 06/21/2001
• Published: 01/23/2003
• Est. Priority Date: 06/21/2001
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Jobson, Thomas A. Jr., Bala, Catherine G., Merzbach, Brian L., Quintero, Christine L., Kolb, F. Jay, Selvia, Scott
• Granted Patent: US 7,013,312 B2
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A method and program storage device for creating tabular data stream flow for sending rows of secure data between a client workstation and a server computer over a network using a common object request broker architecture (CORBA). This method includes receiving a request to create a query form at the client workstation, receiving a worksheet grid form defining selected tabular data, and packaging the worksheet grid form representing an updated status of the data for the tabular data stream flow.

Claims

1. A method of creating a tabular data stream for sending data between a client workstation and a server computer through a network using a common object request broker architecture (CORBA), said method comprising:

creating a query form in said client workstation;

receiving a worksheet grid form in response to said query form, said worksheet grid form defining selected tabular data; and

packaging said worksheet grid form to represent updated data for said tabular data stream.

2. The method of claim 1, wherein said creating of said query form creates secure complex queries based on a selection of table, columns, and constraints maintained in a database of said server computer.

3. The method of claim 1, wherein said receiving of said worksheet grid form creates a snapshot from data in a database of said server.

4. The method of claim 1, wherein said packaging of said worksheet grid form includes editing results of said query form and saving changes of data contained in said worksheet grid form in a database of said server.

5. The method of claim 1, wherein said packaging said worksheet grid form includes producing reports capable of summarizing information by selected groups.

6. The method of claim 1, wherein said packaging said worksheet grid form includes producing comparison reports on a delta between two similarly structured tables.

7. The method of claim 1, wherein said packaging said worksheet grid form includes making cascaded mass changes to a set of related data across multiple tables.

8. The method of claim 1, wherein said packaging said worksheet grid form includes allowing only tables, rows, and columns to be updated by authorized users.

9. The method of claim 1, further including automatically maintaining a current level of implementation of said worksheet grid form on said client workstation.

10. A method of querying a database through a secure network using a common object request broker architecture (CORBA), wherein said database is associated with a server computer running a server process, said server computer being connected to, and in communication with, a client computer through a network, said method comprising:

issuing, by a client process running on a client computer, a query form for data from a database;

sending said query form from said client computer to said server computer;

processing said query form, by said server computer, and retrieving rows of data satisfying said query form from said database as a worksheet grid form defining selected tabular data;

sending said worksheet grid form from said server computer to said client computer; and

packaging, by said client computer, said worksheet grid form representing updated data for marshaling tabular data for transfer between said client computer and said server computer.

11. The method of claim 10, further comprising updating said database through said network by transmitting said worksheet grid form from said client computer to said server computer.

12. The method of claim 10, wherein said packaging of said worksheet grid form includes editing results of said query form and saving changes of data contained in said worksheet grid form by said client process running on said client computer.

13. The method of claim 11, wherein said updating of said tabular data includes producing reports capable of summarizing information by selected groups.

14. The method of claim 10, wherein said packaging said worksheet grid form includes producing comparison reports on a delta between two similarly structured tables.

15. The method of claim 11, wherein said updating of said tabular data includes making cascaded mass changes to a set of related data across multiple tables.

16. The method of claim 11, wherein said updating of said database of said worksheet grid form includes allowing only selected tables, rows, and columns to be updated by authorized users.

17. The method of claim 10, further including automatically maintaining a current level of implementation of said worksheet grid form on said client workstation.

18. The method of claim 10, further including controlling access to data of a user in said database by partitioning said database into private and public database, wherein said user controls said access.

20. The method of claim 19, wherein said creating of said query form creates secure complex queries based on a selection of table, columns, and constraints maintained in a database of said server computer.

21. The method of claim 19, wherein said receiving of said worksheet grid form results in creating a snapshot from data in a database of said server.

22. The product of claim 19, wherein said packaging of said worksheet grid form includes editing results of said query form and saving changes of data contained in said worksheet grid form in a database of said server.

23. The product of claim 19, wherein said packaging said worksheet grid form includes producing reports capable of summarizing information by selected groups.

24. The product of claim 19, wherein said packaging said worksheet grid form includes producing comparison reports on a delta between two similarly structured tables.

25. The product of claim 19, wherein said packaging said worksheet grid form includes making cascaded mass changes to a set of related data across multiple tables.

26. The product of claim 19, wherein said packaging said worksheet grid form includes allowing only tables, rows, and columns to be updated by authorized users.

27. The product of claim 19, wherein said program code for implementing said instructions comprises JAVA programming language.

19. A computer program product for use with a secure database management system having a client system operatively coupled to a server system using a common object request broker architecture (CORBA), the computer program product comprising a computer usable medium having computer usable program code for implementing the following instructions comprising:

receiving a request to create a query form in said client workstation;

receiving a worksheet grid form defining selected tabular data; and

packaging said worksheet grid form representing updated data for said tabular data stream.