US 2018/0322187 A1 · DYNAMIC ALTERNATE KEYS FOR USE IN FILE SYSTEMS UTILIZING A KEYED INDEX

Abstract

In one embodiment, a method for providing alternate keys in a keyed index includes creating a first base record in a keyed index of a database, the first base record including a first unique key and a first data record, wherein the first data record includes at least one sub key and at least one first value, each sub key being correlated with a different one of the at least one first value in a sub key/value pair, and creating one or more alternate key records in the database, each of the alternate key records including one of the at least one sub key which is correlated with the first base record and the first unique key of the first base record. The database adheres to virtual storage access method (VSAM) in some approaches. In other approaches, a number of alternate key records created is equal to a number of first sub keys in the first data record.

Claims19

Dependent claims

A computer program product for providing alternate keys in a keyed index, the computer program product comprising a computer readable storage medium having program code embodied therewith, the program code being readable and/or executable by at least one processor to cause the at least one processor to:

create, by the at least one processor, a first base record in a database, the first base record including a first unique key and a first data record, wherein the first data record comprises at least one sub key and at least one first value, each sub key being correlated with a different one of the at least one first value in a sub key/value pair;
and
create, by the at least one processor, one or more alternate key records in the database, each of the alternate key records including one of the at least one sub key which is correlated with the first base record and the first unique key of the first base record,
wherein a number of alternate key records created is equal to a number of first sub keys in the first data record.

1 more element

create, by the at least one processor, a first base record in a database, the first base record including a first unique key and a first data record, wherein the first data record comprises at least one sub key and at least one first value, each sub key being correlated with a different one of the at least one first value in a sub key/value pair;
and
create, by the at least one processor, one or more alternate key records in the database, each of the alternate key records including one of the at least one sub key which is correlated with the first base record and the first unique key of the first base record,
wherein a number of alternate key records created is equal to a number of first sub keys in the first data record,
wherein the database adheres to virtual storage access method (VSAM).

2 more elements

A method for providing alternate keys in a keyed index, the method comprising:

creating a first base record in a keyed index of a database, the first base record including a first unique key and a first data record, wherein the first data record comprises at least one sub key and at least one first value, each sub key being correlated with a different one of the at least one first value in a sub key/value pair;
and
creating one or more alternate key records in the database, each of the alternate key records including one of the at least one sub key which is correlated with the first base record and the first unique key of the first base record,
wherein the database adheres to virtual storage access method (VSAM),
wherein a plurality of base records are created in the keyed index, and
wherein the keyed index is a key sequence data set (KSDS).

3 more elements

Dependencies are inferred from the claim text.

Dynamic alternate keys for use in file systems utilizing a keyed index

Life of this patent

Dynamic alternate keys for use in file systems utilizing a keyed index

Life of this patent

Abstract

Claims19