A method for avoiding cross-node join in the database stored in a distributed manner for a large-scale social network system

摘要

A method for avoiding joins between nodes in a database distributed to a plurality of nodes is disclosed. The method includes the steps of: modeling a continuous 1: N relation in a database stored in a plurality of nodes in a continuous identification relationship to assign a primary key of a first one-side relation to the remaining relations, Modeling entity sets participating in a continuous 1: N relation stored in a database into a continuous identifying relation, and mapping the modeled consecutive identity relations and the entity sets into a relation .