System and methods for querying a report database

Details System and methods for querying a report database System and methods for querying a report database

2005-09-23

2009-12-29

Pham, Khanh B (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C709S219000, C709S229000

Reexamination Certificate

active

07640264

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.

REFERENCES:
patent: 5774692 (1998-06-01), Boyer et al.
patent: 5893125 (1999-04-01), Shostak
patent: 5894311 (1999-04-01), Jackson
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 6134540 (2000-10-01), Carey et al.
patent: 6148296 (2000-11-01), Tabbara
patent: 6691100 (2004-02-01), Dector et al.
patent: 6907422 (2005-06-01), Predovic
patent: 2004/0122844 (2004-06-01), Malloy et al.
patent: 2005/0119996 (2005-06-01), Ohata et al.
patent: 2006/0031187 (2006-02-01), Pyrce et al.
patent: 2007/0083403 (2007-04-01), Baldwin et al.

Affiliated with

Also associated with

Rating

System and methods for querying a report database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and methods for querying a report database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and methods for querying a report database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4084163