330 results about "Database backup" patented technology

A database management system ensures consistency between primary and mirrored backup copies of a database, despite occurrence of a suspending condition interrupting the normal process of mirroring the primary database. One or more primary controllers are provided, each having a data storage unit with multiple primary data storage devices. Multiple secondary controllers each have multiple associated secondary data storage devices, each secondary controller being coupled to one primary controller. One or more primary databases reside on the primary devices, with a corresponding number of secondary databases residing on the secondary devices. Each secondary database mirrors a corresponding primary database. Either a host, attached to a primary controller, or one of the primary controllers itself, maintains a map cross-referencing each primary and secondary database with the primary and secondary devices containing portions thereof. If a predefined "suspending condition" affecting data mirroring occurs, the host or primary controller consults its map to identify all primary and secondary devices affected by the condition. Then, each primary controller stops all ongoing and future read / writes with each of its affected primary devices. Each primary controller also directs each secondary controller having an affected secondary device to stop mirroring the primary databases stored on that device. Then, the primary controller starts intermediate change recording and resumes read / writes with its primary devices. When the suspending condition ends, each primary controller applies the appropriate logged changes to its secondary database(s) and then reactivates each secondary database.

A system and method store provisioning data supporting a plurality of service providers in a VSIM internal memory unit of a mobile device. A user may selectively enable provisioning data supporting one of the plurality of service providers stored in the VSIM internal memory unit to conduct a wireless communication. An embodiment permits backing up, retrieving and restoring personal data in the VSIM internal memory unit using a remote database. Another embodiment allows a mobile device to select an optimal service provider to conduct a wireless communication. The optimal service provider may be determined based upon mobile device location, communication usage request and / or time and date.

An online primary database is automatically configured to enable a physically consistent snapshot of the primary database at the secondary database to be uniquely mirrored to a secondary remote database as backup while allowing the specialized control audit images to be created at the primary database.

A system for automated installation and maintenance of databases. One or more embodiments provide a user interface (or wizard) that obtains information from a user regarding aspects of the network environment and application data requirements. Using the information obtained from the user, a sizing process builds a database, or resizes an existing database, to efficiently match the needs of the user. An automated maintenance process self monitors, diagnoses, and fixes database problems, such as by rebuilding table keys and indexes. When the diagnostic cannot fix a problem, appropriate notification takes place. In one embodiment, the user information is processed using sizing formulas to obtain values for building the database. Database scripts and command files are generated which, when executed, build the appropriately configured database. Also, in accordance with the user information, scripts and command files may be generated that will implement a database backup process upon a user-specified schedule.

A method and system are provided to enable restoration of a base table and associated catalog table from a database. Table names and table identifiers are copied to a header of a storage media during a backup of the database. When a restore of a designated table is requested, table identifier data is extracted from the header of the storage media housing the backup of the database. Accordingly, the designated base table and associated catalog table(s) are restored from the storage media based upon data stored in the header of the storage media during the backup of the database.

A mechanism to selectively restore a version of an application object stored in a monolithic backup of a database, while maintaining hierarchical and other metadata relationships of the restored portion of the database, is provided. Embodiments of the present invention provide a method, system and computer-readable storage medium that provide a mechanism for receiving a request to restore a version of a selected object from among a plurality of backed up objects in a database backup, locating information associated with the selected object in the backup, and restoring the version of the selected object to a target storage area using information associated with the selected object. Aspects of the present invention use database table metadata gathered from the backed up database at the time the backup was created in order to locate the information associated with the selected object.

In a network of primary and secondary servers having individual databases which are mirrored to each other, there is provided a method to increase resource availability by removal, of already-utilized audit files onto external storage. A TRACKER program for expediting the update of the secondary database will initiate a CopyAudit program which offloads the audit files on the secondary server and then signals the primary server to offload the audit file, of the primary, onto external storage.

