Database Systems Journal

ISSN 2069 - 3230

Published with the support of:
The Bucharest University of Economic Studies


Database Systems Journal, Vol. IV, Issue 1/2013
Issue Topic: Database Administration and Security


Open PDF Journal


CONTENTS


1. ARH_Db_Tuner: The GUI Tool to Monitor and Diagnose the SGA Parameters Automatically (p. 3-10)
Hitesh KUMAR SHARMA, University of Petroleum and Energy Studies, India
Aditya SHASTRI, Banasthali University, Rajasthan, India
Ranjit BISWAS, Department of Computer Science, Hamdard University, India
Database administrators should be aware of resource usages to maintain database system performance. As database applications become more complex and diverse, managing database systems becomes too costly and prone to error. Autonomic database tuning becomes more important than ever. One of the major issues to address in regards to ORACLE database performance is the size of the database. The bulk of the information consists of a large number of records, contained in many tables, each ranging from thousands of rows. There are many factors that can have direct effects on the performance of the database. CPU, Memory, Network, Disk I/O are among other factors. In order to make a database up and run efficiently, each factor must be addresses carefully, and the best tuning strategy must be applied for optimum performance. ORACLE performance issues are complex, and for a DBA, there is a large number of values to monitor and examine in order to decide on best tuning strategy. The aim of the work behind this paper was to design and implement a Database Performance Tuning Measurement Toolkit for ORACLE Database Servers working on MS-Windows platforms. This system is called ARH_Db_Tuner*. This system is the advance version of ORACLE Performance Monitoring Toolkit [19] (OPMT for short). Some of the future aspects of OPMT have been implemented in ARH_Db_Tuner. It is used for testing, analysis and reporting of the database performance.
Keywords: SGA, SGA Dynamic Parameters, Database Tuning, DBA, Automated Tuning.
2. Reverse Engineering in Data Integration Software (p. 11-18)
Vlad DIACONITA, University of Economic Studies, Bucharest, Romania
Integrated applications are complex solutions that help build better consolidated and standardized systems from existing (usually transactional) systems. Integrated applications are complex solutions, whose complexity are determined by the economic processes they implement, the amount of data employed (millions of records grouped in hundreds of tables, databases, hundreds of GB) and the number of users [11]. Oracle, once mainly known for his database and e-business solutions has been constantly expanding its product portfolio, providing solutions for SOA, BPA, Warehousing, Big Data and Cloud Computing. In this article I will review the facilities and the power of using a dedicated integration tool in an environment with multiple data sources and a target data mart.
Keywords: ODI, reverse engineering, SOA, data mart.
3. Introducing Virtual Law offices in the Existing Judiciary (p. 19-27)
Rizul KHANNA, National Institute of Technology (NIT), Jalandhar, Punjab, India
Rahul BHAGAT, National Institute of Technology (NIT), Jalandhar, Punjab, India
With the rise of omnipresent foundation of computing resources over the past years, every IT Setup is expanding their horizons in the Cloud services and related technologies. Cloud provides dynamically scalable virtualized computing resources as a service over the Internet and this key characteristic differentiates it from traditional computing paradigm. It is the application of Cloud and mobile computing technologies for improving communication between lawyers, their clients, and any other person involved. This framework basically digitalizes the existing judicial file system to form an e-library using Clouds infrastructure and using the internet services like GPRS or GSM / CDMA or 3G/4G etc for information retrieval from this e-library after the request has received proper authorization and authentication of the regulatory body. Data is received from both Web and mobile based applications so that each person can access the judicial data anytime and anywhere. For the realization of this system, a web interface is created with e-library serving as the main database and with user-friendly interface to do the above data acquisition and analysis which ultimately gives pace to the slow process of case management.
Keywords: Applications, Cloud Computing, Data Interaction, Internet, E-library Regulatory body, Security.
4. Database Security for an Integrated Solution to Automate Sales Processes in Banking (p. 28-37)
Alexandra Maria Ioana FLOREA, University of Economic Studies, Bucharest, Romania
In order to maintain a competitive edge in a very active banking market the implementation of a web-based solution to standardize, optimize and manage the flow of sales / pre-sales and generating new leads is requested by a company. This article presents the realization of a development framework for software interoperability in the banking financial institutions and an integrated solution for achieving sales process automation in banking. The paper focuses on presenting the requirements for security and confidentiality of stored data and also on presenting the identified techniques and procedures to implement these requirements.
Keywords: interoperability, security, sales process automation, databases.
5. Decision Support System in National Power Companies. A Practical Example (Part I) (p. 37-46)
Adela BARA, University of Economic Studies, Bucharest, Romania
Iuliana BOTHA, University of Economic Studies, Bucharest, Romania
Ion LUNGU, University of Economic Studies, Bucharest, Romania
Simona-Vasilica OPREA, Transelectrica Company, Bucharest, Romania
The paper presents the developing stages of the decision support prototype in which the data warehouse and the presentation level are built and validated. The paper also extends the results published in the 12th international conference on Informatics in Economy (IE 2013) proceedings and will presents the major steps for developing the data warehouse that integrates the sources from the Wind Power Plants (WPP) from the national parks and also the interface modules that allow managers to analyze data at a central level.
Keywords: Data Warehouse, Business Intelligence, Analytics, Decision Support System.