CN115017175B - Teaching-oriented multi-user data processing method and system - Google Patents
Teaching-oriented multi-user data processing method and system Download PDFInfo
- Publication number
- CN115017175B CN115017175B CN202210532454.8A CN202210532454A CN115017175B CN 115017175 B CN115017175 B CN 115017175B CN 202210532454 A CN202210532454 A CN 202210532454A CN 115017175 B CN115017175 B CN 115017175B
- Authority
- CN
- China
- Prior art keywords
- user
- sql
- sql script
- parameter
- task
- 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
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
Abstract
The invention discloses a teaching-oriented multi-user data processing method and system, and relates to the technical field of big data management; limiting user processing permission according to user roles, defining corresponding SQL sentence parameters according to the user processing permission, wherein each user role comprises a teacher 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 SQL sentence parameters defining the user, defines corresponding SQL script tasks by using the SQL sentence parameters, starts corresponding SQL script task execution flow by triggering events or timing tasks, generates execution logs and execution results, and performs list display on the SQL script tasks by instance monitoring.
Description
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
As the internet enters a big data age, data has penetrated into every industry and business field nowadays, and data processing is a process of carrying out resource treatment on original data and is also a precondition for market of data elements. At present, in order to cope with emergency, online and offline cooperation teaching is required for teaching. The on-line teaching is to organize lectures and bidirectional interaction by taking class and the like as units, mainly recording and broadcasting the lectures, and adopting a form of recording, broadcasting and on-line answering. The teaching after class can be in the form of on-demand or on-line answering.
On-line teaching is performed, and situations such as incomplete conversion and filtration of user data, error data, repeated data and the like sometimes occur.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a multi-user data processing method and a system for teaching, which are used for supporting the development of online and offline teaching, and the processing authority of a user is limited by the multi-user data processing system for teaching, so that the soft isolation of data resources is realized.
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 sentence 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 SQL sentence parameters defining the user,
defining corresponding SQL script task by SQL sentence 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 instance monitoring.
Furthermore, in the teaching-oriented multi-user data processing method, the front end is utilized to define corresponding SQL sentence parameters, define corresponding SQL script tasks, and list and display the SQL script tasks through instance monitoring.
Further, in the teaching-oriented multi-user data processing method, the defining corresponding SQL statement parameters includes:
and carrying out parameter management on the corresponding SQL sentence parameters, wherein the parameter management comprises management of parameter addition, parameter searching, parameter editing and parameter deleting.
Further, in the teaching-oriented multi-user data processing method, the defining the corresponding SQL script task by using the SQL statement parameter includes:
acquiring and screening data of the corresponding database table, editing SQL script according to the screened data and SQL sentence parameters and storing,
and publishing SQL script tasks.
Further, before the corresponding SQL script task execution flow is started, the teaching-oriented multi-user data processing 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 with the user authority can be executed according to the user role.
Further, in the teaching-oriented multi-user data processing method, the timing task starts a corresponding SQL script task execution flow, including:
the corresponding SQL script tasks are executed at regular intervals daily, weekly or monthly.
Further, in the teaching-oriented multi-user data processing method, the list display of the SQL script task through the instance monitoring includes:
searching the SQL script task, and displaying a list according to the search result.
The invention also provides a multi-user data processing system oriented to 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 sentence 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 sentence parameters defining the user,
defining corresponding SQL script task by SQL sentence 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 instance monitoring.
The invention has the advantages that:
the invention provides a multi-user data processing method oriented to teaching, which limits user processing permission according to user roles, defines corresponding SQL sentence parameters according to the user processing permission, reduces the error frequency of the SQL sentence parameters, reduces the writing complexity of SQL sentences, utilizes the SQL sentence parameters to define corresponding SQL script tasks, starts corresponding SQL script task execution flows through 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 conditions of incomplete conversion and filtration, error data, repeated data and the like. And the SQL script task list can be displayed through instance monitoring, so that the user can check conveniently.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic flow chart of the method of the invention.
Detailed Description
The present invention will be further described with reference to the accompanying drawings and specific examples, which are not intended to be limiting, so that those skilled in the art will better understand the invention and practice it.
The invention provides a multi-user data processing method facing teaching, which limits user processing authority according to user roles, defines corresponding SQL sentence 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 SQL sentence parameters defining the user,
defining corresponding SQL script task by SQL sentence 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 instance monitoring.
The method defines parameters in the SQL task and provides unified configuration management service for data standardization parameters; defining SQL script tasks, which may contain parameters from a parameter definition flow; triggering a task execution flow 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 specific applications, in some embodiments of the method of the present invention, the front end may be used to define corresponding SQL statement parameters, define corresponding SQL script tasks, and perform list display on the SQL script tasks through instance monitoring.
Specifically, the front end is utilized to define SQL sentence parameters, user processing permission is limited according to user roles, corresponding SQL sentence 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 SQL sentence parameters defining the user,
and defining SQL sentence parameters, and regularly checking that the table names to be processed change every month, so that the error frequency of the SQL sentence parameters is reduced, and the writing complexity of the SQL sentence is reduced. And when the parameters are managed, management of parameter addition, parameter searching, parameter editing and parameter deleting is provided.
Further, when the SQL script task definition is performed,
screening a database table, realizing three-level selection of a database-mode-table through a drop-down menu, searching according to names, and prompting names and field types of fields at a table level;
script editing, namely providing an SQL editing frame and displaying a line number; clicking a table or a field in a left navigation menu bar, and automatically inserting the table or the field into SQL; clicking the parameter button above, and automatically inserting the parameter button into the SQL editing frame; clicking a clearing button to clear all task data and execution result data; clicking a format button to enable formatting; clicking the table name and the field name can copy the table name and the field name;
the script stores, stores or updates the task and also comprises the timing information of the task;
script release, teacher can look over the script task that the student released, and the student also can look over script sample that the teacher released.
Further, when the SQL script task is executed, the SQL script task can be immediately executed: clicking on "execute" on the task definition page or on the task list page, executing immediately,
the timing may be performed: clicking a 'timing' button on a task list page, and 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 of each day, each week and each month, the interval task is executed at fixed execution time, and the interval task is executed at intervals, and the task is stopped: the user may click the "stop" button to stop,
executing permission: the table names in SQL are extracted before execution, and are matched with the data authority tables of users, so that teachers and students can only execute the data tables which are created or distributed by themselves.
Further, when the task execution result is displayed in the instance monitoring flow, searching for the running/completed task is performed by instance monitoring, wherein searching for the SQL script task is provided, and searching for the running/completed task is performed from the starting and ending time, the execution result, the task name, the data source and the like; the method comprises the steps of providing task list display of running/finished tasks, displaying information such as execution progress, trigger type, success/failure number, start and finish time, and clicking and jumping 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 issued by the students, and the students can also check the execution condition of the tasks issued 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 sentence 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 sentence parameters defining the user,
defining corresponding SQL script task by SQL sentence 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 instance monitoring.
The content of information interaction and execution process between the modules in the system is based on the same concept as the method embodiment of the present invention, and specific content can be referred to the description in the method embodiment of the present invention, which is not repeated here.
Similarly, the system can limit the user processing permission according to the user role, define the corresponding SQL sentence parameter according to the user processing permission, reduce the error frequency of the SQL sentence parameter, reduce the writing complexity of the SQL sentence, define the corresponding SQL script task by using the SQL sentence parameter, and start the corresponding SQL script task execution flow by triggering the event or the timing task to generate the execution log and the execution result, thereby improving the accuracy of the SQL script, simplifying the SQL script execution flow, and reducing the conditions of incomplete conversion and filtration, error data, repeated data and the like. And the SQL script task list can be displayed through instance monitoring, so that the user can check conveniently.
It should be noted that not all the steps and modules in the above processes and the system structures are necessary, and some steps or modules may be omitted according to actual needs. The execution sequence 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 multiple physical entities, or may be implemented jointly by some components in multiple independent devices.
The above-described embodiments are merely preferred embodiments for fully explaining the present invention, and the scope of the present invention is not limited thereto. Equivalent substitutions and modifications will occur to those skilled in the art based on the present invention, and are intended to be within the scope of the present invention. The protection scope of the invention is subject to the claims.
Claims (2)
1. A multi-user data processing method facing teaching is characterized in that user processing permission is limited according to user roles, corresponding SQL sentence parameters are defined according to the user processing permission, wherein each user role comprises a teacher 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 SQL sentence parameters defining the user, and the corresponding SQL sentence parameters are defined by the steps of: performing parameter management on corresponding SQL sentence parameters, wherein the parameter management comprises management of parameter addition, parameter searching, parameter editing and parameter deleting;
defining corresponding SQL script tasks by using SQL sentence parameters, including: acquiring and screening data of the corresponding database table, editing and storing SQL script according to the screened data and SQL sentence parameters, issuing SQL script tasks,
confirming the data table for executing SQL, wherein the table name in SQL is extracted to match with the user processing authority, only the data table which is created or distributed by the user authority can be executed according to the user role,
starting a corresponding SQL script task execution flow through a triggering event or a timing task, comprising: the corresponding SQL script tasks are executed at a fixed time every day, every week or every month or at fixed intervals,
an execution log and an execution result are generated,
the front end is utilized to define corresponding SQL sentence parameters and corresponding SQL script tasks,
list presentation of SQL script tasks by instance monitoring, comprising: searching the SQL script task, and displaying a list according to the search result.
2. A multi-user data processing system for teaching is characterized by comprising an SQL script task management module and a display module,
the SQL script task management module limits user processing permission according to user roles and defines corresponding SQL sentence parameters according to the user processing permission, wherein each user role comprises a teacher 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 sentence parameters defining the user, and the SQL script task management module defines the corresponding SQL sentence parameters and comprises: performing parameter management on corresponding SQL sentence parameters, wherein the parameter management comprises management of parameter addition, parameter searching, parameter editing and parameter deleting;
the SQL script task management module defines a corresponding SQL script task by utilizing SQL sentence parameters, and comprises the following steps: acquiring and screening data of the corresponding database table, editing and storing SQL script according to the screened data and SQL sentence parameters, issuing SQL script tasks,
the SQL script task management module confirms the data table for executing SQL, wherein the table name in SQL is extracted and matched with the user processing authority, the data table which is created or distributed according to the user authority can only be executed according to the user role,
the SQL script task management module starts a corresponding SQL script task execution flow through a triggering event or a timing task, and comprises the following steps: the corresponding SQL script tasks are executed at a fixed time every day, every week or every month or at fixed intervals,
the SQL script task management module generates an execution log and an execution result,
the SQL script task management module utilizes the front end to define corresponding SQL sentence parameters and corresponding SQL script tasks,
the display module performs list display on SQL script tasks through instance monitoring, and comprises the following steps:
searching the SQL script task, and displaying a list according to the search result.
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 CN115017175A (en) | 2022-09-06 |
| CN115017175B true 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 (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080193908A1 (en) * | 2007-02-08 | 2008-08-14 | James Wang | Faculty workstation |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108509807A (en) * | 2018-04-13 | 2018-09-07 | 南京新贝金服科技有限公司 | A kind of the table data authority control system and method for based role |
| CN111400681B (en) * | 2020-04-07 | 2023-09-12 | 杭州指令集智能科技有限公司 | Data authority processing method, device and equipment |
-
2022
- 2022-05-12 CN CN202210532454.8A patent/CN115017175B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080193908A1 (en) * | 2007-02-08 | 2008-08-14 | James Wang | Faculty workstation |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115017175A (en) | 2022-09-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9542447B1 (en) | Supplementing candidate answers | |
| US10691584B2 (en) | Behavior driven development integration with test tool | |
| US9047346B2 (en) | Reporting language filtering and mapping to dimensional concepts | |
| US5634121A (en) | System for identifying and linking domain information using a parsing process to identify keywords and phrases | |
| US20050154993A1 (en) | Automatic reference note generator | |
| CN102521316A (en) | Pattern matching framework for log analysis | |
| CN107480009A (en) | A kind of transaction recovery method and device | |
| CN109299074A (en) | A kind of data verification method and system based on templating data base view | |
| US9244707B2 (en) | Transforming user interface actions to script commands | |
| CN115017175B (en) | Teaching-oriented multi-user data processing method and system | |
| CN109614594A (en) | A method of topic document is resolved into exam pool data | |
| Taylor | JDBC developer's resource | |
| Sewell et al. | The software architect's profession: an introduction | |
| CN108766513B (en) | Intelligent health medical data structured processing system | |
| Siddaway | PowerShell and WMI | |
| Sneed et al. | Reverse engineering a visual age application | |
| Ilie et al. | Semantic logging in a distributed multi-agent system | |
| US11831490B1 (en) | Systems, methods, and media for performing information technology service management correlation for infrastructure environment functions | |
| Ojo | Modelling and Implementation of a Result Processing System | |
| US20220244975A1 (en) | Method and system for generating natural language content from recordings of actions performed to execute workflows in an application | |
| WO2018091662A1 (en) | Method for creating and/or changing a collection of data sets for a dialog-guided technical aid for support in the creation and/or changing of data-processing programs or database entries | |
| Siagian et al. | Customer Data Search Application System at PT. Indonesian Islamic Bank Langsa Web-Based Branch | |
| Piros | New automatic interpreter for complex UDC numbers | |
| TWI273448B (en) | Data-testing system and method | |
| CN112486485A (en) | Electronic management method, device, medium and electronic equipment for operation posts |
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 |