Title: Theory / Important / CS / Algo / Database / Database System Concept 6 - McGraw Hill+27{ / 5 Architecture
Tags: récupéré hasSeenConjDef
On every note of this deck, unless a note says otherwise:
Chapter: 17

Name: Centralized database system
Definition: running on a single computer system
Page: 769
Section: 1
Definition2: not interaction with other computer system (it can takes query from/answer to them)
Example: single-user database systems running on personal computers
Conjdef: A db systen
Example2: high-performance database systems running on high-end server systems

Name: Client-server system
Definition: A system where a central database runs, and is used by many users
Page: 771
Section: 1.2

Name: A core
Definition: Something which can execute instruction stream
Page: 770
Section: 1.1

Name: A single-user system
Definition: A desktop unit used by a single person
Page: 770
Section: 1.1

Name: A multi-user system
Definition: A desktop unit used by multiple person simultaneously
Page: 770
Section: 1.1

Name: Coarse-granularity parallelism
Definition: Parallelism where each query is run on a single core.
Page: 771
Section: 1.1

Name: Fine-granularity parallelism
Definition: Parallelism applied on task level. Each query is divided to be run on multiple core
Page: 771
Section: 1.1
Intuition: Using a few processors with shared memories

Name: A server system
Definition: A system that satisfy requests generated by client systems.
Page: 771
Section: 1.2

Name: A client system
Definition: A system that send request to other system
Page: 771
Section: 1.2

Name: Transaction-server system
Definition: A system providing an interface to which clients can send requests to perform an action, in response to which they execute the action and send back results to the client.
Page: 773
Section: 000
Name2: Query-server system

Name: Data-server system
Definition: A system which allow clients to interact with the servers by making requests to read or update data, in units such as files or pages.
Page: 773
Section: 000
Example: File server

Name: A server process
Definition: Processes that receive user queries (transactions), execute them, and send the results back.
Page: 773
Section: 2.1

Name: A thread
Definition: Something similar to a process, where many may have the same virtual-memory space
Page: 773
Section: 2.1

Name: Lock manager process
Definition: lock grant, release
Page: 773
Section: 2.1
Definition2: deadlock detection
Conjdef: process implements lock manager functionality

Name: Database writer process
Definition: one or more processes that output modified buffer blocks back to disk on a continuous basis.
Page: 773
Section: 2.1

Name: Log writer process
Definition: process outputs log records from the log record buffer to stable storage
Page: 773
Section: 2.1

Name: Checkpoint process
Definition: A process processing periodic checkpoints
Page: 774
Section: 2.1

Name: Process monitor process:
Definition: This process monitors other processes, and if any of them fails, it takes recovery actions for the process, such as aborting any transaction being executed by the failed process, and then restarting the process.
Page: 774
Section: 2.1

Name: Mutual exclusion
Definition: The guarantee that while some data are written, they are not read
Page: 775
Section: 2.1

Name: Atomic instruction
Definition: An instruction supported directly by the computer hardware
Page: 775
Section: 2.1

Name: Page shipping
Definition: When the unit of communication for data is a page
Page: 776
Section: 2.1
Context: Data server

Name: Item shipping
Definition: When the unit of communication for data is a tuple/an object
Page: 776
Section: 2.1
Context: Data server

Name: Prefetching
Definition: Sending items not requested, but which may be requested soon
Page: 776
Section: 2.1
Context: Data server

Name: De-escalation
Definition: The fact that the server requests to the client to have the lock back on prefetched data.
Page: 776
Section: 2.1
Context: Data server

Name: Adaptive lock granularity
Definition: Dealing with locks which concerns things not explicitly requested by the client
Page: 776
Section: 2.1
Context: Data server

Name: Data caching
Definition: Dealing with the cache
Page: 776
Section: 2.1
Context: Data server

Name: Cache
Definition: A place where client save data fetched, to avoid to request it again from the server
Page: 776
Section: 2.1
Context: Data server

Name: Cache coherency
Definition: Whether the cache contains data still up to date
Page: 776
Section: 2.1
Context: Data server

Name: Lock caching
Definition: When client also cache locks
Page: 776
Section: 2.1
Context: Data server

Name: Lock call back
Definition: Asking client to return the locks on some data
Page: 776
Section: 2.1
Context: Data server

Name: Cloud computing
Definition: service provider runs its own software, but runs it on computers provided by another company.
Page: 777
Section: 2.1

Name: Virtual machine
Definition: A machine simulated by another machine
Page: 777
Section: 2.1
Extra: Emulated?