| 摘要 |
The invention provides a computer implemented, methods, systems, software program devices, and a Multi-Tier Graphical Interface level General User Interface (GUI) screen designed to support data integration processes for IT and Subject Matter Experts User access and use of structured data sources. The software enables create, extract, transform, programs, processes, and load data integration application Data Integration Application (Composite Object)s through an object based software design enabling efficient and rapid retrieval, processing, and positioning of structured data directly from one or multiple data sources to the required formats, processes, and application support at the skills set levels of the user. The software is a command and processes design for Data Integration Application (Composite Object) that can be transaction oriented, recurring process, as well as periodic The software is an open, data oriented system design for rapid generation and support of Data Integration Application (Composite Object)s using a Multi-Tier three dimensional graphical interface design for cell based data applications. The Data Integration Application (Composite Object) are compiled, independent object applications residing in an object library designated by the user/user IT organization. The compiled data application object are run on the organization's existing computing systems under standard compute processing procedures as either independent applications or in support of the organizations ongoing business/operational requirements for data use requirements. |
| 主权项 |
1. A method of processing data applications using a computer, comprising:
managing, by the computer, processing of data that is distributed among one to multiple data sources, including:
providing a data application object as a compiled union of a variable object, a language object, a connector object, and one or more user objects that provide functionality to browse, analyze or edit the variable, language and connector objects or to zoom onto the data application object, wherein the data application object is adapted to be managed as a single integrated object;providing a programming process for creating the variable object as a data schema of a source and a target data structure in the data, the language object as a data application for an execution process, and the connector object which defines a connection between the source and target data structures,wherein a structured framework is provided for defining data variables of the variable object, creating a compute application for the language object, and defining the source and target data structures for the connector object; andallowing for asynchronous execution of the compiled data application object as an Import, Compute, Export (ICE) method, the execution being allowed to be performed in parallel and serially in relation to the execution of other data application objects; and managing, by the computer, display of the data applications, including:
providing a virtual graphical display that comprises a horizontal plane (X), vertical plane (Y) and depth plane (Z);automatically placing graphical cells on the virtual graphical display along one or more of the horizontal, vertical and depth planes; andproviding display controls used to navigate, search and investigate data application objects that are represented by the graphical cells and that operate on the data and for exploding selected graphical cells into screens used to build, drill into and maintain the data application objects, andenabling subject matter expert users to achieve application characteristics applied to data sources among the one to multiple data sources, the enabling step including:providing a bi-directional algorithm to enable a data application object to support data movement between data sources bi-directionally through an iterative inverse process with execution of a connector object process;providing a function for extending a current formula or adding new command options;providing a function for extending current or additional formulas through a series of spread sheet function and for enabling creation of one or more components of the language object; andproviding an automatic documentation process of each of the variable, language, connector and analysis objects within the compiled data application object,wherein the step of providing the bi-directional algorithm allows for executing an application in the forward and then executing the application in the reverse direction to yield the equivalent results of an original source equivalent; and wherein the automatic placement of the graphical cells provides a single display component group as a composite of graphical cells that are arranged horizontally, vertically and/or in depth in accordance with one or more placement algorithms performed using the data operated on by the corresponding data application objects represented by the graphical cells. |
