A campus card self-service activation and information update system based on incremental data synchronization

Abstract

The present invention discloses a campus card self-service card activation and information update system based on incremental data synchronization, and belongs to the field of campus card management technology. The system uses the newly added or updated user data obtained based on the data update time as incremental data, and synchronizes the incremental data to the campus card system; pre-opens a new user account according to the newly added user data; on this basis, the system can also realize user card collection, information update module and card correction. The present invention adopts an incremental data synchronization method marked by the data update time, shortens the data synchronization time, improves the data synchronization efficiency, and thus improves the service efficiency of the self-service business. The present invention opens up the data synchronization between the school's authoritative data source business system and the campus card system, expands the service scope of the campus card self-service business, and provides more comprehensive and timely self-service for teachers and students on campus. It not only facilitates teachers and students, but also reduces the work of card service personnel and improves work efficiency.

Description

Technical Field

[0001] The present invention belongs to the technical field of campus card management, and more specifically, relates to a campus card self-service activation and information update system based on incremental data synchronization. Background Art

[0002] Campus cards are an important tool for teachers and students to identify themselves and spend money on campus. With the continuous development of informatization, teachers and students have also put forward higher requirements for the timeliness and convenience of campus card services. How to reduce the inconvenience caused to users by the limited number of manual service windows and service hours, provide teachers and students with all-weather, timely and convenient campus card self-service, and improve service efficiency and user experience is an important direction for the construction of university campus card systems and service systems.

[0003] At present, part of the campus card services of colleges and universities have realized online services and self-service, such as online recharge, reporting loss, transaction inquiry, etc. These online self-services have brought great convenience to users, but these cannot cover all campus card services. Some services involving linkage with other systems, such as card application for new teachers and students, change of personal identity information, extension of validity period, etc., have problems such as slow data synchronization and reliance on manual review and processing. With the development of information technology, users have higher requirements for the efficiency of information services, and the service time and location of manual service windows are fixed, and services can only be provided to users during working hours and fixed locations. When users need to handle these services on holidays or other non-working hours, they often need to wait, or cross most of the campus to handle the business. Users have a strong demand for more efficient and comprehensive campus card self-service. Summary of the invention

[0004] In view of the above defects or improvement needs of the prior art, the present invention provides a campus card self-service activation and information update system based on incremental data synchronization, which aims to solve the problems of low data synchronization efficiency and imperfect campus card self-service system in the prior art.

[0005] To achieve the above object, according to one aspect of the present invention, a campus card self-service activation and information update system based on incremental data synchronization is provided, comprising:

[0006] Data collection module, used to collect and input basic information of teachers and students according to business needs;

[0007] The data synchronization module is used to obtain the newly added or updated user data based on the data update time as incremental data, and synchronize the incremental data to the campus card system;

[0008] Automatic pre-account opening module, used to pre-open new user accounts based on newly added user data;

[0009] User card collection module, used to match campus card account information with new users and collect campus cards by themselves;

[0010] Information update module, used to synchronize updated user data to their campus card account information;

[0011] The card correction module automatically corrects the campus card information according to the updated information of the campus card system.

[0012] Furthermore, the user basic information and corresponding code tables collected by the data collection module come from the school's authoritative data source business systems and national standard code tables; among them, the school's authoritative data source business systems include the personnel system, the student basic information management system and the online service hall system.

[0013] Furthermore, the specific implementation process of the data synchronization module is as follows:

[0014] The personnel system, student basic management information system, and online service hall system push teacher and student user data information to the intermediate database of each business system according to the basic database sharing standard;

[0015] After cleaning and processing the data in the intermediate database of each business system according to the basic database standard, the data is stored in the basic database. The basic database synchronizes the changed data to the intermediate database of the campus card system and marks the push time.

[0016] The campus card system periodically obtains the latest user data from the intermediate database, checks each piece of user data in turn, and marks it as new user data or updated user data.

[0017] Furthermore, the incremental data is synchronized to the campus card system. The specific process is as follows:

[0018] For all data pushed by the basic database, first filter the data pushed after the last processing of the campus card system. For each filtered data record, if the data item is incomplete, do not process it; otherwise, check whether the campus card system already has the user's information. If so, mark the data record as updated data; otherwise, mark the data record as newly added data; after the synchronization is completed, record the latest data push time processed this time, which is used to filter the latest pushed data during the next synchronization.

