公开(公告)号：US08898136B1

公开(公告)日：2014-11-25

申请号：US14010314

申请日：2013-08-26

Applicant: Dell Software Inc.

Inventor： Ariel Nissim Weil ,  Douglas Chrystall ,  Patrick Joseph O'Keeffe

IPC: G06F17/30

CPC classification number: G06F17/30306

Abstract: A database statement categorization system can enable DBAs or other users to more easily find tunable database statements by categorizing the database statements. The database categorization system can analyze a DBMS to identify the types of database statements executed on the DBMS and can then categorize the statements automatically, outputting the categorization for presentation to a DBA (or other user). This categorization can advantageously separate less relevant statements that warrant less tuning or investigation from more relevant statements that may have a measurable impact on the performance of the database. By allowing users to focus on statements that are more likely to warrant attention, in certain embodiments the database categorization system streamlines the tuning process.

Abstract translation: 数据库语句分类系统可以使DBA或其他用户通过对数据库语句进行分类来更轻松地查找可调参数数据库语句。 数据库分类系统可以分析DBMS以识别在DBMS上执行的数据库语句的类型，然后可以自动对语句进行分类，将分类显示给DBA（或其他用户）。 这种分类可以有利地将较不相关的声明分开，这些声明可能减少可能对数据库性能产生可测量影响的更相关语句的调整或调查。 通过允许用户专注于更有可能引起关注的语句，在某些实施例中，数据库分类系统简化了调整过程。