In a relational database, keys are the most important elements to maintain the relationship between two tables or to uniquely identify the data from a table. Primary key is used to identify data uniquely therefore two rows can't have the same primary key. It can't be null. On the other hand, foreign key is used to maintain relationship between two tables. The primary key of a table acts as the foreign key in another table. The Foreign key in a table helps enforce Referential Integrity constraint. Read this tutorial to find out more about Primary and Foreign keys and how ... Read More

OLAP  stands for On-Line Analytical Processing. It is used for analysis of database information from multiple database systems at one time such as sales analysis and forecasting, market research, budgeting and etc. Data Warehouse is the example of OLAP system.OLTP stands for On-Line Transactional processing. It is used for maintaining the online transaction and record integrity in multiple access environments. OLTP is a system that manages very large number of short online transactions for example, ATM.Sr. No.KeyOLAPOLTP1BasicIt is used for data analysisIt is used to manage very large number of online short transactions2Database TypeIt uses data warehouseIt uses traditional DBMS3Data ... Read More

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 More

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 More

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 More

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 More

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 More

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 More

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 More

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 More