CN110489472B - Data exchange method and unit management system using same - Google Patents
Data exchange method and unit management system using same Download PDFInfo
- Publication number
- CN110489472B CN110489472B CN201910688898.9A CN201910688898A CN110489472B CN 110489472 B CN110489472 B CN 110489472B CN 201910688898 A CN201910688898 A CN 201910688898A CN 110489472 B CN110489472 B CN 110489472B
- Authority
- CN
- China
- Prior art keywords
- data
- service
- data exchange
- subsystem
- external system
- 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
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data exchange method and a unit management system using the same, wherein the method comprises the following steps: s1: acquiring data issued by external system service or capturing external system data at fixed time through timer setting; s2: storing the acquired data in a database for data exchange; s3: data adaptation, namely converting the acquired data into target service data; s4: and synchronizing the target business data increment to the business table. The data exchange method realizes the safety verification and the authority management of the service, increases the service copy table to meet the requirement in order to avoid the influence on the online service function, optimizes the system performance and improves the system concurrency capability, avoids the influence on the online service function and the increase of the deadlock probability of the service table caused by frequently inquiring the service table, and the system calls the external system through the data exchange subsystem without directly leading the service function system to directly operate the external system.
Description
Technical Field
The present invention relates to the field of unit management technologies, and in particular, to a data exchange method and a unit management system using the same.
Background
The unit management system is based on the crew members as a main body, arranges the crew members for the flight, creates a transparent and efficient operation environment by tracking flight operation delay or canceling key nodes and implementing a scheduling adjustment means, thereby reducing the phenomenon that passengers wait for a long time after closing doors of the flight, improving the operation efficiency of the crew scheduling, improving the normal rate of the flight, improving the quality of civil aviation service and increasing the satisfaction degree of the passengers. In the existing unit management system, the unit system directly exchanges data with an external system, and certain safety risks exist in the data.
Disclosure of Invention
The invention aims to provide a data exchange method, which realizes the safe data exchange between a unit management platform and an external system.
A further object of the present invention is to provide a crew management system using the switching method.
In order to solve the technical problems, the technical scheme of the invention is as follows:
a method of data exchange comprising the steps of:
s1: acquiring data issued by external system service or capturing external system data at fixed time through timer setting;
s2: storing the acquired data in a database for data exchange;
s3: data adaptation, namely converting the acquired data into target service data;
s4: and synchronizing the target business data increment to the business table.
Preferably, the step S1 obtains the data issued by the external system service, and adopts the security verification and the authority management for the service through the IIS.
Preferably, in step S1, the external system data is captured at a TIMER set by a TIMER, the TIMER is implemented by using TIMER, and different time intervals are configured for different capture tasks to trigger the capture tasks.
Preferably, the step S2 stores the obtained data in a database for data exchange, and further includes the step of adding the source of the data and time information of the data exchange to the record of each piece of data.
Preferably, the step S3 converts the acquired data into the target service data, and implements the target service data through type conversion and data mapping operations.
Preferably, after the step S3, it is further determined whether the target service data needs to be subjected to data integration, where the data integration is a process of associating a plurality of data records of different types together through some fields to form one record, and if so, the target service data is incrementally synchronized to the service table after the data integration is performed; if not, the target business data increment is directly synchronized to the business table.
Preferably, the incremental synchronization of the target service data to the service table in step S4 includes the following steps:
s4.1: newly adding a service copy table, wherein the service copy table has the same structure as the service table and has newly added time, modified time and date and time types as data types;
s4.2: the data after data adaptation or data integration is stored in a business copy table;
s4.3: synchronizing the data increment in the service copy table to the service table according to the modification time;
s4.4: the timestamp in the cache is updated.
A unit management system comprises a business function subsystem, a data exchange subsystem and an external system, wherein the external system comprises an OA system and a flight management system; the service subsystem realizes the unit service function and comprises a unit background subsystem, and the unit background subsystem is deployed on the server and automatically processes services; the data exchange subsystem realizes the data exchange method; and the external system exchanges data with the service function subsystem through the data exchange subsystem.
Preferably, in the data exchange between the external system and the service function subsystem through the data exchange subsystem, the external system is called through a WEBSERVICE, and the service function subsystem calls the service of the data exchange subsystem through the WEBSERVICE and calls the external system through the data exchange subsystem.
Preferably, the system further comprises a relational database and a columnar database, wherein the relational database stores data of the business table after data adaptation or data integration or incremental synchronization, and the columnar database stores data obtained in the step of storing the obtained data in the database for data exchange.
Compared with the prior art, the technical scheme of the invention has the beneficial effects that:
the data exchange method realizes the safety verification and the authority management of the service, increases the service copy table to meet the requirement in order to avoid the influence on the online service function, optimizes the system performance and improves the system concurrency capability, avoids the influence on the online service function and the increase of the deadlock probability of the service table caused by frequently inquiring the service table, and the system calls the external system through the data exchange subsystem without directly leading the service function system to directly operate the external system.
Drawings
Fig. 1 is a flow chart of a data exchange method according to the present invention.
Fig. 2 is a schematic diagram of a crew management system using the switching method of fig. 1.
Fig. 3 is a schematic diagram of a specific flow of acquiring data by a unit in the embodiment.
FIG. 4 is a flowchart illustrating a cross-system data synchronization process according to an embodiment.
Detailed Description
The drawings are for illustrative purposes only and are not to be construed as limiting the patent;
for the purpose of better illustrating the embodiments, certain features of the drawings may be omitted, enlarged or reduced, and do not represent the size of an actual product;
it will be understood by those skilled in the art that certain well-known structures in the drawings and descriptions thereof may be omitted.
The technical solution of the present invention is further described below with reference to the accompanying drawings and examples.
Example 1
The present embodiment provides a data exchange method, as shown in fig. 1, including the following steps:
s1: acquiring data issued by external system service or capturing external system data at fixed time through timer setting; a timer is arranged in the data exchange platform, and various qualification data of the pilot of the external system are captured every 6 hours;
s2: storing the acquired data in a database for data exchange; storing the captured data in an array database, and recording capture updating time and data source;
s3: data adaptation, namely converting the acquired data into target service data; data adaptation, a set background is provided with a timer, the qualification items of the qualification tables from different sources are processed every 5 minutes, the qualification items are associated with the pilot information table and combined into a data table;
s4: the target service data increment is synchronized to the service table, the unit management platform creates a table to store the data synchronized from different data source tables and processed, and the qualification data is used for completing related functions
In the specific implementation process, in step S1, data issued by the external system service is acquired, and the security verification and the authority management of the service are adopted by the IIS.
In step S1, the external system data is captured at regular time by setting a TIMER, which is implemented by using TIMER, and different time intervals are configured for different capture tasks to trigger the capture tasks.
The step S2 stores the acquired data in a database for data exchange, and further includes the step of adding the source of the data and the time information of the data exchange to the record of each piece of data.
In step S3, the acquired data is converted into target service data, and the target service data is converted by type conversion and data mapping operations.
Step S3, determining whether the target service data needs data integration, where the data integration is a process of associating multiple data records of different types together through some fields to form a record, and if so, synchronizing the target service data increment to the service table after performing data integration; if not, the target business data increment is directly synchronized to the business table.
In step S4, the incremental synchronization of the target service data to the service table includes the following steps:
s4.1: newly adding a service copy table, wherein the service copy table has the same structure as the service table and has newly added time, modified time and date and time types as data types;
s4.2: the data after data adaptation or data integration is stored in a business copy table;
s4.3: synchronizing the data increment in the service copy table to the service table according to the modification time;
s4.4: the timestamp in the cache is updated.
Example 2
The present embodiment provides a crew management system using the data exchange method provided in embodiment 1, as shown in fig. 2, including a service function subsystem, a data exchange subsystem, and an external system, where the external system includes an OA system and a flight management system; the service subsystem realizes the unit service function and comprises a unit background subsystem, and the unit background subsystem is deployed on the server and automatically processes services; the data exchange subsystem realizes the data exchange method; and the external system exchanges data with the service function subsystem through the data exchange subsystem.
The external system is used for calling the external system through WEBSERVICE in the process of exchanging data with the service function subsystem through the data exchange subsystem, and the service function subsystem calls the service of the data exchange subsystem through WEBSERVICE and calls the external system through the data exchange subsystem.
The system also comprises a relational database and a column database, wherein the relational database stores the data of the business table after data adaptation or data integration or incremental synchronization, and the column database stores the data obtained in the step of storing the data in the database for data exchange.
In a specific embodiment, as shown in fig. 3, the external system, i.e., the flight management system, has two tables, the pilot airport qualification and the pilot certificate qualification, the data exchange subsystem synchronizes the data task regularly, captures the data of the source table and transmits the data to the external system, and writes the data into the target table: the airdrome qualification of the pilot and various certificates of the pilot; the unit background acquires data of the target table, the data are sorted and converged, and the data table is stored; the machine set foreground acquires qualification data and the machine set system is typeset and used. When the cross-system data is synchronized, as shown in fig. 4, the flight management platform system and the unit management platform system exchange to the unit management platform system through the data exchange subsystem, the qualification class of the special airport and the qualification of various certificates in the flight management platform system are exchanged to the unit management platform system through the data exchange subsystem, and the unit background in the unit management platform system performs pilot qualification integration.
The same or similar reference numerals correspond to the same or similar parts;
the terms describing positional relationships in the drawings are for illustrative purposes only and are not to be construed as limiting the patent;
it should be understood that the above-described embodiments of the present invention are merely examples for clearly illustrating the present invention, and are not intended to limit the embodiments of the present invention. Other variations and modifications will be apparent to persons skilled in the art in light of the above description. And are neither required nor exhaustive of all embodiments. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the claims of the present invention.
Claims (9)
1. A method of data exchange, comprising the steps of:
s1: acquiring data issued by external system service or capturing external system data at fixed time through timer setting;
s2: storing the acquired data in a database for data exchange;
s3: data adaptation, namely converting the acquired data into target service data;
s4: synchronizing the target service data increment to a service table;
in step S4, the incremental synchronization of the target service data to the service table includes the following steps:
s4.1: newly adding a service copy table, wherein the service copy table has the same structure as the service table and has newly added time, modified time and date and time types as data types;
s4.2: the data after data adaptation or data integration is stored in a business copy table;
s4.3: synchronizing the data increment in the service copy table to the service table according to the modification time;
s4.4: the timestamp in the cache is updated.
2. The data exchange method according to claim 1, wherein the step S1 obtains the data issued by the external system service, and adopts the security authentication and authority management for the service through the IIS.
3. The data exchange method according to claim 1, wherein the capturing of the external system data is timed by a TIMER in step S1, the TIMER is implemented by using TIMER, and different time intervals are configured for different capturing tasks to trigger the capturing tasks.
4. The data exchange method according to claim 1, wherein the step S2 stores the acquired data in a database for data exchange, and further comprising the step of adding the source of the data and time information of the data exchange to the record of each piece of data.
5. The data exchange method according to claim 1, wherein the step S3 is implemented by converting the obtained data into the target service data through type conversion and data mapping operations.
6. The data exchange method according to claim 1, wherein after step S3, it is further determined whether the target service data needs to be subjected to data integration, where the data integration is a process of associating a plurality of data records of different types together through some fields to form one record, and if so, the target service data is incrementally synchronized to the service table after the data integration is performed; if not, the target business data increment is directly synchronized to the business table.
7. The unit management system is characterized by comprising a business function subsystem, a data exchange subsystem and an external system, wherein the external system comprises an OA system and a flight management system; the service subsystem realizes the unit service function and comprises a unit background subsystem, and the unit background subsystem is deployed on the server and automatically processes services; the data exchange subsystem implementing the data exchange method of any one of claims 1 to 6; and the external system exchanges data with the service function subsystem through the data exchange subsystem.
8. The crew management system according to claim 7, wherein the external system performs data exchange with the service function subsystem through the data exchange subsystem, and the invocation of the external system is performed through WEBSERVICE, and the service function subsystem invokes the service of the data exchange subsystem through WEBSERVICE and invokes the external system through the data exchange subsystem.
9. The crew management system according to claim 7 or 8, further comprising a relational database and a columnar database, wherein the relational database stores data of the business table after data adaptation or data integration or incremental synchronization, and the columnar database stores data obtained in the step of storing the obtained data in the database for data exchange.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910688898.9A CN110489472B (en) | 2019-07-29 | 2019-07-29 | Data exchange method and unit management system using same |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910688898.9A CN110489472B (en) | 2019-07-29 | 2019-07-29 | Data exchange method and unit management system using same |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110489472A CN110489472A (en) | 2019-11-22 |
| CN110489472B true CN110489472B (en) | 2021-08-24 |
Family
ID=68548394
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910688898.9A Active CN110489472B (en) | 2019-07-29 | 2019-07-29 | Data exchange method and unit management system using same |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110489472B (en) |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7680834B1 (en) * | 2004-06-08 | 2010-03-16 | Bakbone Software, Inc. | Method and system for no downtime resychronization for real-time, continuous data protection |
| CN100531055C (en) * | 2006-04-10 | 2009-08-19 | 华为技术有限公司 | Data synchronous system and its method |
| CN104361424B (en) * | 2014-10-11 | 2018-05-04 | 中国电子科技集团公司第十研究所 | Main data system integrated approach based on Enterprise Service Bus |
| CN104615759A (en) * | 2015-02-13 | 2015-05-13 | 厦门雅迅网络股份有限公司 | Data synchronization method for different business system platforms |
| CN105069142B (en) * | 2015-08-18 | 2019-04-05 | 山大地纬软件股份有限公司 | Data increment extraction conversion and dissemination system and method |
-
2019
- 2019-07-29 CN CN201910688898.9A patent/CN110489472B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN110489472A (en) | 2019-11-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103914526B (en) | A kind of interface method and device for SAP ERP systems and ORACLE ERP systems | |
| CN106649378B (en) | Data synchronization method and device | |
| CN109873873B (en) | Flight data issuing system, flight changing method and message processing method | |
| CN101436207B (en) | Data restoring and synchronizing method based on log snapshot | |
| CN107544984A (en) | A kind of method and apparatus of data processing | |
| CN102129478A (en) | Database synchronization method and system thereof | |
| CN102202073A (en) | Distributed system and data synchronization method thereof | |
| CN101854400A (en) | Database synchronization deployment and monitoring method and device | |
| CN103595807A (en) | Data synchronous updating method and device | |
| CN105094961A (en) | Task scheduling management system based on quartz frame and method thereof | |
| CN102508834B (en) | Message-based event application device and message-based event application method | |
| CN102043859A (en) | Data updating method and device | |
| CN103309977B (en) | Heterogeneous data resource integration method | |
| CN108810150B (en) | Data replication method of application-level disaster recovery backup system of cooperative office system | |
| CN102508833A (en) | Data monitoring device and data monitoring method | |
| CN111737355A (en) | MongoDB metadata management-based heterogeneous data source synchronization method and system | |
| CN109144785A (en) | Method and apparatus for Backup Data | |
| CN106055723A (en) | Database data synchronization device, system and method | |
| CN104301149A (en) | Multi-data-center permission management method and system | |
| CN105740248A (en) | Data synchronization method, apparatus and system | |
| CN104317957A (en) | Open platform and system for processing reports and report processing method | |
| CN104199955A (en) | Information management system and information management method | |
| CN110489472B (en) | Data exchange method and unit management system using same | |
| CN110099128B (en) | Authentication data synchronization method and device | |
| CN103365740A (en) | Data cold standby method and device |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Liang Hai Inventor after: Liu Deyong Inventor before: Liang Hai |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |