Principles of Database Design

Principles Of Database Design-ppt Download

  • Date:18 Nov 2020
  • Views:3
  • Downloads:0
  • Size:2.29 MB

Share Presentation : Principles Of Database Design

Download and Preview : Principles Of Database Design

Report CopyRight/DMCA Form For : Principles Of Database Design


Transcription:

GI NG VI N TS L TH LAN Th ng tin TS L Th Lan Vi n nghi n c u qu c t MICA i h cB ch Khoa H N i.
Email Thi Lan Le mica edu vn Web http www mica edu vn perso Le Thi Lan Database N i dung m n h c Ch ng 1 i c ng v c c h c s d li u.
Ch ng 2 C c m h nh d li u Ch ng 3 Ng n ng nh ngh a v thao t c d li u Ch ng 4 Ph thu c h m v chu n h a CSDL quan Ch ng 5 T ch h p c s d li u trong c c ng d ng Php Mysql.
C SQL server K ho ch h c t p L thuy t B i t p tr n l p b i t p tu n c nh n .
nh m sinh vi n nh gi gi a k B i t p l n tham gia v o i m nh gi cu i k Thi h c k nh gi gi a k .
Th c hi n theo nh m M i nh m 3 sinh vi ntheo danh s ch l m 1 b i t p C n Ho n th nh b i t p c giao trong th igian 1 tu n nh n th n m h ng tu n v .
tr nh b y v o th n m tu n ti p theo Ph n chia c ng vi c r r ng Chu n b slides v tr nh b y v b i t p choc c b n trong l p nh gi i m cho c c th nh vi n d a v o.
c ng vi c c a t ng th nh vi n T i li u tham kh o Nguy n Kim Anh Nguy n l c a c c h c s d li u NXB i h c qu c gia H N i SQL Unleashed Second Edition.
by Sakhr Youness Sams MacmillanComputer Publishing Database Management Systems SecondEdition Raghu Ramakrishnan and Johannes Google .
CH NG 1 I C NG V H C S D LI U Gi i thi u D th a kh ng nh t qu n d th ng trong.
truy nh p ng th i Gi i thi u ti p 1 Kh i ni mC s d li u database L m t b s u t p c c d li u t c.
nghi p c l u tr l i v c c c h ng d ng c a m t x nghi p c th n o s d ng V d c s d li u s ch c a th vi n i h c B ch Khoa H N i c s d .
li u h ng h a c a si u th 1 Kh i ni mH qu n tr c s d li u databasemanagement system L m t h th ng ph n m m cho ph p t o.
l p c s d li u v i u khi n m i truynh p i v i CSDL V d M Access SQL server 1 Kh i ni m4 th nh ph n c a m t h c s d li u.
database system C s d li u h p nh t Ng i s d ng Ph n m m qu n tr c s d li u Ph n c ng.
2 H qu n tr c s d li u H qu n tr c s d li u c kh n ng Kh n ng qu n l d li u t n t i l u d i Kh n ng truy nh p c c kh i l ng d li u l n m t c ch hi u qu .
2 H qu n tr c s d li u C c c i m c a h qu n tr c s d li u H tr t nh t m t m h nh d li u m b o t nh c l p d li u H tr ng n ng c p cao.
Qu n l giao d ch i u khi n truy nh p Ph c h i d li u 2 H qu n tr c s d li u Kh i ni m .
S c s d li u Th hi n c a s c s d li u 2 H qu n tr c s d li uC c thay i C c thay iC c thay i.
s d li utruy v nB x l c uB qu n l giao d ch.
B qu n l l u tr D li usi u d li u 2 H qu n tr c s d li u.
C c m c tr u t ng M c v t l M c logic M c khung nh n C c m c c l p d li u.
M c v t l M c logic kh t c C c m c tr u t ng 2 H qu n tr c s d li u C c ng n ng c s d li u.
Ng n ng nh ngh a d li u Data DefinitionLanguage DDL Ng n ng thao t c d li u Data ManipulationLanguage DML T m ki m th ng tin.
Th m th ng tin m i X a th ng tin Thay i th ng tin 2 H qu n tr c s d li u Ng i d ng.
Ng i qu n tr c s d li u nh ngh a s x c nh c u tr c l u tr y quy n x c nhr ng bu c to n v n Ng i s d ng c s d li u L p tr nh ng d ng.
Nh ph n t ch d li u Ng i s d ng cu i 3 Ph n lo i c c h c s d li u H c s d li u t p trung H c s d li u c nh n.
H c s d li u trung t m H c s d li u kh ch ch H c s d li u ph n t n H c s d li u ph n t n thu n nh t H c s d li u ph n t n kh ng thu n nh t.
C s d li u t p trung C s d li u trung t m C s d li u ph n t n 3 H c s d li u ph n t n H c s d li u ph n t n thu n nh t.
H i u h nh nh nhau M h nh d li u nh nhau H qu n tr c s d li u chung D li u c nh ngh a v c khu n d ng H c s d li u ph n t n kh ng thu n nh t.
So s nh c c h qu n tr CSDL quan h T n C ng ty B n u ti n B n quy nADABAS 1970 Software AG ProprietaryMicrosoft Access 1992 Microsoft ProprietaryMicrosoft SQL 1989 Microsoft Proprietary.
MySQL 1995 Sun Microsystems GPL or ProprietaryPostgreSQL 1989 PostgreSQL Global BSDDevelopment GroupSQLite 2000 D Richard Hipp Public domainOracle 1979 Oracle Corporation Proprietary.
http en wikipedia org wiki Com... So s nh c c h qu n tr CSDL quan h T n K ch th cADABAS N AMicrosoft Access 2 GB.
Microsoft SQL Server 524 258 TB 32 767 files 16TB max file size MySQL UnlimitedPostgreSQL UnlimitedSQLite 32 TB 230 pages 32 KB max.
page size Oracle Unlimited 4 GB block sizeper tablespace CH NG 2C C M H NH D .
1 T ng quanQuy tr nh ph t tri n ng d ng CSDLSource Data Modeling Using Entity Relationship Model NGUYEN Kim Anh Data modelling M h nh h a d li u M c ch .
M t d li u s l u tr trong c s d li u v d c c th c th nh sinh vi n b i h c M t m i quan h gi a c c d li u M t c c r ng bu c i v i d li u.
M h nh d li u l M t s h nh th c h a to n h c v im t t p k hi u m t d li u M t t p c c ph p to n c s d ng thao t c c c d li u.
2 M h nh th c th li n k t EntityRelationship Diagrams Th c th Thu c t nh Li n k t.
Th c th Entity L m t i t ng c th hay tr u t ngtrong th gi i th c m n t n t i v c th ph n bi t v i c c i t ng kh c V d sinh vi n c n b .
T p th c th nh m c c th c th gi ngreal customers customersurrogatesT n c a th c th l duy nh t Thu c t nh Attribute .
Thu c t nh l m t th ng tin v th c th M t thu c t nh c m t mi n gi tr Thu c t nh t p thu c t nh kh a l thu c t nh hay t p thu c t nh m gi tr c a n c x c nh duy nh t cho m i th c th .
V d S ch ng minh th nh n d n l thu c t nh kh a chonh n vi n trong m t x nghi p Username v password l t p thu c t nh kh a chom t t i kho n th .
V d H t n M s Gi i t nhNh n vi nTu i Ng y sinh Th c th y u Weak entity .
L th c th ph thu c v o th c th kh c Li n k t nh danh l li n k t gi a th c th y u v th c th nh danh n Th c th y u Weak Entity .
Th n nh n l th c th y u Nh n vi n l th c th nh danh c a th n Ph thu c l li n k t nh danh Th c th y u Weak Entity Gi i t nh Quan h Ng y sinh.
Nh n vi n Ph thu c Th n nh n Li n k t 1 1female current male customer marriage customerpartial functions.
A partial function from X to Y is a function X Y where X is a subset of X Li n k t 0 N v 1 Nairport from flt schedulepartial function.
Li n k t b t bu c 0 N v 1 Nairport from flt scheduletotal function Li n h t N M nhi u nhi u customer reservation flt instance.
Li n h t N M nhi u nhi u C u thu Thi u cho i bo ng i na oM c t n S n nha t n Qu c.
l ng ti ch Li n k t l pconnection flt schedule flt departure arrival Li n k t is a .
A is a B n u B l s t ng qu t h a c a ATh l c T c T n M NV L ngC u th L m t Nh n vi n 2 M h nh quan h T ch c c Cartesian Product T ch c c.
c a n t p l t p t t c c c c ch k t h p c ac c th nh ph n trong n t p Mi n gi tr Domain c a m t thu c t nh l t pt t c c c gi tr c th c a m t thu c t nh K hi umi n gi tr c a thu c t nh A l dom A .
3 M h nh quan h S quan h Relation Schema bi u di nR A1 A2 An l m t quan h R v danh s chc c thu c t nh A1 A2 An Quan h Relation l m t t p con c a t ch .
c c trong mi n gi tr S quan h R Quan h r T p c c thu c t nh A1 Anr R dom A1 dom A2 dom An .
3 M h nh quan h tt B quan h N tuple l m t t p c c c p thu ct nh gi tr bi u di n m t th hi n c a quan h B c quan h Degree l s thu c t nh c a quan L c l ng c a quan h Cardinality l s b .
c a quan h 3 M h nh quan h tt Kh a Key l m t t p thu c t nh m c c gi tr c a n x c nh duy nh tm t b trong quan h t1 v t2 l 2 b trong quan h r tr n m h nh quan h R.
sk l m t t p c c thu c t nh kh a t1 sk t2 sk Kh a t i thi u Candidate key l t p thu c t nh kh a nh nh t M tquan h c th c nhi u t p kh a t i thi u Kh a ch nh primary key l kh a t i thi u c l a ch n l m kh a cho.
quan h Kh a ngo i Foreign Key l kh a t i thi u c a quan h A v c s d ng trong quan h B C s d li u L m t t p quan h 3 M h nh quan h V d .
Courseno Subject Lecturer MachineCS250 Programming Lindsey SunCS260 Graphics Hubbold SunCS270 Micros Woods PCCS290 Verification Barringer Sun.
Course Courseno Subject Lecturer Machine CH NG 3NG N NG NH NGH AV THAO T C D LI U 1 Ng n ng nh ngh a d li u.
Cho ph p nh ngh a S i v i m i b ng Ki u d li u hay mi n gi tr C c r ng bu c to n v n T p c c ch d n.
Th ng tin an to n v y quy n i v i t ng b ng C u tr c l u tr v t l Thi Lan Le MICA HUST 1 Ng n ng nh ngh a d li u Ki u d li u .
D li u x u k t Char n Varchar n d i thay i D li u s Int or Integer t 2 147 483 648 n 2 147 483 647 .
Smallint t 32 768 n 32 767 Numeric p s Real double precision Float n D li u ng y th ng.
Date YYYY MM DD Time HH MM SS MMMMThi Lan Le MICA HUST 1 Ng n ng nh ngh a d li u T o b ng trong CSDL .
CREATE TABLE t n b ng t n c t ki u d li u NOT NULL CONSTRAINT t n r ng bu c ki ur ng bu c Thi Lan Le MICA HUST 1 Ng n ng nh ngh a d li u.
T o b ng X c nh kh a ch nhThi Lan Le MICA HUST 1 Ng n ng nh ngh a d li u Th m X a c t trong b ngThi Lan Le MICA HUST.
1 Ng n ng nh ngh a d li uX a b ng C ph p DROP TABLE relation nameSQL Unleashed, Second Edition by Sakhr Youness Sams, Macmillan Computer Publishing Database Management Systems, Second Edition, Raghu Ramakrishnan and Johannes Gehrke Google… CHƯƠNG 1 ĐẠI CƯƠNG VỀ HỆ CƠ SỞ DỮ LIỆU Giới thiệu Dư thừa, không nhất quán, dị thường trong truy nhập đồng thời, …

