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. 

Say 'Charge It' with Your Cell Phone

Your cell phone can purchase item?? but how???..... yess!! u could purchase item by using your cell phone by dialing a telephone number on the dispensing machine and have the charge for the item and it will show up on your cell phone bill. this working prototypes are currently in use in South Korea, Japan and Europe. wish it will have in Malaysia too.. =)) 

do u think this technology as a potential threat to additional telephone companies?? i think it yess!! so traditional telephone companies should adopt to prepare for this technology. this company must overcome this before the new technology affecting in their production. they must be innovative and creative to create new product that more useful in their company. they should create more differentiation with competitive advantage by distinguishing their products on one or more features important to their customers. make consumer desire to use and loyalty with their product. give good and service satisfy need of customer through sustainable competitive advantage. competitors with higher costs cannot afford to compete with the low-cost leader on price. this allows companies to low their price and focus on value that generated a quite higher price. benefit differentiation is need a producer achieve their target to give good and services for the consumer. 

By using Porter's Five Forces, there is barriers to entry for this new technology in cell phone. among the barrier that the company must facing is threat of new entrants which will be low when there are significant entry barriers to entering the market. Company can expect obstacles that will occur and identify the causes. Between the barriers to technology companies have been long in the market are as  sceptical consumer of their products and have an impact on production.sales companies do not reach the target due to the lack of consumer confidence in the new technology market. Sometimes the user is not too fast to adopt new technology. Among those who consider the new technologies that are marketed just copy and paste or copyright from existing technologies in the market. threat of substitutes  product and services, ideally an organization would like to be on a market which there are a few substitutes of their product or services. Obstacles to the tackle is coming to a copyright company and the products will be competitive. Barriers will be high because companies will maintain the same product, by the problem for companies to maintain their company sales. When Threat of Substitute products and services been high, power of buyers will be increase because there are many options for consumers to buy.

To this new technology, the company chooses differentiation of the porter's 3 Generic Strategies, create a low cost producer in the industry allows the company to lower prices to customers. Unique features or benefits may justify  price differences for example i-care by proton. the company has made a difference in this technology which has competitive advantage to the company. for this strategy, unique features or benefits of the technology can differentiate prices and more demand from consumers. This technology has many application that can be used by the users and no longer in other technology is available. As mentioned in the article, this technology can buy anything using no.phone and must carry their mobile phone. That is a differentiation strategies used by other companies.

value chain which means value-adding activities that convert inputs into outputs.
help create competitive advantage-for the value chain of this business, the profit they get from the payment will go to company or an organizations.As their profit, they will create a new design and pay the supplier that supply the materials.With this activities, company can develop their business same level in international market.




types of regulatory issues that might occur during the transaction from customer

-transaction like buying merchandise, paying the bill or any else will lead to fraud. Sometimes the products is not the same as sample or picture that had been showed. Customer unsatisfied with the merchandise. There are also can happen when the company have taken the money but the products are not delivered to customer. The fraud also can be occur from customer as they can lie about their information such as they use others phones. The breakdown of system also can be an issues that occur and can make the transaction cancelled automatically