A method for performing a consistency check on a database backup of a database is performed without requiring a full recovery of the original database from the database backup. Instead, a database view may be used as a smaller storage requirement tool for providing a transaction-consistent view of portions of an existing full database backup. The database view, in combination with the database backup and transaction log, contains all the information necessary to perform a consistency check on the database backup without a full reconstitution of the original database from the database backup. The consistency check may be run on the database view along with the database backup to verify the integrity of the full database backup to add improved reliability to a database recovery scheme.

A system, method, and medium for performing incremental backups of a Microsoft SQL server database. A snapshot of the database is created, and then a map identifying the changed extents is retrieved from the snapshot. The changed extents are then retrieved from the snapshot and stored in a backup storage device. For a restore operation, a full database backup file is written to a storage device and then the changed extents from a stored incremental backup file may be merged with the full backup file. Next, the database server is notified of the reconstructed file and then the reconstructed file is mounted by the database server as a live instance of the database.

The invention relates to the recovery of data in a database of database records, following a failure of a media containing said database. The data recovery uses a backup of the database and a log of log records detailing any changes in the database which are not captured in the backup. The log is replayed starting with the most recent log record. It is the determined for each successive log record, that relates to an operation on a database record, whether processing the log record will result in the most recent state of the corresponding database record, and if so, the log record is processed. Subsequently additional data is restored from the backup.

Various methods and systems for presenting a logical view of a database backup are disclosed. One method involves querying a database recovery manager for logical identifiers that correspond to physical backup pieces generated during a backup. The method uses the logical identifiers to display a backup view to a user. The backup view identifies logical database components that are available to be restored.

An apparatus, system, and method for creating a database backup schedule in a SAN environment based on a recovery plan. A user provides a desired recovery point objective (RPO) from a system recovery plan and an identifier of a database for back up. The present invention determines a priority (w) for a recent recovery point and determines a number (N) of volumes for storing backup images and a number (n) of database volumes used by the database. The present invention generates a scheduling formula where RPO is divided by the priority (w) of the most recent recovery point raised to the power of the truncated integer value of the ratio of volumes for storing backup images (N) and the number of volumes in use by the database (n) minus a scheduling interval determinant (i). The scheduling formula is used to determine a backup interval and backup assurance points.

A system and method for managing data in a computer system. A backup server is configured to harvest data indicative of logical relationships among data entries in a backup data set. The harvested data and backup data set are stored on a backup medium. Catalog entries are created for both the backup data set and the harvested data. The computer system allows a user to browse the backup catalog, including the logical structure of the content of a particular backup data set. The user may select particular items for restoration from the catalog. In response, the server restores the backup data set and harvested data to a temporary location, identifies data in the harvested data which corresponds to the user's selections, searches the backup data set for the selected items, and initiates restoration of the selected items.

The invention provides a database backup and recovery system based on a block chain technology. The database backup and recovery system comprises a switching center, wherein the switching center is connected with a client side, is connected with one or a plurality of databases and is connected with one or a plurality of block chain nodes through a block chain adapter, and the switching center manages mapping relationships between the plurality of databases and the plurality of block chain nodes for data backup and recovery. The invention also provides a database backup method based on the block chain technology, and a database recovery method based on the block chain technology. The block chain technology is used, the characteristics that the block chain technology can not be tampered and can be permanently stored are utilized, meanwhile, data is distributed in the block chain nodes, overall failure caused by the faults of a center point can be avoided, so that safe and reliable database backup is realized, most of organizations can properly control cost and effectively deploy a backup scheme in existing environment to enable the requirements of most of organizations to be met, and the methods and the system can be generally implemented and have a very wide application scene.

Systems and methods are provided for backing up database storage. A protection policy for database storage is activated at a remote host, wherein the database storage is not physically accessible by the computing device, such that the out-of-band storage is not in communication with the remote host through the computing device. A backup request is transmitted to the remote host comprising data indicative of a volume on the database storage to back up according to the protection policy. A response to the backup request is received comprising staging disk requirements including a required size for a staging disk. A staging disk is determined based on the response. The staging disk is presented to the remote host so that the remote host can perform a backup of the volume to the staging disk using a database backup tool provided by a vendor of the database storage.

