ACCESSING ORGANIZATIONAL INFORMATION - DATA WAREHOUSE

again and again... yesss that me!! CIK YANNA in da housee!! here, the next entry is about learning outcomes for DATA WAREHOUSE

(1) describe the roles and purpose of data warehouses and data marts in an organization

The purpose of the Data Warehouse in the overall Data Warehousing Architecture is to integrate corporate data. It contains the "single version of truth" for the organization that has been carefully constructed from data stored in disparate internal and external operational databases.

The amount of data in the Data Warehouse is massive. Data is stored at a very granular level of detail. For example, every "sale" that has ever occurred in the organization is recorded and related to dimensions of interest. This allows data to be sliced and diced, summed and grouped in unimaginable ways. 

Typical Data Warehousing Environment

 

Contrary to popular opinion, the Data Warehouses does not contain all the data in the organization. It's purpose is to provide key business metrics that are needed by the organization for strategic and tactical decision making. Decision makers don't access the Data Warehouse directly. This is done through various front-end Data Warehouse Tools that read data from subject specific Data Marts. The Data Warehouse can be either "relational" or "dimensional". This depends on how the business intends to use the information.

(2) explain the relationship between business intelligence (BI) and a data warehouse (DW)

BI is a business management term that refers to the applications and technologies used to gather, provide access to, and analyse data and information about a company's operations. A DW is a repository for a company's historical data. DW can be physical or virtual, and they can be structurally relational, quasi-relational, summarized, cubes, flat files, or a combination of styles. DW is the set of technologies and techniques that you use to build and manage the data warehouse. 

more info?? just click =)

finally, me done my assignments.. yeaayyyy!! =')) Hope this notes will be useful to us.. I'll come back later to updates in next chapter.. btw thanks for reading.... 
KEEP CALM & LOVE YANA =')

STORING ORGANIZATIONAL INFORMATION - DATABASES

HEYYY U'OLLLSSS!! we met again =')  i like to wish SALAM MAULIDUR RASUL to all muslim in this country.. Let's bless of our beloved Prophet, Muhammad S.A.W. aminnnnn.. here, the next entry my lecturer ask us to answer all the questions in learning outcomes.. btw, Done read all my previous entries?? i give a lots of information.. dont miss yaaaa.. ;')

(1) define the fundamental concepts of the relational database model

Concept of a database is that of a collection of records or pieces of information which is a structural description of the type of facts held in database known as a schema. Schema describe the objects that are represented in the database and the relationships among them. There are ways of organizing a schema modelling the database structure known as database models or data models. but nowadays, Relational model is commonly used which is all information in the form of multiple related tables each consisting of rows and columns. this model represents relationships by the use of values common to more than one table. Hierarchy model and the network model is use a more explicit representation of relationships.

(2) evaluate the advantages of the relational database model 

The advantages of the relational model 

• increased flexibility
• increased scalability and performance
• reduced information redundancy
• increased information integrity (quality)
•  increased information security

INCREASED FLEXIBILITY

• good database that can handle changes quickly and easily
• physical view of information deals with the physical storage of information on a storage device such as a hard disk
• logical view of information focuses on how users logically access information to meet their particular business needs

INCREASED SCALABILITY & PERFORMANCE

• scalability refers to how well a system can adapt to increase demand
• performance measures how quickly a systems performs a certain process or transaction

REDUCED INFORMATION REDUNDANCY

• redundancy is the duplication of information, or storing the same information in multiple places
• occurs bcoz organizations frequently capture and store the same information in multiple locations.
• primary problem with redundant is that it is often inconsistent which makes it difficult to determine which values are most current or most accurate

INCREASED INFORMATION INTEGRITY (QUALITY)

• measures of the quality of information
• database environment, integrity constraints are rules that help ensure the quality of information 
• two types of integrity:

(1) relational integrity constraints - enforce bacic & fundamental information based constraints

(2) business (critical integrity constraints) - enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints

INCREASED INFORMATION SECURITY

• organizational asset
• as systems become increasingly complex and more available over the internet, security becomes an even bigger issue
• offer many security features including passwords access levels, and access controls
• password provide authentication of the user

(3) define the database management system (DBMS) and its relationship to a website

DBMS is software through which users and application programs interact with a database. The user sends requests to the DBMS and the DBMS performs the actual manipulation of the information in the database. there are two primary ways that users can interact with a DBMS, directly and indirectly. 

