-
公开(公告)号：US20060085484A1
公开(公告)日：2006-04-20
申请号：US10966563
申请日：2004-10-15
申请人： Alexander Raizman , Arunprasad Marathe , Djana Milton , Dmitry Sonkin , Lubor Kollar , Maciej Sarnowicz , Manoj Syamala , Raja Duddupudi , Sanjay Agrawal , Surajit Chaudhuri , Vivek Narasayya
发明人： Alexander Raizman , Arunprasad Marathe , Djana Milton , Dmitry Sonkin , Lubor Kollar , Maciej Sarnowicz , Manoj Syamala , Raja Duddupudi , Sanjay Agrawal , Surajit Chaudhuri , Vivek Narasayya
IPC分类号： G06F17/30
CPC分类号： G06F16/2282 , G06F16/2272
摘要： An automated physical database design tool may provide an integrated physical design recommendation for horizontal partitioning, indexes and indexed views, all three features being tuned together (in concert). Manageability requirements may be specified when optimizing for performance. User-specified configuration may enable the specification of a partial physical design without materialization of the physical design. The tuning process may be performed for a production server but may be conducted substantially on a test server. Secondary indexes may be suggested for XML columns. Tuning of a database may be invoked by any owner of a database. Usage of objects may be evaluated and a recommendation for dropping unused objects may be issued. Reports may be provided concerning the count and percentage of queries in the workload that reference a particular database, and/or the count and percentage of queries in the workload that reference a particular table or column. A feature may be provided whereby a weight may be associated with each statement in the workload, enabling relative importance of particular statements to be specified. An in-row length for a column may be specified. If a value for the column exceeds the specified in-row length for that column, the portion of the value not exceeding the specified in-row length may be stored in the row while the portion of the value exceeding the specified in-row length may be stored in an overflow area. Rebuild and reorganization recommendations may be generated.
摘要翻译： 自动化物理数据库设计工具可以为水平划分，索引和索引视图提供集成的物理设计建议，所有这三个特征被一起调谐（一致）。 在优化性能时可以指定可管理性要求。 用户指定的配置可以实现部分物理设计的规范，而不会实现物理设计。 可以对生产服务器执行调整过程，但是可以基本上在测试服务器上进行。 可以针对XML列建议辅助索引。 数据库的任何拥有者都可以调用数据库。 可以评估对象的使用，并且可以发出用于丢弃未使用对象的建议。 可以提供关于引用特定数据库的工作负载中的查询的计数和百分比的报告，和/或引用特定表或列的工作负载中的查询的计数和百分比。 可以提供特征，其中权重可以与工作负载中的每个语句相关联，使得能够指定特定语句的相对重要性。 可以指定列的行内长度。 如果列的值超过该列的指定行内长度，则不超过指定行内长度的部分可能存储在行中，而超出指定行内长度的值的部分可能会 存储在溢出区域。 可能会生成重建和重组建议。
-
公开(公告)号：US20120084795A1
公开(公告)日：2012-04-05
申请号：US12895511
申请日：2010-09-30
CPC分类号： G06F8/36
摘要： Embodiments are directed to combining service operations with various managed system objects to form a new dynamic programming interface combination and determining valid dynamic programming interface combinations. A computer system determines which service operations are offered by a selected managed system. The selected managed system is configured to provide various services comprising multiple different service operations. The computer system determines that managed system objects of the managed system are to be combined with at least one of the service operations. The computer system also combines the service operation with the managed system object, so that a new dynamic programming interface combination is created. The new dynamic programming interface combination is configured for use by the services offered by the managed system.
摘要翻译： 实施例旨在将服务操作与各种被管理的系统对象组合以形成新的动态编程接口组合并确定有效的动态编程接口组合。 计算机系统确定所选择的被管理系统提供哪些服务操作。 所选择的被管理系统被配置为提供包括多个不同服务操作的各种服务。 计算机系统确定被管理系统的受管系统对象将与服务操作中的至少一个组合。 计算机系统还将服务操作与受管系统对象相结合，从而创建新的动态编程接口组合。 新的动态编程接口组合被配置为由被管理系统提供的服务使用。
-
公开(公告)号：US20060085378A1
公开(公告)日：2006-04-20
申请号：US10966282
申请日：2004-10-15
申请人： Alexander Raizman , Arunprasad Marathe , Djana Ophelia Milton , Dmitry Sonkin , Lubor Kollar , Maciej Sarnowicz , Manoj Syamala , Raja Duddupudi , Sanjay Agrawal , Surajit Chaudhuri , Vivek Narasayya
发明人： Alexander Raizman , Arunprasad Marathe , Djana Ophelia Milton , Dmitry Sonkin , Lubor Kollar , Maciej Sarnowicz , Manoj Syamala , Raja Duddupudi , Sanjay Agrawal , Surajit Chaudhuri , Vivek Narasayya
IPC分类号： G06F17/30
CPC分类号： G06F16/22
摘要： Internal communications within components of an automated physical database design tool may be conducted in a data description language such as XML. Inputs to and outputs from the automated physical database design tool may also be presented in the data description language (e.g., XML). The communications, inputs and outputs may comply with a schema for the data description language. The schema may be written in a schema language such as XSD. Inputs presented in the data description language may comprise tuning options. Outputs may comprise a proposed physical design for a database and reports.
摘要翻译： 自动化物理数据库设计工具的组件内的内部通信可以以诸如XML的数据描述语言来进行。 自动物理数据库设计工具的输入和输出也可以以数据描述语言（例如，XML）呈现。 通信，输入和输出可能符合数据描述语言的模式。 模式可以用XSD等模式语言编写。 以数据描述语言呈现的输入可以包括调谐选项。 输出可以包括数据库的提出的物理设计和报告。
-
公开(公告)号：US09141411B2
公开(公告)日：2015-09-22
申请号：US12895482
申请日：2010-09-30
IPC分类号： G06F15/173 , G06F3/00 , G06F9/445 , H04L12/24
CPC分类号： G06F9/44536 , H04L41/0233
摘要： Embodiments are directed to implementing a dynamically changeable system model that is customizable per version, programmatically generating system models at runtime and to extending a programmatically generated system model. In an embodiment, a computer system determines that a dynamically changeable system model corresponds to a managed system. The dynamically changeable system model includes various managed system objects. The computer system indicates for the dynamically changeable system model which managed system objects are available in each version of the managed system. The available managed system objects are stored in a data store of the dynamically changeable system model. The computer system requests the managed system to provide current managed system information including at least a version identifier and, based on the managed system information indicated by the managed system, provides to the dynamically changeable system model those managed system objects that are provided by the indicated version of the managed system.
摘要翻译： 实施例涉及实现一种可以每个版本定制的动态可变系统模型，在运行时以编程方式生成系统模型并扩展一个以程序方式生成的系统模型。 在一个实施例中，计算机系统确定动态可变系统模型对应于被管理系统。 动态可变系统模型包括各种受管系统对象。 计算机系统指示可管理的系统对象在受管系统的每个版本中可用的动态可更改的系统模型。 可用的受管系统对象存储在动态可更改的系统模型的数据存储中。 该计算机系统请求被管理系统提供包括至少一个版本标识符的当前被管理系统信息，并且基于被管理系统所指示的被管理系统信息向动态可更改的系统模型提供由所指示的所提供的被管理系统对象 版本的受管系统。
-
公开(公告)号：US20120084301A1
公开(公告)日：2012-04-05
申请号：US12895532
申请日：2010-09-30
IPC分类号： G06F17/30
CPC分类号： G06F17/30867 , G06F17/30427 , G06F17/30519
摘要： Embodiments are directed to defining a query expression over a dynamic system model and to transforming a dynamically built query expression into a simplified, canonical form. A computer system receives various user inputs that are to be included as part of a query expression for querying a dynamic system model. The dynamic system model is queryable to determine features provided by a service hosted by a back-end server. The computer system dynamically builds the query expression based on both the received inputs and the available features provided by the service as indicated by the dynamic system model. The query expression also includes metadata structures representing those features of the service which are provided by the service. The computer system also queries across the dynamic system model using the dynamically built query expression to retrieve and provide the service features requested in the received user input.
摘要翻译： 实施例旨在通过动态系统模型定义查询表达式，并将动态构建的查询表达式转换为简化的规范形式。 计算机系统接收作为用于查询动态系统模型的查询表达式的一部分被包括的各种用户输入。 动态系统模型是可查询的，以确定由后端服务器托管的服务提供的功能。 计算机系统基于动态系统模型所指示的接收到的输入和服务提供的可用特征，动态构建查询表达式。 查询表达式还包括表示由服务提供的服务特征的元数据结构。 计算机系统还使用动态构建的查询表达式查询动态系统模型，以检索并提供在接收到的用户输入中请求的服务特征。
-
公开(公告)号：US20060136358A1
公开(公告)日：2006-06-22
申请号：US11019335
申请日：2004-12-21
申请人： Dmitry Sonkin , Maciej Sarnowicz , Bruce Prang , Djana Milton , Arunprasad Marathe , Vivek Narasayya , Manoj Syamala , Sanjay Agrawal
发明人： Dmitry Sonkin , Maciej Sarnowicz , Bruce Prang , Djana Milton , Arunprasad Marathe , Vivek Narasayya , Manoj Syamala , Sanjay Agrawal
IPC分类号： H04N5/44
CPC分类号： G06F16/217
摘要： An automated database tuning tool may include a user interface component and a tuning engine. The user interface may be a graphical component that interfaces with a user to collect configuration parameters for a tuning session for a specified database. The configuration parameters may be stored in a tuning database. A tuning engine that performs the actual tuning process may generate physical design recommendations and reports. The recommendations and reports may be stored in the tuning database, enabling the tuning tool to be run off-line or in background. Communication between components of the tuning tool may occur via stored procedures.
摘要翻译： 自动数据库调整工具可以包括用户界面组件和调谐引擎。 用户接口可以是与用户接口以收集指定数据库的调优会话的配置参数的图形组件。 配置参数可以存储在调优数据库中。 执行实际调谐过程的调谐引擎可能会生成物理设计建议和报告。 建议和报告可能存储在调优数据库中，使调试工具能够在离线或背景下运行。 调谐工具的组件之间的通信可以通过存储过程进行。
-
公开(公告)号：US20120084421A1
公开(公告)日：2012-04-05
申请号：US12895482
申请日：2010-09-30
IPC分类号： G06F15/173
CPC分类号： G06F9/44536 , H04L41/0233
摘要： Embodiments are directed to implementing a dynamically changeable system model that is customizable per version, programmatically generating system models at runtime and to extending a programmatically generated system model. In an embodiment, a computer system determines that a dynamically changeable system model corresponds to a managed system. The dynamically changeable system model includes various managed system objects. The computer system indicates for the dynamically changeable system model which managed system objects are available in each version of the managed system. The available managed system objects are stored in a data store of the dynamically changeable system model. The computer system requests the managed system to provide current managed system information including at least a version identifier and, based on the managed system information indicated by the managed system, provides to the dynamically changeable system model those managed system objects that are provided by the indicated version of the managed system.
摘要翻译： 实施例涉及实现一种可以每个版本定制的动态可变系统模型，在运行时以编程方式生成系统模型并扩展一个以程序方式生成的系统模型。 在一个实施例中，计算机系统确定动态可变系统模型对应于被管理系统。 动态可变系统模型包括各种受管系统对象。 计算机系统指示可管理的系统对象在受管系统的每个版本中可用的动态可更改的系统模型。 可用的受管系统对象存储在动态可更改的系统模型的数据存储中。 该计算机系统请求被管理系统提供包括至少一个版本标识符的当前被管理系统信息，并且基于被管理系统所指示的被管理系统信息向动态可更改的系统模型提供由所指示的所提供的被管理系统对象 版本的受管系统。
-
公开(公告)号：US07559053B2
公开(公告)日：2009-07-07
申请号：US10924536
申请日：2004-08-24
CPC分类号： G06F11/3466 , G06F11/3409 , G06F11/3476 , G06F2201/86 , G06F2201/88
摘要： System performance data and program performance data may be collected, converted into the same format and correlated by time. A graph or other display of system performance data over a time period may be displayed. A bar may be superimposed on the graph. A corresponding grid or other display, of program performance data over the same time period may be displayed. An item or line of the grid corresponding to a program event at a particular timepoint may be selected. A timepoint in the system performance graph may be selected by adjusting the position of the bar superimposed on the system performance graph. In response to the movement of the bar, the portion of the grid of program performance data displayed may be changed so that the grid of program performance data displays program performance data corresponding to the selected timepoint in the system performance graph.
摘要翻译： 可以收集系统性能数据和程序性能数据，转换成相同的格式并按时间相关。 可以显示一段时间内的系统性能数据的图形或其他显示。 酒吧可能会叠加在图表上。 可以显示相同时间段上的节目演奏数据的对应网格或其他显示。 可以选择与特定时间点处的节目事件相对应的网格的项目或行。 可以通过调整叠加在系统性能图上的条的位置来选择系统性能图中的时间点。 响应于条的移动，可以改变显示的节目演奏数据的网格的部分，使得节目演奏数据的网格显示与系统演奏图中所选择的时间点相对应的节目演奏数据。
-
公开(公告)号：US20060048101A1
公开(公告)日：2006-03-02
申请号：US10924536
申请日：2004-08-24
IPC分类号： G06F9/44
CPC分类号： G06F11/3466 , G06F11/3409 , G06F11/3476 , G06F2201/86 , G06F2201/88
摘要： System performance data and program performance data may be collected, converted into the same format and correlated by time. A graph or other display of system performance data over a time period may be displayed. A bar may be superimposed on the graph. A corresponding grid or other display, of program performance data over the same time period may be displayed. An item or line of the grid corresponding to a program event at a particular timepoint may be selected. A timepoint in the system performance graph may be selected by adjusting the position of the bar superimposed on the system performance graph. In response to the movement of the bar, the portion of the grid of program performance data displayed may be changed so that the grid of program performance data displays program performance data corresponding to the selected timepoint in the system performance graph.
-
-
-
-
-
-
-
-
搜索结果
9 条记录 (耗时 0.022 秒)
