Writing incoming items to a database based on location of similar items in a database

摘要

Embodiments disclosed herein relate to a method of writing a transaction to a data store having one or more data tables. An application agent receives transaction data for a first transaction of a first type. Application agent attempts to write the first transaction of the first type to a data table in the data store, provided that a transaction of the first type has been committed to the data store. Application agent scans a plurality of additional data stores for previously committed transactions of the first type Application agent determines additional transactions of another type that are co-located in a data table. Application agent ranks the additional transactions of the other type. Application agent identifies a data table in the data store to which a top ranking additional transaction of the other type has been committed. Application agent writes the first transaction to identified data table in the data store.