公开(公告)号：US09081806B2

公开(公告)日：2015-07-14

申请号：US13606028

申请日：2012-09-07

申请人： Sumanth Hegde ,  Santosh Vijayan

发明人： Sumanth Hegde ,  Santosh Vijayan

IPC分类号： G06F17/30

CPC分类号： G06F17/30306

摘要： Various embodiments of systems and methods of optimizing a database are described herein. Database tables are rated based on at least one of table size and table growth rate. One or more of the database tables are then selected based on the rating of the database tables. Archiving objects for the one or more selected tables are obtained. An archiving object includes one or more archiving programs and defines data related to a business object. The archiving objects are ranked based on dependencies between them. Based on the ranking of the archiving objects, an archiving schedule including an archiving order for the archiving objects is generated. The archiving schedule is then displayed.

摘要翻译： 本文描述了优化数据库的系统和方法的各种实施例。 数据库表根据表格大小和表格增长率中的至少一个进行评级。 然后根据数据库表的等级选择一个或多个数据库表。 获得一个或多个所选表格的归档对象。 存档对象包括一个或多个归档程序并定义与业务对象相关的数据。 归档对象根据它们之间的依赖关系进行排名。 基于归档对象的排名，生成包含归档对象的归档顺序的归档计划。 然后显示归档时间表。

公开(公告)号：US20150019528A1

公开(公告)日：2015-01-15

申请号：US13941098

申请日：2013-07-12

申请人： Santosh Vijayan

发明人： Santosh Vijayan

IPC分类号： G06F17/30

CPC分类号： G06F16/24552

摘要： Column accesses to columns of one or more database tables may be determined based on database queries accessing the one or more database tables. Row accesses to rows of the one or more database tables may be determined based on the queries. A priority may be assigned to a column of a row from the one or more database tables based on the determined column accesses of the column and the row accesses of the row. The column of the row may be moved from random access memory to hard disk based on the assigned priority.

摘要翻译： 可以基于访问一个或多个数据库表的数据库查询来确定对一个或多个数据库表的列的列访问。 可以基于查询来确定对一个或多个数据库表的行的行访问。 基于列的确定的列访问和行的行访问，可以将优先级从一个或多个数据库表分配给行的列。 根据分配的优先级，行的列可以从随机存取存储器移动到硬盘。