Database Systems Journal

ISSN 2069 - 3230

The journal is published under the sponsorship of
The Bucharest University of Economic Studies
and it is produced by the university's own publishing division,
The Bucharest University of Economic Studies Publishing House


Database Systems Journal, Vol. V, Issue 2/2014
Issue Topic: Data Processing


Open PDF Journal


CONTENTS


1. Integrating BI Tools in an Enterprise Portal for a better Enterprise Management (p. 3-12)
Gianina MIHAI, "Dunarea de Jos" University, Galati, Romania
Access to information has always been a stringent necessity for any organization. This necessity has become more stringent in the actual economic context, as decisions must be taken in the shortest time. That is why, since the early sixties, Decision Support Systems emerged. They have evolved together with the client-server technology, during the eighties, towards today's Executive Support Systems. Nowadays, these systems tend to be replaced by Dashboards and Balanced Scorecards as individual BI tools or as integrated tools, which are part of more complex BI solutions, which fulfill the more and more sophisticated and growing information requirements from decision factors. In this paper, we shall present a partial integration solution of the BI tools in an enterprise portal created using Microsoft SharePoint Server technologies. Initially, the enterprise portal which we'll present in this paper was meant to be more a general solution for the informational integration of an organization and less than a portal with strong BI features. But, as we shall demonstrate by the means of this paper, the portal prototype, as it is now, can be rapidly expanded to an enterprise portal with full BI features.
Keywords: Business Intelligence, Enterprise portal, Dashboard, KPI, Integrated reporting.
2. SGA Dynamic Parameters: The Core Components of Automated Database Tuning (p. 13-21)
Hitesh KUMAR SHARMA, University of Petroleum and Energy Studies, India
Aditya SHASTRI, Banasthali University, India
Ranjit BISWAS, Hamdard University, India
Sanjeev KUMAR SINGH, Galgotia University Noida, India
The efficient use of primary memory is one of the major key for the good performance achieved from the any kind of server. The management of the various components stored in the main memory is the key challenge to get the desired throughput from an application running on the server. As we know the DBMS mostly works on client-server architecture. So the memory management for the DBMS's components stored in the main memory of the server is the critical task for a DBA. The DBA should have the knowledge of the components those are stored in main memory during runtime. This paper helps the DBA to get the detailed description of these core components of DBMS.
Keywords: SGA, DBMS, DBA, Dynamic Parameters.
3. Analysis on the Metrics used in Optimizing Electronic Business based on Learning Techniques (p. 22-32)
Irina-Steliana STAN, University of Economic Studies, Bucharest, Romania
Ion-Sorin STROE, University of Economic Studies, Bucharest, Romania
The present paper proposes a methodology of analyzing the metrics related to electronic business. The drafts of the optimizing models include KPIs that can highlight the business specific, if only they are integrated by using learning-based techniques. Having set the most important and high-impact elements of the business, the models should get in the end the link between them, by automating business flows. The human resource will be found in the situation of collaborating more and more with the optimizing models which will translate into high quality decisions followed by profitability increase.
Keywords: Electronic business, Learning systems, KPIs, Optimization, Performance, Models, Decision.
4. Query Optimization Techniques in Microsoft SQL Server (p. 33-48)
Costel Gabriel CORLATAN, University of Economic Studies, Bucharest, Romania
Marius Mihai LAZAR, University of Economic Studies, Bucharest, Romania
Valentina LUCA, University of Economic Studies, Bucharest, Romania
Octavian Teodor PETRICICA, University of Economic Studies, Bucharest, Romania
Microsoft SQL Server is a relational database management system, having MS-SQL and Transact-SQL as primary structured programming languages. They rely on relational algebra which is mainly used for data insertion, modifying, deletion and retrieval, as well as for data access controlling. The problem with getting the expected results is handled by the management system which has the purpose of finding the best execution plan, this process being called optimization. The most frequently used queries are those of data retrieval through SELECT command. We have to take into consideration that not only the select queries need optimization, but also other objects, such as: index, view or statistics.
Keywords: SQL Server, Query, Index, View, Statistics, Optimization.
5. The Transition from RDBMS to NoSQL. A Comparative Analysis of Three Popular Non-Relational Solutions: Cassandra, MongoDB and Couchbase (p. 49-59)
Cristina BAZAR, University of Economic Studies, Bucharest, Romania
Cosmin Sebastian IOSIF, University of Economic Studies, Bucharest, Romania
NoSQL databases were built in the need to deal with the increasing amount of complex data (Big Data), required in real-time web applications, and are mostly addressing some of these points: the focus on availability over consistency, horizontally scalable, distributed architecture, and open-source. The purpose of this paper is to present the reasons for a transition from RDBMS to NoSQL databases, to describe the main characteristics of non-relational databases and to compare and analyze three popular NoSQL solutions - Cassandra, MongoDB and CouchBase, outlining the results obtained during performance comparison tests. Each solution is optimized for different workloads and different use cases. Therefore, each has its own strong points and weaknesses.
Keywords: NoSQL, Relational vs NoSQL, comparison, Cassandra, MongoDB, Couchbase.
5. Business Intelligence. A Presentation of the Current Lead Solutions and a Comparative Analysis of the Main Providers (p. 60-69)
Bogdan-Andrei IONESCU, University of Economic Studies, Bucharest, Romania
Sorina PODARU, University of Economic Studies, Bucharest, Romania
The aim of this paper is to synthesize the concepts behind Business Intelligence, by studying the solutions available on the market provided by the main players. We will present the software solutions already provided by them emphasizing the main advantages and benefits of each of them, but also as a comparative analysis, designed to reveal the area in which each provider is more remarkable than the others.
Keywords: Business Intelligence, Analysis, Report, Prognosis, Management, OLAP, IBM, SAP, SAS, ORACLE.