JSONiq JSONiq is a query language that is outlined for the widely known JSON data model. The most important conceptions of jSONiq were derived from the hard learnt lesson for over 30 years of relational...
Read MoreCategory "Database"
When to use CouchDB over MongoDB and vice versa
There are number of serious discussions over NoSQL database for the high performance distributed web applications. At present there are only two main contenders in the race. One is the MongoDB and the other one...
Read MoreSQL versus noSQL (Speed)
SQL is the abbreviation to Structured Query Language. It is a language widely used to create and manage DataBase Management Systems or DBMS. The use of SQL is a sequel to the relational model databases...
Read MoreHow Massively Parallel Processing databases works?
MPP in a nutshell is a distributed processing architecture in a data warehouse world what it means is that a cluster of servers work together as single machine to distribute the work load between data...
Read MorePig is nothing but “High-level data flow scripting language” what I mean by high-level is that PIG will take care of all those low level programming that you need to write when using MapReduce to run your jobs in Hadoop Cluster as in MapReduce you need to write a lots of Java code to talk...
[ Click to Continue ]Before going in detail about types of indexes in MongoDB let’s talk a little about what indexes does in your database and how it help you to speed up your database search queries. When we create index on table field what actually does is create meta data on that field of a table and point...
[ Click to Continue ]NuoDB is different kind of database, which is almost like traditional relation database but unlike other database, which take approach of shared-disk or shared-nothing architectures, NuoDB is new distributed, peer-to-peer asynchronous approach. As other big relation database like DB2, Oracle and MySQL tried to do in the long run they added new feature with every...
[ Click to Continue ]If you come from the world of relation database then you certainly know that the best way to keep your data and design your scheme is to keep them in third normal form 3NF, you can keep your MongoDB also in the third normal form but in Mongo the best way for your scheme is...
[ Click to Continue ]To get this straight I would like to mention that NoSQL specifically MongoDB is not only a key/value store but it provide more value than only a key value store database, but it’s not a RDBMS either, I have not worked with MongoDB in production with huge data but I have used it with quite...
[ Click to Continue ]In order for you to understand how column and row store works in SAP HANA we need to know what Column and Row store is? and for start the best way would be to show you illustration of this in a picture bellow then I will go head and discuss this further in this article,...
[ Click to Continue ]
Key difference between PIG Latin and SQL