公开(公告)号：US20060200497A1

公开(公告)日：2006-09-07

申请号：US11072111

申请日：2005-03-03

申请人： Wei Hu ,  Mark Dilman ,  J. Lee ,  Juan Loaiza ,  Vinay Srihari

发明人： Wei Hu ,  Mark Dilman ,  J. Lee ,  Juan Loaiza ,  Vinay Srihari

IPC分类号： G06F17/30

CPC分类号： G06F11/1471 ,  G06F11/2094 ,  G06F2201/80 ,  G06F2211/1007 ,  Y10S707/99954

摘要： Techniques are provided for detecting lost writes so that data corruption can be avoided. According to one technique, lost writes are detected by comparing version numbers that are indicated in redo log entries with version numbers that are indicated in corresponding blocks in a standby database. According to one technique, which may be used in conjunction with the above technique, lost writes are detected by logging read operations that occur relative to a primary database, and comparing version numbers that are indicated in read log entries with version numbers that are indicated in corresponding blocks in a standby database. According to one technique, lost writes are detected by comparing, in response to read operations, (a) version numbers that are stored in a persistent in-memory cache with (b) version numbers that are indicated in corresponding blocks that are read from a primary database.

公开(公告)号：US20050256908A1

公开(公告)日：2005-11-17

申请号：US10966961

申请日：2004-10-15

申请人： Wanli Yang ,  Bipul Sinha ,  Amit Ganesh ,  Wei Hu ,  Alok Pareek ,  Alexander Hwang ,  Steven Wertheimer ,  Francisco Sanchez ,  Dmitry Potapov ,  Shen-Ban Meng ,  Juan Loaiza ,  William Bridge ,  J. Lee

发明人： Wanli Yang ,  Bipul Sinha ,  Amit Ganesh ,  Wei Hu ,  Alok Pareek ,  Alexander Hwang ,  Steven Wertheimer ,  Francisco Sanchez ,  Dmitry Potapov ,  Shen-Ban Meng ,  Juan Loaiza ,  William Bridge ,  J. Lee

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30569 ,  Y10S707/99942

摘要： A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e.g., a password files, and links to externally stored object may be recreated on the target database.

摘要翻译： 提供了一种用于在源平台上基于源数据库在目标平台上创建目标数据库的方法和装置。 基于源数据库中包含的数据，元数据（例如，系统表空间和控制文件中的数据）以及外部对象（例如，密码文件和外部存储的表），在目标平台上创建目标数据库。 存储在源数据库的表空间中的数据和元数据将转换为与目标平台兼容的格式。 可以在源数据库或目标数据库执行数据和元数据的转换。 源数据库的重做信息和撤消信息不会从源数据库复制到目标数据库。 可以在目标数据库上重新创建某些文件，例如密码文件和到外部存储对象的链接。

公开(公告)号：US07337234B2

公开(公告)日：2008-02-26

申请号：US10118203

申请日：2002-04-05

申请人： Wei Hu ,  Juan Loaiza

发明人： Wei Hu ,  Juan Loaiza

IPC分类号： G06F15/173 ,  G06F15/16 ,  G08C25/02 ,  H04L12/28

CPC分类号： H04L67/1002 ,  H04L69/40

摘要： A system is provided to manage retry communications between a client and a data source. The system includes a plurality of logical components that sequentially combine to form a communication path for a client communication. At least one of the components in the communication path is designated as a retry component. The retry component retries failed client communications for all of the components in the communication path.

摘要翻译： 提供了一种系统来管理客户端和数据源之间的重试通信。 系统包括多个逻辑组件，其顺序地组合以形成用于客户端通信的通信路径。 通信路径中的至少一个组件被指定为重试组件。 重试组件重试针对通信路径中所有组件的客户端通信失败。

公开(公告)号：US07631091B2

公开(公告)日：2009-12-08

申请号：US11060897

申请日：2005-02-18

申请人： Wei Hu ,  Juan Loaiza ,  Ramana Yerneni

发明人： Wei Hu ,  Juan Loaiza ,  Ramana Yerneni

IPC分类号： G06F15/16 ,  G06F12/00

CPC分类号： G06F17/30463 ,  G06F17/301

摘要： Disclosed are methods, systems, and mediums for improving system utilization and throughput. In some embodiments, application requests received at a primary site are routed to a secondary site for processing when the requests are found to be suitable for processing at the secondary site.

