Busi 335 copyright 2009 10 ym cheung william tan and

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: s software at the “back end.” BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 11 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 12 Why DBMS are Needed Why DBMS are Needed Database Management Concepts Management Concepts DBMS integrate, standardize, and provide inte standardize security for various applications. Application One X In the absence of integration, each type of the absence of each type of accounting application such as sales, payroll, and receivables will maintain separate, receivables will maintain separate independent data files and computer programs. BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo Y A B Application Two X 13 BUSI 335 Y C D Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 14 Elements of the Database Approach Database Management Concepts (cont’d) (cont Database Administrator System Development Process X Y A B C D Applications Transactions Database dictionary and access codes codes Data manipulation routines Database system Logical file 1 i fil Application one XYAD Logical file 3 Securit screened inquiry file ity fil BUSI 335 XYAB XYCD U S E R S Transactions Transactions Logical file 2 Application two Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 15 User Programs User Programs User Programs DBMS Data Definition Language Data Manipulation Language Query Language Host Operating System Physical Database User Queries BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 16 Database Management Languages Management Languages DBMS Features DBMS Features • User Programs - makes the presence of the DBMS transparent to the user. th • Direct Query - allows authorized users to access data without programming without programming. • Application Development - user created applications. • Backup and Recovery - copies database. and Recovery database • Database Usage Reporting - captures statistics on database usage (who, when, etc.) database usage (who, when...
View Full Document

This document was uploaded on 03/04/2014 for the course COMM 335 at The University of British Columbia.

Ask a homework question - tutors are online