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

1. 发明申请

US20070150488A1 System and method for migrating databases 失效
标题翻译：用于迁移数据库的系统和方法
公开(公告)号：US20070150488A1
公开(公告)日：2007-06-28
申请号：US11316245
申请日：2005-12-22
申请人： Eric Barsness , John Santosuosso
发明人： Eric Barsness , John Santosuosso
IPC分类号： G06F7/00
CPC分类号： G06F17/303 , Y10S707/99932
摘要： A method, system and article of manufacture for migration of databases and, more particularly, for optimizing migration of a database from a source system to a target system. One embodiment provides a computer-implemented method for optimizing migration of a database from a source system to a target system. The method comprises collecting source parameters related to performance characteristics for the database on the source system. On the basis of the collected source parameters and target parameters of the target system database configuration information is generated. The target parameters will affect the operation of the database on the target system as compared to the operation of the database on the source system. The database configuration information is applicable to tune the database to operate on the target system. The method further comprises configuring the database to run on the target system according to the database configuration information.
摘要翻译：一种用于数据库迁移的方法，系统和制品，更具体地说，用于优化数据库从源系统到目标系统的迁移。一个实施例提供了一种用于优化数据库从源系统到目标系统的迁移的计算机实现的方法。该方法包括收集与源系统上的数据库的性能特征相关的源参数。在收集的源参数和目标系统的目标参数的基础上，生成配置信息。与源系统上的数据库的操作相比，目标参数将影响目标系统上数据库的操作。数据库配置信息适用于调整数据库以对目标系统进行操作。该方法还包括根据数据库配置信息配置数据库以在目标系统上运行。

2. 发明申请

US20070124274A1 Apparatus and method for autonomic adjustment of resources in a logical partition to improve partitioned query performance 审中-公开
标题翻译：用于自动调整逻辑分区资源的装置和方法，以改善分区查询性能
公开(公告)号：US20070124274A1
公开(公告)日：2007-05-31
申请号：US11290872
申请日：2005-11-30
申请人： Eric Barsness , John Santosuosso
发明人： Eric Barsness , John Santosuosso
IPC分类号： G06F17/30
CPC分类号： G06F16/2471 , G06F16/22
摘要： In a partitioned database system that includes multiple logical partitions, query performance is estimated with a current allocation of resources. A determination is made whether additional resources are available or whether resources could be reallocated from one logical partition to a different logical partition. Query performance is then estimated again with a proposed reallocation of resources. This process continues iteratively until an allocation of resources is determined that will enhance the performance of the query. A resource allocation mechanism then initiates the reallocation of resources. In this manner, resources in logical partitions may be dynamically and autonomically reallocated to improve the performance of a query to a partitioned database.
摘要翻译：在包含多个逻辑分区的分区数据库系统中，使用资源的当前分配来估计查询性能。确定是否有额外的资源可用或资源是否可以从一个逻辑分区重新分配到另一个逻辑分区。然后，建议重新分配资源，再次估计查询性能。该过程继续迭代，直到确定将增强查询性能的资源分配。然后资源分配机制启动资源的重新分配。以这种方式，可以动态地和自主地重新分配逻辑分区中的资源以改进对分区数据库的查询的性能。

3. 发明申请

US20070005631A1 Apparatus and method for dynamically determining index split options from monitored database activity 审中-公开
标题翻译：从监控的数据库活动中动态确定索引拆分选项的装置和方法
公开(公告)号：US20070005631A1
公开(公告)日：2007-01-04
申请号：US11171728
申请日：2005-06-30
申请人： Eric Barsness , Daniel Beuch , John Santosuosso
发明人： Eric Barsness , Daniel Beuch , John Santosuosso
IPC分类号： G06F7/00
CPC分类号： G06F16/2272
摘要： The activity of a database is monitored, and index split options are dynamically determined from the monitored database activity. Appropriate action may then be taken based on the dynamically determined index split options. For example, the index may be automatically split using the dynamically determined index split options. A user command that specifies index split options may be compared to the dynamically determined index split options, and if the user command is not compatible with the dynamically determined index split options, the command may be inhibited, or the user may receive a warning message in response to the command. In addition, existing index use may be monitored, and if the monitored index use indicates the index is split poorly, the index may be re-generated using the dynamically determined index split options.
摘要翻译：监视数据库的活动，并从监视的数据库活动动态确定索引拆分选项。然后可以基于动态确定的索引拆分选项进行适当的动作。例如，可以使用动态确定的索引拆分选项自动拆分索引。可以将指定索引拆分选项的用户命令与动态确定的索引拆分选项进行比较，并且如果用户命令与动态确定的索引拆分选项不兼容，则该命令可能被禁止，或者用户可能接收到警告消息回应命令。此外，可以监视现有的索引使用，并且如果监视的索引使用指示索引被拆分差，则可以使用动态确定的索引拆分选项重新生成索引。

4. 发明申请

US20060155675A1 DATABASE OPTIMIZATION APPARATUS AND METHOD 审中-公开
标题翻译：数据库优化装置和方法
公开(公告)号：US20060155675A1
公开(公告)日：2006-07-13
申请号：US11277229
申请日：2006-03-22
申请人： Jeremy Arnold , Eric Barsness , Richard Dettinger , John Santosuosso
发明人： Jeremy Arnold , Eric Barsness , Richard Dettinger , John Santosuosso
IPC分类号： G06F17/30
CPC分类号： G06F16/211 , Y10S707/99942 , Y10S707/99943
摘要： A database optimizer collects statistics regarding applications accessing a database, and makes one or more changes to the database schema to optimize performance according to the collected statistics. In a first embodiment, the optimizer detects when a certain type of application accesses the database a percentage of time that exceeds a predefined threshold level, and if the data in the database is stored in a less-than-optimal format for the application, the data type of one or more columns in the database is changed to a more optimal format for the application. In a second embodiment, the optimizer detects when one type of application accesses a column a percentage of time that exceeds a first predefined threshold level and is less than a second predefined threshold level, and creates a new column in the database so the data is present in both formats.
摘要翻译：数据库优化器收集有关访问数据库的应用程序的统计信息，并对数据库模式进行一个或多个更改以根据收集的统计信息优化性能。在第一实施例中，优化器检测特定类型的应用程序何时访问数据库超过预定阈值级别的时间百分比，并且如果数据库中的数据以针对应用的不是最佳格式存储，将数据库中的一个或多个列的数据类型更改为应用程序的更优化格式。在第二实施例中，优化器检测何时一个应用程序访问列超过第一预定义阈值级别并小于第二预定义阈值级别的时间百分比，并在数据库中创建新列，以便数据存在在两种格式。

5. 发明申请

US20060085423A1 Rules of engagement for deterministic Web services 审中-公开
标题翻译：确定性Web服务的参与规则
公开(公告)号：US20060085423A1
公开(公告)日：2006-04-20
申请号：US10965190
申请日：2004-10-14
申请人： Eric Barsness , Richard Dettinger , Scott Gerard , Daniel Kolz , Cale Rath , Richard Saltness , John Santosuosso , Richard Stevens , Shannon Wenzel
发明人： Eric Barsness , Richard Dettinger , Scott Gerard , Daniel Kolz , Cale Rath , Richard Saltness , John Santosuosso , Richard Stevens , Shannon Wenzel
IPC分类号： G06F17/30
CPC分类号： H04L41/5083 , G06F16/9574
摘要： Methods, articles of manufacture and systems for managing Web services. One embodiment provides a method comprising providing one or more rules configured to determine whether a Web service is deterministic. A deterministic Web service produces in subsequent executions identical output in response to identical input. The one or more rules are associated with the Web service.
摘要翻译：方法，制造和管理Web服务的系统。一个实施例提供了一种方法，包括提供被配置为确定Web服务是否是确定性的一个或多个规则。确定性Web服务在后续执行中产生相同的输出以响应相同的输入。一个或多个规则与Web服务相关联。

6. 发明申请

US20050256884A1 Optimization of database network traffic based upon data-use analysis 有权
标题翻译：基于数据使用分析优化数据库网络流量
公开(公告)号：US20050256884A1
公开(公告)日：2005-11-17
申请号：US11189395
申请日：2005-07-26
申请人： Jeremy Arnold , Eric Barsness , Richard Dettinger , John Santosuosso
发明人： Jeremy Arnold , Eric Barsness , Richard Dettinger , John Santosuosso
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/3048 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99945
摘要： An apparatus, program product and method utilize one or more usage statistics, which are reflective of what data is actually and/or likely to be used by a client when processing a database query, to reduce or eliminate the transfer of unnecessary data between a client and server in a client-server database management system. Information such as the columns that are or have been used and/or the number of rows that have been accessed, may be utilized to identify certain data that is likely to not be used during processing of the database query. Based upon the data that has been identified, a subset of the data that would otherwise be returned as a result of the database query may be identified and returned to a client, often substantially reducing the amount of data required to be retrieved by a client in connection with a database query.
摘要翻译：一种装置，程序产品和方法利用一个或多个使用统计信息，其反映在处理数据库查询时客户端实际和/或可能使用的数据，以减少或消除客户端之间的不必要数据传输和服务器在客户端 - 服务器数据库管理系统中。可以利用诸如已被使用的列和/或已经被访问的列的数量的信息来标识在处理数据库查询期间可能不被使用的某些数据。基于已经识别的数据，可以识别否则将作为数据库查询的结果返回的数据的子集，并将其返回给客户端，这通常显着地减少客户端需要检索的数据量与数据库查询的连接。

