Database creation method and device, equipment, medium and product

Abstract

The invention discloses a database creation method, device and equipment, a medium and a product, and belongs to the technical field of data processing. The method comprises the following steps: generating an object information combination according to object search information received by an object information configuration interface; in response to a field design triggering operation for the database table, displaying a field configuration interface; generating a target database table of the target database according to the field configuration information received by the field configuration interface; in response to a database creation instruction, establishing a communication connection with a source database, determining an object set based on the object information combination, searching diagnosis and treatment data of each object in the object set in the source database, and processing the diagnosis and treatment data of each object according to the target library table, target diagnosis and treatment data of all the objects are obtained, and a target database comprising the target diagnosis and treatment data of all the objects is created. According to the technical scheme provided by the embodiment of the invention, the database creation difficulty can be reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular, to a method, apparatus, device, medium, and product for creating a database. Background Art

[0002] When creating a database, the prior art usually first creates an empty database and a library table corresponding to the empty database based on database creation software, and then stores the data to be stored in the database based on the library table.

[0003] This process is usually cumbersome and time-consuming, and requires professional personnel to operate. Therefore, it is necessary to provide a simple method for creating a database. Summary of the Invention

[0004] The present invention provides a method, apparatus, device, medium, and product for creating a database to reduce the difficulty of creating a database.

[0005] According to one aspect of the present invention, there is provided a method for creating a database, including:

[0006] Generating an object information combination according to the object search information received by the object information configuration interface;

[0007] Responding to a trigger operation for field design of a database table, and displaying a field configuration interface;

[0008] Generating a target library table of a target database according to the field configuration information received by the field configuration interface;

[0009] Responding to a database creation instruction, establishing a communication connection with a source database, determining an object set based on the object information combination, searching for the diagnosis and treatment data of each object in the object set in the source database, processing the diagnosis and treatment data of each object according to the target library table to obtain the target diagnosis and treatment data of each object, and creating a target database including the target diagnosis and treatment data of each object.

[0010] According to another aspect of the present invention, there is provided a database creation apparatus, including:

[0011] An information combination determination module, configured to generate an object information combination according to the object search information received by the object information configuration interface;

[0012] An interface display module, configured to respond to a trigger operation for field design of a database table and display a field configuration interface;

[0013] A library table generation module, configured to generate a target library table of a target database according to the field configuration information received by the field configuration interface;

[0014] A creation module is configured to, in response to a database creation instruction, establish a communication connection with a source database, determine an object set based on the combination of object information, search for the diagnosis and treatment data of each object in the object set in the source database, process the diagnosis and treatment data of each object according to the target database table to obtain the target diagnosis and treatment data of each object, and create a target database including the target diagnosis and treatment data of each object.

[0015] According to another aspect of the present invention, there is provided an electronic device, which includes:

[0016] At least one processor; and

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

[0018] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the database creation method according to any embodiment of the present invention.

[0019] According to another aspect of the present invention, there is provided a computer-readable storage medium storing computer instructions for causing a processor to implement the database creation method according to any embodiment of the present invention when executed.

[0020] According to another aspect of the present invention, there is provided a computer program product including a computer program which, when executed by a processor, implements the database creation method according to any embodiment.

[0021] The technical solution of the database creation method provided by the embodiments of the present invention determines the combination of object information through the object search information received by the object information configuration interface, and generates the target database table of the target database through the field configuration information received by the automatic configuration interface; after establishing a communication connection with the source database, it determines the object set based on the combination of object information, then searches for the diagnosis and treatment data of each object in the object set from the source database, and processes the diagnosis and treatment data of each object according to the target database table to obtain the target diagnosis and treatment data, and creates a target database including the target diagnosis and treatment data of each object, realizing the sequential processing of data pulling and data processing, reducing the difficulty of creating the target database, and improving the speed of creating the target database.

[0022] It should be understood that the content described in this part is not intended to identify the key or important features of the embodiments of the present invention, nor is it used to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. Description of the Drawings

[0023] To more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the accompanying drawings required for the description of the embodiments. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other accompanying drawings can be obtained based on these drawings.

[0024] Figure 1 is a flowchart of a database creation method provided according to an embodiment of the present invention;

[0025] Figure 2 is another flowchart of a database creation method provided according to an embodiment of the present invention;

[0026] Figure 3 is a schematic diagram of a field filling rate provided according to an embodiment of the present invention;

