Multi-table associated data query method, system and equipment

• Main Authors: LUO HAIDONG, HU BIN, XU CHENG
• Format: Patent
• Language: Chinese; English
• Published: 14.07.2023
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention discloses a multi-table associated data query method, system and equipment, and relates to the field of data query. The method comprises the following steps: constructing an index field, and storing the index field into a plurality of tables; screening data in a plurality of tables according to a sequence through the same index field; and filtering the screened data according to the primary and foreign keys of the plurality of tables. According to the method and the device, the query efficiency of the multiple tables during associated query can be improved. 本发明公开了一种多表关联的数据查询方法、系统及设备，涉及数据查询领域。该方法包括：构建索引字段，并将所述索引字段存储到多个表中；通过相同的所述索引字段按照顺序筛选多个表中的数据；根据多个表的主外键对筛选到的数据进行过滤。本发明能够提高多张表在进行关联查询时的查询效率。