Systems and methods for automatic maintenance and repair of enitites in a data model
First Claim
1. A system for analyzing and correcting damage to a database file system (DBFS), the system comprising:
- a computer system configured to effect an operating system that includes a database file system,wherein the database file system includes a logical consistency checker,the logical consistency checker configured to check referential integrity of a set of tables in a database corresponding to said DBFS for at least one logical inconsistency, andcheck structural integrity of a set of entities represented in said DBFS for at least one logical inconsistency,further wherein the logical consistency checker is configured todetect at least one logical inconsistency of a damaged entity,create, by the logical consistency checker when a logical data corruption associated with a damaged entity is detected, a dummy entity that includes at least a portion of information contained in the damaged entity,replace the damaged entity with the dummy entity, andassociate the damaged entity with a broken item folder.
4 Assignments
0 Petitions
Accused Products
Abstract
The present invention is directed a logical consistency checker (LCC) working alone or in conjunction with a physical consistency checker (PCC) and/or a data reliability system (DRS) for a database files system of a hardware/software interface system. Logical data correction pertains to logical data corruptions for entities (e.g., items, extensions, and/or relationships in an item-based operating system, where an item-based operating system is one example of an item-based hardware/software interface system). In this regard, a LCC analyses and corrects logical damage to entities representatively stored in the data store in order to ensure that all such entities in said data store are both consistent and conform to the data model rules.
-
Citations
39 Claims
-
1. A system for analyzing and correcting damage to a database file system (DBFS), the system comprising:
-
a computer system configured to effect an operating system that includes a database file system, wherein the database file system includes a logical consistency checker, the logical consistency checker configured to check referential integrity of a set of tables in a database corresponding to said DBFS for at least one logical inconsistency, and check structural integrity of a set of entities represented in said DBFS for at least one logical inconsistency, further wherein the logical consistency checker is configured to detect at least one logical inconsistency of a damaged entity, create, by the logical consistency checker when a logical data corruption associated with a damaged entity is detected, a dummy entity that includes at least a portion of information contained in the damaged entity, replace the damaged entity with the dummy entity, and associate the damaged entity with a broken item folder. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. An automated data reliability system (DRS) for a database file system (DBFS), said DRS effected by a computer system and comprising:
-
a set of policies for performing database administration (DBA) tasks; a subsystem for resolving a set of physical data corruptions at a page level; and a subsystem for resolving a set of logical data corruptions at an entity level, wherein the subsystem for resolving the set of logical data corruptions is configured to detect at least one logical inconsistency associated with a damaged entity, create, when a logical data corruption on an entity level associated with a damaged entity is detected, a dummy entity that includes at least a portion of information contained in the damaged entity, replace the damaged entity with the dummy entity, and associate the damaged entity with a broken item folder. - View Dependent Claims (10, 11, 12, 13, 14)
-
-
15. A method for analyzing and correcting damage to a database file system (DBFS), said method comprising:
-
checking, by a logical consistency checker of a database file system effected by a computer system, referential integrity of a set of tables in a database corresponding to said DBFS for at least one logical inconsistency; checking structural integrity of a set of relationships represented in said DBFS for at least one logical inconsistency; detecting at least one logical inconsistency associated with the structural integrality of a damaged entity; creating, when a logical data corruption associated with a damaged entity is detected, a dummy entity that includes at least a portion of information contained in the damaged entity; replacing the damaged entity with the dummy entity; and associating the damaged entity with a broken item folder. - View Dependent Claims (16, 17, 18, 19, 20)
-
-
21. A method for an automated data reliability system (DRS) for a database file system (DBFS) to address logical inconsistencies on an entity-level, said method comprising:
-
utilizing a set of policies for performing database administration (DBA) tasks; checking, by the DRS effected by a computer system, if a database file system includes one or more logical inconsistencies at an entity-level, wherein a logical inconsistency includes at least one of a physical data corruption at a page level and a logical data corruption at an entity level; correcting, by the DRS, at least one identified set of physical data corruptions at a page level; creating, by the DRS when a logical data corruption on an entity level associated with a damaged entity is detected, a dummy entity that includes at least a portion of information contained in the damaged entity; replacing the damaged entity with the dummy entity; and associating the damaged entity with a broken item folder. - View Dependent Claims (22, 23, 24, 25, 26)
-
-
27. A computer-readable storage medium comprising computer-readable instructions for analyzing and correcting damage to a database file system (DBFS), said computer-readable instructions comprising instructions for:
-
checking, by a logical consistency checker of a database file system, referential integrity of a set of tables in a database corresponding to said DBFS for at least one logical inconsistency; checking structural integrity of a set of entities represented in said DBFS for at least one logical inconsistency; creating, when a logical inconsistency associated with a damaged item is detected, a dummy item that includes at least a portion of information contained in the damaged item and relationships corresponding to the relationships of the damaged item; replacing the damaged item with the dummy item; and moving the damaged item to a broken item folder. - View Dependent Claims (28, 29, 30, 31, 32)
-
-
33. A computer-readable storage medium comprising computer-readable instructions for an automated data reliability system (DRS) for a database file system (DBFS) to address logical inconsistencies on an entity-level, said computer-readable instructions comprising instructions for:
-
utilizing a set of policies for performing database administration (DBA) tasks; resolving a set of physical data corruptions at a page level; and resolving a set of logical data corruptions at an entity level, wherein the instructions for resolving the set of logical data corruptions include instructions for detecting at least one logical inconsistency associated with a damaged entity, instructions for creating, when a logical inconsistency associated with a damaged item is detected, a dummy entity that includes at least a portion of information contained in the damaged entity, instructions for replacing the damaged entity with the dummy entity, and instructions for associating the damaged entity with a broken item folder. - View Dependent Claims (34, 35, 36, 37, 38)
-
-
39. A hardware control device for an automated data reliability system (DRS) for a database file system (DBFS) to address logical inconsistencies on an entity-level, said device comprising means for:
-
utilizing a set of policies for performing database administration (DBA) tasks;
checking, if a database file system includes one or more logical inconsistencies at an entity-level, wherein a logical inconsistency includes at least one of a physical data corruption at a page level and a logical data corruptions at an entity level;correcting at least one identified set of physical data corruptions at a page level; creating, by the DRS when a logical data corruption on an entity level associated with a damaged entity is detected, a dummy entity that includes at least a portion of information contained in the damaged entity; replacing the damaged entity with the dummy entity; and associating the damaged entity with a broken item folder.
-
Specification