Friday, 20 July 2018

Big Data Analytics on Current Data

Typical big data applications have a load phase, where a snapshot of data is extracted from operational systems, transformed and cleaned, and then loaded into your big data appliance. Analysts and data scientists can then execute business analytics (BI) queries against the data store in search of patterns and potential marketing opportunities and cost savings. One disadvantage of this architecture is that your appliance becomes more like a large data warehouse, in that it does not contain the most up-to-date data.

Wednesday, 18 July 2018

Oracle Database 12c: Delights the Productivity of the DBA

The architecture of this version is characterized by the concept of containers and database instances that connects and disconnects those containers on the fly, aims to go further than Oracle 11g architecture for consolidation.

Monday, 16 July 2018

Oracle's ASCIISTR() and Unicode Characters

Oracle provides an interesting function, ASCIISTR(), to return ASCII strings from a VARCHAR2 or CLOB column, and in general it does an admirable job. There are non-printing characters however, that 'put a spanner in the works', returning HEX strings instead of characters. Since each HEX string is five bytes long, such strings can significantly increase the overall length of the text so that it won't 'fit' in the allocated buffer space. Let's look at one of those 'annoying' characters, look at its source and provide a possible solution.

Friday, 13 July 2018

Difference between mongoDB and Oracle

Before starting out with the difference between mongoDB and Oracle let us go through about both the databases in brief.


Oracle is an object-relational database system that comprises of table-column-row (TCR) structure. The data in oracle database is stored logically in tables. These tables are then logically grouped in tablespaces. Oracle database physically stores data in data files. Tablespaces contain segments. These segments are made of one or more extents. An extent is the collection of contiguous data blocks. Thus data blocks are basic units of data storage in Oracle.