Invention Grant
- Patent Title: Flexible column selection in relational databases
- Patent Title (中): 关系数据库中灵活的列选择
-
Application No.: US13843220Application Date: 2013-03-15
-
Publication No.: US09208214B2Publication Date: 2015-12-08
- Inventor: Allan T. Chandler
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Van Leeuwen & Van Leeuwen
- Agent Thomas E. Tyson
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
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.
Public/Granted literature
- US20140280308A1 Flexible Column Selection in Relational Databases Public/Granted day:2014-09-18
Information query