Application method and system based on education experience data

Abstract

The invention relates to the technical field of big data information processing, in particular to an application method and system based on education experience data, and the method comprises the following steps: data resource carding, education experience data model core library table design, data connection, data aggregation, data governance, data modeling and service development. The method has the beneficial effects that the information data of each commissioning bureau in the government is fully utilized, the'information isolated island 'of the data among the commissioning bureau of the government is broken, and the sharing and fusion of the data are realized; comprehensive and systematic sorting of education experience data is realized, a set of data model and data service is provided, and data support is provided for application of education data; the method is high in practicability, wide in application range and easy to popularize, widens thinking for internal personnel of the government to deeply apply education data, and promotes development of government affair big data environment and industry.

Description

Technical Field

[0001] The present invention relates to the technical field of big data information processing, and specifically to an application method and system based on educational experience data. Background Art

[0002] In the field of education, with the development of educational informatization and the implementation of online distance education, various types of data in the education field have grown rapidly. There has been a sharp increase in various academic qualifications, degrees, continuing education, and online education information. Although the ability and level of educational information management have been continuously improved, the educational data information related to individual citizens has not been effectively integrated, and it has not been considered and planned from the perspective of the application of ordinary people, resulting in the repeated filling of academic information, student status information, certification information, award information, etc. under various government affairs applications by ordinary people. Summary of the Invention

[0003] The purpose of the present invention is to provide an application method and system based on educational experience data to solve the problems raised in the above background art.

[0004] To achieve the above purpose, the present invention provides the following technical solution: An application method based on educational experience data, including the following steps:

[0005] Data resource sorting: Obtain the educational experience data catalog from education departments at the national, provincial, and municipal levels, clarify the data source departments, field contents, and demand differences, and adjust the data service plan according to the actual situation of the project;

[0006] Design of the core library tables of the educational experience data model: Construct core tables and business tables. The core tables contain core fields such as citizen identity number, name, student status number, highest academic degree, and degree certificate number, and the business tables record information such as learning stage, learning time, learning institution, and major studied;

[0007] Data docking: Search for data resources through the sharing platform, identify and analyze the resource quality, confirm the resource correspondence relationship, sort out the list of data requirements for unshared or missing / ambiguous data, and solicit opinions from the business department. Finally, determine the list of data requirements and the source departments;

[0008] Data aggregation: Promote the sharing of resources among various departments, apply for data through the sharing platform and agree on an update mechanism, collect the data into the original library and perform periodic backups;

[0009] Data governance: Formulate governance rules for integrity, standardization, consistency, and normalization, write governance tasks, store the problematic data in the problem library, and write the qualified data into the special library;

[0010] Data modeling: Taking the citizen identity number and student status number as the core information, integrating multi-level educational data resources to form an educational experience special service model, and providing one-stop academic information integration services;

[0011] Service Development: Develop service interfaces based on standard data, provide talent declaration certification and professional title evaluation certification services, and register and publish them to the data sharing platform.

[0012] Preferably, in the data resource sorting step, the data catalog includes but is not limited to the following:

[0013] Preschool education information: name, citizen identification number, school name, enrollment time;

[0014] Academic record management information of ordinary primary and secondary schools: student ID number, enrollment year and month, student category code;

[0015] Academic record change information of ordinary primary and secondary schools: change category, change date, change reason;

[0016] Graduation information of secondary vocational schools: graduation certificate number, issuance date, whether received;

[0017] Degree and academic record information of higher education institutions: degree code, degree-awarding unit name, major code for obtaining a degree;

[0018] Study abroad experience information: study abroad country / region code, overseas school number, major of study abroad.

[0019] Preferably, in the design step of the core database table of the education experience data model, the sources of the core table fields include:

[0020] Citizen identification number, name: from the population core information table in the population basic database;

[0021] Student ID number: from the municipal education department;

[0022] Highest academic record, highest academic record graduation certificate number, degree certificate number, highest academic record graduation time: from the degree / academic record information of higher education institutions, graduation information of secondary vocational schools, graduation information of ordinary primary and secondary schools, and study abroad experience information tables;

