Database Data Warehousing Design
Data warehousing is a powerful tool that business organizations use to enhance competitive advantages. Data warehousing supports business decision by collecting, organizing and consolidating data for analysis and reporting using tools such as OLAP (online analytical processing ) and data mining. Typically, the relational database technology is generally being used to design a data warehousing and a relational database is a database having collection of tables, and organized based on the relational model. One of the main goals of business organizations is to use data to leverage their strategic competitive advantages. Typically, the data warehousing has become a strategic priority because of the enormous amount of data that organizations need to analyze. Using a relational database, organizations have been able to develop a data warehousing that could assist management to make effective decision. (Microsoft, 2012).
Fundamental objective of this paper is to design the data warehousing for a data collection company using a relational database. In the database framework, the paper incorporates data warehousing to enhance greater understanding of what data warehousing can deliver to the company.
Data Warehouse Tool
The essence of data warehousing is to provide superior performances to business intelligence. Typically, data warehouse organizes data efficiently to assist businesses to make effective decision-making. OLAP is an effective data warehouse tool that organizes data into multidimensional cubes, which assists in summarizing data in various ways. For example, a query request of the quantity sold for range of product across different geographical regions could be answered within few seconds. The inherent performances of data warehouse are the ability to rapidly summarize the data for analytical queries. (Tera Data, 2012).
Moreover, the data warehousing delivers data mining tool that applies a complex algorithm and sophisticated technology to analyze data for decision-making. The paper provides the database schema that supports the data warehousing requirements.
Creating a Database Schema
Database schema is a text-based or graphical representation used to generate database physical model. The database schema consists of the following tables for the Data Collection Company as presented below:
The database schema:
Customers: stores customer's data
Products: stores a list of services delivered.
Product Lines: stores a list of product and service line category.
Orders: stores orders placed by the customers.
OrderDetails: stores the order line items of each order.
Payments: stores payments made by the customers based on customer's account.
Employees: stores all employee information, which includes organizational unit structure.
Offices: stores sale office data.
Using the information above, the paper provides the following database schema.
CREATE TABLE 'customers' (
'customerNumber' int (12) NOT NULL,
'customerName' varchar (55) NOT NULL,
'contactLastName' varchar (45) NOT NULL,
'contactFirstName' varchar (45) NOT NULL,
'phone' varchar...
Database Data Warehouse Design Our company, Data Analytic Limited, specializes in collecting and analyzing data for various organizations. Over the years, we have assisted various companies to turn raw data into valuable information that assists the companies in making effective decision profitable in the short and long run. Our research and data analytics are geared towards giving extra edge to various companies. Our services include processing and analyzing terabytes of data
Data Warehousing Data Warehouse technology has changed the way that global organizations conduct business. Many have found it impossible to create a business strategy without a data warehouse. The purpose of this discussion is to research and explain the importance of data warehouse management. We will begin by defining data warehouse and describing the business uses for the technology. Our discussion will then focus of data warehouse management. We will examine the
The use of databases as the system of record is a common step across all data mining definitions and is critically important in creating a standardized set of query commands and data models for use. To the extent a system of record in a data mining application is stable and scalable is the extent to which a data mining application will be able to deliver the critical relationship data,
Data Mining in Health Care Data mining has been used both intensively and extensively in many organizations.in the healthcare industry data mining is increasingly becoming popular if not essential. Data mining applications are beneficial to all parties that are involved in the healthcare industry including care providers, HealthCare organizations, patients, insurers and researchers (Kirby, Flick,.&Kerstingt, 2010). Benefits of using data mining in health care Care providers can make use of data analysis in
Data Warehousing and Data Mining Executive Overview Analytics, Business Intelligence (BI) and the exponential increase of insight and decision making accuracy and quality in many enterprises today can be directly attributed to the successful implementation of Enterprise Data Warehouse (EDW) and data mining systems. The examples of how Continental Airlines (Watson, Wixom, Hoffer, 2006) and Toyota (Dyer, Nobeoka, 2000) continue to use advanced EDW and data mining systems and processes to streamline
Data Warehousing: A Strategic Weapon of an Organization. Within Chapter One, an introduction to the study will be provided. Initially, the overall aims of the research proposal will be discussed. This will be followed by a presentation of the overall objectives of the study will be delineated. After this, the significance of the research will be discussed, including a justification and rationale for the investigation. The aims of the study are to
Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.
Get Started Now