Nuodb, Inc.

Dassault Systemes

Seth Theodore Proctor

Oleg Levin

Michael Thomas Rice

Thomas Jonathan Harwood

Yan Avlasov

Paul D Smith

Jacob Getto

Techniques are disclosed for implementing a unified partitioning scheme within distributed database systems to allow a table to be horizontally partitioned and those partitions stored on and serviced by a storage group. A storage group is a subset of storage manager (SM) nodes, and each SM node is configured to persist database data in durable storage. The distributed database system assigns each storage group to a subset of SM nodes. The distributed database system can address each storage group using a symbolic mapping that allows transactions to identify a particular storage group, and to direct read and write operations to a subset of SM nodes servicing that storage group. An administrator can update this mapping on-the-fly to cause the distributed database system to dynamically adjust an implemented partitioning scheme without necessarily interrupting on-going database operations.

Table partitioning within distributed database systems

A data processing network includes a database management for a plurality of databases serviced by a server comprising a plurality of data processors. Each server data processor includes a copy of the database management system and a monitor for measuring and analyzing various parameters for each server data processor and each included database and performing various methods transparently to a user. For example, when a parameter or combination thereof indicates that a database in one data processor is inactive or requires additional resources, that database is set to an inactive state or is transferred to another data processor with greater resources, respectively. An inactive database is recalled upon receipt of a request for access to that database. A database in a data processor of greater resources can be returned to a server data processor or another data processor with fewer resources. These operations are transparent to database users and independent of user or administrator intervention.

Database management system with database hibernation and bursting

Growing community of inventors

Arlington, MA, United States of America

Seth Theodore Proctor