Methods and systems for a fast access database and fast database monitoring

    公开(公告)号:US10783126B1

    公开(公告)日:2020-09-22

    申请号:US15377415

    申请日:2016-12-13

    Abstract: Systems, methods, and computer-readable media are disclosed for an improved database. The systems, methods, and computer-readable media described herein may enhance the response time of databases and improve user experiences. In an example method described herein, a database monitoring system may receive instructions to perform one or more data monitoring operations comprising counting an occurrence of a first value within at least a portion of items stored in a database. The method may include determining a length of a first window of time and fetching, from a first location of a data store of the database, data indicative of a total count of the occurrence of the first value at a time associated with the beginning of the first window of time. In turn, the monitoring system may store data representing the first count in the first memory. The, monitoring system may determine that the first count of the occurrence of the first value changed during the first window of time and store data representing the second count in the first memory. Once the monitoring system determines that the first window of time expired, the monitoring system may provide, to the database, the data representing the second count from the first memory, wherein the database is configured to initiate a write operation for storing the data representing the second count at the first location of the data store of the database.

    Generating query results based on data partitions

    公开(公告)号:US10459918B1

    公开(公告)日:2019-10-29

    申请号:US15195813

    申请日:2016-06-28

    Abstract: Techniques for improving efficiency of data processing associated with data queries are described. For example, a computer system may access a first query result of a first time window that result may have been generated based on first transformed data stored in data partitions associated with the first time window. The computer system may access data corresponding to a time unit that falls outside of the first time window and inside a second time window. The first time window and the second time window may have overlapping time units. The computer system may generate a data partition that corresponds to the time unit and that stores second transformed data. The second transformed data may correspond to a data transformation of the data. The computer system may generate a second query result for the second time window based on the second transformed data and the first query result.

Patent Agency Ranking