Hierarchical data query method and device
The invention provides a hierarchical data query method and device, which can be applied to the field of big data or finance, and can be used for obtaining a plurality of assigned rules by assigning a configured field as 1 and an unconfigured field as-1 in each rule in a rule table. The method compr...
Saved in:
| Main Author | |
|---|---|
| Format | Patent |
| Language | Chinese English |
| Published |
11.10.2022
|
| Subjects | |
| Online Access | Get full text |
Cover
Loading…
| Summary: | The invention provides a hierarchical data query method and device, which can be applied to the field of big data or finance, and can be used for obtaining a plurality of assigned rules by assigning a configured field as 1 and an unconfigured field as-1 in each rule in a rule table. The method comprises the following steps: assigning a plurality of rules to a database, carrying out deduplication processing on the plurality of assigned rules to obtain a code table comprising a small number of matching rules, and after a data query request is received, traversing all possible matching rules in the code table and exhaustion rule table, and fully utilizing the association performance of the database, so that the data query efficiency is improved. The left connection is continuously used for multiple times for multiple times of association of the same rule table, accurate matching of the main table and the rule table is achieved, the query duration is effectively shortened, and the query efficiency is improved.
本发 |
|---|---|
| Bibliography: | Application Number: CN202210922883 |