Managing data within a temporal relational database management system

Patent metadata

Field	Value
Publication number	US-10007718-B2
Application number	US-201615075172-A
Country	US
Kind code	B2
Filing date	Mar 20, 2016
Priority date	Sep 12, 2015
Publication date	Jun 26, 2018
Grant date	Jun 26, 2018

Abstract

Disclosed aspects include a temporal relational database management system initiating a set of operations. A set of columns in a transaction time temporal table is identified for change categorization. A change categorization model is constructed. The change categorization model is based on a set of changes with respect to the set of columns in the transaction time temporal table. The change categorization model uses a cluster analysis technique. Based on the change categorization model, a group of change categories for a set of rows coupled with the set of columns in the transaction time temporal table is determined. Based on the change categorization model, a first change category of the group of change categories is established in a first row of the set of rows.

First claim

What is claimed is:

1. A system for managing data within a temporal relational database management system, the system comprising:
a memory having a set of computer readable computer instructions, and
a processor for executing the set of computer readable instructions, the set of computer readable instructions including:
identifying, by the temporal relational database management system, a set of columns in a transaction time temporal table for change categorization;
constructing, by the temporal relational database management system, a change categorization model, wherein the change categorization model is based on a set of changes with respect to the set of columns in the transaction time temporal table and uses a cluster analysis technique;
determining, by the temporal relational database management system based on the change categorization model, a group of change categories for a set of rows coupled with the set of columns in the transaction time temporal table; and
establishing, by the temporal relational database management system based on the change categorization model, a first change category of the group of change categories in a first row of the set of rows.

2. The system of claim 1 , further comprising:
receiving, by the temporal relational database management system, a change request for a second row of the set of rows; and
establishing, by the temporal relational database management system based on the change categorization model, a second change category of the group of change categories in the second row of the set of rows.

3. The system of claim 1 , further comprising:
receiving, by the temporal relational database management system, a request for a new row which is coupled with the set of columns in the transaction time temporal table; and
establishing, by the temporal relational database management system based on the change categorization model, a second change category of the group of change categories in the new row.

4. The system of claim 1 , wherein the set of columns includes a selection from a group consisting of at least one of: a set of numerical values, a set of free text, or a set of unstructured data.

5. The system of claim 1 , further comprising:
computing a set of delta images based on the set of changes with respect to the set of columns in the transaction time temporal table, wherein the set of delta images includes a magnitude of change for the set of columns.

6. The system of claim 5 , further comprising:
calculating a set of differences based on the set of changes with respect to the set of columns in the transaction time temporal table, wherein the set of differences include at least one of: a mathematical difference or a statistical difference.

7. The system of claim 5 , further comprising:
transforming the set of columns into a term vector of term frequency-inverse document frequency (TF-IDF) weights; and
using the term vector of term frequency-inverse document frequency (TF-IDF) weights to compute the set of delta images.

8. The system of claim 5 , further comprising:
normalizing the set of delta images using a statistical analysis technique.

9. The system of claim 5 , further comprising:
caching the set of delta images in the temporal relational database management system.

10. The system of claim 1 , wherein the cluster analysis technique groups the set of changes by similarity using a selection from a group consisting of at least one of: a k-means technique, a singular value decomposition (SVD) technique, a clustering using representatives (CURE) technique, a Bradley-Fayyad-Reina (BFR) technique, or a restricted Boltzmann machine (RBM) neural network technique.

11. The system of claim 1 , further comprising:
generating, using the cluster analysis technique, a set of clusters based on the set of changes with respect to the set of columns in the transaction time temporal table; and
mapping, based on the set of clusters, the set of rows to the group of change categories.

12. The system of claim 1 , further comprising:
providing to a user, by the temporal relational database management system, the first change category of the group of change categories in the first row of the set of rows.

13. The system of claim 1 , further comprising:
predicting a change category of the group of change categories for a row of the set of rows; and
receiving a change request which requests changes to a plurality of the set of columns.

14. The system of claim 1 , wherein the transaction time temporal table includes both a first table and a second table, and wherein establishing the first change category of the group of change categories in the first row of the set of rows includes:
establishing the first change category of the group of change categories in a first row of a set of rows of the first table, and
establishing a second change category of the group of change categories in a first row of a set of rows of the second table.

15. The system of claim 1 , further comprising:
computing a set of delta images based on the set of changes with respect to the set of columns in the transaction time temporal table, wherein the set of delta images includes a magnitude of change for the set of columns;
normalizing the set of delta images using a statistical analysis technique; and
caching the set of delta images in the temporal relational database management system.

16. The system of claim 1 , further comprising:
generating, using the cluster analysis technique, a set of clusters based on the set of changes with respect to the set of columns in the transaction time temporal table;
mapping, based on the set of clusters, the set of rows to the set of change categories;
predicting a change category of the group of change categories for a row of the set of rows;
receiving a change request which requests changes to a plurality of the set of columns; and
providing to a user, by the temporal relational database management system, the first change category of the group of change categories in the first row of the set of rows.

17. A computer program product for managing data within a temporal relational database management system, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:
identifying, by the temporal relational database management system, a set of columns in a transaction time temporal table for change categorization;
constructing, by the temporal relational database management system, a change categorization model, wherein the change categorization model is based on a set of changes with respect to the set of columns in the transaction time temporal table and uses a cluster analysis technique;
determining, by the temporal relational database management system based on the change categorization model, a group of change categories for a set of rows coupled with the set of columns in the transaction time temporal table; and
establishing, by the temporal relational database management system based on the change categorization model, a first change category of the group of change categories in a first row of the set of rows.

18. The computer program product of claim 17 , wherein:
the set of columns includes a first selection from a first group consisting of at least one of: a set of numerical values, a set of free text, or a set of unstru

Assignees

• IBM

Inventors

• Charron David S
• Gilbertson Kyle E
• Konik Rafal P
• Lawrence Nicholas T

Classifications

• G06F17/30598 Primary

  Physics · mapped topic

• G06F17/30292

  Physics · mapped topic

• G06F17/30339

  Physics · mapped topic

• G06F17/30345

  Physics · mapped topic

• G06F17/30551

  Physics · mapped topic