I Tech Group

Sunday, April 3, 2011

Inverted Database & Relational Database

Inverted Database
Suited for direct marketing applications because it has speed and flexibility to respond to unanticipated questions

Easy to add new elements to an inverted database as and when updated information is acquired

Relational Database

A relational database matches data by using common characteristics found within the data set
Examples are Databases like Oracle, SQL Server, and Microsoft Access
E.g., A data set containing all the real-estate transactions in a town can be grouped by the year the transaction occurred; or it can be grouped by the sale price of the transaction; or it can be grouped by the buyer's last name; etc
Flexible because users can create queries to extract information from these tables and recombine it

 

No comments:

Post a Comment