15 Questions
What is the acronym for the properties that relational databases must adhere to?
ACID
True or false: NewSQL databases can support distributed and multi-model features.
True
What is the acronym for the properties that relational databases adhere to?
ACID
What is the main disadvantage of using mainframe databases?
They are expensive
What type of databases are more affordable but may not have the best scale-up performance?
Hyper-converged Database appliances
True or false: Database optimization does not include hardware aspects.
False
What type of databases are Google Spanner and NewSQL?
Distributed and multi-model
What technology is used for scale-out, but requires many code changes to the application?
Middleware-based sharding
True or false: An in-memory cache can be used to improve database performance.
True
What is one way to improve database performance?
Using an in-memory cache as a data layer between applications and databases
True or false: Relational databases do not adhere to the ACID properties.
False
What is one way to improve database performance?
Use of an in-memory cache
What can the Intel 3rd Xeon scalable platform processor provide for database performance?
Both A and B
What processor is a good choice for database performance?
Intel 3rd Xeon scalable platform processor
True or false: Mainframe databases are more affordable than Hyper-converged Database appliances.
False
Study Notes
- Relational databases are based on the relational model, strictly adhering to a-to-mi-city, consistency, isolation, and durability properties - which we call ACID.
- Mainframe databases are outdated and expensive, while RISC+ DiskArrays and Hyper-converged Database appliances are more affordable but compromise on scale-up performance.
- Middleware-based sharding is used for scale-out, but requires many code changes to the application.
- NewSQL databases like Google Spanner were invented to support distributed and multi-model features.
- In-Memory Data Grid is the future direction of Databases, and memory resources can be more easily pooled, accelerating the design and deployment of IMDG in the cloud.
- Database optimization is an important part of keeping a database running at its best.
- There are many aspects to database optimization, including architecture, hardware, application, and database engine aspects.
- One way to improve database performance is by using an in-memory cache as a data layer between applications and databases.
- Separation of storage and compute can also help improve database performance.
- The Intel 3rd Xeon scalable platform processor is a good choice for database performance because it has more cores and higher frequency.
Test your knowledge about database performance, optimization techniques, and modern database solutions including ACID properties, sharding, NewSQL databases, in-memory data grid, and hardware choices for database performance.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free