OPTIMIZATIONS FOR A BACKGROUND DATABASE CONSISTENCY CHECK

• US 20080222150A1
• Filed: 03/06/2007
• Published: 09/11/2008
• Est. Priority Date: 03/06/2007
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Stonecipher, Ryan Lindsey
• Granted Patent: US 7,711,716 B2
• Time in Patent Office: Days
• US Class Current: 707/8
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity

Abstract

Two features allow for increased performance in running database consistency checks. First, a database consistency check runs directly on a database, as opposed to running on a saved database snapshot. This saves memory since there is no need to save a database snapshot. To handle any pages modified since a start of the database consistency check, a supplemental check runs on modified pages. Any facts generated by either check run through an early aggregation that attempts to aggregate facts during the database consistency check.

Claims

1. A system, comprising:

a database component that stores information; and

a database check component that performs a consistency check on information stored in the database component without creation or utilization of a database snapshot.

2. The system of claim 1, further comprising a supplemental check component that runs a consistency check on any pages from the database component that are modified during running of the database consistency check, and generates facts for modified pages.

3. The system of claim 1, further comprising an optimization component that determines an appropriate time to run the consistency check.

4. The system of claim 1, further comprising a notification component that notifies a potential page modifier that the consistency check is taking place.

5. The system of claim 1, further comprising a report component that reports results from the consistency check.

6. The system of claim 1, further comprising a repairing component that repairs errors discovered by the database consistency check.

7. The system of claim 1, further comprising a sampling component that initiates the database check component to run a sample consistency check.

8. The system of claim 1, further comprising a link component that allows the consistency check to run on information in a plurality of database components in a plurality of servers.

9. A system, comprising:

a database check component that generates facts about pages stored in a database component; and

an early aggregation component that aggregates the facts at least partially during operation of the database check component.

10. The system of claim 9, further comprising a maximization component that selects a combined operation of fact generation and any aggregation.

11. The system of claim 9, further comprising an expression component that selects a sorted arrangement to store non-aggregated facts.

12. The system of claim 9, further comprising a compression component that compresses the facts.

13. The system of claim 9, further comprising a link component that allows the consistency check to run on information in a plurality of database components in a plurality of servers.

14. The system of claim 9, further comprising a link component that allows the aggregation of facts from a plurality of sources.

15. A method, comprising:

running a database consistency check that generates facts about a database; and

grouping the facts during running of the database consistency check.

16. The method of claim 15, wherein the database consistency check runs on a database.

17. The method of claim 16, further comprising running a supplemental consistency check that executes upon database pages modified during running of the database consistency check.

18. The method of claim 15, further comprising determining an optimal time to run a database consistency check.

19. The method of claim 15, further comprising storing non-aggregated facts in a sorted configuration.

20. The method of claim 15, further comprising reporting facts that were not aggregated by the early aggregation component.