Browse Prior Art Database

Maintaining The Integrity Of Proprietary Interfaces To Data Base Management Systems

IP.com Disclosure Number: IPCOM000236731D
Publication Date: 2014-May-13
Document File: 2 page(s) / 23K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a method to prevent corruption in a Database Management System (DBMS) following updates or changes to the associated proprietary interface. The method provides additional DBMS Catalog information regarding proprietary interface module update activity, which permits an additional automatic check to be made.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 55% of the total text.

Page 01 of 2

Maintaining The Integrity Of Proprietary Interfaces To Data Base Management Systems

A method is herein disclosed to employ automated validity checks of Database Management Systems (DBMSs). DBMSs provide proprietary interfaces for customer and vendor use. When changes are made to customer/vendor tools that exploit this interface and the tool is updated, but not correctly implemented in the DBMS, then data corruption occurs. An existing Problem Reporting (PMR) archive database contains many examples of this type of problem.

The disclosed provides additional DBMS Catalog information regarding proprietary interface module update activity. Providing this information permits an additional automatic check to be made, rather than relying solely on manual checking which is subject to user error. DBMSs have catalogs that contain control information about the databases and objects defined to said databases.

The following new information can be stored in the catalog entry for the impacted database's proprietary interface module name entry:


• DEFINED_DATE: the date the customer/vendor interface was last defined to the database and updated by the DBMS database definition process


• LOADED_DATE: the date the customer/vendor interface was last loaded into the DBMS address space and updated by the DBMS system management process

when the proprietary interface module was loaded into the DBMS address space

With these new catalog entries, the DBMS proprietary interface process ca...