CN111949692A - DTO-based user-defined index configuration method, system, equipment and medium - Google Patents

DTO-based user-defined index configuration method, system, equipment and medium Download PDF

Info

Publication number
CN111949692A
CN111949692A CN202010753789.3A CN202010753789A CN111949692A CN 111949692 A CN111949692 A CN 111949692A CN 202010753789 A CN202010753789 A CN 202010753789A CN 111949692 A CN111949692 A CN 111949692A
Authority
CN
China
Prior art keywords
data
index
rule
custom
hospital
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010753789.3A
Other languages
Chinese (zh)
Inventor
殷嘉珩
陈良
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hefei Senyi Intelligent Technology Co Ltd
Original Assignee
Hefei Senyi Intelligent Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hefei Senyi Intelligent Technology Co Ltd filed Critical Hefei Senyi Intelligent Technology Co Ltd
Priority to CN202010753789.3A priority Critical patent/CN111949692A/en
Publication of CN111949692A publication Critical patent/CN111949692A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24564Applying rules; Deductive queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Medical Treatment And Welfare Office Work (AREA)

Abstract

The application provides a DTO-based user-defined index configuration method, a DTO-based user-defined index configuration system, DTO-based user-defined index configuration equipment and DTO-based user-defined index configuration media, wherein data models containing fields with different meanings are constructed; mapping the hospital data in various different formats to the data model according to a predefined structured rule so as to extract the hospital data in the data model according to the structured rule; and setting a filtering rule or a calculation rule in a preset index custom configuration page according to the service requirement so as to extract real-time in-hospital data corresponding to the custom index for the corresponding statistical display of the front-end page. The method and the device can avoid the work of repeatedly assigning values and manually calculating the composite index in a semantic layer data set link, and simultaneously change the data into the module, so that the data object mapping can release greater flexibility, the rapid configuration of the index is realized, the development efficiency is effectively improved, and the index configuration flow is optimized.

Description

