中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

15 records (took 0.018 seconds)

    1.
    发明专利
    未知

    公开(公告)号：DE68929132T2

    公开(公告)日：2000-07-13

    申请号：DE68929132

    申请日：1989-07-12

    Applicant: IBM

    Inventor： HADERLE DONALD JAMES ,  WATTS JULIE ANN

    IPC: G06F9/00 ,  G06F17/30 ,  G06F12/00

    Abstract: A method is disclosed for deferring enforcement of referential constraints in large-scale data base operations such as the population or loading of relational tables 10, 12. First, the new rows are loaded in a Data Load phase 24 into the tables, and information on the new rows and their constraints is extracted and sorted 26 into a sorted key data set 68. Any primary indexes 22 required for constraint checking are then updated 28 using the sorted key data set. The new rows are then checked 70 for constraint violations, such violations are rectified 72 to restore the table's referential integrity, and a deletion data set 80 is produced. The deletion data set is merged and sorted 86 with row information 53 stored during loading, and the result is used to copy 88 the new rows violating referential constraints to a separate discard data set 48 where they can be corrected and reloaded into the table. Finally, an error summary report 36 is generated for use in correcting the discard data set.

    2.
    发明专利
    未知

    公开(公告)号：DE68926422D1

    公开(公告)日：1996-06-13

    申请号：DE68926422

    申请日：1989-07-12

    Applicant: IBM

    Inventor： CRUS RICHARD ANTHONY ,  DOCKTER MICHAEL JON ,  ENGLES ROBERT WILLIAM ,  HADERLE DONALD JAMES

    IPC: G06F12/00 ,  G06F7/00 ,  G06F17/30

    Abstract: An implementation of referential integrity in which descriptions of referential constraints are compiled into meta-data descriptions of the constraint rules and specifications. The meta-data descriptions of the constraints are stored in the form of objects called relationship descriptors. Each relationship descriptor contains a complete description of a referential constraint, either directly or by means of pointers to other objects such as record and index descriptors which contain information comprised in the constraint's specification. The relationship descriptors are linked into two types of chains by symbolic pointers. One type of relationship descriptor chain connects all relationship descriptors which have a common parent table. The other type of relationship descriptor chain connects relationship descriptors with common dependent tables. Both types of chains are anchored in respective fields in the tables' record descriptors. The use of meta-data descriptors facilitates both ready modification of the constraints, and speedy enforcement of the constraints by a single, shared procedure which may be embedded in the data base manager.

    4.
    发明专利
    未知

    公开(公告)号：DE68929132D1

    公开(公告)日：2000-02-10

    申请号：DE68929132

    申请日：1989-07-12

    Applicant: IBM

    Inventor： HADERLE DONALD JAMES ,  WATTS JULIE ANN

    IPC: G06F9/00 ,  G06F17/30 ,  G06F12/00

    Abstract: A method is disclosed for deferring enforcement of referential constraints in large-scale data base operations such as the population or loading of relational tables 10, 12. First, the new rows are loaded in a Data Load phase 24 into the tables, and information on the new rows and their constraints is extracted and sorted 26 into a sorted key data set 68. Any primary indexes 22 required for constraint checking are then updated 28 using the sorted key data set. The new rows are then checked 70 for constraint violations, such violations are rectified 72 to restore the table's referential integrity, and a deletion data set 80 is produced. The deletion data set is merged and sorted 86 with row information 53 stored during loading, and the result is used to copy 88 the new rows violating referential constraints to a separate discard data set 48 where they can be corrected and reloaded into the table. Finally, an error summary report 36 is generated for use in correcting the discard data set.

    7.
    发明专利
    未知

    公开(公告)号：DE3781577T2

    公开(公告)日：1993-04-08

    申请号：DE3781577

    申请日：1987-01-02

    Applicant: IBM

    Inventor： CRUS RICHARD ANTHONY ,  HADERLE DONALD JAMES ,  HERRON HOWARD WINSTON

    IPC: G06F9/46 ,  G06F12/00

    Abstract: A method utilizing a coordinated pair of locking limits for managing concurrency and lock granularity tradeoff relations. A first limit is placed on the number of small granularity locks per resource. A second limit is placed on the number of locks assignable to each process. When the first number of small locks is reached, the method withdraws the small locks and grants only one lock to the entire resource (lock escalation). When a process requests an additional lock over the second limit, the lock is refused.

Patent Agency Ranking