The present invention provides a mechanism to selectively restore portions of a monolithically backed up database, while maintaining hierarchical relationships and other metadata relationships of the restored portions of the database. Embodiments of the present invention provide a method, system and computer-readable storage medium that provides for receiving a request to restore a selected object from among a plurality of backed up objects in a database backup, locating information associated with the selected object in the database backup, and restoring the object-to-restore using the information associated with the selected object in a target area. Database table metadata is gathered from the backed up database at the time the backup was created in order to locate the information associated with the selected object.

An automatic database backup and restoration system comprises an interface component that receives statements relating to backing up at least a portion of a first database, the original database resident upon a consumer computing device. A backup component associated with the interface component automatically copies at least the portion of the first database and writes the copied portion to a backup database, the backup database is a full backup of the first database. The consumer computing device can be, for example, one of a laptop computer, a desktop computer, a personal digital assistant, and a cellular phone.

A system and method for backing up a database, where the system has read threads running simultaneously, write threads, and data buffers. Each read thread repeats the following operations until all the data is backed up: read a block of data from the database, compress the data using a dynamic compression ratio which is initialized and adjusted after every compression, write the data to an available data buffer until the data buffer is full, write to the next available data buffer once the data buffer is full, and determine a new compression ratio. A controller determines the new compression ratio using either a method that monitors the timing of system components and / or a method that monitors CPU consumption.

The present invention provides a mechanism to selectively restore portions of a monolithically backed up database, while maintaining hierarchical relationships and other metadata relationships of the restored portions of the database. Embodiments of the present invention provide a method, system and computer-readable storage medium that provides for receiving a request to restore a selected object from among a plurality of backed up objects in a database backup, locating information associated with the selected object in the database backup, and restoring the object-to-restore using the information associated with the selected object in a target area. Database table metadata is gathered from the backed up database at the time the backup was created in order to locate the information associated with the selected object.

Systems and methods are disclosed herein that facilitate automatic database backup and restore for databases resident in personal computing devices, and which are transparent to a user, utilizing database page mirroring. Modifications to a data page in a data file can be validated and written to a backup, or mirror, database and then subsequently written to an original database after a predetermined time. An I / O latch on a mirrored data page can be limited to a duration of a single I / O write operation to facilitate sequential data page writing to each of the databases while mitigating potential for both databases to be written simultaneously, which can detrimentally affect data quality during a recovery operation.

A mechanism to selectively restore portions of a monolithically backed up database, while maintaining security relationships associated with the restored portions of the database is provided. Embodiments of the present invention provide a method, system and computer-readable storage medium for receiving a request to restore a selected object from among a plurality of backed up objects in a database backup, accessing security-related information associated with the selected object in the database backup, restoring the selected object using the information associated with the selected object in a target area, and associating elements of the security-related information with the restored selected object.

The invention relates to a cable line condition monitoring multi-dimensional visual management platform and belongs to the technical field of electric power. According to the cable line condition monitoring multi-dimensional visual management platform, a plurality of sets of data collectors are connected with data receiving servers which are composed of two IBMX3650s; the data receiving servers are connected with data base servers which are composed of two IBMX3650s; the data receiving servers and the data base servers are all connected on the same intranet router; meanwhile, two IBMX3650 servers are used as data base backup servers and connected on an intranet router which is the same as the intranet router of the data base servers; two IBMX3650 servers are used as application servers and also connected on the intranet router which is the same as the intranet router of the data base servers, and client-sides which are connected on an intranet access a service unit which is composed of two IBMX3650 servers through the intranet. An operation management system can be stably and reliably set up, the operation management level is improved, the asset utilization ratio is improved, and asset loss is reduced.

