Integrating best practices into database design

• US 20050289115A1
• Filed: 06/28/2004
• Published: 12/29/2005
• Est. Priority Date: 06/28/2004
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Garden, Euan P., Kleinerman, Christian, Raheem, Michael S.
• Application Number:
  US10/878,583
• Publication Number:
  US 20050289115A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/213 with details for schema evolution support

Abstract

Best practice guidelines are integrated into the design of database applications so that it is less likely that inappropriate values are set. A proposed value for a database object may be compared to an archive of best practice guidelines. If the proposed value does not comply with best practice guidelines, a best practice recommendation may be provided, and an opportunity may be provided to change the proposed value to the recommended value before the database object is manipulated or the setting persisted.

Claims

1. A system for integrating a best practice guidelines into a server product design comprising:

a best practices analyzer that receives a proposed object manipulation statement associated with an object manipulation for a server product object and compares the proposed object manipulation statement to a best practice rule for the server product object before performing the object manipulation.

2. The system of claim 1, wherein the best practices analyzer returns a best practice recommendation for the object manipulation.

3. The system of claim 1, wherein in response to determining that the proposed object manipulation statement complies with the best practice rule for the server product object, the object manipulation is performed.

4. The system of claim 1, wherein in response to determining that the proposed object manipulation statement fails to comply with the best practice rule for the server product object, a best practice recommendation is returned.

5. The system of claim 1, further comprising an interface for receiving the proposed object manipulation statement and transferring information associated with the proposed object manipulation statement to an applications programming interface module, the applications programming interface module transferring the information associated with the proposed object manipulation statement to the best practices analyzer.

6. The system of claim 1, further comprising an applications programming interface that transfers a best practice recommendation to a user interface from the best practices analyzer.

7. The system of claim 1, further comprising an applications programming interface that performs the object manipulation.

8. The system of claim 1, wherein the best practices analyzer selects the best practice rule for the server product and applies the best practice rule to the proposed object manipulation statement to determine if the object manipulation complies with a recommended practice.

9. The system of claim 1, further comprising a best practices rules datastore comprising a first rule and a second rule, the first rule comprising the best practice rule for the server product.

10. The system of claim 1, wherein the server product object comprises a portion of a server product and the server product comprises a database.

11. The system of claim 10, wherein the database is a SQL database.

12. The system of claim 1, wherein the proposed object manipulation statement comprises an operation.

13. The system of claim 1, wherein the proposed object manipulation statement comprises a proposed property setting.

14. A method for integrating best practices into a database design comprising:

receiving an object manipulation statement for a database object of a database, the object manipulation statement comprising a value for a property of the database object;

analyzing the object manipulation statement within a context of the database design;

in response to determining that the value complies with a best practice rule for the database object, persisting the value for the property of the database object.

15. A method for integrating best practices into a database design comprising:

receiving an object manipulation statement for a database object of a database, the object manipulation statement comprising a value associated with the database object;

analyzing the object manipulation statement to determine if the value complies with a best practice rule for the database object of the database; and

in response to determining that the value fails to comply with the best practice rule for the database object of the database, providing information associated with the best practice rule before manipulating the database object according to the object manipulation statement.

16. The method of claim 15, wherein the database is a SQL database.

17. The method of claim 15, wherein the object manipulation statement is received by a user interface, the user interface transferring information associated with the object manipulation statement to an applications programming interface.

18. The method of claim 15, wherein a best practice analyzer retrieves information associated with the object manipulation statement from the database.

19. The method of claim 15, wherein an applications programming interface transfers information associated with the object manipulation statement to a best practices analyzer.

20. The method of claim 15, wherein a best practices analyzer selects the best practice rule associated with the database object from a best practice datastore and determines if the value complies with the best practice rule.

21. The method of claim 15, wherein analyzing the object manipulation statement comprises:

selecting the best practice rule associated with the database object of the database.

22. The method of claim 15, further comprising providing an opportunity to modify the value to comply with the best practice rule.

23. The method of claim 15, further comprising persisting the value.

24. A system for analyzing a proposed property setting of a database object to determine if the proposed property setting complies with a best practice rule comprising:

a best practice analyzer that receives the proposed property setting for the database object of a database, and provides a best practice property setting for the database object before persisting the database object.

25. The system of claim 24, further comprising

a user interface for receiving the proposed property setting and sending information associated with the proposed property setting to an applications programming interface.

26. The system of claim 24, further comprising:

an applications programming interface for receiving information associated with the proposed property setting and persisting the proposed property setting in the database.

27. The system of claim 24, further comprising:

a datastore comprising at least one best practice guideline for setting the proposed property setting for the database object within the context of a database.

28. A computer-readable medium comprising computer-readable instructions for:

receiving a proposed property value for a database object in a database;

determining whether the proposed property value complies with an archive of best practice information associated with the database object before the proposed property value is persisted.

29. The computer-readable medium of claim 28, further comprising computer-readable instructions for:

providing information associated with a recommended property value for the database object.

30. The computer-readable medium of claim 28, further comprising computer-readable instructions for:

providing an opportunity to change the proposed property value before the proposed property value is persisted.

31. The computer-readable medium of claim 28, further comprising computer-readable instructions for:

providing an opportunity to override a recommended property setting for the database object.