Abstract: Systems and methods are disclosed that perform dynamic database schema modification. A database system may receive a request to change a schema. In response to receiving the request to perform the dynamic schema modification, the database system may complete pending transactions and begin modifying the database schema. Any requests to access the database received prior to completion of the modification may be paused, thereby allowing the database to remain online and continue receiving requests while the modification is in progress. After completion of the modification, the paused requests may be resumed.

Abstract: Methods and systems are disclosed to perform online disk data redistribution in a database environment. The methods and systems disclosed herein provide for the redistribution of data across multiple physical disks of a database while when a new physical storage device is added to the database. In embodiments, online redistribution of the data may include creating a temporary file, copying live database from a first physical storage to the temporary file, creating a checkpoint for the database, writing the temporary file to a second physical storage device that is added to the database, and purging the live database file and the temporary database file.

Abstract: Systems and methods are disclosed that perform dynamic database schema modification. A database system may receive a request to change a schema. In response to receiving the request to perform the dynamic schema modification, the database system may complete pending transactions and begin modifying the database schema. Any requests to access the database received prior to completion of the modification may be paused, thereby allowing the database to remain online and continue receiving requests while the modification is in progress. After completion of the modification, the paused requests may be resumed.