CN114860737B - Processing method, device, equipment and medium of teaching and research data - Google Patents

Processing method, device, equipment and medium of teaching and research data Download PDF

Info

Publication number
CN114860737B
CN114860737B CN202210742670.5A CN202210742670A CN114860737B CN 114860737 B CN114860737 B CN 114860737B CN 202210742670 A CN202210742670 A CN 202210742670A CN 114860737 B CN114860737 B CN 114860737B
Authority
CN
China
Prior art keywords
target
field
data
data source
database
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
Application number
CN202210742670.5A
Other languages
Chinese (zh)
Other versions
CN114860737A (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.)
Beijing Century TAL Education Technology Co Ltd
Original Assignee
Beijing Century TAL Education Technology 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 Beijing Century TAL Education Technology Co Ltd filed Critical Beijing Century TAL Education Technology Co Ltd
Priority to CN202210742670.5A priority Critical patent/CN114860737B/en
Publication of CN114860737A publication Critical patent/CN114860737A/en
Application granted granted Critical
Publication of CN114860737B publication Critical patent/CN114860737B/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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • 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/26—Visual data mining; Browsing structured data
    • 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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/0486—Drag-and-drop
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/451—Execution arrangements for user interfaces

Abstract

The disclosure relates to a processing method, a device, equipment and a medium of teaching and research data, wherein the method comprises the following steps: configuring a data source of teaching and research data to be analyzed to obtain a target data source; executing preset data set configuration operation aiming at tables and fields in a database connected with a target data source to obtain a target data set; wherein the data set configuration operation comprises: database table selection, configuration of indexes and dimensions corresponding to the data sets in the database table and data set accuracy verification; the graphical management tool is formed by configuring a plurality of modules with different functions and used for graphically displaying the target data set. The present disclosure can reduce user adaptation costs.

Description

