Splunk Overview-For Operational Intelligence & Log Management

What is Splunk:

It’s a popular Advanced IT Search Tool  used by many companies which derives information from machine data. To make it more lucid, Splunk has the ability to search, monitor and analyze through all machine generated data such as log data generated by applications, servers, and network devices across an organization. This product further indexes structured as well as unstructured data and helps in diagnosing the problems, making it easy for administrators, business analysts and managers to detect requisite information.

Splunk’s web interface makes its easy to examine data as an alternative of going through each log files individually. Splunk helps in easier monitoring and log aggregation thus allowing non experts and beginners to extract important data from the log entries.

Main Features of Teradata Database

Teradata has a Massive Parallel Processing  system, Shared Nothing Architecture thereby eliminating resource contention. Teradata is mainly designed to accommodate large data warehouse implementation and has many data warehousing features embedded into the core of the database. With linear scalability (Software can scale linearly with hardware), unconditional parallelism, multi-faceted parallelism, intelligent data distribution, parallel-aware optimizer makes Teradata is capable of handling large data and complex queries. 

Oracle Database 12C New Feature-Fetch& Offset

In this post we will discuss about a new feature that was introduced in Oracle 12c to limit the rows returned in an easier and effective manner compared to methods used in previous releases by using ROWNUM or using Top-N rows or using analytic functions like RANK or DENSE_RANK. Using this Feature  Oracle 12c provides improved support for top-n analysis.

This new Row limiting Clause in Oracle allows us to select the Top N like queries without much effort. Let’s take a look into the syntax now.

SELECT * FROM Table_Name

ORDER BY column_name DESC

[ OFFSET offset { ROW | ROWS } ]

[ FETCH { FIRST | NEXT } [ { rowcount | percent PERCENT } ]

{ ROW | ROWS } { ONLY | WITH TIES } ]

Features of The New Row limiting Clause In Oracle

Fetch Clause is to limit the number of rows returned in the result set. Fetch Keyword is followed by FIRST or NEXT which can be used interchangeably and is for semantic clarity only. Fetch clause can specify the number of rows or a percentage of rows to return which we will see by using some examples.  

What is Massively Parallel Processing (MPP)

With the advent of Big Data sets mainstream technologies like Massively Parallel Processing (MPP) systems is experiencing vital growth. Let’s discuss about what is MPP or Massively Parallel Processing (MPP)