Legal claims defining the scope of protection. Each claim is shown in both the original legal language and a plain English translation.
1. A method implemented by one or more computing devices, the method comprising: by the one or more computing devices: receiving one or more search criteria for searching a plurality of database connections to at least one analytics information content repository, wherein the plurality of database connections are associated with respective analytics metadata stored in a metadata repository; identifying at least one of the plurality of database connections, wherein the identifying comprises identifying analytics metadata stored in the metadata repository that are associated with the at least one of the plurality of database connections and that meet the search criteria; rating the at least one of the plurality of database connections; displaying identifiers for the at least one of the plurality of database connections with corresponding ratings via a user interface; receiving a selection of one of the plurality of database connections from the at least one of the plurality of database connections via the user interface; responsive to the selection of the selected one of the plurality of database connections, assigning a score to at least one of a plurality of database connection fields within the selected one of the plurality of database connections, wherein assigning the score comprises determining a ratio between a number of information content instances in the analytics information content repository that contain the selected one of the plurality of database connections and a number of the information content instances in the analytics information content repository that contain the at least one of the plurality of database connection fields; ranking the at least one of the plurality of database connection fields based on the score; outputting an indication of the ranking of the at least one of the plurality of database connection fields via the user interface; receiving a selection of one of the ranked plurality of database connection fields; locating at least one analytics report with the selected one of the plurality of database connections, wherein the at least one analytics report is associated with the selected one of the ranked plurality of database connection fields and matches the search criteria; and outputting the at least one analytics report via the user interface.
A software-implemented method allows users to search a variety of database connections (e.g., to databases, queries, data cubes) for analytics information. The method receives search criteria, then identifies database connections whose associated metadata matches the criteria. These connections are then ranked and displayed to the user. Upon user selection of a database connection, its individual fields are scored based on how often they appear with the selected connection in the underlying data repository. These fields are then ranked and displayed. Upon user selection of a field, the system locates and displays relevant analytics reports associated with both the chosen database connection and field.
2. The method according to claim 1 , wherein: the search criteria comprises a keyword; and at least one of the plurality of database connections comprises a database, a database query, or a data cube.
The search method for database connections specifies that the search criteria includes a keyword. The system searches a variety of database connections (e.g., to databases, queries, or data cubes) and finds database connections whose associated metadata matches the keyword. The found connections are ranked and presented to the user.
3. The method according to claim 2 , wherein the analytics metadata comprises metadata associated with one or more of the database, the database query, the data cube, or an analytics report accessible using at least one of the plurality of database connections.
Using a keyword search, the method identifies database connections. The analytics metadata, used for identifying these connections, includes metadata about the underlying database, database queries, data cubes, or analytics reports accessible through the database connections. The system searches a variety of database connections (e.g., to databases, queries, or data cubes) and finds database connections whose associated metadata matches the keyword. The found connections are ranked and presented to the user.
4. The method according to claim 2 , wherein identifying the at least one of the plurality of database connections comprises: matching the keyword with analytics metadata for a plurality of databases associated with the at least one of the plurality of database connections; and if a match occurs, selecting the at least one of the plurality of database connections for rating.
During the database connection search, the keyword is matched against the analytics metadata of databases. If a match is found, the corresponding database connection (e.g., to databases, queries, or data cubes) is selected for rating and presentation to the user. The system searches a variety of database connections and finds database connections whose associated metadata matches the keyword. The found connections are ranked and presented to the user.
5. The method according to claim 4 , wherein the analytics metadata for the plurality of databases comprises one or more of a database name, a database column name, a database field name, and metadata associated with an analytics report stored within one of the plurality of databases.
In the keyword-based database connection search, the analytics metadata for databases includes the database name, column name, field name, or metadata related to analytics reports stored within the database. The keyword is matched against the analytics metadata of databases. If a match is found, the corresponding database connection is selected for rating and presentation to the user. The system searches a variety of database connections (e.g., to databases, queries, or data cubes) and finds database connections whose associated metadata matches the keyword. The found connections are ranked and presented to the user.
6. The method according to claim 4 , wherein the rating comprises: assigning a score to each of the plurality of databases associated with the at least one of the plurality of database connections, based on the matching.
The rating process involves assigning scores to each database linked to a database connection (e.g., to databases, queries, or data cubes), based on the keyword match strength. The keyword is matched against the analytics metadata of databases. If a match is found, the corresponding database connection is selected for rating and presentation to the user.
7. The method according to claim 6 , comprising: ranking at least a portion of the plurality of databases based on the assigned score; and outputting an indication of the ranking of the at least a portion of the plurality of databases.
The scored databases are ranked based on their assigned scores, and the ranking is displayed to the user. The rating process assigns scores to each database linked to a database connection, based on the keyword match strength. The keyword is matched against the analytics metadata of databases. If a match is found, the corresponding database connection (e.g., to databases, queries, or data cubes) is selected for rating and presentation to the user.
8. The method according to claim 1 , wherein assigning the score to at least one of the plurality of database connection fields further comprises: determining a second ratio between the number of information content instances in the analytics information content repository that contain the selected database connection and a number of the information content instances in the analytics information content repository that contain all of the plurality of database connection fields.
The process of scoring database connection fields involves determining the ratio of information content instances containing the selected database connection versus the instances containing at least one of the database connection fields. The software implemented method allows users to search a variety of database connections (e.g., to databases, queries, data cubes) for analytics information.
9. The method according to claim 8 , wherein assigning the score to at least one of the plurality of database connection fields further comprises: modifying the ratio using a first corresponding weighting value; modifying the second ratio using a second corresponding weighting value; and combining the modified ratio with the second modified ratio to generate a score for the database connection field.
Scoring database connection fields involves calculating two ratios: (1) the ratio of information content instances containing the selected database connection versus the instances containing at least one of the database connection fields, and (2) the ratio of information content instances containing the selected database connection versus the instances containing all the database connection fields. Each ratio is then adjusted by a weighting factor, and the weighted ratios are combined to produce a final score for the database connection field.
10. A computing system comprising: memory, and one or more processors; wherein the memory stores computer-executable instructions that are executed by the one or more processors to execute: a metadata analytics engine, the metadata analytics engine comprising: a database connection repository; a metadata repository of analytics metadata associated with a plurality of database connections stored in the database connection repository; a filtering module configured to: filter, using a keyword, the analytics metadata stored in the metadata repository and associated with the plurality of database connections to at least one analytics information content repository, wherein each of the plurality of database connections comprises metadata attributes defining at least a portion of the analytics metadata, and select one or more of the plurality of database connections as search results, if the keyword matches at least one of the metadata attributes associated with the plurality of database connections; and a ranking module configured to: rate the selected one or more of the plurality of database connections, rank the selected one or more of the plurality of database connections based on the rating, display identifiers for the selected one or more of the plurality of database connections with corresponding ratings via a user interface; and for a database connection with a highest rating of the selected one or more of the plurality of database connections: assign scores to a plurality of fields associated with the database connection with the highest rating, wherein assigning scores comprises determining a ratio between a number of information content instances in the analytics information content repository associated with the database connection with the highest rating and a number of the information content instances in the analytics information content repository associated with at least one of the plurality of fields; select one of the plurality of fields based on the scores; locate at least one analytics report with the database connection with the highest rating, wherein the at least one analytics report is associated with the selected one of the plurality of fields; and output, via a user interface, the at least one analytics report.
A computing system discovers analytics reports by providing a database connection repository and a metadata repository. A filtering module uses keywords to search analytics metadata associated with database connections. The module selects database connections if the keyword matches metadata attributes. A ranking module rates and ranks the selected database connections, displaying results via a user interface. For the highest-rated connection, the system scores its fields based on the number of information content instances related to the connection versus the number related to the fields. The system selects a field based on its score, locates analytics reports associated with the connection and field, and displays the reports via a user interface.
11. The system according to claim 10 , wherein: each of the plurality of database connections comprises a database, a database query, or a data cube.
The analytics report discovery system includes a database connection repository and a metadata repository. The database connections in the repository consist of databases, database queries or data cubes. A filtering module uses keywords to search analytics metadata associated with database connections. The module selects database connections if the keyword matches metadata attributes. A ranking module rates and ranks the selected database connections, displaying results via a user interface. For the highest-rated connection, the system scores its fields based on the number of information content instances related to the connection versus the number related to the fields. The system selects a field based on its score, locates analytics reports associated with the connection and field, and displays the reports via a user interface.
12. The system according to claim 11 , wherein: the metadata attributes comprise one or more of a connection name, a column name, a field name, or a title name associated with one or more of the database, the database query, the data cube, or an analytics report accessible using at least one of the plurality of database connections.
This invention relates to a system for managing and analyzing metadata attributes in database environments. The system addresses the challenge of efficiently organizing and retrieving metadata associated with databases, queries, data cubes, and analytics reports across multiple database connections. Metadata attributes such as connection names, column names, field names, or title names are stored and linked to their respective data sources, enabling users to quickly identify and access relevant data structures. The system ensures that metadata is consistently tracked and accessible, improving data governance and analytics workflows. By centralizing metadata attributes, the system enhances data discoverability and reduces the complexity of managing disparate data sources. This approach supports better decision-making by providing clear, structured metadata that facilitates seamless integration and analysis across different database connections. The system is designed to streamline data management processes, ensuring that metadata remains accurate and up-to-date, which is critical for maintaining data integrity and reliability in large-scale database environments.
13. The system according to claim 10 , wherein rating the selected one or more of the plurality of database connections comprises: assigning a score to each of the selected one or more of the plurality of database connections based on a match between the keyword and at least one of the metadata attributes for each of the selected one or more of the plurality of database connections.
To rate selected database connections, the system assigns a score to each connection based on how well the keyword matches its metadata attributes. A computing system discovers analytics reports by providing a database connection repository and a metadata repository. A filtering module uses keywords to search analytics metadata associated with database connections. The module selects database connections if the keyword matches metadata attributes. A ranking module rates and ranks the selected database connections, displaying results via a user interface.
14. The system according to claim 13 , wherein: ranking the selected one or more of the plurality of database connections based on the rating comprises ranking based on the scores; and the database connection with the highest rating comprises a database connection of the selected one or more of the plurality of database connections with a highest score.
The analytics report discovery system ranks selected database connections based on their assigned scores (as determined by the keyword match quality with its metadata). The connection with the highest score is considered the highest-rated connection. The selected connections are assigned a score to each connection based on how well the keyword matches its metadata attributes. A computing system discovers analytics reports by providing a database connection repository and a metadata repository.
15. One or more non-transitory computer-readable storage devices comprising computer-executable instructions for performing a method in a database platform, the method comprising: receive search criteria for searching a plurality of database connections to at least one analytics information content repository, each of the plurality of database connections comprising a database, a database query, or a data cube within the database platform; assign first scores to the plurality of database connections, based on matching the search criteria with analytics metadata associated with the plurality of database connections; rate the plurality of database connections based on the first scores; display the plurality of the database connections with corresponding scores, of the first scores, and corresponding ratings via a user interface; receive a selection of one of the plurality of database connections via the user interface; responsive to receiving the selection of the selected one of the plurality of database connections, assign second scores to a plurality of database fields within the selected one of the plurality of database connections, based on matching the search criteria with analytics metadata associated with the plurality of database fields, wherein assigning the second scores comprises determining a ratio between a number of information content instances in the analytics information content repository that contain the selected one of the plurality of database connections and a number of the information content instances in the analytics information content repository that contain at least one of the plurality of database fields; select one of the plurality of database fields, based on the second scores; identify at least one analytics report from the at least one analytics information content repository, the at least one analytics report associated with the selected one of the plurality of database connections and the selected one of the plurality of database fields; and display the at least one analytics report via the user interface.
A software program searches database connections (databases, queries, data cubes) for analytics reports. It assigns initial scores to connections based on how well search criteria match associated metadata. Connections are then ranked and displayed with their scores. Upon user selection of a connection, the program assigns scores to database fields within the connection, assessing the ratio of information content instances containing the connection versus instances containing the fields. A field is selected based on its score. The program identifies and displays analytics reports associated with both the selected connection and field.
16. The one or more non-transitory computer-readable storage devices of claim 15 , wherein the method further comprises: rating at least a portion of the plurality of database fields based on the second score; and outputting an indication of the rated database fields.
The software program to search database connections can rate and display the database fields. The field rankings can be displayed to the user. The software program searches database connections (databases, queries, data cubes) for analytics reports. It assigns initial scores to connections based on how well search criteria match associated metadata. Connections are then ranked and displayed with their scores. Upon user selection of a connection, the program assigns scores to database fields within the connection, assessing the ratio of information content instances containing the connection versus instances containing the fields. A field is selected based on its score. The program identifies and displays analytics reports associated with both the selected connection and field.
Unknown
October 24, 2017
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.