SYSTEM AND METHOD FOR INTEGRATING BUSINESS LOGIC INTO A HOT/COLD PREDICTION

摘要

A system and method for integrating business logic into a database system is disclosed herein. A database system may comprise a first database cluster H and a second database cluster L. After records are separated into the first database cluster H and the second database cluster L, the total number of records in the second database cluster L is compared to a target number of records. If there are too many records in the second database cluster L, a randomly generated number is used to randomly move records from second database cluster L into first database cluster H. In a situation where the first database cluster H is faster and accessed more often, such a method results in more products being placed in the faster database cluster and become more likely to become purchased. Other embodiments are also disclosed herein.

主权项

1. A method comprising:
determining: (a) a total number of records in a set of distinct records contained in a database system and (b) a total number of records in the set of distinct records in a second database cluster L, wherein the database system comprises a first database cluster H and the second database cluster L, and wherein the total number of records contained in the database system comprises the total number of records in the second database cluster L plus the total number of records in the first database cluster H; if the total number of records in the second database cluster L is greater than a target number of records in the second database cluster L, then iterating through each record in the set of distinct records, and, for each record in the second database cluster L:
generating a random number; and using the random number to determine if the record should be moved from the second database cluster L to the first database cluster H; receiving a search request from a requester; and presenting a search result containing one or more records of the set of distinct records to the requester.