[0023] First academic record, first academic record graduation time: from the same sources as above.

[0024] Preferably, in the data docking step, the resources searched on the sharing platform are processed as follows:

[0025] Identify and analyze the quality of resources, and exclude resources with the same name or ambiguous definitions;

[0026] For the same resources shared at different levels of provinces, cities, and counties, communicate with the customer to confirm the priority;

[0027] For resources with missing or ambiguous information items, organize a problem list and seek opinions from the business department;

[0028] Sort out the list of unshared data requirements and include it in the scope of the next round of soliciting opinions.

[0029] Preferably, in the service development step, the following application services are provided:

[0030] Talent declaration and certification service: Integrate information from the basic databases of population and legal persons and data from education departments at multiple levels to provide talent with integrated education experience information services;

[0031] Professional title evaluation and certification service: Provide citizens' education experience and highest academic degree certificate information, simplify the application process for professional title evaluation, and support comprehensive review by evaluation institutions.

[0032] A system for an application method based on education experience data includes:

[0033] A data resource sorting module, used to obtain data directories related to education experience from education departments at the national, provincial, and municipal levels, and adjust the data service plan according to customer needs to ensure that the data resources meet the actual needs of the project;

[0034] An education experience data model construction module, including a core table and a business table. The core table stores core information such as citizen identification number, name, student ID number, highest academic degree, and degree certificate number. The business table records business information such as learning stage, start date of study, learning institution, and name of major studied;

[0035] A data docking module, used to sort out data resources on the sharing platform, identify and select data resources that meet the requirements, generate a list of project data requirements, and send it to the business department for soliciting opinions, and finally determine the list of data requirements and the source department;

[0036] A data aggregation module, used to promote the sharing of data resources among departments, initiate resource applications through the sharing platform, write data collection tasks, collect data into the original database and perform periodic backups;

[0037] A data governance module, used to formulate governance rules such as data integrity, standardization, consistency, and normalization, store problem data in the problem database, and write qualified data into the special topic database.

[0038] Preferably, the data directories supported by the data resource sorting module include but are not limited to: preschool education information, student status management information of ordinary primary and secondary schools, student status management information of secondary vocational schools, student status information of high schools, study abroad experience information tables, continuing education information, relevant electronic certificate information; the fields covered by various data directories include name, citizen identification number, student ID number, enrollment time, graduation time, type of change, change date, degree certificate number, graduation certificate number, name of major studied, and learning institution.

[0039] Preferably, the core table structure in the educational experience data model construction module includes: The citizen identity number and the name field are sourced from the population core information table in the population basic database; The highest education level, the graduation certificate number of the highest education level, the degree certificate number, and the graduation time of the highest education level are sourced from the information on degrees / educational levels of higher education institutions, the graduation information of secondary vocational schools, the graduation information of ordinary primary and secondary schools, and the study abroad experience information table; The sources of the first education level and the graduation time of the first education level are the same as those of the highest education level field.

[0040] Preferably, the data docking module further includes: A data resource identification unit for searching for resources from the sharing platform and identifying resource content with duplicate names or ambiguous definitions;

[0041] A data requirement list generation unit for integrating unshared resources and shared resources with missing or ambiguous parts to generate a project data requirement list;

[0042] An opinion solicitation and feedback unit for sending the data requirement list to the business department, collecting feedback opinions, and adjusting the data requirement list and the construction plan according to the feedback.

[0043] Preferably, the system further includes: A data modeling module for integrating and modeling based on educational experience data, associating national, provincial, and municipal educational data resources through core information such as citizen identity numbers and student status numbers to form a data fusion service for educational information;

[0044] A service development module for extracting a service list based on standard data, developing data interfaces, and registering and publishing them to the data sharing platform to support data requirements in application scenarios such as talent declaration certification and professional title evaluation certification.

[0045] Compared with the prior art, the beneficial effects of the present invention are:

