CN110019229B - Database configuration system - Google Patents
Database configuration system Download PDFInfo
- Publication number
- CN110019229B CN110019229B CN201711422879.9A CN201711422879A CN110019229B CN 110019229 B CN110019229 B CN 110019229B CN 201711422879 A CN201711422879 A CN 201711422879A CN 110019229 B CN110019229 B CN 110019229B
- Authority
- CN
- China
- Prior art keywords
- configuration
- database
- configuration module
- tablespace
- size
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/61—Installation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application provides a database configuration system, which at least comprises the following modules: the first configuration module is at least used for configuring a tablespace and also used for configuring data associated with the tablespace, and the configuration of the tablespace comprises a cataloging tablespace and the configuration thereof; the second configuration module is at least used for allocating and configuring the tablespaces when the first configuration module allocates the tablespaces, so that the complexity of the DB2 database system is simplified, the DB2 database system configuration process is simplified, and the deployment time cost of the database is reduced.
Description
Technical Field
The embodiment of the application relates to the technical field of data, in particular to a database configuration system.
Background
A database management system (dbms) is a large software for manipulating and managing databases, which is used to build, use and maintain the databases. The user accesses the data in the database through dbms, and the database administrator also performs maintenance work on the database through the dbms. It enables multiple applications and users to build, modify and query databases in different ways, either at the same time or at different times.
IBM DB2 is a set of relational database management systems developed by IBM corporation of America, each serving on a different operating system platform. The DB2 product is UNIX-based and personal computer operating systems, but DB2 pursues ORACLE's database product in terms of UNIX-based systems and microsoft Access under windows systems.
The DB2 is mainly applied to large application systems, has good scalability, can support environments from mainframes to single users, and is applied to all common server operating system platforms. IBM DB2 provides a high level of data utilization, integrity, security, recoverability, and execution capabilities for small to large scale applications with platform independent basic functions and SQL commands.
However, the DB2 database system is complex and cumbersome to configure. The deployment of the database takes a lot of time to develop the operation and maintenance.
Disclosure of Invention
In view of the above, one of the technical problems to be solved by the embodiments of the present invention is to provide a database configuration system to overcome the above-mentioned drawbacks in the prior art.
The embodiment of the application provides a database configuration system, which at least comprises the following modules:
the first configuration module is at least used for configuring a tablespace and also used for configuring data associated with the tablespace, and the configuration of the tablespace comprises a cataloging tablespace and the configuration thereof;
a second configuration module, configured to perform allocation and configuration of the tablespace at least when the first configuration module performs configuration of the tablespace.
Optionally, in any embodiment of the present invention, the first configuration module is further configured to configure the buffer pool.
Optionally, in any embodiment of the present invention, the first configuration module is further configured to configure a database, where the database is associated with at least one of the tablespace and the buffer pool.
Optionally, in any embodiment of the present invention, when configuring the database, the first configuration module includes at least one configuration of a database partition group configuration, a belonging partition number configuration, partition data, a page number, a buffer pool size configuration, and a page size configuration.
Optionally, in any embodiment of the present invention, the first configuration module is further configured to perform a first tablespace configuration, and when configuring the first tablespace, the first configuration module includes configuring at least one of a type of tablespace, a name of tablespace, a group of affiliated database partitions, a page size, a type of tablespace management, a number of affiliated containers, a type of affiliated containers, a path of containers, a size of containers, whether to expand, a growth size, an expansion size, a reserved size, and a buffer pool used.
Optionally, in any embodiment of the present invention, the first configuration module is further configured to perform a second tablespace configuration, and when configuring the second tablespace, the first configuration module includes at least one of a tablespace type, a tablespace name, a belonging database partition group, a page size, a tablespace management type, a container number, a container type, a container size, an automatic expansion size, a maximum size, an expansion size, a prefetch size, and a used buffer pool.
Optionally, in any embodiment of the present invention, at least one of the following modules is further included:
a third configuration module, configured to at least perform script address configuration, where the script address configuration is used to perform configuration of a file export path;
a fourth configuration module, configured to at least configure a storage node of a database;
a fifth configuration module, configured to at least perform database variable configuration;
a sixth configuration module for at least database manager configuration;
a seventh configuration module, configured to at least perform database parameter configuration;
an eighth configuration module, the eighth configuration module at least configured to perform operating system script configuration.
Optionally, in any embodiment of the present invention, when the third configuration module is included, the third configuration module configures at least one of a path of a file, a name of a file in a buffer pool and a tablespace, a name of a database registration variable configuration file, a name of a database manager parameter configuration file, and a name of a database parameter configuration file when performing script address configuration;
when the configuration module comprises the fourth configuration module, the fourth configuration module configures at least one of the configurations of bare equipment, file system selection, size, RAID group number, stripe size, NA number, and RG read-write ratio when configuring the storage node of the output database;
when the sixth configuration module is included, the sixth configuration module configures at least one of a parameter configuration and an HA handover configuration of the database manager when performing the configuration of the database manager;
when the device comprises a seventh configuration module, the seventh configuration module configures at least one of a database name, a user identifier, a user password and a parameter identifier when configuring the database parameters.
Optionally, in any embodiment of the present invention, the second configuration module configures at least one of a table space in which a user table is located, an index table space, a large field table space, and a table type when performing the allocation configuration of the table space.
Optionally, in any embodiment of the present invention, the second configuration module configures at least one of a serial number, a physical table name, a physical table description, a table type, a node partition key, a range partition key, a minimum value, a maximum value containing boundary, a partition size, a table space list to which the partition table belongs, an index table space list to which the partition table belongs, a dimension, a retention period, a record size, a peak transaction daily data amount, an annual data amount, a storage space, a data storage table space size estimation, and record data when performing allocation configuration of the table space.
In the embodiment of the application, the database configuration system at least comprises a first configuration module and a second configuration module, wherein the first configuration module is at least used for configuring the tablespace and also used for configuring the data associated with the tablespace, and the configuration of the tablespace comprises the cataloging tablespace and the configuration thereof; the second configuration module is at least used for allocating and configuring the tablespaces when the first configuration module allocates the tablespaces, so that a modularized configuration idea is provided, and a separate configuration file can be generated for each configuration module, thereby simplifying the complexity of the DB2 database system, simplifying the DB2 database system configuration process, and reducing the deployment time cost of the database.
Drawings
Some specific embodiments of the present application will be described in detail hereinafter by way of illustration and not limitation with reference to the accompanying drawings. The same reference numbers in the drawings identify the same or similar elements or components. Those skilled in the art will appreciate that the drawings are not necessarily drawn to scale. In the drawings:
fig. 1 is a schematic structural diagram of a database configuration system according to an embodiment of the present application;
fig. 2 is a schematic structural diagram of a database configuration system according to a second embodiment of the present invention.
Detailed Description
It is not necessary for any particular embodiment of the invention to achieve all of the above advantages at the same time.
In order to make those skilled in the art better understand the technical solutions in the embodiments of the present invention, the technical solutions in the embodiments of the present invention will be described clearly and completely with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all embodiments. All other embodiments obtained by a person skilled in the art based on the embodiments of the present invention shall fall within the scope of the protection of the embodiments of the present invention.
The following further describes specific implementation of the embodiments of the present invention with reference to the drawings.
Fig. 1 is a schematic structural diagram of a database configuration system according to an embodiment of the present application; as shown in fig. 1, the system comprises at least a first configuration module 101 and a second configuration module 102, wherein:
the first configuration module 101 is at least used for configuring a tablespace, and is also used for configuring data associated with the tablespace, and when configuring the tablespace, the first configuration module includes a catalog tablespace and a configuration thereof;
the second configuration module 102 is at least used for performing allocation configuration of the tablespace when the first configuration module 101 is used for performing configuration of the tablespace.
In a specific implementation, the first configuration module 101 may be a tablespace configuration module, where the tablespace configuration module is further configured to perform a first tablespace configuration, for example, a catalog tablespace configuration, and the tablespace configuration module, when configuring the first tablespace, configures at least one of a type of tablespace, a tablespace name, a belonging database partition group, a page size, a tablespace management type, a belonging container number, a belonging container type, a container path, a container size, whether to expand, a growth size, an expansion size, a reserved size, and a used buffer pool.
In another specific implementation, the tablespace configuration module is further configured to perform a second tablespace configuration, where the first configuration module 101 configures at least one of a tablespace type, a tablespace name, a belonging database partition group, a page size, a tablespace management type, a container number, a container type, a container size, an automatic expansion growth size (unit: M), a maximum size (unit: G), an expansion size, a prefetch size, and a used buffer pool when configuring the second tablespace.
In yet another embodiment, the first configuration module 101 may be a buffer pool and table space configuration module, and the buffer pool and table space configuration module may participate in the above description of the configuration of the table space.
The buffer pool and tablespace configuration module is further configured to configure a database, where the database is associated with at least one of the tablespace and the buffer pool.
Specifically, the buffer pool and table space configuration module, when configuring the database, includes at least one configuration of database partition group configuration, belonging partition number configuration, partition data, page number, buffer pool size configuration, and page size configuration. The configuration of the database may be associated with the configuration of the buffer pool. When configuring the buffer pool, the buffer pool names may be set, and the default is IBMDEFAULTBP and BP _ SHARE _32k, and the buffer pool names may be manually added.
In this embodiment, the second configuration module 102 configures at least one of a table space, an index table space, a large field table space, and a table type where a user table is located when performing the allocation configuration of the table space.
Specifically, the allocation configuration of the table space may include, but is not limited to: the method comprises the following steps of configuring at least one of a serial number, a physical table name, a physical table description, a table type, a node partition key, a range partition key, a minimum value, a maximum value containing boundary, a partition size, a partition table space list, an index table space list, a dimension, a retention period (D/M/Y), a record size (byte), a peak transaction daily data volume (bar), a year data volume, a storage space (byte), a data storage table space size estimation (G) and record data.
FIG. 2 is a schematic structural diagram of a database configuration system according to a second embodiment of the present invention; as shown in fig. 2, the system includes, in addition to the first configuration module 101 and the second configuration module 102 of fig. 1, a third configuration module 103, a fourth configuration module 104, a fifth configuration module 105, a sixth configuration module 106, a seventh configuration module 107, and an eighth configuration module 108, wherein:
the third configuration module 103 is at least configured to perform script address configuration, where the script address configuration is used to perform configuration of a file export path.
In a specific implementation, the third configuration module 103 may specifically be a script address configuration module, and in this embodiment, the third configuration module 103 configures at least one of a path of a file, a buffer pool, and a file name of a tablespace, a database registration variable configuration file name, a database manager parameter configuration file name, and a database parameter configuration file name when performing script address configuration.
The fourth configuration module 104 is at least used for configuring a storage node of a database. In a specific implementation, the fourth configuration module 104 may specifically be a data storage partitioning configuration module, where the data storage partitioning configuration module is specifically configured to configure at least one of configurations of a bare device, a file system selection, a size, a RAID group number, a stripe size, an NA number, and an RG read-write ratio.
The fifth configuration module 105 is at least used for configuring database variables. In a specific implementation, the fifth configuration module 105 may be specifically a database variable configuration module, configured to perform configuration of registered variables of a database, including but not limited to the following variables, as shown in table one:
register variables for table-database
The sixth configuration module 106 is used at least for database manager configuration. The sixth configuration module 106 configures at least one of a parameter configuration of the database manager and an HA handover configuration when performing the configuration of the database manager.
In a specific implementation, the sixth configuration module 106 may specifically be a database manager configuration module, and when performing the configuration of the database manager, the following parameters may be configured, as shown in table two:
table-database manager configuration parameters
| INTRA_PARALLEL |
| MAX_QUERYDEGREE |
| INSTANCE_MEMORY |
| SHEAPTHRES |
| NUM_INITAGENTS |
| NUM_POOLAGENTS |
| ASLHEAPSZ |
| RQRIOBLK |
| KEEPFENCED |
| MAX_CONNECTIONS |
| MAX_COORDAGENTS |
| SVCENAME |
The seventh configuration module 107 is at least used for configuring database parameters; in a specific implementation, the fourth configuration module 104 may specifically be a database parameter configuration module, and the database parameter configuration module configures at least one of a database name, a user identifier, a user password, and a parameter identifier when performing database parameter configuration.
The parameters configured by the database parameter configuration module are shown in table three:
parameters configured by parameter configuration module of table three database
The eighth configuration module 108 is at least configured to perform operating system script configuration; specifically, the eighth configuration module 108 is an os script configuration module, and the parameters configured by the os script configuration module are shown in table four:
configuration parameters of table four operating system script configuration module
It should be noted that fig. 2 includes a first configuration module 101, a second configuration module 102, a third configuration module 103, a fourth configuration module 104, a fifth configuration module 105, a sixth configuration module 106, a seventh configuration module 107, and an eighth configuration module 108. However, in other embodiments, all of the third configuration module 103, the fourth configuration module 104, the fifth configuration module 105, the sixth configuration module 106, the seventh configuration module 107, and the eighth configuration module 108, or a part of the configuration modules may be selectively added according to needs.
In addition, in the above embodiments, the technical functions of the first configuration module 101, the second configuration module 102, the third configuration module 103, the fourth configuration module 104, the fifth configuration module 105, the sixth configuration module 106, the seventh configuration module 107, and the eighth configuration module 108 are not limited to the description of the above embodiments, and those skilled in the art can flexibly expand the technical functions as needed.
In the above embodiment of the present application, the database configuration system at least includes a first configuration module 101 and a second configuration module 102, where the first configuration module 101 is at least used for configuring a tablespace, and is also used for configuring data associated with the tablespace, and when configuring the tablespace, the database configuration system includes a catalog tablespace and its configuration; the second configuration module 102 is at least used for performing allocation configuration of the tablespaces when the first configuration module 101 is used for performing configuration of the tablespaces, so that a modularized configuration idea is provided, and a separate configuration file can be generated for each configuration module, thereby simplifying the complexity of the DB2 database system, simplifying the DB2 database system configuration process, and reducing the deployment time cost of the database.
The above-described embodiments of the apparatus are merely illustrative, wherein the modules described as separate parts may or may not be physically separate, and the parts displayed as modules may or may not be physical modules, may be located in one place, or may be distributed on a plurality of network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions and/or portions thereof that contribute to the prior art may be embodied in the form of a software product that can be stored on a computer-readable storage medium including any mechanism for storing or transmitting information in a form readable by a computer (e.g., a computer). For example, a machine-readable medium includes Read Only Memory (ROM), Random Access Memory (RAM), magnetic disk storage media, optical storage media, flash memory storage media, electrical, optical, acoustical or other form of propagated signals (e.g., carrier waves, infrared signals, digital signals, etc.), and others, and the computer software product includes instructions for causing a computing device (which may be a personal computer, server, or network device, etc.) to perform the methods described in the various embodiments or portions of the embodiments.
Finally, it should be noted that: the above embodiments are only used for illustrating the technical solutions of the embodiments of the present application, and are not limited thereto; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus (device), or computer program product. Accordingly, embodiments of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
Embodiments of the present invention are described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (devices) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
Claims (10)
1. A database configuration system, characterized in that the system comprises at least the following modules:
the first configuration module is at least used for configuring a tablespace, and is also used for configuring data associated with the tablespace, and the configuration of the tablespace comprises the configuration of a cataloged tablespace;
a second configuration module, configured to perform allocation and configuration of the tablespace at least when the first configuration module performs configuration of the tablespace;
the system generates a separate configuration file for each configuration module.
2. The database configuration system of claim 1, wherein the first configuration module is further configured to configure a buffer pool.
3. The database configuration system according to claim 2, wherein the first configuration module is further configured to configure a database, the database being associated with at least one of the tablespace and the buffer pool.
4. The database configuration system according to claim 3, wherein the first configuration module, when configuring the database, includes at least one configuration of a database partition group configuration, a belonging partition number configuration, partition data, a page number, a buffer pool size configuration, and a page size configuration.
5. The database configuration system according to claim 1, wherein the first configuration module is further configured to perform a first configuration of tablespace, and the first configuration module, when configuring the first tablespace, comprises configuring at least one of a type of tablespace, a name of tablespace, a group of affiliated database partitions, a page size, a type of tablespace management, a number of affiliated container, a type of affiliated container, a container path, a container size, whether to expand, a growth size, an expansion size, a reservation size, and a buffer pool used.
6. The database configuration system according to claim 1, wherein the first configuration module is further configured to perform a second tablespace configuration, and the first configuration module configures at least one of a tablespace type, a tablespace name, a belonging database partition group, a page size, a tablespace management type, a container number, a container type, a container size, an auto-expansion growth size, a maximum size, an expansion size, a reserved size, and a used buffer pool when configuring the second tablespace.
7. The database configuration system according to claim 1, further comprising at least one of:
a third configuration module, configured to at least perform script address configuration, where the script address configuration is used to perform configuration of a file export path;
a fourth configuration module, configured to at least configure a storage node of a database;
a fifth configuration module, configured to at least perform database variable configuration;
a sixth configuration module for at least database manager configuration;
a seventh configuration module, configured to at least perform database parameter configuration;
an eighth configuration module, the eighth configuration module at least configured to perform operating system script configuration.
8. The database configuration system according to claim 7, wherein when the third configuration module is included, the third configuration module configures at least one of a file name of a path, a buffer pool, and a tablespace of a file, a database registry variable profile name, a database manager parameter profile name, and a database parameter profile name when performing script address configuration;
when the configuration module comprises the fourth configuration module, the fourth configuration module configures at least one of the configurations of bare equipment, file system selection, size, RAID group number, stripe size, NA number, and RG read-write ratio when configuring the storage node of the output database;
when the sixth configuration module is included, the sixth configuration module configures at least one of a parameter configuration and an HA handover configuration of the database manager when performing the configuration of the database manager;
when the device comprises a seventh configuration module, the seventh configuration module configures at least one of a database name, a user identifier, a user password and a parameter identifier when configuring the database parameters.
9. The database configuration system of claim 1, wherein the second configuration module configures at least one of a user table index table space, a large field table space, and a table type when performing the allocation configuration of the table space.
10. The database configuration system according to claim 1, wherein the second configuration module configures at least one of a serial number, a physical table name, a physical table description, a table type, a node partition key, a range partition key, a minimum value, a maximum value containing boundary, a partition size, a table space list to which the partition table belongs, an index table space list to which the partition table belongs, a dimension, a retention period, a record size, a peak transaction daily data amount, an annual data amount, a storage space, a data storage table space size estimation, and record data when performing the allocation configuration of the table space.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711422879.9A CN110019229B (en) | 2017-12-25 | 2017-12-25 | Database configuration system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711422879.9A CN110019229B (en) | 2017-12-25 | 2017-12-25 | Database configuration system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110019229A CN110019229A (en) | 2019-07-16 |
| CN110019229B true CN110019229B (en) | 2022-04-15 |
Family
ID=67187014
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711422879.9A Active CN110019229B (en) | 2017-12-25 | 2017-12-25 | Database configuration system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019229B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113326246B (en) | 2020-02-28 | 2024-07-30 | 华为技术有限公司 | Method, device and system for predicting performance of database management system |
| CN112068895B (en) * | 2020-08-10 | 2023-12-19 | 深圳市鼎盛光电有限公司 | Code configuration method, device, video playing equipment and storage medium |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1430148A (en) * | 2001-12-31 | 2003-07-16 | 深圳市中兴通讯股份有限公司上海第二研究所 | Method of storing and accessing embedded database |
| CN101826088A (en) * | 2009-03-05 | 2010-09-08 | 中兴通讯股份有限公司 | Device and method for configuring and storing information model |
| CN102096669A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Data backup method and data backup device |
| CN103176750A (en) * | 2013-02-27 | 2013-06-26 | 武汉虹旭信息技术有限责任公司 | Mobile internet data storage system based on interlaced time partition and method thereof |
| CN103699638A (en) * | 2013-12-23 | 2014-04-02 | 国云科技股份有限公司 | Method for realizing cross-database type synchronous data based on configuration parameters |
| CN104951527A (en) * | 2015-06-12 | 2015-09-30 | 深圳互娱网络科技有限公司 | System and method for rapid configuration of database management background |
| CN105138621A (en) * | 2015-08-14 | 2015-12-09 | 浪潮电子信息产业股份有限公司 | Sybase ASE database configuration optimization system and method |
| CN105893531A (en) * | 2016-03-31 | 2016-08-24 | 武汉虹信技术服务有限责任公司 | PostgreSQL database mass data management method and system |
| CN106095792A (en) * | 2016-05-27 | 2016-11-09 | 中国银联股份有限公司 | The method and apparatus generating database manipulation code |
| CN106326004A (en) * | 2016-08-17 | 2017-01-11 | 中国航空工业集团公司西安飞行自动控制研究所 | Dynamic memory allocation method of embedded database |
| CN106569920A (en) * | 2016-11-09 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Database backup method and device |
| US9767131B2 (en) * | 2013-03-14 | 2017-09-19 | Oracle International Corporation | Hierarchical tablespace space management |
-
2017
- 2017-12-25 CN CN201711422879.9A patent/CN110019229B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1430148A (en) * | 2001-12-31 | 2003-07-16 | 深圳市中兴通讯股份有限公司上海第二研究所 | Method of storing and accessing embedded database |
| CN101826088A (en) * | 2009-03-05 | 2010-09-08 | 中兴通讯股份有限公司 | Device and method for configuring and storing information model |
| CN102096669A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Data backup method and data backup device |
| CN103176750A (en) * | 2013-02-27 | 2013-06-26 | 武汉虹旭信息技术有限责任公司 | Mobile internet data storage system based on interlaced time partition and method thereof |
| US9767131B2 (en) * | 2013-03-14 | 2017-09-19 | Oracle International Corporation | Hierarchical tablespace space management |
| CN103699638A (en) * | 2013-12-23 | 2014-04-02 | 国云科技股份有限公司 | Method for realizing cross-database type synchronous data based on configuration parameters |
| CN104951527A (en) * | 2015-06-12 | 2015-09-30 | 深圳互娱网络科技有限公司 | System and method for rapid configuration of database management background |
| CN105138621A (en) * | 2015-08-14 | 2015-12-09 | 浪潮电子信息产业股份有限公司 | Sybase ASE database configuration optimization system and method |
| CN105893531A (en) * | 2016-03-31 | 2016-08-24 | 武汉虹信技术服务有限责任公司 | PostgreSQL database mass data management method and system |
| CN106095792A (en) * | 2016-05-27 | 2016-11-09 | 中国银联股份有限公司 | The method and apparatus generating database manipulation code |
| CN106326004A (en) * | 2016-08-17 | 2017-01-11 | 中国航空工业集团公司西安飞行自动控制研究所 | Dynamic memory allocation method of embedded database |
| CN106569920A (en) * | 2016-11-09 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Database backup method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110019229A (en) | 2019-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10558672B1 (en) | System and method for executing queries on multi-graphics processing unit systems | |
| EP2565802B1 (en) | Data masking setup | |
| CN110019292B (en) | Data query method and device | |
| US9372880B2 (en) | Reclamation of empty pages in database tables | |
| CN108009261B (en) | Data synchronization method and device and electronic equipment | |
| CN110427775B (en) | Data query authority control method and device | |
| JP2010524060A (en) | Data merging in distributed computing | |
| CN103970870A (en) | Database query method and server | |
| US20120290588A1 (en) | Reorganizing database tables | |
| EP2901344A1 (en) | System and method for flexible distributed massively parallel processing (mpp) database | |
| CN110399368B (en) | Method for customizing data table, data operation method and device | |
| CN104022913B (en) | For method of testing and the device of data cluster | |
| CN107408132B (en) | Method and system for moving hierarchical data objects across multiple types of storage | |
| CN106372160A (en) | Distributive database and management method | |
| CN110019229B (en) | Database configuration system | |
| CN107070645A (en) | Compare the method and system of the data of tables of data | |
| CN107562521A (en) | A kind of method for managing resource and device | |
| CN111177700A (en) | Method and device for controlling row-level authority | |
| CN105279029B (en) | A kind of local storage dynamic allocation method based on Activity Calculation resource | |
| CN113886419A (en) | SQL statement processing method and device, computer equipment and storage medium | |
| CN115495620A (en) | Data management method based on graph structure and related equipment | |
| CN111680069A (en) | Database access method and device | |
| US20200110822A1 (en) | Composite metadata objects for database systems | |
| US12056107B2 (en) | Managing vertex level access in a graph via user defined tag rules | |
| CN111221847A (en) | Monitoring data storage method and device and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |