System and methods for querying a report database
US7640264B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 23, 2005 |
| Grant date | Dec 29, 2009 |
| Priority date | — |
| Expiry date | Aug 4, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99944
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A decision support system including a query generation tool provides a Graphical User Interface (GUI) for generating a query of a Storage Area Network (SAN) database using interactive screen displays identifying manageable entities in the SAN and queryable statistics thereof. Configurations herein provide a query mechanism, or interface, that generates an executable query via a GUI having intuitive mnemonic labels corresponding to the real-world (i.e. SAN manageable entities) represented in the query database, rather than the technical database table and attribute names which tend to be more cryptic, particularly to an uninitiated query operator. The GUI presents a sequence of screens for selecting SAN manageable entities, report fields, selection criteria, and output format. The query logic computes SQL syntax for identifying corresponding database tables and attributes, performing the required joins between the tables, and selecting the report set of records for output in the resulting SQL query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.