Online Analytical Processing (OLAP) – Definition, Architecture and Functionality

OLAP Council (1997) define Online Analytical Processing (OLAP) as a group of decision support system that facilitate fast, consistent and interactive access of information that has been reformulate, transformed and summarized from relational dataset mainly from data warehouse into Multi-Dimensional Databases (MDDB) which allow optimal data retrieval and for performing trend analysis. OLAP is an important concept for strategic database analysis. OLAP have the ability to analyze large amount of data for the extraction of valuable information. Analytical development can be of business, education or medical sectors. The technologies of data warehouse, OLAP, and analyzing tools support that ability.

Online Analytical Processing (OLAP) enable discovering pattern and relationship contain in business activity by query tons of data from multiple database source systems at one time.… Read the rest

Database Management System (DBMS) – Components, Advantages, and Disadvantages

A Database management system (DBMS) is software designed to manage and maintain large quantities of data. The DBMS serves as the mediator between the user and the database. The database structure itself is stored as a collection of files. The data in these files can only be accessed through the DBMS. A single, integrated view of the data in the database is shown to the user by the DBMS. All application requests received by the DBMS are translated into complex operations required to fulfill these requests. The database’s internal complexity is hidden by the DBMS from the application programs and users.… Read the rest

The Difference Between Traditional File Systems and DBMS

Traditional File Systems

File-based systems were an early attempt to computerize the manual filing system. File-based system is a collection of application programs that perform services for the end-users, such as updating, insertion, deletion adding new files to database etc. Each program defines and manages its data.

When a computer user wants to store data electronically they must do so by placing data in files. Files are stored in specific locations on the hard disk (directories). The user can create new files to place data in, delete a file that contains data, rename the file, etc which is known as file management; a function provided by the Operating System (OS).… Read the rest

Data Mining – Meaning, Steps and Business Applications

Data mining or knowledge discovery is the process of analyzing data from different perspectives & summarizing it into useful information. This information can be used to increase revenue & cut cost or both. We know that data mining software is one of a number of analytical tools for analyzing data. It allows users to analyze data from many angels & categories it.   It also summarizes the relationship identified. Technically speaking data mining is the process of correlations among dozens of fields in large relational database. In other words it is the process of sorting through large amount of data & picking out important information.… Read the rest