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

Distributed Database - Essay Example

Only on StudentShare
Masters
Essay
Miscellaneous
Pages 12 (3012 words)

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
Not exactly what you need?

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)