Web-based strategic client planning system for end-user creation of queries, reports and database updates
First Claim
1. 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 said client computer, a query form for data from said 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, wherein said worksheet grid form comprises multiple rows of data;
sending said worksheet grid form from said server computer to said client computer;
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, 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 said database of said server;
updating said database through said network by transmitting said worksheet grid form from said client computer to said server computer; and
wherein said updating of said tabular data includes making cascaded mass changes to a set of related data across multiple tables, andwherein said updating of said database of said worksheet grid form includes allowing only selected tables, rows, and columns to be updated by authorized users.
2 Assignments
0 Petitions
Accused Products
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.
-
Citations
11 Claims
-
1. 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 said client computer, a query form for data from said 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, wherein said worksheet grid form comprises multiple rows of data; sending said worksheet grid form from said server computer to said client computer; 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, 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 said database of said server; updating said database through said network by transmitting said worksheet grid form from said client computer to said server computer; and wherein said updating of said tabular data includes making cascaded mass changes to a set of related data across multiple tables, and 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. - View Dependent Claims (2, 3, 4, 5)
-
-
6. 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, wherein said worksheet grid form comprises multiple rows of data; packaging said worksheet grid form to represent updated data for said tabular data stream, 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; and applying commit rule options, during said saving of said changes of data contained in said worksheet grid, to choose a method by which errors are handled during the processing of database updates, deletes, and inserts; wherein said packaging said worksheet grid form includes making cascaded mass changes to a set of related data across multiple tables, and wherein said packing said worksheet grid form includes allowing only tables, rows, and columns to be updated by authorized users. - View Dependent Claims (7, 8, 9, 10, 11)
-
Specification