Changing table records in a database management system

A system for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• the system comprises:
• a Delta program adapted to generate a dataset DUP of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• a Trigger program adapted, for i=1, 2, . . . , N:
• to step through all records of SiB, including to compare the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset DUP and to save in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset DUP;
• a Bridge program adapted to generate files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• and
• at least one Objectload program in object code form adapted to update the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively.

A system for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• the system comprises:
• a Delta program adapted to generate a dataset DUP of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• a Trigger program adapted, for i=1, 2, . . . , N:
• to step through all records of SiB, including to compare the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset DUP and to save in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset DUP;
• a Bridge program adapted to generate files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• and
• a Sourcegen macroprogram adapted to generate at least one Sourceload program at a source code level, said at least one Sourceload program adapted to being compiled into a corresponding at least one Objectload program in object code form, said at least one Objectload program adapted to update the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively.

A system for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• the system comprises:
• a Delta program adapted to generate a dataset DUP of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• a Trigger program adapted, for i=1, 2, . . . , N:
• to step through all records of SiB, including to compare the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset DUP and to save in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset DUP;
• a Bridge program adapted to generate files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• and
• a Sourcegen macroprogram adapted to generate at least one Sourceload program at a source code level, said at least one Sourceload program adapted to being compiled into a corresponding at least one Objectload program in object code form, said at least one Objectload program adapted to update the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively, such that a read lockout does not occur while T1, T2, . . . , TM are being updated, said T1, T2, . . . , TM stored in a database of a database management system (DBMS) having the read lockout for a data transaction on any table TA in the DBMS if said data transaction on TA is executed through a transaction statement of the DBMS.

A method for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• the method comprises:
• executing a Delta program, including generating a dataset DUP of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• executing a Trigger program, including for i=1, 2, . . . , N:
• stepping through all records of SiB, including comparing the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset DUP and saving in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset DUP;
• executing a Bridge program, including generating files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• and
• executing at least one Load program, including updating the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively.

A method for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• the method comprises:
• executing a Delta program, including generating a dataset DUP of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• executing a Trigger program, including for i=1, 2, . . . , N:
• stepping through all records of SiB, including comparing the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset DUP and saving in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset DUP;
• executing a Bridge program, including generating files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• and
• executing at least one Objectload program, including updating the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively.

A method for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• the method comprises:
• executing a Delta program, including generating a dataset DUP of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• executing a Trigger program, including for i=1, 2, . . . , N:
• stepping through all records of SiB, including comparing the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset DUP and saving in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset DUP;
• executing a Bridge program, including generating files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• executing a Sourcegen macroprogram, including generating at least one Sourceload program at a source code level;
• compiling the at least one Sourceload program into a corresponding at least one Objectload program in object code form;
• and
• executing the at least Objectload program, including updating the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively.

A method for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• the method comprises:
• executing a Delta program, including generating a dataset DUP of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• executing a Trigger program, including for i=1, 2, . . . , N:
• stepping through all records of SiB, including comparing the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset DUP and saving in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset DUP;
• executing a Bridge program, including generating files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• executing a Sourcegen macroprogram, including generating at least one Sourceload program at a source code level;
• compiling the at least one Sourceload program into a corresponding at least one Objectload program in object code form;
• and
• executing the at least Objectload program, including updating the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively, such that a read lockout does not occur while T1, T2, . . . , TM are being updated, said T1, T2, . . . , TM stored in a database of a database management system (DBMS) having the read lockout for a data transaction on any table TA in the DBMS if said data transaction on TA is executed through a transaction statement of the DBMS.

A system for deleting deletion-targeted records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• the system comprises:
• a Delta program adapted to generate a dataset DDEL of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Delete records of SiB relative to SiA, said selected Delete records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• and
• at least one Load program adapted to delete the deletion-targeted records in the tables T1, T2, . . . , TM, each said deletion-targeted record having one of the non-redundant family keyvalues that exists in the dataset DDEL.