Processing method, device, equipment and medium of teaching and research data
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a medium for processing research and teaching data.
Background
In the field of teaching and research applying big data technology, multidimensional analysis application based on data assets is one of the most core practices. Through the application of data multidimensional analysis, effective help can be provided for different latitudes, different personnel and different angles of the teaching and research data from top to bottom, and multi-dimensional statistical analysis, decision support of teaching and research plans, data driving, tutoring plan optimization of students, course content control, teaching effect evaluation and other functional support can be provided for the teaching and research data.
However, in the process of applying the data multidimensional analysis tool in the market to the research and development field, it is found that the current Online Analytical Processing (OLAP) technology is new and different day by day, the updating speed is very fast, the query mode and the syntax details of each OLAP engine are different, and the data analysis tool needs to continuously adapt to a new OLAP engine, which results in too high adaptation cost and lack of uniform data analysis query service.
Disclosure of Invention
In order to solve the technical problems or at least partially solve the technical problems, the present disclosure provides a method, an apparatus, a device and a medium for processing research and teaching data.
According to an aspect of the present disclosure, there is provided a method for processing research and teaching data, including:
configuring a data source of teaching and research data to be analyzed to obtain a target data source;
executing preset data set configuration operation aiming at tables and fields in a database connected with the target data source to obtain a target data set; wherein the data set configuration operation comprises: database table selection, configuration of indexes and dimensions corresponding to the data sets in the database table and data set accuracy verification;
and forming a graphical management tool by configuring a plurality of modules with different functions, wherein the graphical management tool is used for graphically displaying the target data set.
According to another aspect of the present disclosure, there is provided a processing apparatus for research and teaching data, including:
the data source configuration module is used for configuring a data source of the teaching and research data to be analyzed to obtain a target data source;
the data set configuration module is used for executing preset data set configuration operation aiming at tables and fields in a database connected with the target data source to obtain a target data set; wherein the data set configuration operation comprises: database table selection, configuration of indexes and dimensions corresponding to the data sets in the database table and data set accuracy verification;
and the tool configuration module is used for forming a graphical management tool by configuring a plurality of modules with different functions, and the graphical management tool is used for graphically displaying the target data set.
According to another aspect of the present disclosure, there is provided an electronic apparatus including: a processor; and a memory storing a program, wherein the program comprises instructions which, when executed by the processor, cause the processor to perform a processing method according to the above teaching and research data.
According to another aspect of the present disclosure, there is provided a non-transitory computer-readable storage medium storing computer instructions for causing the computer to perform a processing method according to teaching and research data.
Compared with the prior art, the technical scheme provided by the embodiment of the disclosure has the following advantages:
the processing method, device, equipment and medium of teaching and research data provided by the embodiment of the disclosure comprise the following steps: configuring a data source of teaching and research data to be analyzed to obtain a target data source; executing preset data set configuration operation aiming at tables and fields in a database connected with a target data source to obtain a target data set; wherein the data set configuration operation comprises: database table selection, configuration of indexes and dimensions corresponding to the data sets in the database table and data set accuracy verification; the graphical management tool is formed by configuring a plurality of modules with different functions and used for graphically displaying the target data set. The present disclosure can reduce user adaptation costs.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure.
In order to more clearly illustrate the embodiments or technical solutions in the prior art of the present disclosure, the drawings used in the description of the embodiments or prior art will be briefly described below, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without inventive exercise.
FIG. 1 is a flowchart of a method for processing teaching and research data according to an embodiment of the present disclosure;
FIG. 2 is a schematic diagram of a graphical management tool provided by an embodiment of the present disclosure;
fig. 3 is a report schematic diagram generated by data analysis according to an embodiment of the present disclosure;
FIG. 4 is a schematic diagram of analysis results provided by embodiments of the present disclosure;
FIG. 5 is a schematic diagram of another report generated by data analysis according to an embodiment of the present disclosure;
FIG. 6 is a block diagram of a device for processing teaching and research data according to an embodiment of the present disclosure;
fig. 7 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure.
Detailed Description
In order that the above objects, features and advantages of the present disclosure can be more clearly understood, embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it is to be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein, but rather are provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the disclosure are for illustration purposes only and are not intended to limit the scope of the disclosure.
It should be understood that the various steps recited in the method embodiments of the present disclosure may be performed in a different order, and/or performed in parallel. Moreover, method embodiments may include additional steps and/or omit performing the illustrated steps. The scope of the present disclosure is not limited in this respect.
The term "include" and variations thereof as used herein are open-ended, i.e., "including but not limited to". The term "based on" is "based, at least in part, on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Relevant definitions for other terms will be given in the following description. It should be noted that the terms "first", "second", and the like in the present disclosure are only used for distinguishing different devices, modules or units, and are not used for limiting the order or interdependence relationship of the functions performed by the devices, modules or units.
It is noted that references to "a" or "an" in this disclosure are intended to be illustrative rather than limiting, and that those skilled in the art will appreciate that references to "one or more" are intended to be exemplary and not limiting unless the context clearly indicates otherwise.
The names of messages or information exchanged between devices in the embodiments of the present disclosure are for illustrative purposes only, and are not intended to limit the scope of the messages or information.
At present, teaching and research data assets can be rapidly presented through data multidimensional analysis application. However, the application of the graphical multidimensional analysis tool in the market directly to the research and teaching field has many problems, such as the following:
first, there is a lack of a unified data analytics query service. The existing Online Analytical Processing (OLAP) technology is changing day by day, the updating speed is very fast, the query mode and the grammar details of each OLAP engine are different, and the data analysis query tool needs to be continuously adapted to the new OLAP engine.
Second, the user learning cost is high. The data analysis application generally adopts a native SQL (Structured Query Language) statement for configuration, and generally only can be oriented to professionals such as a data analyst. Real users, such as teaching and research managers, management teachers, course design teachers and the like, can only passively use configured visual management tools and cannot automatically explore and define the required data; if there is a need for analyzing the relevant data, the data analyst needs to be contacted for configuration, and the efficiency is low. Moreover, because the SQL is written by the user, the SQL content written by the user is also required to be high; if the SQL written by the user has problems, the system is difficult to check and correct and needs to be checked by the user; if the performance of the SQL written by the user is poor, the performance of data analysis application is reduced, and the use experience is affected.
Thirdly, the graphical construction is not rich enough, the display form is single, and the multi-end adaptation capability is not enough.
Accordingly, to improve at least one of the above problems, embodiments of the present disclosure provide a method, an apparatus, a device, and a medium for processing research and development data. The processing method of the teaching and research data provided by the embodiment of the disclosure can be used for data analysis in the teaching and research aspect, and can realize a comprehensive data analysis method with multiple functions including graphical management tools, double-end query, multi-dimensional analysis, flexible access and the like. The data analysis refers to a function of performing appropriate statistics and analysis on a large amount of data so as to maximally develop the data, and playing a role of the data. Useful information is extracted and conclusions are formed through data analysis, and therefore detailed research and summary summarization are conducted on the data. The users of the present disclosure include professionals who specialize in gathering, organizing, analyzing, and making industry research, evaluation, and prediction from data in the research and development industry, and users for multidimensional analysis of research and development data. For ease of understanding, the embodiments of the present disclosure are described below.
Fig. 1 is a flowchart of a processing method of research and development data according to an embodiment of the present disclosure, where the method may be applied to a WEB side; as shown in fig. 1, the method comprises the steps of:
and S102, configuring a data source of the teaching and research data to be analyzed to obtain a target data source.
The data source is a source of research and teaching data to be analyzed, for example, the research and teaching data comes from a MySQL database, and when the data source is configured, information such as an address, a user name, a password, a connection parameter and the like of the MySQL database needs to be configured to obtain a configured target data source.
And step S104, executing preset data set configuration operation aiming at tables and fields in a database connected with the target data source to obtain a target data set.
In this embodiment, the data set configuration operation may be understood as: performing aggregation and secondary processing on tables and fields used in a database connected with a target data source, and defining index fields and dimension fields; data set configuration operations include, for example: database table selection, configuration of indexes and dimensions corresponding to the data sets in the database table, and data set accuracy verification.
And S106, forming a graphical management tool by configuring a plurality of modules with different functions, wherein the graphical management tool is used for graphically displaying the target data set.
The graphical management tool in this embodiment is also often referred to as a kanban in practical applications, and is used for graphically displaying teaching and research data in the target data set. A graphical management tool, which is generally configured, may be applied to data of multiple data sets; in one example, a graphical management tool can be adopted to configure graphical display results of different display types for teaching and research data in a target data set; wherein, the display types include: icons, tables, and filter items; the filter terms may also be associated with charts and tables.
After the graphical management tool is configured, the graphical management tool can be issued to different user terminals, and the data analysis requirements of actual use users such as professionals including data analysts and research and development responsible persons are met.
In the embodiment, the processing method of the teaching and research data is realized by configuring the target data source, configuring the target data set and configuring the graphical management tool, specific implementation details are hidden for a user, and the adaptation cost of the user is reduced.
For ease of understanding, the following detailed description is provided for the processing method of the teaching and research data provided by the embodiments of the present disclosure.
For the above step S102, an embodiment of configuring the target data source may include the following.
Step 1, when a data source of teaching and research data is newly added at a WEB end, responding to the selection operation of the database type, and acquiring the target database type of the data source to be newly added. Specifically, a data source of teaching and research data needing to be newly added can be determined according to the newly added operation of the user, and a target database type is obtained from a plurality of database types according to the selection operation of the user on the database types; database types such as MySQL (relational database management system), PostgreSQL (object-relational database management system), Clickhouse (columnar store database), Presto, and the like.
And 2, responding to the configuration information input operation, and acquiring the data source configuration information of the data source to be newly added. The data source configuration information may specifically include: data source name, IP address of database, user name, password and other information.
And 3, judging whether the WEB side is successfully connected with the data source to be newly added or not according to the type of the target database and the configuration information of the data source. And under the condition that the WEB side is successfully connected with the data source to be newly added, storing the data source to be newly added as a target data source. And if the WEB side is successfully connected with the data source to be newly added, modifying the type of the target database and/or the configuration information of the data source, and judging whether the WEB side is successfully connected with the data source to be newly added again according to the modified type of the target database and the configuration information of the data source.
This embodiment is illustrated by connecting to a MySQL database. During configuration, the target database type of the data source to be newly added is a Mysql database, and based on the MySQL option, the MySQL option can be selected from a plurality of database types provided in advance. The data source name corresponds to the name of the data source which needs to be displayed at the WEB end after the data source to be newly added is established; the IP address of the database corresponds to the IP address of the server; the user name is connected with MySQL, and the password corresponds to the password used when the user creates the database; finally, performing connectivity test on the data source to be newly added, and judging whether the test is successful; if the connection is successful, the WEB side is indicated to be successfully connected with the data source to be newly added, and the data source to be newly added is stored as a target data source; and if the data source configuration information fails, checking and modifying the type of the target database and the data source configuration information, and judging whether the data source to be newly added is successfully connected or not again after modification.
The present embodiment provides a method for performing a preset data set configuration operation based on tables and fields of a target data source to obtain a target data set, which is described below.
A data set, also known as a data set, or data set, is a collection of tables in a database or fields of tables connected by join functions. Each column of the data set represents a particular variable and each row corresponds to a member of the data set. Each value is referred to as a data material, corresponding to a number of rows, and the data of the data set may include one or more members. The fields in each column are divided into an index field and a dimension field according to the roles of the fields. Meanwhile, as the native field in the data table sometimes cannot completely meet the requirements of the user, additional definition, modification and calculation are required, so that the user-defined index and the user-defined dimension are derived.
According to the embodiment, the target database table can be selected and configured according to the database table, the indexes and the dimensions corresponding to the data sets in the target database table are configured, then the target data sets are obtained according to the configured target database table, the index fields and the dimension fields, and accuracy verification is carried out on the target data sets.
In some embodiments, the target data set may have only a single database table or may include a plurality of database tables, and an embodiment for selectively configuring the target database table according to the database tables is provided, which includes:
determining a target database to be used from a target data source; the target database comprises a plurality of database tables; and responding to the table selection operation aiming at least one target database table in a plurality of database tables included in the target database, and moving the target database table to a preset graphical configuration area.
In specific implementation, the target data source corresponds to a plurality of databases, and the target database is determined from the plurality of databases according to the selection of the user. Acquiring a plurality of database tables corresponding to a target database; and selecting a target database table to be used from the plurality of database tables according to the table selection operation, and dragging the target database table to the graphical configuration area in a dragging mode. The target database tables and their fields can be edited in the graphical configuration area.
The embodiment changes the mode of generating the data set by the native SQL into the mode of automatically generating the data set by the graphical interface dragging, and reduces the requirements on the user. The degree of automation is improved, accurate prediction and verification are carried out on user behaviors, unpredictable input is limited, and system performance is improved. Before that, in order to convert the native SQL mode into the graphical drag generation mode, the present embodiment may collect and analyze common multidimensional analysis scene SQL in advance, extract a function list that is commonly used and needs to be implemented by automatically generating SQL through graphical drag, and implement the function list by combining different data sources, so that the functions completely cover the user requirements.
In one embodiment, when the target database table is not less than two, the database table selection further comprises: after the table selection operation of all the target database tables is completed, the association relations among the plurality of target database tables are configured in response to the operation of a relation configuration button in the graphical configuration area.
In particular embodiments, the data set configuration may support associative configuration of multiple database tables. The incidence relation of the database tables refers to the relation of data interdependence and influence between two database tables. The correlation relationship of the database is expressed in SQL sentences by connection modes such as internal connection, left connection, right connection, full external connection and the like; in this embodiment, the data set configuration process may support three kinds of association relationships, i.e., an inner connection, a left connection, and a full outer connection, among the database tables.
When two or more database tables need to be subjected to correlation query, each target database table is configured according to the configuration mode of the single database table, and the two database tables needing to be correlated are moved to the graphical configuration area. A relationship configuration button for configuring the incidence relationship between the database tables is included in the graphical configuration area; based on the method, in response to the user clicking a relation configuration button, a configuration interface of the database table incidence relation pops up, and the configuration interface displays three incidence relations of inner connection, left connection and full outer connection, so that the user selects the incidence relation to be configured from the incidence relations. In addition, the embodiment may further include selecting and adding the associated field between the two database tables in response to the user clicking the add associated field button. And when all the target database tables needing to be configured and the incidence relations between the target database tables are completely added, the database table selection is completed.
In order to better understand the configuration of indexes and dimensions corresponding to a data set in a database table, the present embodiment introduces an index field and a dimension field.
The dimension field is used to represent the characteristics of the thing or phenomenon, such as city, registration channel, course purchase channel, time, etc. Each dimension field has its own value range and data type, and the commonly used dimension fields require a user to define rules in advance. In the above-mentioned dimension field, purchase the class channel and be the more important dimension index of excellent channel of analysis, through the number contrast of buying the class channel, can confirm better purchase the class channel. Time is also a common and special channel, and the good and bad degree of the development of the things can be determined by comparing the time with the time, such as the vertical ratio of the number of users to the previous month by 10%, the vertical ratio to the same year by 20%, the vertical ratio to the active users to the registered users to the ring ratio, and the like; and the number of registered people in different provinces, the successive newspaper rate in different cities and the horizontal ratio among different departments.
The dimension field can be divided into a qualitative dimension field and a quantitative dimension field according to the data type; specifically, the data type is a character type (text type), that is, the common VARCHAR type of the database is a qualitative dimension field, and for example, the region, the gender, the time, and the like all belong to the qualitative dimension field; data types are numerical types and are quantitative dimension fields, such as income, age, power consumed, and the like. Considering that the finer the grouping is, the less obvious the rule is, the present embodiment generally needs to perform the numerical processing on the quantitative dimension field, that is, the numerical data is discretized, so that the rule is more obvious.
The dimension field in this embodiment may also be divided into a native dimension field and a custom dimension field according to the source. The native dimension field is a dimension field of which the value is the original field of a data table in the database; and correspondingly, the user-defined field is a dimension field which takes the value of the original field value in the database and is processed by the SQL statement.
The index field is a unit or method, also called a measure, for measuring the degree of development of the thing. Such as the amount of lessons purchased, the number of accumulated registered users, the number of lessons purchased, the attendance rate, the loss rate, the renewal rate, the number of people, the profit margin, etc. Many companies in the market measure the quality of company business operation according to the index field, the index field needs to be obtained through operation modes such as addition, averaging and the like, summary calculation needs to be carried out under preset conditions, such as time, place and range, namely the commonly-mentioned index calculation caliber, and the business party needs to unify the index calculation caliber. The index field can be divided into an absolute value index field and a relative number index field, the absolute number index field reflects indexes of scale, such as the number of registered people, the number of users and the number of purchased lessees, and the relative number index field is mainly used for reflecting indexes of good and bad quality, such as the rate of continuous report, the retention rate, the profit margin and the like. In practical applications, analyzing the development degree of a thing can be analyzed from the aspects of quantity and quality so as to comprehensively measure the development degree of the thing. The index field is used for measuring the development degree of things, and the development degree needs to be compared through different dimensions.
The index field in this embodiment can be divided into a native index field and a custom index field according to the source. The native index field is an index field which takes a value as the original field of a data table in the database for aggregation; in contrast, the user-defined index field refers to an index field whose value is obtained by processing and aggregating an original field value in a database through a certain SQL statement.
According to the description of the index field and the dimension field in the above embodiment, this embodiment provides a method for configuring indexes and dimensions corresponding to a data set in a database table.
In this embodiment, when the target database table is moved to the preset graphical configuration area, the numeric field in the target database table is divided into the index fields, and the non-numeric field is divided into the dimension fields. And displaying the index field and the dimension field in a preset field editing display area.
In specific implementation, when the target database table is dragged to the graphical configuration area, the fields in the target database table are automatically divided into index fields and dimension fields according to the field types, and the index fields and the dimension fields are displayed in a preset field editing display area. When the fields are automatically divided, fields such as int and double in MySQL are numerical fields, and are divided into index fields. The data types of the fields in the target database table are of other field types, such as character types like char and vchar in MySQL, and time types like timeframe in MySQL, and the fields with non-numeric values are automatically divided into dimension fields.
In this embodiment, the target field may be edited in the field editing display area according to the editing operation; the target field comprises an index field and a dimension field which need to be operated when being selected. The editing operations include, but are not limited to: converting field type, setting hidden field, adding field name and description information, and adding custom field.
Considering that the index field and the dimension field are divided according to the field type, the actual user requirements cannot be completely met. For example: if there is a database table in which one field type is numeric, which stores student class numbers, this field is divided into index fields based on the division rule of the field type. It is clear that this field should belong to the dimension field for distinguishing data, rather than being used as an index field for aggregation calculation. In this case, the present embodiment needs to convert the index field and the dimension field that are automatically divided based on the field type, so as to divide the index field and the dimension field more reasonably and accurately.
Based on this, the present embodiment provides, for an operation of converting a field type in an editing operation, the following manner of editing a target field in a field editing presentation area according to the editing operation.
And determining a target field of the field type to be converted in the field editing display area according to the operation of converting the field type. In a specific example, a target field needing to be operated may be selected in a graphical field editing display area, a field type of the target field is converted in response to a user clicking an editing button and a conversion button of the target field, and the target field is re-divided into an index field or a dimension field according to the converted field type. Under the condition that the target field is the index field, the target field is originally divided into the index field according to the division rule of the field type, the field type of the target field is converted from a numerical type to a non-numerical type, and the target field converted into the non-numerical type is divided into the dimension field. Accordingly, in the case where the target field is a dimension field, the field type of the target field is converted from a non-numerical type to a numerical type, and the target field after being converted to the numerical type is divided into index fields.
In actual practice, all fields present in the target data set may be used by the graphical management tool. However, it is possible that some fields in the database table are not intended for use by the user when editing the graphical management tool and need not be visible to the user configuring the graphical management tool. The present embodiment can implement the above function by an operation of setting a hidden field.
When the operation of setting the hidden field is executed, the hovering position of the mouse hovering in the field editing display area is obtained, the field corresponding to the hovering position is determined to be the target field, and the preset hidden field button is displayed in the area (for example, above) corresponding to the target field. And when the clicking operation of the mouse on the hidden field button is detected, setting the hidden target field. Thus, when the target data set in which the target field is located is used by the graphical management tool, the target field is not displayed.
In general, the fields of the target database table are designed by the developer according to a certain development specification, and the original field names are very unfriendly and difficult to read for the business personnel. Also, it is not sufficient that some fields are just named to be understood by the business person. Based on this, the embodiment can edit the target field in the field editing display area according to the information setting operation, so as to rename the field according to the understanding of the service, and add the description of the field, thereby facilitating the understanding of the field by the service personnel.
The embodiment may include: determining a target field needing to be added with service information in a field editing and displaying area according to information setting operation; acquiring target service information input by a user, and adding the target service information to a target field; wherein, the target service information comprises: field names and description information.
Similar to the previous embodiment for setting the hidden field, when the mouse click operation on the information setting button on the target field is detected, the present embodiment enters an editing interface, and the editing interface is used for a user to edit the field name, the description information and other related target service information of the target field. And adding the target service information acquired from the editing interface to the target field. When the target field is used by the graphical management tool, the field name and description information of the target field can be seen.
So far, all fields in the target dataset are automatically generated by dragging the number table database, however, sometimes these native fields are not satisfactory for the user. Taking the dimension field as an example, there is one field for the grade of the student: first one, first two, first three, first one, second high, third high, etc., but what the user really wants is the type of student: junior middle school, high school, etc.; at this time, the existing field cannot meet the use requirement of the user, and a new dimension field meeting the use requirement of the user needs to be defined. In this case, the present embodiment may customize the field in the field editing display area through an operation of newly adding the customized field.
Firstly, responding to the click operation of a user on a newly-increased dimensionality button or a newly-increased index button in a field editing display area, and displaying a newly-built field interface for a custom field. On the newly-built field interface, a user can edit self-defined information such as field names, field descriptions, data types, SQL expressions and the like; for the editing of the SQL expression, the native index field of the target data set and the original field name of the native dimension field can be inserted by clicking the insertion index and the insertion dimension, so that the SQL expression is conveniently written. And then, obtaining and storing the custom information on the interface of the newly-built field, thereby completing the newly-built custom field.
According to the above embodiment of editing the target field, when all the fields of the target data set are edited, the accuracy of the target data set can be checked. Illustratively, when a click operation is detected for a view wide table button in the graphical configuration area, a data set accuracy check is performed on the target data set. Specifically, a query SQL can be automatically generated and executed according to the configured target data set information, if the execution is successful, the query result and the generated SQL are returned, and if the execution is failed, the error report information is returned to the user, so that the user can conveniently adjust the configuration.
Based on the configured target data source, target data set, and graphical management tool, this embodiment may further provide an event analysis method, where the method includes:
selecting an index field and a dimension field in a target data set, and taking the selected index field and the selected dimension field as an initial query result; screening and sorting the initial query result to obtain a target query result; and carrying out visual display on the target query result by adopting a graphical management tool.
The event analysis in this embodiment refers to a process of using a target data set, selecting a part of index fields and dimension fields therein as an initial query result, performing data screening according to set condition dimensions, aggregating the index fields in the initial query result, and then sorting the results according to sorting conditions to obtain a final target query result.
The process of one-time event analysis comprises four key elements of indexes, dimensions, filtering conditions and sequencing conditions. The setting of the dimension field and the index field is a precondition for setting other elements. The screening conditions are some conditions set for further detailing and checking data analysis results, can be understood as the WHERE conditions of SQL statements, and carry out query limitation on query dimensions, so that more detailed, accurate and visual data are screened out, and the screening conditions are all used for carrying out limited query on the dimensions. The sorting condition is a query condition for displaying the initial query result in ORDER according to a certain set sorting rule, and can be understood to correspond to an ORDER BY statement in an SQL statement.
For example, for event analysis requiring tracking of a user path, events used for event analysis may include user registration, login, class purchase, APP module click, advertisement click, cash recharge, class renewal, and the like, which are set in advance according to data requirements, and may be analyzed according to selected analysis conditions to obtain a final result by collecting and storing data through data.
Analysis conditions commonly used for event analysis include dimensions, indices, and commonly used screening conditions. For example, in a certain analysis scenario related to the amount of sales of a course, the required dimension fields may be divided into cities, disciplines, registration channels, and course purchasing channels, the index fields may include the number of lessons reported (the total number of lessons purchased within a specified time range), the number of registered lessons, the number of times of course purchasing, the number of times of advertisement clicking (the number of times of changing an advertisement into a click within a certain time range), and the like, and the user may freely select the data to be analyzed to match the dimension fields and the index fields.
After the target query result is obtained, the target query result may be visually displayed by using a graphical management tool, for example, the following icon component types in the graphical management tool are used to visually display the target query result: tables, index cards, line graphs, bar graphs, etc.
Referring to fig. 2, the present embodiment provides a specific example of a graphical management tool. The graphical management tool comprises: the main functional modules are displayed by a billboard access, user correlation, background management, billboard configuration, infrastructure, authority control and a mobile terminal. Kanban access is a presentation medium for file directories and graphical management tools used by users to view analysis results. Background management can be used for controlling the authority of a user, the confidentiality and the importance of data are high in data analysis, and the design of the authority is also an important link in the data analysis. The configuration of the graphical management tool is a part of a data analysis display interface, in the graphical management tool, data analysis results can use different visual charts to display the analysis results, and common visual tools comprise tables, line graphs, bar graphs and the like. The mobile terminal device refers to a commonly used mobile phone, a tablet personal computer and the like, the mobile terminal has no limitation on the brand and the model of the mobile phone, and the model adaptation comprises a PC terminal device. The various modules in the graphical management tool will not be described in further detail herein.
The embodiment can support various display forms such as a line graph, a bar graph, a broken line bar graph, a pile-up bar graph, a percentage bar graph, a pie graph, a thermodynamic diagram, a dashboard, a funnel, a map, an indicator card, an icon and the like based on data analysis of a graphical management tool. Meanwhile, the condition query of results is increased by supporting various condition screening components, so that a user can conveniently set data analysis query conditions according to own needs, and thus, data is subjected to multi-dimensional analysis, free exploration is performed, and multi-end release is supported.
The embodiment can collect the graphical management tool and each module in the graphical management tool, and then can quickly check the analysis result in the collection. The collection can also be cancelled for the collected graphic management tools or modules.
For the convenience of understanding, the embodiment of the present disclosure provides a specific example of applying the above teaching and research data to analyze the data and generate an analysis report.
According to the embodiment, a data analysis report can be generated for the target data according to the processing method of the teaching and research data. Wherein, the target data can be MOCK (analog) data which is desensitized; the data analysis report can be viewed in a graphical management tool of the mobile terminal.
The large disk portal is accessed below the kanban access module as shown in fig. 2, and the generated data analysis report can be viewed, and the data report is shown in fig. 3. The present example first needs to obtain an item identifier and an item query condition according to an analysis item, so as to query a server for configuration information of the analysis item.
Since the data size to be analyzed is usually relatively large, the present embodiment may operate on information such as project configuration in the server.
In the embodiment of fig. 3, it can be seen that the analysis result includes a dimension information and an index identifier. The index identifier refers to a name of an index in a project, and is also generally called an alias, when a project contains multiple indexes, there are many index identifiers, and of course, a field name may also be used as the index identifier. The daily purchase class and full link index data in FIG. 3 includes a dimension and an index; the dimension is time, namely the abscissa in the line graph, and the index is the number of the net lessors purchased.
The indexes refer to dimension measurement values to be analyzed, and aim at analysis items of daily course purchasing and full link index data in fig. 3: the number of net lessee purchasing persons, the conversion times, the activation rate and the like can be used as indexes; the index identifier may be a word, or may be a specific data ID, for example: the number of the net lessee purchasing persons can be 001, the index identification of the conversion number can be 002, and no format limitation is made on the index identification.
As shown in fig. 3, the upper side includes two tab pages, where a tab is obtained by converting a query parameter or a group of query queries selected by a user into a character string format for storage, and this embodiment includes two tabs "sell to go through a full link" and "cross-section data".
The added tags are stored in a tag preview group of daily course purchasing and full link index data, the tag overview group is used for storing the stored tags, one tag preview group can store one or more tags, and the tag overview group can also create a default tag. The query parameters held by each tag are isolated.
The step of tag-based previewing includes: the user first needs to obtain configuration information of the tag preview group, obtain information about each tag from the configuration information of the tag preview group, and render a corresponding tag group. And triggering the corresponding selected event of the label by the user, inquiring data corresponding to the label from the server according to the label information acquired from the preview group, then inquiring the character string configuration information stored in the label according to the inquiry condition of the label, and rendering a data list or a line graph, a bar graph and other visual interfaces corresponding to the label according to the character string configuration information of the label.
The tag may contain a tag name, which may be determined by user input, or may be automatically generated by default, one or more query parameters.
As shown in fig. 4, a tab preview group is opened in a viewing area of a left graphic management tool (which may be referred to as a kanban for short), a closing button is provided, and if too many tabs are in a tab preview group, a horizontal scroll bar appears in a tab rendering area.
On the left side of fig. 4, it can be seen that when the analysis results are too many classified and the number of the tag preview groups is too many, it is difficult to find the analysis result page to be viewed in the tag preview group. Therefore, the analysis result preview group can be quickly searched in the tag preview group, the search input identifier is a preview group name, and the preview group name is a preview group identifier manually input by a user when the user creates the preview group. Through the quick search, the name of the preview group can be quickly searched, and the analysis result can also be searched; for example: after courses are purchased every day and full link index data are searched, the search result is triggered to directly enter the label page where the analysis result is located, and the analysis result is located and searched quickly.
As shown in the above operation, when there are too many preview groups, catalog classification may also be performed, and preview groups of the same type are stored in the same catalog in a classified manner, so that the preview group page may be searched in a structural hierarchy by catalog classification.
The data source used by the data analysis result in the above embodiment is shown in fig. 5, the data source type according to which the data analysis result is based is MySQL, the data source name is demo, the data source name is a unique data source identifier, duplicate name results are not allowed to appear, the duplicate name is stored in a server, error information is given, and the mobile terminal displays the error information; the complete data source needs to use a server address, a user name and a password, the embodiment is only used for demonstration, and the embodiment can support a user to select various data source types for connection.
In the embodiment of fig. 5, it can be seen that a control for date filtering is added to the embodiment of fig. 3 to filter the time range of the analysis result, and different time ranges can be selected for viewing the data analysis results of different scenes.
The date represents a statistical date range of the current analysis result index, such as: if the monthly newspaper data needs to be seen, the date range from the beginning of the month to the present can be selected, and the corresponding statistical date is as follows: 2022-03-01 to 2022-03-24.
In the embodiment of fig. 5, in the data analysis result, the plan type filters a filtering item of the 29-element plan, the filtering item is associated with daily class purchasing and full link index data, and the association relationship between the filtering and analysis items is selected by the user.
The screening is a condition set for further detailing and viewing data analysis results, the query dimension is subjected to query limitation, and 29-meta-plan data is limited by analysis items of daily class purchasing and full link index data. The plan type filter may include a plurality of enumerated values such as "29 meta plan", "28 meta plan", "0 meta plan", etc., and the user may select one or more data constraints on the analysis result according to the enumerated values.
In this embodiment, the "plan type" in the filtering item of the plan type is only the identifier of the filtering component, and the plan type is a dimension, where the "0 meta-plan" and the "29 meta-plan" are only some of the categories of the dimension value. In the embodiment, a plurality of screening items including class opening date, primary channels, secondary channels, channel types and the like can be used for carrying out conditional limitation on analysis results.
The user triggers the date or the screening once, the analysis result needs to obtain a new result carrying the screening condition from the server again, and the mobile terminal needs to render the analysis result again through the graphical management tool, so that the user can view the latest analysis result.
The method provided by the embodiment can not only render the graphical report, but also render the text template, and the text information also exists in the label page configuration information. On the label configuration page, a corresponding text component can be selected, and the analysis result and the index caliber are described in detail. In the corresponding reference numeral 3 part in fig. 4, "here is a text box, and notes or word descriptions can be written according to requirements," and the user can freely describe the word content without limiting the content and the word number. In reference numeral 6 in fig. 4, the description of the analysis results may also be described by characters, the meaning represented by the data analysis result corresponding to each analysis is different, the character template corresponding to the analysis result a is a, and the character template corresponding to the analysis result B is described as B. The textual template description is also the content of the data analysis defined by the user himself.
The method provided by the embodiment can be used for checking the report corresponding to the analysis result at the mobile terminals such as the mobile phone and the iPad, the report can contain various different graphical display tools such as tables, line graphs, bar graphs and pie charts, the visualization requirements of different services on the reading analysis are met, and the method is favorable for users to visually and clearly view the analysis result page of the data.
Referring to fig. 6, an embodiment of the present disclosure provides a processing apparatus 600 for teaching and research data, including:
the data source configuration module 602 is configured to configure a data source of research and development data to be analyzed to obtain a target data source;
a data set configuration module 604, configured to execute a preset data set configuration operation on tables and fields in a database connected to a target data source in the database to obtain a target data set; wherein the data set configuration operation comprises: database table selection, configuration of indexes and dimensions corresponding to the data sets in the database table and data set accuracy verification;
and a tool configuration module 606, configured to form a graphical management tool by configuring multiple modules with different functions, where the graphical management tool is used to graphically display the target data set.
In some embodiments, the data source configuration module 602 is specifically configured to:
when a data source of the teaching and research data is newly added at a WEB end, responding to the selection operation of the database type, and acquiring the target database type of the data source to be newly added;
responding to the input operation of the configuration information, and acquiring the data source configuration information of the data source to be newly added;
judging whether the WEB side is successfully connected with a data source to be newly added or not according to the type of the target database and the configuration information of the data source;
under the condition that the WEB side is successfully connected with the data source to be newly added, the data source to be newly added is stored as a target data source;
and modifying the type of the target database and/or the configuration information of the data source under the condition that the WEB side is not successfully connected with the data source to be newly added.
In some embodiments, the data set configuration module 604 includes a database table selection unit to:
determining a target database to be used from a target data source;
in response to a table selection operation for at least one target database table of a plurality of database tables included in the target database, moving the target database table to a preset graphical configuration area,
wherein, when the target database table is not less than two, the database table selection further comprises:
after the table selection operation of all the target database tables is completed, the association relations among the plurality of target database tables are configured in response to the operation of a relation configuration button in the graphical configuration area.
In some embodiments, the data set configuration module 604 includes a configuration unit of indexes and dimensions corresponding to the data sets in the database table, and the unit is configured to:
when the target database table is moved to a preset graphical configuration area, dividing a numerical field in the target database table into index fields and dividing a non-numerical field into dimension fields;
displaying the index field and the dimension field in a preset field editing display area;
editing the target field in the field editing display area according to the editing operation; wherein the target field includes an index field and a dimension field.
In some embodiments, the editing operation comprises: an operation to convert a field type; the configuration unit of the index and the dimension corresponding to the data set in the database table is further configured to:
determining a target field of the field type to be converted in the field editing display area according to the operation of converting the field type;
under the condition that the target field is an index field, converting the field type of the target field from a numerical type to a non-numerical type, and dividing the target field converted into the non-numerical type into dimension fields;
and under the condition that the target field is a dimension field, converting the field type of the target field from a non-numerical type to a numerical type, and dividing the target field converted into the numerical type into index fields.
In some embodiments, the editing operation comprises: information setting operation; the configuration unit of the index and the dimension corresponding to the data set in the database table is further configured to:
determining a target field needing to be added with service information in a field editing and displaying area according to information setting operation;
acquiring target service information input by a user, and adding the target service information to a target field; the target service information comprises: field names and description information.
In some embodiments, the apparatus 600 further comprises: configuring graphical display results of different display types for the teaching and research data in the target data set by adopting a graphical management tool; wherein, the display types include: icons, tables, and filter items.
In some embodiments, the apparatus 600 further comprises: selecting an index field and a dimension field in a target data set, and taking the selected index field and the selected dimension field as an initial query result; screening and sorting the initial query result to obtain a target query result; and carrying out visual display on the target query result by adopting a graphical management tool.
The device provided by the embodiment has the same implementation principle and technical effect as the method embodiments, and for the sake of brief description, reference may be made to the corresponding contents in the method embodiments without reference to the device embodiments.
An exemplary embodiment of the present disclosure also provides an electronic device including: at least one processor; and a memory communicatively coupled to the at least one processor. The memory stores a computer program executable by the at least one processor, the computer program, when executed by the at least one processor, is for causing the electronic device to perform a method according to an embodiment of the disclosure.
The exemplary embodiments of the present disclosure also provide a computer program product comprising a computer program, wherein the computer program, when executed by a processor of a computer, is adapted to cause the computer to perform a method according to an embodiment of the present disclosure.
Referring to fig. 7, a block diagram of a structure of an electronic device 700, which may be a server or a client of the present disclosure, which is an example of a hardware device that may be applied to aspects of the present disclosure, will now be described. Electronic device is intended to represent various forms of digital electronic computer devices, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be examples only, and are not meant to limit implementations of the disclosure described and/or claimed herein.
As shown in fig. 7, the electronic device 700 includes a computing unit 701, which may perform various appropriate actions and processes according to a computer program stored in a Read Only Memory (ROM) 702 or a computer program loaded from a storage unit 708 into a Random Access Memory (RAM) 703. In the RAM 703, various programs and data required for the operation of the device 700 can also be stored. The computing unit 701, the ROM 702, and the RAM 703 are connected to each other by a bus 704. An input/output (I/O) interface 705 is also connected to bus 704.
A number of components in the electronic device 700 are connected to the I/O interface 705, including: an input unit 706, an output unit 707, a storage unit 708, and a communication unit 709. The input unit 706 may be any type of device capable of inputting information to the electronic device 700, and the input unit 706 may receive input numeric or character information and generate key signal inputs related to user settings and/or function controls of the electronic device. Output unit 707 may be any type of device capable of presenting information and may include, but is not limited to, a display, speakers, a video/audio output terminal, a vibrator, and/or a printer. Storage unit 704 may include, but is not limited to, a magnetic disk, an optical disk. The communication unit 709 allows the electronic device 700 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunications networks, and may include, but is not limited to, modems, network cards, infrared communication devices, wireless communication transceivers and/or chipsets, such as bluetooth (TM) devices, WiFi devices, WiMax devices, cellular communication devices, and/or the like.
Computing unit 701 may be a variety of general purpose and/or special purpose processing components with processing and computing capabilities. Some examples of the computing unit 701 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various computing units running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, and so forth. The calculation unit 701 performs the respective methods and processes described above. For example, in some embodiments, the processing of the teaching data can be implemented as a computer software program tangibly embodied on a machine-readable medium, such as storage unit 708. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 700 via the ROM 702 and/or the communication unit 709. In some embodiments, the computing unit 701 may be configured in any other suitable manner (e.g., by way of firmware) to perform the processing method of the research and study data.
Program code for implementing the methods of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the program codes, when executed by the processor or controller, cause the functions/operations specified in the flowchart and/or block diagram to be performed. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
As used in this disclosure, the terms "machine-readable medium" and "computer-readable medium" refer to any computer program product, apparatus, and/or device (e.g., magnetic discs, optical disks, memory, Programmable Logic Devices (PLDs)) used to provide machine instructions and/or data to a programmable processor, including a machine-readable medium that receives machine instructions as a machine-readable signal. The term "machine-readable signal" refers to any signal used to provide machine instructions and/or data to a programmable processor.
To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), and the Internet.
The computer system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other.
The foregoing are merely exemplary embodiments of the present disclosure, which enable those skilled in the art to understand or practice the present disclosure. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the disclosure. Thus, the present disclosure is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (11)

