Web-based strategic client planning system for end-user creation of queries, reports and database updates
AssigneeInternational Business Machines Corporation
InventorsCatherine G. Bala, Thomas A. Jobson, Jr., F. Jay Kolb, Brian L. Merzbach, Christine L. Quintero, Scott Selvia
Life of this patent
Estimating the term…
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.
Claims11
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.
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.
Dependencies are inferred from the claim text.