Flexible column selection in relational databases

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 9208214
APP PUB NO 20140280308A1
SERIAL NO

13843220

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

An approach is provided to expand attributes included in an SQL expansion clause into a number of selection statements. In the approach, an expansion clause is identified in within a Structured Query Language (SQL) statement with the SQL statement identifying a relational database table. Column attributes associated with the identified relational database table are compared to attributes included in the identified expansion clause. Columns included in the relational database table are then selected based on the comparison. SQL column selection statements are then generated with each of the generated SQL column selection statements corresponding to one of the selected columns. The generated SQL column selection statements are then included in the SQL statement.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

  • INTERNATIONAL BUSINESS MACHINES CORPORATION

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Chandler, Allan T Floreat, AU 21 196

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation

Maintenance Fees

Fee Large entity fee small entity fee micro entity fee due date
11.5 Year Payment $7400.00 $3700.00 $1850.00 Jun 8, 2027
Fee Large entity fee small entity fee micro entity fee
Surcharge - 11.5 year - Late payment within 6 months $160.00 $80.00 $40.00
Surcharge after expiration - Late payment is unavoidable $700.00 $350.00 $175.00
Surcharge after expiration - Late payment is unintentional $1,640.00 $820.00 $410.00