Related Presentations

Database Models Flat Files and the Relational Database

Database Models: Flat Files and the Relational Database Objectives: Understand the fundamental structure of the relational database model Learn the circumstances under which it is a better choice than the flat file

29 Views0 Downloads

Database Security with focus on Hyperion Database

Hyperion application security determines user access to products using the concept of roles. A role is a set of permissions that determines user access to product functions. User directories store information about the users who can access Hyperion products. Both the Authentication and the authorization processes utilize user information.

25 Views0 Downloads

2 D Design I Mrs Ignagni Chapter 8 Principles of Design

Sequence – the following of one event or image after another in logical ordering (comics) Charles Schulz, Peanuts, is a good example of sequence. Implied Movement – the appearance of movement in a static artwork resulting from an artist’s use of elements. Paul Cezanne’s .

13 Views0 Downloads

The Principles of Design Mrs James Art amp Design

Possible answers could be: The fish and the boat design is repeated over and over. The colors appear as a pattern. The lines that form the sail of the boats. The eyes of the fish. ... What type of balance is shown in this stained glass artwork, Rose Window? Radial Balance! Look at the spiral or spinning effect of the pattern. The axis is the ...

20 Views0 Downloads

Database Tuning Principles Experiments and

Database Tuning Principles, Experiments and Troubleshooting Techniques ... data across multiple databases * A puzzle Two databases X and Y X records inventory data to be used for restocking Y contains delivery data about shipments Improve the speed of shipping by sharing data Certain data of X should be postprocessed on Y shortly after it ...

