Preview

Mis Management Information Systems

Satisfactory Essays
Open Document
Open Document
1023 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Mis Management Information Systems
'
• View of Data • Data Models

Chapter 1: Introduction

$  $ 

• Purpose of Database Systems

• Data Definition Language • Data Manipulation Language • Transaction Management

& ' &

• Storage Management • Database Administrator • Database Users • Overall System Structure
1.1 Silberschatz, Korth and Sudarshan c 1997

Database Systems Concepts

Database Management System (DBMS)

• Collection of interrelated data • Set of programs to access the data • DBMS contains information about a particular enterprise • DBMS provides an environment that it both convenient and efficient to use

Database Systems Concepts

1.2

Silberschatz, Korth and Sudarshan c 1997

' & ' &

Purpose of Database Systems

$  $ 

Database management systems were developed to handle the following difficulties of typical file-processing systems supported by conventional operating systems. • Data redundancy and inconsistency • Difficulty in accessing data • Data isolation – multiple files and formats • Integrity problems • Atomicity of updates • Concurrent access by multiple users • Security problems

Database Systems Concepts

1.3

Silberschatz, Korth and Sudarshan c 1997

View of Data

An architecture for a database system

view level

view 1

view 2

…

view n

logical level

physical level

Database Systems Concepts

1.4

Silberschatz, Korth and Sudarshan c 1997

' & ' &

Levels of Abstraction

$  $ 

• Physical level: describes how a record (e.g., customer) is stored. • Logical level: describes data stored in database, and the relationships among the data. type customer = record name : string; street : string; city : integer; end;

• View level: application programs hide details of data types. Views can also hide information (e.g. salary) for security purposes.
1.5 Silberschatz, Korth and Sudarshan c 1997

Database Systems Concepts

Instances and Schemas

• Similar to types and variables in programming languages •
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Dbm 381 Week 1paper
    • 885 Words
    • 4 Pages

    Dbm 381 Week 1paper

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…

    • 885 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Athabasca Assignment
    • 837 Words
    • 4 Pages

    Athabasca Assignment

    Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.…

    • 837 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Week 2 Individual Database Design Paper
    • 624 Words
    • 3 Pages

    Week 2 Individual Database Design Paper

    “A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input (tech-faq.com)”. To ensure practical use over a long period of, databases ought to be built with high-level of data integrity and the capability to recover data in the event of hardware failure. Data that has been destroyed or corrupted is useless within a business’s data system structure.…

    • 624 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Business Rules and Data Models
    • 688 Words
    • 3 Pages

    Business Rules and Data Models

    References: Pratt, P.J, & Adamski J.J, (2011). Concepts of Database Management. Ohio, OH: CENGAGE Learning.…

    • 688 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    CS-669 Assignment 1
    • 985 Words
    • 4 Pages

    CS-669 Assignment 1

    The purpose of the DBMS is to service between users’ applications and database. This way of accessing to data through the DBMS brings several advantages. First of all, it supports multiple user access at the same time, which helps to update data just in time.…

    • 985 Words
    • 4 Pages
    Powerful Essays
    Read More
  • Good Essays

    Management Information Systems
    • 1176 Words
    • 5 Pages

    Management Information Systems

    1. On average, private sector IT projects underestimated budget and delivery time of systems by ________ percent.…

    • 1176 Words
    • 5 Pages
    Good Essays
    Read More
  • Powerful Essays

    Database Environment
    • 1121 Words
    • 5 Pages

    Database Environment

    When building a system for information, you have to decide how much responsibility for data management your software will take. A database can be rather large or it can be small depending on the information that is being stored. Request for information from a database are made in the form of a query or a question asking the database for particular information. All database management systems are not the same from a technical standpoint. They differ mostly in the way they organize their information internally. The internal organization can then determine how quickly and supplely the information can be extracted (Jupitermedia, 2011) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    Database Usage in the Workplace
    • 592 Words
    • 3 Pages

    Database Usage in the Workplace

    One of the most important elements of a computer based information system is the database. A database is a collection of records or information that is stored in a computer in a structured manner so that information can be stored, managed, and retrieved. Databases are very useful for manipulating large amounts of data and producing reports and documents. This paper takes a look at the Oracle database system and its usage within my organization.…

    • 592 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Relational Database Concepts and Applications: Research Paper
    • 672 Words
    • 3 Pages

    Relational Database Concepts and Applications: Research Paper

    “Establishing a relational database management system is a great way to increase data integrity, efficiency, ask questions, sort and filter data, provide stronger security, and share information in one concise design which is very user friendly if developed correctly. Relational databases allow the ability to cross-reference data stored by the business and as a result provide a higher level of integrity.” “The key to success is in the foundation of the database's design.” “Relationships of data must be accurately assessed and once this connection is established, the rest falls into place rather smoothly. (Goessl, 2009)”…

    • 672 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Relational Databases
    • 750 Words
    • 3 Pages

    Relational Databases

    A database uses a database management system or DBMS that use one of five specific data structure that allows the end user access to the data in the database. The five data structures are hierarchical, network, relational, object-oriented, and multidimensional. The first databases used the hierarchical data structure to store and gather the data. This structure the data relations are stored in a tree like records are dependent and arranged in multilevel with one root record and various subordinate levels. Any data element in the database can be found by starting at the root record and…

    • 750 Words
    • 3 Pages
    Good Essays
    Read More
  • Better Essays

    Relational Databases
    • 4830 Words
    • 20 Pages

    Relational Databases

    Databases are possible because of their database management system (DBMS). As shown in Figure 4.2, the DBMS is a software program that sits between the actual data stored in the system and the application programs that use the data. As shown in Figure 4.4, this allows users to separate the way they view the data (called the logical view) from the way the data is actually stored (the physical view). The DBMS interprets the users ' requests and retrieves, manipulates, or stores the data as needed. The two distinct views separate the applications from the physical information, providing increased flexibility in applications, improved data security, and ease of use.…

    • 4830 Words
    • 20 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    abstract 2

    • 307 Words
    • 2 Pages

    abstract 2

    A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists. It is an integrated collection of data records, files, and other objects of the company’s system. A DBMS allows different user application programs to concurrently access the same database. It may use a variety of models, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. It provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.…

    • 307 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Mis-Management Information System
    • 800 Words
    • 4 Pages

    Mis-Management Information System

    * The Managers put lot of efforts in a service industry to create a distinctive service to remain competitive , thus MIS plays an important role in providing the most satisfying service to the customers…

    • 800 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Database System Concepts
    • 301237 Words
    • 1205 Pages

    Database System Concepts

    Edited by Foxit PDF Editor Copyright dddddd (c) by Foxit Software Company, 2004 For Evaluation Only.…

    • 301237 Words
    • 1205 Pages
    Good Essays
    Read More
  • Powerful Essays

    Introduction to Database Management
    • 1915 Words
    • 8 Pages

    Introduction to Database Management

    From a technical standpoint, DBMSs can differ widely. The terms relational, network, flat, and hierarchical all refer to the way a DBMS organizes information internally. The internal organization can affect how quickly and flexibly you can extract information.…

    • 1915 Words
    • 8 Pages
    Powerful Essays
    Read More

Related Topics