-
公开(公告)号: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.
-
公开(公告)号: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.
摘要翻译: 可以收集系统性能数据和程序性能数据,转换成相同的格式并按时间相关。 可以显示一段时间内的系统性能数据的图形或其他显示。 酒吧可能会叠加在图表上。 可以显示相同时间段上的节目演奏数据的对应网格或其他显示。 可以选择与特定时间点处的节目事件相对应的网格的项目或行。 可以通过调整叠加在系统性能图上的条的位置来选择系统性能图中的时间点。 响应于条的移动,可以改变显示的节目演奏数据的网格的部分,使得节目演奏数据的网格显示与系统演奏图中所选择的时间点相对应的节目演奏数据。
-
公开(公告)号: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列建议辅助索引。 数据库的任何拥有者都可以调用数据库。 可以评估对象的使用,并且可以发出用于丢弃未使用对象的建议。 可以提供关于引用特定数据库的工作负载中的查询的计数和百分比的报告,和/或引用特定表或列的工作负载中的查询的计数和百分比。 可以提供特征,其中权重可以与工作负载中的每个语句相关联,使得能够指定特定语句的相对重要性。 可以指定列的行内长度。 如果列的值超过该列的指定行内长度,则不超过指定行内长度的部分可能存储在行中,而超出指定行内长度的值的部分可能会 存储在溢出区域。 可能会生成重建和重组建议。
-
公开(公告)号: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.
摘要翻译: 自动数据库调整工具可以包括用户界面组件和调谐引擎。 用户接口可以是与用户接口以收集指定数据库的调优会话的配置参数的图形组件。 配置参数可以存储在调优数据库中。 执行实际调谐过程的调谐引擎可能会生成物理设计建议和报告。 建议和报告可能存储在调优数据库中,使调试工具能够在离线或背景下运行。 调谐工具的组件之间的通信可以通过存储过程进行。
-
公开(公告)号:US07822741B2
公开(公告)日:2010-10-26
申请号:US10872633
申请日:2004-06-21
CPC分类号: G06F11/3688 , G06F11/3466 , G06F17/30368
摘要: Trace and replay objects can be designed to automatically perform operations concerning database trace data upon invocation by custom computer processes. Trace data can be saved to any of variety of locations. It can be manipulated for the purpose of storage or replay. Trace data can be played back against any database server using numerous replay configuration options. Replay notifications allow data to be changed just before it is submitted to a database for execution, and allow immediate examination of replay results and validation of playback correctness. Thus, trace and replay objects greatly simplify manageability of trace data. Custom processes can now completely automate security audit and health monitoring of traced database servers. Automatic verification of new server releases and security packs can also be performed. Custom processes can use the provided objects to flexibly access and manipulate the retrieval, storage, and replay of database trace data.
摘要翻译: 跟踪和重放对象可以被设计为在通过自定义计算机进程调用时自动执行关于数据库跟踪数据的操作。 跟踪数据可以保存到各种位置。 可以为了存储或重放而操作它。 可以使用多个重播配置选项对任何数据库服务器播放跟踪数据。 重播通知允许在提交到数据库执行之前更改数据,并允许立即检查重放结果和确认播放正确性。 因此,跟踪和重放对象极大地简化了跟踪数据的可管理性。 自定义进程现在可以完全自动化跟踪数据库服务器的安全审计和运行状况监控。 还可以执行新的服务器版本和安全包的自动验证。 自定义进程可以使用提供的对象来灵活地访问和操作数据库跟踪数据的检索,存储和重放。
-
公开(公告)号:US20050283457A1
公开(公告)日:2005-12-22
申请号:US10872633
申请日:2004-06-21
CPC分类号: G06F11/3688 , G06F11/3466 , G06F17/30368
摘要: Trace and replay objects can be designed to automatically perform operations concerning database trace data upon invocation by custom computer processes. Trace data can be saved to any of variety of locations. It can be manipulated for the purpose of storage or replay. Trace data can be played back against any database server using numerous replay configuration options. Replay notifications allow data to be changed just before it is submitted to a database for execution, and allow immediate examination of replay results and validation of playback correctness. Thus, trace and replay objects greatly simplify manageability of trace data. Custom processes can now completely automate security audit and health monitoring of traced database servers. Automatic verification of new server releases and security packs can also be performed. Custom processes can use the provided objects to flexibly access and manipulate the retrieval, storage, and replay of database trace data.
摘要翻译: 跟踪和重放对象可以被设计为在通过自定义计算机进程调用时自动执行关于数据库跟踪数据的操作。 跟踪数据可以保存到各种位置。 可以为了存储或重放而操作它。 可以使用多个重播配置选项对任何数据库服务器播放跟踪数据。 重播通知允许在提交到数据库执行之前更改数据,并允许立即检查重放结果和确认播放正确性。 因此,跟踪和重放对象极大地简化了跟踪数据的可管理性。 自定义进程现在可以完全自动化跟踪数据库服务器的安全审计和运行状况监控。 还可以执行新的服务器版本和安全包的自动验证。 自定义进程可以使用提供的对象来灵活地访问和操作数据库跟踪数据的检索,存储和重放。
-
公开(公告)号: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等模式语言编写。 以数据描述语言呈现的输入可以包括调谐选项。 输出可以包括数据库的提出的物理设计和报告。
-
公开(公告)号:US08239854B2
公开(公告)日:2012-08-07
申请号:US11728374
申请日:2007-03-26
申请人: Dmitry Sonkin , Unmesh Vartak , Marc Greisen
发明人: Dmitry Sonkin , Unmesh Vartak , Marc Greisen
IPC分类号: G06F9/45
CPC分类号: G06F8/61
摘要: A bookmark file is stored in persistent storage and is updated as various tasks are completed during an installation process. The bookmark file may be read when an installation process is started so that the installation process may continue from a point after the last successfully completed task, if the installation process had failed and was restarted. The bookmark file may also include data collected from a user interface during the installation process. When an installation process is restarted, some embodiments may present the data in a user interface for the user to modify. The installation process may be defined in a configuration file that includes metadata that defines the sequence of installation tasks as well as some error handling for various tasks.
摘要翻译: 书签文件存储在持久存储器中,并且在安装过程中完成各种任务时更新书签文件。 当启动安装过程时,可以读取书签文件,以便如果安装过程失败并重新启动,安装过程可以从上次成功完成任务之后的一个点继续。 书签文件还可以包括在安装过程期间从用户界面收集的数据。 当安装过程重新启动时,一些实施例可以将用户界面中的数据呈现给用户以进行修改。 可以在包括定义安装任务序列的元数据以及各种任务的一些错误处理的配置文件中定义安装过程。
-
公开(公告)号:US08151273B2
公开(公告)日:2012-04-03
申请号:US12199847
申请日:2008-08-28
申请人: Jeanine E. Spence , Joseph W. Hallock , Eric C. Kool-Brown , Jeremy D. Brown , Christer Garbis , Michael W. Jackson , Edward K. Tremblay , Dmitry Sonkin , Marc Greisen , Kanchuki Sarma , Michael D. Lubrecht , Gary J. Purchase , Kenneth P. Coleman
发明人: Jeanine E. Spence , Joseph W. Hallock , Eric C. Kool-Brown , Jeremy D. Brown , Christer Garbis , Michael W. Jackson , Edward K. Tremblay , Dmitry Sonkin , Marc Greisen , Kanchuki Sarma , Michael D. Lubrecht , Gary J. Purchase , Kenneth P. Coleman
IPC分类号: G06F9/46
CPC分类号: G06F9/5072 , G06F9/5027 , G06F9/5083 , G06F11/0709 , G06F11/0715 , G06F11/0793 , G06F2209/5017
摘要: An installation and configuration system consolidates workloads of multiple applications and services, including applications or services that may be installed or configured on multiple server devices or remotely hosted services. The system gathers environmental information, analyzes dependencies among the workloads, and populates the input data used by the workloads from a common database. The system then executes the workloads, allowing branching within the workloads or the sequence of workloads. An example of branching may include detecting an error condition, pausing the sequence, and presenting alternative fixes to a user.
摘要翻译: 安装和配置系统整合多个应用程序和服务的工作负载,包括可能在多个服务器设备或远程托管服务上安装或配置的应用程序或服务。 系统收集环境信息,分析工作负载之间的依赖关系,并填充工作负载从公用数据库使用的输入数据。 然后,系统执行工作负载,允许在工作负载或工作负载序列内分支。 分支的示例可以包括检测错误状况,暂停序列,以及向用户呈现替代修复。
-
公开(公告)号:US06988098B2
公开(公告)日:2006-01-17
申请号:US10422398
申请日:2003-04-24
申请人: Dmitry Sonkin , Andrew Nechayev
发明人: Dmitry Sonkin , Andrew Nechayev
IPC分类号: G06F17/30
CPC分类号: G06F17/30955 , G06F17/30528 , G06F17/3053 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要: A system for generating database query results includes a database suitable for access by a software query, a data storage component which serializes and stores information queried from the database, a storage view component which accesses the data storage component to perform sequential de-serialization of column data, a sort view component which maintains a pointer to the storage view component enabling subsequent physical row access to the data storage component, a grid storage component which acquires the de-serialized query results and provides application-specific formatting, and a grid control component which supplies output data to the a display. The sort view component provides column and row level sorting upon request. The formatted results are viewable simultaneous with the streaming of data from the database and simultaneous with a sorting of the query results.
摘要翻译: 用于生成数据库查询结果的系统包括适合于通过软件查询进行访问的数据库,串行化并存储从数据库查询的信息的数据存储组件,访问数据存储组件以执行列的顺序解串行化的存储视图组件 数据,分类视图组件,其维护指向存储视图组件的指针,以使得能够对数据存储组件进行后续物理行访问;网格存储组件,其获取解序列化查询结果并提供应用特定格式;以及网格控制组件 它将输出数据提供给显示器。 排序视图组件根据请求提供列和行级排序。 格式化的结果可以与来自数据库的数据流一起查看,并与查询结果的排序同时进行。
-
-
-
-
-
-
-
-
-