Preview

What Is a Database?

Good Essays
Open Document
Open Document
626 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
What Is a Database?
What is a database? * A database is a structured collection of data. The data is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies). * The term database is correctly applied to the data and their supporting data structures, and not to the database management system (DBMS). The database data collection with DBMS is called a database system. * The term database system implies that the data is managed to some level of quality (measured in terms of accuracy, availability, usability, and resilience) and this in turn often implies the use of a general-purpose database management system (DBMS).A general-purpose DBMS is typically a complex software system that meets many usage requirements to properly maintain its databases which are often large and complex. * This is specially the case with client-server, near-real time transactional systems, in which multiple users have access to data, data is concurrently entered and inquired for in ways that preclude single-thread batch processing. Most of the complexities of those requirements are still present with personal, desktop-based database systems.

Types of people involved:
Three types of people are involved with a general-purpose DBMS: 1. DBMS developers - These are the people that design and build the DBMS product, and the only ones who touch its code. They are typically the employees of a DBMS vendor (e.g., Oracle, IBM, Microsoft, Sybase), or, in the case of Open source DBMSs (e.g., MySQL, PostgreSQL), volunteers or people supported by interested companies and organizations. They are typically skilled systems programmers. DBMS development is a complicated task, and some of the popular DBMSs have been under development and enhancement (also to follow progress in technology) for decades. 2. Application

You May Also Find These Documents Helpful

  • Satisfactory Essays

    A database is essentially an electronic filing system. It allows you to quickly select desired pieces of information.…

    • 492 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Another advantage of the database approach is flexibility in terms of data usage. The data is kept in…

    • 592 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    CS-669 Assignment 1

    • 985 Words
    • 4 Pages

    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
  • Good Essays

    “Databases are a mean for storing information in such a way that information can be retrieved from it. In simplest terms, a relational database is one that presents information in tables with rows and columns.” “A table is referred to as a relation in the sense that it is a collection of objects of the same type (rows).” “Data in a table can be related according to common keys or concepts, and the ability to retrieve related data from a table is the basis for the term relational database.” “A Database Management System (DBMS) handles the way data is stored, maintained, and retrieved.” “In the case of a relational database, a Relational Database Management System (RDBMS) performs these tasks. Oracle, 2014)”…

    • 672 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Sql Tutorial

    • 5264 Words
    • 22 Pages

    A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data.…

    • 5264 Words
    • 22 Pages
    Powerful Essays
  • Powerful Essays

    RDBMS Concepts, Q & Answers

    • 6114 Words
    • 25 Pages

    It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.…

    • 6114 Words
    • 25 Pages
    Powerful Essays
  • Good Essays

    DATABASE SQL

    • 592 Words
    • 2 Pages

    (2) Increasingly, the term database is used as shorthand for database management system. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes.…

    • 592 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Ms Sql Detailed

    • 16406 Words
    • 66 Pages

    It is software; it is used to store data in the form of tables. It’s not for programming. Actually data is stored in column wise and row wise.…

    • 16406 Words
    • 66 Pages
    Good Essays
  • Satisfactory Essays

    Data Modeling

    • 1591 Words
    • 7 Pages

    • Mini-world: Some part of the real world about which data is stored in a database. For example, student grades and transcripts at a university. • Database Management System (DBMS): A software package/ system to facilitate the creation and maintenance of a computerized database. • Database System: The DBMS software together with the data itself. Sometimes, the applications are also included.…

    • 1591 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Data Base Management System

    • 3606 Words
    • 15 Pages

    * Stands for "Database Management System." In short, a DBMS is a database program. Technically speaking, it is a software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs.…

    • 3606 Words
    • 15 Pages
    Good Essays
  • Powerful Essays

    Database

    • 2550 Words
    • 11 Pages

    Designing Databases: Building a Conceptual Data Model [1] Fundamentals of Databases Alvaro A A Fernandes School of Computer Science University of Manchester Acknowledgements 2…

    • 2550 Words
    • 11 Pages
    Powerful Essays
  • Good Essays

    Dormitory Database Design

    • 791 Words
    • 4 Pages

    A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically…

    • 791 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    dbms 2 marks

    • 347 Words
    • 3 Pages

    Database management system (DBMS) is a collection of interrelated data and a set of programs to access those data.…

    • 347 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Database Design

    • 661 Words
    • 2 Pages

    We will start this off with the answer to “What is a database?”. A database is a compilation of related or like pieces of data. This information or data is gathered and maintained to serve the specific data management needs of the organization. The organizations activities are supported by the database that is created for it. For example, your local gas station has register pumps that work off of a database. This database has all the prices for every type of gas or diesel fuel sold. The gas station database is also hooked up to the cash registers on the inside of the station. So once you pump your gas outside, the database at the pumps store the information such as fuel cost, amount pumped and possibly credit card information if you decided to pay at pump. Now all of this information can be accessed through this database from the inside of the gas station and possibly the gas stations headquarter office. Databases are used to keep an accurate account of data for whatever the enterprise needs account of.…

    • 661 Words
    • 2 Pages
    Good Essays