Relational Compressed Database Images (for Accelerated Querying of Databases)

• US 20080133573A1
• Filed: 12/19/2005
• Published: 06/05/2008
• Est. Priority Date: 12/24/2004
• 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, Mihatsch, Oliver
• Application Number:
  US11/793,802
• Publication Number:
  US 20080133573A1
• Time in Patent Office: Days
• US Class Current: 707/102
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence

Abstract

The invention relates to a data bank interrogation system, wherein two or more data bank tables are linked by means of a common key or several keys which are respectively common to at least two data bank tables. In an analysis query and a selection of data sets in the first data bank, a selection of data sets is determined in the second data bank corresponding to the selection according to the common key and the analysis query is answered using the thus selected data sets in the second data bank.

Claims

1. A database query system having

a first database image of a first database table containing a first multiplicity of data records and a second database image of a second database table containing a second multiplicity of data records, where each data record in the first multiplicity of data records and each data record in the second multiplicity of data records has an associated value for a database key;

an input device which is set up to receive an analysis query to the second database image;

a selection device which is set up to select a portion of the first multiplicity of data records in line with a first selection;

an ascertainment device which is set up to ascertain a second selection of a portion of the second multiplicity of data records, wherein in accordance with the second selection such data records are selected which have associated values for the database key which are respectively associated with at least one data record which has been selected in line with the first selection;

a processing device which is set up to ascertain the result of the analysis query on the basis of the portion of the second multiplicity of data records.

2. The database query system as claimed in claim 1, where the first database image and the second database image are produced in line with a statistical model.

3. The database query system as claimed in claim 2, where the statistical model is a graphical probability model.

4. The database query system as claimed in claim 1, where the input device is also set up to receive a selection instruction, and the selection device is set up to select the portion of the first multiplicity of data records in line with the selection instruction.

5. The database query system as claimed in claim 4, which also has a display device which is set up to show a screen display which comprises the display of possible values for at least one random variable for which each of the first multiplicity of data records contains a value, and the selection instruction is the selection of the display of at least one possible value for the random variable, and the first selection involves all the data records in the first multiplicity of data records being selected which comprise the selected at least one possible value.

6. The database query system as claimed in claim 5, where the display device is also set up to show a further screen display which comprises a display of the result of the analysis query, and where the display device is also set up to change between the screen display and the further screen display.

7. The database query system as claimed in claim 1, also having an access device which is set up to access the second database table and to ascertain data which are contained in the second database table'"'"'s data records selected in line with the second selection, and where the processing device is set up to ascertain the result of the analysis query using the data.

8. The database query system as claimed in claim 1, where the first database image groups the first multiplicity of data records to form a first plurality of segments and the second database image groups the second multiplicity of data records to form a second plurality of segments.

9. The database query system as claimed in claim 8, where the value of the database key for a data record in the first database image comprises a number for the segment which contains the data record and a number for the data record in line with numbering of the data records in the segment.

10. The database query system as claimed in claim 9, where the value of the database key for a data record in the second database image comprises a number for the segment which contains the data record and a number for the data record in line with numbering of the data records in the segment.

11. The database query system as claimed in claim 10, where each data record in the first multiplicity of data records has the value of the database key stored for it in the first database table and each data record in the second multiplicity of data records has the value of the database key stored for it in the second database table.

12. A method for computer-aided database querying using a first database table containing a first multiplicity of data records and a second database table containing a second multiplicity of data records, where each data record in the first multiplicity of data records and each data record in the second multiplicity of data records has an associated value for a database key, having the following steps:

an analysis query to the second database table is received;

a portion of the first multiplicity of data records is selected in line with a first selection;

a second selection of a portion of the second multiplicity of data records is ascertained, wherein in accordance with the second selection such data records are selected which have associated values for the database key which are also respectively associated with at least one data record which has been selected in line with the first selection;

the result of the analysis query is ascertained on the basis of the portion of the second multiplicity of data records.