Intelligent Implementation Processor Design for Oracle Distributed Databases System
Fadoua Hassen, Amel Grissa Touzi

TL;DR
This paper proposes an intelligent layer architecture for Oracle DDBMS that simplifies distributed database implementation by enabling graphical fragmentation, allocation, replication, and automatic SQL script generation.
Contribution
It introduces a novel architecture extending Oracle DBMS with an intelligent layer for easier distributed database design and management.
Findings
Enhanced ease of implementing distributed databases
Automated SQL script generation for distributed configurations
Supports various fragmentation types through GUI
Abstract
Despite the increasing need for modeling and implementing Distributed Databases (DDB), distributed database management systems are still quite far from helping the designer to directly implement its BDD. Indeed, the fundamental principle of implementation of a DDB is to make the database appear as a centralized database, providing series of transparencies, something that is not provided directly by the current DDBMS. We focus in this work on Oracle DBMS which, despite its market dominance, offers only a few logical mechanisms to implement distribution. To remedy this problem, we propose a new architecture of DDBMS Oracle. The idea is based on extending it by an intelligent layer that provides: 1) creation of different types of fragmentation through a GUI for defining different sites geographically dispersed 2) allocation and replication of DB. The system must automatically generate SQL…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsAdvanced Database Systems and Queries · Distributed and Parallel Computing Systems · Data Management and Algorithms
