• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
The Customize Windows > Wordpress and SEO > Web Hosting > Database : What is a Database, How it Works

By Abhishek Ghosh December 3, 2011 9:54 pm Updated on December 3, 2011

Database : What is a Database, How it Works

Advertisement

Database system is a system for electronic data management. The essential task of a Database system is to manage large amounts of data efficiently, consistently and in a durable fashion and it need to save in different subsets, need based forms for the users and application programs.

 

Database system consists of two parts: the management software, called database management system (DBMS) and the amount of data to be managed – the actual database (DB). The management software organizes internally structured storage of data and controls all read and write accesses to the database. Database systems are available in various forms. The most familiar form of a database system is the relational database system.

One of the first major Database system was applied in IMS with Data Language One. The resulting database were managed and hierarchically structured. Significant progress has been achieved in the 1960s and 1970s. While actually in the 1990s, a few commercial vendors of database software dominated the market notably IBM, Informix , Ashton-Tate with dBase , Microsoft with SQL Server and Oracle. Above all, MySQL and PostgreSQL achieved significant market shares. In response, the leading commercial manufacturer to offer Open Source versions of their database software.

 

Understanding Database technology

 

Database systems have become a core component of enterprise software. This makes Database system a critical part of many companies and government agencies escalation of the availability.

The database management system (DBMS) is the software that is installed for the database system and configured. The DBMS defines the database model has to secure a majority of the requirements listed below and a decisive impact on functionality and speed of the system. Database management systems themselves are highly complex software systems.

 

The essential features of today’s database management systems are:

  • Overwriting and deleting data
  • Management of metadata
  • Arrangements for data security
  • Privacy
  • Integrity
  • Multi-user operation by the transaction concept
  • Optimization of queries
  • Enabling triggers and stored procedures
  • Provision of key data about the technology and operation of the DBMS

 

Another important part of Database security is the concept of transaction, the data from race conditions by protecting the ability to have multiple users. Otherwise data may be modified by different users simultaneously.

A query to the database system is first translated into the logical operations of relational algebra. Thereafter database operators actually performs the logical operation on data. The choice of the operators and their order of execution is called to create an implementation plan by the query optimizer. The Optimizer is a particularly complex part of the database software and has a significant impact on the overall system efficiency.

Advertisement

---

 

Purposes and Models of Database System

 

In support of database applications, database systems offer triggers and stored procedures. A trigger initiates an action in the database when a particular event has occurred frequently during insert or update operations. Stored procedures are used to running scripts in the database. Because stored procedures are executed within the database system, they are often the most efficient way to manipulate data.
Database

 

The DBS is a primary interface database language for the following purposes:

 

  • Data retrieval and manipulation ( DML )
  • Database management and definition of data structures ( DDL )
  • Authorization control ( DCL )

 

In the relational DBMS, these categories are in one language ( SQL ), combines with other systems, there is a separation in form but quite different languages. To access the data of DBS privileges are managed. Without permission may not be the appropriate operation performed.

 

Depending on the database model requires the database schema can be adapted to specific structuring choices:

 

Hierarchically : The data objects can only in a parent-child relationship to each other.
Network-like : The data objects are linked together in networks.
Relational : The data is managed in line at a table. There can be any relationships between data. They are defined by values of certain columns.
Object-oriented : the relationships between data objects are managed by the database system itself. Objects can inherit properties from other objects and data.

 

This article is written by Mr. Kanai Lal Saha, who has been regularly writing excellent articles on core computing, Virtualization and Cloud Computing.

 

Tagged With what is a database how it works?

This Article Has Been Shared 8902 Times!

Facebook Twitter Google+ Pinterest
Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Orthopaedic Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to Database : What is a Database, How it Works

  • Windows Hosting, Linux Hosting or Unix Hosting : Which is for you

    Windows Hosting, Linux Hosting or Unix Hosting offers some advantages as well as disadvantages. Which is the most suitable hosting platform for you?

  • Web hosting, Domains, Website, Blog, Forums demystified

    Web hosting, Domains, Website, Blog, Forums are often quite cloudy to the new users. In this article we have written about them in plain English.

  • CDN Options : Rackspace Cloud Files Vs Amazon CloudFront

    CDN options are quite challenging now to decide which has better performance. This article compares Rackspace Cloud Files with Amazon Cloud Front.

  • Cheapest WordPress Cloud Hosting at One Dollar Per Month With CDN

    Cheapest WordPress Cloud Hosting at One Dollar Per Month With CDN on Rackspace cloud infrastructure is now available as pilot project. Amazing, right?

  • WordPress Website Hosting : Handy Guide for the Dummies

    Wordpress Website Hosting to many beginner Bloggers is a scary episode of life. Follow our tips, learn and understand before renting a web server for WordPress.

Additionally, performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us



Subscribe To Our Free Newsletter

You can subscribe to our Free Once a Day, Regular Newsletter by clicking the subscribe button below.

Click To Subscribe

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (15K Followers)
  • Twitter (4.4k Followers)
  • Facebook (5.2k Followers)
  • LinkedIn (3.3k Followers)
  • YouTube (1.5k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • 6 Tips for Securing Your Data from Cyber Attacks as a Remote Worker December 11, 2019
  • What is Process Mining? December 10, 2019
  • Explanation of the ESP32 Vulnerability Warnings December 6, 2019
  • OLTP versus OLAP December 4, 2019
  • What is OLTP (Online Transaction Processing)? December 3, 2019

About This Article

Title: Database : What is a Database, How it Works
2011-12-03

Author: Abhishek Ghosh
Subjects: Web Hosting

Is Part Of:


TheCustomizeWindows,

Saturday, December 3rd, 2011,
Vol.1(01),
p.1–15488 [IoT Ready Journal]


Source:The Customize Windows
ISSN: 0019-5847 ;
E-ISSN: 0019-5847 ;
Publisher:
jima.in

Cite this article as: Abhishek Ghosh, "Database : What is a Database, How it Works," in The Customize Windows, December 3, 2011, December 16, 2019, https://thecustomizewindows.com/2011/12/database-what-is-a-database-how-it-works/.

This website uses cookies. If you do not want to allow us to use cookies and/or non-personalized Ads, kindly clear browser cookies after closing this webpage.

Read Cookie Policy.


PC users can consult Corrine Chorney for Security.

Want to know more about us? Read Notability and Mentions & Our Setup.

web analysis

Copyright © 2019 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy