用于处理查询的方法、数据库系统和计算机可读存储介质

• Format: Patent
• Language: Chinese
• Published: 01.02.2022
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

本公开涉及用于处理查询的方法、数据库系统和计算机可读存储介质。本主题涉及处理数据库系统中查询的方法和系统。处理查询的方法包括：在从客户端接收到相应查询时从数据库系统处理的多个查询中随机选择查询；对于随机选择的每个查询，从高速缓存源检索与随机选择的查询匹配的第一高速缓存数据并从原始数据源检索与随机选择的查询匹配的第一原始数据；对于未被随机选择的查询，从高速缓存源检索与查询匹配的第二高速缓存数据；评估第二高速缓存数据的准确度值；若准确度值低于给定阈值则从原始数据源检索与查询匹配的第二原始数据，并用第二原始数据更新第二高速缓存数据；和使用机器学习算法基于第一高速缓存数据和第一原始数据调整概率模型。 The subject disclosure relates to methods and systems of processing queries in a database system. For example, the method of processing queries comprises: randomly selecting queries from among a plurality of queries handled by the database system, at the time the respective query is received from a client; for each of the queries randomly selected, retrieving a first piece of the cached data matching the randomly selected query from the cache source, and retrieving a first piece of the original data matching the randomly selected query from the original data source; for queries not being randomly selected, retrieving a second piece of the cached data matching the query from the cache source; evaluating the accuracy