Inter-table correlation query method and device

2014 
The invention provides an inter-table correlation query method and device. The inter-table correlation query method and device can shorten the time of inter-table correlation query and increase the speed of inter-table correlation query. The method includes the steps that query indicating information is obtained, the query indicating information carries a first query condition, and instruction is conducted, so that a first query result is obtained from N tables according to the first query condition; the Mth corresponding relation between the Mth table and the (M+1)th table is established according to the correlation relation between the major key value of the Mth table in the N tables and the foreign key value of the (M+1)th table; the first query result is obtained according to the selection conditions in all the N tables in the first query condition and the number of times of the Mth identification corresponding to the (M+1)th identification in the Mth corresponding relation. The inter-table correlation query method and device are suitable for the field of computers.
    • Correction
    • Source
    • Cite
    • Save
    • Machine Reading By IdeaReader
    0
    References
    0
    Citations
    NaN
    KQI
    []