Building and using a sparse time series database (TSDB)

    公开(公告)号:US12105722B2

    公开(公告)日:2024-10-01

    申请号:US17817806

    申请日:2022-08-05

    CPC classification number: G06F16/2477 G06F16/2228 G06F16/24556

    Abstract: Provided are techniques for building and using a sparse Time Series Database (TSDB). Time series records are received from a native TSDB, where each of the time series records includes a timestamp and one or more tags. Timeslots are determined for shards for the sparse TSDB based on the timestamp included in each of the time series records. The sparse TSDB is built by creating the shards for the determined timeslots and storing the time series records in the shards, while filling in empty ranges in the shards. A query that specifies at least one of the one or more tags is received. It is determined whether to execute the query against the sparse TSDB, and, in response to a determination to execute the query against the sparse TSDB, the query is executed against the sparse TSDB to generate results that are returned.

    HETEROGENEOUS SCHEMA DISCOVERY FOR UNSTRUCTURED DATA

    公开(公告)号:US20230409593A1

    公开(公告)日:2023-12-21

    申请号:US17807884

    申请日:2022-06-21

    Abstract: An embodiment for analyzing and tracking data flow to determine proper schemas for unstructured data. The embodiment may automatically use a sidecar to collect schema discovery rules during conversion of raw data to unstructured data. The embodiment may automatically generate multiple schemas for different tenants using the collected schema discovery rules. The embodiment may automatically use ETL to export unstructured data to SQL databases with the generated multiple schemas for the different tenants. The embodiment may automatically monitor usage data of the SQL databases and collect the usage data. The embodiment may automatically optimize schema discovery using the collected usage data. The embodiment may automatically discover schemas with hot usage and apply the discovered schemas with hot usage to other tenants for consumption and further monitoring.

    SMART TEST DATA WORKLOAD GENERATION

    公开(公告)号:US20230089759A1

    公开(公告)日:2023-03-23

    申请号:US17481399

    申请日:2021-09-22

    Abstract: In an approach for smart test data workload generation, a processor receives a plurality of expected image frames for a user interface application to be tested. The plurality of expected image frames is pre-defined and represents a series of workflows and operations of the user interface application to be expected based on a design requirement. A processor calculates a first set of hash-values for each corresponding expected image frame. A processor samples the user interface application with a frequency to a plurality of testing image frames during a test run on the user interface application. A processor calculates a second set of hash-values for each sampled testing image frame. A processor compares the first set of hash-values to the second set of hash-values. A processor verifies that the second set of hash-values matches the first set of hash-values.

    PREDICTIVE MICROSERVICES ACTIVATION USING MACHINE LEARNING

    公开(公告)号:US20220108147A1

    公开(公告)日:2022-04-07

    申请号:US17060165

    申请日:2020-10-01

    Abstract: Described are techniques for predictive microservice activation. The techniques include training a machine learning model using a plurality of sequences of coordinates, where the plurality of sequences of coordinates are respectively based upon a corresponding plurality of series of vectors generated from historical usage data for an application and its associated microservices. The techniques further include inputting a new sequence of coordinates representing a series of application operations to the machine learning model. The techniques further include identifying a predicted microservice for future utilization based on an output vector generated by the machine learning model. The techniques further include activating the predicted microservice prior to the predicted microservice being called by the application.

    DYNAMIC COMBINATION OF PROCESSES FOR SUB-QUERIES

    公开(公告)号:US20190258639A1

    公开(公告)日:2019-08-22

    申请号:US16402259

    申请日:2019-05-03

    Abstract: A tool for combining common processes shared by at least two or more sub-queries within a query is provided. The tool determines whether one or more sub set relationships are shared between the at least two or more sub-queries. Responsive to a determination that one or more sub set relationships are shared between the at least two or more sub-queries, the tool determines an order class for the at least two or more sub-queries based on the one or more sub set relationships, wherein determining the order class includes transforming the query to include one or more differing aspects within the single shared common process, with the one or more differing aspects arranged based, at least in part, on a query style, a query type, and a query function. Responsive to determining an access path for the query, the tool executes the access path during run-time for data accessing.

Patent Agency Ranking