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

Descargo de responsabilidad: este resumen se tradujo utilizando herramientas de inteligencia artificial y aún no ha sido revisado ni verificado.

Indexado en

Google Académico
Academic Journals Database
Open J Gate
Academic Keys
ResearchBible
CiteFactor
Biblioteca de revistas electrónicas
Búsqueda de referencia
Universidad Hamdard
director académico
Factor de impacto de revistas innovadoras internacionales (IIJIF)
Instituto Internacional de Investigación Organizada (I2OR)
Cosmos

Ver más