Centralized database system with geographically partitioned data

A system comprising:

• a local storage device;
• a plurality of remote storage devices;
• and
• a database manager that is configured to perform a method for storing documents in a centralized database system based on geographical data localization, the method comprising:
• receiving a request to create a document according to a data localization criterion;
• creating the document in a local storage device of the centralized database system;
• determining the geographical location for the document based on an attribute of the document matching the localization criterion;
• creating a remote copy of the document on a storage device that is physically located in the geographical location, wherein the remote copy of the document includes a symbolic representation that corresponds to the geographical location;
• and
• modifying the local copy of the document to include a location information of the remote copy, wherein the database manager asynchronously copies application data from the local copy to the remote copy before modifying the local copy.

A computer program product comprising a storage medium readable by one or more processing circuits, the storage medium storing instructions executable by the one or more processing circuits to cause a method for storing documents in a centralized database system based on geographical data localization to be performed, the method comprising:

• receiving a request to create a document according to a data localization criterion;
• creating the document in a local storage device of the centralized database system;
• determining the geographical location for the document based on an attribute of the document matching the localization criterion;
• creating a remote copy of the document on a storage device that is physically located in the geographical location, wherein the remote copy of the document includes a symbolic representation that corresponds to the geographical location;
• and
• modifying the local copy of the document to include a location information of the remote copy, wherein the database manager asynchronously copies application data from the local copy to the remote copy before modifying the local copy.