LP3 Assignment: Database Applications This assignment will assess the competency
ID: 384990 • Letter: L
Question
LP3 Assignment: Database Applications
This assignment will assess the competency 3. Investigate the fundamental aspects of data and information management.
Directions: Prepare a written assignment of 2-3 pages that investigates the following topic: Define and discuss data warehouses, data marts, and data mining. Also, define and discuss business intelligence, online analytical processing (OLAP), and object-relational database management systems.
This assignment needs to have the following:
• A cover page (includes student's name, date, class title, and assignment title)
• Paper needs to be 2-3 pages (minimum 2 full pages), 12 point font, double spaced, and writing is grammatically correct
• A reference page (If you are referencing information from a textbook or other source, then an APA formatted citation and reference page is necessary)
Explanation / Answer
Data Warehouses:
A database is used for the requirement of Reporting and Analysis of data. In this, the data stored in warehouses are uploaded out of the operating systems which can be a marketplace, sales etc.
The Advantages of using data houses are listed below:
It always contains a copy of data and maintains it. Their architect provides the following Benefits:
It maintains a proper history of data, integrates data from multiple resource system, it also provides consistency in codes of systems thereby maintaining a good data quality. It also presents data on an organization efficiently etc.
Data Marts:
These are the access layers of a data warehouses which is utilized to get data from the users. It is a subset of a data warehouse which is oriented towards a team or a business line. While deployment every department or business unit is assumed to be the owner of the data mart including hardware, software etc. It makes them capable to bring required changes without asking anyone.
There are various reasons for creating a data mart: it makes an easy access to normally used data, helps in generating a collective picture, helps in improving response to a user, it is easy to create, it has lower cost than a fully implemented data warehouse, important users are well defined, it contains only business-oriented data are some of the reasons for using Data Marts.
Data Mining:
It is the process of defining common aspects in larger databases. It makes use of an intersection method of artificial intelligence, stats and database systems etc. the main objective and aim of data mining are to gather knowledge from available data set and convert into a human understandable structure for further use.
Other than raw analysis steps it makes use of database management concepts, data reprocessing, interference considerations, complexity consideration, post toughness consideration, visualization and online resource availability etc. The commonly known tasks of data mining can be understood as analysis of huge amount of data in an automatic way in order to gather a pattern such as data records, unusual records etc. this pattern found as a result of data mining can be further used in obtaining a more accurate prediction results by making use of a decision support system.
The process of data mining can be listed as under:
Business Intelligence:
It is the ability in an organization of convert all its ability into knowledge in order to achieve right information on right time via a proper medium. This all information helps in knowing the new opportunity for the organization and to achieve success. It also helps an organization in maintaining a stability in the market and to achieve a competitive advantage in the market.
This type of technology helps in providing useful information such as about history, existing and predictive future pictures in the market business aspects. There are many functions out of which few areas online analytical processing, reports generation, data mining, process mining, business performance analysis, text mining, predictive analysis etc. Normally business intelligence makes use of data from data warehouses or data marts.
Online Analytical Processing:
It is an approach which was developed to answer a multi-dimensional query in one go. It is basically a part of Business Intelligence. Most common applications of OLAP used these days are business reporting for sales, business process management, forecasting, financial reporting and many more.
The tools developed on OLAP makes users to interactively analyze multi-dimensional data in different -different perspective.
It consists of three analytical operations: Roll-Up i.e. consolidation, Drill-down, slicing and dicing etc.
Roll-up basically is the process of collecting the data which can be processed and accumulated. The Drill-down is the method by which the user can navigate in between the collection of such huge data. Slicing and disliking is the process by which the user can take out a portion of data from different ways. The classification of OLAP can be as following: Multidimensional, Rational, and hybrid.
Object-Relational Database Management Systems (ORDBMS):
It is a type of Database Management System which is very common to the rational database except it consist of object-oriented concepts. In this, the classes, objects, and inheritance are supported by the database management system and in the query systems. It actually provides a middle system in between rational database and object-oriented database. In case of this database management system, it is essentially an object store for software written in object-oriented programming language, with API for storing and retrieving objects, and low-level support for querying if required.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.