Friday, 26 February 2016

Chapter 7 : Storing Organizational Information - Databases



 D a t a b a s e s
 



Database models
 


Hierarchical structure


 
Network structure
 

 
Relational structure
 

Entities and Attributes  

              

Keys and relationships
  

      
Relational database advantages
-increase flexibility
-increase scalability and performance
-reduced information redundancy
-Increase information quality
-Increase information security


Database Management System (DBMS)
A software through which users and application programs interact with a database
 
 

Data-driven website
An interactive website kept constantly updated and relevant to the needs of its customer through the use of database

                             



Data-Driven web site business advantage
-     development : allow owner make change anytime
-     content management : requires a programmer to make updates
-     future expand-ability : enable the site to grow faster than would be possible with a static site
-     minimizing human error : ensure the required information is filled out correctly
-     more efficient
-     improved stability
-     cutting production and update cost



data-driven business intelligence

      
Integrating information among multiple databases
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
 

 building a central repository specifically for integrated information 

 

without integration , an organization will :

# spend considerable time entering the same info in multiple system
# suffer from low quality and inconsistency typically embedded in redundant info





















No comments:

Post a Comment