Testiranje primernosti uporabe NoSQL v okviru računovodske aplikacije

DERLINK, MILAN (author), Zrnec, Aljaž (mentor)

Relacijske baze obstajajo že od začetka sedemdesetih let prejšnjega stoletja. V tem času so se aplikacije, ki uporabljajo podatke shranjene v bazah, zelo spremenile. Z razmahom interneta, se je povečalo število sočasnih dostopov do podatkovnih baz in obseg podatkov, ki jih je potrebno hraniti in imeti na voljo, je zelo narasel. V diplomskem delu bomo predstavili relacijske baze, prednosti in slabosti. Predstavili bomo tudi baze NoSQL (Not Only SQL), ki so se pojavile kot odgovor na slabosti relacijskih baz in se pojavljajo v sodobnih internetnih aplikacijah. Pokazali bomo, da baze NoSQL niso primerne za vse sodobne internetne aplikacije. Ena izmed njih je internetna aplikacija za računovodski program. Za testiranje primernosti NoSQL baze za uporabo v okviru računovodske aplikaciji bomo ustvarili enostavno aplikacijo, ki bo uporabljala podatke iz relacijske in NoSQL podatkovne baze. Merili bomo hitrost dostopa do podatkov z različnimi poizvedbami.

• Language: Slovenian
• Keywords: SQL, NoSQL, MySQL, relacijska baza, dokumentna baza, računovodstvo, html, php, MongoDB, BSON, JSON
• Work type: Bachelor thesis/paper
• Organization: FRI - Faculty of Computer and Information Science
• Year: 2014
• PID: 20.500.12556/RUL-29544
• Publication date in RUL: 23.09.2014

Secondary language

• Language: English
• Title: Testing the appropriateness of using NoSQL in the context of financial application

Abstract

Relational databases have existed since the beginning of the seventies of the last century. In the meantime, applications that use data stored in databases, have changed. With the expansion of the Internet has increased the number of concurrent accesses to databases and the volume of data that need to be kept and be made available, it is highly increased. In the thesis we present a relational database, strengths and weaknesses. We will present the database NoSQL (Not Only SQL), which emerged as a response to the weaknesses of relational databases. We will show that NoSQL databases are not suitable for all modern Internet applications. One of them is an Internet application for the accounting program. To test the suitability of NoSQL databases for use within the accounting application, we will create a simple application that will use data from relational and NoSQL databases. We shall measure the speed of access to data with different queries.

• Keywords: SQL, NoSQL, MySQL, relational database, document database, accounting, html, php, MongoDB, BSON, JSON