CN110780970B - Data screening method, device, equipment and computer readable storage medium - Google Patents
Data screening method, device, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN110780970B CN110780970B CN201911065021.0A CN201911065021A CN110780970B CN 110780970 B CN110780970 B CN 110780970B CN 201911065021 A CN201911065021 A CN 201911065021A CN 110780970 B CN110780970 B CN 110780970B
- Authority
- CN
- China
- Prior art keywords
- information
- data screening
- screening
- configuration
- data
- 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
- 238000012216 screening Methods 0.000 title claims abstract description 294
- 238000000034 method Methods 0.000 title claims abstract description 58
- 230000001960 triggered effect Effects 0.000 claims abstract description 54
- 230000014509 gene expression Effects 0.000 claims description 82
- 238000001914 filtration Methods 0.000 claims description 72
- 230000006870 function Effects 0.000 claims description 8
- 238000012795 verification Methods 0.000 claims description 5
- 238000005516 engineering process Methods 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 5
- 238000001514 detection method Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000000295 complement effect Effects 0.000 description 1
- 238000007667 floating Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Classifications
-
- 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
-
- 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
-
- 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
- G06F16/2457—Query processing with adaptation to user needs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention relates to the technical field of financial science and technology, and discloses a data screening method, a data screening device, data screening equipment and a computer readable storage medium. The data screening method is applied to web pages and comprises the following steps: when a data screening template configuration request triggered by a user is received, a corresponding data screening template configuration interface is displayed; receiving a data screening template configuration instruction triggered by a user based on the data screening template configuration interface, and acquiring data screening configuration information carried in the data screening template configuration instruction; and generating a corresponding data screening template based on the data screening configuration information. The invention can solve the problems of complex operation and lower screening efficiency of the existing data screening mode.
Description
Technical Field
The present invention relates to the technical field of financial science and technology (Fintech), and in particular, to a data screening method, apparatus, device, and computer readable storage medium.
Background
With the development of computer technology, more and more technologies (big data, distributed, blockchain Blockchain, artificial intelligence, etc.) are applied in the financial field, and the traditional financial industry is gradually changing to financial technology (Fintech), but due to the requirements of security and real-time performance of the financial industry, higher requirements are also put forward on the technologies.
In the big data age, each enterprise has huge business data, and the data is very important how to screen the data set needed by the user from huge data volume. At present, data is usually screened by exporting data of a webpage to a local excel table, and then a user manually performs operations such as screening, sorting, deleting and the like on the data in the excel table according to own requirements so as to screen and obtain the required data. The data is screened according to the existing mode, manual screening after manual export is needed each time, and the operation is complex and the efficiency is low.
Disclosure of Invention
The invention mainly aims to provide a data screening method, a device, equipment and a computer readable storage medium, and aims to solve the problems of complex operation and low screening efficiency of the existing data screening mode.
In order to achieve the above object, the present invention provides a data screening method applied to a web page, the data screening method comprising:
when a data screening template configuration request triggered by a user is received, a corresponding data screening template configuration interface is displayed;
Receiving a data screening template configuration instruction triggered by a user based on the data screening template configuration interface, and acquiring data screening configuration information carried in the data screening template configuration instruction;
and generating a corresponding data screening template based on the data screening configuration information.
Optionally, the data filtering template configuration interface includes a service information configuration interface, a field information configuration interface, and a filtering information configuration interface, and when receiving a data filtering template configuration request triggered by a user, the step of displaying the corresponding data filtering template configuration interface includes:
When receiving a data screening template configuration request triggered by a user, displaying the service information configuration interface;
When a first interface switching instruction triggered by a user based on the service information configuration interface is received, displaying the field information configuration interface according to the first interface switching instruction;
when a second interface switching instruction triggered by the user based on the field information configuration interface is received, determining a target switching interface according to the second configuration interface switching instruction, and displaying the screening information configuration interface or the service information configuration interface according to the target switching interface.
Optionally, if the target switching interface is a screening information configuration interface, before the step of displaying the screening information configuration interface according to the target switching interface, the method further includes:
detecting whether update information of a field type in the field information configuration interface is received or not;
if yes, acquiring updated field type configuration information, and updating an index field list and a dimension field list in the screening information configuration interface according to the updated field type configuration information;
The step of displaying the screening information configuration interface according to the target switching interface comprises the following steps:
and displaying the updated screening information configuration interface according to the target switching interface.
Optionally, the data filtering configuration information includes filtering index information, filtering dimension information and filtering condition information, and the step of generating the corresponding data filtering template based on the data filtering configuration information includes:
Generating a corresponding first expression according to a target index, an index field, an operation function and an operation symbol in the screening index information;
Generating a corresponding second expression according to the target dimension and the dimension field in the screening dimension information,
Generating a corresponding third expression according to the screening type and the screening information in the screening condition information;
and obtaining a corresponding data screening template based on the first expression, the second expression and the third expression.
Optionally, the data filtering configuration information further includes data set configuration information, and before the step of obtaining the corresponding data filtering template based on the first expression, the second expression and the third expression, the method further includes:
determining the type of the selected data set according to the data set configuration information, and detecting whether the type of the selected data set is a preset type or not;
If the data set configuration information is of a preset type, acquiring input path information in the data set configuration information, and acquiring metadata path information based on the input path information and a preset character string;
If the metadata path information is not of the preset type, determining the preset path information as the metadata path information;
The step of obtaining the corresponding data screening template based on the first expression, the second expression and the third expression comprises the following steps:
and obtaining a corresponding data screening template based on the first expression, the second expression, the third expression and the metadata path information.
Optionally, before the step of receiving the data filtering template configuration instruction triggered by the user based on the data filtering template configuration interface, the data filtering method further includes:
When an input instruction triggered by a user based on the data screening template configuration interface is detected, acquiring input information and a target input object corresponding to the input instruction;
acquiring an input check condition corresponding to the target input object, and detecting whether the input information accords with the input check condition;
if the input verification condition is not met, corresponding prompt information is generated to prompt the user to input errors.
Optionally, after the step of generating the corresponding data filtering template based on the data filtering configuration information, the data filtering method further includes:
When a data screening request triggered by a user is received, a target data screening template is obtained from the data screening templates according to the data screening request, and data screening is carried out according to the target data screening template.
In addition, in order to achieve the above object, the present invention further provides a data screening device applied to a web page, the data screening device including:
The interface display module is used for displaying a corresponding data screening template configuration interface when receiving a data screening template configuration request triggered by a user;
The first acquisition module is used for receiving a data screening template configuration instruction triggered by a user based on the data screening template configuration interface and acquiring data screening configuration information carried in the data screening template configuration instruction;
And the template generation module is used for generating a corresponding data screening template based on the data screening configuration information.
In addition, to achieve the above object, the present invention also provides a data screening apparatus including: the system comprises a memory, a processor and a data screening program stored on the memory and capable of running on the processor, wherein the data screening program realizes the steps of the data screening method when being executed by the processor.
In addition, to achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon a data screening program which, when executed by a processor, implements the steps of the data screening method as described above.
The invention provides a data screening method, a device, equipment and a computer readable storage medium, which are used for displaying a corresponding data screening template configuration interface when receiving a data screening template configuration request triggered by a user; then, receiving a data screening template configuration instruction triggered by a user based on a data screening template configuration interface, and acquiring data screening configuration information carried in the data screening template configuration instruction; and then generating a corresponding data screening template based on the data screening configuration information. By the method, the customized screening configuration of the required configuration information in the web page can be realized, and the corresponding data screening template is generated so as to facilitate the subsequent data screening operation.
Drawings
FIG. 1 is a schematic diagram of a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a flowchart of a data screening method according to a first embodiment of the present invention;
FIG. 3 is a schematic diagram of a data filtering template configuration interface according to a first embodiment of the present invention;
Fig. 4 is a schematic functional block diagram of a first embodiment of the data screening apparatus according to the present invention.
The achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
Referring to fig. 1, fig. 1 is a schematic device structure diagram of a hardware running environment according to an embodiment of the present invention.
The data screening device of the embodiment of the invention can be a smart phone or terminal devices such as a PC (Personal Computer ), a tablet personal computer, a portable computer and the like.
As shown in fig. 1, the data screening apparatus may include: a processor 1001, such as a CPU, a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Wherein the communication bus 1002 is used to enable connected communication between these components. The user interface 1003 may include a Display, an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may further include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., wi-Fi interface). The memory 1005 may be a high-speed RAM memory or a stable memory (non-volatile memory), such as a disk memory. The memory 1005 may also optionally be a storage device separate from the processor 1001 described above.
Those skilled in the art will appreciate that the data screening apparatus structure shown in fig. 1 does not constitute a limitation of the data screening apparatus and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components.
As shown in fig. 1, an operating system, a network communication module, a user interface module, and a data filtering program may be included in a memory 1005, which is a type of computer storage medium.
In the terminal shown in fig. 1, the network interface 1004 is mainly used for connecting to a background server and performing data communication with the background server; the user interface 1003 is mainly used for connecting a client and communicating data with the client; and the processor 1001 may be configured to call the data screening program stored in the memory 1005 and perform the steps of the data screening method described below.
Based on the above hardware structure, various embodiments of the data screening method of the present invention are presented.
The invention provides a data screening method.
Referring to fig. 2, fig. 2 is a flowchart of a first embodiment of the data screening method according to the present invention.
In this embodiment, the data filtering method is applied to a web page, and the method includes:
Step S10, when a data screening template configuration request triggered by a user is received, a corresponding data screening template configuration interface is displayed;
The data screening method of this embodiment is implemented by a data screening device, which is described by taking a terminal (such as a PC or a smart phone) as an example. In this embodiment, when the user needs to perform data screening, the data screening template configuration request may be triggered through a web page of a terminal (such as a PC or a smart phone), specifically, after the corresponding web page is opened and logged in, the data screening template creation option or icon may be clicked, so that the data screening template configuration request may be triggered. At this time, when receiving a data screening template configuration request triggered by a user, the terminal displays a corresponding data screening template configuration interface.
The data filtering template configuration interface may include a service information configuration interface, a field information configuration interface, and a filtering information configuration interface, as shown in fig. 3 (a), fig. 3 (B), and fig. 3 (C), respectively.
Specifically, step 10 includes:
step a1, when a data screening template configuration request triggered by a user is received, displaying the service information configuration interface;
Step a2, when a first interface switching instruction triggered by a user based on the service information configuration interface is received, displaying the field information configuration interface according to the first interface switching instruction;
and a step a3 of determining a target switching interface according to a second interface switching instruction when a second interface switching instruction triggered by a user based on the field information configuration interface is received, and displaying the screening information configuration interface or the service information configuration interface according to the target switching interface.
In this embodiment, when receiving a data filtering template configuration request triggered by a user, a service information configuration interface is displayed for the user to input or select some basic information, such as a name, a description, an icon, a data set type, and the like of a service type, as shown in fig. 3 (a), and of course, it is understood that fig. 3 (a) is only a schematic diagram, and does not represent that the basic information only includes information shown in the drawing, and a corresponding basic information input box or selection box may be set according to actual needs for the user to input or select. When a user clicks a next button in the service information configuration interface, a first interface switching instruction can be triggered, and at the moment, when the terminal receives the first interface switching instruction triggered by the user based on the service information configuration interface, the terminal displays the field information configuration interface according to the first interface switching instruction. The field information configuration interface is used for a user to configure field information of the broad table, such as a field type and an extension type, and besides the field type and the extension type, the field information configuration interface can also comprise a broad table field name and a Chinese alias, as shown in fig. 3 (B). The Chinese alias is a Chinese expression corresponding to the field name of the wide table, and because the fields of the table are generally standardized English commands, sometimes are difficult to understand, the Chinese alias is prepared into a meaningful Chinese name, so that the Chinese alias is more convenient for users to use. The field types may include decimal, string, date, etc., and the extension types are typically some complementary configurations, e.g., decimal refers to the precision of floating point numbers, "24, 2" refers to a 24-bit number, where 2 bits follow the decimal point. When clicking the button of the last step or the next step in the service information configuration interface, the user can trigger a second interface switching instruction. At this time, when receiving a second interface switching instruction triggered by the user based on the field information configuration interface, the terminal determines a target switching interface according to the second interface switching instruction, and then displays a screening information configuration interface or a service information configuration interface according to the target switching interface. For example, when clicking "last step", the corresponding target switching interface is a service information configuration interface, and fig. 3 (a) may be displayed; when clicking "next", the corresponding target switching interface is the filtering information configuration interface, and fig. 3 (C) may be displayed. As shown in fig. 3 (C), the filtering information configuration interface is used for filtering the indexes, dimensions and filtering conditions by the user, and fig. 3 (C) shows an extremely convenient interaction manner, namely dragging, for the user to configure the indexes, dimensions and filtering conditions, specifically, the user only needs to drag the recommended dimension fields and index fields into the corresponding "dimension configuration" and "index configuration" areas, so that the user can pop up the corresponding configuration frame and configure the configuration frame (after performing good configuration, a new dimension or index is generated), and in the "filtering configuration", the system can automatically list the filtering conditions available for configuration, and the user can open the corresponding configuration frame to perform configuration by clicking. In addition, the user may further set the selected index, dimension and screening condition to configure the corresponding screening index information, screening dimension information and screening condition information, for example, if the index of loan interest rate is dragged into the index configuration, the screening index information corresponding to the index may be set by clicking the "loan interest rate" in the index configuration and further by popping up the corresponding index screening condition setting window.
Further, if the target switching interface is a screening information configuration interface, before the step of displaying the screening information configuration interface according to the target switching interface, the method further includes:
step a4, detecting whether update information of a field type in the field information configuration interface is received or not;
Step a5, if yes, acquiring updated field type configuration information, and updating an index field list and a dimension field list in the screening information configuration interface according to the updated field type configuration information;
At this time, the step of displaying the screening information configuration interface according to the target switching interface includes: and displaying the updated screening information configuration interface according to the target switching interface.
Further, if the target switching interface is a filtering information configuration interface, before the filtering information configuration interface is displayed according to the target switching interface, whether the updating information of the field type in the field information configuration interface is received can be detected, if so, the updated field type configuration information is obtained, and the index field list and the dimension field list in the filtering information configuration interface are updated according to the updated field type configuration information. That is, the index field list and the dimension field list in the filtering information configuration interface are configured based on the configuration of the field type by the user in the field information configuration interface, that is, the fields are automatically divided into the index field and the dimension field according to the field type. Generally, a numeric field (e.g., resolution) is divided into index fields, and a Wen Zixing field (e.g., string, date) is divided into dimension fields. Of course, the specific division mode can be set according to the actual situation. And after the index field list and the dimension field list in the screening information configuration interface are updated, displaying the updated screening information configuration interface according to the target switching interface.
Step S20, receiving a data screening template configuration instruction triggered by a user based on the data screening template configuration interface, and acquiring data screening configuration information carried in the data screening template configuration instruction;
then, when the user clicks a 'complete' button in the screening information configuration interface, the corresponding data screening template configuration instruction is triggered, and at this time, the terminal receives the data screening template configuration instruction triggered by the user based on the data screening template configuration interface, so as to obtain the data screening configuration information carried in the data screening template configuration instruction. The data filtering configuration information may include, but is not limited to, filtering index information, filtering dimension information, filtering condition information, data set configuration information, service type names, and the like.
And step S30, generating a corresponding data screening template based on the data screening configuration information.
After the data screening configuration information is acquired, a corresponding data screening template is generated based on the data screening configuration information. Wherein, the data filtering configuration information includes filtering index information, filtering dimension information and filtering condition information, and step S30 includes:
Step b1, generating a corresponding first expression according to a target index, an index field, an operation function and an operation symbol in the screening index information;
The screening criteria information may include, but is not limited to: the target index is calculated based on the index fields and the operation relation (formed by the operation function and the operation coincidence) between the index fields, for example, for the target index X, the corresponding index fields are A, B and C, and the operation coincidence is combined with the operation function, so that the corresponding first expression is sum (a×b) +avg (C). Of course, in a specific embodiment, the user may directly input the first expression of each screening index at the terminal, and the terminal may directly obtain the screening index information, that is, the first expression corresponding to each screening index.
Step b2, generating a corresponding second expression according to the target dimension and the dimension field in the screening dimension information,
Screening dimension information may include, but is not limited to: a target dimension and dimension fields, where each target dimension may correspond to one or more dimension fields. For example, for a target dimension W, there are two dimension fields D and E, and a corresponding second expression may be generated that is D+E. Of course, the user may directly input the second expression corresponding to each filtering dimension at the terminal, and the terminal may directly obtain the filtering dimension information, that is, the second expression corresponding to each filtering dimension.
Step b3, generating a corresponding third expression according to the screening type and the screening information in the screening condition information;
the screening condition information may include, but is not limited to: the screening type and the screening information may generate different types of third expressions for different screening types and screening information, and the third expressions may include conditional expressions and constant expressions, where the constant expressions may include sequence type constants, interval type constants, and value correspondence type constants. Specific generation modes of various third expressions are exemplified as follows:
(1) Conditional expression: similar to the dimensional expression, it may be composed of condition fields and operators, such as: condition fields F and G, the conditional expression configured as f×g;
(2) "constants" in the filter conditions are also configured for expressions, where the constants include three types: sequence type constant, interval type constant, and value correspondence type constant, wherein for an expression of a sequence type constant, reference may be made to the following example:
for expressions of interval type constants, reference may be made to the following examples:
{
"minor": "[1,18]",
"Young": "[19,28]"
}
For an expression whose value corresponds to a type constant, reference may be made to the following example:
{
"Man": 1,
"Female" 0
}
Of course, it can be understood that the user may also directly input the third expression corresponding to each screening condition in the terminal, and the terminal may directly obtain the screening condition information, that is, the third expression corresponding to each screening condition.
And b4, obtaining a corresponding data screening template based on the first expression, the second expression and the third expression.
And after obtaining a first expression corresponding to the screening index information, a second expression corresponding to the screening dimension information and a third expression corresponding to the screening condition information, obtaining a corresponding data screening template based on the first expression, the second expression and the third expression.
Further, the data filtering configuration information further includes data set configuration information, and before the step b4, the method further includes:
step b5, determining the type of the selected data set according to the data set configuration information, and detecting whether the type of the selected data set is a preset type or not;
step b6, if the data set configuration information is of a preset type, acquiring input path information in the data set configuration information, and acquiring metadata path information based on the input path information and a preset character string;
Step b7, if the type is not the preset type, determining the preset path information as the metadata path information;
at this time, step b4 includes: and obtaining a corresponding data screening template based on the first expression, the second expression, the third expression and the metadata path information.
Further, the data filtering configuration information further includes data set configuration information, wherein the data set configuration information may be selectively input based on the data set option shown in fig. 3 (a). For example, if the user clicks on the "Hive library:table" selection box, the corresponding dataset configuration information is: the data set type is Hive library; if the user clicks the "IDE (INTEGRATED DEVELOPMENT ENVIRONMENT ) script" selection box, the pop-up path input box is corresponding to the path information of the data set for the user to input, and the corresponding data set configuration information is: the data set type is IDE script and input path information. And after the first expression, the second expression and the third expression are obtained, determining the type of the selected data set according to the data set configuration information, and detecting whether the type of the selected data set is a preset type, wherein the preset type is an IDE script type, if the type of the selected data set is the preset type, obtaining input path information in the data set configuration information, obtaining metadata path information based on the input path information and a preset character string, wherein the preset character string is limit 1, and obtaining metadata path information by adding the preset character string at the end of the input path information. If the type of the selected data set is not the preset type, the preset path information is determined to be metadata path information, namely, if the type of the selected data set is a Hive library table, an interface connected with HiveMetaStore (metadata storage database) can be directly called to directly query the corresponding metadata information, and the path information corresponding to the metadata can be set as the preset path information. After the metadata path information is acquired, a corresponding data screening template is obtained based on the first expression, the second expression, the third expression and the metadata path information. The finally generated data screening template comprises the customized data set and the customized wide table of the user, and complex indexes, dimensions and screening conditions of the content configured by the user, so that personalized customization can be realized, and user experience is improved. Meanwhile, the user does not need to export data through an excel table and then manually screen, so that the data screening operation process can be simplified, and the data screening efficiency can be improved.
The embodiment of the invention provides a data screening method, which comprises the steps of displaying a corresponding data screening template configuration interface when receiving a data screening template configuration request triggered by a user; then, receiving a data screening template configuration instruction triggered by a user based on a data screening template configuration interface, and acquiring data screening configuration information carried in the data screening template configuration instruction; and then generating a corresponding data screening template based on the data screening configuration information. By the method, customized screening configuration of the required configuration information in the web page can be realized, and the corresponding data screening template is generated so as to facilitate subsequent data screening operation.
Further, based on the first embodiment, a second embodiment of the data screening method of the present invention is provided.
In this embodiment, before the step S20, the data filtering method further includes:
Step A, when an input instruction triggered by a user based on the data screening template configuration interface is detected, input information and a target input object corresponding to the input instruction are obtained;
in this embodiment, after displaying the data filtering template configuration interface, the user may input relevant configuration information, for example, a service type, a field type, etc., based on the data filtering template configuration interface, and when detecting an input instruction triggered by the user based on the data filtering template configuration interface, the terminal obtains the input information corresponding to the input instruction and the target input object. For example, when the user inputs a field type, the corresponding input information is the input field type, and the target input object is the field type of the target field.
Step B, acquiring an input check condition corresponding to the target input object, and detecting whether the input information accords with the input check condition;
Then, the input check condition corresponding to the target input object is obtained, and whether the input information meets the input check condition is detected, for example, in the above example, for the detection of the field type, the input check condition corresponding to the field type of the target field may be obtained, for example, for the loan interest rate of the target field, the input check condition corresponding to the field type is that the field type is decimal, and at this time, whether the input information (i.e. the input field type) is decimal is detected.
And step C, if the input verification condition is not met, generating corresponding prompt information to prompt a user to input errors.
If the input verification condition is not met, the user input error is indicated, and corresponding prompt information is generated at the moment so as to prompt the user to input the error.
By the method, when a user inputs information in the data screening template configuration interface, whether the input information meets the requirements or not can be detected, and the user is reminded to be informed in time when the input information does not meet the requirements, so that the user can correct the input information in time.
Further, based on the first embodiment described above, a third embodiment of the data screening method of the present invention is proposed.
In this embodiment, after the step S30, the data filtering method further includes:
And D, when a data screening request triggered by a user is received, acquiring a target data screening template from the data screening template according to the data screening request, and performing data screening according to the target data screening template.
In this embodiment, after the data screening template is generated, the generated data screening template may be stored in a preset database, when the data screening template is stored, the service type name in the data screening template may be stored or the data screening template may be numbered, when the data screening template is required to be used for data screening by a subsequent user, a data screening request may be triggered in a web page corresponding to the terminal, at this time, when the terminal receives the data screening request triggered by the user, the terminal obtains the target data screening template from the data screening template according to the data screening request, and performs data screening according to the target data screening template. Specifically, when the user triggers the data screening request, the user can input information such as a service type or number corresponding to the required data screening template, so that the terminal can acquire the service type or number from the data screening request, acquire the target screening template from the preset database according to the service type or number, and further perform data screening based on the target screening template.
In this embodiment, the data screening is performed by directly obtaining the target data screening template from the generated data screening template, so that intelligent data screening can be realized.
The invention also provides a data screening device.
Referring to fig. 4, fig. 4 is a schematic functional block diagram of a first embodiment of a data screening apparatus according to the present invention.
As shown in fig. 4, the data screening apparatus includes:
the interface display module 10 is used for displaying a corresponding data screening template configuration interface when receiving a data screening template configuration request triggered by a user;
The first obtaining module 20 is configured to receive a data screening template configuration instruction triggered by a user based on the data screening template configuration interface, and obtain data screening configuration information carried in the data screening template configuration instruction;
the template generating module 30 is configured to generate a corresponding data filtering template based on the data filtering configuration information.
Further, the data filtering template configuration interface includes a service information configuration interface, a field information configuration interface, and a filtering information configuration interface, and the interface display module 10 includes:
The first display unit is used for displaying the service information configuration interface when receiving a data screening template configuration request triggered by a user;
The second display unit is used for displaying the field information configuration interface according to the first interface switching instruction when receiving the first interface switching instruction triggered by the user based on the service information configuration interface;
and the third display unit is used for determining a target switching interface according to the second interface switching instruction when receiving the second interface switching instruction triggered by the user based on the field information configuration interface, and displaying the screening information configuration interface or the service information configuration interface according to the target switching interface.
Further, if the target switching interface is a screening information configuration interface, the interface display module 10 further includes:
the first detection unit is used for detecting whether the updating information of the field type in the field information configuration interface is received or not;
the updating unit is used for acquiring updated field type configuration information if yes, and updating an index field list and a dimension field list in the screening information configuration interface according to the updated field type configuration information;
And the third display unit is specifically used for displaying the updated screening information configuration interface according to the target switching interface.
Further, the data filtering configuration information includes filtering index information, filtering dimension information and filtering condition information, and the template generating module 30 includes:
The first generation unit is used for generating a corresponding first expression according to the target index, the index field, the operation function and the operation symbol in the screening index information;
A second generation unit, configured to generate a corresponding second expression according to the target dimension and the dimension field in the filtering dimension information,
The third generation unit is used for generating a corresponding third expression according to the screening type and the screening information in the screening condition information;
And the template generating unit is used for obtaining a corresponding data screening template based on the first expression, the second expression and the third expression.
Further, the data filtering configuration information further includes data set configuration information, and the template generating module 30 further includes:
The second detection unit is used for determining the type of the selected data set according to the data set configuration information and detecting whether the type of the selected data set is a preset type or not;
The acquisition unit is used for acquiring input path information in the data set configuration information if the data set configuration information is of a preset type, and acquiring metadata path information based on the input path information and a preset character string;
the determining unit is used for determining preset path information as the metadata path information if the metadata path information is not of a preset type;
The template generation is specifically used for: and obtaining a corresponding data screening template based on the first expression, the second expression, the third expression and the metadata path information.
Further, the data screening device further includes:
The second acquisition module is used for acquiring input information and a target input object corresponding to the input instruction when detecting the input instruction triggered by the user based on the data screening template configuration interface;
The third detection module is used for acquiring an input check condition corresponding to the target input object and detecting whether the input information accords with the input check condition;
And the error prompting module is used for generating corresponding prompting information to prompt a user to input errors if the input verification conditions are not met.
Further, the data screening device further includes:
and the data screening module is used for acquiring a target data screening template from the data screening template according to the data screening request when receiving a data screening request triggered by a user, and carrying out data screening according to the target data screening template.
The function implementation of each module in the data screening device corresponds to each step in the data screening method embodiment, and the function and implementation process of each module are not described in detail herein.
The present invention also provides a computer readable storage medium having stored thereon a data screening program which when executed by a processor implements the steps of the data screening method according to any of the above embodiments.
The specific embodiments of the computer readable storage medium of the present invention are substantially the same as the embodiments of the data screening method described above, and will not be described herein.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) as described above, comprising instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method according to the embodiments of the present invention.
The foregoing description is only of the preferred embodiments of the present invention, and is not intended to limit the scope of the invention, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.
Claims (8)
1. The data screening method is characterized by being applied to a web page, wherein the data screening template configuration interface comprises a service information configuration interface, a field information configuration interface and a screening information configuration interface, and the data screening method comprises the following steps:
When receiving a data screening template configuration request triggered by a user, displaying the service information configuration interface;
When a first interface switching instruction triggered by a user based on the service information configuration interface is received, displaying the field information configuration interface according to the first interface switching instruction;
detecting whether update information of a field type in the field information configuration interface is received or not when a second interface switching instruction triggered by a user based on the field information configuration interface is received;
if yes, acquiring updated field type configuration information, and updating an index field list and a dimension field list in the screening information configuration interface according to the updated field type configuration information;
Determining a target switching interface according to the second interface switching instruction, wherein the target switching interface is a screening information configuration interface, and displaying an updated screening information configuration interface according to the target switching interface;
Receiving a data screening template configuration instruction triggered by a user based on the data screening template configuration interface, and acquiring data screening configuration information carried in the data screening template configuration instruction;
and generating a corresponding data screening template based on the data screening configuration information.
2. The data filtering method according to claim 1, wherein the data filtering configuration information includes filtering index information, filtering dimension information, and filtering condition information, and the step of generating the corresponding data filtering template based on the data filtering configuration information includes:
Generating a corresponding first expression according to a target index, an index field, an operation function and an operation symbol in the screening index information;
Generating a corresponding second expression according to the target dimension and the dimension field in the screening dimension information,
Generating a corresponding third expression according to the screening type and the screening information in the screening condition information;
and obtaining a corresponding data screening template based on the first expression, the second expression and the third expression.
3. The data filtering method according to claim 2, wherein the data filtering configuration information further includes data set configuration information, and before the step of obtaining the corresponding data filtering template based on the first expression, the second expression, and the third expression, the method further includes:
determining the type of the selected data set according to the data set configuration information, and detecting whether the type of the selected data set is a preset type or not;
If the data set configuration information is of a preset type, acquiring input path information in the data set configuration information, and acquiring metadata path information based on the input path information and a preset character string;
If the metadata path information is not of the preset type, determining the preset path information as the metadata path information;
The step of obtaining the corresponding data screening template based on the first expression, the second expression and the third expression comprises the following steps:
and obtaining a corresponding data screening template based on the first expression, the second expression, the third expression and the metadata path information.
4. The data screening method of claim 1, wherein prior to the step of receiving a data screening template configuration instruction triggered by a user based on the data screening template configuration interface, the data screening method further comprises:
When an input instruction triggered by a user based on the data screening template configuration interface is detected, acquiring input information and a target input object corresponding to the input instruction;
acquiring an input check condition corresponding to the target input object, and detecting whether the input information accords with the input check condition;
if the input verification condition is not met, corresponding prompt information is generated to prompt the user to input errors.
5. The data screening method of claim 1, wherein after the step of generating the corresponding data screening template based on the data screening configuration information, the data screening method further comprises:
When a data screening request triggered by a user is received, a target data screening template is obtained from the data screening templates according to the data screening request, and data screening is carried out according to the target data screening template.
6. The utility model provides a data screening device which characterized in that is applied to the web page, and data screening template configuration interface includes business information configuration interface, field information configuration interface, screening information configuration interface, and the data screening device includes:
The interface display module is used for displaying the service information configuration interface when receiving a data screening template configuration request triggered by a user;
When a first interface switching instruction triggered by a user based on the service information configuration interface is received, displaying the field information configuration interface according to the first interface switching instruction;
detecting whether update information of a field type in the field information configuration interface is received or not when a second interface switching instruction triggered by a user based on the field information configuration interface is received;
if yes, acquiring updated field type configuration information, and updating an index field list and a dimension field list in the screening information configuration interface according to the updated field type configuration information;
Determining a target switching interface according to the second interface switching instruction, wherein the target switching interface is a screening information configuration interface, and displaying an updated screening information configuration interface according to the target switching interface;
The first acquisition module is used for receiving a data screening template configuration instruction triggered by a user based on the data screening template configuration interface and acquiring data screening configuration information carried in the data screening template configuration instruction;
And the template generation module is used for generating a corresponding data screening template based on the data screening configuration information.
7. A data screening apparatus, the data screening apparatus comprising: memory, a processor and a data screening program stored on the memory and executable on the processor, which when executed by the processor implements the steps of the data screening method according to any one of claims 1 to 5.
8. A computer readable storage medium, wherein a data screening program is stored on the computer readable storage medium, which when executed by a processor, implements the steps of the data screening method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911065021.0A CN110780970B (en) | 2019-10-30 | 2019-10-30 | Data screening method, device, equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911065021.0A CN110780970B (en) | 2019-10-30 | 2019-10-30 | Data screening method, device, equipment and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110780970A CN110780970A (en) | 2020-02-11 |
| CN110780970B true CN110780970B (en) | 2024-06-14 |
Family
ID=69388781
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911065021.0A Active CN110780970B (en) | 2019-10-30 | 2019-10-30 | Data screening method, device, equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110780970B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113312053A (en) * | 2020-02-27 | 2021-08-27 | 北京沃东天骏信息技术有限公司 | Data processing method and device |
| CN112286979B (en) * | 2020-10-30 | 2024-01-30 | 北京明略软件系统有限公司 | Data screening method and device, electronic equipment and storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109840303A (en) * | 2019-01-02 | 2019-06-04 | 平安科技（深圳）有限公司 | Original list method for customizing, device, equipment and computer readable storage medium |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103514206A (en) * | 2012-06-26 | 2014-01-15 | 百度在线网络技术（北京）有限公司 | Method and device for determining popularization configuration information corresponding to objective popularization object |
| CN103902579B (en) * | 2012-12-27 | 2018-02-23 | 腾讯科技（深圳）有限公司 | The method and apparatus for obtaining information |
| CN106682150B (en) * | 2016-12-22 | 2020-12-01 | 北京锐安科技有限公司 | Information processing method and device |
| CN108647339A (en) * | 2018-05-14 | 2018-10-12 | 五八有限公司 | A kind of dimensionality analysis method, apparatus, equipment and storage medium |
| CN109359280B (en) * | 2018-09-12 | 2023-12-05 | 深圳市卡牛科技有限公司 | Data display method, device, computer equipment and storage medium |
| CN109656980A (en) * | 2018-12-27 | 2019-04-19 | Oppo（重庆）智能科技有限公司 | Data processing method, electronic equipment, device and readable storage medium storing program for executing |
-
2019
- 2019-10-30 CN CN201911065021.0A patent/CN110780970B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109840303A (en) * | 2019-01-02 | 2019-06-04 | 平安科技（深圳）有限公司 | Original list method for customizing, device, equipment and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110780970A (en) | 2020-02-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6973625B1 (en) | Method for creating browser-based user interface applications using a framework | |
| KR101409673B1 (en) | Persistent saving portal | |
| CN110738037B (en) | Method, apparatus, device and storage medium for automatically generating electronic form | |
| US11093242B2 (en) | Automatically mapping data while designing process flows | |
| CN102541853B (en) | Method and device which are capable of obtaining application information by utilizing browser address bar | |
| CN111753064B (en) | Man-machine interaction method and device | |
| WO2014093072A1 (en) | Methods and systems for managing spreadsheet models | |
| US11556702B2 (en) | Orchestration of crud operations for a hierarchical web service data model in a spreadsheet | |
| US20200201898A1 (en) | Machine resolution of multi-context acronyms | |
| CN110780970B (en) | Data screening method, device, equipment and computer readable storage medium | |
| CA2955672A1 (en) | Database grid search methods and systems | |
| CN114036443A (en) | Page generation method and device | |
| CN116992081A (en) | Page form data processing method and device and user terminal | |
| WO2015026678A2 (en) | Ad hoc reporting with smart lists | |
| KR101910179B1 (en) | Web-based chart library system for data visualization | |
| US20240037325A1 (en) | Ability to add non-direct ancestor columns in child spreadsheets | |
| CN115469849B (en) | Service processing system, method, electronic equipment and storage medium | |
| CN108885613A (en) | Report display system and method | |
| CN110851346A (en) | Method, device and equipment for detecting boundary problem of query statement and storage medium | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| CN111221610B (en) | Page element acquisition method and device | |
| AU2022201117A1 (en) | Frameworks and methodologies for enabling searching and/or categorisation of digitised information, including clinical report data | |
| CN114610204B (en) | Auxiliary device and method for data processing, storage medium and electronic equipment | |
| KR101798139B1 (en) | Filter system and method according to type of data variable in web-based data visualization system | |
| CN113704593B (en) | Operation data processing method and related device |
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 |