(4) explain why an organization would want to integrate its database

by integrating its systems or building connections between its many database, its allow the organizations multiple system to automatically communicate by passing information between the databases, eliminating the need for manual information entry into multiple systems because after entering the information once, the integrations send the information immediately to all databases. the integrations not only enable the different departments to share information, but have also dramatically increased the quality of the information. without integrations, an organization will,

1. spend considerable time entering the same information in multiple system

2. suffer from the low quality and inconsistency typically embedded in redundant information 

While most integrations do not completely eliminate redundant information, they can ensure the consistency of it across multiple systems. 

Organizational Structures That Support Strategic Initiatives

Did u know what is Organizational Structure?? Read my entry here & Let me tell u.. =') it is about basic structure of a typically IT department including titles, roles, and responsibilities will help an organization build a cohesive enterprise wide team. So that they need to maintain positions in developing  towards elevating some IT positions such as CIO, CTO, CSO, CPO, and CKO. What's that purposes to?? WONDERING?? let me explainn...

CHIEF INFORMATION OFFICER (CIO)

this position is responsible for 

• overseeing all uses of information technology
• ensuring the strategic alignment of IT with business goals and objectives

broad function of CIO include:

• Manager - ensure the delivery of all IT projects, on time and within budget.
• Leader - ensure the strategic vision of IT is in line with the strategic vision of the organization
• Communicator - advocate and communicate the IT strategy by building and strong executive relationships.

CHIEF TECHNOLOGY OFFICER (CTO)

CTO is responsible for ensuring the throughput, speed, accuracy, avaibility, and reliability of an organization's of an organization information technology

CHIEF SECURITY OFFICER (CSO)

This position is responsible for ensuring the security of IT systems and developing strategies and IT safeguards against attacks from hackers and viruses

CHIEF PRIVACY OFFICER (CPO)

CPO is responsible for ensuring the ethical and legal use of information within an organization

CHIEF KNOWLEDGE OFFICER (CKO)

This position of CKO is responsible for collecting, maintaining and distributing the organization's knowledge.

All the above IT positions and responsibilities are critical to an organization's success. The individuals responsible for enterprise wide IT and IT-related issues must provide guidance and support to the organization's employees. 

wish u'ollssS gots the informations and keep reading with my new entry.....

KEEP CALM & LOVE YANA ='D 

how the efficiency & effectiveness the seller using Facebook as a medium of business..

How the success of business online ads are generally measured?? facebook make more advanced online business .. seller can make their business as a part time job as well as to reduce the cost without having to pay rent the site for sale. Besides the dealer can also save time without having any specific time for doing business. They just need to upload pictures of goods sold which is one way to promoted enclosed with your goods the right information on the goods. Customer only need to make a comment or private message for more information if interested. Based on the feedback received, the customer is satisfied and also received goods quickly and safely.

measuring the success of strategic initiatives...

EFFICIENCY & EFFECTIVENESS IT METRICS

definition of metrics... 
standard of measurement by efficiency, performance, progress or quality of a plan, process or product can be assessed.

efficiency IT metrics

• metrics is about measure a performance of IT system itself including speed, availability & etc.
• IT may be focused back-offline efficiency instead of the premium customer service the company wishes to provide.
• in example, how efficiency and the rate of speed customers from Apple Store can purchase or repair their gadgets until they got what they want.

effectiveness IT metrics

• measure the impact IT has on business process & activities including customer satisfaction, conversion rates ell increase.
• effectiveness measures how, well a company or business is reaching its objectives and constantly questions as to whether the right actions being taken to meet the given objectives.
• for example, in real life how would be how well customers are treated at the Apple Store when purchasing a new iPod or gadgets.

RESOURCE PLANNING INTRODUCTION (ERP)

A system that used to combine all the information or operations of a company into a single unit. The standard ERP system will utilize both computer hardware and software. Central database of ERP system will be use to store information from various modules. ERP was originally coined, it was used to describe systems that were designed to use multiple resources. It was commonly connected to the manufacturing industry. The goal of ERP is to unify the various functions of an institution. The software must be capable of giving functionally to one unit that would commonly have to use multiple systems. For example, a system that was able to combine two elements into a whole, such as a system that combined payroll with accounting, would be an ERP system.