[0046] The application method and system based on educational experience data proposed by the present invention make full use of the information data of various commissions, offices, and bureaus within the government, break the "information islands" of data between various commissions, offices, and bureaus of the government, and achieve the sharing and fusion of data; It realizes a comprehensive and systematic sorting of educational experience data, provides a set of data models and data services, and provides data support for the application of educational data; It has strong practicability, a wide range of applications, and is easy to promote, opening up ideas for the in-depth application of educational data by internal government personnel and promoting the development of the government big data environment and industry. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 It is a flow chart of the method of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0048] In order to clearly and completely describe the objectives, technical solutions of the present invention, and make the advantages more clearly understood, the following further details the embodiments of the present invention in conjunction with the accompanying drawings. It should be understood that the specific embodiments described herein are some embodiments of the present invention, rather than all embodiments, and are only used to explain the embodiments of the present invention, not to limit the embodiments of the present invention. All other embodiments obtained by those of ordinary skill in the art without creative efforts belong to the scope of protection of the present invention.

[0049] Embodiment 1, the present invention provides a technical solution: an application service method based on educational experience data, and its specific technical solution includes the following steps:

[0050] Step 1: Data resource sorting

[0051] The data catalog required by the educational experience special application model mainly comes from educational department units at the national, provincial, and municipal levels. The definitions and requirements for the educational experience model may vary in different regions. Before carrying out specific work, it is necessary to communicate with customers in a timely manner to adjust the implementation plan to ensure that the data service construction conforms to the actual situation of the project and the data service provided meets the actual needs of the department. The data resource sources include, but are not limited to, the following data catalog resources:

[0052]

[0053]

[0054]

[0055]

[0056] Step 2: Design of the core library tables of the educational experience data model

[0057] The educational experience service model consists of a core table and business tables. The core table mainly consists of information items such as name, ID number, student ID number, highest education level, graduation certificate number of the highest education level, degree certificate number, graduation time of the highest education level, first education level, and graduation time of the first education level. The business tables record name, citizen identification number, learning stage, start date of learning, end date of learning, learning institution, name of the major studied, and graduation certificate number obtained, etc.

[0058] (1) Core table structure

[0059]

[0060]

[0061] (2) Business table structure

[0062]

[0063]

[0064] Step 3: Data Docking

[0065] According to the data resource list, sort out the corresponding data resources in combination with the actual situation of the project. First, search for resources from the sharing platform. Since the data quality of the sharing platform construction varies from place to place, there may be resources with the same name or ambiguous definitions. It is necessary to identify and analyze the searched resources and select appropriate resources. For the same resources shared at different levels of provinces, cities, and counties, it is necessary to communicate and confirm with the customer to clarify which one shall prevail. For the resources that meet the requirements, it is necessary to further confirm the information items. If the information items cannot correspond to the information items in the requirements list, there are omissions or ambiguities, a list of missing information items or problematic information items needs to be sorted out for further communication with the department. For the data requirements not shared on the sharing platform, a list also needs to be sorted out to prepare for the next step of soliciting opinions.

[0066] According to the situation of data resource sorting, integrate the data resources and related issues of information items to form a project data requirements list, including unshared resources and shared resources with omissions or ambiguities. The project data requirements list needs to be sent to each business department to solicit opinions on data requirements, and feedback whether it can be provided or supplemented. Those that cannot be provided or supplemented need to explain the reasons. According to the final feedback of soliciting opinions, it is necessary to further sort out and analyze. For those with problems, continue to communicate with the department. Replace the data that does not conform to the project plan or cannot meet the construction requirements through other resources or channels. At the same time, make personalized adjustments to the construction plan according to the research situation, and finally determine the data requirements list and the source department.

[0067] Step 4: Data Aggregation

[0068] Promote each department to share resources in a timely manner according to the data aggregation requirements. After the relevant resources are shared, assist the big data competent department to initiate a resource application to the relevant data providing departments through the sharing platform, and agree on a data update mechanism with the providing departments to ensure the freshness of the data. After the application is approved, write data collection tasks for the data of each department and collect the data into the original database. At the same time, it is necessary to perform periodic backups on the data in the original database to avoid affecting performance due to overly large data volumes.

