Grouping data in a database

Patent metadata

Field	Value
Publication number	US-9483545-B2
Application number	US-201414291839-A
Country	US
Kind code	B2
Filing date	May 30, 2014
Priority date	May 30, 2014
Publication date	Nov 1, 2016
Grant date	Nov 1, 2016

Abstract

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.

First claim

What is claimed is:

1. A method comprising:
aggregating, by one or more computer processors, two or more attributes included in a plurality of attributes into a group defined by a first data definition language syntax;
wherein 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;
wherein the attribute definition is defined by a second data definition syntax;
wherein the first data definition language syntax includes the second data definition language syntax;
wherein 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; and
wherein the attribute definition defines an attribute as having one or more of a attributeID, associated data type/domain, required data, and default value using a third data definition syntax.

2. A computer program product comprising:
one or more computer readable tangible storage media and program instructions stored on the one or more computer readable tangible storage media, the program instructions executable by one or more processors to aggregate two or more attributes included in a plurality of attributes into a group defined by a first data definition language syntax;
wherein 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;
wherein the attribute definition is defined by a second data definition language syntax;
wherein the first data definition language syntax includes the second data definition syntax;
wherein the first data definition 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; and
wherein the attribute definition defines an attribute as having one or more of a attributeID, associated data type/domain, required data, and default value using a third data definition syntax.

3. A computer system comprising:
one or more computer processors;
one or more computer readable tangible storage media;
program instructions stored on the one or more computer readable tangible storage media for execution by at least one of the one or more computer processors, the program instructions comprising program instructions to aggregate two or more attributes included in a plurality of attributes into a group defined by a first data definition language syntax;
wherein 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,
wherein the attribute definition is defined by a second data definition language syntax;
wherein the first data definition language syntax includes the second data definition syntax;
wherein the first data definition 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, and
wherein the attribute definition defines an attribute as having one or more of a attributeID, associated data type/domain, required data, and default value using a third data definition syntax.

Assignees

• IBM

Inventors

• Bester Karla
• Chandler Allan T
• Shewell Mark A
• Yates Stephen J

Classifications

• G06F17/30289

  Physics · mapped topic

• G06F17/30598 Primary

  Physics · mapped topic

• G06F17/30339

  Physics · mapped topic

• G06F16/21 Primary

  Design, administration or maintenance of databases · CPC title

• G06F16/221

  Column-oriented storage; Management thereof · CPC title