CN108256829B - ERP skill online scoring oriented data extraction method and system - Google Patents
ERP skill online scoring oriented data extraction method and system Download PDFInfo
- Publication number
- CN108256829B CN108256829B CN201810076843.8A CN201810076843A CN108256829B CN 108256829 B CN108256829 B CN 108256829B CN 201810076843 A CN201810076843 A CN 201810076843A CN 108256829 B CN108256829 B CN 108256829B
- Authority
- CN
- China
- Prior art keywords
- test paper
- data extraction
- data
- erp
- records
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000013075 data extraction Methods 0.000 title claims abstract description 115
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000012360 testing method Methods 0.000 claims abstract description 104
- 238000000605 extraction Methods 0.000 claims description 16
- 238000004458 analytical method Methods 0.000 claims description 8
- 230000006835 compression Effects 0.000 claims description 8
- 238000007906 compression Methods 0.000 claims description 6
- 239000000203 mixture Substances 0.000 claims description 3
- 238000011156 evaluation Methods 0.000 abstract description 14
- 230000005540 biological transmission Effects 0.000 abstract description 6
- 238000012549 training Methods 0.000 description 6
- 230000009286 beneficial effect Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000013144 data compression Methods 0.000 description 2
- 230000003044 adaptive effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000002474 experimental method Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
Images
Classifications
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
- G06F16/90344—Query processing by using string matching techniques
-
- 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)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Educational Administration (AREA)
- Educational Technology (AREA)
- Marketing (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a data extraction method and system for ERP skill on-line marking, which can reduce data transmission quantity. The method comprises the following steps: acquiring the relation between the service type and the document and the data item; acquiring topic parameters, and analyzing the relationship between the acquired service type and the document and the data item and the acquired topic parameters to obtain a single-topic data extraction rule; acquiring test paper parameters, and analyzing the relation between the acquired service type and the document and the data item and the acquired test paper parameters to obtain test paper data extraction rules; extracting all records in the document related to the subject grading from an ERP account set according to the obtained single-subject data extraction rule, and compressing the records into a single-record character string; and extracting all records in the documents related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule, and compressing the records into single record character strings according to the records. The invention is suitable for automatic evaluation of the technical non-objective questions of the enterprise information system.
Description
Technical Field
The invention relates to the fields of computer-aided evaluation, computerized adaptive test and enterprise information systems, in particular to a data extraction method and a data extraction system for ERP skill online examination.
Background
With the rapid development of IT technology and the national economic level, the application demand and talent demand of enterprises at home and abroad on Enterprise Resource Planning (ERP) software are increasing. In order to efficiently cultivate ERP talents, ERP skill training courses are developed in various colleges and universities of the subject department and colleges in succession. Taking the ERP-U8 software of Uyou as an example, more than 2000 colleges and universities adopt the software for teaching and practical training.
Because the ERP system has complex functions and large data quantity, in order to reduce the training complexity of students, the environment of the user-friendly ERP training and related skill competition in high schools is mainly that students complete enterprise informatization operation by one machine, namely, students operate local ERP software on a computer with the environment of the user-friendly ERP-U8 and complete a series of business operations as required, and the corresponding training evaluation is also used for evaluating the operation results of the student machine. In addition, since the ERP system does not include an automatic evaluation function, a teaching and examination system generally needs to be developed separately for the correct and incorrect evaluation of the operation results of students, and a scoring mode of the evaluation results is mostly adopted.
The evaluation of ERP training belongs to the automatic evaluation of technical non-objective questions, is a key point and a difficulty point in computer aided evaluation (CAA), and is a research subject with multidisciplinary intersection. The skill evaluation is carried out on two levels, namely application-oriented result correctness evaluation and operation-oriented operation sequence evaluation. The result correctness evaluation oriented to the application is compared with the standard answer, and the result is correct if the result is consistent. The judgment of "match" is to perform character string matching in the data in which the operation result is analyzed (for example, in the answer sheet of U8 or the operation result is manually filled in).
Most of the currently-used teaching and test systems are independent teaching and test systems based on a C/S (client/server) framework, namely, the teaching and test systems are deployed on a server of a local area network and a student computer. The student machine is provided with a student end of the teaching and examination system and is mainly used for checking examination questions and controlling examination, and students can upload an operated answer account set to a server for scoring after completing business operation required in the examination questions in an ERP software environment of the student machine. However, the data volume of the account set is huge (the account set of the fellow U8V13.0 is generally 2.5GB, and is 250MB after compression), and the independent ERP education system does not support online scoring due to the fact that the data volume of the ERP account set is too large.
Disclosure of Invention
The invention aims to provide a data extraction method and a data extraction system for ERP skill online examination, and aims to solve the problem that an independent ERP teaching and examination system does not support online scoring due to overlarge data amount of an ERP account set in the prior art.
In order to solve the technical problem, an embodiment of the present invention provides a data extraction method for ERP skill online scoring, including:
acquiring the relation between the service type and the document and the data item;
acquiring topic parameters, and analyzing the relationship between the acquired service type and the document and the data item and the acquired topic parameters to obtain a single-topic data extraction rule;
acquiring test paper parameters, and analyzing the relation between the acquired service type and the document and the data item and the acquired test paper parameters to obtain test paper data extraction rules;
extracting all records in the document related to the subject grading from an ERP account set according to the obtained single-subject data extraction rule, and compressing the records into a single-record character string;
and extracting all records in the documents related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule, and compressing the records into single record character strings according to the records.
Further, the analyzing the relationship between the obtained service type and the document and the data item and the obtained title parameter to obtain the extraction rule of the single-title data includes:
analyzing the relation between the obtained service type and the documents and the data items and the obtained subject parameters to obtain all documents and data items related to the examination paper facing to the subject;
and forming a data extraction rule of the subject by using the obtained subject oriented to all the documents and the data items thereof related to the paper marking.
Further, the extracting all records in the document related to the topic score from the ERP account set according to the obtained topic data extraction rule includes:
and extracting all records in the document related to the subject grading from the ERP account set according to the obtained data extraction rule of the subject, and compressing the records into a single record character string.
Further, the analyzing the relationship between the obtained service type and the document and the data item and the obtained test paper parameters to obtain the test paper data extraction rule includes:
acquiring all the single questions contained in the test paper;
extracting all documents and data items thereof required by the test paper grading through all the questions in the test paper;
and performing union set operation and character string operation on all documents and data items thereof required by the extracted test paper scoring to generate a data extraction rule of the test paper.
Further, after compressing the character string into a single record by record, the method further comprises:
and sending the single record character string obtained by compression to a server for scoring by going over the paper.
An embodiment of the present invention further provides an ERP skill online scoring-oriented data extraction system, including:
the acquiring unit is used for acquiring the relation between the service type and the document and the data item;
the first analysis unit is used for acquiring the topic parameters, analyzing the relationship between the acquired service type and the document and the acquired data item and the acquired topic parameters, and acquiring a single-topic data extraction rule;
the second analysis unit is used for acquiring the test paper parameters, analyzing the relationship between the acquired service type and the receipt and the data items and the acquired test paper parameters, and acquiring test paper data extraction rules;
the first extraction unit is used for extracting all records in the document related to the subject grading from the ERP account set according to the obtained single-subject data extraction rule and compressing the records into a single-record character string;
and the second extraction unit is used for extracting all records in the document related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule and compressing the records into single record character strings according to the records.
Further, the first parsing unit includes:
the analysis module is used for analyzing the obtained relation between the service type and the receipt and the data item and the obtained question parameter to obtain all receipts and data items related to the marking of the question;
and the composition module is used for composing the data extraction rule of the subject for all the documents and the data items thereof related to the paper marking by using the obtained subject.
Further, the first extraction unit is specifically configured to extract all records in the document related to the subject score from the ERP account set according to the obtained data extraction rule of the subject, and compress the records into a single-record character string.
Further, the second parsing unit includes:
the acquisition module is used for acquiring all the questions contained in the test paper;
the extraction module is used for extracting all documents and data items thereof required by the test paper grading through all the single questions in the test paper;
and the generating module is used for performing union set operation and character string operation on all the documents and data items thereof required by the extracted test paper scoring to generate a data extraction rule of the test paper.
Further, the system further comprises:
and the first sending unit is used for sending the compressed single record character string to a server for scoring by marking, wherein the record is a record in a document related to the scoring of the title, which is extracted from an ERP account set.
And the second sending unit is used for sending the compressed single record character string to a server for scoring by paper marking, wherein the record is a record in a document related to the scoring of the test paper extracted from the ERP account set.
The technical scheme of the invention has the following beneficial effects:
in the scheme, the relation between the service type and the document and the data item is obtained; acquiring topic parameters, and analyzing the relationship between the acquired service type and the document and the data item and the acquired topic parameters to obtain a single-topic data extraction rule; acquiring test paper parameters, and analyzing the relation between the acquired service type and the document and the data item and the acquired test paper parameters to obtain test paper data extraction rules; extracting all records in the document related to the subject grading from an ERP account set according to the obtained single-subject data extraction rule, and compressing the records into a single-record character string; and extracting all records in the document related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule, and compressing the records into a single record character string according to the records so as to transmit the compressed single record character string to a server side. Therefore, data are extracted based on the generated data extraction rule and the extracted data are compressed, so that the data transmission quantity and the storage pressure of a server side can be reduced, and the online scoring is facilitated.
Drawings
Fig. 1 is a schematic flow chart of a data extraction method for ERP skill online scoring provided in an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a data extraction system for ERP skill online scoring provided in the embodiment of the present invention.
Detailed Description
In order to make the technical problems, technical solutions and advantages of the present invention more apparent, the following detailed description is given with reference to the accompanying drawings and specific embodiments.
The invention provides a data extraction method and system for ERP skill on-line marking, aiming at the problem that an independent ERP teaching and examination system does not support on-line marking because the data volume of an ERP account set is too large in the prior art.
Example one
As shown in fig. 1, the data extraction method for ERP skill online scoring provided by the embodiment of the present invention includes:
s101, acquiring the relation between the service type and the bill and the data item;
s102, acquiring topic parameters, analyzing the relationship between the acquired service type and the document and data items and the acquired topic parameters, and acquiring a topic data extraction rule;
s103, acquiring test paper parameters, analyzing the relation between the acquired service type and the document and the data item and the acquired test paper parameters to obtain test paper data extraction rules;
s104, extracting all records in the document related to the subject grading from the ERP account set according to the obtained single-subject data extraction rule, and compressing the records into a single-record character string;
and S105, extracting all records in the document related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule, and compressing the records into a single record character string.
According to the data extraction method for ERP skill on-line marking, provided by the embodiment of the invention, the relation between the service type and the document and the data item is obtained; acquiring topic parameters, and analyzing the relationship between the acquired service type and the document and the data item and the acquired topic parameters to obtain a single-topic data extraction rule; acquiring test paper parameters, and analyzing the relation between the acquired service type and the document and the data item and the acquired test paper parameters to obtain test paper data extraction rules; extracting all records in the document related to the subject grading from an ERP account set according to the obtained single-subject data extraction rule, and compressing the records into a single-record character string; and extracting all records in the document related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule, and compressing the records into a single record character string according to the records so as to transmit the compressed single record character string to a server side. Therefore, data are extracted based on the generated data extraction rule and the extracted data are compressed, so that the data transmission quantity and the storage pressure of a server side can be reduced, and the online scoring is facilitated.
In order to better understand the data extraction method for ERP skill online scoring according to the embodiment of the present invention, the method is described in detail:
a11, obtaining the relation between the service type and the bill and the data item.
When setting the service type, documents and data items related to the current service type are defined. The business type is a classification of business modes in enterprise practice, for example, purchasing business of an enterprise includes multiple business types such as ordinary purchasing, purchasing return goods, fixed asset purchasing and the like. Each business type relates to different ERP documents, for example, common procurement relates to documents including: the main table and the sub-table of the purchase requisition, the main table and the sub-table of the purchase order, the main table and the sub-table of the purchase arrival order, the main table and the sub-table of the purchase warehousing order, the main table and the sub-table of the purchase invoice, the main table and the sub-table of the purchase settlement order, the main table and the sub-table of the payment order, the certificate and the detailed account table, etc.
Each document includes different data items (i.e., fields), for example, the purchase order sublist mainly includes: 69 fields, specifically: 1 main identification field (purchase order sub-table identification), 4 key fields (purchase order main table identification, inventory code, quantity, raw currency tax free unit price), 7 key fields (purchase order number, tax rate, planned arrival date, logo, item major code, item code and metering unit code), 13 full fields, 20 calculation fields and 24 custom fields.
The same business type has different assessment difficulties in different assessment ranges. For example, a purchase is typically a basic assessment in the supply chain, but a high-level assessment in the finance chain. Therefore, when the service type is set, the assessment range and the assessment difficulty of the service type are set at the same time.
A12, generating a single-topic data extraction rule. And analyzing the extraction rule of the single-question data according to the obtained relation between the service type and the document and the data item and the question parameters sent by the teacher. The single question in the skill evaluation refers to an enterprise business and requires students to perform corresponding informatization operation in ERP software. The document data extraction rule for marking is to stipulate the document and its data items related to the title score. Step a12 may specifically include:
a121, obtaining a title parameter sent by a teacher, wherein the title parameter comprises: one or more of the service type, service date, assessment range, assessment difficulty, assessment position, default highest score, default lowest score, original document picture and file information of an initial account set of the subject;
and A122, analyzing a single-topic data extraction rule according to the relation between the acquired service type and the bill and the data item and the acquired topic parameter. Analyzing all the documents and the data items thereof related to the examination paper marking of the subject based on the subject parameters and the documents and the data items defined when the business type is set, and forming a data extraction rule of the subject by utilizing all the documents and the data items thereof related to the examination paper marking of the analyzed subject.
A13, generating a test paper data extraction rule. Step a13 may specifically include:
a131, acquiring test paper parameters sent by a teacher, wherein the test paper parameters include: one or more of the test paper name, the test paper definition, the assessment range, the assessment difficulty, the assessment post, the weight of the document type and the data item type, the question number, the score calculation model and the multi-record matching strategy;
a132, analyzing the test paper data extraction rule according to the relation between the acquired service type and the bill and the data item and the acquired test paper parameters. Specifically, the method comprises the following steps:
obtaining all the questions contained in the test paper through the test paper;
extracting all documents and data items thereof required by the test paper grading through all the questions in the test paper;
and performing union set operation and character string operation on all documents and data items thereof required by the extracted test paper scoring to generate a data extraction rule of the test paper.
In the embodiment, the obtained question parameters and the obtained test paper parameters can be analyzed to obtain an examination paper marking rule, and the obtained examination paper marking rule is used for scoring the examination paper; wherein the scoring rules comprise: all documents related to the test paper and the subject and the weight thereof, and the data items and the weight thereof.
A14, data extraction and compression
A141, title data extraction at the teacher end. The title data of the teacher end is single-subject title data, and the title data includes initial data before the subject is made and answer data after the subject is made.
The single-subject data extraction algorithm is based on the obtained single-subject data extraction rule, extracts all records in the document related to the subject score from an ERP account set, and compresses the records into single-record character strings according to the records so as to be beneficial to online transmission.
If the question has multiple equivalent answers, the teacher can submit the initial data once and submit the answer data for multiple times.
And A142, extracting test paper data of the student end. The student end data is answer data, and is the requirement of students on the subjects in the test paper, after the information operation of all services is completed in ERP software, all records (including initial service data) in the documents related to the test paper grading are extracted from an ERP account set based on the obtained test paper data extraction rule, and are compressed into single record character strings according to the records so as to be beneficial to online transmission.
And A15, sending the single record character string compressed by the teacher end and the single record character string compressed by the student end to the server end for going over the examination papers and feeding back the results.
A16, the server side matches and scores the answer data of the student and the multi-strategy answer data of the teacher according to the marking rule and the multi-record matching strategy, calculates the skill score of the student on the basis, analyzes the skill operation preference of the student, generates a comment and feeds back the score and the comment to the teacher and the student.
In order to verify the effect of the invention, the data extraction method facing the ERP skill online examination paper in this embodiment is applied to the friend using U8V13.0, and experiments show that the account set started in the month of the friend using ERP U8V13.0 has a database file size of 2.5GB before data extraction, and if data extraction and compression are performed on a piece of ordinary ordering business, the initial data file size of the subject is about 1KB (purchase order data in the beginning of the future), the answer data file size is about 2KB (purchase order data in the beginning of the future and the purchase order data filled in the subject), the compression ratio of the answer data is 1:1,250,000, and the compression efficiency of the initial data is higher. Compared with the prior art, the data needing to be transmitted after extraction and compression is less than one millionth of the account set data.
Example two
The invention further provides a specific implementation mode of the data extraction system for the ERP skill online scoring, and the data extraction system for the ERP skill online scoring corresponds to the specific implementation mode of the data extraction method for the ERP skill online scoring, and the data extraction system for the ERP skill online scoring can achieve the purpose of the invention by executing the flow steps in the specific implementation mode of the method, so the explanation in the specific implementation mode of the data extraction method for the ERP skill online scoring is also applicable to the specific implementation mode of the data extraction system for the ERP skill online scoring, which is provided by the invention, and will not be repeated in the following specific implementation modes of the invention.
As shown in fig. 2, an embodiment of the present invention further provides a data extraction system for ERP skill online scoring, including:
the acquiring unit 101 is used for acquiring the relation between the service type and the document and the data item;
the first analyzing unit 102 is configured to acquire a topic parameter, and analyze the relationship between the acquired service type and the document and the acquired data item and the acquired topic parameter to obtain a topic data extraction rule;
the second analysis unit 103 is configured to obtain test paper parameters, and analyze the obtained relationship between the service type and the document and the data item and the obtained test paper parameters to obtain test paper data extraction rules;
the first extraction unit 104 is used for extracting all records in the document related to the subject grading from the ERP account set according to the obtained single-subject data extraction rule, and compressing the records into a single-record character string;
and the second extraction unit 105 is used for extracting all records in the documents related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule, and compressing the records into a single record character string.
The data extraction system for ERP skill online paper marking in the embodiment of the invention obtains the relationship between the service type and the document and the data item; acquiring topic parameters, and analyzing the relationship between the acquired service type and the document and the data item and the acquired topic parameters to obtain a single-topic data extraction rule; acquiring test paper parameters, and analyzing the relation between the acquired service type and the document and the data item and the acquired test paper parameters to obtain test paper data extraction rules; extracting all records in the document related to the subject grading from an ERP account set according to the obtained single-subject data extraction rule, and compressing the records into a single-record character string; and extracting all records in the document related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule, and compressing the records into a single record character string according to the records so as to transmit the compressed single record character string to a server side. Therefore, data are extracted based on the generated data extraction rule and the extracted data are compressed, so that the data transmission quantity and the storage pressure of a server side can be reduced, and the online scoring is facilitated.
In a specific implementation manner of the data extraction system for ERP skill online scoring, the first parsing unit further includes:
the analysis module is used for analyzing the obtained relation between the service type and the receipt and the data item and the obtained question parameter to obtain all receipts and data items related to the marking of the question;
and the composition module is used for composing the data extraction rule of the subject for all the documents and the data items thereof related to the paper marking by using the obtained subject.
In an embodiment of the data extraction system for ERP skill online scoring, the first extraction unit is specifically configured to extract all records in a document related to subject scoring from an ERP account set according to the obtained subject data extraction rule, and compress the records into a single record character string.
In a specific implementation manner of the data extraction system for ERP skill online scoring, the second parsing unit further includes:
the acquisition module is used for acquiring all the questions contained in the test paper;
the extraction module is used for extracting all documents and data items thereof required by the test paper grading through all the single questions in the test paper;
and the generating module is used for performing union set operation and character string operation on all the documents and data items thereof required by the extracted test paper scoring to generate a data extraction rule of the test paper.
In a specific implementation of the above data extraction system for ERP skill online scoring, the system further includes:
and the first sending unit is used for sending the compressed single record character string to a server for scoring by marking, wherein the record is a record in a document related to the scoring of the title, which is extracted from an ERP account set.
And the second sending unit is used for sending the compressed single record character string to a server for scoring by paper marking, wherein the record is a record in a document related to the scoring of the test paper extracted from the ERP account set.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions.
While the foregoing is directed to the preferred embodiment of the present invention, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention as defined in the appended claims.
Claims (10)
1. A data extraction method facing ERP skill online scoring is characterized by comprising the following steps:
acquiring the relation between the service type and the document and the data item;
acquiring topic parameters, and analyzing the relationship between the acquired service type and the document and the data item and the acquired topic parameters to obtain a single-topic data extraction rule;
acquiring test paper parameters, and analyzing the relation between the acquired service type and the document and the data item and the acquired test paper parameters to obtain test paper data extraction rules;
extracting all records in the document related to the subject grading from an ERP account set according to the obtained single-subject data extraction rule, and compressing the records into a single-record character string;
and extracting all records in the documents related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule, and compressing the records into single record character strings according to the records.
2. The ERP skill online scoring-oriented data extraction method as claimed in claim 1, wherein the analyzing the relationship between the obtained business type and the document and the data item and the obtained subject parameter to obtain the subject data extraction rule comprises:
analyzing the relation between the obtained service type and the documents and the data items and the obtained subject parameters to obtain all documents and data items related to the examination paper facing to the subject;
and forming a data extraction rule of the subject by using the obtained subject oriented to all the documents and the data items thereof related to the paper marking.
3. The data extraction method for ERP skill online scoring as claimed in claim 2, wherein the extracting all records in the document related to the topic score from the ERP account book according to the obtained topic data extraction rule comprises:
and extracting all records in the document related to the subject grading from the ERP account set according to the obtained data extraction rule of the subject, and compressing the records into a single record character string.
4. The data extraction method for ERP skill online scoring as claimed in claim 1, wherein the analyzing the relationship between the obtained business type and the document and the data item and the obtained test paper parameters to obtain the test paper data extraction rule comprises:
acquiring all the single questions contained in the test paper;
extracting all documents and data items thereof required by the test paper grading through all the questions in the test paper;
and performing union set operation and character string operation on all documents and data items thereof required by the extracted test paper scoring to generate a data extraction rule of the test paper.
5. The data extraction method for ERP skill online scoring as claimed in claim 1, wherein after compressing into a single record string by record, the method further comprises:
and sending the single record character string obtained by compression to a server for scoring by going over the paper.
6. A data extraction system facing ERP skill online scoring is characterized by comprising:
the acquiring unit is used for acquiring the relation between the service type and the document and the data item;
the first analysis unit is used for acquiring the topic parameters, analyzing the relationship between the acquired service type and the document and the acquired data item and the acquired topic parameters, and acquiring a single-topic data extraction rule;
the second analysis unit is used for acquiring the test paper parameters, analyzing the relationship between the acquired service type and the receipt and the data items and the acquired test paper parameters, and acquiring test paper data extraction rules;
the first extraction unit is used for extracting all records in the document related to the subject grading from the ERP account set according to the obtained single-subject data extraction rule and compressing the records into a single-record character string;
and the second extraction unit is used for extracting all records in the document related to the test paper grading from the ERP account set according to the obtained test paper data extraction rule and compressing the records into single record character strings according to the records.
7. The ERP skill online scoring-oriented data extraction system as claimed in claim 6, wherein the first parsing unit comprises:
the analysis module is used for analyzing the obtained relation between the service type and the receipt and the data item and the obtained question parameter to obtain all receipts and data items related to the marking of the question;
and the composition module is used for composing the data extraction rule of the subject for all the documents and the data items thereof related to the paper marking by using the obtained subject.
8. The data extraction system for ERP skill online scoring as claimed in claim 7, wherein the first extraction unit is specifically configured to extract all records in the document related to the subject scoring from the ERP account set according to the obtained data extraction rule of the subject, and compress the records into a single record character string.
9. The ERP skill online scoring-oriented data extraction system as claimed in claim 6, wherein the second parsing unit comprises:
the acquisition module is used for acquiring all the questions contained in the test paper;
the extraction module is used for extracting all documents and data items thereof required by the test paper grading through all the single questions in the test paper;
and the generating module is used for performing union set operation and character string operation on all the documents and data items thereof required by the extracted test paper scoring to generate a data extraction rule of the test paper.
10. The ERP skill online scoring-oriented data extraction system as claimed in claim 6, wherein the system further comprises:
the first sending unit is used for sending the single record character string compressed by the first extracting unit to the server for scoring by going over the paper;
and the second sending unit is used for sending the single record character string compressed by the second extraction unit to the server for scoring the paper marking.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810076843.8A CN108256829B (en) | 2018-01-26 | 2018-01-26 | ERP skill online scoring oriented data extraction method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810076843.8A CN108256829B (en) | 2018-01-26 | 2018-01-26 | ERP skill online scoring oriented data extraction method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108256829A CN108256829A (en) | 2018-07-06 |
| CN108256829B true CN108256829B (en) | 2020-07-31 |
Family
ID=62742276
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810076843.8A Active CN108256829B (en) | 2018-01-26 | 2018-01-26 | ERP skill online scoring oriented data extraction method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108256829B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103903082A (en) * | 2012-12-28 | 2014-07-02 | 航天信息软件技术有限公司 | Method for generating accounting documents by means of receipt data in ERP system |
| CN104778258A (en) * | 2015-04-21 | 2015-07-15 | 华中科技大学 | Data extraction method oriented to protocol dataflow |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2003046779A1 (en) * | 2001-11-26 | 2003-06-05 | Basf Aktiengesellschaft | Method and device for the computer-implemented evaluation of client business processes |
-
2018
- 2018-01-26 CN CN201810076843.8A patent/CN108256829B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103903082A (en) * | 2012-12-28 | 2014-07-02 | 航天信息软件技术有限公司 | Method for generating accounting documents by means of receipt data in ERP system |
| CN104778258A (en) * | 2015-04-21 | 2015-07-15 | 华中科技大学 | Data extraction method oriented to protocol dataflow |
Non-Patent Citations (1)
| Title |
|---|
| 会计电算化考试系统的设计与实现;王珠强等;《会计之友(中旬刊)》;20090715(第07期);第87-89页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108256829A (en) | 2018-07-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Shishlov et al. | Compliance of the Parties to the Kyoto Protocol in the first commitment period | |
| CN109559210A (en) | Based on big data and the book keeping operation of the artificial intelligence of cloud computing and method of declaring dutiable goods automatically | |
| Yashin et al. | Designing entrepreneurial education in Russia: hard and soft skills | |
| Afolabi et al. | E-maturity of construction stakeholders for a web-based e-procurement platform in the construction industry | |
| Albrecht et al. | Forensic accounting | |
| KR20210082693A (en) | Learning solution system | |
| Parlier et al. | Inventory analytics: A teaching case using excel and Alteryx | |
| Masanet et al. | Reflections on a massive open online life cycle assessment course | |
| Alter | Service responsibility tables: A new tool for analyzing and designing systems | |
| Ismail | OBACIS: Outcome based analytics and continuous improvement system | |
| CN108256829B (en) | ERP skill online scoring oriented data extraction method and system | |
| Amadio et al. | Data analytics and the cash collections process: An adaptable case employing excel and tableau | |
| Junejo et al. | Quality of experience assessment of banking service | |
| Kopishynska et al. | Professionaloriented training of specialists under implementation of cloud computing information systems in cooperation between universities and IT companies | |
| CN102663555A (en) | Health evaluation objective structuralized clinical exam system and operation method thereof | |
| CN106683011A (en) | Exam and training system based on banking services | |
| Nordin et al. | Applying the work systems method to investigate the operational efficiency of the halal certification system | |
| CN108364244B (en) | ERP skill automatic scoring method and device based on multi-record matching | |
| Awosejo et al. | Recommendation of information systems to motivate accounting firm in South Africa | |
| CN111209588A (en) | Teaching and cultivating management method and system based on block chain | |
| CN108269022A (en) | A kind of ERP technical ability automatic assessment method and device for supporting more policing actions | |
| CN111177283A (en) | Intelligent personnel model construction method and device based on reinforcement learning | |
| Cusumano et al. | Intelligent building contract tendering-potential and exploration | |
| Pirius | A Data‐Driven Approach to SEM Development at a Two‐Year College | |
| Kusumawati | Implementation of Total Quality Management (TQM) TKQ Education Bogor District |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |