-
公开(公告)号：US07155428B1
公开(公告)日：2006-12-26
申请号：US10039283
申请日：2001-12-31
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , G06F17/30463 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A method and apparatus provides for the extraction of environment information from a target database system. The environment information includes at least one of cost-related information and random sample statistics. The cost-related information and/or random sample statistics are imported to a test system, where the cost-related information and/or random sample statistics are used in query plan analysis by an optimizer.
摘要翻译： 方法和装置提供从目标数据库系统提取环境信息。 环境信息包括成本相关信息和随机样本统计中的至少一个。 成本相关信息和/或随机样本统计信息被导入到测试系统，其中成本相关信息和/或随机样本统计信息由优化器在查询计划分析中使用。
-
公开(公告)号：US07499907B2
公开(公告)日：2009-03-03
申请号：US09977038
申请日：2001-10-12
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , Y10S707/99932 , Y10S707/99933 , Y10S707/99937 , Y10S707/99938 , Y10S707/99939
摘要： An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.
摘要翻译： 索引选择机制允许为数据库系统的给定工作负载高效地生成索引建议。 工作负载包括用于访问数据库系统中的表的一组查询。 索引建议被验证以验证性能提高，然后应用索引。 提供图形用户界面屏幕以接收用户输入以及向用户呈现报告。
-
公开(公告)号：US07246111B1
公开(公告)日：2007-07-17
申请号：US09923975
申请日：2001-08-07
IPC分类号： G06F17/30
CPC分类号： G06F17/30386 , Y10S707/99933 , Y10S707/99934
摘要： A system emulation tool and method provides a user interface having various options that are selectable by a user for exporting environment information from one or more target database systems. The user interface in one arrangement includes multiple screens that are invoked in response to user action. Exported data from the one or more target database systems is stored in corresponding files. The user interface of the system emulation tool also provides options to enable a user to import the environment information to a test system. In the test system, the environment information is used to create an environment that emulates the environment of the target database system.
摘要翻译： 系统仿真工具和方法提供具有可由用户选择以从一个或多个目标数据库系统输出环境信息的各种选项的用户界面。 一个布置中的用户界面包括响应于用户动作调用的多个屏幕。 来自一个或多个目标数据库系统的导出数据存储在相应的文件中。 系统仿真工具的用户界面还提供了使用户能够将环境信息导入测试系统的选项。 在测试系统中，环境信息用于创建模拟目标数据库系统环境的环境。
-
公开(公告)号：US20100057796A1
公开(公告)日：2010-03-04
申请号：US12396184
申请日：2009-03-02
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , Y10S707/99932 , Y10S707/99933 , Y10S707/99937 , Y10S707/99938 , Y10S707/99939
摘要： An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.
摘要翻译： 索引选择机制允许为数据库系统的给定工作负载高效地生成索引建议。 工作负载包括用于访问数据库系统中的表的一组查询。 索引建议被验证以验证性能提高，然后应用索引。 提供图形用户界面屏幕以接收用户输入以及向用户呈现报告。
-
公开(公告)号：US07234112B1
公开(公告)日：2007-06-19
申请号：US09796289
申请日：2001-02-28
IPC分类号： G06F3/00
CPC分类号： G06F17/30433 , G06F17/30445 , Y10S707/99933 , Y10S707/99943
摘要： An execution plan of a query for a parallel database system is determined. In one arrangement, the parallel database system is a relational database management system. The execution plan of the query is determined by an optimizer program. Execution plans are inserted into one or more explain tables that are accessible by a visual explain and compare module to display the steps of the execution plan in a graphical user interface. Parallel execution of steps of the execution plan can be depicted in the graphical user interface. Further, plural execution plans for a given query under different conditions may be compared.
摘要翻译： 确定并行数据库系统的查询的执行计划。 在一种安排中，并行数据库系统是关系数据库管理系统。 查询的执行计划由优化程序确定。 执行计划被插入到一个或多个可视化解释和比较模块可访问的解释表中，以在图形用户界面中显示执行计划的步骤。 可以在图形用户界面中描绘执行计划的步骤的并行执行。 此外，可以比较在不同条件下给定查询的多个执行计划。
-
6.发明授权公开(公告)号：US07089258B1
公开(公告)日：2006-08-08
申请号：US10056549
申请日：2002-01-25
IPC分类号： G06F17/30
CPC分类号： G06F17/30306 , Y10S707/99943 , Y10S707/99944 , Y10S707/99945
摘要： A method and computer system for structure subset generation for multiple databases is disclosed. The method retrieves a database view object structure. The method includes inputting definition language specifying a database view identifier and with at least one directly or indirectly referenced database object unqualified with a containing database identifier. The method further includes inputting a show statement that identifies the database view identifier and outputting the definition language with each directly or indirectly referenced database object qualified with its containing database identifier.
摘要翻译： 公开了一种用于多个数据库的结构子集生成的方法和计算机系统。 该方法检索数据库视图对象结构。 该方法包括输入指定数据库视图标识符的定义语言以及与包含的数据库标识符不兼容的至少一个直接或间接引用的数据库对象。 该方法还包括输入标识数据库视图标识符的show语句，并且输出定义语言，其中每个直接或间接引用的数据库对象具有包含数据库标识符的资格。
-
公开(公告)号：US07962521B2
公开(公告)日：2011-06-14
申请号：US12396184
申请日：2009-03-02
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , Y10S707/99932 , Y10S707/99933 , Y10S707/99937 , Y10S707/99938 , Y10S707/99939
摘要： An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.
摘要翻译： 索引选择机制允许为数据库系统的给定工作负载高效地生成索引建议。 工作负载包括用于访问数据库系统中的表的一组查询。 索引建议被验证以验证性能提高，然后应用索引。 提供图形用户界面屏幕以接收用户输入以及向用户呈现报告。
-
公开(公告)号：US06801903B2
公开(公告)日：2004-10-05
申请号：US09976634
申请日：2001-10-12
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , Y10S707/99932
摘要： Statistics regarding at least one attribute (or column) of a table in a database system are collected using an enhanced mechanism for faster collection. The statistics collection is based on scanning a sample of rows of a given table, with the sample being less than all the rows of the table. The percentage of rows to be read is specified in a statement submitted to the database system. The database system then uses the specified percentage to read the sample rows from the table for collecting statistics on the at least one attribute.
摘要翻译： 使用增强的机制来收集关于数据库系统中的表的至少一个属性（或列）的统计信息，以便更快地收集。 统计信息收集基于扫描给定表的行样本，样本小于表的所有行。 要读取的行的百分比在提交到数据库系统的语句中指定。 然后，数据库系统使用指定的百分比从表中读取样本行，以收集关于至少一个属性的统计信息。
-
公开(公告)号：US07260569B1
公开(公告)日：2007-08-21
申请号：US10081079
申请日：2002-02-21
CPC分类号： G06F8/31 , Y10S707/955 , Y10S707/99934
摘要： A database system includes components for executing stored procedures that include at least one of a conditional expression, assignment expression, and dynamic database query language (e.g., SQL) statement. For each such expression, a predetermined type of code is generated and inserted into the object code corresponding to the stored procedure. When executing the stored procedure object code, the predetermined type of code is evaluated directly without having to generate a separate database query language statement.
摘要翻译： 数据库系统包括用于执行包括条件表达式，分配表达式和动态数据库查询语言（例如，SQL）语句中的至少一个的存储过程的组件。 对于每个这样的表达式，生成预定类型的代码并将其插入到对应于存储过程的目标代码中。 当执行存储过程对象代码时，直接评估预定类型的代码，而不必生成单独的数据库查询语言语句。
-
-
-
-
-
-
-
-
搜索结果
9 条记录 (耗时 0.02 秒)
