EASILY QUERIABLE SOFTWARE REPOSITORIES

• US 20080201355A1
• Filed: 05/16/2007
• Published: 08/21/2008
• Est. Priority Date: 02/16/2007
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Minium, Dennis W., Bloesch, Anthony C., Short, Keith W.
• Granted Patent: US 8,145,673 B2
• Time in Patent Office: Days
• US Class Current: 707/102
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

In one embodiment, tables are created in such a way that allows rich querying using standard database routines and other tools. This is accomplished by providing developers and repository users with a set of schema guidelines that describe how the software related items are to be categorized in the tables and how to use such tables for rich querying. For example, one such guideline provides for course-grained versioning of items (e.g., artifacts, metadata, etc.)—as opposed to the fine grained object principle of unit change found in most repository systems such as the entity-property-value scheme. The developers or providers then use these guidelines to optimally categorize, in a natural way, their metadata and other software related items for storing copies thereof in the repository.

Claims

1. In a repository environment, a method of providing entities the ability to optimally create, manage, and/or store fine-grained metadata, artifacts, or other software related items of a domain by providing a relational model that stores these items in a way that allows rich querying using standard database routines and other tools, the method comprising:

providing entities with a set of schema guidelines that describe how software related items of a schematized model of a domain are to be categorized in query tables;

based on the set of schema guidelines, allowing the entities to arrange the software related items into a plurality of query tables that provide ease in querying over the software related items, wherein such items typically reside in a universal entity-property-value schema that is versioned on an object-by-object basis; and

storing the plurality of query tables in a software repository, which is a common store that allows tools that use the software related items to be independent of any particular domain model.

2. The method of claim 1, wherein the tables are versioned on the basis of a collection of software related items in one or more containers that have changed since a last versioning.

3. The method of claim 2, wherein a plurality of the one or more containers are further loosely coupled by one or more soft links that represents a relationship between two fine-grained software items.

4. The method of claim 3, wherein the plurality of the one or more containers are different versions of the software related items and the soft link is used to determine the appropriate version at query time.

5. The method of claim 1, wherein the guidelines include one or more:

naming guidelines;

script file guidelines;

schema guidelines;

table guidelines;

indexing guidelines;

viewing guidelines;

procedure and function guidelines;

foreign key guidelines;

query guidelines;

or cursor use guidelines.

6. The method of claim 5, wherein the naming guidelines include one or more of:

using lower-case characters for T-SQL keywords;

quoting identifiers with [ . . . ] style quotes;

using schema qualified names to refer to database objects;

using .Net naming conventions;

using [Id] as the name of the primary key;

using plurals for table and view names;

appending Table to repository item table names;

using singular role names for join columns;

using singular schema names;

explicitly naming constraints;

or using separate schema for each domain.

7. The method of claim 6, wherein the naming guidelines further include one or more of:

using [PK_TableName] for primary-key names;

using [Check_TableName_Column1_Column2_Description] for check constraint names;

using [Unique_TableName_KeyColumn1_KeyColumn2] for unique constraint names;

using ┌

FK_SourceTable_SourceColumn_TargetTableName┐

for foreign key names;

using [IR_KeyColumn1_KeyColumn2_LeafColumn1] for relational index names;

using ┌

IX_Column_Kind┐

for XML index names where Kind is one of;

Primary, Value, Path or Property;

or using [Schema_Area] for full-text index catalog names.

8. The method of claim 5, wherein the script file guidelines include using two script files per domain.

9. The method of claim 5, wherein the schema guidelines include using extended properties to copyright and conversion table domains/schema.

10. The method of claim 5, wherein the table guidelines include one or more of:

using normalized table designs;

explicitly naming primary keys, foreign keys, or indexes;

using surrogate keys;

using a big or large integer type for identity columns of the software related items where an ID will vary across instances thereof;

using a unique identifier type ID columns of repository items where the ID does not vary across repository instances;

vertically partitioning large or infrequent accessed columns into separate tables;

using explicit integrity constraints;

using XML columns based on a schema collection for hierarchical or ordered data that will be fetched as a unit;

adding a container version column to each domain table;

adding a tombstone table and associated delete trigger for each domain table;

using a xml;

lang attribute for XML entities including culture specific content;

avoiding using string types for enumerations;

storing locale specific text as references to a table and retrieve the strings with a scalar function;

or do not use text, ntext, or image column types;

restricting access to base tables to the login less users.

11. The method of claim 5, wherein the index guidelines include one or more of:

indexing join columns;

indexing foreign key columns;

indexing columns that frequently appear in where clauses;

adding leaf columns to indexes;

not using index columns with a small number of distinct values;

creating a new full-text catalog for each group of related values;

not using schema binding;

or creating security views.

12. The method of claim 5, wherein the procedure and function guidelines include one or more of:

using updatable view instead of basic database functions;

not using schema binding;

avoiding cursors;

not allowing for change of primary key columns;

not altering identity or timestamp columns;

or using column lists in insert statements.

13. The method of claim 5, further comprising one or more of the following:

wherein foreign key guidelines include using delete triggers to enforce non-primary cascade delete actions;

wherein the query guidelines include using table aliases composed of the initial capital letters in the table'"'"'s name;

or wherein the cursor use guidelines include avoiding the user of cursors, or if cursors are used, using a standard pattern for cursors.

14. The method of claim 1, further comprising:

storing the plurality of software related items in the software repository using the universal entity-property-value schema; and

upon receiving a request to process an application associated with the domain, retrieving the plurality of software related items using the universal entity-property-value schema.

15. In a repository, a method of optimally creating, managing, and/or storing fine-grained metadata, artifacts, or other software related items of a domain by providing a relational model that stores these items in a way that allows rich querying using standard database routines and other tools, the method comprising:

identifying a plurality of software related items of a schematized model of a domain;

accessing a set of schema guidelines that describe how the software related items are to be categorized in query tables;

based on the set of schema guidelines, arranging the software related items into a plurality of query tables that provide ease in querying over the software related items, wherein such software related items typically reside in a universal entity-property-value schema that is versioned on an object-by-object basis; and

cataloging the plurality of query tables for storage in a software repository, which is a common store that allows tools that use the software related items to be independent of any particular domain model.

16. The method of claim 15, wherein the tables are versioned on the basis of a collection of software related items in one or more containers that have changed since a last versioning.

17. The method of claim 16, wherein a plurality of the one or more containers are further loosely coupled by one or more soft links that represents a relationship between two fine-grained software items.

18. The method of claim 17, wherein the plurality of the one or more containers are different versions of the software related items and the soft link is used to determine the appropriate version at query time.

19. The method of claim 15, wherein the guidelines include one or more:

naming guidelines;

script file guidelines;

schema guidelines;

table guidelines;

indexing guidelines;

viewing guidelines;

procedure and function guidelines;

foreign key guidelines;

query guidelines;

or cursor use guidelines.

20. The method of claim 15, further comprising:

cataloging the plurality of software related items in the software repository using the universal entity-property-value schema; and

upon sending a request to process an application associated with the domain, receiving the plurality of software related items using the universal entity-property-value schema.