Abstract
Decision support systems are increasingly used in the management of industrial enterprises, the state sector and the scientific community. With the increase of size of transactional and log data sources, as well as the increase in size and speed needs for data warehousing systems that support decision-making, the data becomes big and queries used in these systems are very complex and time-consuming. This leads to the need for large-scale processing in acceptable time intervals. In this paper, we assess whether both SQL and NoSQL scalability platforms are able to process efficiently big data warehouses. We evaluate the database engine MySQL cluster, which enables clustering and scalability of in-memory databases in a shared nothing platform, and we compare it to traditional database engine Microsoft SQL Server 2012 (non-parallel) and to Hive. In the experimental evaluation, we use one appropriate benchmark to evaluating decision support systems, the Star Schema Benchmark (SSB). The results obtained allow us to estimate the improvement obtained with the increase of resources allocated to the MySQL cluster or Hive, and to obtain a better understanding of scalability limitations and characteristics when these engines are used for decision support systems.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: International Journal of Business Process Integration and Management
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
