公开(公告)号：US20110202667A1

公开(公告)日：2011-08-18

申请号：US12707675

申请日：2010-02-18

申请人： Andrew E. Kimball ,  Jeffrey R. Currier ,  Xiaoyu Wu ,  Zhongwei Wu

发明人： Andrew E. Kimball ,  Jeffrey R. Currier ,  Xiaoyu Wu ,  Zhongwei Wu

IPC分类号： G06F15/16

CPC分类号： G06F21/6227 ,  G06F17/30227 ,  G06F17/30368 ,  G06F17/3056 ,  G06F21/33 ,  H04L63/0281 ,  H04L67/1014 ,  H04L67/1021 ,  H04L67/2814

摘要： Aspects of the subject matter described herein relate database virtualization. In aspects, clusters of database servers may be located at various locations of the Internet. When a client seeks to access a logical database, the client may send a logical server and logical database name in a data structure. These names may be used to find a physical server(s) and database(s) that correspond to the logical database. Once the location is determined, a proxy component is used to intercept and/or forward communications between the client and the physical server(s) and database(s) corresponding to the logical database. Using this system, a client may access data from a logical database without knowing the physical address of the logical user database.

摘要翻译： 本文描述的主题的方面涉及数据库虚拟化。 在方面，数据库服务器的集群可以位于因特网的各个位置。 当客户端寻求访问逻辑数据库时，客户端可以在数据结构中发送逻辑服务器和逻辑数据库名称。 这些名称可用于查找与逻辑数据库对应的物理服务器和数据库。 一旦确定了位置，代理组件被用于拦截和/或转发客户端与对应于逻辑数据库的物理服务器和数据库之间的通信。 使用该系统，客户端可以在不知道逻辑用户数据库的物理地址的情况下从逻辑数据库访问数据。

公开(公告)号：US08645550B2

公开(公告)日：2014-02-04

申请号：US12707675

申请日：2010-02-18

申请人： Andrew E. Kimball ,  Jeffrey R. Currier ,  Xiaoyu Wu ,  Zhongwei Wu

发明人： Andrew E. Kimball ,  Jeffrey R. Currier ,  Xiaoyu Wu ,  Zhongwei Wu

IPC分类号： G06F15/16

CPC分类号： G06F21/6227 ,  G06F17/30227 ,  G06F17/30368 ,  G06F17/3056 ,  G06F21/33 ,  H04L63/0281 ,  H04L67/1014 ,  H04L67/1021 ,  H04L67/2814

摘要： Aspects of the subject matter described herein relate database virtualization. In aspects, clusters of database servers may be located at various locations of the Internet. When a client seeks to access a logical database, the client may send a logical server and logical database name in a data structure. These names may be used to find a physical server(s) and database(s) that correspond to the logical database. Once the location is determined, a proxy component is used to intercept and/or forward communications between the client and the physical server(s) and database(s) corresponding to the logical database. Using this system, a client may access data from a logical database without knowing the physical address of the logical user database.

摘要翻译： 本文描述的主题的方面涉及数据库虚拟化。 在方面，数据库服务器的集群可以位于因特网的各个位置。 当客户端寻求访问逻辑数据库时，客户端可以在数据结构中发送逻辑服务器和逻辑数据库名称。 这些名称可用于查找与逻辑数据库对应的物理服务器和数据库。 一旦确定了位置，代理组件被用于拦截和/或转发客户端与对应于逻辑数据库的物理服务器和数据库之间的通信。 使用该系统，客户端可以在不知道逻辑用户数据库的物理地址的情况下从逻辑数据库访问数据。

公开(公告)号：US20110184915A1

公开(公告)日：2011-07-28

申请号：US12695166

申请日：2010-01-28

申请人： Zhongwei Wu ,  Oliver N. Seeliger ,  Santeri Olavi Voutilainen ,  Ajay Kalhan ,  Sandeep Lingam

发明人： Zhongwei Wu ,  Oliver N. Seeliger ,  Santeri Olavi Voutilainen ,  Ajay Kalhan ,  Sandeep Lingam

IPC分类号： G06F17/30

CPC分类号： G06F16/278 ,  G06F16/27

摘要： Architecture that facilitates the restoration of a cluster database in a scalable way using backups (e.g., SQL database backups) and a partition rebuild mechanism to achieve a high level of partition level data consistency, even when restore fails on individual machines and/or machine failure occurs. The architecture restores replicas of the partitions in consideration that the backups may be created at different points and at different times. Optimized parallelism is achieved in restoring each database machine using local backups, which eliminates cross-machine network traffic. Thus, fast recovery of the distributed database can be accomplished on the order of hours over thousands of machines and terabytes of data.

摘要翻译： 使用备份（例如，SQL数据库备份）和分区重建机制，以可扩展的方式恢复集群数据库的架构，即使在单个机器和/或机器故障上恢复失败时也能实现高水平的分区级数据一致性 发生。 考虑到可以在不同时间点和不同时间创建备份，该体系结构将恢复分区的副本。 在使用本地备份恢复每个数据库机器时实现了优化的并行性，从而消除了跨机器网络流量。 因此，分布式数据库的快速恢复可以在数千个机器和TB数据的数小时内完成。

公开(公告)号：US20200073698A1

公开(公告)日：2020-03-05

申请号：US16120732

申请日：2018-09-04

申请人： Zhongwei Wu

发明人： Zhongwei Wu

IPC分类号： G06F9/46 ,  H04L9/06 ,  G06F17/30

摘要： A distributed transaction network for processing and verifying transactions asynchronously between transaction parties comprising a transferor and a transferee, the transferor having an obligation to transfer control of assets to the transferee. Each transaction party is randomly assigned a verifier upon it joining the network, which verifies the transaction of its transaction party by ensuring the asset of the transferor satisfies the transaction obligation and no fork condition exists. The transaction is executed only upon every verifier verifying and signing the transaction. The distributed transaction network further has a directed acyclic transaction map comprising topologically sorted transactions forming a single transaction path of sequentially executed transactions for each transaction party, to prevent the occurrence of race conditions, double spend, or fork conditions. The transaction network further comprises a global consensus mechanism to detect and replace failing verifiers and reverse invalid transactions which were improperly signed by the failing verifiers.

公开(公告)号：US20110191299A1

公开(公告)日：2011-08-04

申请号：US12697302

申请日：2010-02-01

申请人： Hanh Huynh Huu ,  Zhongwei Wu ,  Oliver N. Seeliger ,  Shankar Pal ,  Christian Rober ,  Bruno H.M. Denuit ,  Lev Novik ,  Nigel R. Ellis ,  Tomas Talius

发明人： Hanh Huynh Huu ,  Zhongwei Wu ,  Oliver N. Seeliger ,  Shankar Pal ,  Christian Rober ,  Bruno H.M. Denuit ,  Lev Novik ,  Nigel R. Ellis ,  Tomas Talius

IPC分类号： G06F17/30

CPC分类号： G06F17/30

摘要： Architecture that eliminates the need for on-disk full backups of data retaining only changes that have occurred, in a separate table. Thus, the architecture provides for incremental recovery of incremental changes in a relational database (e.g., SQL). The architecture provides improved recovery time and recovery point objectives. By using the incremental capture of changed data (e.g., in an XML format), the capability is provided to capture schema changes, query the incremental change data and efficiently restore user data to an earlier point-in-time state. Changes (e.g., insert, update and delete operations) are tracked (e.g., continuously) by a set of triggers and the incrementally captured changed rows are inserted in a data capture table (a differential change “delta” table) in a human-readable format (e.g., XML). Rollback is also provided.

摘要翻译： 架构，消除了在单独的表中仅保留已发生的更改的数据的磁盘完全备份的数据。 因此，架构提供了关系数据库（例如，SQL）中增量更改的增量恢复。 该架构提供了改进的恢复时间和恢复点目标。 通过使用改变的数据的增量捕获（例如，以XML格式），提供能力来捕获模式改变，查询增量变化数据并有效地将用户数据恢复到较早的时间点状态。 更改（例如，插入，更新和删除操作）被一组触发器跟踪（例如，连续地），并且增量捕获的改变的行被插入到人类可读的数据捕获表（差分变化“delta”表）中 格式（例如，XML）。 还提供回滚。

公开(公告)号：US20060242167A1

公开(公告)日：2006-10-26

申请号：US11113112

申请日：2005-04-22

申请人： Siddhartha Singh ,  Li Liang ,  Zhongwei Wu ,  Tiberiu Doman

发明人： Siddhartha Singh ,  Li Liang ,  Zhongwei Wu ,  Tiberiu Doman

IPC分类号： G06F17/00

CPC分类号： G06F16/10

