chapter 8: ACCESSING ORGANIZATIONAL INFORMATION-DATA WAREHOUSE

LEARNING OUTCOMES

1)DESCRIBE THE ROLES AND PURPOSES OF DATA WAREHOUSE AND DATA MARTS IN AN ORGANIZATIONAL.

-DATA WAREHOUSE IS A LOGICAL COLLECTION OF INFORMATION TO GATHERED FROM MANY DIFFERENT OPERATIONAL DATABASES THAT SUPPORTS BUSINESS ANALYSIS ACTIVITIES AND DECISION MAKING TASKS.
THE PRIMARY PURPOSE OF DATA WAREHOUSE IS TO AGGREAGATE INFORMATION THROUGHOUT INTO A SINGLE REPOSITORY FOR DECISION-MAKING PURPOSES.
-DATA MARTS CONTAINS A SUBSET OF DATA WAREHOUSE INFORMATION.

2)COMPARE THE MULTIMEDIMENSIONAL NATURE OF DATA WAREHOUSE (AND DATA MARTS) WITH THE TWO-DIMENSIONAL NATURE OF DATABASES.

-Databases contain information in a series of two-dimensional tables, which means that you can only ever view two dimensions of information at one time. In a data warehouse and data mart, information is multidimensional, it contains layers of columns and rows. Each layer in a data warehouse or data mart represents information according to an additional dimension. Dimensions could include such things as products, promotions, stores, category, region, stock price, date, time, and even the weather.The ability to look at information from different dimensions can add tremendous business insight.

3)IDENTIFY THE IMPORTANCE OF ENSURING THE CLEANLINESS OF INFORMATION THROUGHOUT AN ORGANIZATION.

-An organization must maintain high-quality information in the data warehouse.Information cleansing and scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.Without high-quality information the organization will be unable to make good business decisions.
4)EXPLAIN THE REALTIONSHIP BETWEEN BUSINESS INTELLIGENCE AND A DATA WAREHOUSE.

-DATA WAREHOUSE IS THE PRIMARY PURPOSE OF DATA WAREHOUSE IS TO AGGREAGATE INFORMATION THROUGHOUT INTO A SINGLE REPOSITORY FOR DECISION-MAKING PURPOSES.
BUSINESS INTELLIGENCE IS A IONFORMATION THAT PEOPLE USE TO SUPPORT THEIR DECISION-MAKING EFFORTS.

cHAPTER 7 : STORING ORGANIZATIONAL INFORMATION-DATABASES

LEARNING OUTCOMES

1)Describe the two primary methods for integrating information across multiple databases?

-Have two primary methods firstly, backward integration. It takes information entered into a given system and sends it automatically to all upstream systems and processes. Secondly, forward integration. It takes information entered into a given system and sends it automatically to all downstream systems and process.

2)Describe the benefits of a data-driven Web site?

-Data-driven website have more advantages. Data-driven give more advantages from development,content management,future expandability,minimizing human error,cutting production and update costs,more efficent and lastly improved stability.

3)Define the fundamental concepts of the relational database model?
 

-The relational database model stores information in the form of logically related two-dimensional tables.Entities, attributes, primary keys, and foreign keys are all fundamental concepts included in the relational database model.

 

 4)Evaluate the advantages of the relational database model?

 

-The advantages of the relational database model including increased flexibility,increased scability and performance,reduced information redundancy,increased information integrity (quality) and lastly increased information security.

 

5)Compare operational integrity constraints and business-critical integrity constraints?

-Operational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Business-critical integrity constraints are rules that enforce business rules vital to an organization’s success and often require more insight and knowledge than operational integrity constraints

 

 

 

CHAPTER 5 ORGANIZATIONAL STRUCTURES THAT SUPPORT STRATEGIC INITIATIVES

ORGANIZATIONAL STRUCTURES

-Employees across the organization must work closely together to develop strategic initiatives that create competitive advantages. Understanding the basic structure of a typical IT department including titles, roles, and responsibilities will help an organization build a cohesive enterprisewide team.

FIVE DIFFERENT ITEM

CHIEF INFORMATION OFFICER (CIO):
-Responsible for overseeing all uses of information technology.
-Responsible to ensuring the strategic alignment of IT with business goals and objectives.
-CIO often reports directly to the CEO.
-CIO must possess a solid and detailed understanding of every aspect of an organization.
-Broad functions of CIO include manager, leader, and communicator.

 CHIEF TECHNOLOGY OFFICER (CTO):
-Responsible for ensuring the throughoutput, speed, accuracy, availability, and reliability of an organization's information technology.
-Similar with CIO, its because CIO take on the additional responsibility for effectiveness of ensuring that aligned with the organization's strategic initiatives.
-CTO responsibility for ensuring the efficiency of IT systems throughout the organization.
-CTO possess well-rounded knowledge of all aspects of IT systems through networked computers.

 CHIEF SECURITY OFFICER (CSO):
