ALL ABOUT TECHNOLOGY AND INFORMATION SYSTEM

So, this week, I would like to share the information about the DATABASE...
First.. Do u ever heard about the database??? What?? No..!!!

Database is design to store, managing and retrieving the data. Other than that, database also reduce data redundancy, enhance data integrity, support data sharing and provide security.


Database tables consist of column and rows, where each column contains a different type of attribute and each row corresponds to a single record.


If database have column and row, should we use a spreadsheet to replace the database???
NO... u can't...!!!
It is because spreadsheet can't do the action same like databases.
eg : ~ retrieve all records that match certain criteria
      ~ perform complex aggregate calculations
      ~ cross reference records in different tables
      ~ update records in bulk

So, can u see the different now???


software : it is called as database management system
it can be dived into 2 categories
~ desktop database
   - single-user applications and reside on standard personal computers
   -  FoxPro, FileMaker Pro, Paradox, Microsoft Acess and Lotus Approach
   - advantages : inexpensive, user-friendly, offer web solutions  

~ server database
   - ensure the reliability and consistency of data and are geared toward multi-user 
     applications.
   - design to run on high-performance serves and carry a corresponding higher 
     price tag.
   - example : Oracle, IBM DB2, Microsoft SQL
   - advantages : powerful performance, scalability and flexibility


TYPES OF DATABASE

Did u know that database have 5 types??? Its consist of

1. Individual
    - also known as microcomputer database
    - can be stored either on the user's hard disk or on LAN file server

2. Company or shared
    - stored on a mainframe and managed by a database admin.
    - 2 types : common operational database and common user database.

3. Distributed
    - stored in several location
    - its provide the link between users and distant data

4. Propriety
    - enormous database that an organization develops to cover particular subject.
    - offers access to this database to the public or selected outside individuals for fee.
    - sometimes know as information utilities or data banks.

5. Web Database
    - used by web sites collecting data and search sites providing data


~ Business :
   like order processing, payroll, shipping, inventory

~ Educational Institutions : 
   keep the students grades, transfer and transcripts

~ Household and Family Management : 
   Bills and other expenses, address of friend and relative, family birthdays

~ Non-Profit Organizations : 
   track of information like donations, volunteer and hours
   served in the community 

Check this video for more information about database


U also can go to this link for further information...

http://www.webopedia.com/TERM/D/database.html
http://www.ehow.com/facts_5144435_uses-database.html
Its enough for today... and see u later ^..^  annyoong..!!!