There are four types of database:
- Text database
- Desktop database
- Relational database
- No SQL and object oriented database
Text database: A text database is a system that maintains a (usually large) text collection and provides fast and accurate access to it. These two goals are relatively orthogonal, and both are critical to profit from the text collection. Text database is used for creation of complete textbooks, dissertations, journals, magazines, newspapers, documents etc. Text databases can also be used in different fields such as Marketing, National security and Corporate security, legal purpose, for patent work, PR (Public Relation) etc.
Nowadays people can easily search text databases because it is being created in the electronic medium, whereas in traditional text databases people used to first search a topic to index its page number and later they get what they were looking for. But in morden form it has become easier for people to search it within seconds, So it becomes easier for a person to create text data and search it wherever or whenever he is searching for.
Desktop database: A desktop database is a database system that is made to run on a single computer or PC. Here data software is replaced by hardware and networking setup. This data can be in any form but can be used by a single system not more than that. This data has one way transparency and it is a totally file base database system. Desktop database systems are mainly used by web developers so that their data does not get leaked which they have prepared.
Desktop databases are mainly used by smaller businesses which store less data in the form of doc,sheets or related to that which they don't want to share with others. It can also be used for personal usage such as for storing passwords, mobile numbers, etc.
Relational database: A relational database system is mainly designed for relational data, it stores data in structured format using rows and columns. Now what is relational data? A data which is inter connected or related to another data is called relational data.for such kind of data there are few database software which are commonly known as Relational database management software or Relational database system. Such software can store large numbers of data and are used by MNC, Banks, Schools, Colleges etc. A relational database helps you to easily find specific informationation and it helps you to generate a final report too.
In relational databases you get the following features.
- Data safety
- Concurrent access
- Data integrity
- Final Reporting
Hence RDBMS (Relational Database Management System) with such features is trusted by most of the people dealing with larger data, which makes their work easier and simpler. RDBMS is used by Banks, MNC, Schools and Colleges etc.
No SQL and object oriented database: An object database is a database management system in which information is represented in the form of objects as used in object-oriented programming.It has been used since the early 1980s. Features including objects, complex objects, classes, abstraction, inheritance, encapsulation etc in an object oriented database. It provides a mechanism for storage and retrieval of data. NoSQL is doable than RDBMS, but slower. An object-oriented database is organized around objects rather than actions, and data rather than logic. For example, a multimedia record in a relational database can be a definable data object, as opposed to an alphanumeric value.
Some object-oriented databases are designed to work well with Object Oriented Programming language such as Delphi, Ruby, Java, Java Script, C# etc. It is widely used in the sector of telecommunication , For companies with background of programming and developing