DTO-based user-defined index configuration method, system, equipment and medium
Technical Field
The invention relates to the technical field of data processing, in particular to a DTO-based custom index configuration method, a DTO-based custom index configuration system, DTO-based custom index configuration equipment and DTO-based custom index configuration media.
Background
At present, the medical industry is in the rapid development stage of information-based construction, and with the advance of information-based construction, a large amount of generated medical industry data are scattered in each information system of a hospital, so derived medical industry data products and a hospital comprehensive operation management system aim at operation indexes which are mainly concerned by hospital managers, and a data model which is uniform in management, clear in logic, simple and convenient in configuration and high in performance is urgently needed to finish representing the abstract data table at the bottom layer as a concrete operation index. The reappearance of the business scene is realized by specifically monitoring the index result, drilling down and jumping, so that an effective basis is better provided for hospital management decision.
In the conventional index management system in the data product of the medical industry, for example, the conventional BI semantic layer data set design, the latest hospital data cannot be searched in real time, so that the obtained index general statistics result often has certain time lag; in addition, in the index statistical system, a commonly used or customized index pull selection window is often preset in an earlier stage, other index statistical functions cannot be added according to the requirements of a complex scene, and the statistical function of a customized index cannot be provided, so that the bottom layer development such as data source structure adjustment, business logic adjustment and the like needs to be adjusted greatly.
Disclosure of Invention
In view of the above-mentioned shortcomings in the prior art, it is an object of the present application to provide a method, system, device and medium for configuring a DTO-based custom metric, so as to solve at least one problem in the prior art.
In order to achieve the above and other related objects, the present application provides a DTO-based custom indicator configuration method, including: constructing a data model containing different meaning fields; mapping the hospital data in various different formats to the data model according to a predefined structured rule so as to extract the hospital data in the data model according to the structured rule; and setting a filtering rule or a calculation rule in a preset index custom configuration page according to the service requirement so as to extract real-time in-hospital data corresponding to the custom index for the corresponding statistical display of the front-end page.
In an embodiment of the present application, the meaning categories of the fields include: any one or more of a patient, department, doctor, registration, diagnosis, examination, case, income, medication, and hospitalization.
In an embodiment of the present application, the data model is constructed based on a DTO data transfer software application system.
In an embodiment of the present application, the mapping the in-hospital data in a plurality of different formats to the data model according to predefined structured rules includes: acquiring in-hospital data in different formats in a courtyard database; and cleaning the data structure mapped to the data model according to a predefined structured rule so as to enable the information of the patient data to be normalized.
In an embodiment of the present application, the user-defined index added page includes: the index data base comprises any one or more of data courtyard, index type, index subject, index name, established self-defined index, operator, unit, index conversion factor, decimal number, measurement algorithm, calculation column, time dimension, index data standardization, filtering condition and index description.
In an embodiment of the application, the setting of the filtering rule or the calculation rule in the preset index custom configuration page according to the service requirement to extract real-time in-hospital data corresponding to the custom index includes: setting a filtering rule or a calculation rule on the index custom configuration page according to the service requirement; converting into SQL business logic program according to current environment according to filter rule or calculation rule; extracting corresponding real-time in-hospital data from the data model according to the SQL service logic program; and performing integrated processing of duplicate removal, combination and format normalization on the extracted in-hospital data.
In an embodiment of the present application, the extracted frequency may be set according to actual business requirements.
To achieve the above and other related objects, the present application provides a DTO-based custom metric configuration system, which includes: the model building module is used for building a data model containing different meaning fields; the data mapping module is used for mapping the in-hospital data in various different formats to the data model according to a predefined structured rule so as to extract the in-hospital data in the data model according to the structured rule; and the index definition module is used for setting a filtering rule or a calculation rule in a preset index custom configuration page according to the service requirement so as to extract real-time in-hospital data corresponding to the custom index for the corresponding statistical display of the front-end page.
To achieve the above and other related objects, the present application provides a computer apparatus, comprising: a memory, and a processor; the memory is to store computer instructions; the processor executes computer instructions to implement the method as described above.
To achieve the above and other related objects, the present application provides a computer readable storage medium storing computer instructions which, when executed, perform the method as described above.
In summary, the DTO-based custom index configuration method, system, device, and medium provided by the present application construct a data model containing different meaning fields; mapping the hospital data in various different formats to the data model according to a predefined structured rule so as to extract the hospital data in the data model according to the structured rule; and setting a filtering rule or a calculation rule in a preset index custom configuration page according to the service requirement so as to extract real-time in-hospital data corresponding to the custom index for the corresponding statistical display of the front-end page.
Has the following beneficial effects:
aiming at the index management problem existing in the data products in the medical industry at present, the self-defined index rapid configuration function based on the DTO is innovatively provided, the data object mapping is supported through the data filtering rule configuration and the index-conforming calculation configuration defined in the data object during index configuration, the work of repeatedly assigning values and manually calculating composite indexes in a semantic layer data set link is avoided, and meanwhile, the data is changed into a module, so that the data object mapping can release greater flexibility, and the rapid configuration of the indexes is realized. The application practice of the DTO-based user-defined index rapid configuration function in the data analysis platform extracts public parts such as index query, calculation and object mapping of a data product, effectively improves the development efficiency and optimizes the index configuration process.
Drawings
Fig. 1 is a schematic flowchart illustrating a DTO-based custom indicator configuration method according to an embodiment of the present disclosure.
Fig. 2 is a schematic view of a scenario of an index custom configuration page according to an embodiment of the present application.
Fig. 3 is a schematic view of a scenario illustrating statistics of a front-end page according to an embodiment of the present application.
Fig. 4 is a block diagram of a DTO-based custom index configuration system according to an embodiment of the present disclosure.
Fig. 5 is a schematic structural diagram of a computer device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application is provided by way of specific examples, and other advantages and effects of the present application will be readily apparent to those skilled in the art from the disclosure herein. The present application is capable of other and different embodiments and its several details are capable of modifications and/or changes in various respects, all without departing from the spirit of the present application. It is to be noted that the features in the following embodiments and examples may be combined with each other without conflict.
It should be noted that the drawings provided in the following embodiments are only schematic and illustrate the basic idea of the present application, and although the drawings only show the components related to the present application and are not drawn according to the number, shape and size of the components in actual implementation, the type, quantity and proportion of the components in actual implementation may be changed at will, and the layout of the components may be more complex.
Throughout the specification, when a part is referred to as being "connected" to another part, this includes not only a case of being "directly connected" but also a case of being "indirectly connected" with another element interposed therebetween. In addition, when a certain part is referred to as "including" a certain component, unless otherwise stated, other components are not excluded, but it means that other components may be included.
The terms first, second, third, etc. are used herein to describe various elements, components, regions, layers and/or sections, but are not limited thereto. These terms are only used to distinguish one element, component, region, layer or section from another element, component, region, layer or section. Thus, a first element, component, region, layer or section discussed below could be termed a second element, component, region, layer or section without departing from the scope of the present application.
Also, as used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context indicates otherwise. It will be further understood that the terms "comprises," "comprising," and/or "comprising," when used in this specification, specify the presence of stated features, operations, elements, components, items, species, and/or groups, but do not preclude the presence, or addition of one or more other features, operations, elements, components, items, species, and/or groups thereof. The terms "or" and/or "as used herein are to be construed as inclusive or meaning any one or any combination. Thus, "A, B or C" or "A, B and/or C" means "any of the following: a; b; c; a and B; a and C; b and C; A. b and C ". An exception to this definition will occur only when a combination of elements, functions or operations are inherently mutually exclusive in some way.
The existing index statistical system, such as the semantic layer data set design of the traditional BI (business intelligence) system, cannot find the latest hospital data in real time, so that the obtained index general statistical result often has certain time lag; in addition, in the index statistical system, a commonly used or customized index pull selection window is often preset in an earlier stage, other index statistical functions cannot be added according to the requirements of a complex scene, and the statistical function of a customized index cannot be provided, so that the bottom layer development such as data source structure adjustment, business logic adjustment and the like needs to be adjusted greatly.
In view of the problems in the prior art, an object of the present invention is to provide a method, a system, a device, and a medium for configuring a self-defined index based on DTO, so as to achieve fast configuration of an index, improve development efficiency, and optimize an index configuration process.
Fig. 1 is a schematic flow chart of a DTO-based custom indicator configuration method according to an embodiment of the present application. As shown, the method comprises:
step S101: and constructing a data model containing different meaning fields.
It should be noted that the data model is constructed based on a DTO data transfer software application system. The Data Transfer Object (DTO) is a software application that is designed to Transfer Data between modes. Often the data transfer objective is for a data access object to retrieve data from a database. The data transfer object DTO itself is not a business object. The data transfer object is designed according to the requirements of the UI, not according to the domain object. The decoupling between the presentation layer and the Model is realized through the DTO, the presentation layer does not refer to the Model, and if the Model is changed in the development process and the interface is not changed, only the Model needs to be changed without changing the contents in the presentation layer.
The advantages brought by adopting the DTO model are as follows: 1. according to the existing class codes, the DTO object can be conveniently constructed without analyzing again. 2. The request times are reduced, and the efficiency is greatly improved. 3. The DTO objects are organized according to needs, the fields needed by the page are organized, the fields are not needed to be organized, the transmission of the fields of the whole table can be avoided, and the safety is improved to a certain extent.
Different from the design of a semantic layer data set of a traditional BI (business to information) data, the method adopts a DTO (data transfer object) data transmission software application system to build a user-defined index rapid configuration function, on one hand, the method can search the latest data in real time, on the other hand, the DTO-based user-defined index rapid configuration function enables the configuration definition of the index to be more biased to the business, business personnel can correct the statistical calibers of all indexes only by redefining the attribute of the index, and the semantic layer data set of all application indexes does not need to be logically adjusted, so that the index configuration efficiency is greatly improved.
In the present embodiment, the different meaning fields mainly refer to fields corresponding to different functions or categories in the hospital. The meaning categories of the fields include, but are not limited to: any one or more of a patient, department, doctor, registration, diagnosis, examination, case, income, medication, and hospitalization.
Generally, the entity class is inherited using a DTO class, some service fields are placed in the DTO class, and a get, set method is provided. When some fields which do not exist in the database are used in the service logic layer or the interaction layer, the fields, namely the fields with different meanings described in the application, need to be put in the DTO class, and the fields are pre-established according to the service requirements and then put in the DTO class to construct the data model. The meaning of the fields is equivalent to that of processed database fields, and the essential meaning is that the data interaction is convenient and the efficiency is improved.
Step S102: and mapping the hospital data in various different formats to the data model according to a predefined structured rule so as to extract the hospital data in the data model according to the structured rule.
In this embodiment, briefly, the in-hospital data in various formats is cleaned and summarized to the non-passing meaning field included in the data model according to the predefined structured rule, so that all the corresponding related in-hospital data can be quickly found and extracted according to the field in the index custom configuration process.
It should be noted that the structured rule mainly means that the data in the hospital is mapped according to a preset field name or the content of a preset table structure, where the structure or the table structure includes fields with different definitions. For example, gender-related in-hospital data is mapped into the SEX field.
In this embodiment, the mapping the in-hospital data in a plurality of different formats to the data model according to the predefined structured rule includes:
A. acquiring the in-hospital data in different formats in the yard database.
For example, databases built for different departments or areas in a general hospital may be built by different manufacturers, such as pharmacy data systems, hospitalization systems, examination and test systems, and the data structures of the databases and the formats, names and the like of the databases are different. The method comprises the steps of firstly obtaining all related in-hospital data from a plurality of different databases of an institution.
B. And cleaning the data structure mapped to the data model according to a predefined structured rule so as to enable the information of the patient data to be normalized.
In this embodiment, the acquired hospital data is then cleaned to map the data structure required by the preset data model (or database) of the present application, and to make the information of the hospital data unique. For example, the specific cleansing action is directed to a uniform modification of the data structure on the one hand and a unique modification of the patient data information in various formats or names on the other hand, for example, some basic information of the patient may be in different storage formats in different systems, such as a picture format and a text format. Although some information in the hospital data is in different formats or names, the essential information is unique, such as name, gender, social security card number, identification number, and the like.
Step S103: and setting a filtering rule or a calculation rule in a preset index custom configuration page according to the service requirement so as to extract real-time in-hospital data corresponding to the custom index for the corresponding statistical display of the front-end page.
In this embodiment, the setting of the filtering rule or the calculation rule in the preset index custom configuration page according to the service requirement to extract the real-time in-hospital data corresponding to the custom index includes:
A. and setting a filtering rule or a calculation rule on the index custom configuration page according to the service requirement.
In the present embodiment, as shown in fig. 2, a schematic diagram of a custom indicator newly added page is shown. In short, the filtering rules or the calculation rules can be set in the index custom configuration page shown in fig. 2. As shown in the figure, the new page with the custom index includes: the index data base comprises any one or more of data courtyard, index type, index subject, index name, established self-defined index, operator, unit, index conversion factor, decimal number, measurement algorithm, calculation column, time dimension, index data standardization, filtering condition and index description.
For example, the data yard may be used to select an east yard, west yard, division yard, etc. of a hospital; the index types may include, for example, "basic index", "calculation index", "derivation index", and the like; the index theme refers to the service line to which the index belongs, such as an outpatient theme; the index name can refer to an official name urheen self-defined name; the established self-defined index can be shown as index 1 and index 2 in the figure, which indicates that a self-defined index is established according to the newly added page of the self-defined index, for example, a self-defined index with the index name 001 is established, and the self-defined index with the index name 001 can be selected from the index 1; the operator comprises common operation symbols among multiple data or complex data, such as operators of addition, subtraction, multiplication, division and the like; the unit is a statistical unit, such as 'number of people' and 'amount'; the index conversion factor may be a coefficient or weight added in the complex index calculation process; the calculation column can select data for calculation from the data column; the time dimension refers to a time field used in counting the indexes; the index data is standardized to define an evaluation criterion of the index, such as "positive index", "negative index"; the filtering condition can filter data through editable formulas such as characters and characters; the index description is used for carrying out information annotation or explanation on the index.
B. And converting the SQL business logic program which accords with the current environment according to the filtering rule or the calculation rule.
The filtering rules or the calculation rules configured by the custom index are obtained through the custom index adding page as shown in fig. 2, and the related filtering rules or calculation rules can be directly and correspondingly converted into program codes with a preset frame or template, so as to be converted into the SQL service logic program conforming to the current environment.
C. Extracting corresponding real-time in-hospital data from the data model according to the SQL service logic program; and performing integrated processing of duplicate removal, combination and format normalization on the extracted in-hospital data.
In some embodiments, according to the SQL business logic program, the underlying data in the data model may then be obtained through the data transfer object DTO. Further, in some complex scenarios, the in-hospital data mapped in the data model may also be subjected to an integrated process of deduplication, consolidation, and format normalization.
In this embodiment, for example, since the hospital data source for a patient may come from different departments of a hospital, there may be duplication of data and non-uniform formats of data such as variables or parameters, and therefore, the mapped hospital data is subjected to the integrated process of de-duplication, merging and format normalization in the data model.
It should be noted that, a filtering rule or a calculation rule is set in a preset index custom configuration page according to a service requirement, which is actually the definition of an index aperture, that is, the setting of a statistical mode of an index and a service description.
In this embodiment, the extracted frequency may be set according to actual business requirements, and corresponds to the frequency or degree of data update.
In this embodiment, after extracting the real-time in-hospital data corresponding to the user-defined index, the real-time data queried in the database is displayed on the front-end page of the system of the relevant application in a manner of API interface for statistical display. As shown in fig. 3. For example, the historical value or the current actual value of each traffic indicator may be counted. The embodiment in fig. 3 is for illustration only and is not intended to limit the present application. Any person skilled in the art can modify or change the above-described embodiments without departing from the spirit and scope of the present application.
In summary, the application provides a self-defined index configuration method based on the DTO innovatively for the index management problem existing in the current data product in the medical industry, and the data object mapping is supported through the data filtering rule configuration and the index-conforming calculation configuration defined in the data object during the index configuration, so that the work of repeatedly assigning values and manually calculating a composite index in a semantic layer data set link is avoided, and meanwhile, the data is changed into a module, so that the data object mapping can release greater flexibility, and the rapid configuration of the index is realized. The application practice of the DTO-based user-defined index rapid configuration function in the data analysis platform extracts public parts such as index query, calculation and object mapping of a data product, effectively improves the development efficiency and optimizes the index configuration process.
Fig. 4 is a block diagram of a DTO-based system for fast configuration of a custom index according to an embodiment of the present invention. As shown, the system 400 includes:
a model construction module 401 for constructing a data model containing different meaning fields;
the data mapping module 402 is used for mapping the hospital data in various formats to the data model according to predefined structured rules, so as to extract the hospital data in the data model according to the structured rules;
the index definition module 403 sets a filtering rule or a calculation rule in a preset index custom configuration page according to the service requirement, so as to extract real-time in-hospital data corresponding to the custom index for the front-end page to perform corresponding statistical display.
It should be noted that, for the information interaction, execution process, and other contents between the modules/units of the system, since the same concept is based on the embodiment of the method described in this application, the technical effect brought by the embodiment of the method is the same as that of the embodiment of the method in this application, and specific contents may refer to the description in the foregoing embodiment of the method in this application, and are not described herein again.
It should be further noted that the division of the modules of the above system is only a logical division, and the actual implementation may be wholly or partially integrated into one physical entity, or may be physically separated. And these units can be implemented entirely in software, invoked by a processing element; or may be implemented entirely in hardware; and part of the modules can be realized in the form of calling software by the processing element, and part of the modules can be realized in the form of hardware. For example, the processing module 403 may be a separate processing element, or may be integrated into a chip of the system, or may be stored in a memory of the system in the form of program code, and a processing element of the system calls and executes the functions of the processing module 403. Other modules are implemented similarly. In addition, all or part of the modules can be integrated together or can be independently realized. The processing element described herein may be an integrated circuit having signal processing capabilities. In implementation, each step of the above method or each module above may be implemented by an integrated logic circuit of hardware in a processor element or an instruction in the form of software.
For example, the above modules may be one or more integrated circuits configured to implement the above methods, such as: one or more Application Specific Integrated Circuits (ASICs), or one or more microprocessors (DSPs), or one or more Field Programmable Gate Arrays (FPGAs), among others. For another example, when one of the above modules is implemented in the form of a Processing element scheduler code, the Processing element may be a general-purpose processor, such as a Central Processing Unit (CPU) or other processor capable of calling program code. For another example, these modules may be integrated together and implemented in the form of a system-on-a-chip (SOC).
Fig. 5 is a schematic structural diagram of a computer device according to an embodiment of the present application. As shown, the computer device 500 includes: a memory 501 and a processor 502; the memory 501 is used for storing computer instructions; the processor 502 executes computer instructions to implement the method described in fig. 1.
In some embodiments, the number of the memory 501 in the computer device 500 may be one or more, the number of the processor 502 may be one or more, and fig. 5 is taken as an example.
In an embodiment of the present application, the processor 502 in the computer device 500 loads one or more instructions corresponding to processes of an application program into the memory 501 according to the steps described in fig. 1, and the processor 502 executes the application program stored in the memory 501, thereby implementing the method described in fig. 1.
The Memory 501 may include a Random Access Memory (RAM), and may also include a non-volatile Memory (non-volatile Memory), such as at least one disk Memory. The memory 501 stores an operating system and operating instructions, executable modules or data structures, or a subset thereof, or an expanded set thereof, wherein the operating instructions may include various operating instructions for implementing various operations. The operating system may include various system programs for implementing various basic services and for handling hardware-based tasks.
The Processor 502 may be a general-purpose Processor, and includes a Central Processing Unit (CPU), a Network Processor (NP), and the like; the Integrated Circuit may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, a discrete Gate or transistor logic device, or a discrete hardware component.
In some specific applications, the various components of the computer device 500 are coupled together by a bus system that may include a power bus, a control bus, a status signal bus, etc., in addition to a data bus. But for clarity of explanation the various busses are shown in fig. 5 as a bus system.
In an embodiment of the present application, a computer-readable storage medium is provided, on which a computer program is stored, which when executed by a processor implements the method described in fig. 1.
The present application may be embodied as systems, methods, and/or computer program products, in any combination of technical details. The computer program product may include a computer-readable storage medium having computer-readable program instructions embodied thereon for causing a processor to implement various aspects of the present application.
The computer readable storage medium may be a tangible device that can hold and store the instructions for use by the instruction execution device. The computer readable storage medium may be, for example, but is not limited to, an electronic memory device, a magnetic memory device, an optical memory device, an electromagnetic memory device, a semiconductor memory device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: 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), a Static Random Access Memory (SRAM), a portable compact disc read-only memory (CD-ROM), a Digital Versatile Disc (DVD), a memory stick, a floppy disk, a mechanical coding device, such as punch cards or in-groove projection structures having instructions stored thereon, and any suitable combination of the foregoing. Computer-readable storage media as used herein is not to be construed as transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission medium (e.g., optical pulses through a fiber optic cable), or electrical signals transmitted through electrical wires.
The computer-readable programs described herein may be downloaded from a computer-readable storage medium to a variety of computing/processing devices, or to an external computer or external storage device via a network, such as the internet, a local area network, a wide area network, and/or a wireless network. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers and/or edge servers. The network adapter card or network interface in each computing/processing device receives computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in a computer-readable storage medium in the respective computing/processing device.
The computer program instructions for carrying out operations of the present application may be assembly instructions, Instruction Set Architecture (ISA) instructions, machine related instructions, microcode, firmware instructions, state setting data, integrated circuit configuration data, or source code or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C + + or the like and procedural programming languages, such as the "C" programming language or similar programming languages. The computer-readable program instructions may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider). In some embodiments, the electronic circuitry can execute computer-readable program instructions to implement aspects of the present application by utilizing state information of the computer-readable program instructions to personalize the electronic circuitry, such as a programmable logic circuit, a Field Programmable Gate Array (FPGA), or a Programmable Logic Array (PLA).
In summary, the DTO-based custom index configuration method, system, device, and medium provided by the present application construct a data model containing different meaning fields; mapping the hospital data in various different formats to the data model according to a predefined structured rule so as to extract the hospital data in the data model according to the structured rule; and setting a filtering rule or a calculation rule in a preset index custom configuration page according to the service requirement so as to extract real-time in-hospital data corresponding to the custom index for the corresponding statistical display of the front-end page.
The application effectively overcomes various defects in the prior art and has high industrial utilization value.
The above embodiments are merely illustrative of the principles and utilities of the present application and are not intended to limit the invention. Any person skilled in the art can modify or change the above-described embodiments without departing from the spirit and scope of the present application. Accordingly, it is intended that all equivalent modifications or changes which can be made by those skilled in the art without departing from the spirit and technical spirit of the present invention be covered by the claims of the present application.

Claims (10)

1. A DTO-based custom index configuration method is characterized by comprising the following steps:
constructing a data model containing different meaning fields;
mapping the hospital data in various different formats to the data model according to a predefined structured rule so as to extract the hospital data in the data model according to the structured rule;
and setting a filtering rule or a calculation rule in a preset index custom configuration page according to the service requirement so as to extract real-time in-hospital data corresponding to the custom index for the corresponding statistical display of the front-end page.
2. The method of claim 1, wherein the meaning category of the field comprises: any one or more of a patient, department, doctor, registration, diagnosis, examination, case, income, medication, and hospitalization.
3. The method of claim 1, wherein the data model is constructed based on a DTO data transfer software application.
4. The method of claim 1, wherein mapping the nosocomial data in the plurality of different formats to the data model according to predefined structured rules comprises:
acquiring in-hospital data in different formats in a courtyard database;
and cleaning the data structure mapped to the data model according to a predefined structured rule so as to enable the information of the patient data to be normalized.
5. The method of claim 1, wherein the custom metric add-on page comprises: the index data base comprises any one or more of data courtyard, index type, index subject, index name, established self-defined index, operator, unit, index conversion factor, decimal number, measurement algorithm, calculation column, time dimension, index data standardization, filtering condition and index description.
6. The method of claim 1, wherein the setting of filtering rules or calculation rules in a preset index custom configuration page according to business requirements to extract real-time in-hospital data corresponding to a custom index comprises:
setting a filtering rule or a calculation rule on the index custom configuration page according to the service requirement;
converting into SQL business logic program according to current environment according to filter rule or calculation rule;
extracting corresponding real-time in-hospital data from the data model according to the SQL service logic program; and performing integrated processing of duplicate removal, combination and format normalization on the extracted in-hospital data.
7. The method according to claim 1 or 6, wherein the frequency of the extraction is set according to actual service requirements.
8. A DTO-based fast configuration system for custom metrics, the system comprising:
the model building module is used for building a data model containing different meaning fields;
the data mapping module is used for mapping the in-hospital data in various different formats to the data model according to a predefined structured rule so as to extract the in-hospital data in the data model according to the structured rule;
and the index definition module is used for setting a filtering rule or a calculation rule in a preset index custom configuration page according to the service requirement so as to extract real-time in-hospital data corresponding to the custom index for the corresponding statistical display of the front-end page.
9. A computer device, the device comprising: a memory, and a processor; the memory is to store computer instructions; the processor executes computer instructions to implement the method of any one of claims 1 to 7.
10. A computer-readable storage medium having stored thereon computer instructions which, when executed, perform the method of any one of claims 1 to 7.
CN202010753789.3A 2020-07-30 2020-07-30 DTO-based user-defined index configuration method, system, equipment and medium Pending CN111949692A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010753789.3A CN111949692A (en) 2020-07-30 2020-07-30 DTO-based user-defined index configuration method, system, equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010753789.3A CN111949692A (en) 2020-07-30 2020-07-30 DTO-based user-defined index configuration method, system, equipment and medium

Publications (1)

Publication Number Publication Date
CN111949692A true CN111949692A (en) 2020-11-17

Family

ID=73338778

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010753789.3A Pending CN111949692A (en) 2020-07-30 2020-07-30 DTO-based user-defined index configuration method, system, equipment and medium

Country Status (1)

Country Link
CN (1) CN111949692A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113190608A (en) * 2021-05-28 2021-07-30 北京红山信息科技研究院有限公司 Data standardized acquisition method, device, equipment and storage medium
CN113488182A (en) * 2021-05-25 2021-10-08 北京大学 Multi-source heterogeneous medical laboratory examination data processing method, device, equipment and medium
CN114745296A (en) * 2020-12-23 2022-07-12 北京首信科技股份有限公司 Data reporting method and device

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101582079A (en) * 2009-06-23 2009-11-18 用友软件股份有限公司 Object query method and device
CN104537103A (en) * 2015-01-12 2015-04-22 用友医疗卫生信息***有限公司 Data processing method and device
CN105389619A (en) * 2014-08-31 2016-03-09 通用电气公司 Methods and systems for improving connections within healthcare ecosystem
CN107341264A (en) * 2017-07-19 2017-11-10 东北大学 A kind of electronic health record system and method for supporting custom entities
CN109977162A (en) * 2019-04-10 2019-07-05 广东省城乡规划设计研究院 A kind of urban and rural planning data transfer device, system and computer readable storage medium
EP3575980A2 (en) * 2018-05-29 2019-12-04 Accenture Global Solutions Limited Intelligent data quality
CN110765101A (en) * 2019-09-09 2020-02-07 湖南天云软件技术有限公司 Label generation method and device, computer readable storage medium and server

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101582079A (en) * 2009-06-23 2009-11-18 用友软件股份有限公司 Object query method and device
CN105389619A (en) * 2014-08-31 2016-03-09 通用电气公司 Methods and systems for improving connections within healthcare ecosystem
CN104537103A (en) * 2015-01-12 2015-04-22 用友医疗卫生信息***有限公司 Data processing method and device
CN107341264A (en) * 2017-07-19 2017-11-10 东北大学 A kind of electronic health record system and method for supporting custom entities
EP3575980A2 (en) * 2018-05-29 2019-12-04 Accenture Global Solutions Limited Intelligent data quality
CN109977162A (en) * 2019-04-10 2019-07-05 广东省城乡规划设计研究院 A kind of urban and rural planning data transfer device, system and computer readable storage medium
CN110765101A (en) * 2019-09-09 2020-02-07 湖南天云软件技术有限公司 Label generation method and device, computer readable storage medium and server

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114745296A (en) * 2020-12-23 2022-07-12 北京首信科技股份有限公司 Data reporting method and device
CN114745296B (en) * 2020-12-23 2023-08-15 北京首信科技股份有限公司 Data reporting method and device
CN113488182A (en) * 2021-05-25 2021-10-08 北京大学 Multi-source heterogeneous medical laboratory examination data processing method, device, equipment and medium
CN113190608A (en) * 2021-05-28 2021-07-30 北京红山信息科技研究院有限公司 Data standardized acquisition method, device, equipment and storage medium

