scholarly journals Estimating the performance efficiency of ERP system with the relational database in a heterogenic environment

2019 ◽  
Vol 68 (1) ◽  
pp. 33-49
Author(s):  
Janusz Dorożyński ◽  
Maciej Przepiórka
Keyword(s):  
Relational Database ◽  
Time Use ◽  
Relational Databases ◽  
Business Logic ◽  
Application Performance ◽  
Erp System ◽  
System Under Test ◽  
Three Layer Architecture ◽  
Windows Server ◽  
System Operating

The article presents a study of the performance of a commercial ERP system, operating in the 2W model with a relational database installed on the IBM mainframe platform, as well as business logic and presentation server installed on the Windows Server platform. The study was carried out in accordance with the developed methodology by means of recording the time of performing system functions indicated in the own document “Time-use profile of the ERP system under test”. Consulting sessions were also held. Based on the results of the research, a recommendation was made to migrate production relational databases to the Windows Server environment. Keywords: IT, relational database, ERP, MRPII, three-layer architecture, application performance.

SEDRIS Transmittal Storing and Retrieval System using Relational Databases

2014 ◽  
Vol 25 (4) ◽  
pp. 38-65
Author(s):  
Yongkwon Kim ◽  
Heejung Yang ◽  
Chin-Wan Chung
Keyword(s):  
Complex Systems ◽  
Relational Database ◽  
Relational Databases ◽  
Data Representation ◽  
Environmental Data ◽  
Natural Phenomena ◽  
Type Conversion ◽  
Weather System ◽  
Relational Database System ◽  
Efficient Management

Modeling and simulation (M&S) are widely used for design, analysis, and optimization of complex systems and natural phenomena in various areas such as the defense industry and the weather system. In many cases, the environment is a key part of complex systems and natural phenomena. It includes physical aspects of the real world which provide the context for a specific simulation. Recently, several simulation systems are integrated to work together when they have needs for exchanging information. Interoperability of heterogeneous simulations depends heavily on sharing complex environmental data in a consistent and complete manner. SEDRIS (Synthetic Environmental Data Representation and Interchange Specification) is an ISO standard for representation and interchange of environmental data and widely adopted in M&S area. As the size of the simulation increases, the size of the environmental data which should be exchanged between simulations increases. Therefore, an efficient management of the environmental data is very important. In this paper, the authors propose storing and retrieval methods of SEDRIS transmittals using a relational database system in order to be able to retrieve data efficiently in the environmental data server cooperating with many heterogeneous distributed simulations. By analyzing the structure and the content of SEDRIS transmittals, relational database schemas are designed. To reduce query processing time of SEDRIS transmittals, direct storing and retrieval methods which do not require the type conversion of SEDRIS transmittals are proposed. Experimental analyses are conducted to show the efficiency of the proposed approach. The results confirm that the proposed approach greatly reduces the storing time and retrieval time compared to comparison approaches.

Object-Relational Modeling

2009 ◽  
pp. 162-170
Author(s):  
Jaroslav Zendulka
Keyword(s):  
Relational Database ◽  
Relational Databases ◽  
Conceptual Modeling ◽  
Object Oriented ◽  
Database Systems ◽  
Object Relational ◽  
The Difference ◽  
Object Oriented Approach ◽  
Entity Relationship ◽  
Oriented Approach

Modeling techniques play an important role in the development of database applications. Well-known entity-relationship modeling and its extensions have become a widely-accepted approach for relational database conceptual design. An object-oriented approach has brought a new view of conceptual modeling. A class as a fundamental concept of the object-oriented approach encapsulates both data and behavior, whereas traditional relational databases are able to store only data. In the early 1990s, the difference between the relational and object-oriented (OO) technologies, which were, and are still used together to build complex software systems, was labeled the object-relational impedance mismatch (Ambler, 2003). The object-oriented approach and the need of new application areas to store complex data have greatly influenced database technology since that time. Besides appearance of object-oriented database systems, which fully implement objectoriented paradigm in a database environment (Catell et al., 2003), traditional relational database management systems become object-relational (Stonebraker & Brown, 1999). The most recent versions of the SQL standard, SQL: 1999 (Melton & Simon (2001) and SQL: 2003 (Eisenberg et al., 2004), introduced object-relational features to the standard and leading database producers have already released packages which incorporate them.

From Databases to Ontologies

2009 ◽  
pp. 2360-2383
Author(s):  
Guntis Barzdins ◽  
Janis Barzdins ◽  
Karlis Cerans
Keyword(s):  
Conceptual Model ◽  
Relational Database ◽  
Relational Databases ◽  
Database Design ◽  
Database Schema ◽  
Design Problems ◽  
Uml Profile ◽  
Domain Experts ◽  
Owl Ontology ◽  
Rdf Database

This chapter introduces the UML profile for OWL as an essential instrument for bridging the gap between the legacy relational databases and OWL ontologies. We address one of the long-standing relational database design problems where initial conceptual model (a semantically clear domain conceptualization ontology) gets “lost” during conversion into the normalized database schema. The problem is that such “loss” makes database inaccessible for direct query by domain experts familiar with the conceptual model only. This problem can be avoided by exporting the database into RDF according to the original conceptual model (OWL ontology) and formulating semantically clear queries in SPARQL over the RDF database. Through a detailed example we show how UML/OWL profile is facilitating this new and promising approach.

An Evaluation of Dynamic Electronic Catalog Models in Relational Database Systems

2011 ◽  
pp. 73-90 ◽  
Author(s):  
Kiryoong Kim ◽  
Dongkyu Kim ◽  
Jeuk Kim ◽  
Sang-uk Park ◽  
Ighoon Lee ◽  
...  
Keyword(s):  
Electronic Commerce ◽  
Relational Database ◽  
Relational Databases ◽  
Database Systems ◽  
Relational Schemas ◽  
Electronic Catalogs ◽  
Electronic Catalog ◽  
Software Product ◽  
New Models ◽  
Relational Database Systems

Electronic catalogs are electronic representations about products and services in the electronic commerce environment and require diverse and flexible schemas. Although relational database systems seem to be an obvious choice for their storage, traditional designs of relational schemas do not support electronic catalogs in the most effective ways. Therefore, new models for managing diverse and flexible schemas in relational databases are required for such systems. Proposed in this paper are several models for electronic catalogs using relational tables, and an experimental evaluation of their efficiency. The results of this study can be put to practical use and are, in fact, being applied in the design of a commercial software product.

scholarly journals Performance Analysis of NoSQL and Relational Databases with CouchDB and MySQL for Application’s Data Storage

2020 ◽  
Vol 10 (23) ◽  
pp. 8524
Author(s):  
Cornelia A. Győrödi ◽  
Diana V. Dumşe-Burescu ◽  
Doina R. Zmaranda ◽  
Robert Ş. Győrödi ◽  
Gianina A. Gabor ◽  
...  
Keyword(s):  
Big Data ◽  
Data Storage ◽  
Relational Databases ◽  
Database Systems ◽  
Application Performance ◽  
Big Data Applications ◽  
Database Technology ◽  
Important Challenge ◽  
Big Data Application ◽  
The Impact

In the current context of emerging several types of database systems (relational and non-relational), choosing the type and database system for storing large amounts of data in today’s big data applications has become an important challenge. In this paper, we aimed to provide a comparative evaluation of two popular open-source database management systems (DBMSs): MySQL as a relational DBMS and, more recently, as a non-relational DBMS, and CouchDB as a non-relational DBMS. This comparison was based on performance evaluation of CRUD (CREATE, READ, UPDATE, DELETE) operations for different amounts of data to show how these two databases could be modeled and used in an application and highlight the differences in the response time and complexity. The main objective of the paper was to make a comparative analysis of the impact that each specific DBMS has on application performance when carrying out CRUD requests. To perform the analysis and to ensure the consistency of tests, two similar applications were developed in Java, one using MySQL and the other one using CouchDB database; these applications were further used to evaluate the time responses for each database technology on the same CRUD operations on the database. Finally, a comprehensive discussion based on the results of the analysis was performed that centered on the results obtained and several conclusions were revealed. Advantages and drawbacks for each DBMS are outlined to support a decision for choosing a specific type of DBMS that could be used in a big data application.

A novel method for providing relational databases with rich semantics and natural language processing

2017 ◽  
Vol 30 (3) ◽  
pp. 503-525
Author(s):  
Kamal Hamaz ◽  
Fouzia Benchikha
Keyword(s):  
Natural Language ◽  
Data Storage ◽  
Language Processing ◽  
Relational Database ◽  
Relational Databases ◽  
Data Access ◽  
New Techniques ◽  
Content Type ◽  
Semantic Tree ◽  
Novel Method

Purpose With the development of systems and applications, the number of users interacting with databases has increased considerably. The relational database model is still considered as the most used model for data storage and manipulation. However, it does not offer any semantic support for the stored data which can facilitate data access for the users. Indeed, a large number of users are intimidated when retrieving data because they are non-technical or have little technical knowledge. To overcome this problem, researchers are continuously developing new techniques for Natural Language Interfaces to Databases (NLIDB). Nowadays, the usage of existing NLIDBs is not widespread due to their deficiencies in understanding natural language (NL) queries. In this sense, the purpose of this paper is to propose a novel method for an intelligent understanding of NL queries using semantically enriched database sources. Design/methodology/approach First a reverse engineering process is applied to extract relational database hidden semantics. In the second step, the extracted semantics are enriched further using a domain ontology. After this, all semantics are stored in the same relational database. The phase of processing NL queries uses the stored semantics to generate a semantic tree. Findings The evaluation part of the work shows the advantages of using a semantically enriched database source to understand NL queries. Additionally, enriching a relational database has given more flexibility to understand contextual and synonymous words that may be used in a NL query. Originality/value Existing NLIDBs are not yet a standard option for interfacing a relational database due to their lack for understanding NL queries. Indeed, the techniques used in the literature have their limits. This paper handles those limits by identifying the NL elements by their semantic nature in order to generate a semantic tree. This last is a key solution towards an intelligent understanding of NL queries to relational databases.

Migration from a Relational Database to NoSQL

2018 ◽  
Vol 8 (3) ◽  
pp. 63-80
Author(s):  
Samah Bouamama
Keyword(s):  
Relational Database ◽  
Database Management ◽  
Relational Databases ◽  
New Technologies ◽  
Management Tools ◽  
Nosql Databases

This article describes how due to the monstrous evolution of the technology and the enormous increase in data, it becomes difficult to work with traditional database management tools; relational databases quickly reach their limits and adding servers does not increase performance. As a result of this problem, new technologies have emerged, such as NoSQL databases, which radically change the architecture of the databases that the authors are used to seeing, thus increasing the performance and availability of services. As these technologies are relatively new, standard or formal migration processes do not yet exist, the authors thought it useful to propose a migration approach from a relational database to a database-oriented columns type HBase and Cassandra.

STANDARD INFORMATION FOR CONSTRUCTION EQUIPMENT IN A RELATIONAL DATABASE

2017 ◽  
Vol 4 (1) ◽  
Author(s):  
Marco L. Trani ◽  
Manuele Cassano ◽  
Davide Todaro
Keyword(s):  
Relational Database ◽  
Information Structure ◽  
Relational Databases ◽  
Technical Information ◽  
Construction Equipment ◽  
Information Need ◽  
Digital Format ◽  
Information Models ◽  
Building Information ◽  
Standard Information

In the last years, the digital evolution involved the construction sector and produced radical changes in projects elaboration and realization. The diffusion of digital models implies a particular attention on information related to the building elements. For what concerns construction planning and management, this information need to be related to the information of the elements proper of a construction site such as equipment and machines. A deep research focused on the manufacturers’ sheets showed how technical information related to construction equipment are often non-homogenous and incomplete, probably because of a lack of a precise standard. The aims of this research are then the definition of a proper standard information structure for construction equipment and its digitalization thanks to the use of relational Databases and Building Information Models. To do this the amount of information collected from a wide number of datasheets have been standardized and organized in homogenous informative sets to be related in order to gain the correct information package of an equipment. The realization of a relational database permitted to store such data in a digital format and to search them in an efficient way. The realization of a BIM library permitted to provide to designers and firms a tool able to improve and automatize design choices in terms of construction issues.

Audio Retrieval Based on Chinese Keyword Search in Relational Databases

2013 ◽  
Vol 756-759 ◽  
pp. 3236-3240
Author(s):  
Bo Yan Zhu ◽  
Guang Liu ◽  
Liang Zhu
Keyword(s):  
Relational Database ◽  
Relational Databases ◽  
Keyword Search ◽  
Database System ◽  
Experimental Results ◽  
Chinese Characters ◽  
Relational Database System ◽  
Audio Retrieval ◽  
Ranking Strategy ◽  
Audio Files

In this paper, we propose a new method based on Chinese keyword search to select the WAV or MP3 files in audio post-production. First, we listen to each file and label it with Chinese characters, and then classify and store the files in a relational database system. Then, we use the techniques of Chinese keyword search to match query characters and the tuple characters quickly, and to compute similarities between the query and candidate tuples. For the characteristics of Chinese keyword search, we present a ranking strategy and an algorithm to refine the candidate tuples resulting from the first round matching, and finally get top-Nresults of audio files. The experimental results show that our method is efficient and effective.

UPDATE-ENABLED TRIPLIFICATION OF RELATIONAL DATA INTO VIRTUAL RDF STORES

2010 ◽  
Vol 04 (04) ◽  
pp. 423-451 ◽  
Author(s):  
SUNITHA RAMANUJAM ◽  
VAIBHAV KHADILKAR ◽  
LATIFUR KHAN ◽  
MURAT KANTARCIOGLU ◽  
BHAVANI THURAISINGHAM ◽  
...  
Keyword(s):  
Semantic Web ◽  
Relational Database ◽  
Relational Databases ◽  
Heterogeneous Data ◽  
Data Sources ◽  
Relational Data ◽  
Semantic Web Technologies ◽  
Heterogeneous Data Sources ◽  
Description Framework ◽  
Almost All

The current buzzword in the Internet community is the Semantic Web initiative proposed by the W3C to yield a Web that is more flexible and self-adapting. However, for the Semantic Web initiative to become a reality, heterogeneous data sources need to be integrated in order to enable access to them in a homogeneous manner. Since a vast majority of data currently resides in relational databases, integrating relational data sources with semantic web technologies is at the top of the list of activities required to realize the semantic web vision. Several efforts exist that publish relational data as Resource Description Framework (RDF) triples; however almost all current work in this arena is uni-directional, presenting data from an underlying relational database into a corresponding virtual RDF store in a read-only manner. An enhancement over previous relational-to-RDF bridging work in the form of bi-directionality support is presented in this paper. The bi-directional bridge proposed here allows RDF data updates specified as triples to be propagated back into the underlying relational database as tuples. Towards this end, we present various algorithms to translate the triples to be updated/inserted/deleted into equivalent relational attributes/tuples whenever possible. Particular emphasis is laid, in this paper, on the translation and update propagation process for triples containing blank nodes and reification nodes, and a platform enhanced with our algorithms, called D2RQ++, through which bi-directional translation can be achieved, is presented.

Sign in / Sign up

Export Citation Format

Share Document