专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20060085484A1 Database tuning advisor 审中-公开
标题翻译：数据库调优顾问
公开(公告)号：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列建议辅助索引。数据库的任何拥有者都可以调用数据库。可以评估对象的使用，并且可以发出用于丢弃未使用对象的建议。可以提供关于引用特定数据库的工作负载中的查询的计数和百分比的报告，和/或引用特定表或列的工作负载中的查询的计数和百分比。可以提供特征，其中权重可以与工作负载中的每个语句相关联，使得能够指定特定语句的相对重要性。可以指定列的行内长度。如果列的值超过该列的指定行内长度，则不超过指定行内长度的部分可能存储在行中，而超出指定行内长度的值的部分可能会存储在溢出区域。可能会生成重建和重组建议。

2. 发明申请

US20060136358A1 Database tuning advisor graphical tool 审中-公开
标题翻译：数据库调优顾问图形工具
公开(公告)号：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.
摘要翻译：自动数据库调整工具可以包括用户界面组件和调谐引擎。用户接口可以是与用户接口以收集指定数据库的调优会话的配置参数的图形组件。配置参数可以存储在调优数据库中。执行实际调谐过程的调谐引擎可能会生成物理设计建议和报告。建议和报告可能存储在调优数据库中，使调试工具能够在离线或背景下运行。调谐工具的组件之间的通信可以通过存储过程进行。

3. 发明申请

US20060048101A1 Program and system performance data correlation 有权
公开(公告)号：US20060048101A1
公开(公告)日：2006-03-02
申请号：US10924536
申请日：2004-08-24
申请人： Viatcheslav Krassovsky , Dmitry Sonkin , Maciej Sarnowicz , Djana Milton
发明人： Viatcheslav Krassovsky , Dmitry Sonkin , Maciej Sarnowicz , Djana Milton
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.

4. 发明申请

US20070150815A1 Program execution service windows 有权
标题翻译：程序执行服务窗口
公开(公告)号：US20070150815A1
公开(公告)日：2007-06-28
申请号：US11317645
申请日：2005-12-22
申请人： Kyle Smith , Adrian Maziak , Djana Milton , Dattatraya Rajpure , Gaurav Dhawan , Shafqat Khan , Roxana Drake , Khuzaima Iqbal
发明人： Kyle Smith , Adrian Maziak , Djana Milton , Dattatraya Rajpure , Gaurav Dhawan , Shafqat Khan , Roxana Drake , Khuzaima Iqbal
IPC分类号： G06F9/00
CPC分类号： G06F8/65 , G06F8/60 , G06F9/445 , G06F9/4843
摘要： Techniques for guaranteeing that a software program is executed on a machine only during designated periods of time are provided. Service windows define time periods during which software programs targeted to execute on a machine are allowed to execute on the machine. On the machine, the service windows work in conjunction with a client process that is executing on the machine to guarantee execution of the software programs by the client process only during available service windows.
摘要翻译：提供了仅在指定时间段内保证在机器上执行软件程序的技术。服务窗口定义了允许在机器上执行的软件程序在机器上执行的时间段。在机器上，服务窗口与在机器上执行的客户端进程协同工作，以保证客户端进程只在可用的服务窗口中执行软件程序。

5. 发明授权

US08495613B2 Program execution service windows 有权
公开(公告)号：US08495613B2
公开(公告)日：2013-07-23
申请号：US11317645
申请日：2005-12-22
申请人： Kyle Smith , Adrian Maziak , Djana Milton , Dattatraya Rajpure , Gaurav Dhawan , Shafqat Khan , Roxana Drake , Khuzaima Iqbal
发明人： Kyle Smith , Adrian Maziak , Djana Milton , Dattatraya Rajpure , Gaurav Dhawan , Shafqat Khan , Roxana Drake , Khuzaima Iqbal
IPC分类号： G06F9/44
CPC分类号： G06F8/65 , G06F8/60 , G06F9/445 , G06F9/4843
摘要： Techniques for guaranteeing that a software program is executed on a machine only during designated periods of time are provided. Service windows define time periods during which software programs targeted to execute on a machine are allowed to execute on the machine. On the machine, the service windows work in conjunction with a client process that is executing on the machine to guarantee execution of the software programs by the client process only during available service windows.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式