StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Distributed Database - Essay Example

Cite this document
Summary
Given that the ActiveWear Traders Clothing Australia has a Headquarters in Brisbane (BRISHQ), and warehouses in both Brisbane (BRISWH) and Melbourne (MELWH) with more than 60 retail stores across the country.
Create the processes that extract data from source systems; cleanse, transform, and match data according to specified business rules; import data into the data warehouse structure; use query, reporting, and mining tools to access the data and address key business questions
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER94.6% of users find it useful
Distributed Database
Read Text Preview

Extract of sample "Distributed Database"

Download file to see previous pages

Best customers are those who subscribe to 7day, 52week, EZPay {automatic payment from credit card} subscriptions. 2. Existance in the marketplace and we have touched them. By building "complete" universe of households with extended demographics, and by attaching "touch" or contact histories to individuals, can determine what is working on what types of customers (and what isn't working). We need to build touch history over time. Value increase as more history is accumulated. 3. We build a loyalty model based on a subscriber's payment history.

Loyalty can be defined as overall duration as subscriber, number of consecutive payments (with unbroken service), etc. We can then create a profile of a "loyal" subscriber and more effectively identify likely churners vs. likely loyal subscribers. This is a very important step in the data warehousing project, as the foundation of the data warehousing system is the data model. A good data model will allow the data warehousing system to grow easily, as well as allowing for good performance. In data warehousing project, the logical data model is built based on user requirements, and then it is translated into the physical data model.

This project uses Dimensional modeling, which is the name of the logical design technique often used for data warehouses. It is different from entity-relationship modeling. Entity relationship modeling is a logical design technique that seeks to eliminate data redundancy while Dimensional modeling seeks to present data in a standard framework that is intuitive and allows for high-performance access. Every dimensional model is composed of one table with a multi part key, called the fact table, and a set of smaller tables called dimensional tables.

Each dimension table has a single part primary key that corresponds exactly to one of the components of the multi part key in the fact table. This characteristic star like structure is often called a star join. A fact table, because it has a multi part key made up of two or more foreign keys always expresses a many-to-many relationship. The

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Distributed Database Essay Example | Topics and Well Written Essays - 3000 words”, n.d.)
Distributed Database Essay Example | Topics and Well Written Essays - 3000 words. Retrieved from https://studentshare.org/miscellaneous/1521552-distributed-database
(Distributed Database Essay Example | Topics and Well Written Essays - 3000 Words)
Distributed Database Essay Example | Topics and Well Written Essays - 3000 Words. https://studentshare.org/miscellaneous/1521552-distributed-database.
“Distributed Database Essay Example | Topics and Well Written Essays - 3000 Words”, n.d. https://studentshare.org/miscellaneous/1521552-distributed-database.
  • Cited: 0 times

CHECK THESE SAMPLES OF Distributed Database

DISTRIBUTED SYSTEMS

The application successfully demonstrates the Distributed Database operations as it allows the user to not only view the records of both London and Scotland sites, but also to manipulate the data by inserting new or updating existing records.... This can be achieved through re-designing the database involving three key aspects – data fragmentation, data replication and data allocation.... Data Fragmentation refers to the process of breaking up the database into logical units called fragments which can be stored at different sites....
12 Pages (3000 words) Essay

Distributed databases

This paper seeks to find a suitable Distributed Database that can fit two small retail stores. This paper Distributed Databases Introduction A Distributed Database (DDB) is a compilation of numerous, logically interconnected databases distributed through a computer system.... This paper seeks to find a suitable Distributed Database that can fit two small retail stores.... A partitioning schemeThis paper recommends a scheme for vertical partitioning of a Distributed Database....
2 Pages (500 words) Research Paper

High-Quality Distributed Database Systems

In the current speedy and constantly advancing technological world, the need to have high quality Distributed Database systems is one of the most crucial subjects of concern.... This is specifically on issues based on controlling concurrency of organization data and most importantly, the security of data and transactions handles by Distributed Database systems.... The authors of the article address indicate that concurrency control and security threat is a very crucial subject of concern in Distributed Database networks....
4 Pages (1000 words) Research Paper

Technical Architecture and Why

Distributed Database systems.... There are various factors capable of guiding the technical aspects within the Enterprise like… Client/server architecture that incorporates hardware and software components that interact to form a distributed system is required for proper development of client/server system in the big box retailer (Ray, Technical architecture and why Lecturer: ‘Big box' retailers like Walmart deal with huge volumes of data; therefore, the technical architecture should allow sharing and utilization of information across the organization....
1 Pages (250 words) Assignment

Distributed Databases/Very Large Databases

Especially Distributed Database, and it is very large database to handle such a huge type of business.... The more success achieved by Walmart is due to its strong large type of Distributed Database and other business tools, which are used for data storage.... The large Distributed Database is being worked for Walmart and all sales, purchase process is performed through it (Singh, 2013).... The management procedure of Walmart in terms of commodities, locations, employees and all other services and benefits they use the database....
2 Pages (500 words) Assignment

Distributed Database Management Systems

Decentralized database, on the other hand, is an example of a massive database being divided into smaller ones. The Centralized DDBMS versus a Decentralized Database Insert Insert Introduction A Distributed Database management system manages a Distributed Database.... That is a database whose storage is in multiple computing systems that may or may not be in the same location.... Consequently, the work of the DDBMS is control such a database as though it was working in the… The purpose is to synchronize the data and ensure that actions like updates are in all other areas in case of multiple users....
1 Pages (250 words) Essay

IPR Law Firm's Distributed Database Management System

This paper aims to study the architecture and requirements of the Distributed Database management system of an Intellectual Property Rights Law firm in the United States.... The paper identifies the problems in the existing architecture and recommends solutions to overcome them  … The Distributed Database management system of an IPR law firm is a client/server and 2-tier structure.... The Distributed Database management systems refer to a software that allows the management of databases distributed on a computer network to provide transparent distribution activity to the user....
10 Pages (2500 words) Term Paper

What Is a Distributed Database

This assignment "What Is a Distributed Database" sheds some light on the word client-server that refers to an accepted model for networking of computer systems that makes use of server and client devices which are designed for their respective purposes.... ldquo;A Distributed Database is a database that is split over multiple hardware devices but managed by a central database controller” (Holmes n.... A Distributed Database means the division of a database into different physical units separated by a business or geographical region....
6 Pages (1500 words) Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us