A database construction method, device, equipment and medium

Abstract

This invention discloses a database construction method, apparatus, device, and medium, relating to the field of database management technology. In response to a database configuration operation in the database configuration interface, target configuration information is obtained; in response to a data model selection operation in the data model interface, a target data model is determined; the target project size is obtained, and a pre-created project tablespace is established based on the target project size and the target data model; in response to a performance configuration operation in the performance configuration interface, target performance configuration information for the target database is obtained; and the target database is constructed based on the pre-created project tablespace, the target performance configuration information, and the target configuration information. This technical solution ensures rapid database construction to meet the high requirements of data management and system performance in the seismic exploration field.

Description

Technical Field

[0001] This invention relates to the field of database management technology, and in particular to a database construction method, apparatus, device, and medium. Background Technology

[0002] In the field of seismic exploration, data collection, processing, and storage are complex and crucial processes. With the continuous development of exploration technology, the amount of data is growing explosively, making the efficient and accurate construction of seismic exploration databases a pressing issue that needs to be addressed.

[0003] Currently, PostgreSQL is the widely used database system in the seismic exploration field, especially in professional software like GeoEast. Typically, tablespaces are built within the database on a project-by-project basis, and a set of data model tables is created within each tablespace. The traditional approach involves building tablespaces and tables within the database when creating a project, which is lacking in efficiency, security, and user-friendliness. Furthermore, third-party database building tools on the market have significant shortcomings in meeting the specific needs of the seismic exploration field, failing to satisfy the requirement for rapid and efficient batch database construction. Summary of the Invention

[0004] This invention provides a database construction method, apparatus, device, and medium to solve the problems of low efficiency, difficulty in model expansion, and insufficient performance optimization in traditional database construction methods in the field of seismic exploration.

[0005] According to one aspect of the present invention, a database construction method is provided, comprising:

[0006] In response to database configuration operations in the database configuration interface, obtain the target configuration information;

[0007] In response to the selection of a data model in the data model interface, the target data model is determined;

[0008] Obtain the target project size, and based on the target project size and the target data model, establish a pre-created project tablespace;

[0009] In response to performance configuration operations in the performance configuration interface, the target performance configuration information of the target database is obtained;

[0010] The target database is constructed based on the pre-created project tablespace, the target performance configuration information, and the target configuration information.

[0011] According to another aspect of the present invention, a database construction apparatus is provided, comprising:

[0012] The configuration information acquisition module is used to acquire target configuration information in response to database configuration operations on the database configuration interface;

[0013] The data model determination module is used to determine the target data model in response to the selection operation of the data model in the data model interface;

[0014] The project tablespace creation module is used to obtain the target project size and create a pre-created project tablespace based on the target project size and the target data model.

[0015] The performance configuration information determination module is used to obtain the target performance configuration information of the target database in response to the performance configuration operation in the performance configuration interface;

[0016] The database construction module is used to construct the target database based on the pre-created project tablespace, the target performance configuration information, and the target configuration information.

[0017] According to another aspect of the present invention, an electronic device is provided, the electronic device comprising:

[0018] At least one processor; and

[0019] A memory communicatively connected to the at least one processor; wherein,

[0020] The memory stores a computer program that can be executed by the at least one processor, the computer program being executed by the at least one processor to enable the at least one processor to perform the database construction method according to any embodiment of the present invention.

[0021] According to another aspect of the present invention, a computer-readable storage medium is provided, the computer-readable storage medium storing computer instructions for causing a processor to execute and implement the database construction method according to any embodiment of the present invention.

[0022] According to another aspect of the present invention, a computer program product is provided, the computer program product comprising a computer program that, when executed by a processor, implements the database construction method according to any embodiment of the present invention.

[0023] The technical solution of this invention obtains target configuration information in response to a database configuration operation on the database configuration interface. Then, in response to a data model selection operation on the data model interface, a target data model is determined, thereby obtaining the target project size. Based on the target project size and the target data model, a pre-created project tablespace is established. Next, in response to a performance configuration operation on the performance configuration interface, target performance configuration information for the target database is obtained. Finally, based on the pre-created project tablespace, the target performance configuration information, and the target configuration information, the target database is constructed. This technical solution solves the problems of low efficiency, difficulty in model expansion, and insufficient performance optimization in traditional database construction methods in the field of seismic exploration. It significantly improves the efficiency and quality of seismic exploration data processing and management, and meets the high requirements of the seismic exploration field for data management and system performance.

