System for storing and retrieving database information

• US 20040199537A1
• Filed: 01/13/2004
• Published: 10/07/2004
• Est. Priority Date: 04/03/2003
• Status: Abandoned Application

• Current Assignee: Robert Cory Duff
• Original Assignee: Robert Cory Duff
• Inventors: Duff, Robert Cory
• Application Number:
  US10/756,527
• Publication Number:
  US 20040199537A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/30 of unstructured textual data document management systems G06F16/93
• CPC Class Codes: G06F 16/84 Mapping; Conversion

Abstract

Certain exemplary embodiments comprise a system for storing information in a repository. The system comprises an interface processor for receiving a text file comprising a plurality of records containing data in a character string representative data format. The system further comprises a pre-processor for parsing a reference file to determine relationships between records comprised of character strings in the text file, the relationships comprising a key relationship, and for storing data identifying the relationships in memory. The system further comprises a data processor for storing the records comprised of the character strings in the text file in a repository using the data identifying the relationships.

Claims

1. A system for storing information in a repository (1800), comprising:

an interface processor (1300) for receiving a text file (1100) comprising a plurality of records containing data in a character string representative data format;

a pre-processor (1400) for parsing a reference file (1200) to determine relationships between records comprised as character strings in said text file (1100), said relationships comprising a key relationship, and for storing data identifying said relationships in memory; and

a data processor (1500) for storing said records comprised as character strings in said text file (1100) in a repository (1800) using said data identifying said relationships.

2. A system according to claim 1, wherein

the reference file (1200) comprises metadata (1200).

3. A system according to claim 1, wherein

said character string representative data format comprises at least one of,

(a) ASCII (American Standard Code for Information Interchange) format and

(b) another character representative data format.

4. A system according to claim 1, wherein

said pre-processor (1400) is adapted to store said data identifying said relationships in an organized data structure in said memory comprising at least one of, (a) a tabular structure having both data rows and columns, (b) a plurality of tabular structures, (c) a mapping structure and (d) adjacent memory locations.

5. A system according to claim 1, wherein

said data identifying said relationships comprises a plurality of data elements associated with a record relationship and include at least one of, (a) an identifier for identifying a specific data element of said plurality of data elements, (b) an identifier for identifying a specific data element of a plurality of data elements associated with a storage file comprised in said text file (1100), (c) a descriptive name for a record, (d) a location in a record for start of an identifier for identifying a specific record, (e) a length in number of characters of an identifier for identifying a specific record.

6. A system according to claim 5, wherein

said data identifying said relationships comprises a plurality of data elements associated with a record relationship and include at least one of, (i) a location in a record for start of a code for identifying a record type, (ii) a length in number of characters of said code for identifying a record type and (iii) a character string used to differentiate record types.

7. A system according to claim 5, wherein

an individual record of said plurality of records comprised in said text file (1100) includes an identifier for identifying a specific individual record of said plurality of records and

said pre-processor (1400) is adapted to assign a value for said identifier for identifying said specific data element of said plurality of data elements irrespectively of a value of said identifier for identifying said specific individual record.

8. A system according to claim 5, wherein

said data identifying said relationships comprises a subset of information determining at least one of, (a) an identifier identifying a specific data element of said plurality of data elements is associated with a parent record of said plurality of records, (b) an identifier identifying a specific data element of said plurality of data elements is associated with a child record of said plurality of records, (c) a location in a child record for the start of an identifier for identifying a parent record, and (d) a length of an identifier, for identifying a parent record, and conveyed in a child record.

9. A system according to claim 1, wherein

said data processor (1500) is adapted to store said records comprised in said text file (1100) in said repository (1800) using said data identifying said relationships without parsing said records during storage of said records.

10. A system according to claim 1, wherein

said data processor (1500) is adapted to assign new identifier values to uniquely identify individual records of said plurality of records and incorporates said new identifier values in corresponding individual records of said plurality of records and stores said records in said repository (1800), said new identifier values being separate from record identifier values contained within said records received by said interface processor (1300).

11. A system according to claim 10, further comprising:

a post-processor (1600) for parsing said records stored in said repository (1800) to determine record related information and for storing said record related information in memory, said record related information comprising at least one of, (a) said assigned new identifier values, (b) an identifier for identifying a specific data element of a plurality of data elements associated with a record relationship, (c) identifiers for identifying individual records and (d) an indicator identifying a particular data load operation, from a plurality of different load operations, used to store said records in said repository (1800).

12. A system according to claim 10, further comprising:

a post-processor (1600) for parsing said records stored in said repository (1800) to determine information identifying relationships between said stored records and for storing said information identifying relationships in memory, said information identifying relationships comprising at least one of, (a) an assigned new identifier value associated with a parent record and (b) an assigned new identifier value associated with a child record of said parent record.

13. A system according to claim 10, further comprising:

a search processor (1700) for parsing said records stored in said repository (1800) to determine search information to be usable in searching said stored records and for storing said search information in memory.

14. A system according to claim 10, wherein

said search information is adapted to identify data elements available to be searched and linking information identifying corresponding stored records containing said identified data elements and corresponding locations of said data elements available for search in said corresponding stored records.

15. A system according to claim 14, wherein

in response to a received search command, said search processor (1700) is adapted to parse said stored search information and in response to identification of a data element, determined by search criteria, in said search information, said search processor (1700) provides data identifying a record including said data element determined by said search criteria.

16. A system according to claim 1, wherein

said data processor (1500) is adapted to store said records comprised in said text file (1100) in said repository (1800) as a data string.

17. A system for storing information in a repository (1800), comprising:

an interface processor (1300) for receiving a text file (1100) comprising a plurality of records containing data in character string representative data format;

a data processor (1500) for storing said records comprised in said text file (1100) in a repository (1800) using data identifying relationships, said data identifying relationships comprising at least one key relationship, between records comprised in said text file (1100); and

a search processor (1700) for parsing a reference file (1200) to determine search information to be used in searching said stored records and for storing said search information in memory.

18. A system according to claim 17, wherein

said search information identifies data elements available to be searched and linking information identifying corresponding stored records containing said identified data elements and corresponding locations of said data elements available for search in said corresponding stored records.

19. A system for storing information in a repository (1800), comprising:

an interface processor (1300) for receiving a text file (1100) comprising a plurality of records containing data in character string representative data format;

a data processor ( 1500) for;

assigning new identifier values to uniquely identify individual records of said plurality of records;

incorporating said new identifier values in corresponding individual records of said plurality of records to provide processed records; and

storing said processed records in a repository (1800), said assigned new identifier values being separate from record identifier values contained within said records received by said interface processor (1300); and

a post-processor (1600) for parsing said processed records stored in said repository (1800) to determine record related information and for storing said record related information in memory.

20. A system according to claim 19, wherein

said record related information comprising at least one of, (a) said assigned new identifier values, (b) an identifier for identifying a specific data element of a plurality of data elements associated with a record relationship, (c) identifiers for identifying individual records and (d) an indicator identifying a particular data load operation, from a plurality of different load operations, used to store said records in said repository (1800).

21. A system according to claim 19, wherein

said data processor (1500) stores said records comprised in said text file (1100) in a repository (1800) using data identifying relationships between records comprised in said text file (1100).

22. A method for storing information in a repository (1800), comprising the activities of:

receiving a text file (1100) comprising a plurality of records containing data in character string representative data format;

parsing a reference file (1200) to determine relationships, said relationships comprising key relationships;

storing data identifying said relationships in memory; and

storing said records comprised in said text file (1100) in a repository (1800) using said data identifying said relationships.

23. A method for storing information in a repository (1800), comprising the activities of:

receiving a text file (1100) comprising a plurality of records containing data in character string representative data format;

assigning new identifier values to uniquely identify individual records of said plurality of records, said assigned new identifier values being separate from record identifier values contained within said received records;

incorporating said new identifier values in corresponding individual records of said plurality of records to provide processed records;

storing said processed records in a repository (1800);

parsing a reference file (1200) to determine record related information, said record related information further comprising key information; and

storing said record related information in memory.

24. A method for storing information in a repository (1800), comprising the activities of:

receiving a text file (1100) comprising a plurality of records containing data in character string representative data format;

assigning new identifier values to uniquely identify individual records of said plurality of records, said assigned new identifier values being separate from record identifier values contained within said records as received;

incorporating said new identifier values in corresponding individual records of said plurality of records;

storing said records in a repository (1800); and

parsing a reference file (1200) to determine record related information; and

storing said record related information in memory.

25. A method for converting a database file to a text file (1100) comprising the activities of:

obtaining a database file;

for each record from the database file, transferring the record from the database file to a text file (1100) as a character string, each character string comprising data elements from the record; and

creating a reference file (1200) related to the database file, the reference file (1200) usable for parsing the text file (1100), the reference file (1200) comprising information related to the structure of the database file, the information comprising at least one key relationship.

26. The method of claim 25, wherein the reference file (1200) comprises metadata (1200).

27. A method for updating a composite database file comprising:

obtaining a second text file (1100) comprising a plurality of character strings, each character string corresponding to a record from a second original database file;

obtaining a composite database file, the composite database file created from character strings of a first text file (1100), each character string corresponding to a combination of data elements from a record, the record from a first original database file; and

merging the second text file (1100) contents into the composite database file by providing character strings from the second text file (1100) to the composite database file.

28. The method of claim 27, further comprising:

obtaining a composite database structure file defining relationships in the composite database file;

obtaining a reference file (1200) relatable to the text file (1100), the reference file (1 200) comprising structural data describing records and fields from the text file (1100) and at least one key relationship; and

updating the composite data base structure file responsive to the reference file (1200).