CN110941634A - Data processing method and device, storage medium and electronic device - Google Patents

Data processing method and device, storage medium and electronic device Download PDF

Info

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
Application number
CN201911185378.2A
Other languages
Chinese (zh)
Inventor
郑志浩
邹明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Mininglamp Software System Co ltd
Original Assignee
Beijing Mininglamp Software System Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Mininglamp Software System Co ltd filed Critical Beijing Mininglamp Software System Co ltd
Priority to CN201911185378.2A priority Critical patent/CN110941634A/en
Publication of CN110941634A publication Critical patent/CN110941634A/en
Withdrawn legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • G06F16/2448Query languages for particular applications; for extensibility, e.g. user defined types
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2457Query 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

Data processing method and device, storage medium and electronic device
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.
CN201911185378.2A 2019-11-27 2019-11-27 Data processing method and device, storage medium and electronic device Withdrawn CN110941634A (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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