Device and method for arranging data for use by a data client, such as a graph

• US 5,933,830 A
• Filed: 05/09/1997
• Issued: 08/03/1999
• Est. Priority Date: 05/09/1997
• Status: Expired due to Fees

• Current Assignee: Corda Technologies Incorporated (Domo, Inc.)
• Original Assignee: Corda Technologies Incorporated (Domo, Inc.)
• Inventors: Williams, Neal Wesley
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): Lewis, Cheryl
• Application Number:
  US08/854,079
• Time in Patent Office: 816 Days
• Field of Search: 707/103, 707/100, 707/101, 707/102, 707/104, 711/5
• US Class Current: 1/1
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

An inventive computer-implemented method for arranging one or more sets of data for use by a data client includes automatically determining dimensions of each of the sets of data, automatically adjusting dimensions of a data repository to accommodate the dimensions of the sets of data, and arranging the sets of data in the data repository for use by the data client.

Claims

1. A computer-implemented method for arranging one or more sets of data for use by a data client, the method comprising:

providing a data repository having one or more data cells;

automatically determining dimensions of each of the sets of data;

automatically adjusting the number of data cells in the data repository to accommodate the dimensions of the sets of data; and

arranging the sets of data in the data repository for use by the data client.

2. The method of claim 1 wherein the step of automatically determining dimensions of each of the sets of data comprises receiving each of the sets of data in a row and column-delimited format and determining the number of rows and columns in each of the sets of data from the row and column-delimited format of each set.

3. The method of claim 2 wherein the step of receiving each of the sets of data in a row and column-delimited format comprises receiving each of the sets of data in a format in which columns are delimited by tab escape codes and rows are delimited by at least one of carriage return escape codes and new line escape codes.

4. The method of claim 1 wherein the data repository and the sets of data are arranged in rows and columns, wherein the step of automatically adjusting the number of data cells in the data repository to accommodate the dimensions of the sets of data comprises:

adding rows to the data repository when the total number of rows in the sets of data is greater than the number of rows in the data repository;

adding columns to the data repository when the total number of columns in the sets of data is greater than the number of columns in the data repository;

deleting rows from the data repository when the total number of rows in the sets of data is less than the number of rows in the data repository; and

deleting columns from the data repository when the total number of columns in the sets of data is less than the number of columns in the data repository.

5. The method of claim 1 wherein the data repository and the sets of data are arranged in rows and columns, wherein the step of arranging the sets of data in the data repository for use by the data client comprises parsing each of the sets of data into rows and columns and storing the parsed sets of data in the rows and columns of the data repository.

6. The method of claim 1 wherein the step of arranging the sets of data in the data repository for use by the data client includes filtering the sets of data for use by the data client.

7. The method of claim 6 wherein the step of filtering the sets of data includes at least one of:

transposing rows and columns in the sets of data;

suppressing at least one of rows, columns, and cells in the sets of data;

scaling sets of data; and

sorting sets of data.

8. The method of claim 1 wherein the sets of data include at least one of text data and numerical data.

9. The method of claim 1, further comprising modifying the sets of data through their use by the data client.

10. The method of claim 1 wherein the steps of determining, adjusting, and arranging occur sequentially.

11. An apparatus for arranging one or more sets of data for use by a data client, the apparatus comprising:

a data repository device having one or more data cells;

a source manager device for automatically determining dimensions of each of the sets of data; and

a data manager device coupled to the data repository device and the source manager device for automatically adjusting the number of data cells in the data repository device to accommodate the dimensions of the sets of data and for arranging the sets of data in the data repository device for use by the data client.

12. The apparatus of claim 11 wherein the data cells of the data repository device are arranged in rows and columns.

13. The apparatus of claim 11 wherein at least one of the data repository, source manager, and data manager devices is implemented on at least one computer within an object-oriented framework and includes at least one object.

14. The apparatus of claim 11 wherein the source manager device comprises a device for receiving each of the sets of data in a row and column-delimited format and for determining the number of rows and columns in each of the sets of data from the row and column-delimited format of each set.

15. The apparatus of claim 14 wherein the source manager device comprises a device for receiving each of the sets of data in a format in which columns are delimited by tab escape codes and rows are delimited by at least one of carriage return escape codes and new line escape codes.

16. The apparatus of claim 11 wherein the sets of data are arranged in rows and columns, wherein the data repository device comprises a plurality of cells arranged in rows and columns, wherein the data manager device comprises a device for:

adding rows of cells to the data repository device when the total number of rows in the sets of data is greater than the number of rows of cells in the data repository device;

adding columns of cells to the data repository device when the total number of columns in the sets of data is greater than the number of columns of cells in the data repository device;

deleting rows of cells from the data repository device when the total number of rows in the sets of data is less than the number of rows of cells in the data repository device;

deleting columns of cells from the data repository device when the total number of columns in the sets of data is less than the number of columns of cells in the data repository device;

parsing each of the sets of data into rows and columns; and

storing the parsed sets of data in the rows and columns of cells in the data repository device.

17. The apparatus of claim 11 wherein the data repository, source manager, and data manager devices are all implemented in a single computer.

18. The apparatus of claim 11 wherein the source manager device comprises a plurality of source manager objects each associated with one of the sets of data.

19. The apparatus of claim 11, further comprising a data gathering window device coupled to the data manager device for filtering the sets of data in the data repository for use by the data client.

20. The apparatus of claim 17 wherein the data gathering window device includes devices for transposing rows and columns of data in the sets of data in the data repository, suppressing rows, columns, and cells of data in the sets of data in the data repository, scaling data in the sets of data in the data repository, and sorting data in the sets of data in the data repository.

21. The apparatus of claim 19 wherein the data gathering window device includes devices for manual entry of row and column labels on the sets of data in the data repository for use by the data client.

23. The system of claim 11 wherein the source manager object further includes member methods for:

causing the data manager object to adjust the number of data cells in the data repository;

parsing data;

providing parsed data to the data manager object for arrangement in the data repository; and

causing the data manager object to purge the data repository of data.

24. The system of claim 11 wherein the data manager object further includes member methods for:

purging the data repository of data; and

retrieving data from the data repository.

22. An object-oriented system for arranging one or more sets of data for use by a data client, the system being for implementation on a computer within an object-oriented framework, the system comprising:

a data repository having one or more data cells;

a source manager object including a member method for determining dimensions of each of the sets of data; and

a data manager object including a member method for adjusting the number of data cells in the data repository to accommodate the dimensions of the sets of data and a member method for arranging the sets of data in the data repository for use by the data client.

25. A computer system for arranging one or more sets of data for use by a data client, the computer system comprising an input device, an output device, a memory device, and a processor device coupled to the input, output, and memory devices, one or more of the devices being adapted to automatically determine dimensions of each of the sets of data, to automatically adjust the number of data cells in a data repository to accommodate the dimensions of the sets of data, and to arrange the sets of data in the data repository for use by the data client.

26. A computer-readable storage medium having a configuration representing data and instructions for causing a computer to operate in accordance with a method for arranging one or more sets of data for use by a data client, the method comprising:

determining dimensions of each of the sets of data;

adjusting the number of data cells in a data repository to accommodate the dimensions of the sets of data; and

arranging the sets of data in the data repository for use by the data client.

27. A computer-implemented method for arranging one or more sets of data, the method comprising:

automatically determining dimensions of each of the sets of data;

automatically adjusting dimensions of a data repository to accommodate the dimensions of the sets of data; and

arranging the sets of data in the data repository for use by a data client selected from a group comprising a graph, a gauge, a database, a table, a spreadsheet, a software component, a stand-alone software application, a Live Object, an ActiveX control, and a Java applet.

28. A computer-implemented method for arranging one or more sets of data for use by a data client, the method comprising:

automatically determining dimensions of each of the sets of data, including accessing each of the sets of data from a source selected from a group comprising an internet, an extranet, an intranet, a table, a database, a spreadsheet, a report, a Live Object, a software component, an ActiveX control, a Java applet, and a Common Gateway Interface (CGI) script executing on a computer;

automatically adjusting dimensions of a data repository to accommodate the dimensions of the sets of data; and

arranging the sets of data in the data repository for use by the data client.

29. An object-oriented system for arranging one or more sets of data for use by a data client, the system being for implementation on a computer within an object-oriented framework that includes an OpenDoc framework, the system comprising:

a data repository;

a source manager object including a member method for determining dimensions of each of the sets of data; and

a data manager object including a member method for adjusting dimensions of the data repository to accommodate the dimensions of the sets of data and a member method for arranging the sets of data in the data repository for use by the data client.

30. An object-oriented system for arranging one or more sets of data for use by a data client, the system being for implementation on a computer within an object-oriented framework, the system comprising:

a data repository;

a source manager object including a member method for determining dimensions of each of the sets of data, the source manager object being responsive to at least one of timeout calls, notification calls, and paste calls from the object-oriented framework; and

a data manager object including a member method for adjusting dimensions of the data repository to accommodate the dimensions of the sets of data and a member method for arranging the sets of data in the data repository for use by the data client.

31. An object-oriented system for arranging one or more sets of data for use by a data client, the system being for implementation on a computer within an object-oriented framework, the system comprising:

a data repository;

a source manager object including a member method for determining dimensions of each of the sets of data; and

a data manager object including a member method for adjusting dimensions of the data repository to accommodate the dimensions of the sets of data, a member method for arranging the sets of data in the data repository for use by the data client, a member method for purging the data repository of data, and a member method for retrieving data from the data repository that includes methods for retrieving both filtered and unfiltered data from the data repository.

32. A computer readable storage medium selected from a group comprising a diskette, a floppy disk, a CD-ROM, a hard disk, and a tape, the medium having a configuration representing data and instructions for causing a computer to operate in accordance with a method for arranging one or more sets of data for use by a data client, the method comprising:

determining dimensions of each of the sets of data;

adjusting dimensions of a data repository to accommodate the dimensions of the sets of data; and

arranging the sets of data in the data repository for use by the data client.