[0019] Furthermore, the specific implementation process of the automatic pre-account opening module is as follows:

[0020] For the records marked as new users and unopened accounts in the campus card system intermediate database, each record is processed in a loop to check whether the user already exists in the campus card system user information table; if so, the record is marked as a user with an opened account; if not, the account is automatically pre-opened based on the user identity information and the campus card account opening rules; if the pre-opening is successful, the record is marked as a user with an opened account; if the pre-opening fails, the record is marked as a user with a failed pre-opening.

[0021] Furthermore, the specific implementation process of the information update module is as follows:

[0022] For the records in the campus card system intermediate library that are marked as updated users and have not been updated, each record is processed in turn in a loop, and each corresponding field of the user information in the intermediate library and the corresponding account information in the campus card system is compared. The fields in the campus card system intermediate library are used as the basis, and the corresponding account information fields in the campus card system are updated. After each record is updated, the user record in the intermediate library is marked as processed and updated.

[0023] Furthermore, the specific implementation process of the card correction module is as follows:

[0024] The campus card self-service terminal reads the campus card content and matches it with the account information in the campus card system, and displays the latest account information on the screen. After the user confirms that it is correct, the card correction program is triggered, and the card information is rewritten based on the account information in the campus card system to complete the card correction.

[0025] The present invention also provides a self-service campus card activation method based on incremental data synchronization, comprising:

[0026] S1. The personnel and student management departments input and review the basic information of new faculty and students;

[0027] S2. Push the newly added data to the intermediate database of each business system of the school;

[0028] S3. After cleaning the data in the business system intermediate database according to the basic database standard, store it in the basic database;

[0029] S4. The basic database synchronizes the changed data to the campus card system intermediate database and marks the push time;

[0030] S5. The campus card system processes incremental user data in the intermediate library of the campus card system regularly according to the data push time, and marks new users;

[0031] S6. The campus card system obtains the new user information from the intermediate database and automatically pre-opens an account for each new user according to the pre-opening rules of the campus card system;

[0032] S7. New users check their information and print their cards on the campus card self-service device.

[0033] The present invention also provides a campus card information update method based on incremental data synchronization, comprising:

[0034] S1. The user applies for information change in the personnel system, student basic information management system or online service hall system, and the information change data is generated after being reviewed;

[0035] S2. Each business system pushes the changed data increments to its own intermediate database;

[0036] S3. The data exchange platform synchronizes the change information of the intermediate database to the basic database;

[0037] S4. The basic database synchronizes the changed data to the campus card system intermediate database and marks the push time;

[0038] S5. The campus card system processes incremental user data in the intermediate library of the campus card system regularly according to the data push time, and marks the changed user data;

[0039] S6. The campus card system obtains the changed user information from the intermediate database and compares it with the current user information in the system. If the change conditions are met, the user information in the campus card system is changed. If not, no processing is performed;

[0040] S7. The user verifies the information and corrects the card on the campus card self-service device.

[0041] In general, compared with the prior art, the above technical solution conceived by the present invention can achieve the following beneficial effects.

[0042] (1) The present invention adopts an incremental data synchronization method marked by data update time, which shortens the data synchronization time and improves the data synchronization efficiency, thereby improving the self-service business service efficiency.

[0043] (2) The present invention opens up the data synchronization between the school's authoritative data source business system and the campus card system, expands the service scope of the campus card self-service business, and provides campus teachers and students with more comprehensive and timely self-service, which not only facilitates teachers and students, but also reduces the workload of card service personnel and improves work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 is a system structure diagram provided by an embodiment of the present invention;

[0045] Figure 2 is a diagram of a data synchronization architecture provided by an embodiment of the present invention;

[0046] Figure 3is a flow chart of incremental data synchronization of a campus card system provided by an embodiment of the present invention;

[0047] Figure 4 is a flowchart of automatic pre-account opening provided by an embodiment of the present invention;

[0048] Figure 5 This is a flow chart of a user collecting a card provided by an embodiment of the present invention;

[0049] Figure 6 This is a flowchart of a new employee self-service card opening provided by an embodiment of the present invention;

[0050] Figure 7 The present invention provides a flowchart of a self-service update of campus card information. DETAILED DESCRIPTION

[0051] In order to make the purpose, technical solutions and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention. In addition, the technical features involved in the various embodiments of the present invention described below can be combined with each other as long as they do not conflict with each other.