[0027] Figure 4 is a schematic diagram of a field quality score provided according to an embodiment of the present invention;

[0028] Figure 5 is a schematic diagram of the structure of a database creation device provided according to an embodiment of the present invention;

[0029] Figure 6 is another schematic diagram of the structure of a database creation device provided according to an embodiment of the present invention;

[0030] Figure 7 is another schematic diagram of the structure of a database creation device provided according to an embodiment of the present invention;

[0031] Figure 8 is a schematic diagram of the structure of an electronic device for implementing the database creation method of the embodiment of the present invention. Detailed implementation manners

[0032] To enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, rather than all, of the embodiments of the present invention. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.

[0033] It should be noted that in the description and claims of the present invention and the above-mentioned drawings, the terms "first", "second", etc. are used to distinguish similar objects, and do not necessarily describe a specific order or sequence. It should be understood that the data used in this way can be interchanged under appropriate circumstances, so that the embodiments of the present invention described here can be implemented in an order other than those illustrated or described here. In addition, the terms "comprising" and "having" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, system, product or device comprising a series of steps or units does not necessarily have to be limited to those steps or units clearly listed, but may include other steps or units not clearly listed or inherent to these processes, methods, products or devices.

[0034] It should be noted that in the technical solution of the present invention, the collection, use, storage, sharing, transfer and other processing of the user's personal information involved all comply with the provisions of relevant laws and regulations, and the user needs to be informed and obtain the consent or authorization of the user. When applicable, technical processing such as de-identification and / or anonymization and / or encryption of the user's personal information is performed.

[0035] Figure 1 The flowchart of the database creation method provided by the embodiment of the present invention is applicable to the situation of automatically creating a target diagnosis and treatment information database including all objects corresponding to the object information combination based on the object information combination and field configuration information received through the interaction interface. This method can be executed by a database creation device, which can be implemented in the form of hardware and / or software, and the database creation device can be configured in the processor of an electronic device. As Figure 1 shown, the method includes:

[0036] S110. Generate an object information combination according to the object search information received by the object information configuration interface.

[0037] The object information configuration interface is a target object search interface for searching for warehoused objects in the source database.

[0038] The processor responds to the trigger operation of the object information configuration interface, displays the object information configuration interface; the user inputs object search information on the object information configuration interface and clicks or triggers the confirmation option; the processor generates a corresponding object information combination according to the click or trigger operation.

[0039] The object search information includes at least one of a target disease identifier, a target distribution area identifier, a medical visit time, an age at first diagnosis, gender, age, a residential address, and target indicator information; the medical visit time includes the first medical visit time and / or the last medical visit time for the disease corresponding to the target disease identifier; the target indicator information includes at least one target indicator and the indicator data of each of the at least one target indicator.

[0040] In one embodiment, a user wants to create a disease-specific database. The object search information can be configured as a target disease identifier, gender, age, medical visit time, age at first diagnosis, and target indicator information. Among them, the medical visit time can be the first medical visit time when first visiting the hospital corresponding to the source database for the target disease identifier, or the interval between two medical visit times, or the hospitalization time, etc. The age at first diagnosis refers to the age at which the target object was first diagnosed with the disease corresponding to the target disease identifier. The target indicator information includes one or more detection indicators that the user is concerned about.

[0041] If the user wants to create a disease-specific database for analyzing the distribution area of the target disease. Then, on the basis of the foregoing embodiment, the object search information further includes a residential address, so that the created disease-specific database contains the required address information.

[0042] In one embodiment, before determining the object set, in response to a basic information entry operation, a basic information entry interface is displayed; according to the basic information received by the entry interface, the basic information of the target database to be created is generated. Among them, the basic information includes the label information of the database to be created. The label information can be understood as the name of the database to be created, such as a lung cancer disease-specific database, etc. The basic information may optionally further include a manager identifier, a source database identifier, etc.

[0043] S120. In response to a field design trigger operation for the database table, a field configuration interface is displayed.

[0044] The database table stores the field information of the data stored in the database. In this embodiment, the user can configure the field information according to actual needs.

[0045] In one embodiment, the entry interface is configured with a control for triggering field design, such as a control labeled "field design" or a control labeled "next step". The user clicks or touches the control to trigger the control; the processor displays a field configuration interface in response to the trigger operation, and the user can configure the required fields on the field configuration interface.

[0046] In one embodiment, a field configuration interface displays an editable alternative library table, which includes multiple alternative fields; the user can select the required fields according to actual needs. The processor determines the corresponding target fields in response to the selection operation for the alternative fields; and in response to the confirmation operation for the field configuration interface, generates a target library table of the target database based on all the target fields. The embodiment significantly reduces the difficulty of library table design through the alternative library table.

[0047] On the basis of the foregoing embodiment, an alternative field library is set on the field configuration interface. When the user needs to add a target field to the alternative library table, the user can select the required field from the alternative field library and then add the field to the alternative library table. The combined use of the alternative library table and the alternative field library further reduces the difficulty of field design.

[0048] S130. Generate a target library table of the target database according to the field configuration information received by the field configuration interface.

[0049] Generate a target library table of the target database according to the current candidate library table in the field configuration interface. For example, directly use the current candidate library table as the target database table.

[0050] It can be understood that the field configuration information received by the field configuration interface can all be first fields, or can include at least one first field and at least one second field. Among them, the first field is an existing field in the source library table, and the source library table is the library table of the source database; the second field is a new field determined based on the existing fields in the source library table.

[0051] Exemplarily, the field configuration information includes body fat percentage, which does not exist in the source database but includes weight and height. The body fat percentage can be determined based on the height and weight in the source database. Therefore, the second field can also be considered as a field having an association relationship with the first field.

[0052] S140. In response to a database creation instruction, establish a communication connection with the source database, determine an object set based on the combination of object information, search for the diagnosis and treatment data of each object in the object set in the source database, process the diagnosis and treatment data of each object according to the target library table, obtain the target diagnosis and treatment data of each object, and create a target database including the target diagnosis and treatment data of each object.

[0053] The target database table display page includes a creation control for triggering a database creation instruction by clicking or touching the creation control. When the processor detects the database creation instruction, it establishes a communication connection with the source database, determines an object set based on the combined object information, then searches for the diagnosis and treatment data of each object in the object set in the source database, processes the diagnosis and treatment data of each object according to the target database table to obtain the target diagnosis and treatment data of each object, and simultaneously creates a target database including the target diagnosis and treatment data of each object.

[0054] In the process of creating the target database in the embodiment of the present invention, it is only necessary to determine a virtual data set originating from the source database through the target database table, and determine the target diagnosis and treatment data of each target object to be stored in the database based on the virtual data set, without creating any physical copies of the data.

[0055] In one embodiment, after the target database is created, in response to a permission configuration operation, a permission configuration interface is displayed, and according to the user identifier and permission scope received by the permission configuration interface, the data access scope of the user is determined. In this way, the user can only access and use data within the data access scope corresponding to their permission scope. This improves the management difficulty of the database and the security of data use. The data access scope includes the access scope at the granularity level and the access scope in terms of privacy level. Exemplarily, user A can only access data at the first granularity level, while the target database includes at least two granularity levels of data, and the data at the second granularity level is more accurate. User B can only access data within the first data range, and the data within the first data range does not include data privacy data. Different data can be hidden from different users through the data access scope, improving the security of database use.

[0056] In one embodiment, in response to a design trigger operation, a data access query interface is displayed; according to the query information received by the data access query interface, a query result is displayed, and the query result includes the user identifier accessing the target database, the access time period, the access frequency, etc. This embodiment helps to reduce the management difficulty of the database.

[0057] In one embodiment, in response to a data quality analysis operation on the target database, a data quality analysis report corresponding to the data quality analysis operation is displayed. This embodiment enables the user to intuitively clarify the data quality in the target database.

[0058] In one embodiment, the target database is set with an authorized usage period, which can be a default usage period or a modifiable usage period, and this usage period belongs to the software development party. Exemplarily, the default authorized usage period is displayed on the basic information entry interface so that the user can clearly know the specific authorized usage period at the first time. In this embodiment, after the target database is created, when the processor detects a data access request, it will determine whether the authorized usage period has expired. If it has not expired, it will output the data access result corresponding to the data access request; if the authorized usage period has expired, it will output a prompt message indicating that the usage period of the target database has expired. The setting of the authorized usage period can meet the data usage needs of short-term data users and the database usage experience needs of long-term data users.

[0059] It can be understood that after the target database is created, in the case that new diagnostic data of target objects appears in the source data, the user can update the target database based on the source database through the method described in the embodiments of the present invention.

[0060] The software or device for implementing the method described in the embodiments of the present invention can be configured as a module of the source database software or as a separate software or device.

[0061] The technical solution of the database creation method provided by the embodiments of the present invention determines the object information combination through the object search information received by the object information configuration interface, and generates the target library table of the target database through the field configuration information received by the automatic configuration interface; after establishing a communication connection with the source database, it determines the object set based on the object information combination, then searches for the diagnostic data of each object in the object set from the source database, and processes the diagnostic data of each object according to the target library table to obtain the target diagnostic data, and creates a target database including the target diagnostic data of each object, realizing the sequential processing of data pulling and data processing, and improving the creation speed of the target database.

[0062] Figure 2 This is a flowchart of the database creation method provided by the embodiments of the present invention. In this embodiment, the step of database information browsing is added on the basis of the foregoing embodiment. As Figure 2 shown, the method includes:

[0063] S210. Generate an object information combination according to the object search information received by the object information configuration interface.

[0064] S220. In response to a trigger operation for the field design of the database table, display a field configuration interface.

[0065] S2301. Generate the target library table of the target database according to the field configuration information received by the field configuration interface.

[0066] S2302. In response to an information preview operation, display the object information combination and field configuration information on the information preview interface.

[0067] To ensure the accuracy of the target database, it is necessary to ensure the accuracy of the object information combination and the target database table. To ensure the accuracy of the object information combination and the target database table as much as possible, in this embodiment, after the target database table is generated, the user is allowed to trigger information preview through an information preview operation, so that the processor displays the object information combination and field configuration information through the information preview interface. The user can check the object information combination and the target database table. If there is no problem with the object information combination and the target database table, the user can click or touch the control on the information preview interface for indicating database creation. After the processor detects the trigger operation for this control, a database creation instruction is generated.

[0068] If there is a problem with at least one of the object information combination and the field configuration information, click or touch the first control on the information browsing interface for indicating returning to the object information configuration interface, or click or touch the second control for indicating returning to the field configuration interface; the processor displays the object information configuration interface corresponding to the current object information combination according to the trigger operation for the first control, or displays the field configuration interface corresponding to the target database table according to the trigger operation for the second control. In this way, the user can modify the object information combination by modifying the object search information again in the object information configuration interface, or modify the field configuration information by modifying the field configuration information in the field configuration interface.

[0069] In one embodiment, the information preview interface displays the field classification result, and the category information of each field includes the field main classification, field sub-classification, and field type. Exemplarily, the field main classification is diagnosis, the field sub-classification is inpatient diagnosis, and the field type is text type. Another example is that the field main classification is diagnosis, the field sub-classification is outpatient, and the field type is numeric type.

[0070] Based on the foregoing embodiment, the field configuration information includes at least two fields with field type identifiers, and the information preview interface also displays the field filling rate of each field (see Figure 3 ), where the field filling rate is the proportion of the number of fields corresponding to the corresponding field type identifier in all fields. Exemplarily, the information preview interface displays the filling rate of basic demographic information, the filling rate of admission records, the filling rate of the front page of the medical record, the filling rate of medical examinations, and the filling rate of tests. Optionally, the field filling rates of different fields are represented by sector charts of different colors, and the field filling rate is associated with the central angle and radius of the sector chart. For example, if the field filling rate of basic demographic information is greater than the field filling rate of admission records, then both the central angle and radius of the sector chart corresponding to the field filling rate of basic demographic information are greater than the central angle and radius of the sector chart corresponding to the admission records.

[0071] Based on the foregoing embodiments, the information preview interface also displays the quality scores of each field (see Figure 4 ). Specifically, the alternative field library in the foregoing embodiments stores alternative fields and the quality scores of each alternative field, and the alternative field library includes the fields and quality scores of the existing fields in the alternative library table. Therefore, after the field configuration information is determined, the quality scores of each field in the field configuration information can be extracted from the alternative field library, and the quality scores of each field are displayed on the information preview interface.

[0072] S240. In response to a database creation instruction, establish a communication connection with the source database, determine an object set based on the object information combination, search for the diagnosis and treatment data of each object in the object set in the source database, process the diagnosis and treatment data of each object according to the target library table, and obtain the target diagnosis and treatment data of each object, and create a target database including the target diagnosis and treatment data of each object.

[0073] The technical solution provided by the embodiment of the present invention enables the user to confirm whether the object information combination and the target library table are accurate by displaying the object information combination and the target library table on the information preview interface. This secondary information confirmation can reduce the probability of problems with the object information combination and / or the target library table, thereby improving the accuracy of the target database.

[0074] Figure 5 It is a schematic structural diagram of the database creation device provided by the embodiment of the present invention. As Figure 5 shown, the device includes:

[0075] An information combination determination module 31, configured to generate an object information combination according to the object search information received by the object information configuration interface;

[0076] An interface display module 32, configured to display a field configuration interface in response to a trigger operation for field design of a database table;

[0077] A library table generation module 33, configured to generate a target library table of the target database according to the field configuration information received by the field configuration interface;

[0078] A creation module 34, configured to establish a communication connection with the source database in response to a database creation instruction, determine an object set based on the object information combination, search for the diagnosis and treatment data of each object in the object set in the source database, process the diagnosis and treatment data of each object according to the target library table, and obtain the target diagnosis and treatment data of each object, and create a target database including the target diagnosis and treatment data of each object.

[0079] In one embodiment, as Figure 6As shown, the device includes a label information module 30, and the label information module 30 is used for:

[0080] In response to the basic information entry operation, display the basic information entry interface;

[0081] Generate the basic information of the target database to be created according to the basic information received on the entry interface, and the basic information includes the label information of the database to be created.

[0082] In one embodiment, the object search information includes at least one of a target disease identifier, a target distribution area identifier, a visit time, a first diagnosed age, a gender, an age, a residential address, and target index information; the visit time includes the first visit time and / or the last visit time for the disease corresponding to the target disease identifier; the target index information includes at least one target index and the index data of each of the at least one target index.

[0083] In one embodiment, the fields in the field configuration information include at least one first field and at least one second field; the first field is an existing field in the source database table, and the source database table is the database table of the source database; the second field is a new field determined based on the existing fields in the source database table.

[0084] In one embodiment, as Figure 7 shown, the device further includes a preview module 35, and the preview module 35 is used for:

[0085] In response to the information preview operation, display the object information combination and the target database table on the information preview interface.

[0086] In one embodiment, the field configuration interface displays alternative database tables, and the alternative database tables include multiple alternative fields. The database table generation module is used for:

[0087] In response to the selection operation for the alternative fields, determine the corresponding target fields;

[0088] In response to the confirmation operation for the field configuration interface, generate the target database table of the target database according to all the target fields.

[0089] The technical solution provided by the embodiment of the present invention determines an object information combination based on the object search information received through the object information configuration interface, and generates a target database table of the target database through the field configuration information received through the automatic configuration interface; after establishing a communication connection with the source database, an object set is determined based on the object information combination, and then the diagnosis and treatment data of each object in the object set is searched from the source database, and the diagnosis and treatment data of each object is processed according to the target database table to obtain target diagnosis and treatment data, and a target database including the target diagnosis and treatment data of each object is created, realizing sequential processing of data pulling and data processing, and improving the creation speed of the target database.

[0090] The database creation device provided by the embodiment of the present invention can execute the database creation method provided by any embodiment of the present invention, and has functional modules and beneficial effects corresponding to the execution method.

[0091] Figure 8 FIG. shows a schematic structural diagram of an electronic device 10 that can be used to implement the embodiments of the present invention. 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 electronic device can also represent various forms of mobile devices, such as, personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the present invention described and / or claimed herein.

[0092] As Figure 8 shown, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., wherein the memory stores a computer program executable by the at least one processor, and the processor 11 can execute various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 into the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. The input / output (I / O) interface 15 is also connected to the bus 14.

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

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

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

[0096] The various embodiments of the systems and technologies 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), complex programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, the programmable processor can be a dedicated or general-purpose programmable processor, and can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit the data and instructions to the storage system, the at least one input device, and the at least one output device.

[0097] A computer program for implementing the method 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 apparatus, such that the computer programs, when executed by the processor, cause the functions / operations specified in the flowchart and / or block diagram to be implemented. The computer program may be executed entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.

[0098] In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The 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 of the foregoing. Alternatively, the computer-readable storage medium may be a machine-readable signal medium. More specific examples of the machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0099] In order to provide interaction with a user, the systems and techniques described herein may 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 a pointing device (e.g., a mouse or a trackball) by which the user can provide input to the electronic device. Other kinds of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, speech input, or tactile input).

[0100] The systems and techniques described herein can be implemented in a computing system including backend components (e.g., as a data server), or a computing system including middleware components (e.g., an application server), or a computing system including frontend components (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described herein), or a computing system including any combination of such backend components, middleware components, or frontend components. The components of the system can be interconnected to each other by digital data communication in any form or medium (e.g., a communication network). Examples of communication networks include: local area network (LAN), wide area network (WAN), blockchain network, and the Internet.

