Sql ve Nosql Veritabanlarının Karşılaştırılması

Thumbnail Image

Files

490334 A comparison of SQL and NoSQL databases.pdf (1018.29 KB)

Date

2018

Authors

Journal Title

Journal ISSN

Volume Title

Publisher

Open Access Color

OpenAIRE Downloads

OpenAIRE Views

Research Projects

Organizational Units

Thumbnail Image
Organizational Unit
Software Engineering
(2005)
Department of Software Engineering was founded in 2005 as the first department in Ankara in Software Engineering. The recent developments in current technologies such as Artificial Intelligence, Machine Learning, Big Data, and Blockchains, have placed Software Engineering among the top professions of today, and the future. The academic and research activities in the department are pursued with qualified faculty at Undergraduate, Graduate and Doctorate Degree levels. Our University is one of the two universities offering a Doctorate-level program in this field. In addition to focusing on the basic phases of software (analysis, design, development, testing) and relevant methodologies in detail, our department offers education in various areas of expertise, such as Object-oriented Analysis and Design, Human-Computer Interaction, Software Quality Assurance, Software Requirement Engineering, Software Design and Architecture, Software Project Management, Software Testing and Model-Driven Software Development. The curriculum of our Department is catered to graduate individuals who are prepared to take part in any phase of software development of large-scale software in line with the requirements of the software sector. Department of Software Engineering is accredited by MÜDEK (Association for Evaluation and Accreditation of Engineering Programs) until September 30th, 2021, and has been granted the EUR-ACE label that is valid in Europe. This label provides our graduates with a vital head-start to be admitted to graduate-level programs, and into working environments in European Union countries. The Big Data and Cloud Computing Laboratory, as well as MobiLab where mobile applications are developed, SimLAB, the simulation laboratory for Medical Computing, and software education laboratories of the department are equipped with various software tools and hardware to enable our students to use state-of-the-art software technologies. Our graduates are employed in software and R&D companies (Technoparks), national/international institutions developing or utilizing software technologies (such as banks, healthcare institutions, the Information Technologies departments of private and public institutions, telecommunication companies, TÜİK, SPK, BDDK, EPDK, RK, or universities), and research institutions such TÜBİTAK.

Journal Issue

Events

Abstract

Bu çalışma SQL ve NoSQL veritabanlarının bir karşılaştırmasını ve avantajları ile dezavantajlarının belirlenmesine yönelik bir araştırmayı içerir. Karşılaştırmalar her iki veritabanı türünü ölçekleme, (ACID ve CAP) kuramı, esneklik, başarım, şema, sorgulama dili, maliyet, hız ve very açısından değerlendirmektedir. Çalışmada, MySQL, MS-SQL Server Express Edition, Oracle 11g Express Edition gibi SQL veritabanlarına örnekler verilmiştir. Ayrıca, çalışmada NoSQL veritabnalarına örnek olarak, Anahtar-Değer Depo veritabanları, Kolon-Yönelimli Veritabanları, Doküman Depol Veritabanları ve Dizge Veritabanları kısaca örneklerle anlatılmıştır. Çalışmanın sonuçları ve karşılaştırmalar SQL vertiabanlarının tablo tabanlı sistemler olduğunu, esnekliği, düşey ölçeklemeyi ve yapısal sorgulama dili SQL'i desteklediğini ortaya koymuştur. Diğer taraftan, bu çalışma, SQL sıra düzensel veri yapıları için uygun olmadığını, ve NoSQL veritabanlarının daha az esnek olmasına ragmen, yatay ölçeklenebilir, yapısal olmayan sorgulama dili özellikleri ile, sıra düzensel veritabanı yapıları için daha uygun olduğu ortaya çıkartmıştır.
This study comprises a research about both SQL and NoSQL databases and a comparison in terms of the advantages and disadvantages of each. The comparison is implemented depending on scalability, (ACID and CAP) theory, flexibility, performance, schema, query language, cost, speed and the stored data. We described briefly several examples of SQL databases including My SQL , MS-SQL Server Express Edition , Oracle 11g Express Edition Database. Also, the study included a description for many types of NoSQL database including Key-Value Store Database, Column-Oriented Database, Document Store Database and Graph Databases. The result of the study detected that SQL database is a table based database, supports flexibility, is vertical scalable, and utilizes Structured Language Query. On the other hand, the study discovered that SQL database is not a suitable choice for hierarchical data storage, etc. Whereas in terms of NoSQL, the study discovered that NoSQL databases are less flexible, however, horizontally scalable, have a non-structured querying language and is a good choice for hierarchical databases.

Description

Keywords

Bilgisayar Mühendisliği Bilimleri-Bilgisayar ve Kontrol, Computer Engineering and Computer Science and Control

Turkish CoHE Thesis Center URL

Fields of Science

Citation

WoS Q

Scopus Q

Source

Volume

Issue

Start Page

0

End Page

42

URI

https://hdl.handle.net/20.500.14411/5240

Collections

Master Tezler / Master Thesis