The utility model provides a system for online backup of a database, comprising a database server, a storage array, a backup server and a tape library, wherein the database server is used for operating a database, and using a logic volume of the storage array to store the data of the database; an instruction for carrying out snapshot generation on the logic volume called by the database server is sent to the storage array according to a command for carrying out backup operation on the database from the backup server; the backup server is used for connecting to the database server, pausing input and output of the database on the database server to a storage system, and sending a command for carrying out database backup operation on the database server; mapping information is added to a snapshot volume generated by the storage array, the snapshot volume is loaded according to the mapping information, and the data of the snapshot volume is moved to the tape library; and the storage array is used for carrying out snapshot operation on the logic volume called by the database server according to the instruction from the backup server so as to generate the snapshot volume.

In order to overcome limitations of network connections between a primary host server and a remote secondary host server, the audit file of a primary database is mirrored to an audit file of the remote secondary backup database. A special sensing program called TRACKER operates to speed up the synchronization (duplication) between the primary database and secondary remote database.

A method for restoring back-up of user's databank includes setting up spare databank of the user and the timing task to back up user's data on main used databank to local harddisc in assigned time or at lowload period of the system, receiving user's data in main used databank to spare databank, using the spare one to substitute the main used one at time when the main used can not be used because of the fault.

Embodiments of the present invention disclose a database backup and recovery method, apparatus and system. When recovering a to-be-recovered database, data recovery is performed on the to-be-recovered database by using full backup data of the last full backup time of the to-be-recovered database and record data of the to-be recovered database between the last full backup time and a recovery target time point. By applying the method, apparatus and system disclosed by the embodiments of the present invention, it is avoided that the data between the database recovery target time point and the last database full backup time point before the database recovery target time point is lost as when being recovered, the database is recovered by using only data of the last database full backup before the database recovery target time point when performing recovery on a database, only the last database full backup data before the database recovering target time point is used, the loss of the data between the database recovering target time point and the last database full backup time point before the database recovering target time point is avoided.

The present invention discloses a data backup system for an embedded database, and a method for backing up and restoring data. A backup database storage region and two check code storage spaces are arranged on system hardware storage equipment. A database backup and storage module is also arranged in the data backup system to carry out reading and writing operation on a main database storage region, the backup database storage region and the check code storage spaces and compute, store and judge the check codes. The system achieves a 1+1 protecting function on the database through adding the database backup and storage module in a software layer, reserving data backup space with the same size as that of database space and respectively providing storage space used for storing the check codes for the main database and the backup database simultaneously, thereby guaranteeing that the system can restore the data from the other database when the database has abnormities.

The invention relates to a database backup method and a system thereof. The method includes the steps that a backup information center subsystem receives backup deployment information of a database, is remotely connected with a corresponding database host and sends a remote deployment request to the database host to deploy a backup plane of the database according to the backup deployment information; a database backup subsystem automatically backs up the database according to the backup plane, records backup execution information of each time and stores the backup execution information to the backup information center subsystem; a backup detection subsystem scans the backup execution information stored in the backup information center subsystem, whether every time of backup execution of the database succeeds or not is detected according to the backup execution information, and if not, a warning prompt is output. By means of the database backup method and the system thereof, instantaneity and reliability of database backup can be improved, and unified management of backup of a large scale of distributed databases is facilitated.

The invention relates to a catering service platform system based on a cloud computing platform and a working method thereof. The catering service platform system based on the cloud computing platform comprises a cloud computing platform, a Web server, a foreground client logging-in system and a kitchen management system, wherein the Web server is used for storing the relevant catering Web information of a merchant, a database server, a buffer memory server and a search server are connected with the Web server, the Web server and a Web backup server are connected, and the Web server and a database backup server are connected; the foreground client logging-in system is used for receiving the dish ordering information of customers registered by the cloud computing platform; after the condition that the customers arrive at a restaurant is verified, dishes in the dish ordering information are correspondingly modified, and the dishes are confirmed after the mixture ratio of relevant flavorings is regulated according to the tastes of the customers; and the kitchen management system is used for receiving the information of the dishes after being confirmed by the customers and also arranging an optimal dish output sequence to inform a kitchen of disposing cooking according to the variety of the dishes in the all dish ordering information of the customers. According to the system, the workload of waiters is saved, the operating cost of a restaurant is lowered, and the dining interestingness of customers is enhanced.