A new breed of Database

Paradigm shift in Database Technology

Gone are the days when organizations heavily used to rely on the their traditional RDBMS for keeping a track of all their transactions and operations. Today is the age of more smarter RDBMS which are made from ground zero for a specific purpose.We will be talking about the OLAP databases in particular, which unconditionally are necessary for every organization playing with large data.
OLAP databases help to derive the meaning of this large data for the organizations. OLAP databases play a major role when it comes to decision making times for organization. The OLAP databases are also called as the lifeline of Decision support systems.

Read more ...

Know your tables in Oracle

DBA_TABLES View 

Have you ever thought of knowing statistics about your tables in oracle.
Statistics in terms of Owner,Tablespace, Number of Rows, Number of Blocks used, Number of Blocks empty,etc.
I was just trying to see what system tables does oracle has with it.
I tried

select * from tab;

BOOM BOOM what a surprise More then 2000 objects listed ...................
some of these objects are tables and some of these objects are views.

Read more ...

Installing JDK on Linux

Installing SUN-JDK on Linux

While many of our applications are based on java framework. We definitely need the

Java development kit for running the java based applications.

So Lets start with What actually is a JDK

A Java Development Kit (JDK) is a program development environment for writing Java applets and
applications. It consists of a runtime environment that "sits on top" of the operating system
layer as well as the tools and programming that developers need to compile, debug, and run
applets and applications written in the Java language.

Read more ...