Saurav Mitra

Admin

publications

Introduction to ANSI SQL

We human beings communicate with each other with the help of language. Similiarly, SQL stands for Structured Query Language is the language that a database understands, and we will communicate to the database using SQL. SQL is a 4TH generation database gateway language standardized by ANSI (American National Standards Institute) for managing data held in a RDBMS (Relational Database Management Systems).

Updated on May 13, 2019

SQL- Data Definition Language

The Data Definition Language (DDL) manages database table and index structure. The most basic commands of DDL are the CREATE, ALTER, RENAME, DROP and TRUNCATE statements.

Updated on May 9, 2019

SQL- Data Manipulation Language

The Data Manipulation Language (DML) manages data operation like INSERT, UPDATE, DELETE to database tables. The most basic commands of DML are the INSERT, UPDATE, DELETE and MERGE statements.

Updated on May 9, 2019

SQL- Data Query Language

Structured Query Language (SQL) can be further subdivided in multiple parts based on its functionality. Data Query Language (DQL) mainly deals with SQL SELECT statement for retrieving data from a database.

Updated on May 13, 2019

Complex Xml Generation from Database

In this article we will generate complex XML tags/file directly from Database tables using simple SQL SELECT statement. Almost every database vendors provides support for XML read and write functionality. So let us exploit the available database xml functions. In this article we will demonstrate an use-case based on PostgreSQL database.

Updated on May 13, 2019

DW Implementation Using EDB Postgres

PostgreSQL is an advanced open source relational database management system. EDB develops and integrates performance, security, and manageability enhancements into PostgreSQL to support enterprise-class workloads for its database, EDB Postgres Advanced Server. EDB has also developed database compatibility for Oracle to facilitate the migration of workloads from Oracle to EDB Postgres and to support the operation of many Oracle workloads on EDB Postgres.

Updated on May 13, 2019

What is a database? Refresher to Codd's Rule and ACID property

Remember Codd's Rule? Or Acid Property of database? May be you still hold these basic properties to your heart or may be you no longer remember them. Let's revisit these ideas once again..

Updated on May 14, 2019

Understanding Database Normalization with easy Examples

Normalization is a method of organizing data in a database to reduce data redundancy and eliminate any undesirable anomalies such as Update and deletion anomaly. There could be various degree or form of normalization and in this article we will learn them step by step with easy examples.

Updated on May 14, 2019

What is NoSQL

NoSQL is not the name of any particular database instead it refers to a broad class of non-relational databases that differ from classical relational database management systems (RDBMS) in some significant aspects, most notably because they do not use SQL as their primary query language, instead providing access by means of Application Programming Interfaces (API).

Updated on May 14, 2019

Understanding CAP theorem

Despite the high demand in recent years for massively distributed databases with high partition fault-tolerance, the CAP theorem stipulates that it is actually impossible for a distributed system to provide consistency, availability and partition fault-tolerance guarantees simultaneously; a distributed system can satisfy at most any two of these guarantees at the same time, but not all three. Let's understand this in detail.

Updated on May 14, 2019

We Know ACID. What is BASE?

When it comes to relational database systems, we already know what is meant by ACID property of database. But what is the BASE property of NoSQL database? Let's understand BASE in this article.

Updated on May 14, 2019

Learn Oracle Server Architecture in 10 minutes

Here is an easy to understand primer on Oracle architecture. Read this first to give yourself a head-start before you read more advanced articles on Oracle Server Architecture.

Updated on May 14, 2019

Oracle External Tables

The Oracle external tables feature allows us to access data in external sources as if it is a table in the database. This is a very convenient and fast method to retrieve data from flat files outside Oracle database.

Updated on May 14, 2019

Oracle Spool

Oracle Spool for SQLplus command line utility, can be used in conjunction with OS to export data from Oracle to flat file.

Updated on May 14, 2019

Oracle UTL_FILE

The Oracle supplied PL/SQL package UTL_FILE used to read and write operating system files that are located on the database server.

Updated on May 14, 2019

Different Methods to move data from Oracle to External File

How to push data from Oracle Table to external files? Well, external tables in Oracle provides a way to move data in as well as out of the database with the help of SQL*Loader and Data Pump functionality.

Updated on May 14, 2019

Oracle Analytic Functions

Oracle Analytic Functions compute an aggregate value based on a group of rows. It opens up a whole new way of looking at the data. This article explains how we can unleash the full potential of this.

Updated on May 14, 2019

How to find out Expected Time of Completion for an Oracle Query

Too often we become impatient when Oracle Query executed by us does not seem to return any result. But Oracle (10g onwards) gives us an option to check how long a query will run, that is, to find out expected time of completion for a query.

Updated on May 14, 2019

How to find out Which User is Running what SQL Query in Oracle database?

Do you wonder how to get information on all the active query in the Oracle database? Do you want to know what query is executed by which user and how long is it running? Here is how to do it!

Updated on May 14, 2019

Understanding Oracle QUERY PLAN - A 10 minutes guide

Confused about how to understand Oracle Query Execution Plan? This 10 minutes step by step primer is the first of a two part article that will teach you exactly the things you must know about Query Plan.

Updated on May 14, 2019

Understanding Oracle QUERY PLAN - Part2 (Exploring SQL Joins)

This is the second part of the article Understanding Oracle Query Plan. In this part we will deal with SQL Joins.

Updated on May 14, 2019

Oracle AUTOTRACE Explained - A 10 Minute Guide

AUTOTRACE is a beautiful utility in Oracle that can help you gather vital performance statistics for a SQL Query. You need to understand and use it for SQL Query Tuning. Here is how!

Updated on May 14, 2019

Database Performance Tuning

This article tries to comprehensively list down many things one needs to know for Oracle Database Performance Tuning. The ultimate goal of this document is to provide a generic and comprehensive guideline to Tune Oracle Databases from both programmer and administrator's standpoint.

Updated on May 14, 2019

SAP HANA - An Introduction for the beginners

SAP HANA: High-Performance Analytic Appliance (HANA) is an In-Memory Database from SAP to store data and analyze large volumes of non aggregated transactional data in Real-time with unprecedented performance ideal for decision support & predictive analysis.

Updated on May 14, 2019

SAP HANA Architecture

In this article we will discuss about the architecture overview of the In-Memory Computing Engine of SAP HANA. The SAP HANA database is developed in C++ and runs on SUSE Linux Enterprise Server. SAP HANA database consists of multiple servers and the most important component is the Index Server. SAP HANA database consists of Index Server, Name Server, Statistics Server, Preprocessor Server and XS Engine.

Updated on May 14, 2019
© DWBI