• on in NoSQL

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

    [ Click to Continue ]
  • on in Uncategorized

    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 ]
  • on in Uncategorized

    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 ]
  • on in NoSQL

    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 ]
  • on in SAP

    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 ]
  • on in Uncategorized

    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 ]
  • on in Uncategorized

    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 ]
  • on in Uncategorized

    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 ]
  • on in SAP

    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 ]
  • on in Uncategorized

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

    [ Click to Continue ]

SQLite vs MySQL

on

SQLite is a library that gets embedded inside the application that makes use of. SQLite offers an amazing set of tools to handle all sorts of data. As a self-contained, file-based database SQLite is ease...

Read More
on in MySQL

If we look at for the first time, then it seems like TEXT and VARCHAR can store the same information. But, there are fundamental differences between the two. The way TEXT fields and VARCHAR fields work are imperative to take into consideration. VARCHAR is actually the part of the ISO SQL: 2003 standard whereas The...

[ Click to Continue ]
on in NoSQL Uncategorized

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 query systems as well as over 15 years of gained expertise in executing and designing query languages for data that...

[ Click to Continue ]
on in Software

Firstly we need to know that what a programming language is. Group of instructions is known as program. Any language for expressing a set of detailed instructions for a digital computer is a programming language. A programming language is designed to help process certain kinds of data consisting of numbers characters and strings and to...

[ Click to Continue ]
on in NoSQL

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 is CouchDB. If you are the one to care about the data and most of the time having the data...

[ Click to Continue ]
on in Software

The tutorial discussed below provides with all the necessary skills that are required to work with a software project. In this tutorial we shall learn about undoing the last Git commit. At any stage you may arrive with a query in mind of undoing something. This is a human tendency which makes up the mind...

[ Click to Continue ]
on in NoSQL

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...

[ Click to Continue ]