Organizations tend to grow and prosper as they gain a better understanding of their environment. Typically, business managers must be able to track daily transactions to evaluate how the business is performing. By tapping into the operational database, management can develop strategies to meet organizational goals. The process that identified the trends and patterns in data are the factors to accomplish that. By the way, the way to handle the operational data in organization is important because the reason for generating, storing and managing data is to create information that becomes the basis for rational decision making. To facilitate the decision-making process, decision support systems (DSS) were developed whereas it is an arrangement of computerized tools used to assist managerial decision making within a business.… Read the rest
Data Management Concepts
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