1. A processing method of teaching and research data is characterized by comprising the following steps:
configuring a data source of teaching and research data to be analyzed to obtain a target data source;
executing preset data set configuration operation aiming at tables and fields in a database connected with the target data source to obtain a target data set; wherein the data set configuration operation comprises: database table selection, configuration of indexes and dimensions corresponding to the data sets in the database table and data set accuracy verification; the database table selection includes: determining a target database to be used from the target data source; responding to table selection operation aiming at least one target database table in a plurality of database tables included in the target database, and moving the target database table to a preset graphical configuration area;
and forming a graphical management tool by configuring a plurality of modules with different functions, wherein the graphical management tool is used for graphically displaying the target data set.
2. The method of claim 1, wherein configuring the data source of the research and teaching data to be analyzed to obtain a target data source comprises:
when a data source of teaching and research data is newly added at a WEB end, responding to the selection operation of the database type, and acquiring the target database type of the data source to be newly added;
responding to configuration information input operation, and acquiring data source configuration information of the data source to be newly added;
judging whether the WEB side is successfully connected with the data source to be newly added or not according to the type of the target database and the configuration information of the data source;
under the condition that the WEB side is successfully connected with the data source to be newly added, saving the data source to be newly added as a target data source;
and modifying the type of the target database and/or the configuration information of the data source under the condition that the WEB side is not successfully connected with the data source to be newly added.
3. The method of claim 1,
when the number of the target database tables is not less than two, the database table selection further comprises:
and after the table selection operation of all the target database tables is completed, responding to the operation of a relation configuration button in the graphical configuration area, and configuring the incidence relation among the plurality of target database tables.
4. The method of claim 3, wherein the configuration of the indexes and dimensions corresponding to the data sets in the database table comprises:
when the target database table is moved to a preset graphical configuration area, dividing a numerical field in the target database table into index fields and dividing a non-numerical field into dimension fields;
displaying the index field and the dimension field in a preset field editing display area;
editing the target field in the field editing display area according to the editing operation; wherein the target field includes the metric field and the dimension field.
5. The method of claim 4, wherein the editing operation comprises: an operation to convert a field type; the editing the target field in the field editing display area according to the editing operation comprises the following steps:
according to the operation of converting the field type, determining a target field of the field type to be converted in the field editing and displaying area;
under the condition that the target field is an index field, converting the field type of the target field from a numerical type to a non-numerical type, and dividing the target field converted into the non-numerical type into dimension fields;
and under the condition that the target field is a dimension field, converting the field type of the target field from a non-numerical type to a numerical type, and dividing the target field after being converted into the numerical type into index fields.
6. The method of claim 4, wherein the editing operation comprises: information setting operation; the editing the target field in the field editing display area according to the editing operation comprises the following steps:
according to information setting operation, determining a target field needing to be added with service information in the field editing and displaying area;
acquiring target service information input by a user, and adding the target service information to the target field; wherein the target service information includes: field names and description information.
7. The method according to any one of claims 1-3, further comprising:
configuring graphical display results of different display types for the teaching and research data in the target data set by adopting the graphical management tool; wherein the presentation types include: icons, tables, and filter items.
8. The method according to any one of claims 1-3, further comprising:
selecting an index field and a dimension field in the target data set, and taking the selected index field and the selected dimension field as an initial query result;
screening and sorting the initial query result to obtain a target query result;
and visually displaying the target query result by adopting the graphical management tool.
9. An apparatus for processing teaching and research data, comprising:
the data source configuration module is used for configuring a data source of the teaching and research data to be analyzed to obtain a target data source;
the data set configuration module is used for executing preset data set configuration operation aiming at tables and fields in a database connected with the target data source to obtain a target data set; wherein the data set configuration operation comprises: database table selection, configuration of indexes and dimensions corresponding to the data sets in the database table and data set accuracy verification; the database table selection includes: determining a target database to be used from the target data source; responding to table selection operation aiming at least one target database table in a plurality of database tables included in the target database, and moving the target database table to a preset graphical configuration area;
and the tool configuration module is used for forming a graphical management tool by configuring a plurality of modules with different functions, and the graphical management tool is used for graphically displaying the target data set.
10. An electronic device, characterized in that the electronic device comprises:
a processor; and
a memory for storing a program, wherein the program is stored in the memory,
wherein the program comprises instructions which, when executed by the processor, cause the processor to carry out the method of processing research data according to any one of claims 1 to 8.
11. A non-transitory computer-readable storage medium storing computer instructions for causing a computer to perform the method for processing research data according to any one of claims 1 to 8.
CN202210742670.5A 2022-06-28 2022-06-28 Processing method, device, equipment and medium of teaching and research data Active CN114860737B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210742670.5A CN114860737B (en) 2022-06-28 2022-06-28 Processing method, device, equipment and medium of teaching and research data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210742670.5A CN114860737B (en) 2022-06-28 2022-06-28 Processing method, device, equipment and medium of teaching and research data

