SYSTEM, MULTI-TIER INTERFACE AND METHODS FOR MANAGEMENT OF OPERATIONAL STRUCTURED DATA

• US 20090125796A1
• Filed: 11/10/2008
• Published: 05/14/2009
• Est. Priority Date: 11/09/2007
• Status: Active Grant

• Current Assignee: Fred Day, Kevin Deremigio
• Original Assignee: Fred Day, Kevin Deremigio
• Inventors: DAY, Fred, Deremigio, Kevin
• Granted Patent: US 9,292,306 B2
• Time in Patent Office: Days
• US Class Current: 715/219
• CPC Class Codes: G06F 9/451 Execution arrangements for user interfaces

Abstract

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.

Claims

1. A display method, comprising:

providing a virtual graphical sketch pad as a display panel that is boundless in the horizontal plane (X) and vertical plane (Y);

integrating an information based tiered stack with the virtual graphical sketch pad; and

providing display controls used to navigate, search and investigate composite objects and for exploding selected objects in the stack to specific object information screens used to build and maintain composite objects,

wherein the stack provides a single display component group as a composite of objects consisting of horizontally and vertically arranged objects that decompose into sub-objects.

2. A method according to claim 1, wherein the integrating step includes placement algorithms to automatically place objects on a screen based on the intra and inter-relationships among objects.

3. A method according to claim 1, wherein the integrating step includes placement algorithms that place components onto the virtual sketch pad based on one or more of component heuristics, inter-component relationships and intra-component relationships.

4. A method according to claim 1, wherein the integrating step includes placement algorithms that place components onto the virtual sketch pad based on one or more of usage, process and expert user knowledge defined into an algorithm.

5. A method according to claim 1, wherein the integrating step includes a placement strategy to place related components onto cells in a left to right process clustered around a center horizontal axis in a “

T”

configuration.

6. A method according to claim 1, wherein the integrating step includes a placement strategy to place related components onto cells in a bottom to top and left to right in an “

L”

configuration.

7. A method according to claim 1, wherein the integrating step includes a “

Z”

algorithm that places components onto cells using a composite of “

L” and

“

T”

configurations based on the clumping of intra-relationships of related components and inter-relationships of related components.

8. A method according to claim 1, wherein the display controls include a navigation aid that provides a quick one or two button click from any primary level (application) and/or secondary level (library) component to a third level (object) component group located anywhere on the virtual sketch pad.

9. A method according to claim 1, wherein the display controls include a single click function on a virtual sketch pad neutral image area that turns “

on”

or “

off”

the display of all third level components.

10. A method according to claim 1, wherein the display controls include a single click function on a virtual sketch pad primary level (application) image that turns “

on”

or “

off”

the display of all third level components that belong to the selected primary level.

11. A method according to claim 1, wherein the display controls include a single click function on a virtual sketch pad primary level (application) component that highlights the display of all secondary level components that belong to the selected primary level component.

12. A method according to claim 1, wherein the display controls include a single click function on a virtual sketch pad secondary level (library) component that highlights the display of all third level components that belong to the selected secondary level component.

13. A method according to claim 1, wherein the display controls include a pan ability to point and click to slide the virtual sketch pad logically via a reference link, to the left, to the right, to the top and to the bottom.

14. A method according to claim 1, wherein the display controls include a zoom ability to point and click to zoom in (magnify) or zoom out (compress) the current virtual sketch-pad display.

15. A method of managing structured data, comprising:

providing a Composite Object as a graphical union of a variable object, language object, connector object, analysis object and user object managed as a single manageable object;

providing one or more user objects to browse or edit the analysis, variable, language and connector objects or to zoom onto the composite object.

16. A method according to claim 15, further comprising providing a graphical search engine to access, audit, find, display and show language object hierarchy and to display for all first instance search matches for any composite object and displays all secondary references via an INCLUDE object.

17. A method according to claim 15, further comprising providing a version object as a visual icon to toggle through all published and unpublished versions of the composite object.

18. A method according to claim 15, further comprising providing a zoom method to click on a composite variable object as a logical zoom to display the variable object detail.

19. A method according to claim 15, further providing a zoom method to click on a composite language object as a logical zoom to display the language object display detail.

20. A method for use by subject matter expert users to achieve application characteristics applied to structured data sources among disparate information sources, the method comprising:

performing a bi-directional computation among disparate information sources defined as application components and data processes called a data integration application;

providing a design enabling function based processes capable of extension in current formula or additional new command options;

providing a design enabling function based processes capable of extension in current formula or additional through series of spread sheet function and processes enabling creation of rule object component; and

providing an automatic documentation of component objects, analysis and search.