SECURITY IN COMPUTING FIETH EDITION Chapter 5: Databases 授课教师:高海波 可南中医药大学 信息管理与信息系统教研室 From Security in Computing, Fifth Edition, by Charles P Pfleeger, et al. (ISBN: 9780134085043) Copyright 2015 by Pearson Education, Inc. All rights reserved
SECURITY IN COMPUTING, FIFTH EDITION Chapter 5: Databases From Security in Computing, Fifth Edition, by Charles P. Pfleeger, et al. (ISBN: 9780134085043). Copyright 2015 by Pearson Education, Inc. All rights reserved. 1 授课教师：高海波 河南中医药大学 信息管理与信息系统教研室
2 Objectives for Chapter 7 Basic database terminology and concepts Security requirements for databases Implementing access controls in databases Protecting sensitive data Data mining and big data From Security in Computing, Fifth Edition, by Charles P Pfleeger, et al. (ISBN: 9780134085043) Copyright 2015 by Pearson Education, Inc. All rights reserved
Objectives for Chapter 7 • Basic database terminology and concepts • Security requirements for databases • Implementing access controls in databases • Protecting sensitive data • Data mining and big data 2 From Security in Computing, Fifth Edition, by Charles P. Pfleeger, et al. (ISBN: 9780134085043). Copyright 2015 by Pearson Education, Inc. All rights reserved
3 Database Terms Database administrator Database management system(DBMS) Record Field/element Schema Subschema Attribute Relation From Security in Computing, Fifth Edition, by Charles P Pfleeger, et al. (ISBN: 9780134085043) Copyright 2015 by Pearson Education, Inc. All rights reserved
Database Terms • Database administrator • Database management system (DBMS) • Record • Field/element • Schema • Subschema • Attribute • Relation 3 From Security in Computing, Fifth Edition, by Charles P. Pfleeger, et al. (ISBN: 9780134085043). Copyright 2015 by Pearson Education, Inc. All rights reserved
Database EXample ADAMS 212 Markct St Columbus OH 43210 BENCHLY 501 Union St Chicago IL 60603 CARTER 411 Elm st Colum bus OH 43210 ADAMS Charles ADAMS Edward BENCHLY Ckc 43210 CMH CARTER Marlene 60603 ORD CARTER Beth CARTER B CARTER Lisabeth CARTER Mary From Security in Computing, Fifth Edition, by Charles P Pfleeger, et al. (ISBN: 9780134085043) Copyright 2015 by Pearson Education, Inc. All rights reserved
Database Example 4 From Security in Computing, Fifth Edition, by Charles P. Pfleeger, et al. (ISBN: 9780134085043). Copyright 2015 by Pearson Education, Inc. All rights reserved
5 Schema Example Name First Address City State Zip Airp。rt ADAMs Charles 212 Market St. ColumbusOH 43210 CMH ADAMS Edward 212 Market St. ColumbusOH43210CMH BENCHLY Zeke 501 Union St. Chicago IL 60603ORD CARTER Marlene 411 Elm St Columbus OH 43210CMH CARTER Beth 411 Elm st Columbus OH 43210CMH CARTER Ben 411 Elm St Columbus 43210 CMH CARTER Lisabeth 411 Elm St Columbus OH 43210CMH CARTER Mary 411 Elm St Columbus OH 43210 CMH From Security in Computing, Fifth Edition, by Charles P Pfleeger, et al. (ISBN: 9780134085043) Copyright 2015 by Pearson Education, Inc. All rights reserved
Schema Example 5 From Security in Computing, Fifth Edition, by Charles P. Pfleeger, et al. (ISBN: 9780134085043). Copyright 2015 by Pearson Education, Inc. All rights reserved