STRUCTURE-SPECIFIC RECORD COUNT DATABASE OPERATIONS
Methods and systems are disclosed to perform record counts of particular structures without causing database-wide locking to occur while such counting is being performed. A Data Definition Language (“DDL”) syntax referred to as RECORDCOUNT is specified at the structure level to enable a particular structure to be locked for performance of record count operations without locking the global dataset record. Updates or deletions/insertions to other structures can still be made by locking the structures associated with the RECORDCOUNT operation and not the global dataset. Further, the RECORDCOUNT option can be added to existing structures to enable structure-specific locking for performance of record counts.
1 . A computer-implemented method for creating a database comprising a first database structure, the first database structure comprising a Data Definition Language (“DDL”) syntax for RECORDCOUNT, wherein RECORDCOUNT provides for structure-specific locking while performing a record count database operation, the method comprising:
adding a record to the first database structure, wherein the first database structure comprises at least one record;
determining if RECORDCOUNT is activated for the first database structure; and
if RECORDCOUNT is activated for the first database structure:
locking the first database structure;
counting the records in the first database structure to determine a total number of records in the first database structure; and
providing the total number of records counted.
2 . The method of claim 1 , further comprising:
providing a timestamp with the providing of the total number of records counted, wherein the timestamp identifies a time value of when the total number of records in the first database structure was determined.
3 . The method of claim 1 , further comprising:
maintaining a second database structure, wherein the second database structure comprises a plurality of records; and
not locking the second database structure while locking the first database structure.
4 . The method of claim 3 , wherein RECORDCOUNT is stored in a control file.
5 . The method of claim 3 , wherein the determining if RECORDCOUNT is activated for the first database structure comprises:
determining if RECORDCOUNT=TRUE.
6 . The method of claim 3 , further comprising:
determining a value for RECORDCOUNT is corrupted;
checking the value for RECORDCOUNT by employing a CHECKRECORDCOUNT option to provide a CHECKRECORDCOUNT value; and
if the value for RECORDCOUNT and the value for CHECKRECORDCOUNT differ:
displaying the value for RECORDCOUNT and the value for CHECKRECORDCOUNT;
receiving a selection of the RECORDCOUNT value or the CHECKRECORDCOUNT value; and
updating the RECORDCOUNT value.
7 . The method of claim 1 , further comprising:
if RECORDCOUNT is not activated for the first database structure:
locking a global structure of the database; and
completing a count of the records.
8 . The method of claim 7 , wherein RECORDCOUNT is not activated for the first database structure if RECORDCOUNT =FALSE.
9 . A computer system for performing structure-specific locking for a record count database operation by a database, the computer system comprising:
at least one processing unit; and
memory storing computer executable instructions that, when executed by the at least one processing unit, perform a method of:
defining a Data Definition Language (“DDL”) syntax for RECORDCOUNT which operates on a first structure in the database, wherein the first structure comprises at least a first record;
adding a second record to the first structure;
determining if RECORDCOUNT is enabled for the first structure; and
if RECORDCOUNT is enabled for the first structure:
locking the first structure;
determining a total number of records in the first structure;
providing the total number of records in the first structure; and
providing a timestamp identifying a time value of when the total number of records in the first structure was determined.
10 . The system of claim 9 , further comprising:
providing a datestamp with the returning of the total number of records in the first structure, wherein the datestamp identifies a date value of when the total number of records in the first structure was determined.
11 . The system of claim 9 , further comprising:
maintaining a second structure, wherein the second structure comprises a plurality of records; and
not locking the second structure while locking the first structure.
12 . The system of claim 9 , wherein RECORDCOUNT is stored in a control file.
13 . The system of claim 9 , wherein the determining if RECORDCOUNT is enabled for the first structure comprises:
determining if RECORDCOUNT=TRUE.
14 . The system of claim 9 , wherein RECORDCOUNT is not enabled for the first structure if RECORDCOUNT=FALSE.
15 . The system of claim 14 , further comprising:
if RECORDCOUNT is not activated for the first structure:
locking a global structure of the database.
16 . The system of claim 9 , further comprising:
determining a value for RECORDCOUNT is corrupted;
checking the value for RECORDCOUNT by employing a CHECKRECORDCOUNT option to provide a CHECKRECORDCOUNT value; and
if the value for RECORDCOUNT and the value for CHECKRECORDCOUNT differ:
displaying the value for RECORDCOUNT and the value for CHECKRECORDCOUNT;
receiving a selection of the RECORDCOUNT value or the CHECKRECORDCOUNT value; and
updating the RECORDCOUNT value.
17 . A non-transitory computer readable medium comprising a database function for counting records, the database function comprising the following:
function syntax, wherein the function syntax comprises a string specifying the name RECORDCOUNT, and wherein RECORDCOUNT comprises instructions to count a number of records in a first structure, the instructions, when executed:
locking the first structure;
counting the number of records in the first structure;
providing the number of records in the first structure; and
providing a timestamp identifying a time of performance of the counting of the number of records in the first structure;
activation syntax, wherein the activation syntax comprises a value to cause at least one processing unit to perform the function RECORDCOUNT; and
structure syntax, wherein the structure syntax defines a database structure upon which the RECORDCOUNT function executes.
18 . The computer readable medium of claim 17 , wherein the value for the activation syntax comprises TRUE to indicate that the RECORDCOUNT function is activated.
19 . The computer readable medium of claim 17 , wherein the value for the activation syntax comprises FALSE to indicate that the RECORDCOUNT function is not activated.
20 . The computer readable medium of claim 17 , wherein the function syntax is a Data Definition Language (“DDL”) syntax, and wherein RECORDCOUNT is a structure physical option.