CN115017175A - Multi-user data processing method and system for teaching - Google Patents

Multi-user data processing method and system for teaching Download PDF

Info

Publication number
CN115017175A
CN115017175A CN202210532454.8A CN202210532454A CN115017175A CN 115017175 A CN115017175 A CN 115017175A CN 202210532454 A CN202210532454 A CN 202210532454A CN 115017175 A CN115017175 A CN 115017175A
Authority
CN
China
Prior art keywords
user
sql
task
sql script
teaching
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.)
Granted
Application number
CN202210532454.8A
Other languages
Chinese (zh)
Other versions
CN115017175B (en
Inventor
李萍
单震
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Chaozhou Zhuoshu Big Data Industry Development Co Ltd
Original Assignee
Chaozhou Zhuoshu Big Data Industry Development Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Chaozhou Zhuoshu Big Data Industry Development Co Ltd filed Critical Chaozhou Zhuoshu Big Data Industry Development Co Ltd
Priority to CN202210532454.8A priority Critical patent/CN115017175B/en
Publication of CN115017175A publication Critical patent/CN115017175A/en
Application granted granted Critical
Publication of CN115017175B publication Critical patent/CN115017175B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a multi-user data processing method and a system for teaching, which relate to the technical field of big data management; the method comprises the steps of limiting user processing permission according to user roles, defining corresponding SQL statement parameters according to the user processing permission, wherein the user roles comprise teachers and students, each role comprises a plurality of users, each user limits the user processing permission according to the user roles, each user only creates and defines own SQL statement parameters, defining corresponding SQL script tasks according to the SQL statement parameters, starting corresponding SQL script task execution processes through triggering events or timing tasks, generating execution logs and execution results, and displaying the SQL script tasks in a list through instance monitoring.

Description

Multi-user data processing method and system for teaching
Technical Field
The invention discloses a method and a system, relates to the technical field of big data management, and particularly relates to a teaching-oriented multi-user data processing method and a teaching-oriented multi-user data processing system.
Background
With the internet entering the big data era, data has penetrated into every industry and business field at present, and data processing is a process of carrying out resource treatment on original data and is a precondition for marketization of data elements. At present, the teaching needs to be matched with the teaching on line and off line to deal with the sudden situation. On-line teaching is to organize teaching and bidirectional interaction by taking classes and the like as units, mainly record and broadcast courses and adopt the forms of recording, broadcasting and answering questions on line. The guidance after class can adopt the modes of on-demand or on-line answering and the like.
And the development of online teaching sometimes causes the conditions of incomplete user data conversion and filtration, error data, repeated data and the like.
Disclosure of Invention
The invention provides a multi-user data processing method and a multi-user data processing system for teaching aiming at the problems in the prior art, and aims to support the development of on-line and off-line teaching, limit the processing authority of a user through the multi-user data processing system for teaching and realize the soft isolation of data resources.
The specific scheme provided by the invention is as follows:
the invention provides a multi-user data processing method facing teaching, which limits user processing authority according to user roles, defines corresponding SQL statement parameters according to the user processing authority, wherein the user roles comprise teachers and students, each role comprises a plurality of users, each user limits the user processing authority according to the user roles, each user only creates the SQL statement parameters defining the user,
defining corresponding SQL script task by using SQL statement parameters, starting corresponding SQL script task execution flow by triggering event or timing task to generate execution log and execution result,
and performing list display on the SQL script tasks through example monitoring.
Furthermore, in the teaching-oriented multi-user data processing method, the front end is used for defining corresponding SQL statement parameters and corresponding SQL script tasks, and list display is carried out on the SQL script tasks through example monitoring.
Further, the defining of the corresponding SQL statement parameter in the teaching-oriented multi-user data processing method includes:
and performing parameter management on corresponding SQL statement parameters, wherein the parameter management comprises the management of parameter addition, parameter search, parameter editing and parameter deletion.
Further, in the teaching-oriented multi-user data processing method, defining a corresponding SQL script task by using SQL statement parameters includes:
acquiring and screening data of corresponding database table, editing and storing SQL script according to the screened data and SQL statement parameters,
and releasing the SQL script task.
Further, before the starting of the corresponding SQL script task execution flow in the multi-user data processing method for teaching, the method includes:
and confirming the data table for executing the SQL, wherein the table name in the SQL is extracted and matched with the user processing authority, and only the data table which is created or distributed by the user authority can be executed according to the user role.
Further, the method for processing multi-user data oriented to teaching, in which the timed task starts a corresponding SQL script task execution flow, includes:
the corresponding SQL script tasks are executed at fixed times of the day, week, or month or at fixed intervals.
Further, in the teaching-oriented multi-user data processing method, the performing of list display on the SQL script tasks through instance monitoring includes:
and searching the SQL script task, and displaying a list according to a search result.
The invention also provides a multi-user data processing system facing teaching, which comprises an SQL script task management module and a display module,
the SQL script task management module limits the user processing authority according to the user roles, defines corresponding SQL statement parameters according to the user processing authority, wherein the user roles comprise teachers and students, each role comprises a plurality of users, each user limits the user processing authority according to the user roles, each user only creates and defines the SQL statement parameters of the user,
defining corresponding SQL script task by using SQL statement parameter, starting corresponding SQL script task execution flow by triggering event or timing task, generating execution log and execution result,
and the display module performs list display on the SQL script tasks through example monitoring.
The invention has the advantages that:
the invention provides a multi-user data processing method facing teaching, which limits user processing permission according to user roles, defines corresponding SQL statement parameters according to the user processing permission, reduces the error frequency of the SQL statement parameters, reduces the compiling complexity of SQL statements, defines corresponding SQL script tasks by using the SQL statement parameters, starts corresponding SQL script task execution flows by triggering events or timing tasks, generates execution logs and execution results, improves the accuracy of SQL scripts, simplifies the SQL script execution flows, and reduces the situations of incomplete conversion and filtration, error data, repeated data and the like. And SQL script task list display can be carried out through instance monitoring, and the user can conveniently check the SQL script task list.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
FIG. 1 is a schematic flow diagram of the process of the present invention.
Detailed Description
The present invention is further described below in conjunction with the following figures and specific examples so that those skilled in the art may better understand the present invention and practice it, but the examples are not intended to limit the present invention.
The invention provides a multi-user data processing method facing teaching, which limits user processing authority according to user roles, defines corresponding SQL statement parameters according to the user processing authority, wherein the user roles comprise teachers and students, each role comprises a plurality of users, each user limits the user processing authority according to the user roles, each user only creates the SQL statement parameters defining the user role,
defining corresponding SQL script task by using SQL statement parameter, starting corresponding SQL script task execution flow by triggering event or timing task, generating execution log and execution result,
and performing list display on the SQL script tasks through example monitoring.
The method defines parameters in the SQL task and provides data standardized parameter unified configuration management service; defining SQL script tasks, which can contain parameters from parameter definition process; triggering a task execution process by clicking an event or a timing task to generate an execution log and an execution result; and displaying the task execution result in the example monitoring flow.
In a specific application, in some embodiments of the method of the present invention, the front end may be used to define corresponding SQL statement parameters and corresponding SQL script tasks, and list display may be performed on the SQL script tasks through instance monitoring.
Specifically, SQL statement parameter definition is carried out by utilizing a front end, user processing permission is limited according to user roles, corresponding SQL statement parameters are defined according to the user processing permission, wherein the user roles comprise teachers and students, each role comprises a plurality of users, each user limits the user processing permission according to the user roles, each user only creates the SQL statement parameters defining the user role,
SQL statement parameters are defined, the table names to be processed are regularly checked to change every month, the error frequency of the SQL statement parameters is reduced, and the compiling complexity of the SQL statements is reduced. And when managing the parameters, the management of parameter addition, parameter search, parameter editing and parameter deletion is provided.
Further, when the SQL script task definition is carried out,
screening a database table, realizing three-level selection of the database, a mode and a table through a pull-down menu, searching according to names, and prompting the name and the field type of a field at the table level;
editing scripts, providing an SQL editing frame and displaying line numbers; clicking a table or a field in the left navigation menu bar, and automatically inserting the table or the field into the SQL; clicking the upper parameter button, and automatically inserting the upper parameter button into the SQL edit box; clicking an emptying button to empty all task data and execution result data; a formatting button is clicked, and formatting can be carried out; the table name and the field name are clicked, so that the table name and the field name can be copied;
saving the script, saving or updating the task, and also comprising the timing information of the task;
and the scripts are issued, a teacher can check script tasks issued by students, and the students can check script samples issued by the teacher.
Further, when the SQL script task is executed, the following steps can be immediately executed: clicking "execute" on the task definition page or on the task list page, executing immediately,
the following steps can be executed regularly: clicking a 'timing' button on a task list page, popping up a timing task configuration page, wherein the timing task comprises a timing task and an interval task, the timing task is executed at fixed time every day, every week and every month, the interval task is executed at set execution time and is executed at intervals, and the task is stopped: the user may click the stop button to stop,
and (3) executing the authority: before execution, the table name in SQL is extracted and matched with the data authority table of the user, and both teachers and students can only execute the data table created or distributed by themselves.
Further, when a task execution result is displayed in the example monitoring process, searching of SQL script tasks is provided through example monitoring, and the running/completed tasks are searched from the starting and ending time, the execution result, the task name, the data source and the like; and providing task list display of running/finished tasks, displaying information such as execution progress, trigger type, success/failure number, starting and finishing time and the like, and clicking to jump to a log detail page to display basic information of the tasks and display task execution logs. The teacher can check the execution condition of the tasks published by the student, and the student can also check the execution condition of the tasks published by the teacher.
The invention also provides a multi-user data processing device facing teaching, which comprises an SQL script task management module and a display module,
the SQL script task management module limits the user processing authority according to the user roles, defines corresponding SQL statement parameters according to the user processing authority, wherein the user roles comprise teachers and students, each role comprises a plurality of users, each user limits the user processing authority according to the user roles, each user only creates and defines the SQL statement parameters of the user,
defining corresponding SQL script task by using SQL statement parameter, starting corresponding SQL script task execution flow by triggering event or timing task, generating execution log and execution result,
and the display module performs list display on the SQL script tasks through example monitoring.
The information interaction, execution process and other contents between the modules in the system are based on the same concept as the method embodiment of the present invention, and specific contents can be referred to the description in the method embodiment of the present invention, and are not described herein again.
Similarly, the system can limit the user processing authority according to the user role, define corresponding SQL statement parameters according to the user processing authority, reduce the error frequency of the SQL statement parameters, reduce the compiling complexity of the SQL statement, define corresponding SQL script tasks by using the SQL statement parameters, start the execution flow of the corresponding SQL script tasks by triggering events or timing tasks, generate execution logs and execution results, improve the accuracy of the SQL script, simplify the execution flow of the SQL script, and reduce the conditions of incomplete conversion and filtration, error data, repeated data and the like. And SQL script task list display can be carried out through instance monitoring, and the user can conveniently check the SQL script task list.
It should be noted that not all steps and modules in the above flows and system structures are necessary, and some steps or modules may be omitted according to actual needs. The execution order of the steps is not fixed and can be adjusted as required. The system structure described in the above embodiments may be a physical structure or a logical structure, that is, some modules may be implemented by the same physical entity, or some modules may be implemented by a plurality of physical entities, or some components in a plurality of independent devices may be implemented together.
The above-mentioned embodiments are merely preferred embodiments for fully illustrating the present invention, and the scope of the present invention is not limited thereto. The equivalent substitution or change made by the technical personnel in the technical field on the basis of the invention is all within the protection scope of the invention. The protection scope of the invention is subject to the claims.

Claims (8)

1. A multi-user data processing method facing teaching is characterized in that user processing authority is limited according to user roles, corresponding SQL statement parameters are defined according to the user processing authority, wherein the user roles comprise teachers and students, each role comprises a plurality of users, each user limits the user processing authority according to the user roles, each user only creates the SQL statement parameters defining the user role,
defining corresponding SQL script task by using SQL statement parameter, starting corresponding SQL script task execution flow by triggering event or timing task, generating execution log and execution result,
and performing list display on the SQL script tasks through example monitoring.
2. The multi-user teaching-oriented data processing method according to claim 1, wherein the front end is used to define corresponding SQL statement parameters and corresponding SQL script tasks, and the list display of the SQL script tasks is performed by instance monitoring.
3. The multi-user teaching-oriented data processing method according to claim 1, wherein the defining of the corresponding SQL statement parameters comprises:
and performing parameter management on corresponding SQL statement parameters, wherein the parameter management comprises the management of parameter addition, parameter search, parameter editing and parameter deletion.
4. The multi-user teaching-oriented data processing method according to claim 1, wherein the defining of the corresponding SQL script task using SQL statement parameters comprises:
acquiring and screening data of corresponding database table, editing and storing SQL script according to the screened data and SQL statement parameters,
and releasing the SQL script task.
5. The multi-user data processing method for teaching according to claim 1, wherein before said starting the execution flow of the corresponding SQL script task, it comprises:
and confirming the data table for executing the SQL, wherein the table name in the SQL is extracted and matched with the user processing authority, and only the data table created or distributed by the user authority can be executed according to the user role.
6. The multi-user data processing method for teaching according to claim 1, wherein the timed task starts a corresponding SQL script task execution flow, comprising:
the corresponding SQL script tasks are executed at fixed times of the day, week, or month or at fixed intervals.
7. The multi-user teaching-oriented data processing method according to claim 1, wherein the list presentation of SQL script tasks by instance monitoring comprises:
and searching the SQL script task, and displaying a list according to a search result.
8. A multi-user data processing system facing teaching is characterized by comprising an SQL script task management module and a display module,
the SQL script task management module limits the user processing authority according to the user roles, defines corresponding SQL statement parameters according to the user processing authority, wherein the user roles comprise teachers and students, each role comprises a plurality of users, each user limits the user processing authority according to the user roles, each user only creates and defines the SQL statement parameters of the user,
defining corresponding SQL script task by using SQL statement parameter, starting corresponding SQL script task execution flow by triggering event or timing task, generating execution log and execution result,
and the display module performs list display on the SQL script tasks through example monitoring.
CN202210532454.8A 2022-05-12 2022-05-12 Teaching-oriented multi-user data processing method and system Active CN115017175B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210532454.8A CN115017175B (en) 2022-05-12 2022-05-12 Teaching-oriented multi-user data processing method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210532454.8A CN115017175B (en) 2022-05-12 2022-05-12 Teaching-oriented multi-user data processing method and system

Publications (2)

Publication Number Publication Date
CN115017175A true CN115017175A (en) 2022-09-06
CN115017175B CN115017175B (en) 2023-07-14

Family

ID=83068310

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210532454.8A Active CN115017175B (en) 2022-05-12 2022-05-12 Teaching-oriented multi-user data processing method and system

Country Status (1)

Country Link
CN (1) CN115017175B (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080193908A1 (en) * 2007-02-08 2008-08-14 James Wang Faculty workstation
CN108509807A (en) * 2018-04-13 2018-09-07 南京新贝金服科技有限公司 A kind of the table data authority control system and method for based role
CN111400681A (en) * 2020-04-07 2020-07-10 杭州指令集智能科技有限公司 Data permission processing method, device and equipment

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080193908A1 (en) * 2007-02-08 2008-08-14 James Wang Faculty workstation
CN108509807A (en) * 2018-04-13 2018-09-07 南京新贝金服科技有限公司 A kind of the table data authority control system and method for based role
CN111400681A (en) * 2020-04-07 2020-07-10 杭州指令集智能科技有限公司 Data permission processing method, device and equipment

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
乔冰琴: "《网络数据库》", 上海：上海财经大学出版社, pages: 399 - 400 *

Also Published As

Publication number Publication date
CN115017175B (en) 2023-07-14

Similar Documents

Publication Publication Date Title
Cubranic et al. Hipikat: Recommending pertinent software development artifacts
US10691584B2 (en) Behavior driven development integration with test tool
US5634121A (en) System for identifying and linking domain information using a parsing process to identify keywords and phrases
US6360332B1 (en) Software system and methods for testing the functionality of a transactional server
US7581212B2 (en) Method and system for conversion of automation test scripts into abstract test case representation with persistence
US8881105B2 (en) Test case manager
US7478365B2 (en) Method and system for rule-based generation of automation test scripts from abstract test case representation
US20060184918A1 (en) Test manager
US20030221186A1 (en) Descriptive variables while debugging
CN113537943A (en) Universal workflow engine and construction method thereof
Amalfitano et al. Using dynamic analysis for generating end user documentation for web 2.0 applications
CN115017175A (en) Multi-user data processing method and system for teaching
CN108766513B (en) Intelligent health medical data structured processing system
Zhang et al. Research of web front-end engineering solution in public cultural service project
Ballard et al. IBM infosphere streams: accelerating deployments with analytic accelerators
Dhakal et al. Library Tweets Conversion
CN113051262A (en) Data quality inspection method, device, equipment and storage medium
WO2005089350A2 (en) Custom database system and method of building the same
CN111309306B (en) Man-machine interaction dialogue management system
JP3290778B2 (en) Trouble analysis support device
US20230035835A1 (en) System and method of a modular framework for configuration and reuse of web components
EP4224335A1 (en) Database management methods and associated apparatus
US20220244975A1 (en) Method and system for generating natural language content from recordings of actions performed to execute workflows in an application
US20220269503A1 (en) Methods and systems for auto creation of software component reference guide from multiple information sources
Sonnleitner et al. Persistence of workflow control data in temporal databases

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