Object-oriented Database Management System Research Articles

Requirement for object-oriented database management systems in forensic science

The complex requirements of a database system for recording regulated chemicals exceed the capabilities of a relational database system. Inheritance, which is part of object-oriented programming, must also be logically transferred to chemical objects. This issue is illustrated here by means of examples of the Chemical Weapons Convention (CWC) and the German version of the New Psychoactive Substances Law (NpSG).

SPATIAL DATABASES OF AGRONOMIC GEOINFORMATION SYSTEMS

The work is devoted to the development of spatial databases for the assessment of agricultural land. The geodatabase is aimed at geoinformation support of assessment, agroecological typing (groups, types of land) of agricultural lands, development of adaptive-landscape farming systems. The paper presents the structure of the database of regional and local levels. Three different ways of user interaction with the AgroGIS database are proposed. For practical implementation, it is proposed to use the object-functional approach to database development, based on the use of cloud data storage technology in the DBMS SQlite.
 Background. Geoinformation support of agronomic geoinformation systems (AgroGIS) is aimed at assessing natural-territorial conditions and environmental factors in agrolandscapes, development of adaptive landscape farming systems. AgroGIS geodatabases serve to store, analyze and present spatial information on agricultural land. As shown by an analysis of literary sources, the term “geodatabase” was formed more than twenty years ago. At the same time different geodatabases are known: archaeological, cartographic, soil and others. They differ in the object of research, structure and content, as well as the way of data organization. This indicates the relevance of the topics of the present research.
 Purpose. The purpose of the work is to develop the structure and content of the geodatabase agronomic GIS.
 Materials and methods. The object-functional approach to database development, which is supported by object-oriented database management systems (DBMS) and classical relational DBMS, is used. The essence of this approach is to implement functional tasks taking into account the needs of the user.
 Results. The main components of geodatabase in the form of separate sets of spatial classes (Climate, Relief, Soil, Vegetation, Hydrography, Agrolandscape) are proposed. At the same time the paper shows the need for practical implementation of agronomic geoinformation geodatabases from several aspects.
 Conclusion. In the development of spatial databases of agronomic GIS the most important feature is the ability to constantly update information in the form of temporal component. Practical implementation of temporal geodatabases is possible with the use of non-relational database management systems, as well as methods of processing big data (Big Data).

Специализированная САПР информационно-измерительных устройств командных приборов

Reviewed the problem of building a specialized CAD for information-measuring devices of command instruments. The list of automated design operations is defined. The tree of tasks to be solved during the development of the specialized CAD is considered. Approaches to the development of mathematical, informational, linguistic and software tools are proposed. The proposed problem-oriented language for describing the structure of the designed device is considered. An extensible architecture of specialized CAD based on objectoriented database management system is proposed.

The Object-Oriented Database Management System versus the Relational Database Management System: A Comparison

Both object-oriented and relational database management systems are referred to as DBMS. The web-scale is expanding at an incredible rate, and with it comes an increase in mobile applications, technologies, and social media platforms. The rapid growth of these technologies produces a variety of structured and unstructured data in various forms, each of which has various consequences for data security. Using RDBMS and OODBMS, this study's methodology outlines the development, installation, and management process of multiple and complicated data sets. This study gives a documented study comparing different kinds of data stored in databases by employing two types of database techniques: relational database method and object-oriented database technique. We use a different fingerprint database for the web and mobile devices. This database is also managed using different technologies, such as MySQL, and it accommodates data generated using distinct methods. In addition, this study explores the benefits and advantages of the various databases and determines the ideal database management system for organizations. According to the survey's findings, RDBMS stores data and the relationships between them in tables, but OODBMS stores data in objects, in a manner analogous to Object-Oriented Programming (OOP). According to the study's findings, the primary distinction between relational database management systems (RDBMS) and object-oriented database management systems (OODBMS) is that RDBMS is a Database Management System based on the relational model. In contrast, OODBMS is a Database Management System that facilitates creating and modeling data as objects.

Survey on Security Mechanisms In NoSQL Databases

Database is widely used in most of the applications to store, retrieve and manage large amount of data. Relational database work best when to handle a limited set of data. In web scale systems, relational databases degrade the performance due to the joins, locks and impedance mismatch. Thus, as a result various non-relational databases emerged known as NoSQL databases. With the development of the Internet market and new web technologies, NoSQL databases become a very popular for handling large amount of data. Object Oriented Database Management Systems come under the category of NoSQL databases as they are not queried using SQL. They store information as objects, offer advanced features such as a large number of data types and could also offer advanced features such as inheritance and polymorphism which are characteristics of object-oriented programming languages as well. With this emergence of new databases and their adoption by a large number of organizations, security becomes an important issue. In this paper, we have surveyed several NoSQL databases such as MongoDB, Cassandra GemStone, db4o and Objectivity/DB and presented security features available in these NoSQL databases and compare them.

Modeling of Online Clinical System using Object-Oriented Data through UML

In the last decade, the aggressive domain in clinical sector, paradigm is changing rapidly. Assorted new things can be seen in the clinical sector, because it is embracing new concept terminology and technology to enhance their business & to win the satisfaction of their patient. This paper discusses the role of Unified Modeling Language (UML) in the Object Oriented Database Management System (OODBMS) in clinical system. An attempt has been made to represent that the progress capabilities of object-oriented data facilitates a sharp and direct realization of the Event Model Database design was guided by two notion: (1) that there is an underlying shape to all clinical data and (2) that objects dwell within the database should serve interfaces to diversity of services. These services include decision corroborate information delivery and data exchange. The clinical domain explored was laboratory medicine. Conventional decisionsupport queries were run against the laboratory data information stored in the object-oriented database. Object oriented Data Modeling technique has been used to store the data repositories.

Využití návrhového vzoru adaptér pro odstínění rozdílů v API objektových databází

Actual ERP systems use for data storage mainly relational databases, but in specific situations, particularly for modeling complex relationships can also use the object databases. These information systems are usually developed using object-oriented programming languages like C++, Java, C #, and it would seem natural that for the data storage they also use the object-oriented databases instead of the relational databases, thus dispensing with the need for mapping objects into relations. But this is not true especially because of two reasons. The first reason is historical and the resulting enormous widespread of the relational databases, which were here before the object-oriented databases. The second reason for minority use of the object-oriented databases is the minimum compliance of standards by the object DBMS (Database Management System) producers, such as SQL standard in relational databases, resulting in differences in the API (Application Programming Interface) of object-oriented DBMS and the impossibility to change the object-oriented DBMS in an application without having to rewrite the code of an entire application which is built on that object-oriented database. The following paper attempts to resolve this issue.

Cloud Algebra for Handling Unstructured Data in Cloud Database Management System

The handling of unstructured data in database management s ystem is very difficult. The managing unstructured data like image, video textual data etc. are not easy task in database system. In this work a concept of cloud algebra introduced to handle unstructured data in CDBMS. The most popular concept, relational algebra is used in relational database management system. The relational algebra is helpful in query processing in SQL. Another concept, Object Algebra which is used in object oriented database management system for query processing. The object algebra isuseful to manage the object in object oriented database management system. Now the concept of Cloud computing is introduced in new the era of computer technology. The concept of cloud is also introduced in the field of databases. The cloud database management system is newly introduced in the field of database technology to manage the cloud data. This work introduces the concept of cloud algebra for handling unstructured data the cloud database management system. This work proposed the concept of cloud alge bra for query processing for unstructured data in the cloud. The data are spread over the internet as cloud. The creation of new cloud of unstructured data and setting the relationship among various cloud of unstructured data are facilitated by cloud algebra. The updating, deleting and retrieval of unstructured data in cloud are done by cloud algebra. The cloud algebra provides powerful computation while using the query processing in CDBMS for handling unstructured data.

Formal approach for reengineering fuzzy XML in fuzzy object-oriented databases

Since semi-structured documents (e.g., XML) could benefit greatly from database support and more specifically from object-oriented (OO) database management systems, we study the methodology of reengineering XML to object-oriented databases when database migration occurs in this paper. In particular, considering the need of processing the imprecise and uncertain information existing in practical applications, we investigate the problem of migrating fuzzy XML to fuzzy object-oriented databases. To find the object-oriented schema that best describes the existing fuzzy XML schema (DTD), we devise a comprehensive approach centering on a set of mapping rules. Such reengineering practices could not only provide a significant consolidation of the interoperability between fuzzy OO and fuzzy XML modeling techniques, but also develop the practical design methodology for fuzzy OO databases.

An Investigation on Semantic Web-based Business Support: Ontology development and inference framework for the course recommendation

As a fundamental knowledge source in a global learning environment, it is feasible to apply the relational database management systems (RDBMS), object-oriented database management systems (OODBMS), and other traditional DBMS. However, the traditional DBMSs are not feasible in semantic knowledge/ontology representation and inference. One of the reasonable ways to overcome the limitations is the semantic web-based business support framework. Especially, in this study, we focused on the development of semantic web ontology and natural language (NL)-based inference framework. To validate the efficiency of the proposed framework, we considered a reasonable scenario for course recommendation in a university.

Generalisation log for managing and utilising a multi-representation spatial database in map production

This paper describes a data model for logging map generalisation process information to facilitate data authentication and update propagation in a multi-representation spatial database environment. Generalisation is modelled as a directed acyclic diagram of prioritised generalisation process instances, which is further divided into independent operations as the atomic functional unit for generalisation. Generalisation parameter values and the roles of features in operations are stored. The full generalisation history of each feature may be traced for data authentication and quality analysis, or for update propagation. This model also includes the design of a feature versioning mechanism. In addition, OSGenLog, a set of platform-independent APIs to create generalisation logs, has been implemented in Gothic object-oriented database management system.

The Use of Object-Oriented Technologies for Medical Data Storing and Retrieving

The article focuses on object oriented technologies and the usage of these technologies, how to create an information system (IS) for applications in medicine, specifically in ophthalmology. The rapid evolution of medical data standards, concepts and technologies has created a problem – how to develop a system that would be flexible enough to work with evolving data. After the analysis of object-oriented technologies: Java 2 Platform, Enterprise Edition (J2EE) and Microsoft .NET and open source object- oriented data base management systems (OODBMS) we have proposed and created a system based on .NET and OODBMS db4o. Results include the developed system with proposed architecture and used techniques, also the advantages of object-oriented data bases (OODB), the systems’ possible interopera- bility with the National Electronic Health Record system. Developed IS should help medical specialists to reach important information from any computer in any hospital.

An exploration of key information models and their relationships in global manufacturing decision support

Global manufacturing businesses are beginning to benefit from the information and knowledge support provided by modern IT tools such as Product Lifecycle Management (PLM), Enterprise Resource Planning (ERP), and Customer Relations Management (CRM). Many types of information and knowledge, from customer requirements through product information to global enterprise manufacturing capability are involved in global manufacturing decisions. Understanding the appropriate structures and relationships for this information and knowledge is a significant issue if effective wide-ranging support is to be provided. This paper focuses on global manufacturing decision support and explores three key types of information and knowledge relationship: (a) relationships between information and knowledge elements within a single information and knowledge model; (b) relationships between different information and knowledge models at one organizational level; (c) relationships between different information and knowledge models at different organizational levels. The corresponding information and knowledge structures have been presented with Unified Modelling Language (UML) to show the multiplicity of relationship required, and these are explored with an experimental system based on Rational Unified Process, Visual C++, and object-oriented DBMS ObjectStore. A case study has been pursued to explore the application of the information and knowledge models to a real industry environment.

PySBQL – Python-like query language constructed using stack base approach

PySBQL (Python-like Stack Based Query Language) is a full scale programming and querylanguage. Its syntax is based upon the Python’s syntax, which makes PySBQL highly readable andeasy to use. Contrary to the classical approach in query languages, semantics is defined using acommon structure for programming languages – the Environment Stack (ENVS). As a querylanguage it is similar to SBQL proposed by Subieta [1,2]. The PySBQL language is implementedin Monad – Object Oriented Database Management System.

Opportunistic prioritised clustering framework for improving OODBMS performance

In object oriented database management systems, clustering has proven to be one of the most effective performance enhancement techniques. Existing clustering algorithms are mainly static, that is re-clustering the object base when the database is off-line. However, this type of re-clustering cannot be used when 24-h database access is required. In such situations dynamic clustering is necessary, since it can re-cluster the object base while the database is in operation. We find that most existing dynamic clustering algorithms do not address the following important points: the use of opportunism to impose the smallest I/O footprint for re-organisation; the re-use of prior research on static clustering algorithms; and the prioritisation of re-clustering so that the worst clustered pages are re-clustered first. Our main achievement in this paper is to create the Opportunistic Prioritised Clustering Framework (OPCF). The framework allows any static clustering algorithm to be made dynamic. Most importantly it allows the created algorithm to have the properties of I/O opportunism and clustering prioritisation which are missing in most existing dynamic clustering algorithms. We have used OPCF to make the static clustering algorithms “Graph Partitioning” and “Probability Ranking Principle” into dynamic algorithms. In our simulation study we found these algorithms outperformed two existing highly competitive dynamic algorithms in a variety of situations.

Evolving an in‐house system to integrate the management of digital collections

PurposeTo describe the evolution of a content management system at the University of Maine Library that would function as a universal, extensible metadata repository, thereby eliminating the need to build separate databases for new digital collections, and facilitating both end‐user access and the management of electronic resources in an integrated technology environment.Design/methodology/approachBeginning with the development of a prototype system that mapped EAD encoded finding aids to a relational database, this paper discusses the evolution of this prototype into the design and implementation of a RDBMS (and continuing development of an object‐oriented database management systems (OODBMS) system) to actively manage digital objects and associated metadata. The key to the system design is metadata: extracting and mapping, transforming, and managing the processing of MARC‐based metadata into non‐MARC schemes to build digital collections. Other relevant CMS architecture issues discussed are the design of a functional bibliographic structure and utilities for metadata harvesting and indexing.FindingsProvides information on the use of the Dublin Core Abstract Model and a flexible and adaptable collection‐centric approach in the overall CMS architecture as implemented on a non‐MARC RDBMS, and provides an explanation of the advantages of an object oriented database system over the complexity of evolving relational database tables.Practical implicationsA useful source for the development of an in‐house CMS, and a contribution to the growing body of literature about the transformation of MARC‐based metadata for database design.Originality/valueThis paper is a case study of actual work conducted at the University of Maine Library. The RDBMS manages digital collections; the OODBMS manages digital video and other multimedia resources.

On using cache conscious clustering for improving OODBMS performance

The two main techniques of improving I/O performance of Object Oriented Database Management Systems (OODBMS) are clustering and buffer replacement. Clustering is the placement of objects accessed near to each other in time into the same page. Buffer replacement involves the selection of a page to be evicted, when the buffer is full. The page evicted ideally should be the page needed least in the future. These two techniques both influence the likelihood of a requested object being memory resident. We believe an effective way of reducing disk I/O is to take advantage of the synergy that exists between clustering and buffer replacement. Hence, we design a framework, whereby clustering algorithms incorporating buffer replacement cache behaviour can be conveniently employed for enhancing the I/O performance of OODBMS. We call this new type of clustering algorithm, Cache Conscious Clustering (C3). In this paper, we present the C3 framework, and a C3 algorithm that we have developed, namely C3-GP. We have tested C3-GP against three well known clustering algorithms. The results show that C3-GP out performs them by up to 40% when using popular buffer replacement algorithms such as LRU and CLOCK. C3-GP offers the same performance as the best existing clustering algorithm when the buffer size compared to the database size is very small.

STEP-NC compliant information modelling for wire electrical discharge machining component manufacture

Over the last five years, a great deal of research effort has been concentrated on the development of a new data model ISO 14649, informally known as STEP-NC. It has been strongly argued that STEP-NC has huge implications on the integration of the computer-aided design/computer-aided process planning/computer-aided manufacture (CAD/CAPP/CAM) (CAx) systems, giving the opportunity to realize interoperable computer numerical control (CNC) manufacturing. This is largely owing to the data model, which provides the capability to revolutionize the current state of the art in CNC manufacturing by offering a bi-directional interface with a high-level description of the geometrical and manufacturing information. This paper provides a view of how these STEP-NC compliant information models can be used to support the wire electrical discharge machining (WEDM) CAD to the CNC process chain. The models are based on part 13 of the ISO 14649 standard, which is dedicated to the WEDM process, together with part 10 of the standard, which specifies the general machining information. The information models have been identified and their structures have been defined and modelled using the unified modelling language (UML). A STEP-NC compliant WEDM CAx prototype system, based on the Java and the object-oriented database management system (DBMS) ObjectStore, has been constructed with an example case study to demonstrate the information models.

SnoopIB: Interval-based event specification and detection for active databases

Detection-based semantics does not differentiate between event detection and event occurrence and has been used for detecting events in most of the active systems that support Event–Condition–Action rules. However, this is a limitation for many applications that require interval-based semantics. In this article, we formalize the detection of Snoop (an event specification language) event operators using interval-based semantics (termed SnoopIB) in various event consumption modes. We show how events are detected using event detection graphs, and present a few representative algorithms to detect SnoopIB operators and comment on their implementation in the context of Sentinel—an active object-oriented DBMS.

Development of applications with fuzzy objects in modern programming platforms

Most of the applications that are currently being developed use object-oriented programming technology, as is the case of those applications built with the Java or C♯ languages. Data management has not kept out of this trend, and object-oriented and object-relational database management systems have arisen as a result. Soft-computing applications need to manage imperfect data and Fuzzy Sets Theory has proven to be a good choice for accomplishing the task of imperfect data management. In this article we present a framework that allows the programmers of soft-computing applications to deal with fuzzy objects in a transparent and intuitive way. This framework can be used to develop an object-oriented code in those systems that conform with current hip object-oriented languages, so that imperfect information can be managed. © 2005 Wiley Periodicals, Inc. Int J Int Syst 20: 1117–1136, 2005.