Design And No SQL

Question 1

Describe the “Logical” design.

Describe the “physical” design.

Answer 1

Logical design- data and info is collected as to what the databases’ main aims are, and how each table should link in order to create an efficient solution. These plans are then turned into diagrams such as an ER diagram.

Physical design- this is where the plans and data are DEFINED. Data types are decided, columns are decided, constraints, keys, naming of columns and tables etc. Essentially this is where everything planned in the logical design is DEFINED.

Question 2

Name the different types of NO SQL databases.

Answer 2

Key Value stores- reduce relational structures.

Column stores- rearrange data to store column values.

Document stores- data stored as nested objects.

Graph stores- data stored as connected nodes.

Question 3

What are the advantages to NOSQL?

Answer 3

• Flexible data structures.
• More robust server.
• Scalability.
• Good interface.

Question 4

What are the disadvantages to NO SQL?

Answer 4

• Inconsistent.

- Hasty development. (Like Chinese products.)