Distributed Database for Winnis Bakery
Translated by
ScribdTranslationsDistributed Database for Winnis Bakery
Translated by
ScribdTranslationsDISTRIBUTED DATABASE PROJECT
DEFINITION OF THE PROJECT.
Winnis Restaurant and Bakery requires a database system to manage the
information about its 4 different branches located in San Andrés Tuxtla which are
located in different parts of the city.
From each branch, it is required to know how many invoices they issue per day, the cuts for each shift of
the cashiers, the registered clients, the vouchers to the employees, expenses that each one has
branches and the availability of the products that they offer to their clients.
DATABASE DISTRIBUTION.
Given that the information managed by the company RESTAURANT AND PASTRY SHOP WINNIS in
Excessively extensive different positions will be granted to some of the branches to be these the
that maintain a specific control of each branch.
FRAGMENTATION
The type of fragmentation that would be implemented to solve the problem is using the
vertical and horizontal fragmentation since the queries that will be made meet the criteria of
fragmentation.
HOMOGENEOUS DATABASE.
We decided to use a homogeneous database that all sites have identical.
database management system (DBMS) software is aware of the existence of other sites and
they agree to cooperate with the processing of user requests
Homogeneous distributed databases are similar to centralized databases,
but instead of storing all the data in one place, the data is distributed across different sites of a
red.
DISTRIBUTED DATABASE MANAGEMENT SOFTWARE.
It is a multithreaded, multi-user relational database management system.
MySQL is widely used in web applications, such as Drupal or phpBB, on platforms (Linux/Windows-Apache-
MySQL-HP/Perl/Python), and by error tracking tools like Bugzilla.
ADVANTAGES.
Higher performance
Best data management utilities.
Perfect integration with PHP
No limits on record sizes
Better user access control
IMPLEMENTATION PLATFORM OF THE WINNIS SYSTEM DATABASE
Windows 7 was chosen for its reliability, ease of use, and stability compared to other operating systems.
Currently, Windows continues to be the most commercially used operating system, which is reflected in
the availability of applications, ease of maintenance as well as support in the development of new ones
applications, points that can be crucial in the choice of servers running web applications.
TYPE OF NETWORK IMPLEMENTED BDD.
LasRedes de área metropolitana(MAN) son redes informáticas que se extienden sobre un área
metropolitan. It contains a collection of machines dedicated to executing user programs (hosts).
These are connected by the network that carries messages from one host to another.
DATA STORAGE.
Replica:
The system keeps several identical copies or replicas of a table. Each replica is stored in a
different node.
Advantages:
Availability: the system continues to operate even in the event of a failure of one of the nodes.
Increased parallelism: Several nodes can perform queries in parallel on the same table.
The more replicas of the table there are, the higher the chance that the sought data will be found.
at the node from which the query is made, minimizing thus the data traffic between nodes.
Common questions
Powered by AIReplication enhances data availability by maintaining multiple identical copies of tables across different nodes, ensuring the system continues to function even if one node fails . This redundancy increases the likelihood that queries can be processed at the node where the data resides, thus minimizing data traffic between nodes and enhancing query performance by allowing parallel processing on multiple nodes .
A homogeneous distributed database benefits Winnis Restaurant and Bakery by providing uniformity in the database management system (DBMS) across all branches, facilitating seamless cooperation in processing user requests . This allows for better data management utilities, higher performance, and perfect integration with PHP, which is advantageous for their web applications . Moreover, the use of identical DBMS software across branches ensures no issues with data inconsistency and easier system maintenance .
Vertical and horizontal fragmentation helps Winnis Restaurant and Bakery to efficiently query their extensive data by organizing it into more manageable subsets . Vertical fragmentation involves dividing data based on different attributes, while horizontal fragmentation entails splitting the data into tuples . This ensures that data retrieval meets specific branch requirements efficiently and decreases data redundancy by distributing only relevant data to each branch .
Using a metropolitan area network (MAN) provides Winnis Restaurant and Bakery with the capability to connect multiple branches within a citywide radius, facilitating efficient data sharing and communication between sites . MAN networks support high-speed connections that are critical for handling large volumes of data traffic, essential for seamless database operations, and improving overall system performance .
While MySQL offers high performance and perfect integration with web applications, potential challenges include limitations in certain advanced SQL functionalities compared to other DBMS such as PostgreSQL or Oracle . MySQL's open-source nature may also require more frequent updates, and dependency on community support can be challenging if commercial-grade support is required . Additionally, without careful configuration, the system could face security vulnerabilities, data integrity issues, and performance bottlenecks .
Winnis Restaurant and Bakery might choose Windows 7 as the implementation platform due to its reliability, ease of use, and stability, which are crucial for maintaining a robust server environment . Additionally, the widespread commercial use of Windows 7 ensures a broad availability of compatible applications and comprehensive support for developing new applications, making it a strategic choice for running their servers that host web applications .
The multi-threaded, multi-user capability of MySQL allows simultaneous requests from multiple users or processes to be handled efficiently, which is crucial for a distributed database that supports several branches concurrently . This capability enhances the system's performance by optimizing resource use, reducing query response times, and providing robust support for concurrent transactions, thus ensuring that operations such as issuing invoices or managing product availability are executed smoothly across all branches .
Deploying a distributed database system requires a robust architecture that ensures seamless data distribution and consistency across branches . This includes implementing network configurations like MAN for efficient data communication, adopting strategies like replication for data availability, and using fragmentation to meet query demands . The architecture must also consider security protocols to protect data across multiple nodes, and incorporate failover solutions to mitigate risks associated with node failures. Additionally, it must support scalability and maintain continuity in performance as the business expands .
A homogeneous database system positively affects scalability by allowing uniform updates and expansions across all sites due to identical DBMS installations, simplifying maintenance since only one system configuration needs to be managed . This uniformity also makes it easier to scale the system by adding additional nodes or branches without significant compatibility issues, enabling seamless integration and reducing training needs for technical staff on multiple database systems .
PHP integration enhances system flexibility by allowing dynamic web applications that easily communicate with the MySQL database, enabling real-time updates and interactions with users . This integration supports a variety of functionalities, such as responsive web designs, user authentication, and efficient data retrieval processes, streamlining operations like customer registration and product management . Furthermore, PHP's compatibility with MySQL aids in developing custom solutions tailored to specific needs of Winnis Restaurant and Bakery, thus increasing the overall adaptability of their system .