Method for performing a database query in a relational database
AssigneeSiemens Aktiengesellschaft
InventorFrédéric Depreter
Life of this patent
Estimating the term…
Abstract
A method performs a database query in a relational database, the query being carried out by a database engine and being based on user-defined search criteria. The method includes retrieving a number N of properties of a record within a main database table, the number N being higher than zero, creating a search criteria option for each of the N properties, creating a search criteria table for every search criteria option, creating an index for every search criteria table, and performing the database query based on a user-defined combination of a plurality of the search criteria options.
Claims10
A non-transitory computer-readable storage medium with an executable program stored thereon and being organized as a software library, the library being importable in a database software system, wherein the program instructs a microprocessor to perform the steps of:
- retrieve a number N of properties of a record within a main database table, the number N being higher than zero;
- create a search criteria option for each of the N properties;
- create a separate search criteria table for every search criteria option;
- create a separate index table for every search criteria table only once, wherein there is at least one common search criteria option between the index tables;
- present on a user-interface search criteria options for a user to select;
- select the search criteria options for forming a user-defined combination of a plurality of the search criteria options and associated indexes;
- and
- perform the database query based on the user-defined combination of the plurality of the search criteria options and the associated indexes.
A system for performing a database query in a relational database, the database query being carried out by a database engine and being based on user-defined search criteria, the system comprising:
- the relational database having a non-transitory computer-readable storage medium;
- a microprocessor programmed to:
- retrieve a number N of properties of a record within a main database table, the number N being higher than zero;
- create a search criteria option for each of the N properties;
- create a separate search criteria table for every search criteria option;
- create a separate index table for every search criteria table only once, wherein there is at least one common search criteria option between the index tables;
- present on a user-interface search criteria options for a user to select;
- select the search criteria options for forming a user-defined combination of a plurality of the search criteria options and associated indexes;
- and
- perform the database query based on the user-defined combination of the plurality of the search criteria options and the associated indexes.
Dependencies are inferred from the claim text.