Please enable JavaScript.
Coggle requires JavaScript to display documents.
Foundations of Business Intelligence : Databases and Information Management
Foundations of Business Intelligence : Databases and Information Management
Database
Definition : Collection of related files containing records on people, places, and things.
Example : telephone book
Address
Last name
Phone numbers
First name
Paper-based database (Modern History)
inflexible, inefficient, costly to maintain, and often contain inaccurate data.
Computer database : the ability to quickly relate one set of files to another
Business Intellegence
Multidimensional Data Analysis
Online Analytical Processing (OLAP)
Data Mining
Start with thinking the data for your business
classification of 'entity'
Entity - The maintain informations like customer, supplier......
Each entity has specific characteristics, called 'Attributes'
Ex. Supplier (entity) - [last name, first name, address, email] (attributes)
Relational Database- Table
Rows (records, tuples)
The single data which is resides in the Table.
Key Field : The key field is the unique identifier for all the information in any row of the table.
The Relational Database is the most common type of database today
Columns (attributes, fields)
Each column is represent an attribute of the Table.
Part Table
Foreign Key - Part Table 與Table的連結，這個key會紀錄每一筆Part entity與Table entity連結的關係
What : This table is a separate entity from Table, and fields with information about parts should be sorted in a separate Part Table.
Entity-relationship diagram
Used to clarify table relationships in a relational database
Normalization (正規化) - The process of streamlining complex groups of data to minimize redundant data element and awkward many-to-many relationships, and increase stability and flexibility.
Data Management Systems (DBMS)
Logical View - 以特定形式顯示部份資料，像是MySQL的 SELECT 功能，用戶request所需的attributes，DBMS則回應用戶相對的columns.
DBMS is a specific type of software for creating, sorting, organizing, and accessing data from database.
Physical View - How data are actually organized and structured on physical storage media, such as hard desk
Database and The Web
Customer of Front End
--(request data through website)->
Website & Web Server
--(Interpret commands into SQL)-> -> ->
DBMS
--(working with database)->
Database
Managing Data Resources
WHY?
- Ensure that the data for business remain accurate, reliable, and readily available to those who need it.
Information Policy
It lay out specific procedures and accountabilities, identifying which user and organizational units can share informations.