Back to results
US 2007/0168316 A1Published application
Publication activation service
AssigneeMicrosoft Corporation
InventorsAmit Gupta, Andrew Jaffray, Elizabeth Hill
Life of this patent
Estimating the term…
Abstract
Updating a database while minimizing resources on a database server instance. One or more indexes are created prior to propagating updated data associated with the database to a computing device associated with the database server instance for access.
Claims20
A method comprising:
- receiving an indication of an update to a data file;
- receiving one or more indexes created based on the updated data file;
- identifying a database associated with a database server instance based on the received indication;
- removing database files associated with the identified database from the database server instance;
- associating the updated data file and the received indexes with the database server instance in place of the removed database files;
- notifying a computing device associated with the database server instance to access the identified database including the updated data file and the received indexes.
3 more elements
One or more computer-readable media having computer-executable components comprising:
- a signal component for receiving an indication of an update to a data file associated with a database;
- a population component for creating an index based on the updated data file;
- a validation component for validating the updated data file and the index created by the propagation component;
- a detach component for removing, from the database server instance, database files associated with the database;
- a propagation component for replacing the database files removed by the detach component with the updated data file validated by the validation component and the index created by the population component;
- and
- an attach component for associating the updated data file and the index with the database-server instance in place of the database files removed by the detach component to update the database.
4 more elements
A system comprising:
- means for receiving an indication of an update to a data file associated with one or more of a plurality of databases;
- means for creating indexes based on the updated data file;
- means for identifying the one or more of the plurality of databases based on the received indication;
- means for detaching each of the identified one or more of the plurality of databases from a database server instance associated therewith;
- means for copying the updated data file and the created indexes to each of the detached one or more of the plurality of databases to update each of the detached one or more of the plurality of databases;
- and
- means for attaching each of the updated one or more of the plurality of databases to the database server instance associated therewith.
4 more elements
Dependencies are inferred from the claim text.