20 Views0 Downloads

CS 245 Database System Principles

CS216 Advanced Database Systems Notes 12: Concurrency Control (II) Shivnath Babu How to enforce serializable schedules? Option 1: run system, recording P(S); at end of day, check for P(S) cycles and declare if execution was good How to enforce serializable schedules?

24 Views0 Downloads

Database Tuning Principles NYU Computer Science

Dennis Shasha ([email protected]) ... Data and Index Files RAID 5 is best suited for read intensive apps or if the RAID controller cache is effective enough. RAID 10 is best suited for write intensive apps. * Controller Prefetching no, Write-back yes. Read-ahead: Prefetching at the disk controller level. No information on access pattern.

10 Views0 Downloads

Database Principles

Database Principles. Basics. A database is a collection of data, along with the relationships between the data, organized for efficient retrieval. The data has to be entered into a structure, maintained and kept up to date, and accessed (via reports or online queries) ... Hot topic these days with “Big Data” ...

11 Views0 Downloads

CS 245 Database System Principles Stanford University

Example: say R1.C index is 201 blocks Keep root + 99 leaf nodes in memory Expected cost of each probe is E = (0)99 + (1)101 0.5 200 200 CS 245 Notes 7 * Total cost (including probes) = 500+5000 [Probe + get records] = 500+5000 [0.5+2] uniform assumption = 500+12,500 = 13,000 (case b) CS 245 Notes 7 * Total cost (including probes) = 500+5000 ...

