System and method for browsing database schema information
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
May 27, 2003
Grant Date -
N/A
app pub date -
Nov 1, 1999
filing date -
Nov 1, 1999
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A query object generator tool which generates interface definitions and code that implement a query object also generates a database schema access query object that retrieves the schema of an underlying database. Instead of retrieving data from the database, the database schema access query object retrieves 'metadata', including the names of tables and stored procedures in the database and their descriptions, from the database. The metadata is then displayed as part of a graphic user interface which is used to construct the SQL query implemented by the query object. In accordance with one embodiment of the invention, the database schema access object also verifies that an SQL query generated by a user is valid by submitting the query to the database engine of the underlying database. In accordance with another embodiment of the invention the database schema access object contains methods which perform automatic mapping of 'standard' SQL data types to vendor-specific data.
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