Centralized metadata repository with relevancy identifiers
Techniques and solutions are described for storing and retrieving metadata for database artefacts. A client request is received that includes a relevancy identifier. The relevancy identifier is useable to determine a subset of metadata that should be provided in response to the request. Metadata, including in metadata objects or database artefacts, can be reviewed to determine whether it is relevant to the request, such as if the metadata is associated with the relevancy identifier. Different requests from the same client can specify different relevancy identifiers, as, for example, a first set of metadata may be relevant to one client process and another set may be relevant to another client process. While some metadata can be specific to a particular client, at least some of the metadata can be accessed by multiple clients, and at least in some cases different clients can specify the same relevancy identifier.
1. A computing system comprising:
at least one hardware processor;
at least one memory coupled to the at least one hardware processor; and
one or more computer readable storage media store computer-executable instructions that, when executed, cause the computing system to perform operations comprising:
storing in a repository a plurality of metadata objects, at least a first portion of the plurality of metadata objects comprising a respective relevance identifier, wherein at least a first metadata object of the at least a first portion of the plurality of metadata objects comprises a first relevance identifier value that is different from a second relevance identifier value of at least a second metadata object of the at least a first portion of the plurality of metadata objects, wherein metadata objects of the plurality of metadata objects comprise respective definitions, where a respective definition comprises a plurality of metadata elements and is useable to create an instance of a metadata object having the respective definition;
receiving a request for metadata elements of at least a second portion of the at least a first portion of the plurality of metadata objects comprising the first relevance identifier value, the request comprising the first relevance identifier value and not comprising the second relevance identifier value;
using the first relevance identifier value, reviewing a set comprising the at least a first portion of the plurality of metadata objects to determine a subset of the set, wherein metadata objects of the at least a first portion of the plurality of metadata objects are included in the subset when a definition of a given metadata object of the at least a first portion of the plurality of metadata objects comprises the first relevance identifier value and the subset comprises multiple metadata objects of the at least a first portion of the plurality of metadata objects; and
returning at least a portion of metadata elements in the definitions of the given metadata objects in the subset in response to the request.
2. The computing system of claim 1 , wherein the relevance identifier is not identical to an identifier for a client sending the request.
3. The computing system of claim 1 , wherein the request is a first request, the relevance identifier is a first relevance identifier, and the subset is a first subset, the operations further comprising:
receiving a second request for metadata, the second request comprising a second relevance identifier different than the first relevance identifier; and
using the second relevance identifier, reviewing the set comprising the plurality of metadata objects to determine a second subset of the set of the plurality of metadata objects, where the first subset and the second subset are not equal.
4. The computing system of claim 1 , wherein the reviewing comprising applying one or more scoping functions to determine one or more database artefacts that are associated with a first database artefact.
5. The computing system of claim 4 , wherein an identifier of the first database artefact is provided in the request.
6. The computing system of claim 4 , wherein an identifier of the first database artefact is determined from an identifier of a client from whom the request originated.
7. The computing system of claim 1 , wherein metadata objects of the subset comprise the relevance identifier.
8. The computing system of claim 7 , wherein the relevance identifier comprises an identifier of a client from whom the request originated.
9. The computing system of claim 1 , wherein the relevance identifier identifies a particular software application, subject area, or computer-implemented process.
10. The computing system of claim 1 , wherein the subset is a first subset and is selected from a second subset, the first subset being a subset of the second subset, the second subset comprising related database artefacts.
11. The computing system of claim 10 , wherein the related database artefacts are related by a foreign key or an association.
12. The computing system of claim 1 , wherein metadata objects are defined for respective database artefacts and the relevance identifier is included as an annotation to a definition of a metadata object for the respective database artefact.
13. The computing system of claim 1 , wherein metadata objects are defined for respective database artefacts and the relevance identifier is included as an element in a definition of a metadata object for the respective database artefact.
14. The computing system of claim 1 , where the relevance identifier is associated with a database artefact.
15. The computing system of claim 14 , wherein the database artefact is a table or a view.
16. The computing system of claim 14 , wherein the relevance identifier is associated with a subcomponent of a table or a view.
17. The computing system of claim 1 , wherein the set or the subset is determined at least in part based on authorization information associated with a client from whom the request originated.
18. The computing system of claim 1 , wherein the plurality of metadata objects are maintained in a central repository and requests for metadata from the central repository are received from a plurality of client systems, where different client systems may specify different subsets of relevant metadata using relevance identifiers.
19. One or more non-transitory computer-readable storage media comprising:
computer-executable instructions that, when executed by a computing system comprising at least one hardware processor and at least one memory coupled to the at least one hardware processor, cause the computing system to receive a first request from a first client system for at least a portion of metadata elements included in one or more metadata object definitions associated with a first relevance identifier, wherein a respective metadata object definition is useable to create an instance of a metadata object having the respective metadata object definition, the first request comprising the first relevance identifier;
computer-executable instructions that, when executed by the computing system, cause the computing system to, using the first relevance identifier, review a set comprising a plurality of metadata objects to determine a first subset of the set, the first subset of the set comprising at least a portion of the plurality of metadata objects associated with the first relevance identifier;
computer-executable instructions that, when executed by the computing system, cause the computing system to return metadata elements for the metadata objects of the first subset in response to the first request;
computer-executable instructions that, when executed by the computing system, cause the computing system to receive a second request from a second client system, different than the first client system, for metadata, the second request comprising a second relevance identifier, different than the first relevance identifier;
computer-executable instructions that, when executed by the computing system, cause the computing system to, using the second relevance identifier, review the set of the plurality of metadata objects to determine a second subset of the set of the plurality of metadata objects, the first subset not being equal to the second subset; and
computer-executable instructions that, when executed by the computing system, cause the computing system to return metadata elements for metadata objects of the second subset in response to the second request.
20. A method, implemented in a computing environment comprising a computing system hosting a central metadata repository accessible to a plurality of different client systems, the computing system comprising at least one hardware processor and at least one memory coupled to the at least one hardware processor, the method comprising:
storing in a repository a plurality of metadata objects, at least a first portion of the plurality of metadata objects comprising a respective relevance identifier, wherein at least a first metadata object of the at least a first portion of the plurality of metadata objects comprises a first relevance identifier value that is different from a second relevance identifier value of at least a second metadata object of the at least a first portion of the plurality of metadata objects, wherein metadata objects of the plurality of metadata objects comprise respective definitions, where a respective definition comprises a plurality of metadata elements and is useable to create an instance of a metadata object having the respective definition;
receiving a request for metadata elements of at least a second portion of the at least a first portion of the plurality of metadata objects comprising the first relevance identifier value, the request comprising the first relevance identifier value and not comprising the second relevance identifier value;
using the first relevance identifier value, reviewing a set comprising the at least a first portion of the plurality of metadata objects to determine a subset of the set, wherein metadata objects of the at least a first portion of the plurality of metadata objects are included in the subset when a definition of a given metadata object of the at least a first portion of the plurality of metadata objects comprises the first relevance identifier value and the subset comprises multiple metadata objects of the at least a first portion of the plurality of metadata objects; and
returning at least a portion of metadata elements in the definitions of the given metadata objects in the subset in response to the request.