[0024] It should be understood that the description in this section is not intended to identify key or essential features of the embodiments of the present invention, nor is it intended to limit the scope of the invention. Other features of the invention will become readily apparent from the following description. Attached Figure Description

[0025] To more clearly illustrate the technical solutions in the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0026] Figure 1 This is a flowchart of a database construction method provided according to an embodiment of the present invention;

[0027] Figure 2 This is a schematic diagram of a database creation interface provided according to an embodiment of the present invention;

[0028] Figure 3 This is a schematic diagram of a database information configuration interface provided according to an embodiment of the present invention;

[0029] Figure 4 This is a schematic diagram of a database model selection interface provided according to an embodiment of the present invention;

[0030] Figure 5 This is a schematic diagram of the master-slave database creation interface provided according to an embodiment of the present invention;

[0031] Figure 6 This is a schematic diagram of the slave database configuration interface provided according to an embodiment of the present invention;

[0032] Figure 7This is a schematic diagram of the master database configuration interface provided according to an embodiment of the present invention;

[0033] Figure 8 This is a schematic diagram of an information confirmation interface provided according to an embodiment of the present invention;

[0034] Figure 9 This is a structural block diagram of a database construction apparatus provided according to an embodiment of the present invention;

[0035] Figure 10 This is a structural block diagram of an electronic device that implements the database construction method of this invention. Detailed Implementation

[0036] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.

[0037] Figure 1 This is a flowchart of a database construction method according to an embodiment of the present invention. This embodiment is applicable to database construction in the field of seismic exploration. The method can be executed by a database construction device provided in this embodiment, which can be implemented in hardware and / or software and can be configured in a server. Figure 1 As shown, the method includes:

[0038] S110. In response to the database configuration operation in the database configuration interface, obtain the target configuration information.

[0039] The database configuration interface is the interactive interface for performing database operations in the GeoEast software. In this embodiment of the invention, a wizard-style interactive interface is preferred, which provides a visual interface for technicians and responds to the corresponding functions based on the operation actions performed by the technicians. The target configuration information is the configuration information corresponding to the database to be created, which may include the name of the data source, the installation path of the database, the database port number, the connection pool size, the table structure, and user permission management, etc. The configuration information is connected to the database, and the target configuration information of the database corresponding to the data source is obtained directly according to the data source ID.

[0040] Specifically, when a database configuration operation is received from a technician in the database configuration interface, the configuration information of the database connection is obtained from the database corresponding to the data source selected by the technician in the database configuration interface.

[0041] If the target configuration information for the required connection exists in the current database, proceed directly to step S120; if the required configuration information does not exist in the current database, new database configuration information can be created based on the current interactive interface. Optionally, in response to database configuration operations on the database configuration interface, the target configuration information is obtained, including:

[0042] In response to database configuration operations in the database configuration interface, the system obtains configuration item information and saves it to the target configuration file; it also reads the target configuration file through the GeoEast underlying interface to obtain the target configuration information.

[0043] Among them, the configuration item information is the configuration information obtained from the interface template; the target configuration file is used to store the database configuration information; the file format of the target configuration file is dbs.conf; the configuration file is a preset template file, which can be directly stored as the target configuration file based on the configuration item information and the configuration file.

[0044] Specifically, when the required configuration information is not found in the current database, the corresponding operation can be performed to enter the database configuration information addition interface. Through the database configuration operation in the database configuration interface, the input configuration item information can be obtained, which may include fields such as database type, hostname, port number, username, and password. The configuration item information is saved in a pre-set configuration file template to obtain the target configuration file in the format of dbs.conf. The target configuration file is then connected to the database so that when selecting database configuration information later, the target configuration file can be read directly based on the database configuration operation through the GeoEast underlying interface to obtain the corresponding target configuration information.

[0045] Understandably, when the required configuration information for a connection is not available in the current database, importing a templated configuration file to automatically obtain configuration information eliminates the need for manual input of configuration information. This significantly improves the efficiency and accuracy of GeoEast software database configuration, reduces system problems caused by configuration errors, and further ensures the rapid construction of subsequent databases.

[0046] Optionally, the input configuration information should be validated before saving it. Using the input database port number, IP address, and instance name, a connection test message is sent to the database server. If the database server successfully verifies the connection and returns a success message, the successfully tested configuration information is saved. If the database server returns an error message, the user is allowed to correct it, and the corrected configuration information is saved. It is understood that validating and correcting the configuration information ensures its accuracy.

[0047] S120. In response to the selection operation of the data model in the data model interface, determine the target data model.

[0048] The data model interface is the interactive interface for selecting data models in the GeoEast software; a data model is a database model category, which may include basic data models and extended data models.

[0049] Specifically, the target data model corresponding to the database is determined by the selection operation of the data model interface by the technician. In this embodiment of the invention, the target data model is the basic data model, and an extended model can also be selected.

[0050] The target data model includes the GeoEast model, which contains SQL statements used to describe the geological exploration data.

[0051] The GeoEast model serves as the foundational data model for the database; SQL statements are used to describe the relevant fields of the seismic exploration data, and tables, fields, and foreign key relationships are created in the tablespace by executing SQL statements.

[0052] The target data model also includes a third-party data model, which is generated based on the GeoEast model's corresponding model base class.

[0053] The third-party data model is an extended data model. By providing a set of extended model base classes, the data model structure can be customized according to requirements. The corresponding code can be implemented by inheriting the base data model, and a dynamic model library is generated and stored in a specified directory. This allows the third-party data model to be used directly to extend the model when it is determined to do so.

[0054] Understandably, by providing an extension mechanism for custom model structures, the database can adapt to the actual needs of different projects, enhancing its flexibility. This model extension mechanism supports model extensions corresponding to the basic data model.

[0055] S130. Obtain the target project size and establish a pre-created project tablespace based on the target project size and target data model.

[0056] The project scale refers to the acquisition scope and scale of the earthquake data acquisition system, including the data acquisition range, data storage capacity, and system scalability; the pre-created project tablespace is a table structure created by the earthquake data acquisition system for the earthquake data processing project.

[0057] Specifically, based on the acquisition range, data storage capacity, system scalability, and corresponding target data model of the seismic data acquisition system, a pre-created project tablespace is established, and there can be at least one pre-created project tablespace.

[0058] Optionally, based on the target project size and target data model, a pre-created project tablespace is established, including: creating a target tablespace corresponding to the target project size; reading and executing SQL statements in the target data model, creating tables, fields, and foreign key relationships in the target tablespace, and obtaining the pre-created project tablespace.

[0059] In a target tablespace, there is at least one table. The fields in the table are used to describe the fields related to the seismic exploration data and also represent the project name. The fields in different tables have relationships, which are represented as the relationships between tables, and are foreign key relationships within the tablespace.

[0060] Specifically, create a target tablespace corresponding to the target project size, read the SQL statements in the target data model, and create tables, fields, and foreign key relationships in the target tablespace based on the relevant data fields. For example, if 10 projects need to be built, create 10 tablespaces sequentially based on the project size. Each tablespace has hundreds of fields and table headers, and establish foreign key relationships through the field relationships in each table. The tablespace with tables, fields, and foreign key relationships is used as the pre-created project tablespace.

[0061] Understandably, since each tablespace in a database usually needs to be created once, and the creation process is time-consuming; this embodiment of the invention completes the pre-creation of tablespaces in batches by executing SQL statements in the target data model file, thus ensuring the efficiency of database construction.

[0062] S140. In response to the performance configuration operation in the performance configuration interface, obtain the target performance configuration information of the target database.

[0063] The performance configuration interface is the interface for performing performance configuration in the GeoEast software; technical personnel obtain the target performance configuration information of the target database through performance configuration operations on the performance configuration interface.

[0064] Technical personnel can enter corresponding performance parameter values ​​on the performance configuration interface, such as database buffer size, maximum number of database connections, and database write process interval. Database performance parameters can also be customized based on the performance configuration interface. This embodiment of the invention also allows technical personnel to customize key database performance parameters based on system recommendations or their own experience to improve the overall performance of the database.

[0065] S150. Construct the target database based on the pre-created project tablespace, target performance configuration information, and target configuration information.

[0066] The GeoEast software system constructs a target database based on the received pre-created project tablespaces, target performance configuration information, and target configuration information.

[0067] The technical solution of this invention obtains target configuration information by responding to database configuration operations in the database configuration interface, then determines the target data model by responding to data model selection operations in the data model interface, thereby obtaining the target project scale. Based on the target project scale and the target data model, a pre-created project tablespace is established. Next, in response to performance configuration operations in the performance configuration interface, the target performance configuration information of the target database is obtained. Finally, the target database is constructed based on the pre-created project tablespace, the target performance configuration information, and the target configuration information. This technical solution solves the problems of low efficiency, difficulty in model expansion, and insufficient performance optimization in traditional database construction methods in the field of seismic exploration, significantly improving the efficiency and quality of seismic exploration data processing and management, and meeting the high requirements of the seismic exploration field for data management and system performance.

[0068] Based on the above embodiments, as an optional aspect of the present invention, before constructing the target database according to the pre-created project tablespace, target performance configuration information, and target configuration information, the method further includes: in response to the slave database configuration operation of the target database, constructing a slave database of the target database.

[0069] The slave database configuration operation involves configuring the slave database's port number, node, and number of connections. Selecting the slave database configuration operation through the visual setup interface will send the built master database, as a compressed package, to the master database node via socket. After the database server checks data consistency, it then sends the data to the slave node via socket, enabling rapid master-slave database setup and configuration.

[0070] It is understood that the embodiments of the present invention provide a simple and clear master-slave database setup, and the setup can be completed by filling in the slave database parameter configuration, thereby realizing automatic synchronization and backup of master-slave database data and ensuring data consistency.

[0071] Based on the above embodiments, as another optional aspect of the present invention, after constructing the target database, the method further includes: obtaining new performance parameters in response to an update operation on the performance parameters of the target database; and sending the new performance parameters to the database server via a socket method, so that the database server updates the target database according to the new performance parameters.

[0072] The GeoEast software system obtains the new performance parameters based on the technicians' updates to the target database's performance parameters. It then verifies and limits the range of these parameters to ensure users do not make destructive adjustments. Once the parameters are configured and verified, the GeoEast system transmits the new configuration file to the database server via socket. Upon receiving the new configuration file, the database server program performs operations such as stopping the database, overwriting the original configuration file, and starting the database to make the new parameter configuration effective.

[0073] It is understood that embodiments of the present invention can allow technicians to customize and modify key performance parameters of the database based on system recommendations or their own experience in order to improve the overall performance of the database.

[0074] This invention provides a mechanism for extending custom model structures by rapidly configuring configuration information in the seismic exploration database and updating and optimizing performance parameters. This ensures that the GeoEast software system can achieve efficient, flexible, and reliable database construction, meeting the high requirements of the seismic exploration field for data management and system performance.

[0075] Based on the above embodiments of the present invention, a method for batch database construction is illustrated using the wizard-driven interactive interface of GeoEast software, specifically including:

[0076] Step 1, such as Figure 2 The database creation interface shown allows you to enter a password and select the database configuration information you want to connect to from the data source drop-down menu. If the database configuration information for the data source is not found in the drop-down menu, click the Add button to proceed to step two. If the database configuration information is found in the drop-down menu, directly select the desired data source name and click the Next button to proceed to step three. Here, Password is the password, and Datasource name is the data source name.

[0077] Step 2, as follows Figure 3The database information configuration interface shown is used to add a data source and its corresponding configuration information. This interface displays a templated configuration file. Fill in the configuration items according to the on-screen prompts, and click the OK button to save and return to step one. The configuration items include: DataBase is the corresponding database instance SID name; Port is the database port number; DBPath is the path where the database is stored on the server; PoolMaxRead is a concept within the GeoEast software, representing the number of read connection pools; PoolMaxWrite is a concept within the GeoEast software, representing the number of write connection pools; PoolType is the connection pool type; WriteHostName is the IP address of the write master database; and ReadHostName is the IP address of the read slave database.

[0078] Step 3, as follows Figure 4 In the database model selection interface shown, check the database model you want to create, and then click the Next button to proceed to step four; GeoEast-iEco is a required option by default, and the remaining options are third-party extended models.

[0079] Step 4, as follows Figure 5 The master-slave database creation interface shown allows you to select the project size via a drop-down menu, enter the number of pre-created project spaces to be established based on the selected size, choose whether to create a master-slave database as needed, and click Next to proceed to the next step. If you choose to create a master-slave database, proceed to step five; otherwise, proceed to step six. Here, "Type" is used to select the number of pre-created virtual projects, and the database for each virtual project is in the form of a tablespace. "Creating a testing project while building database" indicates that a real project will be created in the GeoEast software during the database construction process. "Master-slave mode" indicates whether to set up a master-slave database mode.

[0080] Step 5, as follows Figure 6 The slave database configuration interface shown is accessed by filling in the slave database configuration information and clicking the Next button to proceed to step six. Here, Port is the slave database port number; Max_connections is the maximum number of slave database connections; Shared_buffers is the slave database shared memory size; and Hot_standby indicates whether real-time hot standby is enabled.

[0081] Step Six, as Figure 7The primary database configuration interface is shown. Fill in the primary database configuration information and click the Next button to proceed to step seven. Here, Port is the port number; Max_connections is the maximum number of database connections; Shared_buffers is the database shared memory size; Bgwriter_delay is the large file write delay; Fsync is whether memory buffer flushing is enabled on the primary database server; Wal_leve is the Write Ahead Logging level; Max_wal_senders is the maximum number of write-ahead log sending processes; and Wal_keep_segments is the minimum number of write-ahead logs to keep.

[0082] Step Seven: As Figure 8 On the information confirmation interface shown, after filling in the master and slave node information, click the Finish button. GeoEast software will then complete the batch database model and third-party extended model creation, database parameter settings, and master and slave database setup in the database according to the information selected in steps three to six. Among them, the Master node is the IP address of the master node, and the Slave node is the IP address of the slave node.

[0083] This invention provides GeoEast software with an efficient, flexible, and reliable database construction solution, enabling rapid batch database construction, significantly reducing construction time, and providing an extension mechanism for custom model structures. This allows the database to adapt to the actual needs of different projects, enhancing flexibility. Furthermore, by monitoring database performance indicators and automatically adjusting key parameters, it ensures that the database maintains good performance under high load, ensuring data consistency to meet the high requirements of data management and system performance in the seismic exploration field.

[0084] Figure 9 This is a structural block diagram of a database construction apparatus provided in an embodiment of the present invention. The present invention is applicable to database construction in the field of seismic exploration. This method can be executed by the database construction apparatus provided in this embodiment, which can be implemented in hardware and / or software and can be configured in a server. Figure 9 As shown, the device includes:

[0085] The configuration information acquisition module 310 is used to acquire target configuration information in response to database configuration operations on the database configuration interface;

[0086] The data model determination module 320 is used to determine the target data model in response to the selection operation of the data model in the data model interface;

[0087] The project tablespace creation module 330 is used to obtain the target project size and create a pre-created project tablespace based on the target project size and the target data model.

[0088] The performance configuration information determination module 340 is used to obtain the target performance configuration information of the target database in response to the performance configuration operation on the performance configuration interface.

[0089] Database building module 350 is used to build the target database based on the pre-created project tablespace, target performance configuration information, and target configuration information.

[0090] The technical solution of this invention obtains target configuration information by responding to database configuration operations in the database configuration interface, then determines the target data model by responding to data model selection operations in the data model interface, thereby obtaining the target project scale. Based on the target project scale and the target data model, a pre-created project tablespace is established. Next, in response to performance configuration operations in the performance configuration interface, the target performance configuration information of the target database is obtained. Finally, the target database is constructed based on the pre-created project tablespace, the target performance configuration information, and the target configuration information. This technical solution solves the problems of low efficiency, difficulty in model expansion, and insufficient performance optimization in traditional database construction methods in the field of seismic exploration, significantly improving the efficiency and quality of seismic exploration data processing and management, and meeting the high requirements of the seismic exploration field for data management and system performance.

[0091] Optionally, the project tablespace creation module 330 is specifically used for:

[0092] Create a target tablespace that corresponds to the size of the target project;

[0093] Read and execute the SQL statements in the target data model, create tables, fields and foreign key relationships in the target tablespace, and obtain the pre-created project tablespace.

[0094] Optionally, the target data model includes the GeoEast model, which includes SQL statements used to describe the geological exploration data.

[0095] Optionally, the target data model may also include a third-party data model, which is generated based on the GeoEast model's corresponding model base class.

[0096] Optionally, the configuration information acquisition module 310 is specifically used to: respond to the configuration information configuration operation in the database configuration interface, obtain configuration item information, and save the configuration item information to the target configuration file; and read the target configuration file through the GeoEast underlying interface to obtain the target configuration information.

[0097] Optionally, the device also includes a database building module for:

[0098] Before building the target database based on the pre-created project tablespace, target performance configuration information, and target configuration information, a slave database of the target database is built in response to the slave database configuration operation of the target database.

[0099] Optionally, the device also includes a performance parameter update module for:

[0100] After the target database is built, new performance parameters are obtained in response to the update operation on the performance parameters of the target database;

[0101] New performance parameters are sent to the database server via socket, so that the database server updates the target database based on the new performance parameters.

[0102] The database construction apparatus provided in this embodiment of the invention can execute the database construction method provided in any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0103] According to embodiments of the present invention, the present invention also provides an electronic device, a readable storage medium, and a computer program product.

[0104] Figure 10 A structural block diagram of an electronic device 10 that can be used to implement embodiments of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the invention described and / or claimed herein.

[0105] like Figure 10 As shown, the electronic device 10 includes at least one processor 11 and a memory, such as a read-only memory (ROM) 12 or a random access memory (RAM) 13, communicatively connected to the at least one processor 11. The memory stores computer programs executable by the at least one processor. The processor 11 can perform various appropriate actions and processes based on the computer program stored in the ROM 12 or loaded from storage unit 18 into the RAM 13. The RAM 13 may also store various programs and data required for the operation of the electronic device 10. The processor 11, ROM 12, and RAM 13 are interconnected via a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0106] Multiple components in electronic device 10 are connected to I / O interface 15, including: input unit 16, such as keyboard, mouse, etc.; output unit 17, such as various types of displays, speakers, etc.; storage unit 18, such as disk, optical disk, etc.; and communication unit 19, such as network card, modem, wireless transceiver, etc. Communication unit 19 allows electronic device 10 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0107] Processor 11 can be a variety of general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. Processor 11 performs the various methods and processes described above, such as database construction methods.

[0108] In some embodiments, the database construction method may be implemented as a computer program tangibly contained in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on electronic device 10 via ROM 12 and / or communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the database construction method described above may be performed. Alternatively, in other embodiments, processor 11 may be configured to execute the database construction method by any other suitable means (e.g., by means of firmware).

[0109] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems-on-a-chip (SoCs), payload-programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include implementations in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor, capable of receiving data and instructions from a storage system, at least one input device, and at least one output device, and transmitting data and instructions to the storage system, the at least one input device, and the at least one output device.

[0110] Computer programs used to implement the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that when executed by the processor, the computer programs cause the functions / operations specified in the flowcharts and / or block diagrams to be performed. The computer programs may be executed entirely on a machine, partially on a machine, or as a standalone software package, partially on a machine and partially on a remote machine, or entirely on a remote machine or server.

[0111] In the context of this invention, a computer-readable storage medium can be a tangible medium that may contain or store a computer program for use by or in conjunction with an instruction execution system, apparatus, or device. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination thereof. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof.

[0112] To provide interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user provides input to the electronic device. Other types of devices can also be used to provide interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including sound input, voice input, or tactile input).

[0113] The systems and technologies described herein can be implemented in computing systems that include backend components (e.g., as data servers), or computing systems that include middleware components (e.g., application servers), or computing systems that include frontend components (e.g., user computers with graphical user interfaces or web browsers through which users can interact with implementations of the systems and technologies described herein), or any combination of such backend, middleware, or frontend components. The components of the system can be interconnected via digital data communication of any form or medium (e.g., communication networks). Examples of communication networks include local area networks (LANs), wide area networks (WANs), blockchain networks, and the Internet.

[0114] A computing system can include clients and servers. Clients and servers are generally located far apart and typically interact through communication networks. The client-server relationship is created by computer programs running on the respective computers and having a client-server relationship with each other. The server can be a cloud server, also known as a cloud computing server or cloud host, which is a hosting product within the cloud computing service system to address the shortcomings of traditional physical hosts and VPS services, such as high management difficulty and weak business scalability.

[0115] It should be understood that the various forms of processes shown above can be used, with steps reordered, added, or deleted. For example, the steps described in this invention can be executed in parallel, sequentially, or in different orders, as long as the desired result of the technical solution of this invention can be achieved, and this is not limited herein.

[0116] The specific embodiments described above do not constitute a limitation on the scope of protection of this invention. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this invention should be included within the scope of protection of this invention.

Claims

1. A database construction method characterized by comprising: include: In response to database configuration operations in the database configuration interface, obtain the target configuration information; In response to the selection of a data model in the data model interface, the target data model is determined; Obtain the target project size, and based on the target project size and the target data model, establish a pre-created project tablespace; In response to performance configuration operations in the performance configuration interface, the target performance configuration information of the target database is obtained; The target database is constructed based on the pre-created project tablespace, the target performance configuration information, and the target configuration information.

2. The method of claim 1, wherein, Based on the target project size and the target data model, a pre-created project tablespace is established, including: Create a target tablespace corresponding to the size of the target project; Read and execute the SQL statements in the target data model, create tables, fields and foreign key relationships in the target tablespace, and obtain the pre-created project tablespace.

3. The method according to claim 1 or 2, characterized in that, The target data model includes the GeoEast model, which includes SQL statements used to describe geological exploration data.

4. The method of claim 3, wherein, The target data model also includes a third-party data model, which is generated based on the model base class corresponding to the GeoEast model.

5. The method of claim 1, wherein, The process of obtaining target configuration information in response to a database configuration operation on the database configuration interface includes: In response to database configuration operations in the database configuration interface, configuration item information is obtained and the configuration item information is saved to the target configuration file; The target configuration information is obtained by reading the target configuration file through the GeoEast underlying interface.

6. The method of claim 1, wherein, Before constructing the target database based on the pre-created project tablespace, the target performance configuration information, and the target configuration information, the following steps are also included: In response to the slave database configuration operation of the target database, a slave database of the target database is set up.

7. The method of claim 1, wherein, After building the target database, the following is also included: In response to an update operation on the performance parameters of the target database, new performance parameters are obtained; The new performance parameters are sent to the database server via socket, so that the database server updates the target database based on the new performance parameters.

8. A database construction apparatus characterized by comprising: include: The configuration information acquisition module is used to acquire target configuration information in response to database configuration operations on the database configuration interface; The data model determination module is used to determine the target data model in response to the selection operation of the data model in the data model interface; The project tablespace creation module is used to obtain the target project size and create a pre-created project tablespace based on the target project size and the target data model. The performance configuration information determination module is used to obtain the target performance configuration information of the target database in response to the performance configuration operation in the performance configuration interface; The database construction module is used to construct the target database based on the pre-created project tablespace, the target performance configuration information, and the target configuration information.

9. An electronic device, comprising: The electronic device includes: At least one processor; and A memory communicatively connected to the at least one processor; wherein, The memory stores a computer program that can be executed by the at least one processor, the computer program being executed by the at least one processor to enable the at least one processor to perform the database construction method according to any one of claims 1-7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions that are used to cause a processor to execute the database construction method of any one of claims 1-7.

11. A computer program product, characterised in that, The computer program product includes a computer program that, when executed by a processor, implements the database construction method according to any one of claims 1-7.

Images