Course Hero Logo

Some features of dbms program development contains

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 29 - 31 out of 45 pages.

Some features of DBMS:Program development– contains application development software.Users & programmers can use this tocreate application access to databaseBack up & recovery– periodically makes back up copies of the physical databaseDatabase usage reporting– captures statistics on what, when and who are using the data. Databaseadministrator uses this info to assign user authorization & maintain database.***KNOWDatabase Access –permit authorized users to access database.3 modules facilitate thesetasks:oData Definition Language (DDL):a programming language used to define the physical database toDBMS. Defines database on 3 levels/views:
D217 – Accounting Information SystemsUpdated Study Guide Notesi.Internal View:physical arrangement of records in the database.Lowest level of representation.Internal view describes the structure of records, links & physical arrangement, & sequence offiles.There’s only 1 internal view of the database.ii.Conceptual View (Schema):represents the database logically and abstract.Allows users to callfor data without knowing or needing too specific data.Only 1 conceptual view for a database.iii.User view (subschema):User Viewdefines how particular user sees the portion on database thathe or she Is authorized to access.Database is only limited to their authorization.DBMS Operation (summary):1. User calls for data to dbms.Data is in special manipulation language.2. DBMS analyzes the requests & authorization (denied if data doesn’t match).3. DBMS determines data structure parameters from internal view & passes thru operating system.4. OS interacts with disk storage device to retrieve data from physical database.5. OS stores data in main memory buffer area managed by DBMS.6. DMBS transfers data to user’s work location.7. When processing is complete, #4,5,6 are reversed to restore data processed.oData Manipulation Language (DML):proprietary programming language used to retrieve, process, &store data.Entire user programs may be written in the DML, or alternatively, selected DMLcommands can be inserted into programs that are written in universal languages, such as PL/1,COBOL, and FORTRAN. Inserting DML commands enables legacy application programs, which wereoriginally written for the flat-file environment or earlier types of DBMSs, to be easily converted towork in the current database environment. By replacing the old DML commands with the newcommands, user programs can be modified to function in the new environment.oQuery Language:The query capability of the DBMS permits end users and professional programmersto access data in the database directly without the need for conventional programs. SQL emerged asstandard query language for both mainframe & microcomputer DBMSs. SQL is a fourth gen, nonprocedural language with many commands that allow users to input, retrieve, and modify dataeasily. Many database query systems require no SQL knowledge.Users select data visually bybpointing & clicking the desired attributes.By reducing reliance on professional programmers,managers are better able to deal with problems that arise.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 45 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
invoice, Accounting software, Purchase order

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture