Bài giảng Cơ sở dữ liệu nâng cao - Chapter 1: Creating databases and database files

Chia sẻ: Uhm Uhm | Ngày: | Loại File: PPTX | Số trang:32

Thêm vào BST

Báo xấu

80
lượt xem 10
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

Bài giảng Cơ sở dữ liệu nâng cao - Chapter 1: Creating databases and database files. Nội dung chính trong chương này gồm có: Introduction to database, creating database, managing database, maintainance to database. Mời các bạn cùng tham khảo.

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Bài giảng Cơ sở dữ liệu nâng cao - Chapter 1: Creating databases and database files

4/5/17 1 Chapter 1 Creating Databases and Database Files
4/5/17 2 Agenda • Introduction to database • Creating database • Managing database • Maintainance to database
4/5/17 3 Database • Database: • A collection of data that are related in a meaningful way, which can be accessed in diﬀerent logical orders • Database Management System (DBMS): • A general purpose software package designed to store and manage database
4/5/17 4 Simplified database system environment
4/5/17 5 Database example • A UNIVERSITY database for maintaining information concerning students, courses, and grades in a university environment • We have: STUDENT file stores data on each student COURSE file stores data on each course SECTION file stores data on each section of each course GRADE_REPORT file stores the grades that students receive PREREQUISITE file stores the prerequisites
4/5/17 6 Database example
4/5/17 7 Database example
4/5/17 8 DBMS • Objectives of DBMS: • Data availability: users can easily access the data. • Data integrity: the data available in the database is a reliable data • Data security: only authorized users can access the data. • Data Independence: the user to store,update, and retrieve data in an eﬃcient manner.
4/5/17 9 Three-Schema Architecture • Defines DBMS schemas at three levels: • Internal schema at the internal level to describe physical storage structures and access paths (e.g indexes). • Conceptual schema at the conceptual level to describe the structure and constraints for the whole database for a community of users. • External schemas at the external level to describe the various user views.
4/5/17 10 Three-Schema Architecture
4/5/17 11 Introduction to SQL Server 2008 • MS SQL Server is a Relational Database Management System (RDBMS) designed for use in a network environment. • RDBMS is system for storing, manipulating data in a series of related table.
4/5/17 12 Introduction to SQL Server 2008 • MS SQL Server supports 2 computing models: • Client/server application model:
4/5/17 13 Introduction to SQL Server 2008 • MS SQL Server supports 2 computing models: • Distributed computing model:
4/5/17 14 Introduction to SQL Server 2008 • SQL 2008 editions Core Editions Specialized Editions Free Editions Enterprise Standard Workgroup Web Developer Express Compact 3.5 Enterprise Shared Remote For web Full Entry level Embedded workloads data offices that applicatio featured database, database that need scenarios need local n hosting edition for ideal for for redundanc in instances of developm learning developing y and departmen company ent and and ISV desktop builtin ts and data testing redistributi and Business small to only on mobile Intelligenc large application e businesse s
4/5/17 15 Overview of database component • Data files • Transaction log • Filegroup • Data Pages • Extend
4/5/17 16 Overview of database component
4/5/17 17 Overview of database component • Data files • Primary – system objects: • database.mdf • Stored in SQL Server’s data directory “C:\Program Files\Microsoft SQLServer\MSSQL.1\MSSQL\DATA” • Secondary – user objects • .ndf
4/5/17 18 Overview of database component • Transaction log • Records data action • Used for recovery • Use the .ldf file extension
4/5/17 19 Overview of database component • Filegroup • a logical grouping of data files that hold all data and database objects defined for the database. • Primary filegroup: • Made up of the primary data ﬁle and any additional user-deﬁned data ﬁles. • Store all system references for the database including pointers to objects deﬁned in the resource database.
4/5/17 20 Overview of database component • Filegroup • Secondary filegroup: • Control over what data is stored in what location. • Without user-deﬁned ﬁlegroups, all data is stored in the Primary ﬁlegroup, so the ﬂexibility and scalability of the database are reduced dramatically.