CN110941634A - Data processing method and device, storage medium and electronic device - Google Patents
Data processing method and device, storage medium and electronic device Download PDFInfo
- Publication number
- CN110941634A CN110941634A CN201911185378.2A CN201911185378A CN110941634A CN 110941634 A CN110941634 A CN 110941634A CN 201911185378 A CN201911185378 A CN 201911185378A CN 110941634 A CN110941634 A CN 110941634A
- Authority
- CN
- China
- Prior art keywords
- index information
- specified
- basic
- operation rule
- user
- 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.)
- Withdrawn
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/2448—Query languages for particular applications; for extensibility, e.g. user defined types
-
- 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)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data processing method and device, a storage medium and an electronic device, wherein the method comprises the following steps: acquiring basic index information to be processed according to user requirements, and associating specified index information related to the basic index information; wherein the specified index information is index information defined according to the basic index information; determining an operation rule between the basic index information and the specified index information to obtain a logic expression formed by the basic index information and the specified index information and the operation rule; and displaying the logic expression to a user. By the method and the device, the problem of low efficiency caused by the fact that screening of data needs to be manually carried out in the related technology is solved.
Description
Technical Field
The invention relates to the field of computers, in particular to a data processing method and device, a storage medium and an electronic device.
Background
In the banking business, when a banking staff screens a client according to a certain index, a technician is required to screen a target client according to the requirement of the staff, if the screening standard is simple, the screening can be completed in a handwritten SQL mode, but when a scene is complex, the technician is required to screen in a program writing mode, so that the time is greatly wasted, and the server performance is very consumed for banks with large data volume.
In view of the above problems in the related art, no effective solution exists at present.
Disclosure of Invention
The embodiment of the invention provides a data processing method and device, a storage medium and an electronic device, which are used for at least solving the problem of low efficiency caused by the fact that the screening of data needs to be manually carried out in the related technology.
According to an embodiment of the present invention, there is provided a data processing method including: acquiring basic index information to be processed according to user requirements, and associating specified index information related to the basic index information; wherein the specified index information is index information defined according to the basic index information; determining an operation rule between the basic index information and the specified index information to obtain a logic expression formed by the basic index information and the specified index information and the operation rule; and displaying the logic expression to a user.
According to another embodiment of the present invention, there is provided a data processing apparatus including: the processing module is used for acquiring basic index information to be processed according to user requirements and associating appointed index information related to the basic index information; wherein the specified index information is index information defined according to the basic index information; the determining module is used for determining an operation rule between the basic index information and the specified index information to obtain a logic expression formed by the basic index information and the specified index information and the operation rule; and the display module is used for displaying the logic expression to a user.
According to a further embodiment of the present invention, there is also provided a storage medium having a computer program stored therein, wherein the computer program is arranged to perform the steps of any of the above method embodiments when executed.
According to yet another embodiment of the present invention, there is also provided an electronic device, including a memory in which a computer program is stored and a processor configured to execute the computer program to perform the steps in any of the above method embodiments.
According to the method and the device, the basic index information to be processed is obtained according to the user requirements, and the specified index information related to the basic index information is associated; the specified index information is the index information defined according to the basic index information, the operation rule between the basic index information and the specified index information is further determined, the logic expression formed by the basic index information, the specified index information and the operation rule is obtained, and the logic expression is displayed for a user, so that the index information is processed quickly, and the problem of low efficiency caused by the fact that data screening needs to be performed manually in the related technology is solved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
fig. 1 is a block diagram of a hardware configuration of a terminal of a data processing method according to an embodiment of the present invention;
FIG. 2 is a flow chart of a method of processing data according to an embodiment of the invention;
FIG. 3 is a schematic diagram of an initialization page according to an embodiment of the invention;
FIG. 4 is a diagram illustrating selection of a base indicator on a page according to an embodiment of the invention;
FIG. 5 is a schematic diagram of selecting a derivative index on a page in accordance with an alternative embodiment of the invention;
FIG. 6 is a schematic diagram of selecting operands on a page in accordance with an alternative embodiment of the present invention;
FIG. 7 is a schematic diagram after an addition configuration in accordance with an alternative embodiment of the present invention;
FIG. 8 is a diagram of inserting a page over an existing expression in accordance with an alternative embodiment of the present invention;
fig. 9 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present invention.
Detailed Description
The invention will be described in detail hereinafter with reference to the accompanying drawings in conjunction with embodiments. It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order.
Example 1
The method provided by the first embodiment of the present application may be executed in a terminal, a computer terminal, or a similar computing device. Taking an example of the operation on a terminal, fig. 1 is a hardware structure block diagram of the terminal of a data processing method according to an embodiment of the present invention. As shown in fig. 1, the terminal 10 may include one or more (only one shown in fig. 1) processors 102 (the processor 102 may include, but is not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA) and a memory 104 for storing data, and optionally may also include a transmission device 106 for communication functions and an input-output device 108. It will be understood by those skilled in the art that the structure shown in fig. 1 is only an illustration and is not intended to limit the structure of the terminal. For example, the terminal 10 may also include more or fewer components than shown in FIG. 1, or have a different configuration than shown in FIG. 1.
The memory 104 may be used to store computer programs, for example, software programs and modules of application software, such as computer programs corresponding to the data processing method in the embodiment of the present invention, and the processor 102 executes various functional applications and data processing by running the computer programs stored in the memory 104, so as to implement the above-mentioned method. The memory 104 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory located remotely from the processor 102, which may be connected to the terminal 10 via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission device 106 is used to receive or transmit data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the terminal 10. In one example, the transmission device 106 includes a Network adapter (NIC) that can be connected to other Network devices through a base station to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is used to communicate with the internet in a wireless manner.
In the present embodiment, a method for processing data running on the terminal is provided, and fig. 2 is a flowchart of a method for processing data according to an embodiment of the present invention, as shown in fig. 2, the flowchart includes the following steps:
step S202, acquiring basic index information to be processed according to user requirements, and associating specified index information related to the basic index information; the specified index information is index information defined according to the basic index information;
step S204, determining an operation rule between the basic index information and the specified index information to obtain a logic expression formed by the basic index information, the specified index information and the operation rule;
step S206, the logic expression is displayed to the user.
Through the steps S202 to S206, obtaining basic index information to be processed according to a user requirement, and associating specified index information related to the basic index information; the specified index information is the index information defined according to the basic index information, the operation rule between the basic index information and the specified index information is further determined, the logic expression formed by the basic index information, the specified index information and the operation rule is obtained, and the logic expression is displayed for a user, so that the index information is processed quickly, and the problem of low efficiency caused by the fact that data screening needs to be performed manually in the related technology is solved.
In an optional implementation manner of this embodiment, as to the manner of presenting the logic expression to the user involved in step S206, the method further may include:
step S206-11, converting the logic expression into a Structured Query Language (SQL) statement;
and S206-12, inquiring according to the SQL statement, and displaying the inquiry result to the user.
That is, in this embodiment, as shown in fig. 3 and fig. 4, a batch of basic indexes are imported according to the requirement (currently, the basic indexes may be imported again according to the requirement). And then, during configuration, the basic indexes are selected according to a service scene and combined with logical operators (+, -, ×, ÷ …) to form a calculable formula, then a user clicks a determination button, the front end transmits data to the rear end, the rear end receives the data and converts the formula into an SQL statement, and then the data is inquired according to the SQL statement and displayed at the front end.
In an optional implementation manner of this embodiment, before associating the specified index information related to the basic index information, the method of this embodiment further includes:
step S200, configuring the attribute of the designated index information, wherein the attribute of the designated index information comprises at least one of the following: the name of the designated index, the type of the designated index, the state of the designated index, the description of the designated index and operators in the operation rules related to the designated index.
That is, as shown in fig. 5 and fig. 6, in the configuration page, the index name, the index type (including basic information of the enterprise, loan information, property information, transaction flow, etc.), the index status (whether enabled or not), the index description, and optionally the existing basic index, derivative index, and operator can be filled in as required.
In an optional implementation manner of this embodiment, the method of this embodiment further includes:
step S208, receiving an instruction for modifying the logic expression;
step S210, modifying at least one of the following logic expressions according to the instruction: basic index information, specified index information and operation rules.
That is, as shown in fig. 7 and 8, the selection frame of the basic index, the derived index (corresponding to the designated index), and the operator can be clicked according to the own requirement, and the index meeting the requirement is selected, and the selected content is displayed below according to the field and the expression difference after selection to form a logical expression, and of course, the user can click a certain field or operator in the following expression to insert another expression or operator into the field or operator, and finally form an executable mathematical expression meeting the logic.
Through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
Example 2
In this embodiment, a data processing apparatus is further provided, and the apparatus is used to implement the foregoing embodiments and preferred embodiments, and details of which have been already described are omitted. As used below, the term "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.
Fig. 9 is a block diagram of a configuration of a data processing apparatus according to an embodiment of the present invention, as shown in fig. 9, the apparatus including: the processing module 92 is configured to obtain basic index information to be processed according to a user requirement, and associate specified index information related to the basic index information; the specified index information is index information defined according to the basic index information; a determining module 94, configured to determine an operation rule between the basic index information and the specified index information, to obtain a logic expression formed by the basic index information, the specified index information, and the operation rule; and a presentation module 96 for presenting the logic expression to a user.
Optionally, the apparatus of this embodiment may further include: the receiving module is used for receiving an instruction for modifying the logic expression; a modification module for modifying at least one of the following logic expressions according to the instruction: basic index information, specified index information and operation rules.
Optionally, the display module 96 in this embodiment may further include: the conversion unit is used for converting the logic expression into a Structured Query Language (SQL) statement; and the display unit is used for inquiring according to the SQL statement and displaying the inquiry result to the user.
Optionally, the apparatus of this embodiment may further include: the configuration module is used for configuring the attribute of the specified index information before the specified index information related to the basic index information is associated, wherein the attribute of the specified index information comprises at least one of the following: the name of the designated index, the type of the designated index, the state of the designated index, the description of the designated index and operators in the operation rules related to the designated index.
It should be noted that, the above modules may be implemented by software or hardware, and for the latter, the following may be implemented, but not limited to: the modules are all positioned in the same processor; alternatively, the modules are respectively located in different processors in any combination.
Example 3
Embodiments of the present invention also provide a storage medium having a computer program stored therein, wherein the computer program is arranged to perform the steps of any of the above method embodiments when executed.
Alternatively, in the present embodiment, the storage medium may be configured to store a computer program for executing the steps of:
s1, acquiring basic index information to be processed according to user requirements, and associating appointed index information related to the basic index information; the specified index information is index information defined according to the basic index information;
s2, determining an operation rule between the basic index information and the specified index information to obtain a logic expression consisting of the basic index information, the specified index information and the operation rule;
s3, the logic expression is displayed to the user.
Optionally, in this embodiment, the storage medium may include, but is not limited to: various media capable of storing computer programs, such as a usb disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk.
Embodiments of the present invention also provide an electronic device comprising a memory having a computer program stored therein and a processor arranged to run the computer program to perform the steps of any of the above method embodiments.
Optionally, the electronic apparatus may further include a transmission device and an input/output device, wherein the transmission device is connected to the processor, and the input/output device is connected to the processor.
Optionally, in this embodiment, the processor may be configured to execute the following steps by a computer program:
s1, acquiring basic index information to be processed according to user requirements, and associating appointed index information related to the basic index information; the specified index information is index information defined according to the basic index information;
s2, determining an operation rule between the basic index information and the specified index information to obtain a logic expression consisting of the basic index information, the specified index information and the operation rule;
s3, the logic expression is displayed to the user.
Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments and optional implementation manners, and this embodiment is not described herein again.
It will be apparent to those skilled in the art that the modules or steps of the present invention described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different than that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A method for processing data, comprising:
acquiring basic index information to be processed according to user requirements, and associating specified index information related to the basic index information; wherein the specified index information is index information defined according to the basic index information;
determining an operation rule between the basic index information and the specified index information to obtain a logic expression formed by the basic index information and the specified index information and the operation rule;
and displaying the logic expression to a user.
2. The method of claim 1, further comprising:
receiving an instruction for modifying the logic expression;
modifying, according to the instructions, at least one of the following logical expressions: the basic index information, the specified index information, and the operation rule.
3. The method of claim 1, wherein exposing the logical expression to a user comprises:
converting the logical expression into a Structured Query Language (SQL) statement;
and querying according to the SQL statement, and displaying a query result to the user.
4. The method of claim 1, wherein prior to associating the specified metric information to which the base metric information relates, the method further comprises:
configuring the attribute of the specified index information, wherein the attribute of the specified index information comprises at least one of the following: the method comprises the steps of specifying an index name, specifying an index type, specifying an index state, specifying an index description and operators in an operation rule related to the specified index.
5. An apparatus for processing data, comprising:
the processing module is used for acquiring basic index information to be processed according to user requirements and associating appointed index information related to the basic index information; wherein the specified index information is index information defined according to the basic index information;
the determining module is used for determining an operation rule between the basic index information and the specified index information to obtain a logic expression formed by the basic index information and the specified index information and the operation rule;
and the display module is used for displaying the logic expression to a user.
6. The apparatus of claim 5, further comprising:
the receiving module is used for receiving an instruction for modifying the logic expression;
a modification module configured to modify, according to the instruction, at least one of the following logic expressions: the basic index information, the specified index information, and the operation rule.
7. The apparatus of claim 5, wherein the display module comprises:
the conversion unit is used for converting the logic expression into a Structured Query Language (SQL) statement;
and the display unit is used for inquiring according to the SQL statement and displaying the inquiry result to the user.
8. The apparatus of claim 5, further comprising:
a configuration module, configured to configure an attribute of the specified index information before associating the specified index information related to the basic index information, where the attribute of the specified index information includes at least one of: the method comprises the steps of specifying an index name, specifying an index type, specifying an index state, specifying an index description and operators in an operation rule related to the specified index.
9. A computer-readable storage medium, in which a computer program is stored, wherein the computer program is configured to carry out the method of any one of claims 1 to 4 when executed.
10. An electronic device comprising a memory and a processor, wherein the memory has stored therein a computer program, and wherein the processor is arranged to execute the computer program to perform the method of any of claims 1 to 4.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911185378.2A CN110941634A (en) | 2019-11-27 | 2019-11-27 | Data processing method and device, storage medium and electronic device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911185378.2A CN110941634A (en) | 2019-11-27 | 2019-11-27 | Data processing method and device, storage medium and electronic device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110941634A true CN110941634A (en) | 2020-03-31 |
Family
ID=69908359
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201911185378.2A Withdrawn CN110941634A (en) | 2019-11-27 | 2019-11-27 | Data processing method and device, storage medium and electronic device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110941634A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111461895A (en) * | 2020-04-07 | 2020-07-28 | 中国建设银行股份有限公司 | Interactive financial quantitative index acquisition method, device and system |
CN112115189A (en) * | 2020-08-10 | 2020-12-22 | 天阳宏业科技股份有限公司 | Multi-table data processing method and device and electronic equipment |
CN113762665A (en) * | 2020-06-29 | 2021-12-07 | 北京京东振世信息技术有限公司 | Method and system for backtracking related real-time data of real-time index |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106919630A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | A kind of risk indicator formula generation method and system based on SQL expression |
CN108268437A (en) * | 2016-12-30 | 2018-07-10 | 航天信息股份有限公司 | The method and device of formula manipulation |
CN109992589A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Method, apparatus, server and the medium of SQL statement are generated based on visual page |
CN110008232A (en) * | 2019-04-11 | 2019-07-12 | 北京启迪区块链科技发展有限公司 | Generation method, device, server and the medium of structured query sentence |
CN110045953A (en) * | 2019-04-22 | 2019-07-23 | 第四范式(北京)技术有限公司 | Generate the method and computing device of business rule expression formula |
-
2019
- 2019-11-27 CN CN201911185378.2A patent/CN110941634A/en not_active Withdrawn
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106919630A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | A kind of risk indicator formula generation method and system based on SQL expression |
CN108268437A (en) * | 2016-12-30 | 2018-07-10 | 航天信息股份有限公司 | The method and device of formula manipulation |
CN109992589A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Method, apparatus, server and the medium of SQL statement are generated based on visual page |
CN110008232A (en) * | 2019-04-11 | 2019-07-12 | 北京启迪区块链科技发展有限公司 | Generation method, device, server and the medium of structured query sentence |
CN110045953A (en) * | 2019-04-22 | 2019-07-23 | 第四范式(北京)技术有限公司 | Generate the method and computing device of business rule expression formula |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111461895A (en) * | 2020-04-07 | 2020-07-28 | 中国建设银行股份有限公司 | Interactive financial quantitative index acquisition method, device and system |
CN113762665A (en) * | 2020-06-29 | 2021-12-07 | 北京京东振世信息技术有限公司 | Method and system for backtracking related real-time data of real-time index |
CN113762665B (en) * | 2020-06-29 | 2024-04-16 | 北京京东振世信息技术有限公司 | Real-time index related real-time data backtracking method and system |
CN112115189A (en) * | 2020-08-10 | 2020-12-22 | 天阳宏业科技股份有限公司 | Multi-table data processing method and device and electronic equipment |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109725901B (en) | Front-end code development method, device, equipment and computer storage medium | |
CN108255847B (en) | Page generation method and device | |
CN110941634A (en) | Data processing method and device, storage medium and electronic device | |
CN107908442B (en) | Spring-based resource loading method and device, terminal equipment and computer-readable storage medium | |
CN109582289B (en) | Method, system, storage medium and processor for processing rule flow in rule engine | |
WO2020024451A1 (en) | Method for configuring service commission settlement formula, server, system and storage medium | |
CN111381820A (en) | Method and device for automatically generating API based on GUI | |
CN108153877B (en) | Data dictionary display method and device, terminal equipment and storage medium | |
CN114610372A (en) | Processing method and device for review file, storage medium, processor and terminal | |
CN116827774A (en) | Service analysis method, device, equipment and storage medium | |
CN114327349A (en) | Method and device for determining smart card, storage medium and electronic device | |
CN111522840B (en) | Label configuration method, device, equipment and computer readable storage medium | |
CN112926008A (en) | Method and device for generating form page, electronic equipment and storage medium | |
CN108959294A (en) | A kind of method and apparatus accessing search engine | |
CN112947954A (en) | Interface updating method and device and storage medium | |
CN114296696A (en) | Business function operation method and device, storage medium and electronic equipment | |
CN110278565A (en) | A kind of base station design method and device | |
CN114003329A (en) | Data display component creating method and device, storage medium and electronic device | |
CN114466387A (en) | Method and device for updating configuration file of base station, storage medium and electronic device | |
CN113127099A (en) | Server configuration method, device, equipment and storage medium | |
CN110673879A (en) | One-key adjustment method and device for element style of configuration software | |
CN110751204A (en) | Data fusion method and device, storage medium and electronic device | |
US20240013116A1 (en) | Method and Apparatus for Providing Cloud Service, and Device | |
CN111737372A (en) | Map data generation method and device | |
CN115032901B (en) | Equipment control method 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 | ||
WW01 | Invention patent application withdrawn after publication | ||
WW01 | Invention patent application withdrawn after publication |
Application publication date: 20200331 |