Middlewares are enabling technologies for the development, deployment, execution and interaction of applications. These software layers are standing between the operating systems and applications. They have evolved from simple beginnings hiding network details from applications into sophisticated systems that handle much important functionality for distributed applications providing support for distribution, heterogeneity and mobility. This paper concerns with the development of a Message_Oreinted Middleware (MOM) for a distributed database system. Middleware is a distributed software layer, or 'platform' which abstracts over the complexity and heterogeneity of the underlying distributed environment with its multitude of network technologies, machine architectures, operating systems and programming languages. The role of this middleware is to ease the task of designing, programming and managing distributed database applications by providing a simple, consistent and integrated distributed programming environment. It provides integrity and security to these databases.
Normalization is an important technique for the analysis of relational databases. It aims to create a set of relational tables with minimum data redundancy that preserve consistency and facilitate correct insertion, deletion, and modification. It is very much time consuming to do this data analysis manually. Thus in this paper, a system is proposed which aims to automate the most complex phase of the database design normalization. It will help to achieve a good database design and eliminate the drawbacks of manual normalization process. This system is suitable to eliminate redundancy and inconsistent dependency automatically. It aims to handle the normalization process up to fifth normal. This includes creating tables and establishing relationships between those tables by using their general definitions in a step-by-step feature on the set of functional dependencies to remove redundant data. Then this system is tested on many examples with multiple candidate keys taken from different sources.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
hi@scite.ai
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.