摘要翻译： 公开了用于提高系统利用率和吞吐量的方法，系统和介质。 在一些实施例中，当发现请求适合于辅助站点处理时，在主站点处接收到的应用请求被路由到辅站点以进行处理。

公开(公告)号：US20070083641A1

公开(公告)日：2007-04-12

申请号：US11245868

申请日：2005-10-07

申请人： Wei Hu ,  Yunrui Li ,  Juan Loaiza

发明人： Wei Hu ,  Yunrui Li ,  Juan Loaiza

IPC分类号： G06F15/173

CPC分类号： H04L67/1097 ,  H04L41/0681 ,  H04L41/0893 ,  H04L43/00 ,  H04L43/0817

摘要： Detecting an operating condition in a multi-server data storage system. One or more of the data storage servers are designated with a status within the cluster. The designating may be performed by at least one of the data storage servers. The status is encoded into log data having records that report changes to the primary data storage performed by the cluster of data storage servers. The log data is transmitted from the primary data storage to the standby data storage system. The standby data storage system determines an operating condition of the cluster of data storage servers based, at least in part, on the status.

摘要翻译： 检测多服务器数据存储系统中的运行状况。 一个或多个数据存储服务器被指定为集群内的状态。 指定可以由数据存储服务器中的至少一个来执行。 该状态被编码成具有报告对由数据存储服务器集群执行的主数据存储的更改的记录的日志数据。 日志数据从主数据存储器传送到备用数据存储系统。 备用数据存储系统至少部分地基于状态来确定数据存储服务器的集群的操作条件。

公开(公告)号：US20060190761A1

公开(公告)日：2006-08-24

申请号：US11060897

申请日：2005-02-18

申请人： Wei Hu ,  Juan Loaiza ,  Ramana Yerneni

发明人： Wei Hu ,  Juan Loaiza ,  Ramana Yerneni

IPC分类号： G06F11/00

CPC分类号： G06F17/30463 ,  G06F17/301

摘要： Disclosed are methods, systems, and mediums for improving system utilization and throughput. In some embodiments, application requests received at a primary site are routed to a secondary site for processing when the requests are found to be suitable for processing at the secondary site.

公开(公告)号：US07673291B2

公开(公告)日：2010-03-02

申请号：US10775531

申请日：2004-02-09

申请人： Karl Dias ,  Shivani Gupta ,  Mark Ramacher ,  Uri Shaft ,  Venkateshwaran Venkataramani ,  Graham S. Wood ,  Juan Loaiza

发明人： Karl Dias ,  Shivani Gupta ,  Mark Ramacher ,  Uri Shaft ,  Venkateshwaran Venkataramani ,  Graham S. Wood ,  Juan Loaiza

IPC分类号： G06F9/44 ,  G06F12/00 ,  G06F11/00

CPC分类号： G06F17/30306 ,  G06F17/30371

摘要： Techniques for self-diagnosing performance problems in a database are provided. The techniques include classifying one or more performance problems in a database system. One or more values for quantifying an impact of the one or more performance problems on the database system are then determined. The quantified values are determined based on the performance of operations in the database system. A performance problem based on the one or more quantified values is then determined. A solution for the performance problem is generated and may be outputted.

摘要翻译： 提供了数据库中自我诊断性能问题的技术。 这些技术包括对数据库系统中的一个或多个性能问题进行分类。 然后确定用于量化一个或多个性能问题对数据库系统的影响的一个或多个值。 量化值基于数据库系统中的操作性能来确定。 然后确定基于一个或多个量化值的性能问题。 产生性能问题的解决方案，并可以输出。

公开(公告)号：US07526767B1

公开(公告)日：2009-04-28

申请号：US09967441

申请日：2001-09-27

申请人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

发明人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

IPC分类号： G06F9/46

CPC分类号： G06F9/5061

摘要： A resource scheduler is provided for allocating a computer system resource to database management system (DBMS) processes. The resource scheduler operates according to resource plans and resource allocation methods. Each plan allocates the resource according to a resource allocation method. During operation of the DBMS, any of the active plans and resource allocation method may be exchanged for alternate plans or resource allocation methods. The resource scheduler enforces an emphasis resource allocation method in which processor time is allocated in percentages to groups of database processes groupified according to common execution requirements. A selected plan includes multiple process groups and/or sub-plans. The resource scheduler allocates processor time in multiple levels among the sub-plans and groups of database processes. Database processes are automatically switched between the groups of a plan according to switch criteria.

