Systems and methods for implementing and maintaining sampled tables in a database system

摘要: In accordance with disclosed embodiments, there are provided systems and methods for implementing maintaining sampled tables in a database system. According to particular embodiment such system includes processor memory execute instructions at the system; store records; query interface submit queries receive results from database; triggers initiate hash function on insert transactions, primary key of each record be inserted into determine whether first value satisfies sampling condition; sample table corresponding any which condition based function; index providing keys records stored table; an ordered second numerically by value. Other related embodiments disclosed.