Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

6. Databases

This class was created by Brainscape user Alexey Filatov. Visit their profile to learn more about the creator.

By: Alexey Filatov
Start Studying

Decks in this class (17)

1. SQL
Tables rows columns synonyms,
What is the default order of the ...,
Null values general meaning
9  cards
2. Disk and Files
How databases use memory and disk...,
Basic units of data for databases...,
How relational databases are repr...
22  cards
3. B+ Trees
What is an index,
3 b trees properties,
Which nodes of b trees contain re...
10  cards
4. Buffer Management
Buffer manager main responsibility,
When a buffer manager should comm...,
What are frames how they are tracked
10  cards
5. Relational Algebra
Why do we need relational algebra...,
What inputs and outputs relational,
Relational algebra operators
13  cards
6. Sorting
Why databases need special sortin...,
What do we measure when analyzing...,
Two way external merge sort expla...
7  cards
7. Hashing
Why do we need hashing in additio...,
Why do we need special hashing al...,
External hashing algorithm describe
3  cards
8. Iterators and Joins
Describe a join in terms of tuple...,
Simple nested loop join describe,
Page nested loop join describe an...
8  cards
9. Query Optimization
The main goal of query optimization,
What is a query plan which langua...,
Operator s selectivity def
16  cards
10. Transactions and Concurrency I
3 main types of concurrency issue...,
Transaction def,
Acid properties of transactions
11  cards
11. Transactions and Concurrency II
2 main kinds of lock in dbms,
Two phase locking 2pl describe th...,
Main problem of two phase locking
13  cards
12. DB Design
2 main components of e r diagrams,
Entities in e r models,
Relationships in e r models defho...
15  cards
13. Recovery
Force no force policies trade off,
Steal no steal policies trade off...,
What is a database log
21  cards
14. Parallel Query Processing
What is parallel query processing,
What is shared memory architecture,
What is a shared disk architecture
18  cards
15. Distributed Transactions
How distributed locking is common...,
What is consensus in distributed ...,
Two phase commit 2 main types of ...
21  cards
16. NoSQL
2 main classes of db workloads,
What is etl,
The main goal of nosql databases ...
7  cards
17. MapReduce and Spark
Mapreduce where the initial data ...,
Mapreduce input output what shoul...,
Mapreduce describe the map phase
9  cards

More about
6. Databases

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Alexey Filatov's 6. Databases flashcards now!

How studying works.

Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.

Learn more about spaced repetition

Add your own flashcards.

Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!

What's Brainscape anyway?

Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.

We use an adaptive study algorithm that is proven to help you learn faster and remember longer....

Looking for something else?

DATABASE SYSTEMS
  • 14 decks
  • 231 flashcards
  • 4 learners
Decks: Introduction To Databases, Introduction To Databases Ansi Sparc, Introduction To The Relational Model, And more!
ICSM Year 6
  • 20 decks
  • 2220 flashcards
  • 99 learners
Decks: Emergency Care, Medicine Cardiology, Medicine Dermatology, And more!
Find Flashcards
Make Flashcards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions