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 emerged in the 70’s. SQL databases are essentially relational model databases and they have a relationship between the data. The […]...

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 […]...

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 […]...

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 […]...

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, […]...

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 […]...

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 […]...

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 […]...

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 […]...

For demo purpose we are going to configure three servers primary, secondary and arbiter servers and we are going to do this in local computer for testing purpose only in real world you need separate servers or you can use virtual machine to use seprate virtual machines for each servers,open command line and paste the […]...