摘要： A test library for use with a database storage system such as WinFS provides users with a WinFS schema agnostic way to test the WinFS store application programming interfaces (APIs) and to use the WinFS store APIs to populate the WinFS store with randomly generated data. The WinFS test library provides users with an object layer that they can program against to carry out multiple tasks on the WinFS store. Tests can use the WinFS test library to generate schema-agnostic tests that do not break if a schema is changed or removed. For instance, a user can create a WinFS schema and install it in a WinFS store. The WinFS test library will automatically validate that the schema and all of its declared types are properly installed in the store. It will also generate instances of each type, set randomly generated values for every property including nested types, call the store API to create them in the store, and then select values from the store and validate that they were set property. The WinFS test library also automatically validates Update and Delete of the types. The WinFS test library also describes both the store types (metadata) and the store data in the same framework, making it straightforward to write tests on unknown schemas.

摘要翻译： 用于数据库存储系统（如WinFS）的测试库为用户提供了一种WinFS架构无关方式来测试WinFS存储应用程序编程接口（API），并使用WinFS存储API使用随机生成的数据填充WinFS存储。 WinFS测试库为用户提供了一个对象层，可以对其进行编程，以在WinFS存储上执行多个任务。 测试可以使用WinFS测试库来生成模式不可知测试，如果模式被更改或删除，则不会中断。 例如，用户可以创建一个WinFS架构并将其安装在WinFS存储中。 WinFS测试库将自动验证模式及其所有声明的类型是否已正确安装在存储中。 它还将生成每个类型的实例，为包含嵌套类型的每个属性设置随机生成的值，调用存储API在存储中创建它们，然后从存储中选择值并验证它们是否已设置属性。 WinFS测试库还会自动验证类型的更新和删除。 WinFS测试库还在同一框架中同时描述了存储类型（元数据）和存储数据，使得在未知模式上编写测试变得简单直观。

公开(公告)号：US10713086B2

公开(公告)日：2020-07-14

申请号：US16120732

申请日：2018-09-04

申请人： Zhongwei Wu

发明人： Zhongwei Wu

IPC分类号： G06F9/46 ,  H04L9/06 ,  G06F16/23

摘要： A distributed transaction network for processing and verifying transactions asynchronously between transaction parties comprising a transferor and a transferee, the transferor having an obligation to transfer control of assets to the transferee. Each transaction party is randomly assigned a verifier upon it joining the network, which verifies the transaction of its transaction party by ensuring the asset of the transferor satisfies the transaction obligation and no fork condition exists. The transaction is executed only upon every verifier verifying and signing the transaction. The distributed transaction network further has a directed acyclic transaction map comprising topologically sorted transactions forming a single transaction path of sequentially executed transactions for each transaction party, to prevent the occurrence of race conditions, double spend, or fork conditions. The transaction network further comprises a global consensus mechanism to detect and replace failing verifiers and reverse invalid transactions which were improperly signed by the failing verifiers.

公开(公告)号：US08825601B2

公开(公告)日：2014-09-02

申请号：US12697302

申请日：2010-02-01

申请人： Hanh Huynh Huu ,  Zhongwei Wu ,  Oliver N. Seeliger ,  Shankar Pal ,  Christian Rober ,  Bruno H. M. Denuit ,  Lev Novik ,  Nigel R. Ellis ,  Tomas Talius

发明人： Hanh Huynh Huu ,  Zhongwei Wu ,  Oliver N. Seeliger ,  Shankar Pal ,  Christian Rober ,  Bruno H. M. Denuit ,  Lev Novik ,  Nigel R. Ellis ,  Tomas Talius

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

CPC分类号： G06F17/30

摘要： Architecture that eliminates the need for on-disk full backups of data retaining only changes that have occurred, in a separate table. Thus, the architecture provides for incremental recovery of incremental changes in a relational database (e.g., SQL). The architecture provides improved recovery time and recovery point objectives. By using the incremental capture of changed data (e.g., in an XML format), the capability is provided to capture schema changes, query the incremental change data and efficiently restore user data to an earlier point-in-time state. Changes (e.g., insert, update and delete operations) are tracked (e.g., continuously) by a set of triggers and the incrementally captured changed rows are inserted in a data capture table (a differential change “delta” table) in a human-readable format (e.g., XML). Rollback is also provided.

摘要翻译： 架构，消除了在单独的表中仅保留已发生的更改的数据的磁盘完全备份的数据。 因此，架构提供了关系数据库（例如，SQL）中增量更改的增量恢复。 该架构提供了改进的恢复时间和恢复点目标。 通过使用改变的数据的增量捕获（例如，以XML格式），提供能力来捕获模式改变，查询增量变化数据并有效地将用户数据恢复到较早的时间点状态。 通过一组触发器跟踪（例如，插入，更新和删除操作）更改（例如，连续地），并且增量捕获的改变的行被插入到人类可读的数据捕获表（差分变化“delta”表）中 格式（例如，XML）。 还提供回滚。