102 results about "Tablespace" patented technology

A method and apparatus are provided for storing data of multiple enterprises in a set of database objects in a database system and allowing multiple enterprises to interact with the database system as if those database objects contained only their data. According to an aspect of the present invention, a database command issued against a database object by a user is modified by adding predicates that limit access to data associated with the enterprise in which the user has data access. The predicates may specify conditions based on a column in the database object that identifies the enterprise. When a user issues a database command to add data to the database object, the column is populated in a manner transparent to the user. The data in the database object that is associated with a particular enterprise is stored in a separate tablespace.

An information recovery system mounts partial database replications, such as selected tablespaces, on a target host.

A system and an associated method selectively process log files for enhancing performance of tablespace recovery by processing only those log files required, and for selecting which log file to process during recovery for both redo and rollback phases of recovery. The system and method skip the processing of log files that do not contain records of interest for the tablespace being recovered and determines whether a log file contains anything that needs to be played, in particular for the recovery of a subsystem in the database, such as a tablespace. Pre processing of the log files is not done, rather including tablespace ID correlated with log file ID information is collected while the log files are created. The cross-correlated information is used during tablespace recovery to selectively determine which of the log files to process. Some log files may be skipped in cases where not all of the database system is being recovered. A sub set of the database can be recovered, such as a tablespace, and which log files to process is determined based on a lock instruction.

The invention provides a method for storing and inquiring mass data tables in a database. The method realizes storage 'partition' of the mass data tables by physical design and logical design of the database instead of depending on whether the database has a partition technology. In the method, reasonable rules are designed according to a plurality of special characteristics of daily reckoning tables, then a table definition is subject to 'partition' design by the rules, which causes the record to be automatically 'distributed' to different storage 'partitions' in the course of inserting into the database; the 'partitioned' daily reckoning table creates a combined view by the rules, and provides an inquiry function by the combined view, thus the achieved daily reckoning table has obvious advantages in terms of data enquiry; and as to the database with limitation on the table space, the data inquiry can be solved even if the mass data of the daily reckoning tables causes the database to reach the upper limit.

An online index building operation is disclosed for building an index from source data with minimal loss of availability to the source data. The source data can be maintained in a relational database system, such as in a tablespace of a DB2® environment. The disclosed operation creates a consistent image of the source data as of a point-in-time and creates an index from the consistent image. Then, the disclosed operation repeats the acts of making the image consistent as of a subsequent point-in-time and updating the index to reflect the subsequent consistent image until substantially caught up with the current changes to the source data. If not caught up, the disclosed operation continues unless it is falling behind at which point the operation terminates. If it is caught up, the disclosed operation locks access to the source data, updates the image to reflect any final changes, updates the index, and allows access to the index.

The invention discloses a system and a method for processing great data amount based on transport tablespace. The system comprises a source platform, a target platform, a data file uploading module and an element data uploading module, wherein the source platform is used for exporting and sending a table space and receiving the tablespace processed by the target platform; the target platform is used for receiving the tablespace sent by the source platform, processing a data file and sending the processed tablespace; and the data file uploading module and the element data uploading module are used for uploading the tablespace derived by the source platform to the target platform and forwarding the tablespace processed by the target platform to the source platform. Compared with the prior art, the system and the method solve the problems of overlong downtime and poor customer experience caused by gradually increasing data amount and operations, such as upgrading a database, splitting ormigrating data, and the like and greatly shorten the downtime.

A relational database load operation is disclosed for loading data into a multi-table tablespace, such as a segmented tablespace in a DB2® environment. In one aspect, the load operation allows one or more tables to be replaced in a single pass of the tablespace without modifying, loading or replacing other tables in the tablespace. Thus, the disclosed operation can replace one or more tables in a single pass of the tablespace without the need to unload and reload tables not targeted for replacement. In another aspect, the load operation allows for a combined operation where one or more tables are replaced and one or more tables are resumed in a single pass of the multi-table tablespace without modifying other tables already residing in the tablespace.

The invention provides a database synchronization method and device, a server and a storage medium, belonging to the field of databases. One embodiment of the method comprises the following steps: obtaining a data change log; analyzing a data change log to obtain a data change record having a tablespace name and a page number, and distributing the data change record to a plurality of areas to be synchronized according to the tablespace name and the page number; starting the same number of working threads as the area to be synchronized, and processing the change of the data change record in thearea to be synchronized in parallel; and after all the worker threads finish the change of the data change record, executing the transaction operation of the data change record, and completing the database synchronization. The database synchronization method and device, server, and storage medium of the present invention can improve the parallel granularity of the data table by copying the analyzed change record in parallel according to the data page level, thereby greatly improving the synchronization speed of the data.

The invention discloses a method for recovering a whole MySQL database. The method is characterized by comprising the following steps that S100, a MySQL database file is carved, wherein a magnetic disk is scanned, file features are searched for, a table data file and a table structure file with the file features are obtained, the files are reconstructed according to the serial number of a data page and a table space identifier, and a table definition file is saved; S200, the database file is correlated, wherein the carved MySQL database file and the engine type of the MySQL database are matched, and the table structure file is correlated with the corresponding table data file; S300, a table structure is recovered, wherein whether the table data file is correlated with the corresponding table structure file or not is judged, if yes, S400 is executed, and otherwise, the table structure is recovered according to the engine type; S400, the database file is recovered.

The present invention is a method, system and apparatus for generating parameterized installation scripts to accommodate the installation of multiple databases sharing similar physical constructs. The method of the invention can include the step of creating a database which can achieve the foregoing stated advantages of the present invention, a parameterized description of a physical data model can be first combined with a set of database specific properties to produce a physical database. A parameterized description of a logical data model can be second combined with the set of database specific properties to generate a logical model for the physical database. The first combining step can include the step of creating at least one bufferpool in the physical database as specified by the properties. Also, the first combining step can include the step of creating at least one tablespace in the physical database as specified by the properties.

A method and apparatus for determining the usage of space in a database is provided. A first set of space usage data that reflects the amount of free space associated with one or more tablespaces of a database is stored at a first database server. A second set of space usage data is retrieved from one or more other database servers. The first set of space usage data and the second set of space usage data are both updated based on changes made to the database by the particular database server storing the space usage data. The first set of space usage data is updated at the first database server with the second set of space usage data. The first database server may evaluate the usage of space in the database based on the updated first set of space usage data.

The invention discloses a method for classify and storing massive sea clutter data, comprising the following steps: (1) constructing a storage system based on an ORACLE RAC shared storage cluster structure; (2) Constructing data storage tablespace to realize sea clutter data storage management; (3) Constructing partition mode to realize the logical classification and storage management of sea clutter data; (4) achieving combined retrieval of sea clutter data based on view virtual association technology. The type of data retrieval is determined by the actual sea clutter application scene. The sea clutter data classification storage method disclosed by the invention constructs a sea clutter data management hardware platform based on an ORACLE RAC shared memory cluster structure, so that thesystem has load balance, high availability service, expandability, and improves the transaction response time through a parallel execution technology.

A system and method for recovering a database table that depends on a tablespace receives a backup copy of the tablespace and reads log records associated with the table. The system then applies the log records to the backup copy and builds new table data pages from the backup copy. Finally, the system scans the new table data pages for records of the first table and updates the table from the records.