TY  - JOUR
T1  - Analyzing and Improving the Performance of Decision Database with
Enhanced Momentous Data Types
AU - Muthukumar, M. AU - Pandian, P. Senthil AU - Karthikeyan, K. 
JO  - Asian Journal of Information Technology
VL  - 16
IS  - 9
SP  - 699
EP  - 705
PY  - 2017
DA  - 2001/08/19
SN  - 1682-3915
DO  - ajit.2017.699.705
UR  - https://makhillpublications.co/view-article.php?doi=ajit.2017.699.705
KW  - Data decision types
KW  -database decision design
KW  -disk space utilization
KW  -bytes consumption
KW  -query execution time
KW  -CPU
AB  - In the current digital age, volume of data is getting increased by 59% on every year worldwide.
According to research, it is estimated that 70-85% of data is unstructured and more than 20% performance
degradation happens due to improper database design. There are many factors which may influence the
performance of the database among the factors a data type plays an important role. Choosing the right data type
for each column is most essential in either heavy transaction or less transaction tables. Proper database design
provides multiple benefits like minimized disk usage, less consumptions of CPU and resources and improved
query performance. The proper usage of data types in the database improves the performance of the whole
system. These data types are of different types and should be used in an intelligent way to achieve the expected
behavior. This study demonstrates how to choose the correct data types to design efficient database and also
identifies which data type should be used or not to be used.
ER  -