Method for extracting data from a relational database using a reduced query
US6976015B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 7, 2001 |
| Grant date | Dec 13, 2005 |
| Priority date | — |
| Expiry date | Dec 6, 2022 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99934
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A database manager and a corresponding method for having a database manager extract information from a relational database having, e.g., a star configuration (i.e. having a hub table and related so-called dimension tables) in response to what is called a joining query (one that would require that dimension tables be joined to the hub table), and, in addition, a query according to the invention. The method includes the steps of: having the database manager provide an alias table for a field from at least one dimension table that would be joined to the hub table according to the joining query, the alias table including each value of the field occurring in the dimension table (the aliased field) and also including an alias for each value of the aliased field; and having the database manager transform the joining query into a reduced query in which the aliased field is replaced by the alias.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.