AN ADVANCED MODEL FOR MULTI-VALUED ATTRIBUTE ORDERING TUPLES IN RELATION FROM RELATIONAL DATABASE MANAGEMENT SYSTEM USING DYNASEQ TUPLE ORDERING ALGORITHM (DTOA)


Kavish A M
Roll No: 6714, Sainik School Amaravathinagar, Taluka Udumalpet, Tiruppur Dist Tamilnadu
Abstract
In relational database management systems (RDBMS), attributes are typically required to contain atomic values according to the First Normal Form (1NF). However, many real-world applications involve attributes that naturally contain multi values. These multi-valued attributes are usually decomposed into separate relations during normalization. While this preserves relational integrity, it does not inherently maintain a deterministic ordering of the values of attribute value. The Structured Query Language (SQL) provides mechanisms such as ORDER BY for sorting tuples, but it lacks a dedicated method for dynamically ordering multi-valued attributes belonging to a single tuple based on a specific pattern. This research proposes an advanced relational model using the Dynaseq Tuple Ordering Algorithm (DTOA) to address this limitation. The algorithm dynamically assigns sequence indices to values of multi-valued attributes and ensures that these values are retrieved in a specified order within SQL queries. The study analyses the efficiency of DTOA in terms of query execution and algorithmic complexity. The results demonstrate that the proposed model improves the structured ordering of multi-valued attributes while maintaining compatibility with relational database architecture.
Keywords: RDBMS, SQL, Multi-Valued Attributes, DTOA Algorithm, Tuple Ordering, Query Optimization, Runtime Complexity.
Journal Name :
EPRA International Journal of Multidisciplinary Research (IJMR)

VIEW PDF
Published on : 2026-03-19

Vol : 12
Issue : 3
Month : March
Year : 2026
Copyright © 2026 EPRA JOURNALS. All rights reserved
Developed by Peace Soft