Overview of SQL Server: Hanoi University of Technology
Overview of SQL Server: Hanoi University of Technology
Overview of SQL Server: Hanoi University of Technology
Vu Tuyet Trinh
trinhvt-fit@mail.hut.edu.vn
Hanoi University of Technology
1
P2-3
Introduction to SQL Server
Results
Results
Query OLTP
Query
OLAP
Microsoft
SQL Server Goal
Microsoft
Outline
Microsoft
Relational Data Model
3936 G le n Bu n d o o ra 1108 21
Attributes 8507 No rm a n Bu n d o o ra 1108 23
8507 29
Su b je c t
No Na m e De p t
Relationship 21 Syste m s C SC E
23 Da ta b a se C SC E
29 VB C SC E
18 Alg e b ra Ma th s
Microsoft
Basic Concepts of a Relational Database
Entities
Tables
Attributes
Fields
Relations
Microsoft
Student
Basic concepts Id Name Suburb
1108 Robert Kew
• Database ~ a collection of 3936 Glen Bundoora
tables.
8507 Norman Bundoora
• Table ~ information about a
single entity 8452 Mary Balwyn
Solution
Normalization
Reducing redundancies and improving data modification
performance
Renormalizations is often done to enhance reporting performance
(at the expense of disk space and redundancy)
Referential Integrity
Maintains the logical relationships between database objects
Microsoft
Example
Microsoft
Outline
Microsoft
Data Access Architectures
Microsoft
Client/Server Architecture
Client SQL Server
Results OLTP
Results
OLAP
Query
Query
Client Application Relational Database
Management System
Microsoft
N-tier Architecture
Microsoft
Service-Oriented Architecture
Microsoft
P18
SQL Server Services
Data Management
MSSQLServer Transaction and Query
Service Processing
Data Integrity
Jobs
SQLServerAgent Alerts
Service Operators
Distributed
Transaction
Microsoft Distributed Management
Transaction Coordinator
Server
Full-Text Catalogs
Microsoft Search Full-Text Indexes
Microsoft
Microsoft
Transact-SQL (T-SQL)
Microsoft
CLR Integration
Microsoft
SQL Server Editions
Standard Edition
Workgroup Edition
Microsoft
Evolution of SQL Server
SQL Server SQL Server SQL Server SQL Server SQL Server
6.5 7.0 2000 2005 2008
Microsoft
Microsoft Data Platform Vision
Microsoft
Microsoft
Summary
Microsoft 24
Microsoft