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...
Read MoreWhat is NuoDB also known as NewSQL?
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...
Read MoreScheme Design Approach in MongoDB
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...
Read MoreWhen to use NoSQL or RDBMS Databases?
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...
Read MoreIn 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 ]In MongoDB you must have ID for each collection you create and the data type that you can store in the ID field is limited only to arrays in other word you can use all kinds of data type including timestamp, integer, string and etc. But you cannot use array as your document id as...
[ Click to Continue ]In NoSQL databases world there is no tables instead you store your data in collections which is similar to normal relation database table they are not really a table in structure but if you compare it with relation database you can do so with tables, collection in mongo is kind of scope which defines and...
[ Click to Continue ]Your application always stores the data that is given to it by the user in the memory and then it stores that data to a storage medium device mainly the disk or other type of storage devices, and MongodDB uses memory mapped files as the server cannot stores all its information in the memory instead...
[ Click to Continue ]SAP HANA is a new technology build by SAP to fill lack of speed some other database were lacking, SAP HANA is a in memory column-oriented, relational database management system which stores all the data in memory and give your business an online analytic process to speed up the calculation, HANA is an acronym for...
[ Click to Continue ]To define enumeration in dictionary word it’s a collection of stuff/things we put them together, like if we create a enumeration for months of the year this would be set of data as month names, In java we declare enumeration like we declare class but with more specific key name like enum. [java][/java] package com.dbdiary.clean;...
[ Click to Continue ]
SQL versus noSQL (Speed)