Repost 10 things you need to know about nosql Databases

1. Maturity

RDBMS has existed for a long time. nosql supporters think that their age is a symbol of their out-of-date, but for most CIOs (CIOs), the maturity of RDBMS can be reassuring. generally, RDBMS systems are stable and feature-rich. in contrast, most nosql alternatives are still in the pre-production environment stage, and there are a lot of key features to be implemented.

Living at the cutting edge of technology is exciting for most developers, but enterprises must be very cautious when implementing it.

2. Support strength

Enterprises also want to ensure that they can get timely and effective support when key systems fail. All RDBMS providers are doing their best to provide high-level support for enterprises.

In contrast, most nosql systems are open-source projects. Although every nosql database usually has one or more companies providing support for it, these companies are usually small start-up companies, unable to provide global support, insufficient support resources, or lack of credit similar to Oracle, Microsoft, or IBM.

3. Analysis and Business Intelligence

Nosql databases have evolved to meet the expansion needs of modern Web 2.0 applications. Correspondingly, most of their feature sets are designed to meet the needs of these applications. HoweverProgramThe value of data in is beyond the period of insertion, reading, update, and deletion of a typical web application. mining information from the company's database to improve the company's efficiency and competitiveness, as well as business intelligence (BI) is a key issue for all large and medium-sized companies.

Nosql databases provide new tools for Real-Time query and analysis. Even a simple query requires considerable programming skills. Generally, the Bi tools used cannot access nosql databases.

A little comforting is that there are also solutions similar to hive and pig, through which you can easily access the data in the hadoop cluster, maybe eventually, you can easily access other nosql databases. quest software company developed a product, toad for cloud database, which provides real-time query functions for a variety of nosql databases.

4. Management

Nosql may be designed to provide a zero-management solution. However, the reality is that this goal is far from achieved. the current nosql system requires a lot of skills for installation and a lot of effort for maintenance.

5. Professional Skills

Frankly speaking, millions of programmers in the world are very familiar with the principles and programming of RDBMS, which are distributed in various business scenarios. in comparison, almost every nosql developer is still in the learning stage. as time passes, this situation will be solved, but now it is much easier to find an experienced RDBMS developer and RDBMS administrator than to find a nosql expert.

Conclusion

Nosql databases are becoming an important part of more and more database environments. if used properly, they can provide tangible benefits. however, enterprises need to be cautious when promoting their use and understand the internal limitations and problems related to these databases.

About the author

Guy Harrison is the director of the R & D department of Quest software. well-known database experts have over 20 years of experience in application and database management, performance tuning, and software development. Guy has published many books on database technology and published a large number of related books.ArticleAnd often give speeches at technical meetings.