CN111563083B - Report data query method, device and system - Google Patents
Report data query method, device and system Download PDFInfo
- Publication number
- CN111563083B CN111563083B CN202010362318.XA CN202010362318A CN111563083B CN 111563083 B CN111563083 B CN 111563083B CN 202010362318 A CN202010362318 A CN 202010362318A CN 111563083 B CN111563083 B CN 111563083B
- Authority
- CN
- China
- Prior art keywords
- report
- file
- sub
- queried
- report file
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/18—File system types
- G06F16/182—Distributed file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2255—Hash tables
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a report data query method, a report data query device and a report data query system, wherein the report data query method comprises the following steps: dividing the report file into a plurality of sub report files; storing a plurality of sub-report files into an IPFS system to obtain hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to the identifiers of the sub-report files one by one; after receiving a search instruction of a user, obtaining a hash value of the report file to be queried according to a file identification of the report file to be queried in the search instruction; and obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried. The invention can query report data, and has high query success rate and high efficiency.
Description
Technical Field
The present invention relates to the field of report data technologies, and in particular, to a report data query method, device, and system.
Background
The electronic report system is an important channel for storing and distributing all business system reports in the whole jurisdiction, can safely store a large amount of historical reports for a long time, reduce the printing quantity of the reports, improve the efficiency of inquiring the reports in business sites, strengthen the authority management of the reports in the sites, improve the response speed of customers to the requirement of the bills and the like.
The traditional implementation mode adopts a centralized architecture to store data in a data center server, and an electronic report system automatically distributes files to each downstream system or provides the files for each downstream system to download. Meanwhile, the report is provided for each website to query the report in real time. Because banking sites are more, the number of people for inquiring the report (including downloading the report after inquiring) is more, the central server bears extremely large storage pressure and inquiring pressure, so that inquiring efficiency is reduced, the development of banking business is affected, and in addition, if the central server is down or a disk is damaged, report data can stop forwarding and providing inquiry, so that the success rate of inquiring is reduced.
Disclosure of Invention
The embodiment of the invention provides a report data query method, which is used for querying report data, has high query success rate and high efficiency, and comprises the following steps:
dividing the report file into a plurality of sub report files;
storing a plurality of sub-report files into an IPFS system to obtain hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to the identifiers of the sub-report files one by one;
after receiving a search instruction of a user, obtaining a hash value of the report file to be queried according to a file identification of the report file to be queried in the search instruction;
and obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried.
The embodiment of the invention provides a report data query device, which is used for querying report data, has high query success rate and high efficiency, and comprises:
the splitting module is used for splitting the report file into a plurality of sub report files;
the hash value generation module is used for storing a plurality of sub-report files to the IPFS system, so as to obtain hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to the identifiers of the sub-report files one by one;
the first query module is used for obtaining the hash value of the report file to be queried according to the file identification of the report file to be queried in the search instruction after receiving the search instruction of the user;
and the second query module is used for obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried.
The embodiment of the invention provides a report data query system, which is used for querying report data, has high query success rate and high efficiency, and comprises: the report data query device, the central server and the IPFS system.
The embodiment of the invention also provides computer equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the report data query method when executing the computer program.
The embodiment of the invention also provides a computer readable storage medium, which stores a computer program for executing the report data query method.
In the embodiment of the invention, the report file is divided into a plurality of sub report files; storing a plurality of sub-report files into an IPFS system to obtain hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to the identifiers of the sub-report files one by one; after receiving a search instruction of a user, obtaining a hash value of the report file to be queried according to a file identification of the report file to be queried in the search instruction; and obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried. In the process, a plurality of sub-report files are stored in the IPFS system, hash values of each sub-report file on the IPFS system are obtained, and report files are inquired based on the hash values, so that the storage pressure and inquiry pressure of a central server are greatly reduced, the report data inquiry efficiency is improved, inquiry is not stopped because of problems of the central server, and the report data inquiry success rate is improved.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. In the drawings:
FIG. 1 is a flow chart of a method for querying report data in an embodiment of the invention;
FIG. 2 is a diagram of a system architecture for implementing a report data query method;
FIG. 3 is a detailed flowchart of a report data query method according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a report data query device according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a report data query system according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of a computer device in accordance with an embodiment of the invention;
fig. 7-9 are schematic diagrams of a bank report file according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention will be described in further detail with reference to the accompanying drawings. The exemplary embodiments of the present invention and their descriptions herein are for the purpose of explaining the present invention, but are not to be construed as limiting the invention.
In the description of the present specification, the terms "comprising," "including," "having," "containing," and the like are open-ended terms, meaning including, but not limited to. Reference to the terms "one embodiment," "a particular embodiment," "some embodiments," "for example," etc., means that a particular feature, structure, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present application. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiments or examples. Furthermore, the particular features, structures, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. The sequence of steps involved in the embodiments is used to schematically illustrate the practice of the present application, and is not limited thereto and may be appropriately adjusted as desired.
Fig. 1 is a flowchart of a method for querying report data according to an embodiment of the present invention, as shown in fig. 1, where the method includes:
102, storing a plurality of sub-report files to an IPFS system, and obtaining hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to identifiers of the sub-report files one by one;
and 104, obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried.
In the embodiment of the invention, a plurality of sub-report files are stored in the IPFS system, the hash value of each sub-report file on the IPFS system is obtained, and the report files are inquired based on the hash values, so that the storage pressure and the inquiry pressure of a central server are greatly reduced, the report data inquiry efficiency is improved, the inquiry is not stopped because of the occurrence of problems of the central server, and the report data inquiry success rate is improved.
In particular, the IPFS (Inter Planetary File System, interstellar file system) is a global, point-to-point distributed version of the file system, and aims to supplement (even replace) the hypertext transfer protocol (HTTP) currently governing the internet, to connect all computing devices with the same file system together, and to replace the domain name based address by a content based address, that is, the user finds content stored in a place instead of an address, without verifying the identity of the sender, but only by verifying the hash of the content, so that the web page can be faster, safer, more robust, and more durable. IPFS is a point-to-point distributed file system that connects computing devices all having the same file management mode.
The working principle of IPFS is as follows:
each file and all blocks therein have a cryptographically hashed hash value that uniquely identifies the file.
The IPFS can perform redundant file deletion for files having the same hash value, while keeping track of the history version record of each file.
The file searching mode in the IPFS is to search through the hash value of the file, and the node stored in the file and the file information related to the node can be determined through the hash value.
The system provides a decentralised naming system in such a way that the file name is easy to read, rather than reading the file by hash values.
Based on the advantages of the IPFS, the embodiment of the present invention adopts an IPFS system, where the IPFS system may include a plurality of IPFS nodes, so that the plurality of IPFS nodes need to be deployed first, and the steps of deploying the IPFS nodes under Linux are as follows:
(1) Mounting
First, the installation file is downloaded from the gitsub, and the command is as follows:
go get-u-d github.com/ipfs/go-ipfs
then, enter the download installation file directory, command is as follows:
cd$IPFSPATH/src/github.com/ipfs/go-ipfs
finally, the node is installed, commanded as follows:
make install
(2) Initialization of
The commands for initialization are as follows
ipfs init
(3) Joining IPFS networks
The networks that are added here are all local area networks because of the confidentiality of the statement data (e.g., bank statement data). In the installation process of the IPFS node, the access nodes of the data are all internal local area networks, and the data are transmitted through the local area networks, so that the rapid access of the data is realized. The commands to join the IPFS network are as follows:
ipfs daemon
the steps for deploying the IPFS node under Windows are as follows:
(1) Downloading client
Opening an ipfs network, finding a download page, downloading a client version corresponding to the Windows system, and downloading to obtain a compressed packet. Downloading links: https:// dist. Ipfs. Io/#go-ipfs
(2) Establishing an installation catalog and installing
Decompressing the compressed package to a disk folder with higher local control rate, creating an IPFS directory under the folder, and decompressing the file to the directory. Double clicking the ipfs.exe file therein runs once.
(3) Establishing and starting up a node
Open command prompt. The installation directory into the ipfs is ordered with cd, e.g. directory d:/ipfs/go-ipfs. The command is cd d/ipfs/go-ipfs, the ipfs command is input, and the initial document of the ipfs is checked. The document can be successfully viewed, indicating that the installation was successful. The input command ipfs init builds a node. After the IPFS node has been set up, it may be started by IPFS daemon. An installation directory of ipfs may be added to the system variables.
In particular, in step 101, there are various methods for dividing the report file into multiple sub-report files, and one of the embodiments is described below.
In one embodiment, splitting the report file into a plurality of sub-report files includes:
identifying a plurality of index information of the report file;
the report file is divided into a plurality of sub report files based on the plurality of index information.
In the above embodiment, firstly, a report file is to be read, taking a report file of a bank as an example, fig. 7-9 are schematic diagrams of a report file of a certain bank in the embodiment of the present invention, where the report file format is as follows, a row of row indexes beginning with 1@od@t@is used, the row indexes contain index information 1@od@t@org-ID 12345|rpt-ID CRDM5010|dat 2006/11/08|, where ORG-ID is a mechanism number, and 12345 is a mechanism number value; RPT-ID is report name, CRDM5010 is report name value; DAT is report date, 2006/11/08 is date value.
The report file includes 2 index information, so that the report file is divided into 2 sub report files, file one: the file name is CRDM5010.20161108.002. The index information of the file is 1@OD@T@ORG-ID: 12345|RPT-ID: CRDM5010|DAT:2006/11/08|. File two: the file name is CRDM5010.20161108.002. The index information of the file is 1@OD@T@ORG-ID: 12346|RPT-ID: CRDM5010|DAT:2006/11/08|.
In step 102, a plurality of sub-report files need to be stored in the IPFS system, and a hash value of each sub-report file on the IPFS system is obtained, where a command for storing the plurality of sub-report files in the IPFS system is as follows, and name is an identifier of the sub-report file, which may be a name:
ipfs add name
for example, the commands to store the first and second files to the IPFS system are as follows:
CRDM5010.20161108.001
ipfs add CRDM5010.20161108.002
by executing the command, CRDM5010.20161108.001 obtains the hash value of the report file in IPFS as QmcKi2a33uGb1kBg yBpsuwoabfmcByddMiZ2pukxxLyD8 after loading; CRDM5010.20161108.002 the hash value of the report file in IPFS is QmcKi2a33uGb1kAg yBpsuwSabfmcByddMiZ2pukxxLyD6.
In an embodiment, the method further comprises:
transmitting the file identification and the hash value of the sub-report file to a central database;
obtaining a hash value of the report file to be queried according to the file identification of the report file to be queried in the retrieval instruction, including:
and querying a central database according to the file identification of the report file to be queried in the retrieval instruction, and obtaining the hash value of the report file to be queried.
In the above embodiment, in addition to the above file identification and hash value, the search information may be sent to the central database together, for example, the data of the above file one and file two sent to the central database is shown in table 1, where the file identification is a file name.
Table 1 data sent to a central database
After the retrieval information is sent to the central database, the central database analyzes and obtains the information such as file names, organization numbers, report dates and the like in the index information, and then the information is loaded into the central database in a shell batch script mode, so that the hash value of the report file can be conveniently recorded, the subsequent search of the report file can be conveniently carried out, namely, the central database is queried according to the file identification of the report file to be queried in the retrieval instruction, and the hash value of the report file to be queried is obtained. And then, obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried.
In addition, in step 103, to first receive a search instruction of the user, the search instruction of the user may be triggered by a report file to be displayed selected by the user in a front-end application system (there may be a plurality of application servers).
In an embodiment, the central database is an ORACLE distributed database, and the ORACLE distributed database can fully ensure the security of report data.
Fig. 2 is a system architecture diagram for implementing a report data query method, in which a plurality of IPFS nodes form an IPFS system, which corresponds to an application server, and based on fig. 2, the present invention proposes a detailed flow chart for describing a report data query method according to the following embodiment, and fig. 3 is a detailed flow chart of a report data query method according to the embodiment of the present invention, as shown in fig. 3, including:
Of course, it is to be understood that other variations of the above detailed procedures are also possible, and all related variations should fall within the protection scope of the present invention.
In summary, in the method provided by the embodiment of the present invention, the report file is divided into a plurality of sub report files; storing a plurality of sub-report files into an IPFS system to obtain hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to the identifiers of the sub-report files one by one; after receiving a search instruction of a user, obtaining a hash value of the report file to be queried according to a file identification of the report file to be queried in the search instruction; and obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried. In the process, a plurality of sub-report files are stored in the IPFS system, hash values of each sub-report file on the IPFS system are obtained, and report files are inquired based on the hash values, so that the storage pressure and inquiry pressure of a central server are greatly reduced, the report data inquiry efficiency is improved, inquiry is not stopped because of problems of the central server, and the report data inquiry success rate is improved. In addition, the invention improves the report downloading speed and the data inquiring speed. The IPFS system can comprise a plurality of IPFS nodes, so that the IPFS nodes are deployed in a plurality of idle disk spaces, and the effective utilization rate of the disks is increased. Because the central server only provides the storage and query service of index information of report files, the storage function and the query function are decoupled.
The embodiment of the invention also provides a report data query device, the principle of which is similar to that of a report data query method, and the description is omitted here.
Fig. 4 is a schematic diagram of a report data query device according to an embodiment of the present invention, as shown in fig. 4, where the device includes:
the segmentation module 401 is configured to segment the report file into a plurality of sub-report files;
the hash value generating module 402 is configured to store a plurality of sub-report files to the IPFS system, and obtain hash values of each sub-report file on the IPFS system, where the hash values of each sub-report file correspond to identifiers of the sub-report files one by one;
the first query module 403 is configured to obtain a hash value of the report file to be queried according to a file identifier of the report file to be queried in the search instruction after receiving the search instruction of the user;
and the second query module 404 is configured to obtain the report file to be queried from the IPFS system according to the hash value of the report file to be queried.
In one embodiment, the segmentation module 401 is specifically configured to:
identifying a plurality of index information of the report file;
the report file is divided into a plurality of sub report files based on the plurality of index information.
In an embodiment, the apparatus further comprises a saving module 405 for:
transmitting the file identification and the hash value of the sub-report file to a central database;
the first query module 403 is specifically configured to:
and querying a central database according to the file identification of the report file to be queried in the retrieval instruction, and obtaining the hash value of the report file to be queried.
In one embodiment, the central database is an ORACLE distributed database.
In summary, in the device provided by the embodiment of the invention, the report file is divided into a plurality of sub report files; storing a plurality of sub-report files into an IPFS system to obtain hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to the identifiers of the sub-report files one by one; after receiving a search instruction of a user, obtaining a hash value of the report file to be queried according to a file identification of the report file to be queried in the search instruction; and obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried. In the process, a plurality of sub-report files are stored in the IPFS system, hash values of each sub-report file on the IPFS system are obtained, and report files are inquired based on the hash values, so that the storage pressure and inquiry pressure of a central server are greatly reduced, the report data inquiry efficiency is improved, inquiry is not stopped because of problems of the central server, and the report data inquiry success rate is improved. In addition, the invention improves the report downloading speed and the data inquiring speed. The IPFS system can comprise a plurality of IPFS nodes, so that the IPFS nodes are deployed in a plurality of idle disk spaces, and the effective utilization rate of the disks is increased. Because the central server only provides the storage and query service of index information of report files, the storage function and the query function are decoupled.
An embodiment of the present invention proposes a report data query system, and fig. 5 is a schematic diagram of the report data query system in the embodiment of the present invention, as shown in fig. 5, where the system includes a report data query device 501, a central server 502, and an IPFS system 503, where the IPFS system includes a plurality of IPFS nodes.
In summary, in the system provided by the embodiment of the present invention, the report data query device divides the report file into a plurality of sub-report files; storing a plurality of sub-report files into an IPFS system to obtain hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to the identifiers of the sub-report files one by one; after receiving a search instruction of a user, obtaining a hash value of the report file to be queried according to a file identification of the report file to be queried in the search instruction; and obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried. In the process, a plurality of sub-report files are stored in the IPFS system, hash values of each sub-report file on the IPFS system are obtained, and report files are inquired based on the hash values, so that the storage pressure and inquiry pressure of a central server are greatly reduced, the report data inquiry efficiency is improved, inquiry is not stopped because of problems of the central server, and the report data inquiry success rate is improved. In addition, the invention improves the report downloading speed and the data inquiring speed. The IPFS system can comprise a plurality of IPFS nodes, so that the IPFS nodes are deployed in a plurality of idle disk spaces, and the effective utilization rate of the disks is increased. Because the central server only provides the storage and query service of index information of report files, the storage function and the query function are decoupled.
The embodiment of the present application further provides a computer device, and fig. 6 is a schematic diagram of the computer device in the embodiment of the present invention, where the computer device can implement all the steps in the report data query method in the foregoing embodiment, and the electronic device specifically includes the following contents:
a processor (processor) 601, a memory (memory) 602, a communication interface (Communications Interface) 603, and a bus 604;
wherein the processor 601, the memory 602, and the communication interface 603 complete communication with each other through the bus 604; the communication interface 603 is configured to implement information transmission between related devices such as a server device, a detection device, and a user device;
the processor 601 is configured to invoke a computer program in the memory 602, where the processor executes the computer program to implement all the steps in the report data query method in the foregoing embodiment.
The embodiment of the present application further provides a computer readable storage medium, which can implement all the steps in the report data query method in the above embodiment, and the computer readable storage medium stores a computer program, where the computer program when executed by a processor implements all the steps in the report data query method in the above embodiment.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the invention, and is not meant to limit the scope of the invention, but to limit the invention to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the invention are intended to be included within the scope of the invention.
Claims (7)
1. The report data query method is characterized by comprising the following steps of:
dividing the report file into a plurality of sub report files;
storing a plurality of sub-report files into an IPFS system to obtain hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to the identifiers of the sub-report files one by one;
after receiving a search instruction of a user, obtaining a hash value of the report file to be queried according to a file identification of the report file to be queried in the search instruction;
obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried;
dividing the report file into a plurality of sub report files, including: identifying a plurality of index information of the report file;
dividing the report file into a plurality of sub report files based on a plurality of index information;
the method further comprises the steps of:
transmitting the file identification and the hash value of the sub-report file to a central database;
obtaining a hash value of the report file to be queried according to the file identification of the report file to be queried in the retrieval instruction, including: inquiring a central database according to the file identification of the report file to be inquired in the retrieval instruction, and obtaining the hash value of the report file to be inquired;
the method further comprises the steps of: the search information is sent to a central database;
the central database analyzes and obtains the file name, the organization number, the report number and the report date in the index information, and then loads the file name, the organization number, the report number and the report date into the central database in a shell batch script mode, and records the hash value of the report file.
2. The report data query method of claim 1, wherein the central database is an ORACLE distributed database.
3. A report data query device, comprising:
the splitting module is used for splitting the report file into a plurality of sub report files;
the hash value generation module is used for storing a plurality of sub-report files to the IPFS system, so as to obtain hash values of each sub-report file on the IPFS system, wherein the hash values of each sub-report file correspond to the identifiers of the sub-report files one by one;
the first query module is used for obtaining the hash value of the report file to be queried according to the file identification of the report file to be queried in the search instruction after receiving the search instruction of the user;
the second query module is used for obtaining the report file to be queried from the IPFS system according to the hash value of the report file to be queried;
the segmentation module is specifically used for: identifying a plurality of index information of the report file; dividing the report file into a plurality of sub report files based on a plurality of index information;
the apparatus further comprises a saving module for: transmitting the file identification and the hash value of the sub-report file to a central database;
the first query module is specifically configured to: inquiring a central database according to the file identification of the report file to be inquired in the retrieval instruction, and obtaining the hash value of the report file to be inquired;
the save module is also for: the retrieval information is sent to a central database; the central database analyzes and obtains the file name, the organization number, the report number and the report date in the index information, and then loads the file name, the organization number, the report number and the report date into the central database in a shell batch script mode, and records the hash value of the report file.
4. The report data querying device as in claim 3, wherein the central database is an ORACLE distributed database.
5. A report data query system, comprising: the report data querying device, central server, IPFS system of any one of claims 3 to 4.
6. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 2 when executing the computer program.
7. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program for executing the method of any one of claims 1 to 2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010362318.XA CN111563083B (en) | 2020-04-30 | 2020-04-30 | Report data query method, device and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010362318.XA CN111563083B (en) | 2020-04-30 | 2020-04-30 | Report data query method, device and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111563083A CN111563083A (en) | 2020-08-21 |
| CN111563083B true CN111563083B (en) | 2023-04-28 |
Family
ID=72070772
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010362318.XA Active CN111563083B (en) | 2020-04-30 | 2020-04-30 | Report data query method, device and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111563083B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112348140B (en) * | 2020-11-27 | 2023-04-18 | 杭州安恒信息技术股份有限公司 | Bar code information storage method, query method, electronic device and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109471889A (en) * | 2018-09-19 | 2019-03-15 | 平安科技（深圳）有限公司 | Report accelerated method, system, computer equipment and storage medium |
| CN110032567A (en) * | 2019-04-24 | 2019-07-19 | 江苏满运软件科技有限公司 | Report form inquiring method, device, server and storage medium |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2010271797A (en) * | 2009-05-19 | 2010-12-02 | Nippon Telegr & Teleph Corp <Ntt> | Method, device and program for managing data position in distributed storage |
| CN105260136B (en) * | 2015-09-24 | 2019-04-05 | 北京百度网讯科技有限公司 | Data read-write method and distributed memory system |
| CN108710681B (en) * | 2018-05-18 | 2022-02-22 | 腾讯科技（深圳）有限公司 | File acquisition method, device, equipment and storage medium |
| CN109992563A (en) * | 2019-01-18 | 2019-07-09 | 阿里巴巴集团控股有限公司 | A kind of service scripts storage method and device based on block chain |
-
2020
- 2020-04-30 CN CN202010362318.XA patent/CN111563083B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109471889A (en) * | 2018-09-19 | 2019-03-15 | 平安科技（深圳）有限公司 | Report accelerated method, system, computer equipment and storage medium |
| CN110032567A (en) * | 2019-04-24 | 2019-07-19 | 江苏满运软件科技有限公司 | Report form inquiring method, device, server and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 张小虎等.基于BIRT的报表搜索.小型微型计算机系统.2017,全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111563083A (en) | 2020-08-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108133008B (en) | Method, device, equipment and storage medium for processing service data in database | |
| US9135322B2 (en) | Environment classification | |
| CN102725755B (en) | Method and system of file access | |
| US7487551B2 (en) | Access to content addressable data over a network | |
| AU757667B2 (en) | Access to content addressable data over a network | |
| CN110689349B (en) | Transaction hash value storage and searching method and device in blockchain | |
| CN110647503A (en) | Distributed storage method and device | |
| JP7279904B2 (en) | Chain data verification system and method | |
| CN103532754A (en) | System and method for high-speed memory and distributed type processing of massive logs | |
| CN102253991B (en) | Uniform resource locator (URL) storage method, web filtering method, device and system | |
| US9600486B2 (en) | File system directory attribute correction | |
| US20230289782A1 (en) | Smart contract-based data processing | |
| US11323264B2 (en) | Validating tracked portions of received sensor data using computer cryptographic processing | |
| CN113821478A (en) | Block chain-based large file storage method and system | |
| CN111563083B (en) | Report data query method, device and system | |
| CN105765570B (en) | Music recognition | |
| US11494392B2 (en) | Tracking entity activity using computer generation of values for blockchain network entries | |
| CN113111125A (en) | Business evidence storage method based on block chain | |
| CN110928923A (en) | Data storage method and system based on block chain | |
| US20110047165A1 (en) | Network cache, a user device, a computer program product and a method for managing files | |
| CN115757642A (en) | Data synchronization method and device based on filing log file | |
| CN103778223A (en) | Pervasive word-reciting system based on cloud platform and construction method thereof | |
| CN112671842B (en) | Information transmission method and device, electronic equipment and readable storage medium | |
| CN111404936B (en) | File forwarding system and method | |
| CN112597119A (en) | Method and device for generating processing log and storage medium |
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 |