[0052] like Figure 1 As shown, a campus card self-service card activation and information update system based on incremental data synchronization includes:

[0053] The data collection module is used by different business systems to collect and enter basic information of teachers and students according to their business needs.

[0054] The data synchronization module is used to synchronize the user information collected by different business systems to the campus card system through a data synchronization tool and a series of data synchronization processes, so that the campus card system can obtain the newly added or updated user data.

[0055] Automatic pre-account opening module, used to pre-open accounts for new campus card users, and make preparations for new users to collect their cards by themselves;

[0056] User card collection module: users can read their ID number through the second-generation ID card on the self-service card collection device, or manually enter the ID number for identity recognition, match the campus card account information, and collect their first campus card by themselves.

[0057] The information update module synchronously updates the campus card account information of users whose basic information has changed.

[0058] Card correction module: the user places the campus card on the self-service device, and the self-service device automatically corrects the campus card information according to the system update information.

[0059] Furthermore, in the data collection module, the personnel system is responsible for entering and collecting the basic information of faculty and staff, including: personnel number, name, gender, certificate type code, certificate number, unit number, campus number, identity type code, ethnicity code, length of service, and photo; the student basic information management system is responsible for entering and collecting the basic information of students, including: student number, name, gender code, certificate type code, certificate number, department number, campus code, student identity type code, ethnicity code, date of entry, expected graduation time, and photo; the online service hall system is responsible for entering and collecting change information that has passed the process review, including: student delayed graduation information, including data: student number, name, and expected graduation time after delay.

[0060] The authoritative data sources for various code tables are: the personnel system is the authoritative data source for the department code table, campus code table, faculty and staff identity type code table, and certificate type code table; the student basic information management system is the authoritative data source for the student identity type code table; the gender code table, ethnicity code table, etc. use national standard code tables.

[0061] Each data source has a corresponding data reporting and review mechanism to ensure the accuracy of the data.

[0062] Furthermore, if Figure 2 As shown in the figure, the data synchronization module, personnel system, student basic management information system, and online service hall system, according to the basic database sharing standard, incrementally push the basic information and change information of faculty and staff, the basic information and change information of students, and the information of students' delayed graduation to the intermediate library of each business system. The data exchange platform cleans and processes the data of the intermediate library of these business systems according to the basic database standard, stores it in the basic database, and pushes it to the intermediate library of the campus card system synchronously, marking the push time at the same time. The campus card system regularly obtains the latest change data from the intermediate library, and checks each change data in turn, detecting and marking which are new user data and which are updated user data.

[0063] Furthermore, if Figure 3 As shown in the figure, the incremental data synchronization process of the campus card system is as follows: the campus card system uses the push time of the basic database as the incremental update basis, and regularly processes new and changed data. For all data pushed by the basic database, first filter the data pushed after the system last processed, and for each filtered data record, if the data item is incomplete, do not process it; otherwise, check whether the campus card system already has the user's information. If so, mark the data record as updated data, otherwise, mark the data record as new data. After the synchronization is completed, record the latest data push time that has been processed this time, which is used to filter the latest pushed data during the next synchronization.

[0064] Furthermore, if Figure 4As shown, the automatic pre-account opening module processes each record in a loop for the records marked as newly added users and unopened in the intermediate library of the campus card system, and checks whether the user already exists in the user information table of the campus card system according to the student ID. If so, the record is marked as an account-opened user; if not, pre-account opening is performed, and the user's campus card account number, card type, identity type, validity period, default consumption limit, initial password, etc. are automatically set according to the user identity information and the account opening rules of the campus card. If the pre-account opening is successful, the record is marked as an account-opened user; if the pre-account opening fails, the record is marked as a user who failed to pre-account opening.

[0065] Furthermore, if Figure 5 As shown in the figure, in the user card collection module, new teachers and students click "Card Collection Service" and place the second-generation ID card on the self-service device for automatic identification of the ID number. If the user's ID type is not an ID card, the ID number can be manually entered on the self-service device screen. After the self-service device obtains the user's ID information, it searches the campus card system for the account status of the pre-opened campus card corresponding to the ID number. If a qualified campus card account can be found, the account information will be displayed on the self-service device screen. The displayed content includes: student number, name, secondary unit name, identity type, and validity period. After the user confirms that the information is correct, click "Confirm", and the self-service device will enter the card printing program. After the card printing is completed, the card will be issued from the card outlet, and the user can take the card away. If the user information is incorrect, it will be fed back to the basic information entry department to reconfirm the information. If the obtained ID number does not match the account information in the campus card system, the screen interface prompts that the account does not exist.

[0066] Furthermore, the information update module, for the records marked as updated users and not processed in the campus card system intermediate library, processes each record in turn in a loop, compares each corresponding field of the user information in the intermediate library and the corresponding account information in the campus card system based on the student ID, updates the corresponding account information field in the campus card system based on the field in the campus card intermediate library, and marks the intermediate library user record as processed and updated after each record is updated. Furthermore, for the student status change data of delayed graduation, it is necessary to detect whether the validity period after the extension is greater than the current campus card validity period. If so, update the validity period, if not, do not process it.

[0067] Furthermore, the card correction module, take the campus card to the campus card self-service terminal, put the card in the card reading area, click "card correction", the self-service device reads the card content, and matches the account information in the campus card system, and displays the latest account information on the screen. After the user confirms that it is correct, the card correction program can be triggered, and the account information in the campus card system is used as the basis to rewrite the card information and complete the card correction. If the information is incorrect, it will be fed back to the basic information entry department to reconfirm the information.

[0068] like Figure 6 As shown, a self-service campus card activation method based on incremental data synchronization includes:

[0069] (1) The Human Resources / Student Management Department enters and reviews the basic information of new faculty / students, including: personnel number, name, gender, identity type, certificate type, certificate number, secondary unit, length of service / expected graduation date, photo, etc.;

[0070] (2) The personnel / student management system pushes the newly added basic data of teachers and students to the intermediate database of their respective business systems;

[0071] (3) The data exchange platform synchronizes the newly added user information from the intermediate database of each business system to the basic database according to the data standards of the basic database, and pushes it to the intermediate database of the campus card system according to the data standards required by the campus card system, and marks the data push time;

[0072] (4) The campus card system processes incremental user data in the campus card system regularly based on the data push time and marks new users;

[0073] (5) The campus card system obtains the identity information of new users from the intermediate database, and automatically pre-opens an account for each new user according to the pre-opening rules of the campus card system, setting the user's campus card account number, card type, validity period, default spending limit, initial password, etc.

[0074] (6) New users click “Get Card Service” on the campus card self-service device and place their ID card on the card reader area of ​​the self-service device, or manually enter their ID number;

[0075] (7) The campus card self-service device obtains the ID number, matches the account information pre-opened in the system, and displays it on the self-service device screen. The user verifies his or her identity, including name, secondary unit, photo, etc. If the information is correct, click Confirm to open the card and print; if the information is incorrect, it will be fed back to the data initial entry department for information confirmation or modification.

[0076] like Figure 7 As shown, a campus card information updating method based on incremental data synchronization includes:

[0077] (1) The user applies for information change in the personnel system, student basic information management system or online service hall system, and the information change data is generated after being reviewed;

[0078] (2) Each business system pushes the changed data increments to its own intermediate repository;

[0079] (3) The data exchange platform synchronizes the change information of the intermediate database to the basic database, and pushes it to the intermediate database of the campus card system according to the data standards required by the campus card system, and marks the data push time;

[0080] (4) The campus card system processes incremental user data in the campus card system regularly according to the data push time and marks the changed user data;

[0081] (5) The campus card system obtains the changed user information from the intermediate database and compares it with the current user information in the system. If the change conditions are met, the user information in the campus card system is changed; if not, no action is taken;

[0082] (6) The user reads the campus card on the self-service device and clicks “Card Calibration”;

[0083] (7) The device reads the card information and matches it with the user information in the campus card system, and displays the account information on the screen of the self-service device. The user checks the system information changes. If the changes are correct, click Confirm to correct the card. If the information is incorrect, feedback is sent to the data change management department for information modification.

[0084] It will be easily understood by those skilled in the art that the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

Claims

