System of binding all computerized organizational intelligence on a server computer and RDBMS portal software interface tool and methodology

摘要

A system of binding organizational intelligence to a server machine EO whereby it is no longer distributed throughout both the client(s) and the server(s) but managed exclusively within the RDBMS. An RDBMS portal software tool possessing analytical and data manipulative functionalities, but by design no organizational intelligence, is installed and configured at an end user computer. A data table and stored procedure are created in the RDBMS. The table serves registry and coordination functions, while the stored procedure functions as a menu procedure. The tool is the common interface for all stored procedures and for the user. The user passes instructions to the tool, and the tool passes instructions to the RDBMS to execute stored procedures. The tool receives back from the RDBMS the data sets which results from their execution and provides them to the user. The user may manipulate the data and perform analyses using the tool.