Overview of SQL Server
Vu Tuyet Trinh
trinhvt-fit@[Link]
Hanoi University of Technology
1
P2-3
Introduction to SQL Server
Client SQL Server
Results
Results
Query OLTP
Query
OLAP
Client Application Relational Database
Management System
Microsoft
SQL Server Goal
Microsoft
Outline
Introduction to SQL Server
Relational Data Model
Exploring SQL Server Architecture
Data Access Architectures
SQL Server Services & Tools
Programming Languages
Transact-SQL (T-SQL)
CLR
SQL Server Editions
Evolution of SQL Server
Summary
Microsoft
Relational Data Model
Entities Relational Database
Stu d e n t
Id Na m e Suburb Ta ke s
1108 Ro b e rt Ke w SID SNO
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
8452 Ma ry Ba lwyn 8507 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
•Primary key ~ (set of) Takes
column(s) that uniquely SID SNO
identifies a record. 1108 21
1108 23
•Foreign key ~ (set of) 8507 23
column(s) used to link table 8507 29
together
Microsoft
Database Design: Main Ideas
Objective
Ensuring data completeness
Avoiding data redundancies
Facilitating data access
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
Introduction to SQL Server
Relational Data Model
Exploring SQL Server Architecture
Data Access Architectures
SQL Server Services & Tools
SQL Server Editions
Evolution of SQL Server
Summary
Microsoft
Data Access Architectures
Client / Server architecture
Data functionalities on server-side
Visual functionalities on client-side
N-tier architecture
Separating different layers based on data-related processing
such
Some layers: data storage, data access, business functionalities,
visualization (interface)
Service Oriented Architecture (SOA)
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)
Implementation of Entry-Level ANSI ISO Standard
Composing of 3 categories
Data Definition Language Statements (DDL)
Data Control Language Statements (DCL)
Data Manipulation Language Statements (DML)
Microsoft
CLR Integration
Lets you write your database queries using .NET
Any .NET language (C#, VB, C++)
Create and debug using Visual Studio IDE
Microsoft
SQL Server Editions
Enterprise (Developer) Edition
Standard Edition
Workgroup Edition
SQL Server Express Edition
SQL Server Everywhere Edition
Microsoft
Evolution of SQL Server
SQL Server SQL Server SQL Server SQL Server SQL Server
6.5 7.0 2000 2005 2008
• Data • Re-architecture • Reliability and • Enterprise-class • Secure trusted
warehousing of relational scalability scalability platform for data
• Internet server advancements • Programmability • Productive
support • First to include • Deep XML advancements policy-based
• Differentiation OLAP in support • End-to-end management
from Sybase database • Data business • Optimized and
SQL Server • Auto tuning warehousing intelligence predictable
• Ease-of-use • SQL Server CE • Manageability system
• 64 bit support • Support for performance
multiple types of • Dynamic
data development
• Beyond
relational data
• Pervasive
Business Insight
Cross-release Realibility & Security Performance and Scalability
objective Integrated Business Intelligence Automatic Tuning
Microsoft
Your Data Any Place, Any Time
Microsoft
Microsoft Data Platform Vision
Microsoft
Microsoft
Summary
SQL Server ~ a database management system
Supporting relational data model
Supporting data services and tools for database administration
SQL Server ~ the core of a new generation data platform
Exploited in client/server, n-tier, service-orientes architectures
being extensible and flexible data stored
extensible relational data
XML
unstructured data
Supporting .net
Microsoft 24
Microsoft