Information Management: DATABASE MANAGEMENT SYSTEM

DATABASE MANAGEMENT SYSTEM

By: Gonzales, Brian Gabriel E.


What is a Database Management System?
    
    The system software used to create and administer databases is referred to as a database management system (DBMS). End users can create, protect, read, update, and remove data in a database with the help of a DBMS.

Topics
  • Functions of DBMS
  • Advantages of DBMS
  • Disadvantages of DBMS

Functions Of DBMS

These are the operations of a database management system and how it works.

  • Data Definition
  • Data Manipulation
  • Data Security and Integrity
  • Data Recovery and Concurrency
  • Data Dictionary

DATA DEFINITION
  • Metadata must be accepted in source form by the DBMS and converted to the proper object form.

DATA MANIPULATION
  • It is the ability of the DBMS to be able to process user requests to access, update already-existing data in the database, and add new data.

DATA SECURITY AND INTEGRITY
  • Any efforts to bypass the security and integrity tests specified by the database administrator must be rejected by the DBMS, which must be able to keep track of user requests.

DATA RECOVERY AND CONCURRENCY
  • A system crash's impact is lessened by the DBMS's ability to restore data.

DATA DICTIONARY
  • It is the ability of the DBMS to provide a database dictionary for easier finding of the data that the user wants to manage.

Advantages of DBMS

It tackles about the positive impact of using a Database Management System (DBMS). Below are the impacts that it gives to the user:

  • Reduced Data Redundancy
  • Data Integrity
  • Data Independence
  • Data Security
  • Data Consistency
  • Easier Use of Data
  • Less Storage

Reduced Data Redundancy
  • It reduces the duplication of data.

Data Integrity
  • The user may be sure that any modifications to the data will be updated in all future uses of the data because there is no duplication of the data.

Data Independence
  • Data must be independent of both the software used to access the database and other data in the database due to the nature of the database system.

Data Security
  • Since it has a unique identifier, the user can be certain that the data will be secured. Also, The database software package for a database system may include additional security features.

Data Consistency
  • The database environment maintains data consistency. It guarantees that users of the data have the same understanding of the data, including changes made by the user and by others.

Easier Use of Data
  • It frees people from time-consuming, repetitive data processing tasks.

Less Storage
  • The DBMS will use less storage because there is less data redundancy.

Disadvantages of DBMS

It tackles about the negative impact of using a Database Management System (DBMS). Below are the impacts that it gives to the user:

  • Complexity
  • Expense
  • Vulnerability
  • Size
  • Training Costs
  • Compatibility
  • Locking-In of Technology

Complexity
  • Both databases and the DBMS that supports them are very complicated.

Expense
  • Due to the potential requirement for new hardware, the installation of the DBMS and its databases onto the current system calls for thorough planning.

Vulnerability
  • Data in a database is centrally located, putting it at risk to partial or whole destruction in the event of a hardware component failure or a software error.

Size
  • The average mainframe database is huge in terms of size.

Training Costs
  • In order to become the database administrator for a new product, a company that purchases a database product must first train one or more people fit in that role.

Compatibility
  • The incompatibility of most database systems with other database systems is one of its drawbacks.

Locking-In of Technology
  • Whenever a business wants to stop marketing an item, the DBMS must be rebuilt from scratch because it cannot adapt automatically.

Comments

Post a Comment

Popular posts from this blog

DATA DEFINITION LANGUAGE, INTERACTIVE DATA MANIPULATION LANGUAGE, EMBEDDED DATA MANIPULATION LANGUAGE

Image
DATA DEFINITION LANGUAGE, INTERACTIVE DATA MANIPULATION LANGUAGE, AND EMBEDDED DATA MANIPULATION LANGUAGE By: Gonzales, Brian Gabriel E. What is Data Definition Language (DDL)? - Although it may sound like another programming language, data definition language is merely a way of classifying the many kinds of SQL statements. The set of SQL commands known as Data Definition Language (DDL) can be used to design and modify database structures. Indexes, triggers, tables, and views are all examples of objects that can be created, modified, or removed using DDL statements. Common DDL statements are as follows: CREATE (generates a new table) ALTER (alters table) Drop (removes a table from the database) What is Interactive Data Manipulation Language? -  A relational database management system can employ the computer language Interactive Data Manipulation Language (IDML) to manipulate and alter data. (RDBMS). It is mostly used to extract, modify, and analyze data from databases that are stored i
Read more

DATABASE, MS EXCEL, AND MS ACCESS

Image
DATABASE, MS EXCEL, AND MS ACCESS By: Gonzales, Brian Gabriel E. What is a Database? A database is a grouping of information that is logically related and is set up such that it is simple to access, administer, and change. A database management system (DBMS) often controls how databases are accessed electronically from a computer system.   What Type of Software is Microsoft Office Excel? The Microsoft Office software package contains the spreadsheet program Microsoft Excel. With the use of both simple and advanced arithmetic operations and functions, spreadsheets let users manipulate tables of numbers that are organized in rows and columns. The application is compatible with several operating systems, including Windows, macOS, mobile devices, and tablets.    What Type of Software is Microsoft Access? A database management system and application organization service is Microsoft Access. Software developers and application developers use it mostly to create their programs using the progr
Read more

XML, JSON, AJAX

Image
XML, JSON, AND AJAX By: Gonzales, Brian Gabriel E. What is XML? - Extensible Markup Language is known as XML. It is a markup language made specifically to convey and store structured data. In order to encode documents in a way that is both machine- and human-readable, XML requires a set of rules. Similar to HTML, XML stores data in a hierarchical format. However, XML is concentrated on describing the structure and substance of data, in contrast to HTML, which is largely used for displaying and formatting web content. It offers a method for creating unique tags and elements to represent data in a particular domain or application. Elements, attributes, and text content are all parts of an XML document. Start and end tags are used to enclose elements, and they are capable of having child elements. The start tag of an element contains the attributes that are used to describe the element in more detail. The data that is present in an element is represented by text content. Many different ap
Read more