database technology stack, including MS SQL Server, Azure etc.
Have you ever wondered:
- what technologies database server really includes?
- how many do I possess?
I could not find a really comprehensive diagram that shows the database technology stack, so I come up with my own version.
There might be issues here and there, like the category, the individual ones, but the beautity is you can modify it as you want.
You can have a graphical preview here (use mouse to move / zoom):
https://rawgit.com/unruledboy/DatabaseStack/master/ux/DatabaseStack.htm
-
RDBMS
-
MS SQL Server
- SQL OS
- Memory Management
- Buffer Pool
- Deadlock detection
- Exception handling
- Schedulers
- InterOp
- Storage Engine
- Transaction Services
- File Manager
- Data File
- Extents
- Pages
- Log File
- Write Ahead
- Relational Engine
- Query Processing
- Parser
- Optimizer
- SQL Manager
- Database Manager
- Query Executor
- Memory Management
- Thread and Task Management
- Buffer Management
- Distributed Query Processing
- Query Processing
- Communication
- Tabular Data Stream (TDS)
- Protocols
- TCP/IP
- Named pipes
- Shared memory
- Web Services
- Core Concepts
- Instance
- Default
- Named
- Alias
- Port
- Default: 1433
- Dynamic
- Transaction
- ACID
- Atomic
- Consistent
- Isolated
- Durable
- Checkpoint
- Isolation Levels
- Read uncommitted
- Read committed
- Repeatable read
- Snapshot
- Serializable
- ACID
- Concurrency
- Lock
- Optimistic
- Pessimistic
- Exclusive
- Shared
- Wait
- Latch
- Deadlock
- Kill
- sync/async
- Blocking
- Row versioning
- Lock
- Instance
- Core Objects
- Database
- Recovery Models
- Simple
- Full
- Bulk logged
- Compatibility Levels
- 130: SQL Server 2016
- 120: SQL Server 2014
- 110: SQL Server 2012
- 100: SQL Server 2008
- 90: SQL Server 2005
- 80: SQL Server 2000
- Recovery Models
- Table
- FileTable
- View
- Standard
- Indexed
- Partitioned
- Stored Procedure (SP)
- Function (FN)
- Table-valued Function
- Scalar-valued Function
- Data Type
- Types
- System Type
- User-defined Type (UDT)
- Conversion
- Precedence
- Synonym
- Precision/Scale/Length
- XML
- JSON
- Spatial (CLR)
- Types
- Index
- Index Type
- Clustered Index
- Non-clustered Index
- Index Setting
- Include
- Filter
- Index Management
- Rebuild
- Reorganise
- Disable
- Enable
- Drop
- Index Type
- Column
- columnstore
- NTFS FileStream
- Schema
- Trigger
- Table Trigger
- BEFORE
- AFTER
- INSTEADOF
- Table Trigger
- Constraint
- Key
- Default
- Synonym
- Cursor
- Collation
- Login
- User
- Rule
- Server role
- Endpoint
- Job
- Job Agent
- Job Activity Monitor
- Alert
- Operator
- SQL Job
- Step
- Schedule
- Notification
- .NET CLR
- Assembly
- Managed Code Types
- Function
- Stored Procedure
- Trigger
- UDF
- UDA
- UDT
- Security Levels
- Linked Server
- Service Broker
- Database
- Standard
- ANSI 92
- Languages
- Query Language
- T-SQL (Transact-SQL)
- MDX (MultiDimensional eXpressions)
- Data Manipulation Language (DML)
- CRUD
- Create(INSERT)
- Retrieve(SELECT)
- Update
- Delete
- MERGE
- TEXT
- UPDATETEXT
- WRITETEXT
- READTEXT
- BULK INSERT
- EXECUTE
- CRUD
- Data Definition Language (DDL)
- CREATE
- ALTER
- DROP
- TRUNCATE
- RESTORE
- RECONFIGURE
- Data Control Language (DCL)
- GRANT
- REVOKE
- Transaction Control Language (TCL)
- BEGIN TRANSACTION
- COMMIT
- ROLLBACK
- SAVE TRANSACTION
- Query Language
- System database
- master (dbs, login, configs)
- tempdb (temp tables / sps)
- msdb (jobs/alerts/backups)
- model (template for new db)
- resource (invisible, system objects)
- File
- primary (MDF)
- secondary (NDF)
- log (LDF)
- File/Filegroup
- Auto Grow
- Runtime
- Process
- Worker
- Connection
- Request
- Stall
- Stats
- Cache
- aging
- Catalog Views
- Dynamic Management Views (DMV)
- Execution count
- Execution io/cpu/perf
- Full Text Search (FTS)
- Integrated Full Text Search (iFTS)
- Replication
- Log Shipping
- Publish/Subscribe
- Transactional
- Merge
- Snapshot
- Mirroring
- AlwaysOn
- Clustering
- Core
- Shared Disk Array
- Quorum
- Failover
- Active/Active
- Active/Passive
- Core
- Snapshot
- Versions
- Express
- BI
- Web
- Standard
- Enterprise
- Datacenter
- Local DB
- Management
- SQL Server Management Studio (SSMS)
- SQL Server Command Line Util (sqlcmd)
- SQL Monitor ;-)
- Maintenance
- Maintenance Plan
- Logs
- Database Mail
- Database
- Backup/Restore
- Mode
- Full
- Differential
- Transaction log
- Mode
- Online/Offline
- Attach/Deattach
- Backup/Restore
- Import/Export
- Shrink
- DBCC
- Bulk Load
- Resource governor
- Facets
- Business Intelligence (BI)
- SQL Server Integration Service (SSIS)
- SQL Server Reporting Service (SSRS)
- SQL Server Analysis Service (SSAS)
- Troubleshoot
- Dedicated Administrator Connection (DAC) - "ADMIN:INSTANCE"
- SQL Server Profiler
- Activity Monitor
- Error
- Severity Levels
- Error Log
- sys.xp_readerrorlog
- Performance
- Seek
- Scan
- Fragmentation
- Partitioning
- Database Engine Tuning Advisor
- Services
- SQL Server
- SQL Server Browser
- SQL Server Agent
- SQL OS
-
Oracle
-
MySQL
-
PostgreSQL
-
Informix
-
-
Cloud
- Azure
- Database
- Redis Cache
- Storage
- Blobs
- Tables
- Queues
- Files and Disks
- StorSimple
- SQL Data Warehouse
- Azure
-
NoSQL
- Azure Document DB