A method for deleting deletion-targeted records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• the method comprises:
• executing a Delta program, including generating a dataset DDEL of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Delete records of SiB relative to SiA, said selected Delete records not having any redundant family a keyvalues, for i=1, 2, . . . , N;
• and
• executing at least one Load program, including deleting the deletion-targeted records in the tables T1, T2, . . . , TM, each said deletion-targeted record having one of the non-redundant family keyvalues that exists in the dataset DDEL.

A computer program product, comprising at least one computer usable medium having computer readable program codes embodied therein for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• said computer readable program codes comprising:
• a Delta program adapted to generate a dataset D of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• a Trigger program adapted, for i=1, 2, . . . , N:
• to step through all records of SiB, including to compare the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset D and to save in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset D;
• a Bridge program adapted to generate files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• and
• at least one Load program adapted to update the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively.

A computer program product, comprising at least one computer usable medium having computer readable program codes embodied therein for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• said computer readable program codes comprising:
• a Delta program adapted to generate a dataset D of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• a Trigger program adapted, for i=1, 2, . . . , N:
• to step through all records of SiB, including to compare the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset D and to save in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset D;
• a Bridge program adapted to generate files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• and
• at least one Objectload program in object code form adapted to update the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively.

A computer program product, comprising at least one computer usable medium having computer readable program codes embodied therein for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• said computer readable program codes comprising:
• a Delta program adapted to generate a dataset D of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA,, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• a Trigger program adapted, for i=1, 2, . . . , N:
• to step through all records of SiB, including to compare the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset D and to save in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset D;
• a Bridge program adapted to generate files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• and
• a Sourcegen macroprogram adapted to generate at least one Sourceload program at a source code level, said at least one Sourceload program adapted to being compiled into at least one Objectload program in object code form, said at least one Objectload program adapted to update the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively.

A computer program product, comprising at least one computer usable medium having computer readable program codes embodied therein for updating records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• said computer readable program codes comprising:
• a Delta program adapted to generate a dataset D of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . ,N;
• a Trigger program adapted, for i=1, 2, . . . , N:
• to step through all records of SiB, including to compare the family keyvalue KFVR within each record of SiB against the family keyvalues in the dataset D and to save in a file ΔSi each said record of SiB for which KFVR equals one of the family keyvalues KFV in the dataset D;
• a Bridge program adapted to generate files ΔT1, ΔT2, . . . , ΔTM that includes the data in ΔS1, ΔS2, . . . , ΔSN in a form that is compatible with the M tables T1, T2, . . . , TM, respectively;
• and
• a Sourcegen macroprogram adapted to generate at least one Sourceload program at a source code level, said at least one Sourceload program adapted to being compiled into at least one Objectload program in object code form, said at least one Objectload program adapted to update the tables T1, T2, . . . , TM with the data in ΔT1, ΔT2, . . . , ΔTM, respectively, such that a universal locking does not occur while T1, T2, . . . , TM are being updated, said T1, T2, . . . , TM stored in a database of a database management system (DBMS) having the universal locking for a data transaction on any table TA in the DBMS if said data transaction on TA is executed through a transaction statement of the DBMS.

A computer program product, comprising at least one computer usable medium having computer readable program codes embodied therein for deleting deletion-targeted records in a tableset T of a family, in relation to

• N source files denoted as S1, S2, . . . , SN, said N at least 1, said tableset T having M tables T1, T2, . . . , TM, said M at least 1, said N source files logically associated with said M tables, said family having a common family key KF across the M tables and across the N source files,
• a fileset SA comprising files S1A, S2A, . . . , SNA respectively embodying S1, S2, . . . , SN at a time tA such that T1, T2, . . . , TM at the time tA accurately reflects SA, and
• a fileset SB comprising files S1B, S2B, . . . , SNB respectively embodying S1, S2, . . . , SN at a time tB, said tB and tA being different times,
• said computer readable program codes comprising:
• a Delta program adapted to generate a dataset DDEL of non-redundant family keyvalues embodying KF, each said non-redundant family keyvalue drawn from selected Update records of SiB relative to SiA, said selected Update records not having any redundant family keyvalues, for i=1, 2, . . . , N;
• and
• at least one Load program adapted to delete the deletion-targeted records in the tables T1, T2, . . . , TM, each said deletion-targeted record having one of the non-redundant family keyvalues that exists in the dataset DDEL.