Reentrant database object wizard

• US 20060085380A1
• Filed: 10/19/2004
• Published: 04/20/2006
• Est. Priority Date: 10/19/2004
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Lasker, Steven M., Cote, Antoine, Yuknewicz, Paul J.
• Granted Patent: US 7,620,644 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 8/20 Software design
• CPC Class Codes: G06F 9/453 Help systems
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A system and method for a reentrant database object wizard is provided. The system provides the ability to compare a currently generated dataset to the objects of the underlying database. Columns and tables that are not common between both the dataset and the database are visually displayed for the user to make a decision on inclusion or exclusion. In addition, columns and tables that were previously within the dataset that are no longer available on the database connection are displayed, for example, with warning icons so that the user can either resolve the missing column or table within the database, or remove the column/table from their typed dataset. The system includes a comparison component and a display component. The comparison component provides comparison information based upon a comparison of a dataset to an associated database. The display component displays the comparison information. The system can further, optionally, include an input component which can be employed by a user to provide information associated with the user'"'"'s decision on inclusion and/or exclusion of column(s) and/or table(s) to the system. Thereafter, based upon the user'"'"'s input, the system can provide can provide based upon a comparison of the modified dataset to the associated database.

Claims

1. A reentrant database object wizard system comprising:

a comparison component that provides comparison information based upon a comparison of a dataset to an associated database; and

,

a display component that displays the comparison information.

2. The system of claim 1, the comparison information comprising identification of at least one of a column and a table that is not common between the dataset and the database.

3. The system of claim 1, further comprising an input component that facilitates modification of the dataset by a user.

4. The system of claim 3, the comparison component providing comparison information based upon a comparison of the modified dataset to the associated database.

5. The system of claim 4, the display component displays the comparison information based upon the comparison of the modified dataset to the associated database.

6. The system of claim 4, the display component displays information regarding a change that occurred as a result of a user.

7. The system of claim 6, the information displayed regarding the change comprising at least one of a list of table(s), stored procedure(s), function(s) and view(s) that were added.

8. The system of claim 6, the information displayed regarding the change comprising a column that was added to a table.

9. The system of claim 6, the information displayed regarding the change comprising at least one of a list of table(s), stored procedure(s), function(s) and view(s) that were removed.

10. The system of claim 6, the information displayed regarding the change comprising a column that was removed from a table.

11. The system of claim 1, the comparison information displayed by the display component in a hierarchical view.

12. The system of claim 1, the comparison information displayed by the display component comprising a tri-state checkbox for an item, the tri-state checkbox toggles between an include state, an exclude state and a leave in current state.

13. A method facilitating a reentrant database object wizard comprising:

comparing information associated with a dataset to information associated with a database; and

,

providing information associated with the comparison to a user.

14. The method of claim 13, further comprising:

determining whether the user has made a change to the dataset; and

,

if the user has made a change to the dataset, comparing information associated with the modified dataset to information associated with the database; and

,

providing information associated with the comparison to the user.

15. The method of claim 13, the information associated with the comparison comprising identification of at least one of a column and a table that is not common between the dataset and the database.

16. The method of claim 13, the comparison information displayed in a hierarchical view.

17. The method of claim 13, the comparison information displayed with a tri-state checkbox for an item, the tri-state checkbox toggles between an include state, an exclude state and a leave in current state.

18. A computer readable medium having stored thereon computer executable instructions for carrying out the method of claim 13.

19. A data packet transmitted between two or more computer components that facilitates comparison of a DataType with an associated database, the data packet comprising:

a data field comprising comparison information based upon a comparison of the dataset to the associated database.

20. A computer readable medium storing computer executable components of a reentrant database object wizard system comprising:

a comparison component that provides comparison information based upon a comparison of a dataset to an associated database; and

,

a display component that displays the comparison information.

21. A reentrant database object wizard system comprising:

means for comparing a dataset to an associated database; and

,

means for displaying information associated with comparison of the dataset to the associated database.