Please enable JavaScript.
Coggle requires JavaScript to display documents.
FOUNDATION OF BUSINESS INTELLIGENCE: DATABASE AND INFORMATION MANAGEMENT…
FOUNDATION OF BUSINESS INTELLIGENCE: DATABASE AND INFORMATION MANAGEMENT
PROBLEMS OS MANAGING DATA IN TRADITIONAL FILE ENVIRONMENT
Data Redundancy
Inconsistency
Dependancy
Lack of flexibilty
Poor security
6.Lack of data sharing
Lack of availability
DATABASE MANAGEMENT SYSTEM
How solves The Problems of Traditional File Environment?
redundancy,inconsistency - minimize isolated files in which data are repeated. Cannot eliminate but can control
Dependancy - enable data stand their own.
Access and availability - will be increased, maintenance cost reduced - because users and programmers can perform hoc queries without writing complicated programs
Security- centrally manage data and their use
Data sharing-easier because data presented being single location
Relational DBMS
-represent data as two-dimensional tables. each tables contains entity and attributes
Select - creates subsets which consists all records in the file meet criteria
Join - combines relational tables
Project - Create subsets consists of columns is a table
CAPABILITIES OF DBMS
Querying and reporting
DESIGNING DATABASE
Normalization and entity relationship diagrams
PRINCIPAL TOOLS
The challenge of big data
Bussiness intelligence infrastructure
data warehouse and data marts
hadoop
in-memory computing
analytic platforms
data mining
text mining and web mining
IMPORTANCE OF INFORMATION POLICY, DATA ADMINISTRATION, DATA QUALITY ASSURANCE
Establishing an information policy-rules for sharing,disseminating,acquiring,standardizing,classifying,inventorying informations
Ensuring Data Quality