Database system observability data querying and access

Patent metadata

Field	Value
Publication number	US-12124458-B2
Application number	US-202218052352-A
Country	US
Kind code	B2
Filing date	Nov 3, 2022
Priority date	Nov 3, 2022
Publication date	Oct 22, 2024
Grant date	Oct 22, 2024

Abstract

A query may be determined based on data retrieval parameter values. The data retrieval parameter values may include a data type parameter identifying a designated data type of a plurality of data types corresponding with database observability data generated during operation of a database system. The of data retrieval parameter values may also include a designated time period during which to retrieve data associated with the designated data type. A query may be determined based on the plurality of data retrieval parameter values via a collection manager in a database application layer associated with the database system. The query may be executed to retrieve a designated dataset of database observability data corresponding with the designated data type and generated by the database system during the designated time period.

First claim

The invention claimed is:

1. A method comprising:
receiving via a communication interface a plurality of data retrieval parameter values, the plurality of data retrieval parameter values including a data type parameter identifying a designated data type of a plurality of data types corresponding with database observability data generated during operation of a database system, the plurality of data retrieval parameter values also including a designated time period during which to retrieve data associated with the designated data type, wherein the data retrieval parameter values are included in a trigger object retrieved from an external event store and wherein the data retrieval parameter values include a database query identifier identifying a predetermined database query type and a plurality of values corresponding with a plurality of fields;
determining a designated query based on the plurality of data retrieval parameter values via a collection manager in a database application layer associated with the database system by populating a database query template associated with the predetermined database query type based on the data retrieval parameter values;
executing the designated query to retrieve a designated dataset of database observability data corresponding with the designated data type and generated by the database system during the designated time period; and

storing the database observability data in the external event store.

2. The method recited in claim 1 , wherein the designated query is one of a plurality of queries determined and executed based on the plurality of data retrieval parameter values, and wherein the designated dataset of database observability data includes data retrieved based on executing two or more of the plurality of queries.

3. The method recited in claim 1 , wherein the data type parameter identifies a database table, and wherein executing the designated query comprises determining whether the designated query is authorized for execution based at least in part on the data type parameter.

4. The method recited in claim 1 , wherein the plurality of data retrieval parameter values include a timestamp, and wherein the designated query is determined when the timestamp occurs after a designated point in time.

5. The method recited in claim 1 , wherein the plurality of data retrieval parameter values includes a force trigger value, and wherein the method further comprises determining whether the data retrieval parameter values correspond to a previously executed query when it is determined that the force trigger value is false, and wherein the designated query is determined when it is determined that the data retrieval parameter values do not correspond to a previously executed query.

6. The method recited in claim 1 , wherein the plurality of data retrieval parameter values are retrieved from the external event store.

7. The method recited in claim 1 , the method further comprising:
determining based on the plurality of data retrieval parameter values a database node of a plurality of database nodes for executing the designated query.

8. The method recited in claim 1 , wherein the database observability data includes one or more queries run on the database during the designated time period.

9. The method recited in claim 1 , wherein the database observability data includes information on one or more database sessions active during the designated time period.

10. The method recited in claim 1 , wherein the database observability data includes information on computing resource usage associated with use of an active session by a user account during the designated time period.

11. The method recited in claim 1 , wherein the database observability data includes information selected from the group consisting of: database log data, database monitoring data, database metrics, database profiling information, and database tracing information.

12. A database system comprising:
a communication interface configured to receive a plurality of data retrieval parameter values, the plurality of data retrieval parameter values including a data type parameter identifying a designated data type of a plurality of data types corresponding with database observability data generated during operation of the database system, the plurality of data retrieval parameter values also including a designated time period during which to retrieve data associated with the designated data type, wherein the data retrieval parameter values are included in a trigger object retrieved from an external event store and wherein the data retrieval parameter values include a database query identifier identifying a predetermined database query type and a plurality of values corresponding with a plurality of fields;
an application host implemented on one or more processors and configured to determine a designated query based on the plurality of data retrieval parameter values via a collection manager in a database application layer associated with the database system_by populating a database query template associated with the predetermined database query type based on the data retrieval parameter values;
a database query engine configured to execute the designated query to retrieve a designated dataset of database observability data corresponding with the designated data type and generated by the database system during the designated time period; and
an external event store interface configured to store the database observability data in an external event store.

13. The database system recited in claim 12 , wherein the designated query is one of a plurality of queries determined and executed based on the plurality of data retrieval parameter values, and wherein the designated dataset of database observability data includes data retrieved based on executing two or more of the plurality of queries.

14. One or more non-transitory computer readable media having instructions stored thereon for performing a method, the method comprising:
receiving via a communication interface a plurality of data retrieval parameter values, the plurality of data retrieval parameter values including a data type parameter identifying a designated data type of a plurality of data types corresponding with database observability data generated during operation of a database system, the plurality of data retrieval parameter values also including a designated time period during which to retrieve data associated with the designated data type, wherein the data retrieval parameter values are included in a trigger object retrieved from an external event store and wherein the data retrieval parameter values include a database query identifier identifying a predetermined database query type and a plurality of values corresponding with a plurality of fields;
determining a designated query based on the plurality of data retrieval parameter values via a collection manager in a database application layer associated with the database system by populating a database query template associated with the predetermined database query type based on the data retrieval parameter values;
executing the designated query to retrieve a designated dataset of database observability data corresponding with the designated data type and generated by the database system during the designated time period; and

storing the database observability data in the external event store.

Assignees

• Salesforce Inc

Inventors

• Teyer Paymon
• Panjala Sumana
• Weber Robert
• Singh Priyanshu

Classifications

• G06F16/242

  Query formulation · CPC title

• G06F11/3409 Primary

  for performance assessment · CPC title

• G06F16/256

  in federated or virtual databases · CPC title

• G06F16/24575 Primary

  using context · CPC title