Database Systems Journal

ISSN 2069 - 3230

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

Database Systems Journal, Vol. II, Issue 2/2011
Issue Topic: Administration

Open PDF Journal


1. Managing XML Data to optimize Performance into Object-Relational Databases (p. 3-12)
Iuliana BOTHA, University of Economic Studies, Bucharest, Romania
This paper propose some possibilities for manage XML data in order to optimize performance into object-relational databases. It is detailed the possibility of storing XML data into such databases, using for exemplification an Oracle database and there are tested some optimizing techniques of the queries over XMLType tables, like indexing and partitioning tables.
Keywords: Object-relational database, XML data, optimizing technique, index, partitioned table.
2. Increasing Database Performance using Indexes (p. 13-22)
Cecilia CIOLOCA, University of Economic Studies, Bucharest, Romania
Mihai GEORGESCU, University of Economic Studies, Bucharest, Romania
The performance issues are presented. The process of performance tuning is described. The indexing concept is introduced. The two types of defining an index are identified. The paper presents and explains the way a clustered and nonclustered index works. A compared analysis between clustered and nonclustered indexes is created. The benefits of using indexes on databases are identified and explained. A demonstration of using SEEK and SCAN indexes is presented, showing the logic behind these two types of indexes. Cases when an index must be used and how this index is created, are presented along with the performance improvement that is obtained after successfully creating the index.
Keywords: Clustered index, Nonclustered index, Optimization, Database, Performance.
3. A Grid Architecture for Manufacturing Database System (p. 23-34)
Laurentiu CIOVICA, University of Economic Studies, Bucharest, Romania
Constantin Daniel AVRAM, University of Economic Studies, Bucharest, Romania
Before the Enterprise Resource Planning concepts business functions within enterprises were supported by small and isolated applications, most of them developed internally. Yet today ERP platforms are not by themselves the answer to all organizations needs especially in times of differentiated and diversified demands among end customers. ERP platforms were integrated with specialized systems for the management of clients, Customer Relationship Management and vendors, Supplier Relationship Management. They were integrated with Manufacturing Execution Systems for better planning and control of production lines. In order to offer real time, efficient answers to the management level, ERP systems were integrated with Business Intelligence systems. This paper analyses the advantages of grid computing at this level of integration, communication and interoperability between complex specialized informatics systems with a focus on the system architecture and data base systems.
Keywords: Enterprise resource planning, architecture, grid computing, data base systems.
4. Grid Database - Management, OGSA and Integration (p. 35-44)
Florentina Ramona PAVEL (EL BAABOUA), University of Economic Studies, Bucharest, Romania
The problem description of data models and types of databases has generated and gives rise to extensive controversy generated by their complexity, the many factors involved in the actual process of implementation. Grids encourage and promote the publication, sharing and integration of scientific data, distributed across Virtual Organizations. Scientists and researchers work on huge, complex and growing datasets. The complexity of data management within a grid environment comes from the distribution, heterogeneity and number of data sources. Early Grid applications focused principally on the storage, replication and movement of file-based data.. Many Grid applications already use databases for managing metadata, but increasingly many are associated with large databases of domain-specific information. In this paper we will talk about the fundamental concepts related to grid-database access, management, OGSA and integration.
Keywords: Grid, data grid, grid computing, database, management, integration.
5. Considerations Regarding Designing and Administrating SOA Solutions (p. 45-54)
Vlad DIACONITA, University of Economic Studies, Bucharest, Romania
Solutions like SOA, Cloud, SaaS, Iaas or PaaS are not only buzzwords, they became a business reality because they are relative cheap and easy to use. SOA and Cloud are tightly linked because most cloud solutions are being defined using SOA making them feasible from the business perspective, because it’s hard to move to cloud when you are using a tightly coupled architecture. Big companies such as Oracle, Microsoft, IBM or Amazon offer many commercial solutions providing software as a service, as well as hosted and managed alternatives to classical deployment. For firms that are building private clouds and for service providers that are building public clouds, diverse solutions are offered by the big players for platform as a service and infrastructure as a service.
Keywords: SOA, web services, modeling, cloud.
6. Natural versus Surrogate Keys. Performance and Usability (p. 55-63)
Dragos-Paul POP, University of Economic Studies, Bucharest, Romania
Choosing the primary key for a table proves to be one of the most important steps in database design. But what happens when we have to pick between a natural or a surrogate key? Is there any performance issue that we must have in mind? Does the literature have a preferred pick? Is usability a concern? We’ll have a look at the advantages and disadvantages of both natural and surrogate keys and the performance and usability issues they address.
Keywords: Primary keys, natural keys, surrogate keys, superkey, candidate key, unique key, performance, usability.