Method of designing a database access system and system for updating a database access system

• US 20040249785A1
• Filed: 09/25/2003
• Published: 12/09/2004
• Est. Priority Date: 06/04/2003
• Status: Abandoned Application

• Current Assignee: Thomas Gauweiler
• Original Assignee: Thomas Gauweiler
• Inventors: Gauweiler, Thomas
• Application Number:
  US10/672,230
• Publication Number:
  US 20040249785A1
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method for accessing a database is provided. The method includes creating in a design environment a file that defines a metadata. The metadata relates at least one business object and at least one query. The method also includes communicating the file to a mobile device, storing the file on the mobile device, and transforming the file into a binary structure at an initial run of a computer application running on the mobile device. The binary structure is adapted to be read by the computer application. The method also includes recording the binary structure in a memory of the mobile device. A method for providing database access for a plurality of files with a limited number of database access channels is provided. A method for is provided for accessing a database in a computing environment for a plurality of recordsets. Each of the plurality of recordsets is associated with a database access channel for fetching records of the plurality of recordsets from the database upon occurrence of a preselected event. A method of fetching data for a plurality of active file from a database having a limited number of database connections is provided. A computer readable medium is provided which stores instructions executable by a computer. The instructions include a method for providing database access for a plurality of files with a limited number of database access channels. A device for accessing a database is provided. A system for updating a database access program is provided.

Claims

1. A method, comprising:

(a) creating in a design environment a file that determines a metadata that relates at least one business object and at least one query;

(b) communicating the file to a mobile device;

(c) storing the file on the mobile device;

(d) transforming the file into a binary structure at an initial run of a computer application running on the mobile device, the binary structure adapted to be read by the computer application; and

(e) recording the binary structure in a memory of the mobile device.

2. The method of claim 1, wherein the method is adapted to create a database access system.

3. The method of claim 1, wherein the file is an XML file.

4. The method of claim 1, further comprising:

determining whether the file has been updated upon a startup of the computer application; and

mapping the binary structure by the computer application from the memory if the file has not been updated.

5. The method of claim 4, further comprising storing at least one of a datestamp and a filesize in the memory with the binary structure, the at least one of the datestamp and the filesize uniquely identifying the file corresponding to the binary structure.

6. The method of claim 5, wherein the determining whether the file has been updated includes comparing at least one of a further datestamp and a further filesize of a further file stored on the mobile device with the at least one of the datestamp and the filesize recorded with the binary structure.

7. The method of claim 6, wherein, if the at least one of the further datestamp and the further filesize of the further file stored on the mobile device correspond with the at least one of the datestamp and the filesize recorded with the binary structure, then the file and the further file are identical and the file has not been updated.

8. The method of claim 6, wherein if the at least one of the further datestamp and the further filesize of the further file stored on the mobile device do not correspond with the at least one of the datestamp and the filesize recorded with the binary structure, then the file and the further file are not identical and the file has not been updated.

9. The method of claim 8, further comprising repeating operations (d) and (e) for the further file.

10. The method of claim 1, further comprising:

creating a new file to change the metadata; and

repeating the operations of (b), (c), (d), and (e) for the new file.

11. The method of claim 1, wherein the metadata describes at least one of:

actual data;

at least one attribute for the at least one business object;

at least one relationship between a plurality of business objects; and

the at least one query.

12. The method of claim 1, wherein the mobile device includes at least one of a laptop computer and a personal digital assistant.

13. The method of claim 1, wherein the recording of the binary structure in the memory includes mapping the binary structure into an address space.

14. The method of claim 1, further comprising mapping the binary structure for a subsequent run of the computer application until the file is updated with a new file.

15. A method, comprising:

(a) receiving at a mobile device a file that includes a metadata that relates at least one object and at least one record for a computer application;

(c) storing the file on the mobile device;

(b) converting the file into a binary file at a first running of the computer application; and

(c) mapping the binary file into an address space.

16. The method of claim 15, further comprising recording the binary structure in a memory of the mobile device.

17. The method of claim 16, further comprising reading the binary structure at a second running of the computer application.

18. The method of claim 15, wherein the file is an XML file.

19. The method of claim 15, further comprising:

determining whether the file has been updated upon a startup of the computer application; and

mapping the binary structure by the computer application from the memory if the file has not been updated.

20. A system for updating a database access program, comprising:

a design server including a memory and a processor adapted to create a file that relate a plurality of objects in a computer application and records in a database; and

a mobile device including a processor, a program memory, a database memory, and a communication interface coupled to the network;

wherein the design server is adapted to create the file;

wherein the mobile device is adapted to transform the file into a binary structure at an initial run of a computer application running on the mobile device, the binary structure adapted to be read by the computer application.

21. The system of claim 20, wherein the mobile device is adapted to record the binary structure in the program memory.