top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

small discussion about MySQL

0 votes
367 views

Introduction

A database is a systematic collection of data. A Database Management System (DBMS) is required to store, access, delete, or otherwise organize data in a database.

MySQL is an open source DBMS. It is easy to download, modify, and use open source software without having to pay and fees or royalty to the original author.

DBMS helps you to manage data in two ways:

  • It provides an interface to manage data.
  • It supports connectivity to other applications that can be used to manage data.

Both, DBMS and RDBMS, perform the same task of storing and managing data. One of the key differences between DBMS and RDBMS is that RDBMS splits large amount of data into smaller tables and establishes relationship between the tables. DBMS stores large amount of data in a single table. Also, the RDBMS is based on a relational model whereas DBMS is not.

MySQL is an open source RDBMS. MySQL uses the standardized Structured Query Language (SQL) to manage the database. MySQL is developed and distributed by MySQL AB, a company founded by the MySQL developers. In 2008, Sun Microsystem acquired MySQL AB. In 2010, Oracle acquired Sun Microsystems and hence, MySQL is now owned by Oracle Corp.

Features of MySQL

MySQL was designed to achieve speed, robustness, and ease of use. The features of MySQL are as follows:

Technical Features:

  • Is written in C and C++
  • Is tested with different compilers
  • Is compatible with multiple operating systems
  • Has Application programming Interfaces (APIs) for accessing MySQL databases available in many languages, including C, C++, Eiffel, Java, Perl, Python, Ruby, and Tcl.
  • Is using multiple kernel threads or processing units, if available, for data processing.
  • Is using multiple processors where available, boosting performance.
  • Has ability to divert memory resources from inactive threads to active threads for faster processing
  • Has commands and features to retrieve, update, and delete data from several tables
  • Has support for compatibility to be used as a separate application or as an embedded library.

Commands and Functions:

  • Has support for all MySQL operators and functions in the SELECT statement and the WHERE clause
  • Has support for tables from different database in on statement
  • Has support for table and column aliases
  • Has support for displaying information about databases, tables, and indexes using the SHOW command
  • Has support for displaying query resolution information using the EXPLAIN command
  • Has full support for SQL GROUP BY and ORDER BY clauses, group functions and left and right outer joins.

Scalability and Limits:

  • Handles large databases that have upto 5 billion rows
  • Allows upto 64 indexes per table
  • Allows upto 16 keys per table

Connectivity

  • Supports connectivity on any platform to MySQL server using Transmission Control Protocol/Internet Protocol (TCP/IP) sockets
  • Supports connectivity on Windows NT, 2000, XP, 2003, and Vista using named pipes or shared-memory connections.
  • Supports connectivity on UNIX systems using UNIX domain socket files.

Advantages of MySQL over other RDBMS

There are many commercial Database Management Systems such as Oracle, Microsoft SQL server, and Sybase available in the market. These Database Management systems are robust, reliable, and support most of the features that a user wants. However, it is impossible for these databases to compete with MySQL with regards to price, as MySQL is available for free. In addition, for commercial Database Management Systems, the initial setup cost is most expensive, resource intensive and time consuming whereas with MySQL, this is not the case. This is one of the key advantages of MySQL.

Also, as the source for MySQL is fully available, you can customize MySQL as required. There are many troubleshooting techniques, command help, and syntax help that are available. This information is available in blogs, forums, and lists that do not require paid subscriptions. However, troubleshooting techniques, command help, and syntax help for commercial databases may require a paid subscription.

MySQL provides different versions that work on different versions of Linux, UNIX, Microsoft, Windows, and other operating systems. MySQL also supports various built-in and third-party GUI tools for faster and easier design, implementation, and administration.

posted Jul 3, 2017 by Alok Kumar

  Promote This Article
Facebook Share Button Twitter Share Button LinkedIn Share Button


Related Articles

What is ThingSpeak?

ThingSpeak is an open-source Internet of Things (IoT) application and API to store and retrieve data from things using the HTTP protocol over the Internet or via a Local Area Network.ThingSpeak was originally launched by ioBridge in 2010 as a service in support of IoT applications.
ThingSpeak™ is an IoT analytics platform service that allows you to aggregate, visualize and analyze live data streams in the cloud. 

ThingSpeak provides instant visualizations of data posted by your devices to ThingSpeak. With the ability to execute MATLAB® code in ThingSpeak you can perform online analysis and processing of the data as it comes in. ThingSpeak is often used for prototyping and proof of concept IoT systems that require analytics.

ThingSpeak allows you to aggregate, visualize and analyze live data streams in the cloud. 

Some of the key capabilities of ThingSpeak include the ability to

  • Easily configure devices to send data to ThingSpeak using popular IoT protocols.
  • Visualize your sensor data in real-time.
  • Aggregate data on-demand from third-party sources.
  • Use the power of MATLAB to make sense of your IoT data.
  • Run your IoT analytics automatically based on schedules or events.
  • Prototype and build IoT systems without setting up servers or developing web software.
  • Automatically act on your data and communicate using third-party services like Twilio® or Twitter®.

Video for Thingspeak 

https://www.youtube.com/watch?v=2XH1bTWkWIE

READ MORE

What is Minikube?

Minikube is a tool that makes it easy to run Kubernetes locally. Minikube runs a single-node Kubernetes cluster inside a VM on your laptop for users looking to try out Kubernetes or develop with it day-to-day.

Minikube supports Kubernetes features such as:

  • DNS
  • NodePorts
  • ConfigMaps and Secrets
  • Dashboards
  • Container Runtime: Docker, rkt, CRI-O and containerd
  • Enabling CNI (Container Network Interface)
  • Ingress

When using a single VM of Kubernetes, it’s really handy to reuse the Minikube’s built-in Docker daemon; as this means you don’t have to build a docker registry on your host machine and push the image into it - 

We can just build inside the same docker daemon as minikube which speeds up local experiments. Just make sure you tag your Docker image with something other than ‘latest’ and use that tag while you pull the image. Otherwise, if you do not specify version of your image, 

it will be assumed as :latest, with pull image policy of Always correspondingly, which may eventually result in ErrImagePull as you may not have any versions of your Docker image out there in the default docker registry (usually DockerHub) yet.

Video for Minikube

https://www.youtube.com/watch?v=dhJi5_J7ztY

READ MORE

What is Polymer.Js?

Polymer.js is a JavaScript library created by Google that allows reusing the HTML elements for building applications with components. Polymer is an open-source JavaScript library developed by Google developers

Polymer provides a number of features over vanilla Web Components:

  • Simplified way of creating custom elements
  • Both One-way and Two-way data binding
  • Computed properties
  • Conditional and repeat templates
  • Gesture events

Polymer.js places a hefty set of requirements on the browser, relying on a number of technologies that are in still in the process of standardization (by W3C) and are not yet present in today’s browsers. 

Examples include the shadow dom, template elements, custom elements, HTML imports, mutation observers, model-driven views, pointer events, and web animations. These are marvelous technologies, but at least as of now, that are yet-to-come to modern browsers.

The Polymer strategy is to have front-end developers leverage these leading-edge, still-to-come, browser-based technologies, which are currently in the process of standardization (by W3C), as they become available. 

The recommended polyfills are designed in such a way that (at least theoretically) will be seamless to replace once the native browser versions of these capabilities become available.

Video for Polymer.Js
https://www.youtube.com/watch?v=tvafAyxkuVk

READ MORE

What is React Navigation?

React Navigation is a popular library for routing and navigation in a React Native app.React Navigation is born from the React Native community's need for an extensible yet easy-to-use navigation solution written entirely in JavaScript 

Features

  1) Easy-to-use

          Start quickly with built-in navigators that deliver a seamless out-of-the-box experience.

   2) Components built for iOS and Android

           Platform-specific look-and-feel with smooth animations and gestures.

    3) Completely customizable

            If you know how to write apps using JavaScript you can customize any part of React Navigation.

     4) Extensible platform

            React Navigation is extensible at every layer— you can write your own navigators or even replace the user-facing API.

Npm and Yarn Command

npm install --save react-navigation
yarn add react-navigation

Video for Reach Navigation

https://www.youtube.com/watch?v=C96piR3FRww

READ MORE

What is MLlib?

MLlib (Spark) is Apache Spark’s machine learning library. Its goal is to make practical machine learning scalable and easy. It consists of common learning algorithms and utilities, including classification, regression, clustering, collaborative filtering, dimensionality reduction, as well as lower-level optimization primitives and higher-level pipeline APIs.

Main Benefits

  • Ease of Use
  • Performance
  • Runs Everywhere

MLlib contains many algorithms and utilities.

ML algorithms include:

  • Classification: logistic regression, naive Bayes,...
  • Regression: generalized linear regression, survival regression,...
  • Decision trees, random forests, and gradient-boosted trees
  • Recommendation: alternating least squares (ALS)
  • Clustering: K-means, Gaussian mixtures (GMMs),...
  • Topic modeling: latent Dirichlet allocation (LDA)
  • Frequent itemsets, association rules, and sequential pattern mining

Spark revolves around the concept of a resilient distributed dataset (RDD), which is a fault-tolerant collection of elements that can be operated on in parallel. There are two ways to create RDDs: parallelizing an existing collection in your driver program, or referencing a dataset in an external storage system, such as a shared filesystem, HDFS, HBase, or any data source offering a Hadoop InputFormat.

Video for MLib 

https://www.youtube.com/watch?v=HaNoUnrQWd0

READ MORE

What is Statsmodels ?

Statsmodels is a Python package that allows users to explore data, estimate statistical models, and perform statistical tests. Statsmodels is built on top of the numerical libraries NumPy and SciPy, integrates with Pandas for data handling and uses Patsy for an R-like formula interface.

Statsmodels is part of the scientific Python stack that is oriented towards data analysis, data science and statistics. Statsmodels is built on top of the numerical libraries NumPy and SciPy, integrates with Pandas for data handling and uses Patsy[3] for an R-like formula interface. Graphical functions are based on the Matplotlib library. Statsmodels provides the statistical backend for other Python libraries. Statmodels in free software released under the Modified BSD (3-clause) license.

Features

  • Linear regression models:
  • Mixed Linear Model with mixed effects and variance components
  • GLM: Generalized linear models with support for all of the one-parameter exponential family distributions
  • Bayesian Mixed GLM for Binomial and Poisson
  • GEE: Generalized Estimating Equations for one-way clustered or longitudinal data
  • Discrete models:
  • Multivariate:
  • Nonparametric statistics: Univariate and multivariate kernel density estimators
  • Datasets: Datasets used for examples and in testing
  • Statistics: a wide range of statistical tests
  • Imputation with MICE, regression on order statistic and Gaussian imputation
  • Mediation analysis
  • Tools for reading Stata .dta files, but pandas has a more recent version
  • Table output to ascii, latex, and html
  • Miscellaneous models​

Video for Statsmodels

https://www.youtube.com/watch?v=RWRsxhUzpxk

READ MORE
...