Review and comparison of relational and non-relational databases: A survey article

سال انتشار: 1400
محل انتشار: اولین همایش ملی رایانش نرم و هوش محاسباتی
کد COI اختصاصی: CSCCI01_050
زبان مقاله: انگلیسی
تعداد مشاهده: 309

نویسندگان

M.Sc. Student, Department of Computer, Faculty of Engineering, West Tehran Branch, Islamic Azad University,Tehran, Iran

Assistant Professor, Department of Computer Science, Faculty of Engineering, Tehran West Branch, Islamic Azad University, Tehran, Iran

چکیده

A database management system is a broad term that refers to all the tools used to manage data. Database management systems are based on database models. These models are types of structures defined for data management. Relational databases have been used to store and retrieve data since ۱۹۷۹, but with the advent of the Internet and the development of web applications, data have been generated that are structurally impossible to store and maintain in relational databases. Therefore, in ۲۰۰۰, non-relational databases were designed and presented. Choosing the proper database model is a decision that software developers must make based on the features of each of these models. So, in this article, the features of relational and non-relational databases have been studied, compared and by knowing these features, the most appropriate model for storing and maintaining data can be selected. In this article, a comparison of different database models are performed and the study population includes conference papers, related journal articles published during the last ۱۰ years. According to the studies and reviews conducted in this article, each of the database models has strengths and weaknesses that are based on these features and also the type and volume of data generated by applications, software developers can select the best model to store and retrieve data. Therefore, both models of the database will continue to operate and neither is better than the other and only based on their features and the generated data can be selected the appropriate model for storing information.

کلیدواژه ها

Non-relational database, SQL, Relational database, NoSQL

مقالات مرتبط جدید

اطلاعات بیشتر در مورد COI

COI مخفف عبارت CIVILICA Object Identifier به معنی شناسه سیویلیکا برای اسناد است. COI کدی است که مطابق محل انتشار، به مقالات کنفرانسها و ژورنالهای داخل کشور به هنگام نمایه سازی بر روی پایگاه استنادی سیویلیکا اختصاص می یابد.

کد COI به مفهوم کد ملی اسناد نمایه شده در سیویلیکا است و کدی یکتا و ثابت است و به همین دلیل همواره قابلیت استناد و پیگیری دارد.