Similar Documents

Publication Publication Date Title
US20200159749A1 (en) Syntactic tagging in a domain-specific context
CN107918600B (en) Report development system and method, storage medium and electronic equipment
CN108197132B (en) Graph database-based electric power asset portrait construction method and device
CN111949692A (en) DTO-based user-defined index configuration method, system, equipment and medium
CN109634941B (en) Medical data processing method and device, electronic equipment and storage medium
US20180025092A1 (en) Modular memoization, tracking and train-data management of feature extraction
CN107430613A (en) Knowledge-intensive data handling system
CN109637602B (en) Medical data storage and query method, device, storage medium and electronic equipment
CN111986792B (en) Medical institution scoring method, device, equipment and storage medium
JP2020501267A (en) Automatic knowledge-based feature extraction from electronic medical records
CN111627552B (en) Medical streaming data blood-edge relationship analysis and storage method and device
CN112445875B (en) Data association and verification method and device, electronic equipment and storage medium
CN113064897B (en) Method, device, equipment and storage medium for generating business index model
WO2019227711A1 (en) Method and apparatus for generating influenza prediction model, and computer-readable storage medium
CN112818048A (en) Hierarchical construction method and device of data warehouse, electronic equipment and storage medium
CN114461644A (en) Data acquisition method and device, electronic equipment and storage medium
CN115203435A (en) Entity relation generation method and data query method based on knowledge graph
CN111414410A (en) Data processing method, device, equipment and storage medium
CN109493928B (en) Patient data screening method, system, equipment and storage medium based on condition tree
CN111143394A (en) Knowledge data processing method, knowledge data processing device, knowledge data processing medium and electronic equipment
CN114579653A (en) Data set-based CDA document generation method and device and electronic equipment
CN111782738B (en) Method and device for constructing database table level blood relationship
CN111933301A (en) DRG grouper forming system, method and corresponding equipment, storage medium
CN114944210A (en) Data processing method and device, computer readable storage medium and electronic equipment
CN115458103B (en) Medical data processing method, medical data processing device, electronic equipment and readable storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20201117