Advanced Database System Abstract
Data is collection of raw facts and figure which is basic for decision making. Anything which is unorganized is called data. Database is collection of data, which is organized in a way that allows for easy data retrieval and manipulation. Database system is the way in which databases are arranged. DBMS is the software component or logical tool to handle databases
A database is a collection of related data which represents some aspect of the real world. A database system is designed to be built and populated with data for a certain task.
Introduction
A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. Database is the back end of an application. A DBMS receives instruction from a database administrator and accordingly instructs the system to make the necessary changes. These commands can be to load, retrieve or modify existing data from the system. There are four main types of database organization:
Relational Database:
Data is organized as logically independent tables. Relationships among tables are shown through shared data. The data in one table may reference similar data in other tables, which maintains the integrity of the links among them. This feature is referred to as referential integrity – an important concept in a relational database system. Operations such as “select” and “join” can be performed on these tables. This is the most widely used system of database organization.
Flat Database:
Data is organized in a single kind of record with a fixed number of fields. This database type encounters more errors due to the repetitive nature of data.
Object-Oriented Database:
Data is organized with similarity to object-oriented programming concepts. An object consists of data and methods, while classes group objects having similar data and methods.
Hierarchical Database:
Data is organized with hierarchical relationships. It becomes a complex network if the one-to-many relationship is violated.
Here are some most popular Database Systems:
- Oracle RDBMS
- IBM DB2
- Teradata
- MySQL
- Microsoft Access
- Oracle
- PostgreSQL
- dBASE
- FoxPro
- SQLite
- LibreOffice Base
- MariaDB
- Microsoft SQL Server etc.
History of DBMS
Here, are the important landmarks from the history:
- 1960 – Charles Bachman designed first DBMS system
- 1970 – Codd introduced IBM’S Information Management System (IMS)
- 1976- Peter Chen coined and defined the Entity-relationship model also know as the ER model
- 1980 – Relational Model becomes a widely accepted database component
- 1985- Object-oriented DBMS develops.
- 1990s- Incorporation of object-orientation in relational DBMS.
- 1991- Microsoft ships MS access, a personal DBMS and that displaces all other personal DBMS products.
- 1995: First Internet database applications
- 1997: XML applied to database processing. Many vendors begin to integrate XML into DBMS products.
Characteristics of Database Management System
- Provides security and removes redundancy
- Self-describing nature of a database system
- Insulation between programs and data abstraction
- Support of multiple views of the data
- Sharing of data and multiuser transaction processing
- DBMS allows entities and relations among them to form tables.
- It follows the ACID concept ( Atomicity, Consistency, Isolation, and Durability).
- DBMS supports multi-user environment that allows users to access and manipulate data in parallel.
Application of DBMS
Banking :- For customer information, account activities, payments, deposits, loans, etc
Airlines :- For reservations and schedule information
Universities :- For student information, course registrations, colleges and grades
Telecommunication :- It helps to keep call records, monthly bills, maintaining balances, etc
Finance :- For storing information about stock, sales, and purchases of financial instruments like stocks and bonds
Sales :- Use for storing customer, product & sales information
Data Warehousing
A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources.
There are two approaches to data warehousing, top down and bottom up. The top down approach spins off data marts for specific groups of users after the complete data warehouse has been created. The bottom up approach builds the data marts first and then combines them into a single, all-encompassing data warehouse.These technologies help executives to use the warehouse quickly and effectively. They can gather data, analyze it, and take decisions based on the information present in the warehouse. The information gathered in a warehouse can be used in any of the following domains
-
Tuning Production Strategies: The product strategies can be well tuned by repositioning the products and managing the product portfolios by comparing the sales quarterly or yearly
-
Customer Analysis: Customer analysis is done by analyzing the customer’s buying preferences, buying time, budget cycles, etc
-
Operations Analysis: Data warehousing also helps in customer relationship management, and making environmental corrections. The information also allows us to analyze business operations
Application of Data Warehouse
1. Information Processing:
Quering, basic statistical analysis and reporting using crosstabs, table, cahrts or graphs. A current trend in data warehouse information processing is to construct low cost web based accessing tools that are then integrated with web browsers.
2. Analytical Processing:
A data warehouse is often used as the basis for a decision support system. Data can be analyzed by means of basic OLAP operations, including slice and dice, drill-down. It generally operates on historical data in both summarized and detailed forms.
3. Data Mining:
It is also called knowledge discovery. There are two main kinds of models is data mining. One is predictive models and another one is descriptive models.
Online Analytical Processing
OLAP is computer processing that enables a user to easily and selectively extract and view data from different point of view. OLAP is best known technology that allows a user to slice and dice data or drill-down into data. OLAP is technology that uses a multidimensional view of aggregate data to offer fast access to strategic for the purpose of advanced analysis, deeper understanding.
Role of the OLAP Server in the Data Warehouse
OLAP servers deliver warehouse applications such as performance reporting, sales forecasting product line and customer profitability, sales analysis, marketing analysis, what-if analysis and manufacturing mix analysis — applications that require historical, projected and derived data. With OLAP servers’ robust calculation engines, historical data is made vastly more useful by transforming it into derived and projected data. Users gain broader insights by combining standard access tools with a powerful analytic engine.
Data Marts
A data mart is a simple form of data warehouse that is focused on a single subject like sales, Finance, Marketing. Data marts are often built and controlled by a single department with in an organization. Data marts usually takes data from only a few sources because of single subject. The sources could be internal operational systems a central data warehouse or external data. Data marts improve end-user response time ny allowing user to have access to the specific type of data.
Conclusion
The advanced database system is nothing but are some new features in the database system. As we discussed about the query processing and optimization and data ware house, these are the new feature of database system and are in trends. One of the most critical functional requirements of a DBMS is its ability to process queries in a timely manner, query process and optimization are used to process query in timely. And we also discuss the three phases of its through which a query is process and optimized where data ware house is subject oriented, integrated, time –variant and non-volatile collection of data in support of management’s decision making process.
1 thought on “Advanced Database System”