New Generation Databases
Year 2015 will be a milestone year for RTS when we shall scale new heights in product development and quality deliverables and so it is a great honour to be first on the list to write a blog for RTS in this new year. It gets me really excited to share information about an upcoming technology I am passionate about “new generation databases”.
We all know about databases – a very interesting piece of technology, to store large amounts of information – textual, numeric, pictures, even videos – do on demand retrieval and use at a later time. Traditional databases like Oracle, MSSQL Server etc. provide long-term data storage to computer software – everything from mobile phone app to a large enterprise application involving many interconnected computers. They can handle many operations (such as filtering and sorting data, logging, roll back, secure processing of data in a multi user environment etc) at database end However there is a big constraint, in order to set up these traditional databases we need to have professional expertise in SQL (Structured Query Language). SQL as a language is different from the language in which applications are developed so an extra effort is required to achieve that seamless integration between application code and database.
Solution to this has come in the form of new generation (no/new sql) databases which explore a new way of data storage. Objects and information are stored more directly – using library functions and objects from the language used to develop applications. An age old notion has been challenged that only “relational databases should be used”, making them immensely popular among developer community.
New generation (no/new sql) databases are designed in a way so that maximum processing is handled by the application. Like traditional database solutions they do not apply many restrictions on how to store data. They just save what is provided by the application making them highly-optimized for data storage and retrieval thus providing excellent performance. Best part, most of it is open source, no hefty licence fees required or no yearly renewals either, so a lot of cost saving too.
Key Strengths of No/New SQL Databases:
- Can be used to store highly variable data structures, and even unstructured data.
- Accessible from the language as used in application
- Fast storage and retrieval
But do our new generation databases suit every application? No, not as of now. They are good in scenarios where less number of users make very large changes to data at different times, where success of “transactions” may not be guaranteed or when a high level of isolation between the data storage and the running applications is not desired.
If there is problem, there is a solution too Using an entirely new level of innovation and engagement, a mix of relational and new generation (No/New SQL) databases is already being implemented across the technology world with great success.
Combining the best from relational databases (Stability, Security and Suitability) with best from new generation databases (Speed, Savings and Schema less) many organizations have transformed the way we experience technology.
In coming times, in order to develop data rich applications, as No/New SQL solutions become more mature and popular, they would certainly provide an increasingly logical choice for application development and business growth.
Please share your views on how you feel would No/New SQL databases impact our choice for databases in future.