Scientific publications of the Ivan Franko National University of Lviv

Visnyk of the Lviv University. Series Applied Mathematics and Computer Science

Additional information
Year 2018
Volume 26
Authors Mykhailiuk K., Yuriyak V., Yaroshko Sergii
Name of the article Development of the database manager for DBMS MongoDB in Pharo environment
Abstract The database manager for NoSQL MongoDB has been developed using the MVC template, an object-oriented Smalltalk programming language in Pharo environment, the MongoTalk and Spec libraries. The application provides a number of features for working with MongoDB databases, such as: creating a database, collection or document, conveniently mapping and manipulating data using CRUD operations written as JavaScript requests.
At the age of fast development the information technology and increasing the amount of information exists a topical issue of choosing convenient and fast systems for saving and access to data. Now the so-called NoSQL databases are gaining popularity and rapid spread. The advantages of NoSQL databases are no secret, especially when cloud computing has gained wide adoption.
NoSQL databases were created in response to the limitations of traditional relational database technology. When compared against relational databases, NoSQL databases are more scalable and provide superior performance, and their data model addresses several shortcomings of the the relational model. One such system is MongoDB.
MongoDB is a document-oriented database management system (DBMS) with open source code that does not require a table schema description. It relates to fast and scalable systems that operate data in a key-value format. MongoDB supports the storage of documents in a JSON-like format, has a fairly flexible language for query creation, can create indexes for various stored attributes, and effectively store large binary objects in collections.
However, all operations with MongoDB databases are performed only on a console basis. Users lack access to the database in visual mode. Therefore, the purpose of our project was to create a program with a convenient window interface for managing the MongoDB databases.
The database manager for NoSQL MongoDB has been developed using the MVC template, an object-oriented Smalltalk programming language in Pharo environment, the MongoTalk, Mapless and Spec libraries. Mapless provides convenient tools for working with the MongoDB database, automates the creation of classes for the presentation of tables in the database. Spec is a special Smalltalk class library for creating a variety of visual controls. It is easy to develop a user interface window.
The main goal of this project is to implement a desktop application with allows user to operate with MongoDB using clear and responsive interface.
The developed application works in the Pharo environment and provides the following capabilities: 1) creating a database; 2) establishing connection with the database MongoDB; 3) performing basic operations with the database – CRUD (create, read, update, delete) written as JavaScript requests - its collections and records in each such collection using ; 4) Convenient browsing of the database list and its contents.
The great advantage of the work performed is the convenience of the developed application window and the speed of obtaining, storing and updating data, which simplifies data analysis and work with them.
Language Ukrainian
PDF format Mykhailiuk K., Yuriyak V., Yaroshko Sergii 
small logo
©2003-2012 Lviv University | Contacts