CN111259129B - Data report searching method and device, electronic equipment and storage medium - Google Patents
Data report searching method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN111259129B CN111259129B CN202010062376.0A CN202010062376A CN111259129B CN 111259129 B CN111259129 B CN 111259129B CN 202010062376 A CN202010062376 A CN 202010062376A CN 111259129 B CN111259129 B CN 111259129B
- Authority
- CN
- China
- Prior art keywords
- report
- interest
- data
- searching
- sets
- 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
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000004364 calculation method Methods 0.000 claims abstract description 31
- 238000012795 verification Methods 0.000 claims abstract description 15
- 230000006870 function Effects 0.000 claims description 30
- 238000005311 autocorrelation function Methods 0.000 claims description 15
- 238000005516 engineering process Methods 0.000 abstract description 2
- 238000012545 processing Methods 0.000 description 10
- 238000004140 cleaning Methods 0.000 description 6
- 230000005540 biological transmission Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 4
- 238000012856 packing Methods 0.000 description 4
- 230000011218 segmentation Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000001172 regenerating effect Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000007670 refining Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/332—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/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/3332—Query translation
- G06F16/3334—Selection or weighting of terms from queries, including natural language queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/35—Clustering; Classification
- G06F16/353—Clustering; Classification into predefined classes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/604—Tools and structures for managing or administering access control systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Artificial Intelligence (AREA)
- Automation & Control Theory (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a big data technology, and discloses a data report searching method, which comprises the following steps: receiving report search keywords input by a user terminal, calculating word frequency values and document frequency values of the report search keywords to further obtain report core keywords, receiving authority information input by the user terminal, if the authority information passes through security verification of a report storage database, performing binding operation on the report core keywords to obtain binding core keywords, searching reports associated with the binding core keywords from the report storage database according to the binding core keywords, obtaining associated report sets according to the reports, classifying the associated report sets according to a preset interest calculation method, obtaining a plurality of interest report sets, feeding back to the user terminal, and completing data report search. The invention also provides a data report searching device and a computer readable storage medium. The invention can realize the accurate and efficient data report searching function.
Description
Technical Field
The present invention relates to the field of big data technologies, and in particular, to a method and apparatus for searching a data report, an electronic device, and a computer readable storage medium.
Background
For searching of the data report, most of the current methods are based on data or header matching, and although the searching function of the data report can be achieved, the searching accuracy of the data report cannot be improved due to the lack of a secondary searching function and no reference searching record.
Disclosure of Invention
The invention provides a data report searching method, a device, electronic equipment and a computer readable storage medium, which mainly aim at searching a data report according to the report requirement of a user.
In order to achieve the above object, the present invention provides a method for searching a data report, including:
Receiving report search keywords input by a user terminal, calculating word frequency values and document frequency values of the report search keywords, and calculating according to the word frequency values and the document frequency values to obtain report core keywords;
Receiving authority information input by a user terminal, and if the authority information passes the security verification of a pre-constructed report storage database, performing binding operation on the report core keywords to obtain binding core keywords;
Searching a report associated with the binding core keyword from a pre-constructed report storage database according to the binding core keyword, and obtaining an associated report set according to the report;
Classifying the associated report sets according to a preset interest calculation method to obtain a plurality of interest report sets, and feeding back the interest report sets to a user terminal to complete data report searching.
Optionally, before the receiving the permission information input by the user terminal, the method further includes:
Searching a report data set corresponding to the report core keyword in the report storage database;
judging whether the report data set is set with permission in the report storage database, and executing the step of receiving permission information input by the user terminal if the report data set is set with permission in the report storage database;
And if the report data set is not set with the permission in the report storage database, taking the report data set as a parameter of a pre-constructed SQL permission program, and running the SQL permission program to finish the permission setting operation of the report data set.
Optionally, the classifying the associated report set according to a preset interest calculation method to obtain a plurality of interest report sets includes:
Dividing the associated report set into one or more interest domains according to the historical interest record of the report storage database;
calculating the interest value of the one or more interest domains by using a preset interest calculation method;
and dividing the associated report set into a plurality of interest report sets according to the interest value.
Optionally, the interest calculating method includes:
by the formula Calculating an interest value;
Wherein g ij represents the interest value, d ik represents report data included in the i-th interest domain, d jk represents report data included in the j-th interest domain, n is the number of the interest domains, H represents the history search record, and max i,j∈H(dik∩djk) represents sequentially searching for the same occurrence number as the d ik,djk report data from the history search record.
Optionally, after the feeding back the multiple interest report sets to the user terminal, the method further includes:
if the user terminal receives the interest report sets, a weight function is built according to the interest report sets;
establishing an autocorrelation function according to the weight function and the interest report sets;
and solving the autocorrelation function to obtain correlation values of a plurality of interest report sets, and inputting the correlation values and the interest report sets into a historical interest record of the report storage database.
In addition, in order to achieve the above object, the present invention also provides a data report searching apparatus, which includes a memory and a processor, wherein the memory stores a data report searching program that can be executed on the processor, and the data report searching program when executed by the processor implements the following steps:
Receiving report search keywords input by a user terminal, calculating word frequency values and document frequency values of the report search keywords, and calculating according to the word frequency values and the document frequency values to obtain report core keywords;
Receiving authority information input by a user terminal, and if the authority information passes the security verification of a pre-constructed report storage database, performing binding operation on the report core keywords to obtain binding core keywords;
Searching a report associated with the binding core keyword from a pre-constructed report storage database according to the binding core keyword, and obtaining an associated report set according to the report;
Classifying the associated report sets according to a preset interest calculation method to obtain a plurality of interest report sets, and feeding back the interest report sets to a user terminal to complete data report searching.
Optionally, before the receiving the permission information input by the user terminal, the method further includes:
Searching a report data set corresponding to the report core keyword in the report storage database;
judging whether the report data set is set with permission in the report storage database, and executing the step of receiving permission information input by the user terminal if the report data set is set with permission in the report storage database;
And if the report data set is not set with the permission in the report storage database, taking the report data set as a parameter of a pre-constructed SQL permission program, and running the SQL permission program to finish the permission setting operation of the report data set.
Optionally, the classifying the associated report set according to a preset interest calculation method to obtain a plurality of interest report sets includes:
Dividing the associated report set into one or more interest domains according to the historical interest record of the report storage database;
calculating the interest value of the one or more interest domains by using a preset interest calculation method;
and dividing the associated report set into a plurality of interest report sets according to the interest value.
Optionally, the interest calculating method includes:
by the formula Calculating an interest value;
Wherein g ij represents the interest value, d ik represents report data included in the i-th interest domain, d jk represents report data included in the j-th interest domain, n is the number of the interest domains, H represents the history search record, and max i,j∈H(dik∩djk) represents sequentially searching for the same occurrence number as the d ik,djk report data from the history search record.
Optionally, after the feeding back the multiple interest report sets to the user terminal, the method further includes:
if the user terminal receives the interest report sets, a weight function is built according to the interest report sets;
establishing an autocorrelation function according to the weight function and the interest report sets;
and solving the autocorrelation function to obtain correlation values of a plurality of interest report sets, and inputting the correlation values and the interest report sets into a historical interest record of the report storage database.
In addition, to achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon a data report searching program executable by one or more processors to implement the steps of the data report searching method as described above.
The invention extracts the key words of the inquiry content of the user, accurately knows the inquiry content wanted by the user, searches the report related to the key words from the pre-constructed report storage database to obtain the related report set, and provides the history record which can be referred to for searching when searching because the history interest record is stored in the report storage database, thereby improving the searching accuracy; in addition, the related report sets are classified according to the interest calculation method, so that secondary searching is further performed on the premise of searching according to the history record, and the purpose of classifying the related report sets is achieved. Therefore, the data report searching method, the data report searching device and the computer readable storage medium can realize the accurate and efficient table inquiry function.
Drawings
FIG. 1 is a flowchart of a method for searching a data report according to an embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating an internal structure of a data report searching apparatus according to an embodiment of the present invention;
Fig. 3 is a schematic diagram of a data report table searching program in the data report table searching device according to an embodiment of 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.
The invention provides a data report searching method. Referring to fig. 1, a flow chart of a method for searching a data report according to an embodiment of the invention is shown. The method may be performed by an apparatus, which may be implemented in software and/or hardware.
In this embodiment, the data report searching method includes:
S1, receiving report search keywords input by a user, calculating word frequency values and document frequency values of the report search keywords, and calculating according to the word frequency values and the document frequency values to obtain report core keywords.
In the preferred embodiment of the invention, for example, a user inputs a report search keyword of 'I want to generate a data report of financial class', and because words such as 'I want', 'generate', 'data report' have no actual effect on the generation of the report, the actual effect on the generation of the report is only 'financial', so that a report core keyword 'financial' needs to be extracted from the report search keyword.
Preferably, a form of receiving report search keywords input by a plurality of users in batches and packing the report search keywords can be used, and the packing form of receiving the report search keywords in batches can improve the speed of the whole invention. And if the report search keyword receiving system constructed in advance is used for receiving report search keywords input by a user, the report search keyword receiving system comprises a physical layer, an access layer and a data acquisition layer, the report search keywords input by a plurality of users are periodically acquired through the data acquisition layer, thousands of pieces of data are cached in the physical layer, then the cached report search keyword data are connected to the access layer, the report search keyword data are packaged in the access layer to obtain report search keyword data packets, and meanwhile, a transmission protocol is set and a multithreading mechanism is adopted to transmit the report search keyword data packets.
In detail, the settings of the transmission protocol are such as ID label, IP address, port, etc.
In detail, the calculating the word frequency value and the document frequency value of the report search keyword includes: and cleaning and word segmentation processing is carried out on the report search keywords to obtain a keyword set, word frequency values of the keywords in the keyword set are sequentially calculated, and document frequency values of the keywords in the keyword set in a preset document set are calculated.
The cleaning comprises punctuation removal and stop word removal.
The word frequency value (TF) calculating method comprises the following steps:
The step of obtaining the keyword set through the cleaning and word segmentation processing is as follows: "I want", "generate", "financial class", "data", "report".
In detail, the calculation of the document frequency value IDF is:
further, the calculation method of the report core keyword TF-IDF comprises the following steps:
And obtaining TF-IDF values of different keywords in the keyword set through calculation, and selecting the largest numerical value to obtain the report core keywords.
S2, receiving authority information input by the user terminal, if the authority information cannot pass through the security verification of the pre-constructed report storage database, re-receiving the authority information input by the user terminal, and if the authority information passes through the security verification of the report storage database, performing binding operation on the report core keywords to obtain binding core keywords.
The authority information is that authority control is carried out on the related information on the basis of data report searching, if a pre-constructed report storage database is a financial storage database, and if the security of the financial storage database is improved, only financial staff can carry out data report searching on the financial storage database.
In another preferred embodiment of the present invention, before the step S2, the method further includes: searching a report data set corresponding to the report core keyword in the report storage database, judging whether the report data set is provided with permission in the report storage database, if the report data set is provided with permission in the report storage database, receiving permission information input by a user terminal, and if the report data set is not provided with permission in the report storage database, taking the report data set as a parameter of a pre-constructed SQL permission program, and running the SQL permission program to finish the permission setting operation of the report data set.
In detail, the SQL entitlement program is an entitlement program written by using an SQL programming language, and because the SQL programming language is internally provided with a plurality of entitlement operation functions, such as EXECUTE, REFERENCES, DELETE, the report data set can be used as the function parameters of functions such as EXECUTE, REFERENCES, DELETE and the like, and the functions such as EXECUTE, REFERENCES, DELETE and the like are transferred to the functions such as REFERENCES, DELETE and the like, and then the entitlement operation functions built in the SQL programming language are directly operated to complete the entitlement operation on the report data set.
S3, searching a report associated with the binding core keyword from the pre-constructed report storage database according to the binding core keyword, and obtaining an associated report set according to the report.
Preferably, the pre-constructed report storage database is a place where different types of data reports are stored after being classified in advance, such as MYSQL. The data report forms of different types are financial report forms, material report forms, management system report forms and the like.
Further, if the report core keyword is 'finance', searching the report storage database according to the 'finance' keyword to obtain a financial report set.
S4, classifying the associated report sets according to a preset interest calculation method to obtain a plurality of interest report sets, and feeding the interest report sets back to the user terminal to complete data report searching.
In detail, the classifying the associated report set according to the interest calculation method includes: dividing the associated report set into one or more interest domains according to the historical interest record, calculating interest values of the one or more interest domains by using an interest calculation method, and dividing the associated report set into a plurality of interest report sets according to the interest values.
Further, if the report core keyword is "finance", searching in the report storage database according to the "finance" keyword to obtain a financial report set, continuing to search records according to the financial report set, and finally, the end user finally outputs the financial report in the financial report set, thereby dividing the financial report set into one or more interest fields.
Further, the method for calculating the interest value comprises the following steps:
by the formula The value of interest is calculated and the value of interest,
Wherein g ij represents the interest value, d ik represents report data included in the i-th interest domain, d jk represents report data included in the j-th interest domain, n is the number of the interest domains, H represents the history search record, and max i,j∈H(dik∩djk) represents sequentially searching for the same occurrence number as the d ik,djk report data from the history search record.
In detail, when a plurality of interest values are calculated, the interest report sets with the highest interest value or the first few high interest report sets are traversed to feed back to the user.
In detail, the regenerating the grouping report set according to the association report set comprises the following steps: dividing the associated report set into a plurality of sub-table sets, establishing a one-to-one correspondence between the associated report set and the sub-table sets, such as cash flow sub-tables, personnel arrangement sub-tables, outgoing reimbursement tables and the like under the associated report set managed by an enterprise, and after establishing a correspondence between the associated report set and the sub-table sets, receiving sub-table search words input by a user, and obtaining the corresponding sub-table sets according to the sub-table search words.
And (3) inputting a financial keyword by the user, processing the financial keyword through S3 and S4 to obtain a financial statement set, further refining the financial statement set to obtain a plurality of sub-table sets, and deriving an asset summary table set from the plurality of sub-table sets at the moment when the user needs an asset liability table.
Further, if the user is to accept the multiple interest report sets, regarding the database of the prestored report as a total interest report set according to the multiple interest report sets, dividing the total interest report set into multiple interest report sets, establishing a one-to-one correspondence between the total interest report set and the interest report sets, if cash flow sub-tables and personnel configuration sub-tables are available under the enterprise management total report, feeding back the cash flow sub-tables to the user, if the user does not select the cash flow sub-tables, feeding back the personnel configuration sub-tables to the user, and so on to complete all recommendations. In detail, if the user accepts the plurality of interest report sets, completing the search of the data report, including: if the user accepts the interest report sets, a weight function is established according to the interest report sets, an autocorrelation function is established according to the weight function and the interest report sets, the autocorrelation function is solved to obtain correlation values of the interest report sets, and the correlation values and the interest report sets are input into a historical interest record to complete data report searching.
Preferably, the autocorrelation function is:
Wherein R represents the autocorrelation function value, x (i_set) represents the weight function, i_set represents data in the interest report SET, n I_SET represents the number of occurrences of each interest report in the interest report SET, m represents the number of user inputs, typically 1, n represents the number of the plurality of interest report SETs, k represents an adjustment factor for coordinating the calculation matching problem with the historical interest records.
The invention also provides a data report searching device. Referring to fig. 2, an internal structure diagram of a data report searching apparatus according to an embodiment of the invention is shown.
In this embodiment, the data report searching apparatus 1 may be a PC (Personal Computer ), or a terminal device such as a smart phone, a tablet computer, a portable computer, or a server. The data report searching apparatus 1 comprises at least a memory 11, a processor 12, a communication bus 13, and a network interface 14.
The memory 11 includes at least one type of readable storage medium including flash memory, a hard disk, a multimedia card, a card memory (e.g., SD or DX memory, etc.), a magnetic memory, a magnetic disk, an optical disk, etc. The memory 11 may in some embodiments be an internal storage unit of the data report searching apparatus 1, for example a hard disk of the data report searching apparatus 1. The memory 11 may also be an external storage device of the data report searching apparatus 1 in other embodiments, for example, a plug-in hard disk, a smart memory card (SMART MEDIA CARD, SMC), a Secure Digital (SD) card, a flash memory card (FLASH CARD) or the like, which are provided on the data report searching apparatus 1. Further, the memory 11 may also include both an internal storage unit and an external storage device of the data report searching apparatus 1. The memory 11 may be used not only for storing application software installed in the data report searching apparatus 1 and various types of data, such as codes of the data report searching program 01, but also for temporarily storing data that has been output or is to be output.
Processor 12 may in some embodiments be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor or other data processing chip for running program code or processing data stored in memory 11, such as executing data report search program 01, etc.
The communication bus 13 is used to enable connection communication between these components.
The network interface 14 may optionally comprise a standard wired interface, a wireless interface (e.g. WI-FI interface), typically used to establish a communication connection between the apparatus 1 and other electronic devices.
Optionally, the device 1 may further comprise a user interface, which may comprise a Display (Display), an input unit such as a Keyboard (Keyboard), and a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch, or the like. The display may also be referred to as a display screen or a display unit, as appropriate, for displaying information processed in the data-report searching device 1 and for displaying a visual user interface.
Fig. 2 shows only the data report searching apparatus 1 having the components 11-14 and the data report searching program 01, and it will be understood by those skilled in the art that the structure shown in fig. 1 does not constitute a limitation on the data report searching apparatus 1, and may include fewer or more components than shown, or may combine some components, or may be a different arrangement of components.
In the embodiment of the apparatus 1 shown in fig. 2, the memory 11 stores a data report search program 01; the processor 12 performs the following steps when executing the data report search program 01 stored in the memory 11:
step one, receiving report search keywords input by a user, calculating word frequency values and document frequency values of the report search keywords, and calculating according to the word frequency values and the document frequency values to obtain report core keywords.
In the preferred embodiment of the invention, for example, a user inputs a report search keyword of 'I want to generate a data report of financial class', and because words such as 'I want', 'generate', 'data report' have no actual effect on the generation of the report, the actual effect on the generation of the report is only 'financial', so that a report core keyword 'financial' needs to be extracted from the report search keyword.
Preferably, a form of receiving report search keywords input by a plurality of users in batches and packing the report search keywords can be used, and the packing form of receiving the report search keywords in batches can improve the speed of the whole invention. And if the report search keyword receiving system constructed in advance is used for receiving report search keywords input by a user, the report search keyword receiving system comprises a physical layer, an access layer and a data acquisition layer, the report search keywords input by a plurality of users are periodically acquired through the data acquisition layer, thousands of pieces of data are cached in the physical layer, then the cached report search keyword data are connected to the access layer, the report search keyword data are packaged in the access layer to obtain report search keyword data packets, and meanwhile, a transmission protocol is set and a multithreading mechanism is adopted to transmit the report search keyword data packets.
In detail, the settings of the transmission protocol are such as ID label, IP address, port, etc.
In detail, the calculating the word frequency value and the document frequency value of the report search keyword includes: and cleaning and word segmentation processing is carried out on the report search keywords to obtain a keyword set, word frequency values of the keywords in the keyword set are sequentially calculated, and document frequency values of the keywords in the keyword set in a preset document set are calculated.
The cleaning comprises punctuation removal and stop word removal.
The word frequency value (TF) calculating method comprises the following steps:
The step of obtaining the keyword set through the cleaning and word segmentation processing is as follows: "I want", "generate", "financial class", "data", "report".
In detail, the calculation of the document frequency value IDF is:
further, the calculation method of the report core keyword TF-IDF comprises the following steps:
And obtaining TF-IDF values of different keywords in the keyword set through calculation, and selecting the largest numerical value to obtain the report core keywords.
And step two, receiving the authority information input by the user terminal, if the authority information cannot pass the security verification of the pre-constructed report storage database, re-receiving the authority information input by the user terminal, and if the authority information passes the security verification of the report storage database, performing binding operation on the report core keywords to obtain binding core keywords.
The authority information is that authority control is carried out on the related information on the basis of data report searching, if a pre-constructed report storage database is a financial storage database, and if the security of the financial storage database is improved, only financial staff can carry out data report searching on the financial storage database.
In another preferred embodiment of the present invention, before the second step, the method further includes: searching a report data set corresponding to the report core keyword in the report storage database, judging whether the report data set is provided with permission in the report storage database, if the report data set is provided with permission in the report storage database, receiving permission information input by a user terminal, and if the report data set is not provided with permission in the report storage database, taking the report data set as a parameter of a pre-constructed SQL permission program, and running the SQL permission program to finish the permission setting operation of the report data set.
In detail, the SQL entitlement program is an entitlement program written by using an SQL programming language, and because the SQL programming language is internally provided with a plurality of entitlement operation functions, such as EXECUTE, REFERENCES, DELETE, the report data set can be used as the function parameters of functions such as EXECUTE, REFERENCES, DELETE and the like, and the functions such as EXECUTE, REFERENCES, DELETE and the like are transferred to the functions such as REFERENCES, DELETE and the like, and then the entitlement operation functions built in the SQL programming language are directly operated to complete the entitlement operation on the report data set.
Searching a report associated with the binding core keyword from a pre-constructed report storage database according to the binding core keyword, and obtaining an associated report set according to the report.
Preferably, the pre-constructed report storage database is a place where different types of data reports are stored after being classified in advance, such as MYSQL. The data report forms of different types are financial report forms, material report forms, management system report forms and the like.
Further, if the report core keyword is 'finance', searching the report storage database according to the 'finance' keyword to obtain a financial report set.
And step four, classifying the associated report sets according to a preset interest calculation method to obtain a plurality of interest report sets, and feeding back the interest report sets to a user terminal to complete data report searching.
In detail, the classifying the associated report set according to the interest calculation method includes: dividing the associated report set into one or more interest domains according to the historical interest record, calculating interest values of the one or more interest domains by using an interest calculation method, and dividing the associated report set into a plurality of interest report sets according to the interest values.
Further, if the report core keyword is "finance", searching in the report storage database according to the "finance" keyword to obtain a financial report set, continuing to search records according to the financial report set, and finally, the end user finally outputs the financial report in the financial report set, thereby dividing the financial report set into one or more interest fields.
Further, the method for calculating the interest value comprises the following steps:
by the formula The value of interest is calculated and the value of interest,
Wherein g ij represents the interest value, d ik represents report data included in the i-th interest domain, d jk represents report data included in the j-th interest domain, n is the number of the interest domains, H represents the history search record, and max i,j∈H(dik∩djk) represents sequentially searching for the same occurrence number as the d ik,djk report data from the history search record.
In detail, when a plurality of interest values are calculated, the interest report sets with the highest interest value or the first few high interest report sets are traversed to feed back to the user.
In detail, the regenerating the grouping report set according to the association report set comprises the following steps: dividing the associated report set into a plurality of sub-table sets, establishing a one-to-one correspondence between the associated report set and the sub-table sets, such as cash flow sub-tables, personnel arrangement sub-tables, outgoing reimbursement tables and the like under the associated report set managed by an enterprise, and after establishing a correspondence between the associated report set and the sub-table sets, receiving sub-table search words input by a user, and obtaining the corresponding sub-table sets according to the sub-table search words.
And (3) inputting a financial keyword by the user, processing the financial statement set in the third step and the fourth step to further refine the financial statement table to obtain a plurality of sub-table sets, and deriving an asset summary table set from the plurality of sub-table sets at the moment when the user needs an asset liability table.
Further, if the user is to accept the multiple interest report sets, regarding the database of the prestored report as a total interest report set according to the multiple interest report sets, dividing the total interest report set into multiple interest report sets, establishing a one-to-one correspondence between the total interest report set and the interest report sets, if cash flow sub-tables and personnel configuration sub-tables are available under the enterprise management total report, feeding back the cash flow sub-tables to the user, if the user does not select the cash flow sub-tables, feeding back the personnel configuration sub-tables to the user, and so on to complete all recommendations.
In detail, if the user accepts the plurality of interest report sets, completing the search of the data report, including: if the user accepts the interest report sets, a weight function is established according to the interest report sets, an autocorrelation function is established according to the weight function and the interest report sets, the autocorrelation function is solved to obtain correlation values of the interest report sets, and the correlation values and the interest report sets are input into a historical interest record to complete data report searching.
Preferably, the autocorrelation function is:
Wherein R represents the autocorrelation function value, x (i_set) represents the weight function, i_set represents data in the interest report SET, n I_SET represents the number of occurrences of each interest report in the interest report SET, m represents the number of user inputs, typically 1, n represents the number of the plurality of interest report SETs, k represents an adjustment factor for coordinating the calculation matching problem with the historical interest records.
Alternatively, in other embodiments, the data report searching program may be further divided into one or more modules, where one or more modules are stored in the memory 11 and executed by one or more processors (the processor 12 in this embodiment) to implement the present invention, and the modules referred to herein are a series of instruction segments of a computer program capable of performing a specific function for describing the execution of the data report searching program in the data report searching apparatus.
For example, referring to fig. 3, a schematic program module of a data report searching program in an embodiment of the data report searching apparatus of the present invention is shown, where the data report searching program may be divided into a report core keyword calculating module 10, a data authority verifying module 20, a report matching module 30, and a report dividing and feedback module 40 by way of example:
the report core keyword calculation module 10 is used for: and receiving report search keywords input by a user terminal, calculating word frequency values and document frequency values of the report search keywords, and calculating according to the word frequency values and the document frequency values to obtain report core keywords.
The data authority verification module 20 is configured to: and receiving the authority information input by the user terminal, if the authority information cannot pass the security verification of the pre-constructed report storage database, re-receiving the authority information input by the user terminal, and if the authority information passes the security verification of the report storage database, performing binding operation on the report core keywords to obtain binding core keywords.
The report matching module 30 is configured to: searching a report associated with the binding core keyword from a pre-constructed report storage database according to the binding core keyword, and obtaining an associated report set according to the report.
The report dividing and feedback module 40 is configured to: classifying the associated report sets according to a preset interest calculation method to obtain a plurality of interest report sets, and feeding back the interest report sets to a user terminal to complete data report searching.
The functions or operation steps implemented when the program modules such as the report core keyword calculation module 10, the data authority verification module 20, the report matching module 30, the report dividing and feedback module 40 are executed are substantially the same as those of the foregoing embodiments, and will not be described herein again.
In addition, an embodiment of the present invention further provides a computer-readable storage medium, where a data report search program is stored, where the data report search program may be executed by one or more processors to implement the following operations:
And receiving report search keywords input by a user terminal, calculating word frequency values and document frequency values of the report search keywords, and calculating according to the word frequency values and the document frequency values to obtain report core keywords.
And receiving the authority information input by the user terminal, if the authority information cannot pass the security verification of the pre-constructed report storage database, re-receiving the authority information input by the user terminal, and if the authority information passes the security verification of the report storage database, performing binding operation on the report core keywords to obtain binding core keywords.
Searching a report associated with the binding core keyword from a pre-constructed report storage database according to the binding core keyword, and obtaining an associated report set according to the report.
Classifying the associated report sets according to a preset interest calculation method to obtain a plurality of interest report sets, and feeding back the interest report sets to a user terminal to complete data report searching.
It should be noted that, the foregoing reference numerals of the embodiments of the present invention are merely for describing the embodiments, and do not represent the advantages and disadvantages of the embodiments. And the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method 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, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, apparatus, article, or method that comprises the element.
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, 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 (5)
1. A method for searching a data report, the method comprising:
Receiving report search keywords input by a user terminal, calculating word frequency values and document frequency values of the report search keywords, and calculating according to the word frequency values and the document frequency values to obtain report core keywords;
receiving authority information input by a user terminal, and if the authority information passes the security verification of a pre-constructed report storage database, performing binding operation on the report core keywords to obtain binding core keywords;
searching a report associated with the binding core keyword from the report storage database according to the binding core keyword, and obtaining an associated report set according to the report;
Classifying the associated report sets according to a preset interest calculation method to obtain a plurality of interest report sets, and feeding back the interest report sets to a user terminal to complete data report searching;
The method for classifying the associated report sets according to a preset interest calculation method to obtain a plurality of interest report sets comprises the following steps: dividing the associated report set into one or more interest domains according to the historical interest record of the report storage database; calculating the interest value of the one or more interest domains by using a preset interest calculation method; dividing the associated report set into a plurality of interest report sets according to the interest value;
The interest calculation method comprises the following steps:
by the formula The value of interest is calculated and the value of interest,
Wherein,Representing the interest value,/>Represents the/>Report data included in group interest fields,/>Represents the/>Report data included in group interest fields,/>For the number of interest domains,/>Representing the historical interest record,/>Representing a search from the historical interest record sequentially with the/>,/>The same occurrence number of report data;
the method further comprises the following steps of: if receiving interest report set receiving information fed back by a user terminal, establishing a weight function according to the interest report sets; establishing an autocorrelation function according to the weight function and the interest report sets; solving the autocorrelation function to obtain correlation values of a plurality of interest report sets, and inputting the correlation values and the interest report sets into a historical interest record of the report storage database;
the autocorrelation function is:
Wherein, Representing the weight function,/>Representing data within the interest report set,/>Representing the number of occurrences of each interest report in the interest report set,/>Representing the number of user inputs,/>Representing the number of the interest report sets,/>Representing an adjustment factor for coordinating and computing matching problems with the historical interest records.
2. The data report searching method of claim 1, further comprising, before said receiving the authority information input by the user terminal:
Searching a report data set corresponding to the report core keyword in the report storage database;
judging whether the report data set is set with permission in the report storage database, and executing the step of receiving permission information input by the user terminal if the report data set is set with permission in the report storage database;
And if the report data set is not set with the permission in the report storage database, taking the report data set as a parameter of a pre-constructed SQL permission program, and running the SQL permission program to finish the permission setting operation of the report data set.
3. A data report searching apparatus for implementing the data report searching method as claimed in any one of claims 1 to 2, characterized in that the apparatus comprises a memory and a processor, the memory having stored thereon a data report searching program executable on the processor, the data report searching program implementing the following steps when executed by the processor:
Receiving report search keywords input by a user terminal, calculating word frequency values and document frequency values of the report search keywords, and calculating according to the word frequency values and the document frequency values to obtain report core keywords;
receiving authority information input by a user terminal, and if the authority information passes the security verification of a pre-constructed report storage database, performing binding operation on the report core keywords to obtain binding core keywords;
searching a report associated with the binding core keyword from the report storage database according to the binding core keyword, and obtaining an associated report set according to the report;
Classifying the associated report sets according to a preset interest calculation method to obtain a plurality of interest report sets, and feeding back the interest report sets to a user terminal to complete data report searching.
4. An electronic device comprising one or more functional modules stored in a memory of the electronic device and which when executed by a processor of the electronic device implements the data report searching method of any of claims 1 to 2.
5. A computer-readable storage medium having stored thereon a data report search program executable by one or more processors to implement the data report search method of any of claims 1 to 2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010062376.0A CN111259129B (en) | 2020-01-19 | 2020-01-19 | Data report searching method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010062376.0A CN111259129B (en) | 2020-01-19 | 2020-01-19 | Data report searching method and device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111259129A CN111259129A (en) | 2020-06-09 |
| CN111259129B true CN111259129B (en) | 2024-04-30 |
Family
ID=70947037
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010062376.0A Active CN111259129B (en) | 2020-01-19 | 2020-01-19 | Data report searching method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111259129B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101661475A (en) * | 2008-08-26 | 2010-03-03 | 华为技术有限公司 | Search method and system |
| CN105224567A (en) * | 2014-06-26 | 2016-01-06 | 腾讯科技（深圳）有限公司 | A kind of searching method of key word and device |
| CN109063127A (en) * | 2018-08-02 | 2018-12-21 | 深圳市京华信息技术有限公司 | A kind of searching method, device, server and storage medium |
| CN109299235A (en) * | 2018-09-19 | 2019-02-01 | 平安科技（深圳）有限公司 | Knowledge base searching method, apparatus and computer readable storage medium |
-
2020
- 2020-01-19 CN CN202010062376.0A patent/CN111259129B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101661475A (en) * | 2008-08-26 | 2010-03-03 | 华为技术有限公司 | Search method and system |
| CN105224567A (en) * | 2014-06-26 | 2016-01-06 | 腾讯科技（深圳）有限公司 | A kind of searching method of key word and device |
| CN109063127A (en) * | 2018-08-02 | 2018-12-21 | 深圳市京华信息技术有限公司 | A kind of searching method, device, server and storage medium |
| CN109299235A (en) * | 2018-09-19 | 2019-02-01 | 平安科技（深圳）有限公司 | Knowledge base searching method, apparatus and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111259129A (en) | 2020-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11176124B2 (en) | Managing a search | |
| US7912816B2 (en) | Adaptive archive data management | |
| US20110282855A1 (en) | Scoring relationships between objects in information retrieval | |
| US20150169710A1 (en) | Method and apparatus for providing search results | |
| US20120166429A1 (en) | Using statistical language models for contextual lookup | |
| CN107085583B (en) | Electronic document management method and device based on content | |
| CN109299235B (en) | Knowledge base searching method, device and computer readable storage medium | |
| CN112651236B (en) | Method and device for extracting text information, computer equipment and storage medium | |
| WO2021115474A1 (en) | Data search method, apparatus, computer device, and storage medium | |
| EP2529318A1 (en) | Method and system for conducting legal research using clustering analytics | |
| WO2020258481A1 (en) | Method and apparatus for intelligently recommending personalized text, and computer-readable storage medium | |
| CN113836131A (en) | Big data cleaning method and device, computer equipment and storage medium | |
| US11755678B1 (en) | Data extraction and optimization using artificial intelligence models | |
| WO2022100067A1 (en) | Method and apparatus for querying data in database, electronic device and storage medium | |
| US10635725B2 (en) | Providing app store search results | |
| EP2472461A1 (en) | Configurable catalog builder system | |
| CN110737824A (en) | Content query method and device | |
| WO2020056976A1 (en) | Optimized sequencing method, device, and program for search results, and computer readable storage medium | |
| CN111259129B (en) | Data report searching method and device, electronic equipment and storage medium | |
| CN109918420B (en) | Competitor recommendation method and server | |
| KR102532216B1 (en) | Method for establishing ESG database with structured ESG data using ESG auxiliary tool and ESG service providing system performing the same | |
| US20180075157A1 (en) | Method and System for Converting Disparate Financial, Regulatory, and Disclosure Documents to a Linked Table | |
| JP2015106346A (en) | Recommendation information generation device and recommendation information generation method | |
| US20220292089A1 (en) | Automated, configurable and extensible digital asset curation tool | |
| US9734254B2 (en) | Method and apparatus for automatic completion of an entry into an input field |
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 |