System and Method for Time Parameter Based Database Restoration
    153.
    发明申请
    System and Method for Time Parameter Based Database Restoration 审中-公开
    基于时间参数的数据库恢复系统与方法

    公开(公告)号:US20170075775A1

    公开(公告)日:2017-03-16

    申请号:US14855552

    申请日:2015-09-16

    Inventor: RICHARD BANISTER

    Abstract: A system and method are provided for the recovery and restoration of software records of a database server to record iterations previous to the current state of the selected records. This action may be taken in order to overcome the consequences of database corruption. An event-time maybe designated which is applied to select some or all of the earlier but most recent versions of each selected record. The system and method presented include a local target database for the purpose of recording software records to an archive, and may include a remote source database, from which records may be transmitted to the local target database. A restore command may be detected by the database server as sent from the remote source server, as received in an electronic message, as received via an electronics communications network, or as directly input. The local target database may have access to multiple iterations or versions of a software record including the original record version as stored in an archive, and may, upon instruction or command, revert to a previous iteration of a software record stored in the archive if corruption of later iterations is suspected. Alternatively or additionally, the local target database may not be restored with earlier versions of records but the remote source database may be restored with the selected record versions. The software records may optionally be updated in a batch method, or may alternatively be updated in real time, as the software records are created.

    Abstract translation: 提供了一种系统和方法,用于恢复和恢复数据库服务器的软件记录,以记录所选记录的当前状态之前的迭代。 为了克服数据库损坏的后果,可采取这一行动。 可指定的事件时间被应用于选择每个所选记录的早期但最新版本的一些或全部。 所呈现的系统和方法包括用于将软件记录记录到存档的本地目标数据库,并且可以包括远程源数据库,可以从其发送记录到本地目标数据库。 数据库服务器可以通过电子通信网络接收到的电子消息中接收到的数据库服务器或远程源服务器作为直接输入来检测恢复命令。 本地目标数据库可以访问包括存储在归档中的原始记录版本的软件记录的多个迭代或版本,并且可以在指令或命令时恢复到存储在存档中的软件记录的先前迭代,如果腐败 以后的迭代被怀疑。 或者或另外,本地目标数据库可能不能与早期版本的记录一起还原,但远程源数据库可以使用所选记录版本进行还原。 随着软件记录被创建,软件记录可以可选地以批处理方式更新,或者可替代地实时更新。

    Automated local database connection affinity and failover
    155.
    发明授权
    Automated local database connection affinity and failover 有权
    自动本地数据库连接关联和故障切换

    公开(公告)号:US09594653B1

    公开(公告)日:2017-03-14

    申请号:US15232931

    申请日:2016-08-10

    Abstract: A first compute node of a plurality of compute nodes of a database cluster may receive a request for a database transaction from a client application. The client application may be located within the first compute node. A first connection may be established, without regard to whether another compute node has a lighter workload than the first compute node, between the client application and a first database of the database cluster. The first connection may be a local connection, wherein the first database is located within the first compute node. The first compute node may detect that a failure associated with the first database has occurred. The first compute node may execute a failover operation to continue servicing the request for the data. The executing of a failover operation may include establishing a second connection between the client application and a second database of the database cluster.

    Abstract translation: 数据库集群的多个计算节点的第一计算节点可以从客户端应用程序接收对数据库事务的请求。 客户端应用可以位于第一计算节点内。 可以建立第一连接,而不考虑另一个计算节点是否具有比第一计算节点更轻的工作负载,在客户端应用程序和数据库集群的第一个数据库之间。 第一连接可以是本地连接,其中第一数据库位于第一计算节点内。 第一计算节点可以检测到与第一数据库相关联的故障已经发生。 第一个计算节点可以执行故障转移操作,以继续维护数据请求。 执行故障切换操作可以包括在客户端应用和数据库集群的第二数据库之间建立第二连接。

    Multidimensional spatial searching for identifying duplicate crash dumps
    156.
    发明授权
    Multidimensional spatial searching for identifying duplicate crash dumps 有权
    多维空间搜索识别重复的崩溃转储

    公开(公告)号:US09589074B2

    公开(公告)日:2017-03-07

    申请号:US14464556

    申请日:2014-08-20

    Abstract: A method of identifying duplicate crash dumps in a computer system may include receiving a first crash dump caused by an application crash, extracting a first function signature of a function that caused the first crash dump, and searching a datastore of crash dumps for function signatures that substantially match the first function signature. The searching may include performing an approximate string-match between each of the function signatures the first function signature and performing an exact string match between each of the function signatures and the first function signature. The searching may also include combining weighted results of the approximate string-match with weighted results of the exact string match to generate match scores for each of the function signatures, and identifying the function signatures that substantially match the first function signature based on the match scores.

    Abstract translation: 识别计算机系统中的重复故障转储的方法可以包括:接收由应用程序崩溃引起的第一次故障转储,提取导致第一次故障转储的功能的第一功能签名,以及搜索崩溃转储的数据存储区以获得功能签名 基本匹配第一个功能签名。 搜索可以包括在每个功能签名之间执行第一功能签名并在每个功能签名和第一功能签名之间执行精确的字符串匹配的近似字符串匹配。 搜索还可以包括将近似字符串匹配的加权结果与精确字符串匹配的加权结果组合以生成每个功能签名的匹配分数,以及基于匹配分数来识别基本上匹配第一函数签名的函数签名 。

    Point in time recovery support for pending schema definition changes
    157.
    发明授权
    Point in time recovery support for pending schema definition changes 有权
    对待定模式定义更改的及时恢复支持

    公开(公告)号:US09588996B2

    公开(公告)日:2017-03-07

    申请号:US14634065

    申请日:2015-02-27

    Abstract: Recovering data to a point in time before pending definition changes are materialized in a relational database management system. One or more definition changes to a database schema are received. Original data base schema attributes are saved and maintained as point in time metadata in a catalog table until the one or more definition changes have been materialized. During recovery processing, it is determined for each object being recovered whether the object is being recovered to a point in time prior to which the one or more definition changes were materialized. In response to determining that an object is being recovered to a point in time prior to which the one or more definition changes were materialized, the saved point in time metadata is used for the object in the recovery process.

    Abstract translation: 在关系数据库管理系统中将数据恢复到等待定义更改之前的时间点。 接收到对数据库模式的一个或多个定义更改。 原始数据库模式属性将作为目录表中的时间点元数据进行保存和维护,直到实现了一个或多个定义更改。 在恢复处理期间,确定正在恢复的每个对象是否正在将对象恢复到一个或多个定义改变实现之前的时间点。 为了响应于确定对象被恢复到一个或多个定义改变实现之前的时间点,所保存的时间元数据被用于恢复过程中的对象。

    FILE-BASED CLUSTER-TO-CLUSTER REPLICATION RECOVERY
    158.
    发明申请
    FILE-BASED CLUSTER-TO-CLUSTER REPLICATION RECOVERY 有权
    基于文件的集群到集群复制恢复

    公开(公告)号:US20170060701A1

    公开(公告)日:2017-03-02

    申请号:US14836999

    申请日:2015-08-27

    Abstract: Resiliency in file replication scenarios via maintenance of multiple replication queues with differing susceptibility to various sources of data loss. A plurality of requests are received at a first file system location to write to one or more file system objects at the first file system location. Details about the plurality of requests are recorded in at least two replication queues which differ, at least in part, as to types of failures which will cause data loss. Responsive to detection of data loss in one of the replication queues, details about the plurality of requests are retrieved from another of the replication queues.

    Abstract translation: 通过维护多个复制队列对文件复制方案的灵活性,对各种数据丢失源具有不同的敏感性。 在第一文件系统位置处接收多个请求以在第一文件系统位置处写入一个或多个文件系统对象。 关于多个请求的细节被记录在至少两个复制队列中,至少部分地与将导致数据丢失的故障类型不同。 响应于在其中一个复制队列中检测到数据丢失,从另一个复制队列中检索有关多个请求的详细信息。

    READ AHEAD BUFFER PROCESSING
    159.
    发明申请
    READ AHEAD BUFFER PROCESSING 审中-公开
    阅读前面的缓冲处理

    公开(公告)号:US20170052736A1

    公开(公告)日:2017-02-23

    申请号:US15307469

    申请日:2014-05-23

    Abstract: Read data blocks based on a read-amount multiplied by an increment-amount from data storage and write the data blocks to the read-ahead buffer. If the total number of data blocks written to the read-ahead buffer is greater than or equal to the request-amount, then returning to the host the total number of data blocks written to the read-ahead buffer. If the total the number of data blocks written to the read-ahead buffer is less than the request-amount, repeating incrementing the increment-amount and reading data blocks equal to the read-amount multiplied by the increment-amount from the data storage, and writing the read data blocks to the read-ahead buffer until the total number of data blocks written to the read-ahead buffer is greater than or equal to the request-amount.

    Abstract translation: 基于从数据存储乘以增量的读取量读取数据块,并将数据块写入预读缓冲器。 如果写入预读缓冲器的数据块的总数大于或等于请求量,则向主机返回写入预读缓冲器的数据块的总数。 如果写入预读缓冲器的数据块的总数小于请求量,则从数据存储器重复增加增量量并读取等于读取量乘以增量的数据块, 并将读取的数据块写入预读缓冲器,直到写入预读缓冲器的数据块的总数大于或等于请求量。

    CONSISTENT BACKUP OF A DISTRIBUTED DATABASE SYSTEM
    160.
    发明申请
    CONSISTENT BACKUP OF A DISTRIBUTED DATABASE SYSTEM 审中-公开
    分布式数据库系统的一致备份

    公开(公告)号:US20170046231A1

    公开(公告)日:2017-02-16

    申请号:US15335770

    申请日:2016-10-27

    Applicant: SAP SE

    Inventor: Ivan Schreter

    Abstract: In an executing database instance including a plurality of database nodes, creation of a backup of the executing database instance includes creation of a current savepoint in one of the plurality of database nodes by storing first modified pages of a cache of the database node in a datastore of the database node, transmitting a confirmation after storing the first modified pages, repeatedly identifying second modified pages of the cache and storing the identified second modified pages in the datastore, receiving an instruction to enter a critical phase and stopping the repeated identifying and storing in response to the instruction, blocking updates to the database node and transmitting a second confirmation, and receiving a second instruction and, in response to receiving the second instruction, identifying third modified pages of the cache and storing the third modified pages of the cache in the datastore. Pages associated with the current savepoint are identified and stored in the datastore, and the pages associated with the current savepoint are stored in a persistent media.

    Abstract translation: 在包括多个数据库节点的执行数据库实例中,创建执行数据库实例的备份包括通过将数据库节点的高速缓存的第一修改页存储在数据存储中来创建多个数据库节点之一中的当前保存点 在所述数据库节点之后发送确认,重复地识别所述高速缓存的第二修改页面并且将所识别的第二修改页面存储在所述数据存储区中,接收进入关键阶段的指令并停止重复识别和存储 对指令的响应,阻止对数据库节点的更新并发送第二确认,以及接收第二指令,并且响应于接收到第二指令,识别高速缓存的第三修改页,并将高速缓存的第三修改页存储在 数据存储。 与当前保存点相关联的页面被标识并存储在数据存储区中,并且与当前保存点相关联的页面存储在持久介质中。

Patent Agency Ranking