Got a tricky question? Receive an answer from students like you! Try us!

Distributed Database - Essay Example

Only on StudentShare
Author : murazikchaya

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

Extract of sample
Distributed Database

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.
...
Download paper

Related Essays

BLOBs in database
The storage and retrieval of these items can be accomplished through a database system using a column type capable of storing binary data (commonly referred to as a "binary large object" or a BLOB). There are many existing database systems capable of storing BLOBs. Such systems' functionality, performance and cost vary greatly among vendors (with some costing as much as $25,000 for a single CPU license). The prohibitive cost often keeps some organizations from conducting full assessments of database systems for possible use in their operations, potentially causing a loss or revenue. Entities…
4 pages (1004 words)
Distributed Electrical Generation
Cost and price of electricity has been taken as the moderating factor. Thus all of the independent factors will be considered in accordance with the cost and price of electricity. The black out of electricity in the northeastern parts of USA have been studied in great detail and has been taken as an example of which to base the blackout portion of the study. A questionnaire has been developed in this regard and face-to-face interviews have been conducted in order to gather primary data. The aim of this study is to define how electricity can be generated and distributed with regards to each of…
90 pages (22590 words)
Database Architecture & Administration
The first multipurpose DBMS became commercially available in the 1960s and the first standardised DBMS was developed in 1971 by the "Database Task Group."…
5 pages (1255 words)
Database Management. MSSQL Server Database.
In this case the university requirements deal with a variety of services which requires their data to be stored in a database so that it can be successfully fetched and modified for performing a variety of functions. …
3 pages (753 words)
distributed database development assignment
The client can access information by directly or indirectly connecting to the database server. For example, if a client connects to a server requests access to information from a database contained on that server a direct connection established. To elaborate further, if the client connects to the Head Quarter database and requests access to the data held in warehouse (inventory ) or retail stores (item, color ) tables, he can do so by a simple query – “ select * from inventory;”. This is a direct query as the object, i.e., the inventory table is not located on the remote database. On the…
10 pages (2510 words)
DISTRIBUTED SYSTEMS
Due to time limitation, this problem has not been resolved yet and therefore, the application still requires to be fine tuned to allow it to be run through IIS rather than involving Visual Studio’s internal ASP.NET Development Server.…
12 pages (3012 words)
Enterprise Database Management System
The growing scale of data demands a better and reliable method to manage and access them. Such a demand has yielded in the development of Database Management Systems. Every organization needs some sort of information to be stored and accessed all the time and as a result, Database Management Systems have become an integral part of every organization.…
8 pages (2008 words)