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

Decks in this class (17)

1. SQL
Tables rows columns synonyms 1,
What is the default order of the ...,
Null values a general meaning 3
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 1,
3 b trees properties 2,
Which nodes of b trees contain re...
10  cards
4. Buffer Management
Buffer manager main responsibility 1,
When the buffer manager should co...,
What are frames how they are trac...
10  cards
5. Relational Algebra
Why do we need relational algebra...,
What inputs and outputs have oper...,
What operators relational algebra...
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 descri...
3  cards
8. Iterators and Joins
Describe a join in terms of tuple...,
Simple nested loop join describe 2,
Page nested loop join describe an...
8  cards
9. Query Optimization
The main goal of query optimizati...,
What is a query plan which langua...,
Operator s selectivity def 3
16  cards
10. Transactions and Concurrency I
3 main types of concurrency issue...,
Transaction def 2,
Acid properties of transactions 3
11  cards
11. Transactions and Concurrency II
2 main kinds of locks in dbms 1,
Two phase locking 2pl describe th...,
The main problem of two phase loc...
13  cards
12. DB Design
2 main components of e r models 1,
Entities in e r models def 2,
Relationships in e r models def 3
15  cards
13. Recovery
Force no force policies trade off...,
Steal no steal policies trade off...,
What is a database log 3
21  cards
14. Parallel Query Processing
What is parallel query processing 1,
What is shared memory architecture 2,
What is a shared disk architecture 3
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 1,
What is etl 2,
The main goal of nosql databases ...
7  cards
17. MapReduce and Spark
Mapreduce and spark where the ini...,
Mapreduce input output what shoul...,
Mapreduce describe the map phase 3
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.

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?

6. Databases
  • 11 decks
  • 1138 flashcards
  • 511 learners
Decks: Cis275 Chapter 1 Introduction To Databas, Cis275 Chapter 2 Relational Databases, Cis275 Chapter 3 Database Design, And more!
Block 6
  • 32 decks
  • 1407 flashcards
  • 3 learners
Decks: Phys Cardiac Muscle, Ocular Cornea 1 And 2, Optics Visual Acuity, And more!
Make Flashcards