[0101] A computing system can include a client and a server. The client and the server are generally remote from each other and typically interact through a communication network. The client-server relationship is created by computer programs running on 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 a cloud host, which is a host product in the cloud computing service system, solving the defects of difficult management and weak business scalability existing in traditional physical hosts and VPS services.

[0102] An embodiment of the present invention also provides a computer program product, including a computer program which, when executed by a processor, implements the database creation method provided in any embodiment of the present application.

[0103] In the process of implementing the computer program product, computer program code for performing the operations of the present invention can be written in one or more programming languages or combinations thereof. The programming languages include object-oriented programming languages such as Java, Smalltalk, C++, and also include conventional procedural programming languages such as the "C" language or similar programming languages. The program code can be executed entirely on the user computer, partially on the user computer, executed as a stand-alone software package, partially on the user computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer can be connected to the user computer through any type of network - including a local area network (LAN) or a wide area network (WAN) - or can be connected to an external computer (e.g., by connecting through an Internet service provider via the Internet).

[0104] 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 recited in the present invention can be executed in parallel, sequentially, or in a different order, as long as the desired results of the technical solution of the present invention can be achieved, and no limitation is imposed herein.

[0105] The above specific embodiments do not constitute a limitation on the protection scope of the present 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 the present invention shall be included within the protection scope of the present invention.

Claims

1. A method for creating a database, characterized in that, including: generating an object information combination based on the object search information received by the object information configuration interface; displaying a field configuration interface in response to a trigger operation for field design of a database table; generating a target database table of the target database based on the field configuration information received by the field configuration interface; in response to a database creation instruction, establishing a communication connection with a source database, determining an object set based on the object information combination, searching for the diagnosis and treatment data of each object in the object set in the source database, processing the diagnosis and treatment data of each object according to the target database table to obtain the target diagnosis and treatment data of each object, and creating a target database including the target diagnosis and treatment data of each object.

2. The method according to claim 1, wherein Before generating the object information combination based on the object search information received by the object information configuration interface, it further includes: displaying a basic information entry interface in response to a basic information entry operation; generating the basic information of the target database to be created based on the basic information received by the entry interface, where the basic information includes the label information of the database to be created.

3. The method according to claim 1, wherein: the object search information includes at least one of a target disease identifier, a target distribution area identifier, a visit time, a first diagnosis age, a gender, an age, a residential address, and target index information; the visit time includes the first visit time and / or the last visit time for the disease corresponding to the target disease identifier; the target index information includes at least one target index and the index data of each target index in the at least one target index.

4. The method according to claim 1, wherein: the fields in the field configuration information include at least one first field and at least one second field; the first field is an existing field in the source database table, and the source database table is a database table of the source database; the second field is a new field determined based on the existing fields in the source database table.

5. The method according to claim 1, wherein The field configuration interface displays alternative database tables, and the alternative database tables include multiple alternative fields. Generating the target database table of the target database based on the field configuration information received by the field configuration interface includes: determining a corresponding target field in response to a selection operation for the alternative field; in response to a confirmation operation for the field configuration interface, generating a target database table of the target database based on all the target fields.

6. The method according to claim 1, wherein After generating the target database table of the target database based on the field configuration information received by the field configuration interface, it further includes: displaying the object information combination and the field configuration information on an information preview interface in response to an information preview operation.

7. A database creation device, characterized in that, including: an information combination determination module, configured to generate an object information combination based on the object search information received by the object information configuration interface; an interface display module, configured to display a field configuration interface in response to a trigger operation for field design of a database table; a database table generation module, configured to generate a target database table of the target database based on the field configuration information received by the field configuration interface; A creation module, configured to establish a communication connection with a source database in response to a database creation instruction, determine an object set based on the combination of the object information, search for the diagnosis and treatment data of each object in the object set in the source database, process the diagnosis and treatment data of each object according to the target database table, obtain the target diagnosis and treatment data of each object, and create a target database including the target diagnosis and treatment data of each object.

8. An electronic device, characterized in that, 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 executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the database creation method according to any one of claims 1-6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions, and the computer instructions are used to implement the database creation method according to any one of claims 1-6 when executed by a processor.

10. A computer program product, characterized in that, The computer program product includes a computer program, and the computer program implements the database creation method according to any one of claims 1-6 when executed by a processor.

Images