Dev. 17 DBMS (MySQL)

What is DBMS (Database Management System)?

A DBMS is a software package developed to define, manipulate, retrieve and manage data in a DB. Generally a DBMS manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate the data.

The earliest types of DBMS were the hierarchy model and the network model. However, over time, a relational DB became popular over those models.

SQL and NoSQL

SQL is a traditional language that can be used to pull various information on these relational models. Furthermore, a new concept has emerged called NoSQL which means ‘Not only SQL’ so using NoSQL to describe systems that are beyond the traditional SQL and relational DB models. It is also important to note that NoSQL is a much more abstract term than relational DB. The object-oriented DB is an example for this using object designs to work with the identities and attributes instead of relational tables.

MySQL

MySQL is an open source relational DBMS that works on many platforms. It provides multi-user access to support many storage engines and is supported by Oracle. So, it is possible to buy a commercial license from Oracle and get premium services.

Features of MySQL

• Ease of management: the software is easy to download and uses scheduler to mark tasks autometically.
• Robust transactional support: holds the ACID (Atomicity, Consistency, Isolation, Durability) property and allows distributed multi-version support.
• Comprehensive application development: has libraries to embed the DB into any application.
• High performance: provides fast load utilities with distinct memory caches and table index partitioning.
• Secure data protection: supports powerful mechanisms to ensure that only authorized users can access to the DB.
• High availability: can run high-speed master/slave replication configurations and it offers cluster servers.
• Scalability & Flexibility: can run embedded applications and create data warehouses holding a humongous amount of data.

GraphQL

It is a query language for APIs and a runtime for fulfilling those queries with our existing data. It provides a complete and understandable description of the data in our API, gives clients the power to what they need and nothing more, makes it easier to evolve APIs over time.