发明名称 |
GROUPING DATA IN A DATABASE |
摘要 |
According to embodiments of the present invention, two or more attributes that are included in a plurality of attributes are aggregated into a group defined by a first data definition language syntax. The first data definition language syntax defines the group as having a groupID and one or more of an attribute definition defined in a comma-separated list and a group definition. The attribute definition is defined by a second data definition syntax. The first data definition language syntax includes the second data definition language syntax. The first data definition language syntax is structured in a manner to allow a database operation associated with the group to be applied to all attributes and/or groups included therein. |
申请公布号 |
US2016171086(A1) |
申请公布日期 |
2016.06.16 |
申请号 |
US201615053205 |
申请日期 |
2016.02.25 |
申请人 |
International Business Machines Corporation |
发明人 |
Bester Karla;Chandler Allan T.;Shewell Mark A.;Yates Stephen J. |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A method comprising:
providing a table in a relational database, with the table comprising a plurality of columns; defining a group of columns; receiving user input; responsive to the user input, adding, by machine logic, a first column of the plurality of columns to the group; adding, by machine logic, a second column of the plurality of columns to the group based on predetermined selection criteria; and receiving an SQL (Structured Query Language) statement using group names corresponding to the group of columns to perform actions on the columns of the group. |
地址 |
Armonk NY US |