Chapter 8

                DATA.......................WAREHOUSE

Data warehouse is a logical collection of information

- gathered from many different operational database

- support business analysis activities and decision making tasks.

Before the data are loading into the data warehouse, the data first will be extracted from internal and external database and then transform the info using a common set of enterprise definitions. This process is called......

ETL - Extraction, transformation and loading

Different with databases (contain information in a series of two- dimensional tables), data warehouse and data mining have information that is multidimensional (contain layers of column and rows)

There are also a process called Information cleansing or scrubbing. This process weeds out and fix or delete inconsistent, incorrect, or incomplete info. It is to maintain high-quality data in the data warehouse.

Biz intelligence - info that people use to support in decision making. There are 3 principle BI enablers which is technology, people and culture......

Chapter 7

Storing Organizational Information - Database

As I said in previous entry, information are everywhere in an organization. So, it means that there must be one storage that used to store that info. The answer is...... 

DATABASE

There are 3 types model of database which is 

• hierarchical database model
• network database model
• relational database model

The function for this 3 model is same - to store the info but the difference is the way the info is stored and each one of the model are suitable for particular types of information.

There are 2 elements of information that stored in the database which is, entity and attributes. Primary keys and foreign keys identify the various entity classes (tables) in the database

5 database advantages from business perspective....

flexibility

scalability & performance

information integrity

information security

and lastly..........reduce info redundancy

~~Alkisah maka tersebutlah kisah~~

Assalamualaikum dan selamat sejahtera kpd sesiapa saja yang mengunjungi ke blog ini...Disebabkan arini aakku dah kering idea so aku juz present about my hometown....

So secara amnye (da boring guna basically) Kuala Kangsar terdiri daripada beberapa bahagian iaitu Sg. Siput, Kota Lama Kanan, Kota Lama Kiri, Sayong, Lubuk Merbau, Chegar Galah, Senggang, Kampung Buaya dan Pulau Kamiri. Kuala Kangsar adalah salah satu daerah di Perak dan merupakan Bandar Diraja

Adelah beberapa tempat menarik yang anda harus kunjungi jika datang ke sini LET'S ROLL!!!!!

Istana Kuning@Muzium Diraja

Masjid Ubudiah

Dataran Putra

Jambatan Sultan Abdul Jalil

Galeri Sultan Azlan Shah

Jam Besar Kuala Kangsar

Tapi kan dalam byk2 tempat nie, ade 1 tempat yg sayee rasekan paling menarik and xpernah boring even pergi tiap2 hari pun.....

Hahaha...Sekian................................

Chapter 6

Valuing Organizational Information

HYE GUYS!!!!

In organization, there are many information in it. A good worker will find the information needed, process or analyse and then do the decision making. This is important because it will effect the company's direction and profitability. 

There are 3 level of organizational information and they are information level, information formats and information granularities. Timeliness is an aspect of information that depends on the situation.

Real-time information

"immediate, up-to-date info"

Real-time system

"provides real-time info in response to query request"

 The business decision will good varies to the quality of the information that worker search. It is unfortunate if you are using technology but later, provide bad decision making to the company. This will give bad consequences to the company. 

A good information have characteristic such as accuracy, completeness, consistency, uniqueness and timeliness while bad info have redundancy, do not have evidence, and not accurate.

2 benefits if good information is achieved.

• Improve the chance of making good decision making
• Directly impact an organization's bottom line.