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. II, Issue 4/2011
Issue Topic: Developing Database Applications


Open PDF Journal


CONTENTS


1. Oracle Exalytics: Engineered for Speed-of-Thought Analytics (p. 3-8)
Gabriela GLIGOR, Oracle Romania
Silviu TEODORU, Oracle Romania
One of the biggest product announcements at 2011's Oracle OpenWorld user conference was Oracle Exalytics In-Memory Machine, the latest addition to the "Exa"-branded suite of Oracle-Sun engineered software-hardware systems. Analytics is all about gaining insights from the data for better decision making. However, the vision of delivering fast, interactive, insightful analytics has remained elusive for most organizations. Most enterprise IT organizations continue to struggle to deliver actionable analytics due to time-sensitive, sprawling requirements and ever tightening budgets. The issue is further exasperated by the fact that most enterprise analytics solutions require dealing with a number of hardware, software, storage and networking vendors and precious resources are wasted integrating the hardware and software components to deliver a complete analytical solution. Oracle Exalytics Business Intelligence Machine is the world’s first engineered system specifically designed to deliver high performance analysis, modeling and planning. Built using industry-standard hardware, market-leading business intelligence software and in-memory database technology, Oracle Exalytics is an optimized system that delivers answers to all your business questions with unmatched speed, intelligence, simplicity and manageability.
Keywords: Engineered system, Business Intelligence, analytics, OLAP, architecture.
2. PL/SQL and Bind Variable: the two ways to increase the efficiency of Network Databases (p. 9-16)
Hitesh KUMAR SHARMA, ITM University, India
Ranjit BISWAS, Manav Rachna International University, India
Faridabad Aditya SHASTRI, Banasthali University, India
Modern data analysis applications are driven by the Network databases. They are pushing traditional database and data warehousing technologies beyond their limits due to their massively increasing data volumes and demands for low latency. There are three major challenges in working with network databases: interoperability due to heterogeneous data repositories, proactively due to autonomy of data sources and high efficiency to meet the application demand. This paper provides the two ways to meet the third challenge of network databases. This goal can be achieved by network database administrator with the usage of PL/SQL blocks and bind variable. The paper will explain the effect of PL/SQL block and bind variable on Network database efficiency to meet the modern data analysis application demand.
Keywords: Network Database, Web Application, Bind Variable, PL/SQL, Middleware.
3. Problem Decomposition Method to Compute an Optimal Cover for a Set of Functional Dependencies (p. 17-30)
Vitalie COTELEA, Academy of Economic Studies, Chisinau, Republic of Moldova
The paper proposes a problem decomposition method for building optimal cover for a set of functional dependencies to decrease the solving time. At the beginning, the paper includes an overview of the covers of functional dependencies. There are considered definitions and properties of non redundant covers for sets of functional dependencies, reduced and canonical covers as well as equivalence classes of functional dependencies, minimum and optimal covers. Then, a theoretical tool for inference of functional dependencies is proposed, which possesses the uniqueness property. And finally, the set of attributes of the relational schema is divided into equivalence classes of attributes that will serve as the basis for building optimal cover for a set of functional dependencies.
Keywords: Logical Database Design, Functional Dependencies, Optimal Cover, Problem Decomposition.
4. Business Intelligence using Software Agents (p. 31-42)
Ana-Ramona BOLOGA, University of Economic Studies, Bucharest, Romania
Razvan BOLOGA, University of Economic Studies, Bucharest, Romania
This paper presents some ideas about business intelligence today and the importance of developing real time business solutions. The authors make an exploration of links between business intelligence and artificial intelligence and focuses specifically on the implementation of software agents-based systems in business intelligence. There are briefly presented some of the few solutions proposed so far that use software agents properties for the benefit of business intelligence. The authors then propose some basic ideas for developing real-time agent-based software system for business intelligence in supply chain management, using Case Base Reasoning Agents.
Keywords: Business intelligence, Agent-Based Systems, Supply Chain Management, Case-Base Reasoning.
5. Applications of Spatial Data Using Business Analytics Tools (p. 43-50)
Anca Ioana ANDREESCU, University of Economic Studies, Bucharest, Romania
Anda VELICANU, University of Economic Studies, Bucharest, Romania
Daniela MITROESCU, University of Economic Studies, Bucharest, Romania
This paper addresses the possibilities of using spatial data in business analytics tools, with emphasis on SAS software. Various kinds of map data sets containing spatial data are presented and discussed. Examples of map charts illustrating macroeconomic parameters demonstrate the application of spatial data for the creation of map charts in SAS Enterprise Guise. Extended features of map charts are being exemplified by producing charts via SAS programming procedures.
Keywords: Spatial data, business analytics, SAS system, map charts.
6. Solutions for the Object-Relational Databases Design (p. 51-64)
Manole VELICANU, University of Economic Studies, Bucharest, Romania
Iuliana BOTHA, University of Economic Studies, Bucharest, Romania
The need for databases occurs in the moment when takes place an informatics system development. Moreover, databases are an important step in this process. For this reason, this paper deals with object-relational databases implementation as part of informatics systems development. The practical implementation is made on a decision support system (DSS) prototype, which can be applied in the uncertain and unpredictable environments, like the production and the prediction of the wind energy.
Keywords: Object-Relational Databases, Informatics Systems Development, Unified Modeling Language (UML), Database Design, Database Implementation.