摘要翻译： 提供资源调度器用于将计算机系统资源分配给数据库管理系统（DBMS）进程。 资源调度器根据资源计划和资源分配方式进行操作。 每个计划根据资源分配方法分配资源。 在DBMS的操作期间，可以为备用计划或资源分配方法交换任何活动计划和资源分配方法。 资源调度器执行强调资源分配方法，其中处理器时间按照按照常规执行要求分组的数据库进程的分组的百分比分配。 选定的计划包括多个进程组和/或子计划。 资源调度程序在数据库进程的子计划和组之间的多个级别中分配处理器时间。 数据库进程根据切换标准在计划组之间自动切换。

公开(公告)号：US07376682B2

公开(公告)日：2008-05-20

申请号：US10775513

申请日：2004-02-09

申请人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

发明人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

IPC分类号： G06F17/30

CPC分类号： G06F17/30008 ,  Y10S707/99957

摘要： Quantifying the impact of wasteful operations on a database system is provided. One or more operations that are determined to be wasteful are received. The impact of the wasteful operations on performance in a database may then be quantified. The database is monitored to determine when a wasteful operation is being performed. When a wasteful operation is detected, a time value is recorded of the time spent on processing the wasteful operation. The time value is stored and used to quantify an impact of a performance problem in a database. The time value may be stored and associated with other time values that are recorded for the same wasteful operation. Thus, the impact of wasteful operations that are performed and processed in a database may be determined.

摘要翻译： 提供了浪费操作对数据库系统的影响。 接收到被确定为浪费的一个或多个操作。 然后可以量化浪费操作对数据库中的性能的影响。 监视数据库以确定何时执行浪费的操作。 当检测到浪费的操作时，记录处理浪费操作花费的时间的时间值。 时间值被存储并用于量化数据库中性能问题的影响。 时间值可以被存储并且与为相同的浪费操作记录的其他时间值相关联。 因此，可以确定在数据库中执行和处理的浪费操作的影响。

公开(公告)号：US07020878B1

公开(公告)日：2006-03-28

申请号：US09967459

申请日：2001-09-27

申请人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

发明人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

IPC分类号： G06F9/46

CPC分类号： G06F9/4881 ,  G06F2209/5019

摘要： One embodiment of the present invention provides a resource scheduler for allocating a computer system resource, such as memory or mass storage, within a processor, to database management system (DBMS) processes. The resource scheduler operates according to resource plans and resource allocation methods. One or more plans may be configured and loaded with the DBMS. Each plan allocates the resource according to an associated resource allocation method. During operation of the DBMS, any or all of the active plans and resource allocation methods may be exchanged for alternate plans or resource allocation methods. In one embodiment of the invention the resource scheduler enforces a maximum active sessions resource allocation method in which system resources are allocated by limiting the number of active sessions allowed in groups of database processes grouped according to common execution requirements. A selected plan includes multiple process groups and/or sub-plans. The resource scheduler allocates system resources among the sub-plans and groups of database processes according to their associated limits on active session numbers, with sub-plans and groups having higher active session limits getting access to more system resources than sub-plans and groups having lower active session limits.

摘要翻译： 本发明的一个实施例提供了一种资源调度器，用于将处理器内的诸如存储器或大容量存储的计算机系统资源分配给数据库管理系统（DBMS）处理。 资源调度器根据资源计划和资源分配方式进行操作。 一个或多个计划可以配置并加载到DBMS。 每个计划根据相关资源分配方法分配资源。 在DBMS的操作期间，任何或所有活动计划和资源分配方法可以被交换用于替代计划或资源分配方法。 在本发明的一个实施例中，资源调度器执行最大活动会话资源分配方法，其中通过限制根据共同执行需求分组的数据库进程组允许的活动会话的数量来分配系统资源。 选定的计划包括多个进程组和/或子计划。 资源调度程序根据其对活动会话号码的相关限制，在子计划和数据库进程组之间分配系统资源，具有较高活动会话限制的子计划和组比具有子计划和组的子计划和组具有访问更多的系统资源 活动会话限制较低