22 Views0 Downloads

Principles of Distributed Database Systems

What is a Distributed Database System? A distributed database is a collection of multiple, logically interrelateddatabases distributed over a computer network. A distributed database management system (Distributed DBMS) is the software that manages the DDB and provides an access mechanism that makes this distribution transparentto the users

8 Views0 Downloads

CS 245 Database System Principles Computer Science amp E

Notes 09: Transaction Processing Slides are modified from the CS 245 class slides of Hector Garcia-Molina * * Proof: similar to X locks case Detail: l-ti(A), l-rj(A) do not conflict if comp(t,r) l-ti(A), u-rj(A) do not conflict if comp(t,r) Theorem Rules 1,2,3 Conf.serializable for S/X locks schedules * Lock types beyond S/X Examples: (1) increment/decrement lock (2) update lock * Example (1 ...

9 Views0 Downloads

CS5423 Principles of Database Systems

Database Systems: The Complete Book 2nd edition. Hector Garcia-Molina, Jeff Ullman and Jennifer Widom. Recommended reading. Fundamentals of Database Systems 7th edition, by Elmasri and Navathe. ISBN: 9780133970777, 2016. Database Management Systems 3rd edition, by Raghu Ramakrishnan and Johannes Gehrke. Readings in Database Systems

3 Views0 Downloads