Database access system, method of accessing a database, and method of designing a database access system

• US 20050086203A1
• Filed: 06/04/2003
• Published: 04/21/2005
• Est. Priority Date: 06/04/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Gauweiler, Thomas
• Granted Patent: US 7,685,127 B2
• Time in Patent Office: Days
• US Class Current: 1/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-22. -22. (canceled)

23. A method for providing database access for a plurality of files with a limited number of database access channels, comprising:

receiving a first signal indicating an initiation of a new file;

if a desired number of database access channels is greater than or equal to the limited number of database access channels, determining a respective active file corresponding to each of the database access channels;

sequentially causing each of the active files to access one of a single database record and a plurality of database records until a second signal is received indicating a first active file has accessed all database records; and

reassigning a first database access channel which was assigned to the first active file to the new file.

24. The method of claim 23, wherein the active files are each sequentially caused to access the single database record.

25. The method of claim 23, wherein the active files are each sequentially caused to access the plurality of database records, a number of the plurality of database records accessed by the active files being the same for each access by the active files.

26. A method for providing access to a database in a computing environment for a plurality of recordsets, wherein 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, comprising:

initiating a new recordset;

if a number of the plurality of recordsets is equal to a maximum number of database access channels, sequentially fetching records for each recordset until a first recordset of the plurality of recordsets has fetched all records associated with the first recordset;

assigning the database access channel of the first recordset to the new recordset.

27. A method of fetching data for a plurality of active files from a database having a limited number of database connections, comprising:

(a) assigning each database connection of the limited number of database connections to an active file until one of (i) all of the limited number of database connections have been assigned, and (ii) each active file desiring a database connection has a corresponding assigned database connection;

(b) determining if any active file desiring the database connection does not have the corresponding assigned database connection;

(c) if any active file desiring the one of the limited number of database connections does not have the corresponding assigned database connection, fetching a record for each file from the database on the assigned database connection sequentially until all records for at least one file are fetched; and

reassigning the assigned database connection for the at least one file for which all records have been fetched to another active file that does not have the corresponding assigned database connection.

28-32. -32. (canceled)

33. A computer readable medium, the computer readable medium storing instructions executable by a computer, the instructions including a method for providing database access for a plurality of files with a limited number of database access channels, the method comprising:

receiving a first signal indicating an initiation of a new file;

if a desired number of database access channels is greater than or equal to the limited number of database access channels, determining a respective active file corresponding to each of the database access channels;

sequentially causing each of the active files to access one of a single database record and a plurality of database records until a second signal is received indicating a first active file has accessed all database records; and

reassigning a first database access channel which was assigned to the first active file to the new file.

34-36. -36. (canceled)