CN109376349A - Adult education system table data processing platform (DPP) and method based on Meta data system - Google Patents
Adult education system table data processing platform (DPP) and method based on Meta data system Download PDFInfo
- Publication number
- CN109376349A CN109376349A CN201811216651.9A CN201811216651A CN109376349A CN 109376349 A CN109376349 A CN 109376349A CN 201811216651 A CN201811216651 A CN 201811216651A CN 109376349 A CN109376349 A CN 109376349A
- Authority
- CN
- China
- Prior art keywords
- excel
- data
- metadata
- student
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 230000008569 process Effects 0.000 claims abstract description 14
- 230000009471 action Effects 0.000 claims description 6
- 238000003672 processing method Methods 0.000 claims description 6
- 230000001360 synchronised effect Effects 0.000 abstract description 5
- 230000008859 change Effects 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/20—Education
- G06Q50/205—Education administration or guidance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Health & Medical Sciences (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- Educational Technology (AREA)
- Tourism & Hospitality (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Educational Administration (AREA)
- Computational Linguistics (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of adult education system table data processing platform (DPP) and method based on Meta data system, the platform includes: metadata configurations module: for being associated according to the content at table number of computations as needed all kinds of in teaching system with the corresponding field in corresponding data table, and establishing metadata；Excel template establishes module: for establishing corresponding excel template according to the metadata configured in metadata configurations module；Data export module: for excel template to be written in the quantity of calculating according to metadata configurations module and excel template and uploads to file server, file address is returned to client.By the present invention in that with asynchronous generation excel, synchronous downloading excel optimizes export experience, abandons original storing process calculation used and is changed to use metadata configurations+Map dictionary calculate and improve treatment effeciency.
Description
Technical field
The present invention relates to technical field of data processing, and in particular to a kind of adult education system table data based on Meta data system
Processing platform and method.
Background technique
For the management at teaching system, following data often is provided for the Ministry of Education: to special at the adult in teaching system
Industry number of students, Adult Undergraduate Course divide Major number, and student at school divides age condition, enrollment, student at school source situation, and student changes feelings
Condition, student stop the main reason for leaving school etc.；However due to using synchronous downloading, storing process is calculated, larger in student data amount
In the case where the efficiency of data processing can be slow, data export that the time is long, are easy to influence the experience of user.
Summary of the invention
The purpose of the present invention is to provide a kind of adult education system table data processing platform (DPP) and method based on Meta data system,
It solves due to using synchronous downloading, storing process calculates, and adult education system data is handled in the biggish situation of student data amount
Efficiency can be slow, and the data export time is long, is easy the problem of influencing the experience of user.
In order to solve the above technical problems, the invention adopts the following technical scheme:
A kind of adult education system table data processing platform (DPP) based on Meta data system, the platform include:
Metadata configurations module: for according to the content and corresponding data table at table number of computations as needed all kinds of in teaching system
In corresponding field be associated, and establish metadata；
Excel template establishes module: for establishing corresponding excel mould according to the metadata configured in metadata configurations module
Plate；
Data export module: for excel template to be written simultaneously in the quantity of calculating according to metadata configurations module and excel template
File server is uploaded to, returns to file address to client.
Preferably, all kinds of tables at teaching system include school admission imformation table, student's Basic Information Table, student status information
Table, student status unusual action information table.
A kind of adult education system table data processing method based on Meta data system, comprising the following steps:
S1: metadata configurations module is according in the content and corresponding data table at table number of computations as needed all kinds of in teaching system
Corresponding field be associated, and establish metadata；
S2:Excel template establishes module and establishes corresponding excel mould according to the metadata configured in metadata configurations module
Plate；
S3: data export module according to metadata configurations module and excel template by the quantity of calculating be written excel template and on
File server is passed to, returns to file address to client.
Preferably, being sent a message to by the way of asynchronous process when being exported in the S3 step to data
ActiveMQ carries out asynchronous process.
Preferably, data export module is to the derived specific method of data progress in the S3 step: for basis
Student information is searched at all kinds of tables in teaching system and is stored in Map dictionary according to the Key that metadata is arranged, and by Key value
Excel cell corresponding with metadata setting is matched, and it is mono- will to search the corresponding excel of Key value write-in that student obtains
In first lattice, excel file is finally uploaded into file server, returns to file download address.
Preferably, verify data whether there is before being write data in excel cell in the S3 step, if depositing
It is then write data into excel cell in data, data then directly go up transmitting file if it does not exist.
Compared with prior art, the beneficial effects of the present invention are:
By the present invention in that with asynchronous generation excel, synchronous downloading excel optimizes export experience, abandon it is original use deposit
Storage process calculation is changed to carry out calculating using metadata configurations+Map dictionary to improve treatment effeciency.
Detailed description of the invention
Fig. 1 is basic flow chart of the invention.
Fig. 2 is detail flowchart of the invention.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
For one embodiment of platform of the invention, a kind of adult education system table data processing based on Meta data system is flat
Platform, the platform include:
Metadata configurations module: for according to the content and corresponding data table at table number of computations as needed all kinds of in teaching system
In corresponding field be associated, and establish metadata；
Excel template establishes module: for establishing corresponding excel mould according to the metadata configured in metadata configurations module
Plate；
Data export module: for excel template to be written simultaneously in the quantity of calculating according to metadata configurations module and excel template
File server is uploaded to, returns to file address to client.
Further, for another embodiment of platform of the invention, all kinds of tables at teaching system include enrollment
Information table, student's Basic Information Table, student status information table, student status unusual action information table.It will be at the adult Major in teaching system
Number, Adult Undergraduate Course divide Major number, and student at school divides age condition, enrollment, student at school source situation, and student's change conditions are learned
The raw data such as the main reason for leaving school of stopping carry out counting statistics, then will necessarily be associated with school admission imformation table, student's Basic Information Table, learn
Nationality information table, student status unusual action information table.
Referring to Fig. 1,2, for one embodiment of method of the invention, a kind of adult education system table based on Meta data system
Data processing method, comprising the following steps:
S1: metadata configurations module is according in the content and corresponding data table at table number of computations as needed all kinds of in teaching system
Corresponding field be associated, and establish metadata；
S2:Excel template establishes module and establishes corresponding excel mould according to the metadata configured in metadata configurations module
Plate；
S3: data export module according to metadata configurations module and excel template by the quantity of calculating be written excel template and on
File server is passed to, returns to file address to client.
Further, for another embodiment of method of the invention, when being exported in the S3 step to data
By the way of asynchronous process, sends a message to ActiveMQ and carry out asynchronous process.
By the present invention in that synchronous downloading excel optimizes export experience with asynchronous generation excel, original use is abandoned
Storing process calculation be changed to carry out using metadata configurations+Map dictionary to calculate and improve treatment effeciency.
Further, for another embodiment of method of the invention, data export module logarithm in the S3 step
It is according to derived specific method is carried out: for according to searching student information at all kinds of tables in teaching system and be arranged according to metadata
Key be stored in Map dictionary, and Key value excel cell corresponding with metadata setting is matched, is learned searching
Raw obtained Key value is written in corresponding excel cell, and excel file is finally uploaded to file server, returns to file
Download address.
Further, for another embodiment of method of the invention, in order to save system space and operating process, institute
Stating verify data before being write data in excel cell in S3 step whether there is, and data then write data into if it exists
Into excel cell, data then directly go up transmitting file if it does not exist.
The present invention is exemplified below, such as at the adult Major number in teaching system, Adult Undergraduate Course point profession is learned
Raw number, student at school divide age condition, recruit student, student at school source situation, and student's change conditions, student stops the main reason for leaving school
Deng, for above-mentioned data processing export have follow steps:
1, metadata is configured
The school admission imformation of student, student's essential information, student status information, student status unusual action information, the teaching programme being arranged in system are matched
Set the high base 313(Adult of export and divide Major number), the high base 314(Adult Undergraduate Course of export divide Major number), export it is high
Base 321(student at school divide age condition), export high base 322(enrollment, student at school source situation), the high base 331(student of export changes
Situation), the high base 332(student of export stop the main reason for leaving school), other situations in the high base 341(student at school of export) in need to count
Corresponding field in the item and corresponding data table of the amount of counting.
2, excel template is established
Corresponding excel template is defined according to data processing table (high base table).
3, data are exported
Click and export high base 313(Adult and divide Major number), the high base 314(Adult Undergraduate Course of export divide Major number),
Export high base 321(student at school and divide age condition), export high base 322(enrollment, student at school source situation), export Gao Ji
331(student's change conditions), the high base 332(student of export stop the main reason for leaving school), other in the high base 341(student at school of export
Situation), it sends a message to ActiveMQ and carries out asynchronous process.
Asynchronous process
Step 1: defining corresponding excel template according to high base table；
Step 2: according to message name metadata selected to use and excel template；
Step 3: verifying whether to have selected the time, if the time is not selected to prompt " the specific time please be select "；
Step 4: according to excel template generation excel file；
It needs the information counted step 5: calculating high base table according to message and is written in the excel file of generation；
(1) high base 313(Adult divides Major number)
It is training in student according to level where time, student's student status state (in nationality, suspend schooling, graduate, complete a course, leave school), student
Essential information, student status information are searched student information in teaching programme and are stored in Map dictionary according to the Key that metadata is arranged,
According to the excel cell matching corresponding with metadata setting of Key value, and in calculated value write-in corresponding unit lattice, have been calculated
File server is uploaded at rear excel file, file address is returned to, is shown in messaging list.
(2) high base 314(Adult Undergraduate Course divides Major number)
It is undergraduate course in student according to level where time, student's student status state (in nationality, suspend schooling, graduate, complete a course, leave school), student
Essential information, student status information are searched student information in teaching programme and are stored in Map dictionary according to the Key that metadata is arranged,
According to the excel cell matching corresponding with metadata setting of Key value, and in calculated value write-in corresponding unit lattice, have been calculated
File server is uploaded at rear excel file, file address is returned to, is shown in messaging list.
(3) high base 321(student at school divides age condition)
Student information and root are searched in student's essential information, student status information according to time, student's student status state (in nationality, suspending schooling)
It is stored in Map dictionary according to the Key that metadata is arranged, is matched according to Key value excel cell corresponding with metadata setting,
And in calculated value write-in corresponding unit lattice, excel file uploads to file server after the completion of calculating, returns to file address,
It is shown in messaging list.
(4) high base 322(enrollment, student at school source situation are exported)
Search in school admission imformation, student's essential information, student status information according to time, student's student status state (in nationality, suspending schooling)
Raw information is simultaneously stored in Map dictionary according to the Key that metadata is arranged, according to Key value excel corresponding with metadata setting
Cell matching, and in calculated value write-in corresponding unit lattice, excel file uploads to file server after the completion of calculating, returns
Back into file address, is shown in messaging list.
(5) high base 331(student change conditions are exported)
According to time, student's student status state (in nationality, suspend schooling, graduate, complete a course, leave school) in student's essential information, student status information, learn
Student information is searched in nationality unusual action information and is stored in Map dictionary according to the Key that metadata is arranged, according to Key value and first number
It is matched according to corresponding excel cell is arranged, and calculated value is written in corresponding unit lattice, after the completion of calculating on excel file
File server is passed to, file address is returned to, is shown in messaging list.
(6) it exports high base 332(student and stops the main reason for leaving school)
According to time, student's student status state (suspend schooling, leave school) in student's essential information, student status information, stop to leave school and search in reason
Student information is simultaneously stored in Map dictionary according to the Key that metadata is arranged, corresponding with metadata setting according to Key value
The matching of excel cell, and in calculated value write-in corresponding unit lattice, excel file uploads to file service after the completion of calculating
Device returns to file address, is shown in messaging list.
(7) other situations in high base 341(student at school are exported)
Student information and root are searched in student's essential information, student status information according to time, student's student status state (in nationality, suspending schooling)
It is stored in Map dictionary according to the Key that metadata is arranged, is matched according to Key value excel cell corresponding with metadata setting,
And in calculated value write-in corresponding unit lattice, excel file uploads to file server after the completion of calculating, returns to file address,
It is shown in messaging list.
Step 5: downloading excel file in message center list.
" one embodiment ", " another embodiment ", " embodiment ", " preferred implementation spoken of in the present specification
Example " etc., referring to combining specific features, structure or the feature of embodiment description includes describing extremely in the application generality
In few one embodiment.It is not centainly to refer to the same embodiment that statement of the same race, which occur, in multiple places in the description.Into one
For step, when describing a specific features, structure or feature in conjunction with any embodiment, what is advocated is to combine other implementations
Example realizes that this feature, structure or feature are also fallen within the scope of the present invention.
Although reference be made herein to invention has been described for multiple explanatory embodiments of the invention, however, it is to be understood that
Those skilled in the art can be designed that a lot of other modification and implementations, these modifications and implementations will fall in this Shen
It please be within disclosed scope and spirit.More specifically, disclose in the application, drawings and claims in the range of, can
With the building block and/or a variety of variations and modifications of layout progress to theme combination layout.In addition to building block and/or layout
Outside the modification and improvement of progress, to those skilled in the art, other purposes also be will be apparent.
Claims (6)
1. a kind of adult education system table data processing platform (DPP) based on Meta data system, it is characterised in that: the platform includes:
Metadata configurations module: for according to the content and corresponding data table at table number of computations as needed all kinds of in teaching system
In corresponding field be associated, and establish metadata；
Excel template establishes module: for establishing corresponding excel mould according to the metadata configured in metadata configurations module
Plate；
Data export module: for excel template to be written simultaneously in the quantity of calculating according to metadata configurations module and excel template
File server is uploaded to, returns to file address to client.
2. the adult education system table data processing platform (DPP) according to claim 1 based on Meta data system, it is characterised in that: institute
All kinds of tables for stating into teaching system include school admission imformation table, student's Basic Information Table, student status information table, student status unusual action information table.
3. a kind of adult education system table data processing method based on Meta data system, it is characterised in that: the following steps are included:
S1: metadata configurations module is according in the content and corresponding data table at table number of computations as needed all kinds of in teaching system
Corresponding field be associated, and establish metadata；
S2:Excel template establishes module and establishes corresponding excel mould according to the metadata configured in metadata configurations module
Plate；
S3: data export module according to metadata configurations module and excel template by the quantity of calculating be written excel template and on
File server is passed to, returns to file address to client.
4. the adult education system table data processing method according to claim 3 based on Meta data system, it is characterised in that: institute
It states when being exported in S3 step to data by the way of asynchronous process, sends a message to ActiveMQ and carry out asynchronous process.
5. the table data processing method according to claim 3 based on Meta data system, it is characterised in that: the S3 step
Middle data export module carries out derived specific method to data: for searching student's letter according at all kinds of tables in teaching system
It ceases and is simultaneously stored in Map dictionary according to the Key of metadata setting, and by Key value excel cell corresponding with metadata setting
It is matched, the Key value that student obtains will be searched and be written in corresponding excel cell, excel file is finally uploaded into text
Part server returns to file download address.
6. the adult education system table data processing method according to claim 5 based on Meta data system, it is characterised in that: institute
Stating verify data before being write data in excel cell in S3 step whether there is, and data then write data into if it exists
Into excel cell, data then directly go up transmitting file if it does not exist.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811216651.9A CN109376349A (en) | 2018-10-18 | 2018-10-18 | Adult education system table data processing platform (DPP) and method based on Meta data system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811216651.9A CN109376349A (en) | 2018-10-18 | 2018-10-18 | Adult education system table data processing platform (DPP) and method based on Meta data system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109376349A true CN109376349A (en) | 2019-02-22 |
Family
ID=65400990
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811216651.9A Pending CN109376349A (en) | 2018-10-18 | 2018-10-18 | Adult education system table data processing platform (DPP) and method based on Meta data system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109376349A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110351715A (en) * | 2019-07-15 | 2019-10-18 | 西安中兴物联软件有限公司 | AT command processing method, terminal adapter and computer readable storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090248710A1 (en) * | 2008-03-27 | 2009-10-01 | Microsoft Corporation | Database Part Table Junctioning |
| US20130212116A1 (en) * | 2012-02-13 | 2013-08-15 | Post Pro Finance Co., Inc. | Metadata engine and repository |
| CN108345682A (en) * | 2018-03-02 | 2018-07-31 | 弘成科技发展有限公司 | Platform and method are imported and exported based on what multi-tenant can configure |
-
2018
- 2018-10-18 CN CN201811216651.9A patent/CN109376349A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090248710A1 (en) * | 2008-03-27 | 2009-10-01 | Microsoft Corporation | Database Part Table Junctioning |
| US20130212116A1 (en) * | 2012-02-13 | 2013-08-15 | Post Pro Finance Co., Inc. | Metadata engine and repository |
| CN108345682A (en) * | 2018-03-02 | 2018-07-31 | 弘成科技发展有限公司 | Platform and method are imported and exported based on what multi-tenant can configure |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110351715A (en) * | 2019-07-15 | 2019-10-18 | 西安中兴物联软件有限公司 | AT command processing method, terminal adapter and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| AU2017329098B2 (en) | Method and device for processing question clustering in automatic question and answering system | |
| CN113505128B (en) | Method, device, equipment and storage medium for creating data table | |
| CN112395390B (en) | Training corpus generation method of intention recognition model and related equipment thereof | |
| CN111159220B (en) | Method and apparatus for outputting structured query statement | |
| CN103440288A (en) | Big data storage method and device | |
| CN108121699B (en) | Method and apparatus for outputting information | |
| Silva et al. | Integrating big data into the computing curricula | |
| CN110163252A (en) | Data classification method and device, electronic equipment, storage medium | |
| CN109902286B (en) | Entity identification method and device and electronic equipment | |
| CN111008213A (en) | Method and apparatus for generating language conversion model | |
| CN108551478B (en) | Transaction processing method, server and transaction processing system | |
| CN109376349A (en) | Adult education system table data processing platform (DPP) and method based on Meta data system | |
| CN112269875B (en) | Text classification method, device, electronic equipment and storage medium | |
| CN117216114A (en) | Data stream association method, device, equipment and storage medium thereof | |
| CN113468258A (en) | Heterogeneous data conversion method and device and storage medium | |
| CN111832304B (en) | Weight checking method and device for building names, electronic equipment and storage medium | |
| CN111191025B (en) | Method and device for determining article relevance, readable medium and electronic equipment | |
| WO2022000169A1 (en) | Data analysis method and apparatus spanning data centers, and device and storage medium | |
| CN206639222U (en) | A kind of demographic data processing system based on cloud computing | |
| CN117971908A (en) | Method and device for entering lake in real time by data, electronic equipment and storage medium | |
| CN117972032A (en) | Question and answer method, device, equipment and medium based on large language model | |
| CN118569601A (en) | Automatic work order processing system and method based on large language model | |
| CN116401282A (en) | Data processing method and device, storage medium and electronic equipment | |
| CN116243859A (en) | Unstructured data storage method based on classification model | |
| TW201621713A (en) | Method of operating a solution searching system and solution searching system |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190222 |