Data retrieval method and apparatus with multiple source capability

• US 6,631,382 B1
• Filed: 07/31/2000
• Issued: 10/07/2003
• Est. Priority Date: 01/02/1996
• Status: Expired due to Term

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Timeline Incorporated
• Inventors: Kouchi, David B., Yarnall, David, Babcock, Donald K.
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US09/628,541
• Time in Patent Office: 1,163 Days
• Field of Search: 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Generation of output or reports on information contained in a data source which may be any of two or more types of source data, in a standardized or uniform manner is provided. A plurality of drivers are provided specific to different types of source data which include programming for identifying structural or other characteristics of the various data sources, e.g. for use in defining a new database. Preferably the new database is configured to permit highly flexible and/or rapid output or reporting or is otherwise optimized for reporting purposes. In one embodiment, the present invention includes conversion of one or more data sources into one or more uniform databases, preferably generating one or more key categories for organizing the data, optionally generating category groupings or rollups and additional data or optional references. In one embodiment, one or more databases are created which have a degree of uniformity of structure, even though they may be based on two or more different data sources which may have very different structures. The different data sources are automatically analyzed and this analysis can be used to identify and/or create categories of data for use in organizing the database.

Claims

1. A computer-implemented method comprising;

providing a driver which issues instructions for accessing data which may be stored in either of first and second different data sources, said driver containing program instructions configured for use in connection with said first data source;

using said driver to automatically obtain information about the data structure of said first data source without the need for human analysis of the first data source by accessing content of information stored in said first data source and mapping at least some information in said data source to procedures which provide a corresponding item in a new database, wherein said information about the data structure leads to optimization of said new database in which information from said first database is to be stored; and

creating a report from said new database.

2. A computer-implemented method usable in connection with accessing data which may be stored in either of first and second different data sources, the method comprising:

a first step in providing a first driver containing program instructions configured for use in connection with said first data source in the absence of said first driver being configured for use in connection with said second data source;

a second step for using said first driver to automatically obtain first information about the data structure of said first data source without the need for human analysis of the first data source by automatically accessing content of information stored in said first data source;

using said first information to define a structure for a first database different from said data sources wherein said first database did not exist before said step for using said first driver to automatically obtain first information; and

generating at least a first report based on information in said first database.

3. A computer-implemented method usable in connection with at least a first data source which stores first source data, said first source data including accounting data, said accounting data being used according to an accounting system which has a plurality of account parts, the method comprising:

using a computer to automatically obtain information about the data structure of said first data source without the need for human analysis of said first data source by accessing content of information stored in said first data source, wherein said information about the data structure includes information which can be used for optimizing a new database, if and when said new database is formed; and

storing at least some of said information about data structure in a data storage device.

4. A method as claimed in claim 3 wherein said step of forming said new database comprises forming said new database having structure different from the structure of said first data source.

5. A method as claimed in claim 4 wherein said step of creating a data repository is performed before said step of using a computer to obtain information about the data structure of said first data source.

6. A method as claimed in claim 3 further comprising forming said new database.

7. A method as claimed in claim 6 wherein said step of forming said new database comprises forming said new database has a structure different from the structure of said first data source.

8. A method as claimed in claim 6 wherein said new database is optimized, using said information about the data structure.

9. A method as claimed in claim 6 wherein said first data source is a database.

10. A method as claimed in claim 6 further comprising soliciting information from a user to be used, at least partially, in determining the structure of said new database.

11. A method as claimed in claim 10 wherein said step of soliciting includes displaying a dialog box.

12. A method as claimed in claim 10 wherein said step of soliciting includes displaying a list of choices.

13. A method as claimed in claim 6 further comprising populating said new database after said step of forming said new database.

14. A method as claimed in claim 3 wherein said information about data structure includes an identification of at least some of said account parts.

15. A method as claimed in claim 3 wherein said information about data structure includes stored queries in said first data source.

16. A computer-implemented method usable in connection with at least a first data source which stores first source data, the method comprising:

using a computer to automatically obtain information about the data structure of said first data source without the need for human analysis of said first data source by accessing content of information stored in said first data source, wherein said information about the data structure includes information which can be used for optimizing a new database, if and when said new database is formed; and

storing at least some of said information about data structure in a data storage device.

17. A method as claimed in claim 16 further comprising creating a data repository without first forming said new database.

18. A method as claimed in claim 17 wherein said step of creating a data repository is performed before said step of using a computer to obtain information about the data structure of said first data source.

19. A method as claimed in claim 16 further comprising forming said new database.

20. A method as claimed in claim 19 further comprising populating said new database after said step of forming said new database.

21. A method as claimed in claim 19 wherein said step of forming a new database comprises conversion of said first data source into a uniform database.

22. A method as claimed in claim 19 wherein said new database is optimized, using said information about the data structure.

23. A method as claimed in claim 16 wherein said step of forming said new database comprises forming said new database having a structure different from the structure of said first data source.

24. A method as claimed in claim 16 wherein said first data source is a database.

25. A method as claimed in claim 16 further comprising soliciting information from a user to be used, at least partially, in determining the structure of said new database.

26. A method as claimed in claim 25 wherein said step of soliciting includes displaying a dialog box.

27. A method as claimed in claim 25 wherein said step of soliciting includes displaying a list of choices.

28. A method as claimed in claim 16 wherein said first data source includes at least first and second tables.

29. A method as claimed in claim 28 wherein said information about the structure of said first data source includes information regarding how data in said first table is linked to data in said second table.