首页>
外国专利>
Performance of Distributed Databases and Database-Dependent Software Applications
Performance of Distributed Databases and Database-Dependent Software Applications
展开▼
机译:分布式数据库和数据库相关软件应用程序的性能
展开▼
页面导航
摘要
著录项
相似文献
摘要
Computer-implemented systems and methods for categorizing tables of a database into groups are provided. A set of queries used to access a database are processed to generate a log that identifies for each of the queries (i) a database operation associated with the query, (ii) a table of the database accessed via the query, and (iii) a column or columns of the table used by the query to access the table. Database operation criteria for categorizing database tables into groups are accessed. The criteria are based on a total number of times that a table is accessed by the set of queries and a number of times that the table is accessed using a column or group of columns. An algorithm that evaluates data of the log against the criteria is applied. The algorithm is configured to automatically categorize tables identified in the log into groups based on the evaluation.
展开▼