Main Article Content
Abstract
The database is one of the benchmarks that affect the quality of information systems. An effective information system certainly has a quality database. Aspects that can be measured to determine the quality of the database are aspects of truth, consistency, range, level of detail, completeness, minimalism, ability to integrate and readability. One of the mistakes that are often encountered in databases is related to the consistency aspect. Consistency aspects that are not paid much attention to its application can lead to data conflicts due to ambiguity and data duplication. This study aims to improve the quality of the database by applying consistency to the naming of fields and tables. A naming method to produce consistency in standardization was applied in this study.
Keywords
Article Details
References
-
Batini, C., Lenzerini, M. & Navathe, SB, 1986. A comparative analysis of methodologies for database schema integration. ACM computing surveys (CSUR), 18 (4), pp.323-364.
Herden, O., 2001. Measuring quality of database schemas by reviewing-concept, criteria and tool. Oldenburg Research and Development Institute for Computer Science Tools and Systems, Escherweg, 2, p. 26121.
Le, VM, Soares, GA and Gulwani, S., Microsoft Technology Licensing LLC, 2019. SQL Query Formatting By Examples. US Patent Application 16 / 007,396.
Marelli, M. & Amenta, S., 2018. A database of orthography-semantics consistency (OSC) estimates for 15,017 English words. Behavior research methods, 50 (4), pp. 1482-1495.
Pham, N., van Heck, RG, van Dam, JC, Schaap, PJ, Saccenti, E. and Suarez-Diez, M., 2019. Consistency, inconsistency, and ambiguity of metabolite names in biochemical databases used for genome-scale metabolic modeling. Metabolites, 9 (2), p. 28.
Taipalus, T., 2020, August. The Effects of Database Complexity on SQL Query Formulation (journal-first). In 2020 46th Euromicro Conference on Software Engineering and Advanced Applications (SEAA) (pp. 185-185). IEEE.
References
Herden, O., 2001. Measuring quality of database schemas by reviewing-concept, criteria and tool. Oldenburg Research and Development Institute for Computer Science Tools and Systems, Escherweg, 2, p. 26121.
Le, VM, Soares, GA and Gulwani, S., Microsoft Technology Licensing LLC, 2019. SQL Query Formatting By Examples. US Patent Application 16 / 007,396.
Marelli, M. & Amenta, S., 2018. A database of orthography-semantics consistency (OSC) estimates for 15,017 English words. Behavior research methods, 50 (4), pp. 1482-1495.
Pham, N., van Heck, RG, van Dam, JC, Schaap, PJ, Saccenti, E. and Suarez-Diez, M., 2019. Consistency, inconsistency, and ambiguity of metabolite names in biochemical databases used for genome-scale metabolic modeling. Metabolites, 9 (2), p. 28.
Taipalus, T., 2020, August. The Effects of Database Complexity on SQL Query Formulation (journal-first). In 2020 46th Euromicro Conference on Software Engineering and Advanced Applications (SEAA) (pp. 185-185). IEEE.