Publications (2)

Publication Number Publication Date
CN114860737A CN114860737A (en) 2022-08-05
CN114860737B true CN114860737B (en) 2022-09-20

Family

ID=82627017

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210742670.5A Active CN114860737B (en) 2022-06-28 2022-06-28 Processing method, device, equipment and medium of teaching and research data

Country Status (1)

Country Link
CN (1) CN114860737B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115660251A (en) * 2022-10-28 2023-01-31 广州智算信息技术有限公司 Enterprise health degree evaluation system based on AI big data

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9665662B1 (en) * 2013-06-13 2017-05-30 DataRPM Corporation Methods and system for providing real-time business intelligence using natural language queries
CN109992589B (en) * 2019-04-11 2020-04-10 北京启迪区块链科技发展有限公司 Method, device, server and medium for generating SQL (structured query language) statements based on visual page
CN110618983B (en) * 2019-08-15 2023-01-06 复旦大学 JSON document structure-based industrial big data multidimensional analysis and visualization method
CN112256789B (en) * 2020-10-19 2022-06-17 杭州比智科技有限公司 Intelligent visual data analysis method and device
CN112632037B (en) * 2020-12-24 2023-04-07 浪潮通用软件有限公司 Method and device for graphically defining query data set

Also Published As

Publication number Publication date
CN114860737A (en) 2022-08-05