7. 发明申请

US20050240650A1 Service enablement via on demand resources 审中-公开
标题翻译：通过点播资源实现服务支持
公开(公告)号：US20050240650A1
公开(公告)日：2005-10-27
申请号：US10829622
申请日：2004-04-22
申请人： Eric Barsness , John Santosuosso
发明人： Eric Barsness , John Santosuosso
IPC分类号： G06F15/16
CPC分类号： G06Q10/06
摘要： A method, apparatus, system, and signal-bearing medium that in an embodiment determine whether a task is allowed to use a service-enabled resource, wherein the service-enabled resource is disabled until a fee is paid. If the task is allowed to use the service-enabled resource, then the service-enabled resource is allocated to the task. If the task is not allowed to use the service-enabled resource, then a non-service enabled resource is allocated to the task.
摘要翻译：一种方法，装置，系统和信号承载介质，其在一个实施例中确定是否允许任务使用启用服务的资源，其中所述服务使能的资源被禁用，直到支付费用。如果任务被允许使用启用了服务的资源，则将启用服务的资源分配给该任务。如果不允许任务使用启用了服务的资源，则将非服务启用的资源分配给该任务。

8. 发明申请

US20050198636A1 Dynamic optimization of batch processing 审中-公开
标题翻译：批处理的动态优化
公开(公告)号：US20050198636A1
公开(公告)日：2005-09-08
申请号：US10787722
申请日：2004-02-26
申请人： Eric Barsness , Randy Ruhlow , John Santosuosso
发明人： Eric Barsness , Randy Ruhlow , John Santosuosso
IPC分类号： G06F9/46
CPC分类号： G06F9/5027 , G06F9/4881 , G06F9/5072 , G06F9/5077 , G06F11/3409 , G06F11/3419 , G06F11/3452 , G06F11/3466 , G06F2209/5019 , G06F2209/508
摘要： Methods, systems, and computer program products for dynamically adjusting computer resources, as appropriate, in response to predictions of batch runtimes as well as for rendering costs of the computer resources actually utilized, which costs are consistent with customer demands.
摘要翻译：适用于动态调整计算机资源的方法，系统和计算机程序产品，以响应批量运行时间的预测以及实际使用的计算机资源的成本，这些成本与客户需求一致。

9. 发明申请

US20050192937A1 Dynamic query optimization 审中-公开
标题翻译：动态查询优化
公开(公告)号：US20050192937A1
公开(公告)日：2005-09-01
申请号：US10787639
申请日：2004-02-26
申请人： Eric Barsness , Mahdad Majd , Randy Ruhlow , John Santosuosso
发明人： Eric Barsness , Mahdad Majd , Randy Ruhlow , John Santosuosso
IPC分类号： G06F9/50 , G06F17/30
CPC分类号： G06F9/5077 , G06F9/50 , G06F9/5072 , G06F16/24532 , G06F16/24542
摘要： Methods, systems, and computer program products for dynamically adjusting computer resources, as appropriate, in response to predictions of query runtimes as well as for rendering costs of the computer resources actually utilized, which costs are consistent with consumer demands.
摘要翻译：适用于动态调整计算机资源的方法，系统和计算机程序产品，以响应查询运行时间的预测以及实际使用的计算机资源的成本，哪些成本与消费者需求一致。

10. 发明申请

US20050131913A1 Database range constraint that is dynamically limited by data in the database 有权
标题翻译：由数据库中的数据动态限制的数据库范围约束
公开(公告)号：US20050131913A1
公开(公告)日：2005-06-16
申请号：US10733752
申请日：2003-12-11
申请人： Eric Barsness , John Santosuosso
发明人： Eric Barsness , John Santosuosso
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30371
摘要： A dynamic range constraint is defined that has one or more limits that are computed from data residing in the database. In a first embodiment, a dynamic range constraint is defined for a database column that includes at least one limit that is computed from data within that column. In a second embodiment, a dynamic range constraint is defined for a database column that includes at least one limit that is computed from data in a different database column. The limits may be computed using any suitable heuristic or criteria, including statistical analysis of the data in the database. In this manner a range constraint for a column may evolve automatically as the data in the database changes.
摘要翻译：定义了动态范围约束，其具有根据驻留在数据库中的数据计算出的一个或多个限制。在第一实施例中，为数据库列定义动态范围约束，其包括从该列内的数据计算的至少一个限制。在第二实施例中，针对包括从不同数据库列中的数据计算的至少一个限制的数据库列定义动态范围约束。可以使用任何合适的启发式或标准来计算限制，包括数据库中数据的统计分析。以这种方式，列的范围约束可以随着数据库中的数据的变化而自动发展。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式