RADIOELECTRONIC AND COMPUTER SYSTEMS

Nowadays, due to the rapid development of social networks and the blogger culture, there is a tendency to use affiliate systems to promote their product. The Affiliate Reporting Service is a service offered to customers who want to analyze the affiliate systems' performance data. These systems are used by business executives and business owners to analyze ecommerce data and convert it into profit/expense data to adjust their business path further. This type of service includes data storage for all affiliates, data archive management, conversion of advertising campaigns, trend tracking, and more. These systems are based on large data sets that need to be stored correctly and safely stored and processed using database management systems. There are two major direction: SQL and NoSQL, relational and non-relational databases. The differences between them are how they are designed, what types of data they support, how they store information, how they support information security. A rigid relational database schema helps maintain the security and integrity of data when stored and modified. The lack of a rigid database schema and the need to change the entire structure of the table with a minimal change in the storage concept, make it easier to work with non-relational databases and subsequently support them, but it also has its disadvantages. It is important to understand that the tasks are different and the methods for solving them are also different; Choosing a database and database management system is a complex multi-parameter task and is one of the most important steps in developing such applications. Properly selected database will reduce the monetary and time costs associated with the development of the software, as well as facilitate system support in the future. The purpose of the article is to compare relational and non-relational databases by different metrics used in Affiliate Reporting Systems Design. In particular, a performance analysis was conducted on the performance of various operations, on the basis of which conclusions were drawn about the use of a particular database.

database; database management system; SQL; NoSQL; MongoDB; PostgreSQL; affiliate marketing; reporting system

Bruce, C. Brown. The Complete Guide to Affiliate Marketing on the Web: How to Use and Profit from Affiliate Marketing Program. Atlantic Publishing Company, 2008. 384 p.

Prussakov, Evgenii. Affiliate Program Management: An Hour a Day. Sybex, 2011. 460 p.

Ulaner, Kevin. Affiliate Marketing: The Beginner's Step by Step Guide to Making Money Online with Affiliate Marketing. CreateSpace, 2017. 62 p.

Singh, Surabhi. Driving Traffic and Customer Activity Through Affiliate Marketing. IGI Global, 2017. 233 p.

McCreary, Dan., Kelly, Ann. Making Sense of NoSQL: A guide for managers and the rest of us. Manning Publications, 2013. 312 p.

Tiwari, Shashank. Professional NoSQL. Packt Publishing, 2011. 384 p.

Fowler, Adam. NoSQL For Dummies. Dummies Tech, 2015, 456 p.

Hernandez, Michael J. Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design. Addison-Wesley Professional, 2003, 611 p.

PostgreSQL Documentation, Quick Links. Available at: https://www.postgresql.org/docs/ (аccessed 22.10.2019)

Hannah, Crossing, Simon, Riggs. Crossing. PostgreSQL Administration 9. Recipe Book, Litres, 2019. 351 p.

Sweet, Justin., Schneier, Marc M. Legal Aspects of Architecture, Engineering & the Construction Process, Cengage Learning, 2008, 769 p.

Mancas, C. Conceptual Data Modeling and Database Design: A Fully Algorithmic Approach, Volume 1: The Shortest Advisable Path. CRC Press, 2016. 698 p.

Aggregation Pipeline Stages. $unwind (aggregation). Available at: https://docs.mongodb.com/ manual/reference/operator/aggregation/unwind (аccessed 22.10.2019).

Taulli, Tom. How to Create the Next Facebook: Seeing Your Startup Through, from Idea to IPO. Apress, 2012. 208 p.