Monday 3 February 2014

Chapter 7 : Storing Organizational Information

Database – Maintains informations about various types of object, events, people and places.

Database models :

Relational = Nowadays, new installations of database management systems are almost exclusively of the relational type. Organizations that
already have a major investment in hierarchical or network technology
may add to the existing model, but groups that have no need to maintain
compatibility with “legacy systems” nearly always choose the relational
model for their databases.

Hierarchical = Hierarchical databases are aptly named because they have
a simple hierarchical structure that allows fast data access. They suffer
from redundancy problems and a structural inflexibility that makes database modification difficult.

Network = Network databases have minimal redundancy but pay for that
advantage with structural complexity.

  
Entities – a person, place, thing, transaction or event about which information is stored             

Attributes – characteristics or properties of an entity class

Relational Database Advantages
·         Increased flexibility
·         Increased scalability and performance
·         Reduced information redundancy
·         Increased information integrity
·         Increased information security



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

Data-driven Web sites – an interactive Web site kept constantly updated and relevant to the needs of its customers through the use of database
Data-driven Web Sites Business Advantages
-          Develoment
-          Content management
-          Future expandability
-          Minimizing human error
-          Cutting production and update costs
-          More efficient

-          Improved stability

No comments:

Post a Comment