Database query system using a statistical model of the database for an approximate query response

• US 20070168329A1
• Filed: 12/17/2003
• Published: 07/19/2007
• Est. Priority Date: 05/07/2003
• Status: Abandoned Application

• Current Assignee: Panoratio Database Images GmbH (Panoratio Holdings, Inc.)
• Original Assignee: Panoratio Database Images GmbH (Panoratio Holdings, Inc.)
• Inventors: Hofmann, Reimar, Haft, Michael
• Application Number:
  US10/555,887
• Publication Number:
  US 20070168329A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2462 Approximate or statistical queries
• CPC Class Codes: G06F 16/30 of unstructured textual data document management systems G06F16/93

Abstract

The invention relates to a data base query system which is characterized in that once the database query is drawn up, a compressed image of the database to be queried is queried in accordance with the database query. Depending on the result of the query of the compressed image an inspection is made whether the result is sufficient and if the result is not sufficient, the database itself is queried in accordance with the database query.

Claims

1. A database query system, having

at least one first device that has stored a database, the database containing a multiplicity of data,

at least one second device that stores a compressed image of at least one portion of the contents of the database, and

a query unit that is coupled to the first device and to the second device and is set up in such a way that it can carry out querying of the contents of the compressed image and querying of the contents of the database.

2. The database query system as claimed in claim 1, in which a statistical image is stored in the second device as a compressed image.

3. The database query system as claimed in claim 2, in which a statistical model is stored in the second device as the statistical image.

4. The database query system as claimed in claim 2 or 3, in which in addition at least one portion of the data stored in the database is stored in compressed form in the second device.

5. The database query system as claimed in one of claims 1 to 4, having at least one client computer that is coupled to the query unit and is set up in such a way that it undertakes database requests or database queries.

6. The database query system as claimed in one of claims 1 to 5, in which the query unit is set up for communicating in accordance with open database connectivity or java database connectivity.

7. The database query system as claimed in one of claims 1 to 6, in which the query unit is set up for processing database queries in accordance with Standard Query Language or in accordance with known OLAP interfaces (ODBO).

8. The database query system as claimed in one of claims 1 to 7, having a plurality of databases that are coupled to the query unit.

9. The database query system as claimed in one of claims 1 to 8, in which the database has a plurality of database segments, and in which a compressed image is provided for each database segment.

10. The database query system as claimed in one of claims 5 to 9, in which the second device is implemented in the client computer.

11. The database query system as claimed in one of claims 1 to 9, in which the first device and the second device are implemented jointly in a computer.

12. A method for computer-aided querying of a database that contains a multiplicity of data,

in which a database query is formed,

in which the compressed image of the database is queried in accordance with the database query,

in which it is checked independently of the result of the query of the compressed image whether the result is sufficient,

in which the database is queried in accordance with the database query or in accordance with another database query in the case when the result is not sufficient, and

in which the result of the query of the compressed image and/or the result of the query of the database are/is provided.