Category Archives: Database Technologies

What is multitenancy? Why it’s becoming so important?

The term “Software Multitenancy” refers to a software architecture in which a single instance of software runs on a server and serves multiple tenants. A tenant is a group of users who share a common access with specific privileges to … Continue reading

Posted in Cloud Computing, Database Technologies, Emerging Trends, Oracle | Leave a comment

Oracle 12c top 12 features

Tom Kyte has picked his top 12 features of Oracle Database 12c and put them into a presentation. Here are his picks: Even better PL/SQL from SQL Improved defaults Increased size limits for some datatypes Easy top-n and pagination queries … Continue reading

Posted in Database Technologies, Oracle | Tagged , , | Leave a comment

In-Memory Column Store in Oracle Database 12c Release 1 (12.1.0.2)

In-Memory Column Store in Oracle Database 12c Release 1 (12.1.0.2) In-Memory Column Store feature in Oracle Database 12c Release 1 (12.1.0.2) promises to address such kind of real-time reporting and statistic requirements at ease. This feature offers users best of … Continue reading

Posted in Cloud Computing, Database Technologies, Oracle | Tagged , , , , , , , , | Leave a comment

Re-Organize / Defrag database schema using ALTER TABLE MOVE TABLESPACE option

There are several ways for a complete reorganization and space reclamation:- EXPORT/IMPORT DBMS_REDEFINITION CREATE TABLE AS SELECT (CTAS) DATA PUMP ALTER TABLE MOVE TABLESPACE This post provides a trick to reorganize all schema objects using the following script using ‘ALTER TABLE MOVE TABLESPACE’ … Continue reading

Posted in Database Technologies, Oracle | Tagged , , , , , , | Leave a comment

HSQLDB – Hyper SQL Database

HSQLDB (Hyper SQL Database) is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92 and SQL:2008 standards.[2] It offers a fast,[3] small (around 1300 kilobytes in version 2.2) database … Continue reading

Posted in Database Technologies | Tagged , , | Leave a comment

A Comparative Analysis of Hadoop Players

For Hadoop 2.2, let’s have a look at major players in the Hadoop ecosystem:  Hortonworks, Cloudera and MapR. Hortonworks Hortonworks announced in June the general availability of their Hortonworks Data Platform (HDP). The HDP distro is 100% Apache open source code. The major … Continue reading

Posted in Cloud Computing, Database Technologies, Emerging Trends, General, Open Source | Tagged , , , , , , , | Leave a comment

What Is Hadoop?

The Apache™ Hadoop® project develops open-source software for reliable, scalable, distributed computing. The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is … Continue reading

Posted in Database Technologies, Emerging Trends, Open Source | Tagged , , | Leave a comment