Lecture 3 INSY 3304 - 002
Popular in Database Management Systems
Popular in Information technology
This 3 page Class Notes was uploaded by loveena Cherukunnathu on Wednesday January 27, 2016. The Class Notes belongs to INSY 3304 - 002 at University of Texas at Arlington taught by Karen Scott in Spring 2016. Since its upload, it has received 44 views. For similar materials see Database Management Systems in Information technology at University of Texas at Arlington.
Reviews for Lecture 3
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 01/27/16
January 27, 2016 The Database System Environment Hardware physical things (ex: computer) Software It contains: operating system software, DBMS, application programs that access with DBMS(plus utility software for backups) People database designer (who does the design modeling), system and database admins, systems analysist and programmers, and users Procedures Business rules, the instructions/rules/polices that dictate the design and use of the system. Data collection of facts that are stored in your database Database systems are created and managed at different levels of complexity Some maybe small/ some maybe big (ex. for 1 person or whole industry) Database solutions must be cost-effective, tactic and strategic Database technology already in use affects selection of a database system DBMS Functions Transparency It should be transparent to the end user which means, it hides the complexity from the user. Data dictionary management Stores the definitions of data elements and their relationships. DBMS looks up data components structures and relationships. It automatically records any structural changes in its data dictionary. Also it provides data abstractions and removes structural and data dependency What metadata looks like inside the dictionary Data storage management Create and manage the data structure that are required for data storage. (ex. create tables, columns) Also create data entry forms, reports, screen definitions, query definitions…etc. Performs fine tuning for you so database perform more efficiently. (ex. create index) Data transformation and presentation Transforms from physically to logical and vis-versa. Transforms data to conform to the required data structures. Security management DBMS creates security system that enforces user’s data security and privacy. Multiuser access control multiple concurrent users Takes complex algorithms to maintain the integrity of the data while allowing for concurrent access. Backup and recovery management Backups your data - makes copy of your data and restore if it something is lost. Backup and data recover to ensure data safety and integrity. Critical to preserve the integrity of the data Data integrity management DBMS force and enforce integrity rules. Minimizes redundancy, max consistency. The integrity rules are stored in data dictionary. Referential integrity: Enforces data integrity based on the relationships Entity integrity: Primary key’s has to be different from once that already exist. Database access languages and APIs SQL is default query language nowadays. SQL is supported by majority of DBMS vendors. Query languages are non-procedural. API (Application Program Interface): Programs that allow 1 application to communicate with another application. Database communication interfaces DBMS accepts end-user requests. You can go directly in DBMS and create different rd quarries and reports. Also allows you to connect to 3 party application Managing the Database System: A Shift in Focus Framework database provides this to enforce strict producers and standards o More sophisticated use of the data o Effectiveness Data structure and their relationships will determine their effectiveness. Which are created in and effected by DBMS. Disadvantages of database systems: The cost involved. Complexity to manage the data You have to maintain currency. You get dependent on the vendor – they provide special code for you Frequent upgrade/replacement cycles. Preparing for Your Database Professional Career
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'