DBM405 (Database Management System)
Abstract
The research that I have done for this individual assignment where I need to provide a brief explanation of OLAP, Data Warehouse and Data Mart, Three-tier architecture and ASP was through a research online. I found that most of these acronyms for computer terminology are hard to find when the meanings that apply to your subject or acronym you are un-aware of it. In conclusion all the above words are related one to each other.
Let me start this paper providing a shot briefing about how hard was for me finding most of the explanation of these four terminologies that I will be explaining below.
OLAP is the first word that I will define in my paper. OLAP is an acronym for On-Line Analytical Processing. It is an approach to quickly providing the answer to complex database queries. Is used in today business for reporting sales, marketing, management reporting, data mining and similar areas.
The main reason of using OLAP to answer queries is speed. Relational databases store entities in discrete tables if they have been properly normalized. This structure is good for operational databases but for complex multi-table queries is comparatively slow. A better model for querying but worse for operational use is the dimensional database.
OLAP take a snapshot of a relational database and restructures it into dimensional data. The queries can ten be run against this. It has been claimed that for complex queries OLAP can produce a result in around 0.1% of the time for the same query on relational data.
For example a set of customers can be grouped by city, by district or by country; so with 50 cities, 8 districts and two countries there are three hierarchical levels with 60 members. These customers can be considered in relation to products; if there are 250 products with 20 categories, three families and three departments then there are 276 product members. With just these two dimensions there are 16,560 possible aggregations. As the data considered increases the number of aggregations can quickly total tens of millions or more.
The above example from Webopedia.com give us a better picture how many more aggregations are add without notice it. Thanks to OnLine Analitical Processing minized the time to a result in around 0.1% of the time for the same query on a relational data.
The second terminology that I research was Data Warehouse and Data Mart.
Prior to presentation of the relevant literature as described above it is first necessary to define essential terms for purposes of clarity and understanding.
In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.
We will discuss some of them in this analysis. User Friendly Microsoft Access is a user friendly application software database. According to Microsoft ® Corporation (2004), “Access version 2002 extends this versatility by giving developers and more experienced users new functionality, enabling them to access and analyze their important data as well as build powerful new database solutions. At the same time, Access now makes it easy for beginning users to discover and use more of the existing application” (no pg).
This paper was written to show the similarities and differences in five different databases. It compared Access, MySQL, SQL Server, DB2, and Oracle in six different areas. It found many similarities in functionality, but large diversity in pricing.
I will explain each category to some level of depth, focusing primarily on public space, providing examples of scenarios along with conclusive evidence of their existence and effects on lifestyles.
SEARCH-BASED APPLICATIONS: SBAs use semantic technologies to process and classify unstructured and structured content across multiple databases, and employ technologies for accessing information.
Businesses have data warehouses in place to attain knowledge about latest fads in organization data that affect the business strategically. This type of analysis and reporting is called OLAP: on line analytical processing. Management uses OLAP tools on data warehouse to run reports and make determinations. This would be impossible to do with an operational data store, since operational data store contains data that is only true at the current time. For exam...
Following are key terms in the problem or question that are not clear and thus need to be defined:
For example, each row of a spreadsheet may store information about a car that Sutton Dealership will sell. Each column may store a different aspect of the car's information, such as model, make, colour, engine size, etc. The spreadsheet software can analyse this data by counting the number of people who purchased car with 2.0 litre engine size, listing all the people who purchased white cars, or performing other calculations. This makes spreadsheets similar to database.
[7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.
A data warehouse comprised of disparate data sources enables the “single version of truth” through shared data repositories and standards and also provides access to the data that will expand frequency and depth of data analysis. Due to these reasons, data warehouse is the foundation for business intelligence.
I will begin this paper by reciting some of the definitions that I did find.
Prior to the start of the Information Age in the late 20th century, businesses had to collect data from non-automated sources. Businesses then lacked the computing resources necessary to properly analyze the data, and as a result, companies often made business d...
The Database Management System (DBMS) is software that enables the users to define, create, maintain and control the access to the database. It is a software that interact with the user’s applications programs and it database. Meanwhile, information retrieval system is a system that involved the activity that the systems obtain the information. The obtaining information action need the information from it resources.
Data can be organized a specific way for each business to be able to get the best use. Employees can also access the system at the same time but in different ways. For example, the customer service team can pull up documents and keep track of complaints at the same time that the marketing team is in a