CN110780971A - Method and system for realizing visual medical data mapping and converting tool - Google Patents
Method and system for realizing visual medical data mapping and converting tool Download PDFInfo
- Publication number
- CN110780971A CN110780971A CN201911074311.1A CN201911074311A CN110780971A CN 110780971 A CN110780971 A CN 110780971A CN 201911074311 A CN201911074311 A CN 201911074311A CN 110780971 A CN110780971 A CN 110780971A
- Authority
- CN
- China
- Prior art keywords
- data
- conversion
- mapping
- tool
- interface
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
Abstract
The invention discloses a method and a system for realizing a visual medical data mapping and converting tool, which belong to the field of development of desktop client application, and solve the technical problem of how to improve and improve the working method and the working efficiency of a plurality of data governors on medical data mapping and format conversion, and adopt the technical scheme that: the method comprises the following specific steps: providing developer-oriented client software which takes a data source, format conversion and a data target as main visualization modules; providing selection modes of various languages and providing interfaces under the corresponding language modes for selection; the data mapping is completed through the connection operation, and the data format conversion is completed by matching an interface method after the connection; and a conversion processing interface of basic data types under various language modes is provided, and the customization of data structure conversion is supported. The system comprises a graphical data operation module, a user-defined interface module, a data conversion module, a data structure definition module and a code generation module.
Description
Technical Field
The invention relates to the field of development of desktop client applications, in particular to a method and a system for realizing a visual medical data mapping and converting tool.
Background
The technological revolution leading to the trend of big data is changing every business silently. Processing mass data in more and more fields becomes normal, particularly in the medical health industry, along with the national emphasis on national medical health and health industry, the medical health data management is more and more important and urgent, and the mapping and format conversion of the data in the medical data are inevitable as the basis of the data management, so that how to improve the mapping and format conversion of the data in the batch data processing is a problem in the prior art.
Currently, data mapping tools in the industry mainly include an internal deployment data mapping tool, an open source data mapping tool and a cloud-based data mapping tool. The internal deployment data mapping tool is generally used for a company enterprise with a large amount of data, has relatively close relation with software and hardware inside the company enterprise, needs team operation, has high cost and limited application range, and is used for example in Microsoft SQL, IBM InfoSphere and the like; open source data mapping tools are typically low cost ways that fit into smaller and less complex data sets, but generally require coding skills to start and run, such as CloverETL, Pentaho; the cloud-based data mapping tool has certain advantages in speed, expansibility and flexibility, can realize mapping, storage and access of all data from any source in any format, generally pays attention to data conversion results, does not provide a conversion process, and simultaneously needs to make more guarantees in the aspects of data privacy and data safety.
Today, when medical big data technology is rapidly developed, how to improve and improve the working method and working efficiency of a plurality of data governors on medical data mapping and format conversion is urgent and has important significance, so that how to realize medical data mapping and conversion tools to meet market demands and developer will is an urgent problem to be solved.
Patent document CN110069478A discloses a multisource heterogeneous data integration system for medical big data, which includes: the system comprises a data real-time acquisition module, a backup data storage cluster module and an incremental mapping management module; the data real-time acquisition module is responsible for acquiring and filtering real-time data and historical data on an original production system; the backup data storage cluster module is used for storing the data distributed after being processed by the data real-time acquisition module and providing the heterogeneous data as a data source of the incremental mapping management module; the incremental mapping management module is responsible for carrying out real-time integration on the provided data and carrying out corresponding subsequent processing. According to the technical scheme, the multi-source heterogeneous data is cleaned and converted by using a data middleware form, a standard data set is provided for upper-layer application, the collection efficiency of high-quality data is improved, but the working method and the working efficiency of a plurality of data governors on medical data mapping and format conversion cannot be improved and improved.
Disclosure of Invention
The technical task of the invention is to provide a method and a system for realizing a visual medical data mapping and converting tool, so as to solve the problem of how to improve and improve the working method and the working efficiency of a plurality of data governors on medical data mapping and format conversion.
The technical task of the invention is realized in the following way, the method is a visual medical data mapping and converting tool realization method, and the method is a rapid development tool for generating data mapping and format conversion codes aiming at medical data based on a visual operation desktop; the method comprises the following specific steps:
providing developer-oriented client software which takes a data source, format conversion and a data target as main visualization modules;
providing selection modes of various languages and providing interfaces under the corresponding language modes for selection;
the data mapping is completed through the connection operation, and the data format conversion is completed by matching an interface method after the connection;
providing a conversion processing interface of basic data types in various language modes, and supporting the customization of data structure conversion;
and providing a code output tool, and outputting the configured code with the data conversion process from the source data format to the target data format in a one-key mode.
Preferably, the language comprises JAVA, C language; the interfaces in the language mode include interfaces for basic data structures, interfaces for complex data structures, and interfaces for custom data structures.
Preferably, when the tool encounters a non-existent data type, custom expansion is performed in the tool; and customizing conversion logic for the data conversion format which cannot be matched, and generating a button and converting codes through codes after completing necessary operations of data mapping and format conversion.
A system of visualized medical data mapping and conversion tools, the system comprising,
the graphical data operation module is used for defining a visual interface of the tool;
the user-defined interface module is used for helping the tool to realize the expansion support of the conversion between the data types;
the data conversion module is used for providing a rich data type conversion method and providing calling in an interface mode;
the data structure definition module is used for providing a self-defined interface for a complex data structure used by a data source and a data target except for basic numerical values and data types of texts, and is used for creating, publishing and calling;
and the code generation module is used for forming batch conversion codes for developers to use.
Preferably, the visualization interface provides seven main functional elements, namely development language switching, variable name and type setting of a data source, variable name and type setting of a data target, a code editing area of the data source and the data target, connection line mapping of the data source and the data target, a user-defined interface button and a code export button.
Preferably, the data conversion module works as follows:
when the data mapping relation (line connection operation) between a group of data sources and a group of data targets is determined, the called conversion interface is judged according to the conversion of the two data types, and the interface codes are manually adjusted in the code editing area.
Preferably, the complex data structure includes sets, data and queues.
Preferably, the specific process of the code generation module is as follows:
after a group of data mapping is completed, the definitions of the data source and the data target in the group of mapping and the conversion logic generate corresponding codes according to the grammar template of the selected language type, and after all the mapping is completed, batch conversion codes are formed for developers to use.
Preferably, the tool installs software for the client, and the internal function is based on the packaging method and the self-contained data structure library and does not depend on the network environment.
The method and the system for realizing the visual medical data mapping and converting tool have the following advantages that:
the method can improve the problems of data mapping and data format conversion in batch data processing, and realize the rapid generation of data mapping and data format conversion codes so as to assist developers to do code development work of large-batch medical data mapping and conversion;
the development tool is positioned on a developer, a visual operation interface is provided for improving the development efficiency of the developer and avoiding repetitive labor, so that the developer can select the data formats of a source and a target through the interface, define data, use a connection mode for data mapping, automatically perform interface matching on connection contents by the tool, and call a corresponding interface method to realize the conversion of the data formats; the developer can independently operate after being installed on a personal computer, can customize a conversion rule package on the basis of software, can be used as a common interface for repeated use, and can also customize a data structure to meet the conversion requirement among different medical data types;
the development tool is installed at the client, is oriented to developers, does not need to depend on a network environment, occupies less resources, has high expandability, can effectively reduce repetitive coding and provides working efficiency;
the invention provides a visual development interface, encapsulates abundant data interfaces, enables the conversion of basic data types to be completed through connecting lines and simple editing, and reduces the complexity of code development;
the invention provides a code generation function, which can generate codes for batch conversion from source medical data to target medical data, and realizes data mapping and one-key generation of conversion codes based on the selected language mode model;
the method is used for mapping and converting the source data and the target data in the normalization and standardization process of the medical data; and the method is developer-oriented and can realize code development based on visual operation.
Drawings
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a flow chart diagram of a method for implementing a visual medical data mapping and conversion tool;
fig. 2 is a block diagram of a system for a visualized medical data mapping and conversion tool.
Detailed Description
The method and system for implementing the visualized medical data mapping and transforming tool of the present invention will be described in detail with reference to the drawings and specific embodiments.
Example 1:
as shown in fig. 1, the method for implementing the visualized medical data mapping and converting tool of the present invention is a rapid development tool for generating data mapping and format conversion codes for medical data based on a visible operation desktop; the method comprises the following specific steps:
s1, providing developer-oriented client software which takes a data source, format conversion and a data target as main visualization modules;
s2, providing selection modes of various languages and providing interfaces under corresponding language modes for selection;
s3, data mapping is completed through a connection operation, and data format conversion is completed by matching an interface method after connection;
s4, providing a conversion processing interface of basic data types in various language modes, and supporting the customization of data structure conversion;
and S5, providing a code output tool, and outputting the configured code with the data conversion process from the source data format to the target data format in a one-key mode.
The languages in the step S2 include JAVA and C languages;
the interface in the language mode in step S4 includes an interface of a basic data structure, an interface of a complex data structure, and an interface of a custom data structure.
When the tool in the step S5 meets the nonexistent data type, the tool is subjected to custom expansion; and customizing conversion logic for the data conversion format which cannot be matched, and generating a button and converting codes through codes after completing necessary operations of data mapping and format conversion.
Example 2:
the system of the visualized medical data mapping and conversion tool of the invention comprises,
the graphical data operation module is used for defining a visual interface of the tool; the visual interface provides seven main functional elements of development language switching, variable name and type setting of a data source, variable name type setting of a data target, a code editing area of the data source and the data target, connection line mapping of the data source and the data target, a user-defined interface button and a code export button.
The user-defined interface module is used for helping the tool to realize the expansion support of the conversion between the data types;
the data conversion module is used for providing a rich data type conversion method and providing calling in an interface mode; the working process is as follows:
when the data mapping relation (line connection operation) between a group of data sources and a group of data targets is determined, the called conversion interface is judged according to the conversion of the two data types, and the interface codes are manually adjusted in the code editing area.
The data structure definition module is used for providing a self-defined interface for a complex data structure used by a data source and a data target except for basic numerical values and data types of texts, and is used for creating, publishing and calling; wherein the complex data structure includes sets, data, and queues.
The code generation module is used for forming batch conversion codes for developers to use; the specific process is as follows:
after a group of data mapping is completed, the definitions of the data source and the data target in the group of mapping and the conversion logic generate corresponding codes according to the grammar template of the selected language type, and after all the mapping is completed, batch conversion codes are formed for developers to use.
The tool is used for installing software for a client, and the internal function is based on an encapsulation method and a self-contained data structure library and does not depend on a network environment.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (9)
1. A method for realizing a visual medical data mapping and converting tool is characterized in that the method is a rapid development tool for generating data mapping and format conversion codes aiming at medical data based on a visual operation desktop; the method comprises the following specific steps:
providing developer-oriented client software which takes a data source, format conversion and a data target as main visualization modules;
providing selection modes of various languages and providing interfaces under the corresponding language modes for selection;
the data mapping is completed through the connection operation, and the data format conversion is completed by matching an interface method after the connection;
providing a conversion processing interface of basic data types in various language modes, and supporting the customization of data structure conversion;
and providing a code output tool, and outputting the configured code with the data conversion process from the source data format to the target data format in a one-key mode.
2. The method for implementing the visualized medical data mapping and conversion tool according to claim 1, wherein said language comprises JAVA, C language; the interfaces in the language mode include interfaces for basic data structures, interfaces for complex data structures, and interfaces for custom data structures.
3. The method for implementing the visualized medical data mapping and conversion tool according to claim 1 or 2, wherein the tool is customized and expanded in the tool when encountering a non-existent data type; and customizing conversion logic for the data conversion format which cannot be matched, and generating a button and converting codes through codes after completing necessary operations of data mapping and format conversion.
4. A system of visualized medical data mapping and conversion tool is characterized in that the system comprises,
the graphical data operation module is used for defining a visual interface of the tool;
the user-defined interface module is used for helping the tool to realize the expansion support of the conversion between the data types;
the data conversion module is used for providing a rich data type conversion method and providing calling in an interface mode;
the data structure definition module is used for providing a self-defined interface for a complex data structure used by a data source and a data target except for basic numerical values and data types of texts, and is used for creating, publishing and calling;
and the code generation module is used for forming batch conversion codes for developers to use.
5. The system of visual medical data mapping and conversion tools according to claim 4, wherein the visual interface provides seven main functional elements of development language switching, variable name and type setting of data source, variable name type setting of data target, code editing area of data source and data target, connection line mapping of data source and data target, custom interface button and code export button.
6. The system of visualized medical data mapping and conversion tools of claim 4, wherein said data conversion module operates as follows:
and when the data mapping relation between a group of data sources and a group of data targets is determined, judging the called conversion interface according to the conversion of the two data types, and manually adjusting the interface codes in the code editing area.
7. The system of visualized medical data mapping, conversion tools of claim 4 wherein said complex data structure comprises sets, data and queues.
8. The system of visualized medical data mapping and conversion tools of claim 4, wherein said code generation module comprises the following specific procedures:
after a group of data mapping is completed, the definitions of the data source and the data target in the group of mapping and the conversion logic generate corresponding codes according to the grammar template of the selected language type, and after all the mapping is completed, batch conversion codes are formed for developers to use.
9. The system of visual medical data mapping and transformation tools according to claim 4, 5, 6, 7 or 8, wherein the tools are client installation software, and the internal functions are based on encapsulation methods and self-contained data structure libraries, independent of network environment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911074311.1A CN110780971A (en) | 2019-11-06 | 2019-11-06 | Method and system for realizing visual medical data mapping and converting tool |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911074311.1A CN110780971A (en) | 2019-11-06 | 2019-11-06 | Method and system for realizing visual medical data mapping and converting tool |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110780971A true CN110780971A (en) | 2020-02-11 |
Family
ID=69389455
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911074311.1A Pending CN110780971A (en) | 2019-11-06 | 2019-11-06 | Method and system for realizing visual medical data mapping and converting tool |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110780971A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111651155A (en) * | 2020-06-03 | 2020-09-11 | 北京智趣工场教育科技有限公司 | Programming learning operating system and external interactive system |
| CN112948479A (en) * | 2021-04-16 | 2021-06-11 | 深圳市今天国际物流技术股份有限公司 | Data structure interconversion method based on aviator |
| CN113645303B (en) * | 2021-08-11 | 2024-04-23 | 曙光信息产业(北京)有限公司 | Data transmission method, device, computer equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060005164A1 (en) * | 2004-07-01 | 2006-01-05 | Jetter Michael B | System and method for graphically illustrating external data source information in the form of a visual hierarchy in an electronic workspace |
| US20070239749A1 (en) * | 2006-03-30 | 2007-10-11 | International Business Machines Corporation | Automated interactive visual mapping utility and method for validation and storage of XML data |
| CN101714087A (en) * | 2009-12-15 | 2010-05-26 | 四川长虹电器股份有限公司 | System and method for mapping C language structure to relation database table |
| CN101957865A (en) * | 2010-10-27 | 2011-01-26 | 杭州新中大软件股份有限公司 | Data exchange and sharing technology among heterogeneous systems |
| CN104537103A (en) * | 2015-01-12 | 2015-04-22 | 用友医疗卫生信息系统有限公司 | Data processing method and device |
| CN105160004A (en) * | 2015-09-17 | 2015-12-16 | 西安未来国际信息股份有限公司 | B/S framework based data mapping method for heterogeneous system |
| CN109299168A (en) * | 2018-10-09 | 2019-02-01 | 湖北函数科技有限公司 | A kind of internet big data Visualized Analysis System |
| CN110007912A (en) * | 2019-03-05 | 2019-07-12 | 山东浪潮通软信息科技有限公司 | A kind of visual configuration realization system and method for data sharing interface |
-
2019
- 2019-11-06 CN CN201911074311.1A patent/CN110780971A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060005164A1 (en) * | 2004-07-01 | 2006-01-05 | Jetter Michael B | System and method for graphically illustrating external data source information in the form of a visual hierarchy in an electronic workspace |
| US20070239749A1 (en) * | 2006-03-30 | 2007-10-11 | International Business Machines Corporation | Automated interactive visual mapping utility and method for validation and storage of XML data |
| CN101714087A (en) * | 2009-12-15 | 2010-05-26 | 四川长虹电器股份有限公司 | System and method for mapping C language structure to relation database table |
| CN101957865A (en) * | 2010-10-27 | 2011-01-26 | 杭州新中大软件股份有限公司 | Data exchange and sharing technology among heterogeneous systems |
| CN104537103A (en) * | 2015-01-12 | 2015-04-22 | 用友医疗卫生信息系统有限公司 | Data processing method and device |
| CN105160004A (en) * | 2015-09-17 | 2015-12-16 | 西安未来国际信息股份有限公司 | B/S framework based data mapping method for heterogeneous system |
| CN109299168A (en) * | 2018-10-09 | 2019-02-01 | 湖北函数科技有限公司 | A kind of internet big data Visualized Analysis System |
| CN110007912A (en) * | 2019-03-05 | 2019-07-12 | 山东浪潮通软信息科技有限公司 | A kind of visual configuration realization system and method for data sharing interface |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111651155A (en) * | 2020-06-03 | 2020-09-11 | 北京智趣工场教育科技有限公司 | Programming learning operating system and external interactive system |
| CN112948479A (en) * | 2021-04-16 | 2021-06-11 | 深圳市今天国际物流技术股份有限公司 | Data structure interconversion method based on aviator |
| CN113645303B (en) * | 2021-08-11 | 2024-04-23 | 曙光信息产业(北京)有限公司 | Data transmission method, device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP2169547B1 (en) | Compilation model for programmable logic controllers (PLC). | |
| CN108681444A (en) | A kind of Soft- PLC configuration development approach based on XML technology | |
| CN110780971A (en) | Method and system for realizing visual medical data mapping and converting tool | |
| CN102693281B (en) | AUTOCAD-based method for generating auxiliary line in PDMS | |
| JP2002229783A (en) | Software construction support system, its method, and software construction support program | |
| CN112860256B (en) | Visual configuration system and method for Linux kernel equipment tree | |
| CN102779044B (en) | The dissection process system of expression formula and analyzing and processing method | |
| US7711740B2 (en) | Data access layer design and code generation | |
| CN1967574A (en) | Method and system to realize generating of integrated communications platform process | |
| Thramboulidis | IEC 61499: Back to the well proven practice of IEC 61131? | |
| CN113641700A (en) | Data processing method and device based on Spring boot frame | |
| CN110750553A (en) | Method for self-defining export of data in service management system | |
| CN101763072A (en) | Conversion method and device of numerical control machining code | |
| CN116339696A (en) | System and method for extensible automatic generation of cross-platform multi-language interface | |
| CN113467972A (en) | Communication interface construction method, communication interface construction device, computer equipment and storage medium | |
| US8112741B1 (en) | Ignoring output arguments of functions in programming environments | |
| US7343593B2 (en) | Method and device for porting software programs to a target platform by way of an electronic data processing system | |
| CN110471659A (en) | Multilingual method and system, human-machine interface configuration software end and equipment end | |
| CN104731597A (en) | Method for applying SQL statements to engineering software compiling platform | |
| CN110334001A (en) | A kind of method and apparatus that batch automatically generates echo test | |
| US11698823B2 (en) | Application interface implementation method in a host platform layer, device, and medium | |
| CN113238746A (en) | Hybrid programming control method, device, equipment and storage medium | |
| JPH04286029A (en) | Source program converter | |
| CN112685031A (en) | Analysis method and system for DBC file of fuel cell test system | |
| CN115774569B (en) | High-integration simulation tool modularized packaging method |
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 |