Small-Medium Business class DBMS



Introduction

A databse is simply an organized collection of related data, typically stored on a disk, and accessible by possibly many concurrent users. Databases are generally separated into application areas. For example, one database may contain Human Resource (employee and payroll) data; another may contain sales data; another may contain accounting data; and so on. Databases are managed by a DBMS.

A Database Management System (DBMS) is a computerized data keeping system. It is a system software application that is used for the interaction with the end-user and other application for creating and retrieving data. In general Database is alogical group of data that contains set of related table spaces and index spaces. The table is a logical structure made up of rows and columns where data are stored. DBMS are categorized according to their data structures or by types.

1. MySQL/MariaDB

MariaDB is one of the most popular open source database system developed by the community-based developer of MySQL. Thus, MariaDB's API and protocol are compatible with those used in MySQL. MySQL is used at Google, Mozilla and Wikimedia Foundation. MariaDB turns data into structured information in a wide array of applications, ranging from banking to websites.

MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins, and may other tools make it very versatile for a wide variety of use cases. Despite the fact that Oracle's MySQL is the most popular open-source database management system, Major Linux distributors like Red Hat and SUSE, are switching it out for its fork, MariaDB. Even now Google is moving to MariaDB from MySQL. The current version of MariaDB is 10.0 and having the features of 'forks', MariaDB is getting popular in contrast to MySQL.

2. PostgreSQL

PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards comliance. It can handle workloads ranging from small sigle-machine applications to large Internet-facing applications with many concurrent users; on macOS Server, Microsoft Windows, and Linux Operating Systems. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications.

PostgreSQL is used in Boards flight at Boston airport. The Federal Aviation Authority converted from Oracle to PostgreSQL to track critical information about the layout of all airports in the U.S. It is also used on a call via Skype. Skype uses PostgreSQL to store all Skype chat and call activity. The call is routed through to an external VOIP service, running on Asterisk, which also uses PostgreSQl. PostgreSQL is also used in researches colon cancer at a charity website that uses a .org domain. The .org domain is managed by Afilias who also use PostgreSQL. The medication described is by Genentech, producer of Avastin and other drugs, who use PostgreSQL for integrating and mining bioinformatics data as part of the drug discovery process. The current version of PostgreSQL is 10.1, and they release with fixig security issues.

3. SQL Server

SQL Server is a Microsoft product used to manage and store information. It is a relational database management system which means data stored inside SQL Server will be housed in a relational database and SQL Server is an entire management system of those stored data. Which means data are stored in a structured table, and uses rows and columns. Structured Query Language is used to manage and administer the database server.

The history of Microsoft SQL Server begains with the first Microsoft SQL products SQL Server 1.0, 16 bits server for the OS/2 operating system in 1989. The current user of SQL Server is Anthem Inc. (Insurance Company), Cook Children Health (Hospitals and Clinics), pseg.com (Electricity, Oil, and Gas), saic.com (Software Development and Technical Consultant company), Fiserv.com (Software manufacture), United health group (Insurence), etc. SQL Server has 46% of market shares on the Windows Operating System. But, not only in Windows OS, SQL Server 2017 took major steps in choices of development languages, data types, on-premise or cloud infrastructure, and operating systems by bringing the power of SQL Server to Linux and Windows based OS.

Uses of DBMS in Small-Medium Business

As a small business owner, we tend to focus only on how to get success in business operations but we forget about the most important part is maintaining a database of the business. There days database security is the main concern in small-medium businesses. For the solution of all these problems, DBMS is the most recommended to use. DBMS will eleiminate the uses of multiple data files on spreadsheets to a great extent by not just keeping all the crucial business-related data handy also in a safe form of a database. DBMS can be from free to costly ones and to use you just have to install on a system and use them. The SQL Server Lite edition is specially created for the samll businesses and it is free up to certain data limit. This server also has the scalability function that has the features of upgrading into higher database whenever it is needed.

DBMS Market Share

  1. Oracle Database - 70%
  2. Microsoft SQL Server - 68%
  3. MySQL (Oracle Corporation) - 50%
  4. IBM DMZ - 39%
  5. IBM Informix -18%
  6. SAP Sybase Adaptive Sever Enterprise - 15%
  7. SAP Sybase IQ - 14%
  8. Teradata - 11%

In conclusion, no matter what database you use, the data should be secure, and any form of data encryption should not interface with the data flexibility. The database should always remain scalable and accessible whenever it is needed. MySQL/MariaDB, PostgreSQL, or MySQL Server have their own benefits and drawbacks. The choices of the database depend upon your features of the company's database. Today's organizational data is always susceptible to losses, and therefore a proper system is highly recommended when a lot of data exists. So, uses of any the above datase systems will help the end users to share the data fast and efficiently across the organization.

    

Bidesh Thapa Copyright © Fall-2017