Abstracto

Prime Factor Attribute on Entity to increase the performance of read-only statements in Many-to-Many relationship

M.S. Vasantharaju

It is very common to encounter many-to-many relationship where an entity will resolve into a Lookup or Reference Table while designing relational database. And using an associative entity [4] is not always a better solution as it involves a separate table and joins reduce the performance of the SQL-Data statements. This paper discusses about how adding a prime factor attribute on an entity instead of adding an associative entity improves the performance of SQL-Data statements if at least one entity in man-to-many relationship will resolve into Lookup table and number of entity-occurrence is less than 20 for best optimization