System and method for generating horizontal view for SQL queries to vertical database
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Jul 13, 2004
Grant Date -
Jun 12, 2003
app pub date -
Jun 1, 2001
filing date -
Jun 1, 2001
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A database including vertical tables useful for storing large numbers of objects having potentially thousands of attributes in, e.g., e-commerce applications. To support querying the vertical database using conventional SQL, a horizontal view over the underlying vertical tables is defined, and then queries are posed against the view. The queries are automatically transformed and executed against the vertical tables. If desired, the query results can be transformed back to a horizontal format. In this way, it appears to the user that a conventional horizontal data format is being used.
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