[0069] Step 5: Data Governance

[0070] In response to the data aggregation situation, sort out the data governance rules, specifically including rules such as integrity, standardization, consistency, and normalization. According to the data governance rules, write governance tasks, store the problematic data in the problem library, and write the qualified data into the special topic library. Various problems may be encountered during the governance process, such as operating environment problems, database problems, process problems, etc., which need to be solved specifically.

[0071] Step Six: Data Modeling

[0072] The educational experience special topic service model will integrate the educational data resources distributed in the country, province, and city according to people's educational experiences, associate them through core information such as citizen identity numbers and student status numbers, and uniformly encapsulate the educational time, graduation school information of citizens in preschool, primary school, junior high school, high school, university, etc., to form a data fusion service for educational qualifications information, providing a one-stop service for all levels and departments to call citizens' educational data, and solving problems such as querying and verifying educational data such as educational experience, highest educational qualification, and first educational qualification.

[0073] Step Seven: Service Development

[0074] Based on the standard data, extract the service list that can be provided externally, or provide services specifically according to user needs, and carry out the development work of relevant data services according to the service list. The developed data interfaces need to undergo unified tests such as functionality and stability. After passing the tests, register and publish the services to the data sharing platform to support the data needs of relevant departments.

[0075] According to business needs, sort out the application scenarios of the educational experience special topic service, and provide multiple types of product services for different application scenarios.

[0076] 1. Talent Declaration and Certification Service

[0077] Talent is the first resource. To accelerate the attraction and aggregation of outstanding talents and innovation and entrepreneurship teams at home and abroad to settle down, local governments have increased the intensity of talent introduction and talent subsidy policies. However, during the talent declaration process, there are problems such as repeated submission of materials and repeated filling of information. To solve the difficulties and bottlenecks in talent introduction declaration and comprehensively promote "Internet + Government Services", through basic database information such as population and legal persons, connect data of multiple levels of education departments to provide integrated services for talents' educational experience information.

[0078] 2. Professional Title Evaluation and Certification Service

[0079] Professional title refers to the professional and technical level, ability, and hierarchical title of achievements of professional and technical personnel, which is a symbol reflecting the technical level and working ability of professional and technical personnel. With the needs of social development, there has gradually emerged the need to separate the evaluation of the level of professional and technical personnel from the appointment of positions, that is, "separation of evaluation and appointment", and the concept of professional title has also changed accordingly. The appointed position is called "professional and technical position", abbreviated as position; while the level of professional and technical personnel is identified by "qualification for professional and technical positions", abbreviated as professional title. A large amount of information such as citizens' educational experience and highest academic degree certificates needs to be submitted during the professional title evaluation process, which increases the complexity of the application by ordinary people, and the chaotic filling is not conducive to the comprehensive review by the evaluation agencies. Therefore, the educational experience service can well solve the problems of scattered data services and inactive data services mentioned above.

[0080] Embodiment 2, based on Embodiment 1, in order to implement a system for an application method based on educational experience data, including:

[0081] A data resource sorting module, used to obtain data directories related to educational experience from education departments at the national, provincial, and city levels, and adjust the data service plan according to customer needs to ensure that the data resources meet the actual needs of the project; the data directories supported by the data resource sorting module include but are not limited to: preschool education information, student status management information of ordinary primary and secondary schools, student status management information of secondary vocational schools, student status information of high schools, study abroad experience information tables, continuing education information, relevant electronic certificate information; the fields covered by various data directories include name, citizen identity number, student status number, enrollment time, graduation time, type of change, change date, degree certificate number, graduation certificate number, name of the major studied, and learning unit.

[0082] An educational experience data model construction module, including a core table and a business table. The core table stores core information such as citizen identity number, name, student status number, highest academic degree, and degree certificate number, and the business table records business information such as learning stage, learning start date, learning unit, and name of the major studied; the core table structure in the educational experience data model construction module includes: the citizen identity number and name fields are from the population core information table of the population basic database; the highest academic degree, highest academic degree graduation certificate number, degree certificate number, and highest academic degree graduation time fields are from the degree / academic degree information of high schools, graduation information of secondary vocational schools, graduation information of ordinary primary and secondary schools, and study abroad experience information tables; the source of the first academic degree and the first academic degree graduation time fields is the same as that of the highest academic degree field.

