Abstract: Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.

Abstract: Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.

Abstract: The invention provides methods, apparatus, and systems for performing high-throughput preparation and screening of salts and polymorphs of drug candidates. The invention is directed towards enhancing the pre-formulation discovery process used for drug development. In particular, processes that determine suitable salts and processes that discover substantially every polymorph that can form from a particular drug candidate are provided. The processes are performed using several apparatuses that are specifically configured to carry-out various steps in a high-throughput characterization process. One such apparatus is configured for synthesizing a plurality of library members based on, for example, a library model generated by a computer system. Another apparatus may filter the synthesized solution to provide a substantially pure mixture that can be subjected to salt or polymorph testing.