CN115062068A - Correlation search and multistage relation query method - Google Patents
Correlation search and multistage relation query method Download PDFInfo
- Publication number
- CN115062068A CN115062068A CN202210814136.0A CN202210814136A CN115062068A CN 115062068 A CN115062068 A CN 115062068A CN 202210814136 A CN202210814136 A CN 202210814136A CN 115062068 A CN115062068 A CN 115062068A
- Authority
- CN
- China
- Prior art keywords
- query
- identification information
- information
- association
- database
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 230000000977 initiatory effect Effects 0.000 claims abstract description 9
- 238000005192 partition Methods 0.000 claims description 29
- 238000001914 filtration Methods 0.000 claims description 17
- 238000012795 verification Methods 0.000 claims description 17
- 238000004891 communication Methods 0.000 claims description 8
- 239000000284 extract Substances 0.000 claims description 8
- 230000006870 function Effects 0.000 claims description 7
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 238000013500 data storage Methods 0.000 claims description 6
- 238000005516 engineering process Methods 0.000 claims description 6
- 230000000694 effects Effects 0.000 claims description 5
- 238000012545 processing Methods 0.000 description 4
- 238000012550 audit Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012797 qualification Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000012502 risk assessment Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- 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/2453—Query optimisation
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides an association search and multistage relation query method, which comprises five steps of building a query platform, initiating a query requirement, converting the query requirement, querying the association relation and feeding back results.
Description
Technical Field
The invention relates to the field of data processing, in particular to a correlation search and multistage relation query method.
Background
With the development and popularization of computer network technology and database technology, more and more enterprises rely on management software to manage and maintain daily business, all kinds of business data are actually data examples of certain business types, the business data of all kinds of business types do not exist independently, and the business data have thousands of business relations;
in the enterprise risk analysis and early warning scene, there are often needs to mine enterprise affiliates and further analyze enterprise affiliation risks, such as credit qualification audit of enterprises by banks, finance research and mining enterprise risk clues, and the like, however, the existing data systems are numerous, and as the query quantity increases, the efficiency of the conventional manual query mode is low, and the existing social needs cannot be met, so that the invention provides an association search and multistage relationship query method to solve the problems in the prior art.
Disclosure of Invention
In view of the above problems, the present invention provides a method for association search and multi-level relationship query, which has a more convenient association and multi-level relationship query method, thereby solving the problem of low query efficiency in the prior art.
In order to realize the purpose of the invention, the invention is realized by the following technical scheme: a method for association search and multi-stage relation query comprises the following steps:
step one, building an inquiry platform
Establishing an incidence relation query platform based on a web platform, wherein the incidence relation query platform comprises a login unit for a user login platform, a verification unit for verifying login information of the user, an interface unit for providing an access function, an information query unit for initiating an information query request and an information feedback unit for feeding back a query result, and then establishing communication connection between the incidence relation query platform and a server through a wireless communication technology, and meanwhile, a query database and a processor are arranged in the server;
step two, initiating query requirements
A user logs in the established incidence relation query platform in the first step, and sends a query demand to a server through an information query unit, wherein the query demand carries main body identification information and classification identification information;
step three, query requirement conversion
After receiving the query requirement sent in the second step, a processor in the server converts the query requirement, and converts the query requirement into a query statement of a programming language type;
step four, association relation query
The processor executes the query statement of the programming language type converted in the third step, calls the data in the query database, carries out recursive call query, acquires the database partition corresponding to the main body identification information, acquires the incidence relation table in the database partition, and calls the incidence relation table into the information feedback unit;
step five, result feedback
After the information feedback unit receives the association table, an association filtering module is arranged in the information feedback unit, the association filtering module acquires the classification identification information carried by the query requirement in the second step, and extracts and filters data according to the acquired classification identification information, namely, the association corresponding to the classification identification information is queried in the acquired association table through the classification identification information, and the feedback is carried out.
The further improvement lies in that: in the first step, a distributed data storage mode is adopted for data in the query database, that is, a plurality of database partitions are arranged in the query database, different association tables are respectively stored in the plurality of database partitions, corresponding partition identification information is respectively preset in the plurality of database partitions, and the partition identification information corresponds to the main body identification information.
The further improvement is that: in the first step, the input end of the interface unit is connected with the output end of the verification unit, and the interface unit is used for enabling the association relation query platform to have the effect of user identity verification.
The further improvement lies in that: in the first step, a user information database is also arranged in the server, and the input end of the user information database is connected with the output end of the login unit.
The further improvement lies in that: in the second step, after the user logs in the association relation query platform, the information of the user needs to be verified through the verification unit.
The further improvement lies in that: in the second step, when a plurality of subject identification information is included, the plurality of subject identification information is separately queried, and if the subject identification information which fails to match the result is included, the subject identification information is ignored.
The further improvement lies in that: and in the third step, an association relation filtering module is arranged in the information feedback unit, and the association relation filtering module acquires the classification identification information carried by the query requirement in the second step and extracts and filters the data according to the acquired classification identification information.
The further improvement lies in that: and in the fifth step, a data summarizing module is further arranged in the information feedback unit and is used for merging the inquired data results.
The invention has the beneficial effects that: according to the association search and multistage relationship query method, an association relationship query platform is built, users can log in by themselves for query conveniently, a manual query mode is replaced, a plurality of users can perform query operation simultaneously, query efficiency is effectively improved, meanwhile, a distributed data storage mode is adopted, namely data are stored in a classified mode, during query, partition identification information corresponding to classified storage is matched with main identification information of query requirements, pressure of initial data processing is reduced, targeted data query is performed according to matching results subsequently, and the association search and multistage relationship query efficiency is improved.
Drawings
Fig. 1 is a schematic front view of a structure according to a first embodiment of the present invention.
Detailed Description
For the purpose of enhancing understanding of the present invention, the present invention will be further described in detail with reference to the following examples, which are provided for illustration only and are not intended to limit the scope of the present invention.
Example one
As shown in fig. 1, the present embodiment provides a method for association search and multi-level relationship query, including the following steps:
step one, building an inquiry platform
Building an incidence relation query platform based on a web platform, wherein the incidence relation query platform comprises a login unit for a user login platform, a verification unit for verifying login information of the user, an interface unit for providing an access function, an information query unit for initiating an information query request and an information feedback unit for feeding back a query result, and then the incidence relation query platform is in communication connection with a server through a wireless communication technology, and meanwhile, a query database and a processor are arranged in the server, in the first step, the query database adopts a distributed data storage mode for data, namely, a plurality of groups of database partitions are arranged in the query database, the plurality of groups of database partitions respectively store different incidence relation tables, the plurality of groups of database partitions are respectively preset with corresponding partition identification information, and the partition identification information is corresponding to main body identification information, in the first step, the input end of the interface unit is connected with the output end of the verification unit, the interface unit is used for enabling the incidence relation query platform to have the effect of user identity verification, in the first step, a user information database is further arranged in the server, and the input end of the user information database is connected with the output end of the login unit;
step two, initiating query requirements
A user logs in the established incidence relation query platform in the first step and sends a query demand to a server through an information query unit, wherein the query demand carries main body identification information and classification identification information, in the second step, the user needs to verify the information of the user through a verification unit after logging in the incidence relation query platform, in the second step, when a plurality of main body identification information is contained, the main body identification information is separately queried, and if the main body identification information which cannot be matched with a result is contained, the main body identification information is ignored;
step three, query requirement conversion
After receiving the query requirement sent in the second step, a processor in the server performs conversion processing on the query requirement, and converts the query requirement into a query statement of a programming language type, wherein in the third step, an association relationship filtering module is arranged in the information feedback unit, acquires the classification identification information carried by the query requirement in the second step, and extracts and filters data according to the acquired classification identification information;
step four, incidence relation query
The processor executes the query statement of the programming language type converted in the third step, calls the data in the query database, carries out recursive call query, acquires the database partition corresponding to the main body identification information, acquires the incidence relation table in the database partition, and calls the incidence relation table into the information feedback unit;
step five, result feedback
After the information feedback unit receives the association table, an association filtering module is arranged in the information feedback unit, the association filtering module acquires the classification identification information carried by the query requirement in the second step, and extracts and filters data according to the acquired classification identification information, namely, the association corresponding to the classification identification information is queried in the acquired association table through the classification identification information, and the feedback is carried out.
Example two
The embodiment provides a method for association search and multistage relation query, which comprises the following steps:
step one, building an inquiry platform
Building an incidence relation query platform based on a web platform, wherein the incidence relation query platform comprises a login unit for a user login platform, a verification unit for verifying login information of the user, an interface unit for providing an access function, an information query unit for initiating an information query request and an information feedback unit for feeding back a query result, and then the incidence relation query platform is in communication connection with a server through a wireless communication technology, and meanwhile, a query database and a processor are arranged in the server, in the first step, the query database adopts a distributed data storage mode for data, namely, a plurality of groups of database partitions are arranged in the query database, the plurality of groups of database partitions respectively store different incidence relation tables, the plurality of groups of database partitions are respectively preset with corresponding partition identification information, and the partition identification information is corresponding to main body identification information, in the first step, the input end of the interface unit is connected with the output end of the verification unit, the interface unit is used for enabling the incidence relation inquiry platform to have the effect of user identity verification, in the first step, a user information database is also arranged in the server, and the input end of the user information database is connected with the output end of the login unit, wherein the function of the interface unit is not only the function of providing an identity verification interface for the platform, but also the function of the interface unit can be expanded, the interface unit has the effect of a short message platform interface, even if the incidence relation inquiry platform can be bound with the mobile phone number of a user, after the incidence relation inquiry is carried out, the inquired result is sent to the mobile phone of the user in a short message mode;
step two, initiating query requirements
A user logs in the established incidence relation query platform in the first step and sends a query demand to a server through an information query unit, wherein the query demand carries main body identification information and classification identification information, in the second step, the user needs to verify the information of the user through a verification unit after logging in the incidence relation query platform, in the second step, when a plurality of main body identification information is contained, the main body identification information is separately queried, if the main body identification information which cannot be matched with a result is contained, the main body identification information is ignored, wherein the main body identification information is a main object, such as name, area and the like, and the classification identification information is a relation behind the main object, such as wage, loan and the like, and is used for obtaining a multilevel relation of the main body identification information;
step three, query requirement conversion
After receiving the query requirement sent in the second step, a processor in the server performs conversion processing on the query requirement, and converts the query requirement into a query statement of a programming language type, wherein in the third step, an association filtering module is arranged in the information feedback unit, the association filtering module acquires the classification identification information carried by the query requirement in the second step, and extracts and filters the data according to the acquired classification identification information, namely, the data matched with the classification identification information can pass through the association filtering module, and the unmatched data cannot pass through the association filtering module, namely, the unmatched data cannot be output;
step four, association relation query
The processor executes the query statement of the programming language type converted in the third step, calls the data in the query database, carries out recursive call query, acquires the database partition corresponding to the main body identification information, acquires the incidence relation table in the database partition, and calls the incidence relation table into the information feedback unit;
step five, result feedback
After the information feedback unit receives the association table, an association filtering module is arranged in the information feedback unit, the association filtering module acquires the classification identification information carried by the query requirement in the second step, and extracts and filters data according to the acquired classification identification information, namely, the association corresponding to the classification identification information is queried in the acquired association table through the classification identification information and feeds back the association.
In the first embodiment and the second embodiment, the association table in the query database is preset relationship table data and is used for users to query, the invention facilitates users to log in for query by themselves by constructing an association table query platform, replaces a manual query mode, enables a plurality of users to perform query operation simultaneously, effectively improves the query efficiency, and meanwhile, adopts a distributed data storage mode, namely, data is stored in a classified mode.
The foregoing illustrates and describes the principles, general features, and advantages of the present invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (8)
1. A method for correlation search and multi-stage relation query is characterized in that: the method comprises the following steps:
step one, building an inquiry platform
Establishing an incidence relation query platform based on a web platform, wherein the incidence relation query platform comprises a login unit for a user login platform, a verification unit for verifying login information of the user, an interface unit for providing an access function, an information query unit for initiating an information query request and an information feedback unit for feeding back a query result, and then establishing communication connection between the incidence relation query platform and a server through a wireless communication technology, and meanwhile, a query database and a processor are arranged in the server;
step two, initiating query requirements
A user logs in the established incidence relation query platform in the first step, and sends a query demand to a server through an information query unit, wherein the query demand carries main body identification information and classification identification information;
step three, query requirement conversion
After receiving the query requirement sent in the second step, a processor in the server converts the query requirement, and converts the query requirement into a query statement of a programming language type;
step four, association relation query
The processor executes the query statement of the programming language type converted in the third step, calls the data in the query database, carries out recursive call query, acquires the database partition corresponding to the main body identification information, acquires the incidence relation table in the database partition, and calls the incidence relation table into the information feedback unit;
step five, result feedback
After the information feedback unit receives the association table, an association filtering module is arranged in the information feedback unit, the association filtering module acquires the classification identification information carried by the query requirement in the second step, and extracts and filters data according to the acquired classification identification information, namely, the association corresponding to the classification identification information is queried in the acquired association table through the classification identification information, and the feedback is carried out.
2. The method of claim 1, wherein the method comprises: in the first step, a distributed data storage mode is adopted for data in the query database, that is, a plurality of database partitions are arranged in the query database, different association tables are respectively stored in the plurality of database partitions, corresponding partition identification information is respectively preset in the plurality of database partitions, and the partition identification information corresponds to the main body identification information.
3. The method of claim 1, wherein the method comprises: in the first step, the input end of the interface unit is connected with the output end of the verification unit, and the interface unit is used for enabling the association relation query platform to have the effect of user identity verification.
4. The method of claim 1, wherein the method comprises: in the first step, a user information database is also arranged in the server, and the input end of the user information database is connected with the output end of the login unit.
5. The method of claim 1, wherein the method comprises: in the second step, after the user logs in the association relation query platform, the information of the user needs to be verified through the verification unit.
6. The method of claim 1, wherein the method comprises: in the second step, when a plurality of subject identification information is included, the plurality of subject identification information is separately queried, and if the subject identification information which fails to match the result is included, the subject identification information is ignored.
7. The method of claim 1, wherein the association search and multi-stage relation query method comprises: and in the third step, an association relation filtering module is arranged in the information feedback unit, and the association relation filtering module acquires the classification identification information carried by the query requirement in the second step and extracts and filters the data according to the acquired classification identification information.
8. The method of claim 1, wherein the method comprises: and in the fifth step, a data summarizing module is further arranged in the information feedback unit and is used for merging the inquired data results.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210814136.0A CN115062068A (en) | 2022-07-12 | 2022-07-12 | Correlation search and multistage relation query method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210814136.0A CN115062068A (en) | 2022-07-12 | 2022-07-12 | Correlation search and multistage relation query method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115062068A true CN115062068A (en) | 2022-09-16 |
Family
ID=83205475
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210814136.0A Pending CN115062068A (en) | 2022-07-12 | 2022-07-12 | Correlation search and multistage relation query method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115062068A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103593419A (en) * | 2013-10-30 | 2014-02-19 | 华为技术有限公司 | Method, device, server and system for inquiring data |
| CN107016001A (en) * | 2016-01-28 | 2017-08-04 | 阿里巴巴集团控股有限公司 | A kind of data query method and device |
| US9817891B1 (en) * | 2013-04-03 | 2017-11-14 | Amdocs Software Systems Limited | System, method, and computer program for creating metadata-based search queries |
| CN109543096A (en) * | 2018-10-15 | 2019-03-29 | 平安科技（深圳）有限公司 | Data query method, apparatus, computer equipment and storage medium |
| CN110489441A (en) * | 2019-08-12 | 2019-11-22 | 厦门商集网络科技有限责任公司 | A kind of extemporaneous querying method and equipment based on big data |
| CN112052252A (en) * | 2019-06-06 | 2020-12-08 | 阿里巴巴集团控股有限公司 | Data query method and device based on associated database |
| CN112307052A (en) * | 2020-10-28 | 2021-02-02 | 北京锐安科技有限公司 | Data management method, service system, terminal and storage medium |
-
2022
- 2022-07-12 CN CN202210814136.0A patent/CN115062068A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9817891B1 (en) * | 2013-04-03 | 2017-11-14 | Amdocs Software Systems Limited | System, method, and computer program for creating metadata-based search queries |
| CN103593419A (en) * | 2013-10-30 | 2014-02-19 | 华为技术有限公司 | Method, device, server and system for inquiring data |
| CN107016001A (en) * | 2016-01-28 | 2017-08-04 | 阿里巴巴集团控股有限公司 | A kind of data query method and device |
| CN109543096A (en) * | 2018-10-15 | 2019-03-29 | 平安科技（深圳）有限公司 | Data query method, apparatus, computer equipment and storage medium |
| CN112052252A (en) * | 2019-06-06 | 2020-12-08 | 阿里巴巴集团控股有限公司 | Data query method and device based on associated database |
| CN110489441A (en) * | 2019-08-12 | 2019-11-22 | 厦门商集网络科技有限责任公司 | A kind of extemporaneous querying method and equipment based on big data |
| CN112307052A (en) * | 2020-10-28 | 2021-02-02 | 北京锐安科技有限公司 | Data management method, service system, terminal and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108446341B (en) | Service state query method and device, computer equipment and storage medium | |
| CN102110170B (en) | System with information distribution and search functions and information distribution method | |
| CN101556678A (en) | Processing method of batch processing services, system and service processing control equipment | |
| CN103064933A (en) | Data query method and system | |
| CN105446991A (en) | Data storage method, query method and device | |
| CN102236672A (en) | Method and device for importing data | |
| CN102073640A (en) | Method, system and server for testing structured query language (SQL) statements | |
| CN106777027B (en) | Large-scale parallel processing row-column mixed data storage device and storage and query method | |
| CN108228787B (en) | Method and device for processing information according to multi-level categories | |
| US6820073B1 (en) | System and method for multiple pass cooperative processing | |
| US11537785B1 (en) | Spreadsheet flat data extractor | |
| CN105630995A (en) | Method and system for querying credit | |
| CN102364475A (en) | System and method for sequencing search results based on identity recognition | |
| CN114327374A (en) | Business process generation method and device and computer equipment | |
| CN115062068A (en) | Correlation search and multistage relation query method | |
| CN116628018A (en) | Data query method, device, server and storage medium | |
| US8229946B1 (en) | Business rules application parallel processing system | |
| CN110689386A (en) | Electronic bill issuing method and system | |
| CN114971598A (en) | Wind-controlled approval system, method, equipment and medium | |
| CN106874498B (en) | Financial data access method and access device | |
| CN115344633A (en) | Data processing method, device, equipment and storage medium | |
| CN111159213A (en) | Data query method, device, system and storage medium | |
| CN115292580A (en) | Data query method and device, computer equipment and storage medium | |
| WO2021159668A1 (en) | Robot dialogue method and apparatus, computer device and storage medium | |
| CN113190562A (en) | Report generation method and device and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20220916 |