106 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.

Provided herein is a mechanism that allows a given database system to access data blocks from another database system, where data blocks from the given database system and data blocks from the other database system have different sizes. According to an aspect of the present invention, a tablespace in the other database system contained the data blocks. The tablespace is detached from the other database system and integrated into the given database, which is capable of processing data stored in data blocks of a different sizes.

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.

A method and apparatus for data recovery are disclosed. Undo tablespace size is calculated for user-specified undo retention time based on system statistics collected over a period of time specified by a history time parameter.

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.

A method of searching a data page in a table space of a database for inserting a data record to a first table, wherein the table space comprises space map pages and sets of data pages, wherein each space map page comprises information about the available storage space of one set of data pages, wherein each space map page and the corresponding set of data pages is further assigned to a table range for each table to which at least one data page in the set of data pages belongs to, wherein the database further comprises a clustering index for the first table in the database management system, wherein the database management system comprises a space usage information database, and wherein the space usage information database holds space usage information for each table range.

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 invention provides a storage system that includes a policy manager. The policy manager has a user interface and a policy engine which encodes performance and workload requirements of tablespaces in a policy that is based on user input received through the user interface. Databases are connected to the policy manager and tablespaces are connected to the databases. The databases create the tablespaces, and the databases establish a storage allocation for the tablespace based on the policy. The policy manager detects if the tablespace is out of storage and automatically extends the storage allocation for the tablespace based on the policy, when the tablespace is out of storage.

The invention provides a storage system that includes a policy manager. The policy manager has a user interface and a policy engine which encodes performance and workload requirements of tablespaces in a policy that is based on user input received through the user interface. Databases are connected to the policy manager and tablespaces are connected to the databases. The databases create the tablespaces, and the databases establish a storage allocation for the tablespace based on the policy. The policy manager detects if the tablespace is out of storage and automatically extends the storage allocation for the tablespace based on the policy, when the tablespace is out of storage.

Provided is a method for online reorganization and increasing the page size of a DB2 object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB2 REORG utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets; page size of the allocated shadow data sets is dynamically updated during reorganization. The original data sets are switched with the newly built shadow data sets, and DB2 catalog values and control blocks are updated with new page size values.

A system and method for configuring storage resources for database storage are disclosed. A method may include mapping at least one first tablespace having a first block size to at least one first logical unit. The method may also include mapping the at least one first tablespace and the at least one first logical unit to a first cache having a size equal to the first block size. In addition, the method may include mapping at least one second tablespace having a second block size to at least one second logical unit. The method may further include mapping the at least one second tablespace and the at least one second logical unit to a second cache having a size equal to the second block size.

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.

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.

Embodiments of the present invention disclose a data migration, backup and recovery method and apparatus. The method comprises: recording feature parameters of a plurality of partition tables to obtain a partition information configuration table; establishing a table space, and mapping each partition in each partition table to a corresponding table space to obtain a partition relationship mappingtable; and determining a target partition according to the feature parameters in the partition information configuration table, determining a target table space corresponding to the target partition according to the partition relationship mapping table, and carrying out data migration, backup or recovery on a data file in the target table space, wherein each table space corresponds to at least onedata file. According to the technical scheme of the embodiments of the present invention, by fine-grained partitioning the table, the partitions are respectively established into the corresponding table space, data migration, backup and recovery at any time can be supported, the technical scheme can adapt to various databases, the data granularity of data migration, backup and recovery can be effectively controlled, and the speed of data migration, backup and recovery can be improved.

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.

The invention discloses a heterogeneous replication method for a database. The method comprises the following steps: (a) acquiring process data which are generated in an operation process of a relational database; (b) carrying out separation and extraction on session data and customer data in the acquired process data; (c) storing the separated and extracted session data into a non-relational database, wherein the session data stored in the non-relational database are divided according to the session IDs (identity cards), and comprise SQLID (structured query language identity card), transferred application program, time of duration, transferred SQL (structured query language) quantity, wait events and occupied memory size; storing the session data after sorting according to the time order. According to the heterogeneous replication method for the database provided by the invention, through separation of the session data and the customer data, the session data generated in the operation process of the relational database are stored by virtue of an NoSQL format, thus the monitored data can be stored for a long period of time; occupation in a system tablespace is reduced, and subsequent statistic analysis, fault tracking and performance optimization are facilitated.

The invention belongs to the technical field of database management systems and computer software, and particularly relates to a high-speed data import and export method based on an openGauss platform. Different from a traditional logic import and export method, export is carried out in a mode of copying the table data file, the table data file is copied into a table space of a new database system during import, tuple information in the data file is modified according to the MVCC characteristic of the table data file, as analysis of SQL commands and scanning and filtering of tuples in data files do not need to be carried out, the data import and export performance is remarkably improved, particularly, time consumed for export and import of large table object data is greatly shortened, the efficiency of object migration between databases is improved, meanwhile, the maintenance cost of the data is reduced accordingly, therefore, the defects of low import and export efficiency, high maintenance cost and low processing efficiency of the table data with large data volume under the openGauss platform are well overcome.

A method of reorganizing a tablespace in a database may include reading a row of data from the database, analyzing the row of data read out from the database, determining whether to eliminate or retain the row of data based on at least one predetermined rule, reloading the row of data into the database when it is determined that the row of data complies with the at least one predetermined rule, eliminating the row of data when it is determined that the row of data does not comply with the at least one predetermined rule, and rebuilding an index related to the database to include keys that correspond to the reloaded row of data. The determining, reloading, eliminating and rebuilding steps are repeated for each row of data in the database.