Method and apparatus for automatic table selection and generation of structured query language instructions
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
May 21, 1996
Grant Date -
N/A
app pub date -
Nov 15, 1993
filing date -
Nov 15, 1993
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A method and apparatus is provided for generating structured query language instructions for communication to a database. In response to receipt of user-supplied input dimensions, an output table is automatically selected that represents the user's query of the relational database. The system automatically identifies and generates the links between data in predefined data tables within the database and the automatically selected output table. From the output table and data links, structured query language instructions are automatically generated. A technique is included to select the minimum number of tables reflective of the input dimensions. Each link between the input data tables and the output table is checked bi-directionally to ensure the integrity of the table selected.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully