A comparative analysis of data redundancy and execution time between relational and object oriented schema table

The design of database is one of the important parts in building software, because database is the data storage inside the system. There are some techniques that allow the programmer to improve design of the database. One of the most popular techniques being used for database is the relational technique, which content entity relationship diagram and normalization. The relational technique is easy to use and useful for reducing data redundancy because the normalization technique solves the data redundancy by applying normalization normal forms on the schema tables. The second technique is the object oriented technique, which content class diagram and generate schema table. An advantage of object oriented technique is its closeness to programming languages like C++ or C#. This project is starting with applying relational technique and object oriented technique to define which technique uses less data redundancy during design database. Based on experimental results for total data redundancy in HMS case study was 336 for relational technique and 364 for object oriented technique as well as, course database case study was 186 for relational technique and 204 for object oriented technique. Also, this project is focus on query execution time between relational databases and object oriented database by using user friendly window. The experimental result for query execution time in HMS case study was 107.25 milliseconds for RDBMS and 80.5 milliseconds for OODBMS. In course database case study was 46.75 milliseconds for RDBMS and 31.75 milliseconds for OODBMS. However, the comparative analysis in this project is explaining the result of comparison between relational and object oriented techniques specifically with data redundancy and query execution time

Rigorous Design of Fault-Tolerant Transactions for Replicated Database Systems using Event B

System availability is improved by the replication of data objects in a distributed database system. However, during updates, the complexity of keeping replicas identical arises due to failures of sites and race conditions among conflicting transactions. Fault tolerance and reliability are key issues to be addressed in the design and architecture of these systems. Event B is a formal technique which provides a framework for developing mathematical models of distributed systems by rigorous description of the problem, gradually introducing solutions in refinement steps, and verification of solutions by discharge of proof obligations. In this paper, we present a formal development of a distributed system using Event B that ensures atomic commitment of distributed transactions consisting of communicating transaction components at participating sites. This formal approach carries the development of the system from an initial abstract specification of transactional updates on a one copy database to a detailed design containing replicated databases in refinement. Through refinement we verify that the design of the replicated database confirms to the one copy database abstraction

Developement Of Database and Stored Procedures for E-Commerce System

E-commerce has been an important entity in our daily life. Mobile commerce will make up to 45% of total revenue of e-commerce transaction by 2020. Database design is important in creating e-commerce application. Previous work on the database design for e-commerce application is improved. This thesis further improve previous work on database design for ecommerce application. The method of using stored procedure technique in creating an e-commerce application is also applied. We propose two design that is applied for e-commerce application, which is the database design and the stored procedure technique. The first proposes an improve design on e-commerce application database. We introduce a simple design that is applied and used in e-commerce application, further improving the previous design. The design focus on a simple approach to a database for e-commerce application. The second proposes on using the stored procedure technique in creating the database. Stored procedure used as a middleware for the application and the database. The stored procedure is categorised in two, which is the basic and advance stored procedure techniques. We explained on applying stored procedure technique on an e-commerce application. The proposed stored procedure and database can applied to the creation of an e-commerce applicationTable of Contents Abstract Chapter 1: Introduction .....................................................................................1 1.1 Background of research..............................................................................1 1.2 Research objectives.....................................................................................2 Chapter 2: Literature Review.............................................................................4 2.1 E-Commerce ................................................................................................4 2.2 Database and stored procedure.................................................................5 Chapter 3: Database Design and Stored Procedure..........................................9 3.1 Database design ..........................................................................................9 3.2 Basic stored procedures design................................................................17 3.3 Advance stored procedure design ...........................................................23 Chapter 4: Implementation and Experiment ..................................................25 4.1 Database implementation ........................................................................25 4.2 Stored procedure implementation ..........................................................28 4.3 Website implementation ..........................................................................30 Chapter 5: Conclusion and Further Works......................................................34 Appendix ..........................................................................................................36 Appendix a: Database SQL and Tables ...........................................................40 Appendix b: Stored procedures......................................................................50 References........................................................................................................50Maste

Comparative Analysis of Data Redundancy and Execution Time between Relational and Object-Oriented Schema Table

Database design is one of the important phases in designing software because database is where the data is stored inside the system. One of the most popular techniques used in database design is the relational technique, which focuses on entity relationship diagram and normalization. The relational technique is useful for eliminating data redundancy because normalization produces normal forms on the schema tables. The second technique is the object-oriented technique, which focuses on class diagram and generating schema tables. An advantage of object-oriented technique is its close implementation to programming languages like C++ or Java. This paper is set to compare the performance of both relational and object-oriented techniques in terms of solving data redundancy during the database design phase as well as measuring query execution time. The experimental results based on a course database case study traced 186 redundant records using the relational technique and 204 redundant records when using the object-oriented technique. The query execution time measured was 46.75ms and 31.75ms for relational and object-oriented techniques, respectively

A Review of Audio Features and Statistical Models Exploited for Voice Pattern Design

Audio fingerprinting, also named as audio hashing, has been well-known as a powerful technique to perform audio identification and synchronization. It basically involves two major steps: fingerprint (voice pattern) design and matching search. While the first step concerns the derivation of a robust and compact audio signature, the second step usually requires knowledge about database and quick-search algorithms. Though this technique offers a wide range of real-world applications, to the best of the authors' knowledge, a comprehensive survey of existing algorithms appeared more than eight years ago. Thus, in this paper, we present a more up-to-date review and, for emphasizing on the audio signal processing aspect, we focus our state-of-the-art survey on the fingerprint design step for which various audio features and their tractable statistical models are discussed.Comment: http://www.iaria.org/conferences2015/PATTERNS15.html ; Seventh International Conferences on Pervasive Patterns and Applications (PATTERNS 2015), Mar 2015, Nice, Franc