1. A campus card self-service activation and information update system based on incremental data synchronization, characterized in that: include: Data collection module, used to collect and input basic information of teachers and students according to business needs; The data synchronization module is used to obtain the newly added or updated user data based on the data update time as incremental data, and synchronize the incremental data to the campus card system; Automatic pre-account opening module, used to pre-open new user accounts based on newly added user data; User card collection module, used to match campus card account information with new users and collect campus cards by themselves; Information update module, used to synchronize updated user data to their campus card account information; The card correction module automatically corrects campus card information according to the updated information of the campus card system; The basic user information and corresponding code tables collected by the data collection module come from the school's authoritative data source business systems and national standard code tables; among them, the school's authoritative data source business systems include the personnel system, the student basic information management system, and the online service hall system; The specific implementation process of the data synchronization module is as follows: the personnel system, student basic management information system, and online service hall system push the teacher and student user data information to the intermediate library of each business system according to the basic database sharing standard; the data of the intermediate library of each business system is cleaned and processed according to the basic database standard and stored in the basic database, and the basic database synchronizes the changed data to the intermediate library of the campus card system and marks the push time; the campus card system obtains the latest user data from the intermediate library at regular intervals, checks each user data in turn, and marks it as new user data or updated user data; Synchronize incremental data to the campus card system. The specific process is as follows: For all data pushed by the basic database, first filter the data pushed after the last processing of the campus card system. For each filtered data record, if the data item is incomplete, do not process it; otherwise, check whether the campus card system already has the user's information. If so, mark the data record as updated data; otherwise, mark the data record as newly added data; After the synchronization is completed, the latest data push time processed this time is recorded for filtering the latest pushed data during the next synchronization.

2. According to claim 1, a campus card self-service activation and information update system based on incremental data synchronization is characterized in that: The specific implementation process of the automatic pre-account opening module is as follows: For the records marked as new users and unopened accounts in the campus card system intermediate database, process each record in a loop to check whether the user already exists in the campus card system user information table; If it already exists, the record will be marked as a user who has opened an account; if it does not exist, the account will be automatically pre-opened according to the user's identity information and the account opening rules of the campus card; If the pre-account opening is successful, the record will be marked as an account opened user; If the pre-account opening fails, the record will be marked as a user who failed to open an account.

3. According to claim 1, a campus card self-service activation and information update system based on incremental data synchronization is characterized in that: The specific implementation process of the information update module is as follows: For the records in the campus card system intermediate library that are marked as updated users and have not been updated, each record is processed in turn in a loop, and each corresponding field of the user information in the intermediate library and the corresponding account information in the campus card system is compared. The fields in the campus card system intermediate library are used as the basis, and the corresponding account information fields in the campus card system are updated. After each record is updated, the user record in the intermediate library is marked as processed and updated.

4. According to claim 1, a campus card self-service activation and information update system based on incremental data synchronization is characterized in that: The specific implementation process of the card correction module is as follows: The campus card self-service terminal reads the campus card content and matches it with the account information in the campus card system, and displays the latest account information on the screen. After the user confirms that it is correct, the card correction program is triggered, and the card information is rewritten based on the account information in the campus card system to complete the card correction.

5. A self-service campus card activation method based on incremental data synchronization, characterized in that: The campus card self-service activation and information update system based on incremental data synchronization as described in claim 1 comprises: S1. The personnel and student management departments input and review the basic information of new faculty and students; S2. Push the newly added data to the intermediate database of each business system of the school; S3. After cleaning the data in the business system intermediate database according to the basic database standard, store it in the basic database; S4. The basic database synchronizes the changed data to the campus card system intermediate database and marks the push time; S5. The campus card system processes incremental user data in the intermediate library of the campus card system regularly according to the data push time, marking new users; S6. The campus card system obtains the new user information from the intermediate database and automatically pre-opens an account for each new user according to the pre-opening rules of the campus card system; S7. New users check their information and print their cards on the campus card self-service device.

6. A campus card information updating method based on incremental data synchronization, characterized in that: The campus card self-service activation and information update system based on incremental data synchronization as described in claim 1 comprises: S1. The user applies for information change in the personnel system, student basic information management system or online service hall system, and the information change data is generated after being reviewed; S2. Each business system pushes the changed data increments to its own intermediate repository; S3. The data exchange platform synchronizes the change information of the intermediate database to the basic database; S4. The basic database synchronizes the changed data to the campus card system intermediate database and marks the push time; S5. The campus card system processes incremental user data in the intermediate library of the campus card system regularly according to the data push time, and marks the changed user data; S6. The campus card system obtains the changed user information from the intermediate database and compares it with the current user information in the system. If the change conditions are met, the user information in the campus card system is changed. If not, no processing is performed; S7. The user verifies the information and corrects the card on the campus card self-service device.

Images