Similar Documents

Publication Publication Date Title
CA2527281C (en) Systems and processes for automated criteria and attribute generation, searching, auditing and reporting of data
US9064224B2 (en) Process driven business intelligence
US20130166515A1 (en) Generating validation rules for a data report based on profiling the data report in a data processing tool
US11341449B2 (en) Data distillery for signal detection
US11068758B1 (en) Polarity semantics engine analytics platform
CA2838283A1 (en) System and method for building and managing user experience for computer software interfaces
US11373101B2 (en) Document analyzer
US11461343B1 (en) Prescriptive analytics platform and polarity analysis engine
US11748662B2 (en) Contextual modeling using application metadata
US7523090B1 (en) Creating data charts using enhanced SQL statements
CN113157752A (en) Scientific and technological resource recommendation method and system based on user portrait and situation
Tešendić et al. Business intelligence in the service of libraries
CN114860737B (en) Processing method, device, equipment and medium of teaching and research data
EP1814048A2 (en) Content analytics of unstructured documents
US7992126B2 (en) Apparatus and method for quantitatively measuring the balance within a balanced scorecard
US10248733B2 (en) Integration of a catalog application with a monitoring application
US10318627B2 (en) Visualizing dependencies of multi-dimensional data
Zorrilla Data warehouse technology for e-learning
US11966873B2 (en) Data distillery for signal detection
CN112418260A (en) Model training method, information prompting method, device, equipment and medium
Martinez et al. Visualization of multi-level data quality dimensions with QuaIIe
Chatzistefanou Data Warehousing in Business Intelligence and ETL Processes
Niu et al. Business intelligence
Hiljazi et al. Developing an Introductory Class in Business Intelligence (BI) Using MS Excel PowerPivot.
CN115905279A (en) Method and device for automatically building business analysis report and electronic equipment

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