Method and Device for Updating a Database, and Computer Program Product

• US 20100094804A1
• Filed: 12/04/2007
• Published: 04/15/2010
• Est. Priority Date: 12/08/2006
• Status: Abandoned Application

• Current Assignee: Continental Automotive GmbH (Continental AG)
• Original Assignee: Continental Automotive GmbH (Continental AG)
• Inventors: Suh, Jong-Hyun, Pfeifle, Martin, Tantz, Uwe, Sasse, Volker
• Application Number:
  US12/518,257
• Publication Number:
  US 20100094804A1
• Time in Patent Office: Days
• US Class Current: 707/609
• CPC Class Codes: G06F 16/23 Updating

Abstract

A database system includes a database management system and a database. The database comprises at least one file to be updated (OLD_FILE) which is stored on a storage device. To update the database, the file to be updated (OLD_FILE) is deleted. A new file (NEW_FILE) from the database with current data is transferred to the storage device using a transfer command (SQL_COPY) which is authored in a database language of the database system.

Claims

1-7. -7. (canceled)

8. A method for updating at least one file of a database of a database system which comprises a database management system and the database, the at least one file being stored in a storage device, the method comprising:

overwriting the at least one file with a new file using a transfer command, the new file comprising current data,

wherein the transfer command is written in a database language of the database system.

9. The method for updating at least one file of a database according to claim 8, further comprising:

determining a difference between the new file and the at least one file to be updated;

performing the steps of overwriting the at least one file to be updated with the new file only if the difference between the new file and the at least one file to be updated is at least a predetermined amount; and

updating the at least one file to be updated based on the new file if the difference between the new file and the at least one file to be updated is at most the predetermined measure wherein the at least one file to be updated is left in the storage device.

10. The method for updating at least one file of a database according to claim 8, further comprising:

deleting the at least one file updated; and

transferring the new file to the storage device if the new file differs from the at least one file to be updated by ten to thirty percent.

11. The method for updating at least one file of a database according to claim 10, wherein the database comprises at least one first and one second file to be updated, the method further comprising:

determining how much the first or the second file to be updated respectively, differs from a first or second new file, respectively; and

based at least in part on the determination;

updating at least one of the first and the second file by overwriting the at least one of the first and the second file with respective first and second new file; and

updating the other of the first and the second file in the storage device.

12. The method for updating at least one file of a database according to claim 10, wherein the at least one file to be updated is at least one of saved and deleted before the overwriting.

14. A computer program product comprising a computer-readable storage medium with program instructions which are arranged for carrying out the method as claimed in claims 8.

15. The method for updating at least one file of a database according to claim 9, wherein the at least one file to be updated is updated one block at a time.

16. The method for updating at least one file of a database according to claim 9, wherein the predetermined amount is 10 to 30 percent.

17. The method for updating at least one file of a database according to claim 9, wherein the predetermined amount is 20 percent.

18. The method for updating at least one file of a database according to claim 9, wherein at least one file is configured to provide data to a navigation device.

13. A device for updating a database file in a database system, the database system that comprises:

a database management system; and

a database, the database comprises at least one file to be updated which is stored in a storage device,

the device configured to overwrite the least one file to be updated with a new file using of a transfer command written in a database language of the database system.

19. The device, for updating data box file, according to claim 13, wherein the database management system is so stored in a memory of a navigation system.