Modularized data retrieval method and apparatus with multiple source capability

• US 6,625,617 B2
• Filed: 12/08/2000
• Issued: 09/23/2003
• Est. Priority Date: 01/02/1996
• Status: Expired due to Term

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Timeline Incorporated
• Inventors: Yarnall, David, Babcock, Donald K.
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US09/733,400
• Publication Number:
  US 20010020237A1
• Time in Patent Office: 1,019 Days
• Field of Search: 707/104.1
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

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 at least a first driver which contains programming for accessing at least a first data source and a second data source, different from said first data source, said first driver containing a first set of program instructions configured for use in connection with at least said first data source and containing a second set of program instructions configured for use in connection with at least said second data source;

using said first driver to automatically obtain first information about the data structure of at least a first accessed data source, wherein said accessed data source is one of said first data source and said second data source, without the need for human analysis of the first data source or said second data source;

said first driver including at least a third set of program instructions which is executed regardless of whether said accessed data source is said first data source or said second data source.

2. A method, as claimed in claim 1 wherein said third set of program instructions includes instructions for providing a user interface to accommodate user input.

3. A method, as claimed in claim 2, wherein said user input includes at least one of:

a selection of a level of data organization;

or

a selection of at least one accounting period.

4. Apparatus comprising:

programming means for accessing at least a first data source and a second data source, different from said first data source, said programming means containing a first set of program instructions configured for use in connection with at least said first data source and containing a second set of program instructions configured for use in connection with at least said second data source;

means for using said programming means to automatically obtain first information about the data structure of at least a first accessed data source, wherein said accessed data source is one of said first data source and said second data source, without the need for human analysis of the first data source or said second data source;

said programming means including at least a third set of program instructions which is executed regardless of whether said accessed data source is said first data source or said second data source.

5. Apparatus as claimed in claim 4 wherein said programming means comprises a driver stored in an information storage device.

6. Apparatus as claimed in claim 4 wherein said means for using comprises an electronic computer.

7. Apparatus, as claimed in claim 4, wherein said third set of program instructions includes instructions for providing a user interface to accommodate user input.

8. Apparatus, as claimed in claim 7, wherein said user input includes at least one of:

a selection of a level of data organization; and

a selection of at least one accounting period.

9. Apparatus comprising:

a computer programmed to;

provide at least a first driver which contains programming for accessing at least a first data source and a second data source, different from said first data source, said first driver containing a first set of program instructions configured for use in connection with at least said first data source and containing a second set of program instructions configured for use in connection with at least said second data source;

use said first driver to automatically obtain first information about the data structure of at least a first accessed data source, wherein said accessed data source is one of said first data source and said second data source, without the need for human analysis of the first data source or said second data source;

wherein said first driver includes at least a third set of program instructions which is executed regardless of whether said accessed data source is said first data source or said second data source.

10. A computer-readable medium, having stored therein a computer program comprising instructions for:

providing at least a first driver which contains programming for accessing at least a first data source and a second data source, different from said first data source, said first driver containing a first set of program instructions configured for use in connection with at least said first data source and containing a second set of program instructions configured for use in connection with at least said second data source;

using said first driver to automatically obtain first information about the data structure of at least a first accessed data source, wherein said accessed data source is one of said first data source and said second data source, without the need for human analysis of the first data source or said second data source;

said first driver including at least a third set of program instructions which is executed regardless of whether said accessed data source is said first data source or said second data source.

11. A computer-implemented method comprising:

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

using said driver to automatically obtain first information about the data structure of at least a first accessed data source, wherein said accessed data source is one of said first data source and said second data source, without the need for human analysis of the first data source or the second data source, by accessing content of information stored in said accessed data source wherein said first information leads to optimization of a new database in which information from said accessed data source is to be stored.

12. A method, as claimed in claim 11, further comprising:

storing at least some of said first information.

13. A method, as claimed in claim 11, further comprising:

using said first information to define a new structure, different from said data structure of said accessed data source.

14. A method, as claimed in claim 13 further comprising:

storing information at least partially defining said new structure.

15. A method, as claimed in claim 13, further comprising:

creating a new database having said new structure, after said step of using said first information to define a new structure.

16. A method, as claimed in claim 15 further comprising populating said new database with at least some data from said accessed data source, after said step of creating a new database.

17. A method, as claimed in claim 11, wherein said driver includes at least a third set of program instructions which is executed regardless of whether said accessed data source is said first data source or said second data source.

18. Apparatus comprising:

programming means which issues instructions for accessing either of first and second different data sources, said programming means containing a first set of program instructions configured for use in connection with said first data source and containing a second set of program instructions configured for use in connection with said second data source; and

means for using said programming means to automatically obtain first information about the data structure of at least a first accessed data source, wherein said accessed data source is one of said first data source and said second data source, without the need for human analysis of the first data source or the second data source, by accessing content of information stored in said accessed data source wherein said first information leads to optimization of a new database in which information from said accessed data source is to be stored.

19. Apparatus, as claimed in claim 18, further comprising:

means for storing at least some of said first information.

20. Apparatus, as claimed in claim 18, wherein said means for using further comprises means for using said first information to define a new structure, different from said data structure of said accessed data source.

21. Apparatus, as claimed in claim 20 further comprising:

means for storing information at least partially defining said new structure.

22. Apparatus, as claimed in claim 20, further comprising:

means for creating a new database having said new structure, after storing information to define a new structure.

23. Apparatus, as claimed in claim 22 further comprising means for populating said new database with at least some data from said accessed data source, after said step of creating a new database.

24. Apparatus, as claimed in claim 20 wherein said means for creating includes a computer.

25. Apparatus comprising:

a computer programmed to;

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

use said driver to automatically obtain first information about the data structure of at least a first accessed data source, wherein said accessed data source is one of said first data source and said second data source, without the need for human analysis of the first data source or the second data source, by accessing content of information stored in said accessed data source wherein said first information leads to optimization of a new database in which information from said accessed data source is to be stored.

26. A computer-readable medium, having stored therein a computer program, the computer program comprising instructions for:

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

using said driver to automatically obtain first information about the data structure of at least a first accessed data source, wherein said accessed data source is one of said first data source and said second data source, without the need for human analysis of the first data source or the second data source, by accessing content of information stored in said accessed data source wherein said first information leads to optimization of a new database in which information from said accessed data source is to be stored.