Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Database Articles
Page 274 of 546
Difference between monolithic and microservices architecture
Monolithic architecture is built as one large system and is usually one code-base. Monolithic application is tightly coupled and entangled as the application evolves, making it difficult to isolate services for purposes such as independent scaling or code maintainability.It extremely difficult to change technology or language or framework because everything is tightly coupled and depend on each other.Microservices architecture is built as small independent module based on business functionality. In microservices application, each project and services are independent from each other at the code level. Therefore it is easy to configure and deploy completely and also easy to scale based ...
Read MoreImportant MYSQL Performance Tuning and Settings after Installation
In this article, we will learn and discuss some important performance tuning settings for MySQL which we need to implement after the MySQL Installation better and speedy performance.Pre-requisitesAssuming that we have already installed the MySQL, I am providing some tips before we start to know about Performance tuning settings for MySQL.Even experienced IT persons may make some mistakes which will lead to many problems, so before we apply any recommendations which are shown in this article, we will keep the below items in mind to avoid issues or problems.We will apply only one setting at a time so that we ...
Read MoreCareers in BigData? – A Big Leap Forward
Big Data is everywhere and there is an urgent need to collect and preserve whatever data has been generated. We also find that there is a greater fear of missing something, which is important. Big Data Analytics has become crucial, it helps improve business, decision making and offers the biggest edge over the competitors.What does the term Big Data mean?The term big data can be described as something large volume of data which is both structured and unstructured, that inundates a business on a day-to-day basis. Data is available everywhere but how can organizations capitalize on that is the big ...
Read MoreBusiness Intelligence as a Career Option?
Business intelligence is an umbrella term, which includes infrastructure, applications, tools and best practices that enable analytics of data and information in order to improve and optimize decision making and managing corporate performance. There are a lot of tools and technologies which are built on this concept.BI as a DisciplineBusiness Intelligence is made up of several related activities, which includes Data mining, Online analytical processing, Reporting, and Querying.Why Companies Prefer to use BI?Helps improve predictive mechanism through decision makingReduces costHelps identify new business opportunitiesIn the modern world, business operations are getting more complex with each passing day, hence there is ...
Read MoreHow to Secure MongoDB on Ubuntu 16.04
In this article, we will learn how to secure Mongo DB on Ubuntu 16.04. In previous versions the Mongo DB is vulnerable to automated exploits because, by default, there is no authentication which was allowed to interact with the database, any user can create, read, modify and destroy the database and the contents, this is because of the Mongo DB daemon which can listen to all interfaces as default settings.Enabling Authentication and Adding Admin UserThis issue has been mitigated in the latest versions of Mongo DB after version 3.x releases, however, the authentication is still disabled as default settings, so ...
Read MorePrint all odd numbers and their sum from 1 to n in PL/SQL
In this problem, we are given a number n and we have to print all odd numbers from 1 to n and also print the sum of numbers from 1 to n in PL/SQL.PL/SQL is a procedural language extension to SQL. The code is a sequence of instructions that are ground in a block with all related declarations and instructions.Let’s see an example of our problem −Input: 7 Output: odd numbers are: 1, 3, 5, 7 Sum of odd numbers is 16To solve this problem, we will take a number and initialize it to 1 and a sum variable with ...
Read MoreHow to Migrate MySQL to MariaDB on Linux?
This article will help you to migrate the database from MySQL to MariaDB as the binary compatibility of MySQL-to-MariaDB in the migration process is very much straightforward.After the Oracle’s acquisition of MySQL, the community has driven an outcome of such movement and developed a new database called MariaDB. MariaDB is the open-source and its compatibility with MySQL. Most of the Linux distributions (RH, CentOS, Fedora) have already started to use the support of MariaDB as a drop-in replacement of MySQL.If we want to migrate the database from MySQL to MariaDB then this article will help.Preparing a MySQL Database and TablesWe ...
Read MoreHow to Install MongoDB on Ubuntu 16.04
MongoDB is a cross-platform, document oriented database that provides, high performance, high availability, and easy scalability. MongoDB works on concept of collection and document. The official Ubuntu 16.04 MongoDB packages have not yet been published by the MongoDB maintainers. This article explains about “How to install Mongo DB on Ubuntu and start the MongoDB service on boot”Adding the MongoDB RepositoryMongoDB is generally included in a Ubuntu package repositories. However, a legitimate MongoDB repository affords the most upto date version change in an endorsed manner.To carry out this process, we first must import the key for the legitimate MongoDB repository using ...
Read MoreInsert NULL value into database field with char(2) as type in MySQL?
Let us first create a table −mysql> create table DemoTable658(FirstName varchar(100),value char(2)); Query OK, 0 rows affected (0.95 sec)Insert some records in the table using insert command −mysql> insert into DemoTable658(FirstName) values('John') ; Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable658(value,FirstName) values(default(value),'Sam'); Query OK, 1 row affected (0.23 sec)Display all records from the table using select statement −mysql> select *from DemoTable658;This will produce the following output −+-----------+-------+ | FirstName | value | +-----------+-------+ | John | NULL | | Sam | NULL | +-----------+-------+ 2 rows in set (0.00 sec)
Read MoreQuery non-empty values of a row first in ascending order and then display NULL values
For this, use ORDER BY ISNULL(). Let us first create a table −mysql> create table DemoTable669 ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentScore int ); Query OK, 0 rows affected (0.55 sec)Insert some records in the table using insert command −mysql> insert into DemoTable669(StudentScore) values(45) ; Query OK, 1 row affected (0.80 sec) mysql> insert into DemoTable669(StudentScore) values(null); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable669(StudentScore) values(89); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable669(StudentScore) values(null); Query OK, 1 row affected (0.15 sec)Display all records from the table using select ...
Read More