CN112506944B - Data standard conversion access method, device, equipment and medium between service systems - Google Patents
Data standard conversion access method, device, equipment and medium between service systems Download PDFInfo
- Publication number
- CN112506944B CN112506944B CN202011192920.XA CN202011192920A CN112506944B CN 112506944 B CN112506944 B CN 112506944B CN 202011192920 A CN202011192920 A CN 202011192920A CN 112506944 B CN112506944 B CN 112506944B
- Authority
- CN
- China
- Prior art keywords
- dictionary
- data source
- service system
- standard
- system data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/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
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
Abstract
The invention provides a data standard conversion access method, a device, equipment and a medium between service systems, wherein the method comprises the following steps: providing a definition interface of the standard dictionary for a user to define the standard dictionary; providing a configuration interface of a service system data source for a user to configure the service system data source for binding the standard dictionary; aggregating fields needing to be compared in data of a service system data source, binding the fields with a standard dictionary by a user, finishing comparison work, and storing obtained comparison contents in a database in a form of a mapping table; providing a configuration interface of the access conversion dictionary, and allowing a user to configure a mapping table, a standard dictionary and a service system data source to be converted when accessing; and performing standard conversion on the service system data source to be converted according to the configured mapping table and the standard dictionary to finish data acquisition. The invention can be used for many times through once configuration, and realizes the standard conversion of data among different service systems.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a medium between service systems in a system.
Background
Nowadays, with the continuous expansion of hospital medical systems, the informatization construction of a hospital usually consists of a plurality of business systems with different functions, but for different business systems, there is a set of data standards. When data interaction is generated before different business systems, a lot of data problems can be found, and when data analysis is needed, a unified standard of data cannot be made.
For example, when BI (Business Intelligence) data analysis is performed on a medical System such as a Hospital, and his (Hospital Information System) data and hrp (Hospital Resource Planning) data are simultaneously displayed due to different dictionaries of each department of the Hospital, the data on both sides are not unified in one department, the displayed data can not be in seamless connection, so that the data can be used only by performing related query again in the database after the data acquisition is completed, and simultaneously, the dictionary comparison function is also required to be performed in each business system of the hospital, because the correlated query is needed after each access, multiple correlated queries or multiple comparison are needed when accessing the data for multiple times, the needed data can not be converted at one time, at present, the association query is mostly carried out manually, so that the working efficiency is low and the association query is tedious.
Therefore, a unified standard is required, and data can be processed in a unified and standardized manner at one time.
Disclosure of Invention
The technical problem to be solved by the present invention is to provide a method, an apparatus, a device and a medium for data standard conversion access between service systems, which can be used for multiple times by one-time configuration, thereby realizing high efficiency and convenience of standard conversion of data between different service systems, and facilitating data interaction between service systems and data access operation of a data analysis system.
In a first aspect, the present invention provides a data standard conversion access method between service systems, which includes the following steps:
s1, providing a standard dictionary definition interface for a user to define a standard dictionary;
s2, providing a configuration interface of a service system data source, allowing a user to configure the service system data source for binding the standard dictionary, loading a data table in the service system data source for selection after the user selects the service system data source connection, and providing a corresponding field for the user to select after the user selects the data table;
s3, after the configuration of the service system data source is completed, aggregating the fields to be contrasted in the data of the service system data source as a source dictionary and loading the source dictionary on a dictionary contrast configuration interface, so that after a user binds the data of the standard dictionary and the service system data source, the contrast work is completed, and the obtained contrast content is stored in a database in the form of a mapping table;
s4, providing a configuration interface of the access conversion dictionary, and providing a mapping table, a standard dictionary and a service system data source to be converted when a user configures access;
and S5, performing standard conversion on the service system data source to be converted according to the configured mapping table and the standard dictionary, and completing data acquisition.
In a second aspect, the present invention provides a data standard conversion access device between service systems, including:
the standard dictionary definition module is used for providing a definition interface of a standard dictionary for a user to define the standard dictionary;
the data source configuration module is used for providing a configuration interface of a service system data source, so that a user configures the service system data source used for binding the standard dictionary, a data table in the service system data source is loaded for selection after the user selects the service system data source connection, and a corresponding field is provided for the user to select after the user selects the data table;
the comparison module is used for aggregating fields needing to be compared in the data of the service system data source as a source dictionary and loading the source dictionary on a dictionary comparison configuration interface after the service system data source configuration is completed, so that a user can complete comparison work after binding the data of the standard dictionary and the service system data source, obtain a mapping table and store the mapping table in a database;
the access conversion dictionary configuration module is used for providing an access conversion dictionary configuration interface for a user to configure an awaiting mapping table, a standard dictionary and a service system data source to be converted during access;
and the conversion module is used for performing standard conversion on the service system data source to be converted according to the configured mapping table and the standard dictionary to finish data acquisition.
In a third aspect, the present invention provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of the first aspect when executing the program.
In a fourth aspect, the invention provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the method of the first aspect.
The technical solutions provided in the embodiments of the present invention at least have the following technical effects or advantages: the method comprises the steps of establishing a standard dictionary before fetching, completing comparison work between service system data and standard dictionary data, obtaining a mapping table, configuring the standard dictionary and the mapping table to be used according to needs during fetching, completing standard conversion of data between different service systems, achieving data interaction between different service systems, facilitating data analysis system fetching operation, achieving conversion without performing association query again in a database after fetching is completed, simultaneously storing the mapping table obtained by configuration each time in the database for repeated calling, achieving one-time configuration and repeated use, saving workload generated by multiple association query or multiple comparison after each fetching, and greatly improving fetching efficiency.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
The invention will be further described with reference to the following examples with reference to the accompanying drawings.
FIG. 1 is a flow chart of a method according to one embodiment of the present invention;
FIG. 2 is a diagram illustrating a standard dictionary definition interface in accordance with an embodiment of the present invention;
FIG. 3 is a schematic diagram of a configuration interface of a data source of a business system according to an embodiment of the invention;
FIG. 4 is a diagram of a dictionary matching configuration interface in accordance with an embodiment of the present invention;
FIG. 5 is a diagram illustrating an exemplary access conversion dictionary configuration interface;
FIG. 6 is a diagram illustrating the results of a standard transformation according to an embodiment of the present invention;
FIG. 7 is a partial schematic view of a dictionary collation configuration interface in accordance with an embodiment of the present invention;
FIG. 8 is a schematic structural diagram of an apparatus according to a second embodiment of the present invention;
fig. 9 is a schematic structural diagram of an electronic device according to a third embodiment of the invention;
fig. 10 is a schematic structural diagram of a medium according to a fourth embodiment of the present invention.
Detailed Description
The embodiment of the application provides a data standard conversion access method, a data standard conversion access device, equipment and a medium among service systems, and the data standard conversion access method, the data standard conversion access device, the equipment and the medium can be used for multiple times through one-time configuration, so that the high efficiency and convenience of standard conversion of data among different service systems are realized, and data interaction among the service systems and data access operation of a data analysis system are facilitated.
The technical scheme in the embodiment of the application has the following general idea: the method comprises the steps of establishing a standard dictionary before fetching, completing comparison work between service system data and standard dictionary data, obtaining a mapping table, configuring the standard dictionary and the mapping table to be used according to needs during fetching, completing standard conversion of data between different service systems, achieving data interaction between different service systems, facilitating data analysis system fetching operation, achieving conversion without performing association query again in a database after fetching is completed, simultaneously storing the mapping table obtained by configuration each time in the database for repeated calling, achieving configuration once and using for many times, saving workload generated by association query or comparison for many times after fetching each time, and greatly improving fetching efficiency.
Example one
As shown in fig. 1, the present embodiment provides a data standard conversion access method between service systems, including the following steps:
s1, providing a standard dictionary definition interface for a user to define a standard dictionary;
the definition may be performed by adding a dictionary according to the requirement of the user, for example, for a hospital, a dictionary of a certain business system in the hospital may be used as a standard dictionary, or a completely new dictionary may be defined as a standard dictionary according to the requirement of the hospital, such as an outpatient standard department dictionary and an inpatient standard department dictionary in fig. 2. The standard dictionary is defined for later comparison with data from the service system data source.
S2, providing a configuration interface of a service system data source, allowing a user to configure the service system data source for binding the standard dictionary, loading a data table in the service system data source for selection after the user selects the service system data source connection, and providing a corresponding field for the user to select after the user selects the data table;
in configuring, as shown in FIG. 3, a reference dictionary, i.e., the standard dictionary defined in step S1, is first configured for the data source. And the service system of the data source is selected, for example, the HRP service system or the HIS service system, and the system of the data source is maintained in the dictionary of the data source. Then, a data source of the source data is selected, namely, the database which needs to be connected is maintained in the data source management of the project. After the data source connection is selected, the data table in the database is loaded according to the data source for selection. And selecting the fields after the data table is selected.
As a more preferred implementation manner of this embodiment, the time field, the encoding field, and the name field are provided for selection. The time field is used for screening partial data usage, and the time field is used for screening partial data usage; the code field and name field are used to determine whether data in the business system data source includes a code and name when compared, and the default name field is usually necessary to convert, which provides convenience for conversion.
S3, after the configuration of the service system data source is completed, aggregating the fields to be contrasted in the data of the service system data source as a source dictionary and loading the source dictionary on a dictionary contrast configuration interface, so that after a user binds the data of the standard dictionary and the service system data source, the contrast work is completed, and the obtained contrast content is stored in a database in the form of a mapping table;
for example, after the configuration of the service system data source is completed and confirmed, the interface shown in fig. 4 may be loaded, the fields to be compared in the service system data source may be aggregated to be used as the source dictionary and placed on the left side of the interface, the standard dictionary to be compared and selected by the user is placed on the right side of the interface, the user only needs to select the source data on the left side during the configuration, and the comparison may be completed by clicking and binding on the right side.
S4, providing a configuration interface of the access conversion dictionary, and providing a mapping table, a standard dictionary and a service system data source to be converted when a user configures access;
this step can be implemented on a data integration platform (the data integration platform is used in application scenarios such as various data migration and integration, and is provided with an access component capable of importing and exporting various data), as shown in fig. 5, a conversion dictionary during access is configured on an access conversion dictionary configuration interface provided by the data integration platform, a "database connection" is used to select a database where a mapping table is located, a "comparison type selection" is used to select a predefined standard dictionary, and a "data source" is used to select a service system data source to be converted.
In step S4, the access conversion dictionary configuration interface further includes configuration items of an encoding field and a name field, where the encoding field and the name field are used to determine whether data in the service system data source includes an encoding and a name during conversion. Typically, for hospital systems, the code field may be deselected because the default name field is usually necessarily converted.
And S5, performing standard conversion on the service system data source to be converted according to the configured mapping table and the standard dictionary, and completing data acquisition.
The standard conversion result is shown in fig. 6, where the left thick-line frame is the code and name fields before conversion, and the right thick-line frame is the code and name fields after conversion, it can be found that the codes in the two service systems are not consistent, and the conversion has been successfully performed, and the name fields in the figure are actually also the converted ones, but are consistent with the name fields before and after conversion.
As a more preferred implementation manner of this embodiment, in the method:
as shown in fig. 7, in step S3, the dictionary comparison configuration interface further provides a global check box and an effective month drop-down box, when the user does not check the global check box, the effective month drop-down box needs to select an effective time month, and after the user binds the standard dictionary and the data of the service system data source, the system obtains corresponding comparison content according to the global or effective time month;
as shown in fig. 5, in step S4, the access conversion dictionary configuration interface further includes a time field configuration item, which is used to filter out a mapping table corresponding to a time, so as to find the comparison content corresponding to the time;
in step S5, in the standard conversion, the mapping table is first queried for the comparison content in the time range corresponding to the time field, if the comparison content in the corresponding time range is not found, the global general comparison content is queried, and if the global general comparison content is not found, the conversion result is corresponding to "other".
Based on the same inventive concept, the application also provides a device corresponding to the method in the first embodiment, which is detailed in the second embodiment.
Example two
As shown in fig. 8, in this embodiment, a data standard conversion access device between service systems is provided, including:
the standard dictionary definition module is used for providing a definition interface of a standard dictionary for a user to define the standard dictionary; the definition may be performed by adding a dictionary according to the requirement of the user, for example, for a hospital, a dictionary of a certain business system in the hospital may be used as a standard dictionary, or a completely new dictionary may be defined as a standard dictionary according to the requirement of the hospital, such as an outpatient standard department dictionary and an inpatient standard department dictionary in fig. 3. The standard dictionary is defined for later comparison with data from the service system data source.
The data source configuration module is used for providing a configuration interface of a service system data source, so that a user configures the service system data source used for binding the standard dictionary, a data table in the service system data source is loaded for selection after the user selects the service system data source connection, and a corresponding field is provided for the user to select after the user selects the data table;
in configuring, as shown in FIG. 3, a reference dictionary, i.e., the standard dictionary defined in step S1, is first configured for the data source. And the service system of the data source is selected, for example, the HRP service system or the HIS service system, and the system of the data source is maintained in the dictionary of the data source. Then, a data source of the source data is selected, namely, the database which needs to be connected is maintained in the data source management of the project. After the data source connection is selected, the data table in the database is loaded according to the data source for selection. And selecting the fields after the data table is selected.
As a more preferred implementation manner of this embodiment, the time field, the encoding field, and the name field are provided for selection. The time field is used for screening partial data usage, and the time field is used for screening partial data usage; the code field and name field are used to determine whether data in the business system data source includes a code and name when compared, and the default name field is usually necessary to convert, which provides convenience for conversion.
The comparison module is used for aggregating fields needing to be compared in the data of the service system data source as a source dictionary and loading the source dictionary on a dictionary comparison configuration interface after the service system data source configuration is completed, so that a user can complete comparison work after binding the data of the standard dictionary and the service system data source, obtain a mapping table and store the mapping table in a database; for example, after the configuration of the service system data source is completed and confirmed, the interface shown in fig. 4 may be loaded, the fields to be compared in the service system data source may be aggregated to be used as the source dictionary and placed on the left side of the interface, the standard dictionary to be compared and selected by the user is placed on the right side of the interface, the user only needs to select the source data on the left side during the configuration, and the comparison may be completed by clicking and binding on the right side.
The access conversion dictionary configuration module is used for providing an access conversion dictionary configuration interface for a user to configure an awaiting mapping table, a standard dictionary and a service system data source to be converted during access; this module can be implemented on a data integration platform, as shown in fig. 5, a conversion dictionary during data fetching is configured on a data fetching conversion dictionary configuration interface provided by the data integration platform, where "database connection" is used to select a database where a mapping table is located, "comparison type selection" is used to select a predefined standard dictionary, and "data source" is used to select a service system data source to be converted.
And the conversion module is used for performing standard conversion on the service system data source to be converted according to the configured mapping table and the standard dictionary to finish data acquisition.
The standard conversion result is shown in fig. 6, where the left thick-line frame is the code and name fields before conversion, and the right thick-line frame is the code and name fields after conversion, it can be found that the codes in the two service systems are not consistent, and the conversion has been successfully performed, and the name fields in the figure are actually also the converted ones, but are consistent with the name fields before and after conversion.
As a more preferred implementation manner of this embodiment, in the apparatus:
as shown in fig. 7, the comparison module further provides a global check box and an effective month drop-down box on the dictionary comparison configuration interface, and when the user does not check the global check box, the effective month drop-down box needs to select an effective time month, so that after the user binds the standard dictionary and the data of the service system data source, the system obtains corresponding comparison content according to the global or effective time month;
as shown in fig. 5, the fetching conversion dictionary configuration module further provides a time field configuration item on the fetching conversion dictionary configuration interface, for screening out the comparison content corresponding to the time;
when the conversion module carries out standard conversion, firstly, the comparison content in the time range corresponding to the time field is inquired in the mapping table, if the comparison content in the corresponding time range is not found, the global general comparison content is inquired, and if the global general comparison content is not found, the conversion result is corresponding to other.
Since the apparatus described in the second embodiment of the present invention is an apparatus used for implementing the method of the first embodiment of the present invention, based on the method described in the first embodiment of the present invention, a person skilled in the art can understand the specific structure and the deformation of the apparatus, and thus the details are not described herein. All the devices adopted in the method of the first embodiment of the present invention belong to the protection scope of the present invention.
Based on the same inventive concept, the application provides an electronic device embodiment corresponding to the first embodiment, which is detailed in the third embodiment.
EXAMPLE III
The present embodiment provides an electronic device, as shown in fig. 9, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, any implementation manner of the first embodiment may be implemented.
Since the electronic device described in this embodiment is a device used for implementing the method in the first embodiment of the present application, based on the method described in the first embodiment of the present application, a specific implementation of the electronic device in this embodiment and various variations thereof can be understood by those skilled in the art, and therefore, how to implement the method in the first embodiment of the present application by the electronic device is not described in detail herein. The equipment used by those skilled in the art to implement the methods in the embodiments of the present application is within the scope of the present application.
Based on the same inventive concept, the application provides a storage medium corresponding to the fourth embodiment, which is described in detail in the fourth embodiment.
Example four
The present embodiment provides a computer-readable storage medium, as shown in fig. 10, on which a computer program is stored, and when the computer program is executed by a processor, any one of the first embodiment can be implemented.
The technical scheme provided in the embodiment of the application has at least the following technical effects or advantages: the method comprises the steps of establishing a standard dictionary before fetching, completing comparison work between service system data and standard dictionary data, obtaining a mapping table, configuring the standard dictionary and the mapping table to be used according to needs during fetching, completing standard conversion of data between different service systems, achieving data interaction between different service systems, facilitating data analysis system fetching operation, achieving conversion without performing association query again in a database after fetching is completed, simultaneously storing the mapping table obtained by configuration each time in the database for repeated calling, achieving one-time configuration and repeated use, saving workload generated by multiple association query or multiple comparison after each fetching, and greatly improving fetching efficiency.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
Although specific embodiments of the invention have been described above, it will be understood by those skilled in the art that the specific embodiments described are illustrative only and are not limiting upon the scope of the invention, and that equivalent modifications and variations can be made by those skilled in the art without departing from the spirit of the invention, which is to be limited only by the appended claims.
Claims (4)
1. A data standard conversion access method between service systems is applied to hospital service systems, and is characterized in that: the method comprises the following steps:
s1, providing a standard dictionary definition interface for a user to define a standard dictionary;
s2, providing a configuration interface of a service system data source, allowing a user to configure the service system data source for binding the standard dictionary, loading a data table in the service system data source for selection after the user selects the service system data source connection, and providing a corresponding field for the user to select after the user selects the data table;
the fields comprise a time field, an encoding field and a name field, and the time field is used for screening partial data use; the code field and the name field are used for determining whether data in the data source of the business system comprises codes and names when being compared;
s3, after the configuration of the service system data source is completed, aggregating the fields to be contrasted in the data of the service system data source as a source dictionary and loading the source dictionary on a dictionary contrast configuration interface, so that after a user binds the data of the standard dictionary and the service system data source, the contrast work is completed, and the obtained contrast content is stored in a database in the form of a mapping table;
the dictionary comparison configuration interface is also provided with a global check box and an effective month drop-down box, when the user does not check the global check box, the effective month drop-down box needs to select an effective time month, and after the user binds the standard dictionary and the data of the service system data source, the system can obtain corresponding comparison content according to the global or effective time month;
s4, providing a configuration interface of the access conversion dictionary, and providing a mapping table, a standard dictionary and a service system data source to be converted when a user configures access; a configuration item comprising an encoding field, a name field and a time field, wherein the encoding field and the name field are used for determining whether data in a business system data source comprises an encoding and a name when converting; the time field is used for screening out the contrast content of the corresponding time;
s5, standard conversion is carried out on the service system data source to be converted according to the configured mapping table and the standard dictionary, and access is completed;
in the standard conversion, firstly, the comparison content in the time range corresponding to the time field is inquired in the mapping table, if the comparison content in the corresponding time range is not found, the global general comparison content is inquired, and if the global general comparison content is not found, the conversion result is corresponding to other.
2. A data standard conversion access device between service systems is applied to hospital service systems, and is characterized in that: the method comprises the following steps:
the standard dictionary definition module is used for providing a definition interface of a standard dictionary for a user to define the standard dictionary;
the data source configuration module is used for providing a configuration interface of a service system data source, so that a user configures the service system data source used for binding the standard dictionary, a data table in the service system data source is loaded for selection after the user selects the service system data source connection, and a corresponding field is provided for the user to select after the user selects the data table; the fields comprise a time field, an encoding field and a name field, and the time field is used for screening partial data use; the code field and the name field are used for determining whether data in the data source of the business system comprises codes and names when being compared;
the comparison module is used for aggregating fields needing to be compared in the data of the service system data source as a source dictionary and loading the source dictionary on a dictionary comparison configuration interface after the service system data source configuration is completed, so that a user can complete comparison work after binding the data of the standard dictionary and the service system data source, obtain a mapping table and store the mapping table in a database; the comparison module also provides a global check box and an effective month drop-down box on the dictionary comparison configuration interface, when the user does not check the global check box, the effective month drop-down box needs to select an effective time month, and then after the user binds the standard dictionary and the data of the service system data source, the system can obtain corresponding comparison content according to the global or effective time month;
the access conversion dictionary configuration module is used for providing an access conversion dictionary configuration interface for a user to configure an awaiting mapping table, a standard dictionary and a service system data source to be converted during access; configuration items of an encoding field and a name field are further provided in the access conversion dictionary configuration interface, and the encoding field and the name field are used for determining whether data in a business system data source comprises encoding and names during conversion; time field configuration items are also provided on the access conversion dictionary configuration interface and are used for screening out comparison contents corresponding to time;
the conversion module is used for carrying out standard conversion on the service system data source to be converted according to the configured mapping table and the standard dictionary to finish data acquisition; when standard conversion is carried out, firstly, the comparison content in the time range corresponding to the time field is inquired in the mapping table, if the comparison content in the corresponding time range is not found, the global general comparison content is inquired, and if the global general comparison content is not found, the conversion result is corresponding to other.
3. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of claim 1 when executing the program.
4. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method of claim 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011192920.XA CN112506944B (en) | 2020-10-30 | 2020-10-30 | Data standard conversion access method, device, equipment and medium between service systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011192920.XA CN112506944B (en) | 2020-10-30 | 2020-10-30 | Data standard conversion access method, device, equipment and medium between service systems |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112506944A CN112506944A (en) | 2021-03-16 |
| CN112506944B true CN112506944B (en) | 2022-08-05 |
Family
ID=74954595
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011192920.XA Active CN112506944B (en) | 2020-10-30 | 2020-10-30 | Data standard conversion access method, device, equipment and medium between service systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112506944B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108121739A (en) * | 2016-11-30 | 2018-06-05 | 株式会社日立制作所 | Method of data capture and data gathering system |
| CN110569298A (en) * | 2019-09-12 | 2019-12-13 | 成都中科大旗软件股份有限公司 | data docking and visualization method and system |
| CN110968653A (en) * | 2019-12-06 | 2020-04-07 | 山东浪潮通软信息科技有限公司 | Tree-shaped data dictionary maintenance system and method |
| CN111290813A (en) * | 2020-01-21 | 2020-06-16 | 福建省农村信用社联合社 | Software interface field data standardization method, device, equipment and medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090037163A1 (en) * | 2007-07-30 | 2009-02-05 | Hong Wei Kong | Fast and Flexible Communication System Simulation |
-
2020
- 2020-10-30 CN CN202011192920.XA patent/CN112506944B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108121739A (en) * | 2016-11-30 | 2018-06-05 | 株式会社日立制作所 | Method of data capture and data gathering system |
| CN110569298A (en) * | 2019-09-12 | 2019-12-13 | 成都中科大旗软件股份有限公司 | data docking and visualization method and system |
| CN110968653A (en) * | 2019-12-06 | 2020-04-07 | 山东浪潮通软信息科技有限公司 | Tree-shaped data dictionary maintenance system and method |
| CN111290813A (en) * | 2020-01-21 | 2020-06-16 | 福建省农村信用社联合社 | Software interface field data standardization method, device, equipment and medium |
Non-Patent Citations (1)
| Title |
|---|
| 《医院信息系统基本功能规范---医疗保险接口功能规范》;小风哥哥;《https://blog.csdn.net/anthony634/article/details/80550012》;20180602;第1-30页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112506944A (en) | 2021-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110704398B (en) | Database migration method and device from MySQL to Oracle and computer equipment | |
| US9116899B2 (en) | Managing changes to one or more files via linked mapping records | |
| CN106557307B (en) | Service data processing method and system | |
| US8839197B2 (en) | Automated analysis of composite applications | |
| US20140156849A1 (en) | Map-reduce workflow processing apparatus and method, and storage media storing the same | |
| CN110704476A (en) | Data processing method, device, equipment and storage medium | |
| CN111126019A (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN111158800B (en) | Method and device for constructing task DAG based on mapping relation | |
| US20160217203A1 (en) | Systems, Methods, and Apparatuses for Creating, Linking and Discovering Business Navigation Maps for Analyzing Data | |
| CN111061733B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN113190576A (en) | Data processing method and device, computer equipment and readable storage medium | |
| CN108897858A (en) | The appraisal procedure and device, electronic equipment of distributed type assemblies index fragment | |
| CN112506944B (en) | Data standard conversion access method, device, equipment and medium between service systems | |
| CN100507842C (en) | Method, device for controlling relation between control piece on interface and control piece display system | |
| CN115857929A (en) | Resource data processing method and device, computer equipment and storage medium | |
| CN116384295A (en) | Top file generation method and device, computer equipment and storage medium | |
| CN115392501A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN109325069A (en) | Method for processing business, device and the network equipment | |
| CN107766306B (en) | Data display method and equipment | |
| CN106570035B (en) | Database authorization method and device | |
| CN114115864A (en) | Interface generation method and device and electronic equipment | |
| CN109344145B (en) | Data standard specification-based data cleaning method, device and system | |
| CN113377652A (en) | Test data generation method and device | |
| US20140244539A1 (en) | Business process management, configuration and execution | |
| KR101638048B1 (en) | Sql query processing method using mapreduce |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |