Database Types and Characteristics

Question 1

Store data in tables with rows and columns, linked through keys. They support complex queries and are widely used due to their flexibility and scalability.

Answer 1

Relational Databases

Question 2

Organize data in a tree structure, where each record has a single parent, and access follows predictable paths. Suitable for applications with a fixed data hierarchy.

Answer 2

• Hierarchical Databases

Question 3

Store data as objects with associated methods. They support complex data types and are used in applications requiring multimedia or complex data representations.

Answer 3

• Object-Oriented Databases

Question 4

Use simple text files where each line represents a record. They are easy to implement but limited in scalability and flexibility.

Answer 4

• Flat-file Databases

Question 5

Designed for distributed, scalable, and flexible data storage, often used for big data and real-time web applications. Examples include document stores and key-value stores.

Answer 5

NoSQL Databases

Question 6

• Relational: Data in tables, supports joins.
• Hierarchical: Tree-like structure, predictable paths.
• Object-oriented: Data as objects with methods.
• Flat-file: Simple, one record per line.
• NoSQL: Flexible schemas, distributed.

Answer 6

Characteristics