Asian Journal of Information Technology
ISSN: Online 1993-5994ISSN: Print 1682-3915
Abstract
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.
How to cite this article:
M. Muthukumar, P. Senthil Pandian and K. Karthikeyan. Analyzing and Improving the Performance of Decision Database with
Enhanced Momentous Data Types.
DOI: https://doi.org/10.36478/ajit.2017.699.705
URL: https://www.makhillpublications.co/view-article/1682-3915/ajit.2017.699.705