Easily queriable software repositories
First Claim
1. A computing system comprising:
- at least one processor; and
at least one computer readable storage medium storing computer executable instructions which, when executed by the at least one processor, implement a method of providing entities the ability to 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 database routines and other tools, wherein the method includes;
exposing, via an interface stored in memory of a computer system 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 of a repository, the software related items including both executables and metadata that describes the executables, wherein the set of schema guidelines includes two or more of;
naming guidelines;
script file guidelines;
table guidelines;
indexing guidelines;
viewing guidelines;
procedure and function guidelines;
foreign key guidelines;
query guidelines;
or cursor use guidelines;
receiving from one or more entities software related items that are organized according to one or more schema guidelines in the set of schema guidelines, the software related items being received by the repository; and
storing the organized software related items into a plurality of query tables of the repository, wherein the organized software related items are stored in rows of the query tables, wherein each row includes a container version ID field storing a container version ID that identifies a container to which the organized software related items stored in the row pertain, and wherein the containers are versioned based on when changes to the organized software related items the containers contain are made.
2 Assignments
0 Petitions
Accused Products
Abstract
Tables are created in such a way that allows rich querying using standard database routines and other tools. Developers and repository users are provided 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.
88 Citations
20 Claims
-
1. A computing system comprising:
-
at least one processor; and at least one computer readable storage medium storing computer executable instructions which, when executed by the at least one processor, implement a method of providing entities the ability to 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 database routines and other tools, wherein the method includes; exposing, via an interface stored in memory of a computer system 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 of a repository, the software related items including both executables and metadata that describes the executables, wherein the set of schema guidelines includes two or more of;
naming guidelines;
script file guidelines;
table guidelines;
indexing guidelines;
viewing guidelines;
procedure and function guidelines;
foreign key guidelines;
query guidelines;
or cursor use guidelines;receiving from one or more entities software related items that are organized according to one or more schema guidelines in the set of schema guidelines, the software related items being received by the repository; and storing the organized software related items into a plurality of query tables of the repository, wherein the organized software related items are stored in rows of the query tables, wherein each row includes a container version ID field storing a container version ID that identifies a container to which the organized software related items stored in the row pertain, and wherein the containers are versioned based on when changes to the organized software related items the containers contain are made. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A method of providing entities the ability to 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 database routines and other tools, the method comprising:
-
identifying software related items of a domain; accessing a set of schema guidelines that describe how the software related items of a schematized model of the domain are to be categorized in query tables of a repository, the software related items including both executables and metadata that describes the executables, wherein the set of schema guidelines includes two or more of;
naming guidelines;
script file guidelines;
table guidelines;
indexing guidelines;
viewing guidelines;
procedure and function guidelines;
foreign key guidelines;
query guidelines;
or cursor use guidelines;arranging the software related items into the query tables according to the schema guidelines; providing the software related items to a repository after they have been arranged according to the schema guidelines and in such a way as to cause the organized software related items to be stored by the repository within a plurality of query tables of the repository, wherein the organized software related items are stored in rows of the query tables at the repository, wherein each row includes a container version ID field storing a container version ID that identifies a container to which the organized software related items stored in the row pertain, and wherein the containers are versioned based on when changes to the organized software related items the containers contain are made. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A computer-readable storage medium storing computer executable instructions which, when executed by at least one processor of a computing system, implement a method of providing entities the ability to 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 database routines and other tools, the method comprising:
-
identifying software related items of a domain; accessing a set of schema guidelines that describe how the software related items of a schematized model of the domain are to be categorized in query tables of a repository, the software related items including both executables and metadata that describes the executables, wherein the set of schema guidelines includes two or more of;
naming guidelines;
script file guidelines;
table guidelines;
indexing guidelines;
viewing guidelines;
procedure and function guidelines;
foreign key guidelines;
query guidelines;
or cursor use guidelines;arranging the software related items into the query tables according to the schema guidelines; providing the software related items to a repository after they have been arranged according to the schema guidelines and in such a way as to cause the organized software related items to be stored by the repository within a plurality of query tables of the repository, wherein the organized software related items are stored in rows of the query tables at the repository, wherein each row includes a container version ID field storing a container version ID that identifies a container to which the organized software related items stored in the row pertain, and wherein the containers are versioned based on when changes to the organized software related items the containers contain are made. - View Dependent Claims (20)
-
Specification