CHAPTER 7 : STORING ORGANIZATIONAL INFORMATION - DATABASES

 RELATIONAL DATABASE FUNDAMENTALS
·         Information is everywhere in an organization
·         Information is stored in databases
1.      Database – maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)

2.      Database models include:
·                 Hierarchical database model – information is organized into a tree-like structure (using parent/child relationships) in such a way that it cannot have too many relationships
·                 Network database model – a flexible way of representing objects and their relationships
·                 Relational database model – stores information in the form of logically related two-dimensional tables
Keys and   Relationships
·         Potential relational database of Coca-Cola

3.      Entities and Attributes
-          Entity – a person, place, thing, transaction, or event about which information is stored
-          The rows in each table contain the entities

-          Attributes (fields, columns) – characteristics or properties of an entity class
-          The columns in each table contain the attributes

4.      Keys and Relationships
Primary keys and foreign keys identify the various entity classes (tables) in the database
-          Primary key – a field (or group of fields) that uniquely identifies a given entity in a table
-          Foreign key – a primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables

RELATIONAL DATABASE ADVANTAGES

1.      Database advantages from a business perspective include
·         Increased flexibility
·         Increased scalability and performance
·         Reduced information redundancy
·         Increased information integrity (quality)
·         Increased information security
·         Increased Flexibility

A)             Increased Flexibility
A well-designed database should:
·         Handle changes quickly and easily
·         Provide users with different views
·         Have only one physical view
-  Physical view – deals with the physical storage of information on a storage device
·         Have multiple logical view
-  Logical view – focuses on how users logically access information

B)  Increased Scalability and Performance
·         A database must scale to meet increased demand,  while maintaining acceptable performance levels
·         Scalability – refers to how well a system can adapt to increased demands
·         Performance – measures how quickly a system performs a certain process or transaction

C)  Reduced Information Redundancy
·        Databases reduce information redundancy
-         Redundancy – the duplication of information or storing the same information in multiple places
·         Inconsistency is one of the primary problems with redundant information

D)  Increase Information Integrity (Quality)
·         Information integrity – measures the quality of information
·         Integrity constraint – rules that help ensure the quality of information
·         Relational integrity constraint
·         Business-critical integrity constraint

E)   Increased Information Security
·        Information is an organizational asset and must be protected
·         Databases offer several security features including:
-          Password – provides authentication of the user
-          Access level – determines who has access to the different types of information
-          Access control – determines types of user access, such as read-only access

DATABASE MANAGEMENT SYSTEMS
-         Database management systems (DBMS) – software through which users and application programs interact with a database


DATA-DRIVEN WEBSITES
-          Data-driven websites – an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database


DATA-DRIVEN WEBSITE BUSINESS ADVANTAGES

DATA-DRIVEN BUSINESS INTELLIGENCE
-          BI in a data-driven website

INTEGRATING INFORMATION AMONG MULTIPLE DATABASES
·         Integration – allows separate systems to communicate directly with each other
·         Forward integration – takes information entered into a given system and sends it automatically to all downstream systems and processes
·         Backward integration – takes information entered into a given system and sends it automatically to all upstream systems and processes

INTEGRATING INFORMATION AMONG MULTIPLE DATABASES
·         Forward integration and backward integration


INTEGRATING INFORMATION AMONG MULTIPLE DATABASES
·         Building a central repository specifically for integrated information

Comments

Post a Comment

Popular posts from this blog

CHAPTER 9 : ENABLING THE ORGANIZATION – DECISION MAKING

Image
DECISION MAKING ·          Reasons for the growth of decision-making information systems ·          ·          Model – a simplified representation or abstraction of reality ·          IT systems in an enterprise ·            TRANSACTION PROCESSING SYSTEM (TPS) ·          Moving up through the organizational pyramid users move from  requiring transactional information to analytical information ·          Transaction processing system - the basic business system that serves the operational level (analysts) in an organization ·          Online transaction processing (OLTP) – the capturing of transaction and event information using technology to (1) process the information according to defined business rules, (2) store the information, (3) update existing information to reflect the new information ·          Online analytical processing (OLAP) – the manipulation of information to create business intelligence in support of strategic decision making DE
Read more

CHAPTER 14 : CREATING COLLABORATION PARTNERSHIP

Image
TEAMS, PARTNERSHIPS AND ALLIANCES ·          Organizations create and use teams, partnerships and alliances to; -           Undertake new initiatives -           Address both minor and major problems -           Capitalize on significant opportunities ·          Organizations create teams, partnerships and alliances both internally with employees and externally with other organizations ·          Collaboration system – supports the work of teams by facilitating the sharing and flow of information Information partnerships with other organizations ·          Organizations from alliance and partnerships with other organizations based on their core competency -           Core competency – An organization’s key strength, a business function that it does better than any of its competitors -           Core competency strategy – Organization chooses to focus specifically on its core competency and forms partnerships with other organizations to handle no
Read more

CHAPTER 6 : VALUING ORGANIZATION INFORMATION

Image
ORGANIZATIONAL INFORMATION -           Information is everywhere in an organization. -           Employees must be able to obtain and analyse the many different levels, formats, and granularities of organizational information to make decisions. -           An organization is performing by successfully collecting, compiling, sorting, and    analyzing  information. -           Levels, formats, and granularities of organizational information THE VALUE OF TRANSACTIONAL AND ANALYTICAL INFORMATION -           THE VALUE OF TIMELY INFORMATION -           Timeliness is an aspect of information that depends on the situation  : ·          Real-time information Immediate, up-to-date information ·          Real-time system Provides real-time information in response to query request THE VALUE OF QUALITY INFORMATION -           Characteristics of high-quality information include: ·          Accuracy ·          Completeness ·          Consisten
Read more