Described are methods, systems and computer readable media for dynamic updating of query result displays.

Time-based partitioning of a data set is applied to capture updates to the data set in a copy of the data set. Items that have been updated in a data set with in a time period are identified. Partitions of the data set that include the updated items are created according to a partitioning scheme. The created partitions are grouped in a storage location for the time period in a file structure that stores a copy of the database. A latest version of the copy of the data set may be accessed according to latest partitions of the data set stored in the different locations of the file structure.

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.

Techniques for improving system performance based on data characteristics are disclosed. A system may receive updates to a first data set at a first frequency. The system selects a first storage configuration, from a plurality of storage configurations, for storing the first data set based on the first frequency, and stores the first data set in accordance with the first storage configuration. The system may further receive updates to a second data set at a second frequency. The system selects a second storage configuration, from the plurality of storage configurations, for storing the second data set based on the second frequency, and stores the second data set in accordance with the second storage configuration. The second storage configuration is different than the first storage configuration.

Techniques described herein can accelerate change data capture determinations such as stream reads, which show changes made to a table between two points in time. Three distinct row bitests that mark deleted, updated, inserted, rows in micro-partitions can be added as metadata for the table. These bitsets can be generated during DML operations and then stored as metadata of the new partition generated by the DML operations. The bitsets can then be used to generate streams showing the changes in the table between two points in time (changes interval).

Data protection methods and systems for a storage environment are provided. A first-in-first out (FIFO) structure stores a logical representation of a first storage location that retains previous data for a data container, after new data for the data container is stored at a second storage location. The FIFO structure also stores a logical representation of a file system tree structure that is stored in persistent storage, after a consistent point operation. In response to an event, the file system tree structure is selected, based on the file system tree structure being closest to a transaction. A snapshot is generated using the file system tree structure. Thereafter, the data container is restored from the snapshot or from a copy of the snapshot.

A method of incrementally replicating investigative analysis data is disclosed along with a system for performing the same. The method and system provide the ability to break a data replication job into multiple “replication chunks” which can be exported and imported separately. By doing so, the method and system can efficiently replicate large numbers of data object changes over an unreliable data network.

A computer implemented method includes receiving an event log corresponding to event entries of an electronic diary of a participant of a clinical trial, wherein the event log is generated in a client device, and the event log includes an event identifier and an event timestamp for at least two event entries; determining a block of event entries within the event log, the block including a first event entry and a second event entry at least one of whose event timestamps are verified being correct in view of corresponding service timestamps of a server apparatus, wherein the first and the second event entry are arranged chronologically; and adjusting the event timestamp of the second event entry based on the first timestamp.

Described are methods, systems and computer readable media for performance logging of complex query operations.

Nutritional information of a recipe is gathered to determine a nutritional value table of a food recipe. A computing device may extract and analyze unstructured text of a food recipe to obtain a plurality of ingredients and a quantity of the plurality of ingredients. The computing device may access dietary preferences of a user. The nutritional information of the food recipe may be calculated using the nutritional value of each of the ingredients and complied into a nutritional value table. The recipe may be determined if the recipe corresponds with the dietary preferences of the user. If a recipe does not correspond with the dietary preferences, then an ingredient causes the recipe to not correspond with the dietary preferences is removed from the recipe creating an altered recipe. The nutritional value table of the altered recipe is displayed to the user.