Designing and loading data into an Amazon Redshift cluster is an important part of using the service for data analysis and reporting. Proper design and loading techniques can help ensure that your data is organized...
Read MoreCategory "Database"
8 Unique Features of Redshift That Make It Stand Out
Redshift is a powerful, fully-managed data warehouse service offered by Amazon Web Services (AWS). It is designed to handle petabyte-scale data warehouses and has become a popular choice for businesses looking to analyze large amounts...
Read MoreTop 10 query language for JSON
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 MoreWhen 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 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 emerged in the 70’s. SQL databases are essentially relational model databases and they have a relationship between the data. The...
[ Click to Continue ]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 nodes thus it speed up processing queries in the server and give you the result faster than a normal data...
[ Click to Continue ]Pig 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 ]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 ]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 ]
SQL versus noSQL (Speed)