[0083] The data docking module is used to sort out the data resources of the sharing platform, identify and select the data resources that meet the requirements, generate a list of project data requirements, and send it to the business department for comments, and finally determine the data requirements list and the source department; the data docking module further includes: a data resource identification unit, which is used to search for resources from the sharing platform and identify the resource content with the same name or ambiguous definition; a data requirements list generation unit, which is used to integrate the unshared resources and the shared resources with missing or ambiguous information to generate a list of project data requirements; an opinion solicitation and feedback unit, which is used to send the data requirements list to the business department, collect feedback opinions, and adjust the data requirements list and the construction plan according to the feedback.

[0084] The data aggregation module is used to promote the sharing of data resources among departments, initiate a resource application through the sharing platform, write data collection tasks, collect the data into the original library and perform periodic backups;

[0085] The data governance module is used to formulate governance rules such as data integrity, standardization, consistency, and normalization, store the problematic data in the problem library, and write the qualified data into the special topic library.

[0086] The system further includes: a data modeling module, which is used to integrate and model based on educational experience data, associate the national, provincial, and city educational data resources through the core information such as the citizen identity number and student status number, and form a data fusion service for academic information; a service development module, which is used to extract a service list based on standard data, develop data interfaces, and register and publish them to the data sharing platform to support the data requirements of application scenarios such as talent declaration certification and professional title evaluation certification.

[0087] Although the embodiments of the present invention have been shown and described, those of ordinary skill in the art can understand that various changes, modifications, substitutions, and variations can be made to these embodiments without departing from the principles and spirit of the present invention. The scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. An application method based on educational experience data, characterized in that: It includes the following steps: Data resource sorting: Obtain the education experience data catalog from education departments at the national, provincial, and city levels, clarify the data source departments, field contents, and demand differences, and adjust the data service plan according to the actual situation of the project; Design of the core library tables for the education experience data model: Construct the core table and business tables. The core table contains core fields such as citizen identity number, name, student ID number, highest education level, and degree certificate number. The business tables record information such as learning stage, learning time, learning institution, and major; Data docking: Search for data resources through the sharing platform, identify and analyze the resource quality, confirm the resource correspondence, sort out the list of data requirements that are not shared or have missing / ambiguous information, and solicit opinions from the business department. Finally, determine the data requirement list and the source department; Data aggregation: Promote the sharing of resources among departments, apply for data through the sharing platform and agree on an update mechanism, collect the data into the original library and perform periodic backups; Data governance: Formulate governance rules for integrity, standardization, consistency, and normalization, write governance tasks, store the problematic data in the problem library, and write the qualified data into the special library; Data modeling: Taking the citizen identity number and student ID number as the core information, integrate multi-level education data resources to form an education experience special service model, and provide one-stop integrated service for academic information; Service development: Develop service interfaces based on standard data, provide services for talent declaration certification and professional title evaluation certification, and register and publish them to the data sharing platform.

2. The application method based on educational experience data according to claim 1, wherein: In the data resource sorting step, the data catalog includes but is not limited to the following contents: Preschool education information: Name, citizen identity number, school name, enrollment time; General primary and secondary school student status management information: Student ID number, enrollment year and month, student category code; General primary and secondary school student status change information: Change category, change date, reason for change; Vocational school graduation information: Graduation certificate number, issuance date, whether received; Higher education degree and academic information: Degree code, name of the degree-awarding institution, code of the major for which the degree is obtained; Study abroad experience information: Study abroad country / region code, overseas school number, major of study abroad; 3. The application method based on educational experience data according to claim 2, characterized in that: In the design step of the core library tables for the education experience data model, the sources of the core table fields include: Citizen identity number, name: From the core population information table in the population basic library; Student ID number: From the municipal education department; Highest education level, highest education graduation certificate number, degree certificate number, highest education graduation time: From the higher education degree / academic information, vocational school graduation information, general primary and secondary school graduation information, and study abroad experience information tables; First education level, first education graduation time: The source is the same as above.

