Method and System for Populating a Database With Bibliographic Data From Multiple Sources

• US 20100077007A1
• Filed: 09/18/2009
• Published: 03/25/2010
• Est. Priority Date: 09/18/2008
• Status: Abandoned Application

• Current Assignee: Semiconductor Insights Incorporated (Informa PLC)
• Original Assignee: Semiconductor Insights Incorporated (Informa PLC)
• Inventors: White, Jason, Abbasi, Asad
• Application Number:
  US12/562,217
• Publication Number:
  US 20100077007A1
• Time in Patent Office: Days
• US Class Current: 707/791
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

There is disclosed a method of populating a relational database of bibliographic data associated with one or more document-based collections, wherein the bibliographic data is sourced from two or more sources having distinct source-specific formats. The method generally comprises the steps of accessing source data from the two or more sources; independently standardizing the accessed data from each of the two or more sources in accordance with a common intermediate source-independent format dictated by an intermediate data structure, such that similar data elements from distinct source-specific formats are commonly identified within the intermediate format; and further interpreting the standardized data in relation to stored database elements comprising at least some database elements derived from each of the two or more sources, for populating the database in accordance with the relation with at least some repetitive elements replaced with reference thereto, consistent with a refined database data structure distinct from the intermediate data structure. A system and computer-readable medium for implementing the above method are also disclosed.

Claims

1. A method of populating a relational database of bibliographic data associated with one or more document-based collections, wherein said bibliographic data is sourced from two or more sources having distinct source-specific formats, comprising the steps of:

accessing source data from the two or more sources;

independently standardizing said accessed data from each of the two or more sources in accordance with a common intermediate source-independent format dictated by an intermediate data structure, such that similar data elements from distinct source-specific formats are commonly identified within said intermediate format; and

further interpreting said standardized data in relation to stored database elements comprising at least some database elements derived from each of the two or more sources, for populating the database in accordance with said relation with at least some repetitive elements replaced with reference thereto, consistent with a refined database data structure distinct from said intermediate data structure.

2. The method of claim 1, wherein said database data structure is normalized to a higher normal form than said intermediate structure.

3. The method of claim 1, wherein said intermediate data structure is normalized to a first normal form whereas said database data structure is normalized to a third normal form.

4. The method of claim 1, wherein said further interpreting step interrelates bibliographic data initially sourced in distinct source-specific formats and associated with documents from distinct document-based collections, via one or more data elements common to each of said documents and commonly identified within said intermediate format via said standardizing step.

5. The method of claim 1, wherein said further interpreting step comprises interpreting similar data elements associated with distinct documents as identical based on a degree of similarity between other data elements associated with said distinct documents.

6. The method of claim 1, wherein said further interpreting step is implemented via a common interpreter for all independently standardized data.

7. The method of claim 1, wherein said at least some repetitive elements existing, at least one of, within said standardized data from a single source, within said standardized data from plural sources, between said standardized data and said stored database elements, and both within said standardized data and between said standardized data and said stored database elements.

8. The method of claim 1, wherein independently standardized data from distinct sources is further interpreted at least one of simultaneously, sequentially and as available.

9. The method of claim 1, wherein said accessed data is selected from the group consisting of a single file, multiple files and a batch file.

10. The method of claim 1, wherein the database is normalized to one of first, second, third and fourth normal forms.

11. The method of claim 1, wherein said accessed data comprises metadata.

12. The method of claim 1, wherein the one or more document-based collections comprise one or more patent document-based collections.

13. The method of claim 12, wherein said stored database elements comprise metadata and patent documents.

14. The method of claim 1, wherein said database is normalized with at least one many-to-many relationship.

15. The method of claim 14, wherein said at least one many-to-many relationship is implemented using a linking table with one-to-many relationships.

16. The method of claim 1, wherein said further interpreting populates the database in accordance with said relation such that links exist in the database that are not available from any one of said two or more sources individually.

17. The method of claim 1, wherein said standardizing and further interpreting steps are implemented automatically by one or more computing devices, which one or more computing devices comprising one or more processors operatively coupled to one or more data storage devices having statements and instructions stored therein for, when executed by said one or more processors, automatically implementing said standardizing and further interpreting steps.

18. The method of claim 1, wherein said accessing step comprises one or more of acquiring said source data from at least one of said sources and accessing previously acquired source data.

19. The method of claim 1, wherein different data sets from a same document-based collection are accessed in distinct source-specific formats.

20. A system for populating a relational database of bibliographic data associated with one or more document-based collections, wherein said bibliographic data is sourced from two or more sources having distinct source-specific formats, the system comprising:

one or more data storage devices configured to define an intermediate data structure and a refined database data structure distinct therefrom, and for storing database elements derived from each of the two or more sources in accordance with said refined database data structure;

independent standardization modules for independently standardizing data accessed from the two or more sources in accordance with a common intermediate source-independent format dictated by said intermediate data structure, such that similar data elements from distinct source-specific formats are commonly identified within said intermediate format; and

an interpreter for further interpreting said standardized data in relation to said stored database elements from each of the two or more sources for populating the database in accordance with said relation with at least some repetitive elements replaced with reference thereto, consistent with said refined database data structure.

21. The system of claim 20, further comprising a decision parser for determining an appropriate standardization module for said accessed data based on an associated source-specific format thereof.

22. The system of claim 20, comprising a patent-document database system.

23. A computer-readable medium for populating a relational database of bibliographic data associated with one or more document-based collections accessed from two or more sources in distinct source-specific formats, comprising statements and instructions for implementation by a computing device to implement the steps of:

independently standardizing said accessed data from each of the two or more sources in accordance with a common intermediate source-independent format dictated by an intermediate data structure, such that similar data elements from distinct source-specific formats are commonly identified within said intermediate format; and

further interpreting said standardized data in relation to stored database elements comprising at least some database elements derived from each of the two or more sources, for populating the database in accordance with said relation with at least some repetitive elements replaced with reference thereto, consistent with a refined database data structure distinct from said intermediate data structure.

24. The computer-readable medium of claim 23, further comprising statements and instructions for parsing accessed data based on a source-specific format thereof in selecting appropriate standardizing instructions therefor.

25. The computer-readable medium of claim 23, wherein said one or more document-based collections comprise patent document-based collections.