-Responsible for ensuring the security of IT systems and developing strategies and IT safeguard against attacks from hackers and viruses.
-Role of a CSO has been elevated in recent years because of the number of attacks from hackers and viruses.
-CSO possess detailed knowledge of networks and telecommunications because hackers and viruses usually find their way into IT systems through networked computers.

 CHIEF PRIVACY OFFICER (CPO):
-Responsible for ensuring the ethical and legal use of information within an organization.
-CPO are the newest senior executive position in IT.
-Many CPO are lawyer training, enabling them to understand the often complex legal issues surrounding the use of information.

 CHIEF KNOWLEDGE OFFICER (CKO):
-Responsible for collecting, maintaining, and distributing the organization's knowledge.
-CKO design programs systems that make easy people to reuse knowledge.
-CKO system create repositories of organizational documents, methodologies, tools, and practices, and they establish methods for filtering the information.

chapter 4 meaSuring the success oF strateGies initiAtives

IT METRICS


-EFFICIENCY IT METRICS FOCUS ON TECHNOLOGY ITSELF.
-EFFICIENCY METRICS ARE IMPORTANT TO MONITOR, THE DO NOT ALWAYS GUARANTEE EFFECTIVENESS.

THE INTERRELATIONSHIPS OF EFFICIENCY IT METRICS

6 COMMON TYPES OF EFFICIENCY IT METRICS

THROUGHPUT: AMOUNT OF INFO THAT CAN TRAVEL THRU A SYSTEM AT ANY POINT IN TIME.

SPEED: THE AMOUNT OF TIME A SYSTEM TAKES TO PERFORM A TRANSACTION.

AVAILABILITY: THE NUMBER OF HOURS A SYSTEM IS AVAILABLE FOR USE BY CUSTOMER AND EMPLOYEES.

ACCURARY: THE EXTENT TO WHICH A SYSTEM GENERATES THE CORRECT RESULTS WHEN EXUCUTING THE SAME TRANSACTION NUMEROUS TIMES.

WEB TRAFFIC: INCLUDING A HOST OF BENCHMARKS,EXAMPLE: NO OF PAGES VIEW NO OF UNIQUE VISITORS AND AVERAGE SPEND ON VIEWING THE WEB PAGE.

RESPONSE TIME: THE TIME IT TAKES TO RESPOND TO USER INTERACTIONS SUCH AS MOUSE CLICK.

COMMENT, IF I SELLER IN A FACEBOOK AND HOW MY EFFICIENCY & EFFECTIVENESS TO SELL MY PRODUCT.

- I'M SUCH AS SELLER OF CLOTHES IN FACEBOOK, I WILL MAKESURE MY EFFICIENCY TO SELL MY CLOTHES HAVE A GOOD STRATEGIES. MY EFFICIENCY IS A TO MANAGE MY STRATEGIES TO TARGET MY GOAL AND MY CUSTOMER SATISFACTION. I SHOULD TO SELL THE GOOD CLOTHES, SELL THE BEAUTIFUL CLOTHES, SUITABLE CLOTHES AND I SHOULD TO SELL CLOTHES WITH VARIOUS SIZE AND I MUST DO SOMETHING GOOD TO MY CUSTOMER TO ATTRACT MY CUSTOMER BUY MY CLOTHES SUCH AS GIVE DISCOUNT OR BUY ONE FREE ONE. BESIDES THAT, I MUST HAVE A GOOD COOPERATION WITH MY CUSTOMER FOR MY CUSTOMER TO KNOW MORE DETAIL ABOUT MY SALES. I'M SUCH AS SELLER SHOULD GIVE MORE DETAIL ABOUT INFORMATION TO MY CUSTOMER. FROM FACEBOOK, MY CUSTOMER CAN LOOK ALL CLOTHES, ALL TYPES ALL CLOTHES CUSTOMER CAN GET AND WANT AND THAN CAN GET MORE DETAIL ABOUT THE CLOTHES. FACEBOOK CAN HELP ME EASIER TO COMMUNICATE WITH MY CUSTOMER AND EASIER TO CUSTOMER GET INFORMATION.

-FROM THIS MY EFFECTIVENESS, I GET MORE CUSTOMERS AND GET GOOD DEMAND IN MY SALES. NOT CUSTOMER IN MALAYSIA BUT HAVE MORE CUSTOMER AT OUTSIDE. MORE CUSTOMER GET SATISFACTION FROM MY SERVICE AND THERE ARE LIKE TO BUY CLOTHES WITH ME AND THERE ARE GIVE GOOD FEEDBACK FOR MY BUSINESS. FROM THIS I CAN TARGET MY GOAL AND I WILL BE MORE SUCCESS IN MY BUSINESS ONLINE THROUGH FACEOOK.