4. The application method based on educational experience data according to claim 3, characterized in that: In the data docking step, the following processing is performed on the resources searched on the sharing platform: Identify and analyze the resource quality, and exclude resources with the same name or ambiguous definitions; For the same resources shared at different levels of province, city, and county, communicate with the customer to confirm the priority; For resources with missing or ambiguous information items, sort out the problem list and solicit opinions from the business department; For unshared data requirements, sort out the list and include it in the scope of the next round of opinion solicitation.

5. The application method based on educational experience data according to claim 4, characterized in that: In the service development step, the following application services are provided: Talent declaration and certification service: Integrate the information in the population and legal person basic databases and the data of multi-level education departments to provide talent with educational experience information integration services; Professional title assessment and certification service: Provide citizens' educational experience and the information of the highest academic degree certificate, simplify the application process for professional title assessment, and support the comprehensive review of assessment institutions.

6. A system for an application method based on educational experience data according to claim 5, characterized in that: Including: Data resource sorting module, which is used to obtain the data catalog related to educational experience from the education departments at the national, provincial, and city levels, and adjust the data service plan according to customer needs to ensure that the data resources meet the actual needs of the project; Educational experience data model construction module, which includes a core table and a business table. The core table stores the core information such as citizen identity number, name, student ID number, highest academic degree, and degree certificate number. The business table records the business information such as learning stage, start date of study, learning institution, and name of the major studied; Data docking module, which is used to sort out the data resources of the sharing platform, identify and select the data resources that meet the requirements, generate a list of project data requirements, and send it to the business department for comments, and finally determine the list of data requirements and the source department; Data aggregation module, which is used to promote the sharing of data resources among departments, initiate resource applications through the sharing platform, write data collection tasks, collect data into the original database and perform periodic backups; Data governance module, which is used to formulate governance rules such as data integrity, standardization, consistency, and normalization, store the problematic data in the problem database, and write the qualified data into the special database.

7. A system according to claim 6, characterized in that: The data catalog supported by the data resource sorting module includes but is not limited to: preschool education information, student status management information of ordinary primary and secondary schools, student status management information of secondary vocational schools, student status information of high schools, study abroad experience information table, continuing education information, relevant electronic certificate information; the fields covered by various data catalogs include name, citizen identity number, student ID number, enrollment time, graduation time, type of change, change date, degree certificate number, graduation certificate number, name of the major studied, and learning institution.

8. A system according to claim 7, characterized in that: The core table structure in the educational experience data model construction module includes: the citizen identity number and name fields are from the population core information table in the population basic database; the highest academic degree, highest academic degree graduation certificate number, degree certificate number, and highest academic degree graduation time fields are from the high school degree / academic information, secondary vocational school graduation information, ordinary primary and secondary school graduation information, and study abroad experience information table; the sources of the first academic degree and the first academic degree graduation time fields are the same as those of the highest academic degree field.

9. A system according to claim 8, characterized in that: The data docking module further includes: a data resource identification unit, which is used to search for resources from the sharing platform and identify the resource content with the same name or vague definition; A data requirement list generation unit, which is used to integrate the unshared resources and the shared resources with missing or ambiguous information to generate a list of project data requirements; An opinion solicitation and feedback unit, which is used to send the data requirement list to the business department, collect feedback opinions, and adjust the data requirement list and construction plan according to the feedback.

10. A system according to claim 9, wherein: The system also includes: a data modeling module, which is used to perform integration modeling based on educational experience data, associate the educational data resources at the national, provincial, and city levels through the core information of citizen identity number and student ID number, and form a data fusion service for academic information; A service development module, which is used to extract a service list based on standard data, develop data interfaces, and register and publish them to a data sharing platform to support the data requirements of application scenarios such as talent declaration certification and professional title evaluation certification.

Images