NoSQL databases disrupted the orderly world of relational database management systems (RDBMS). These databases offered tremendous scope for scaling, economy and flexibility, compared to the rigidity of RDBMSs. However, in a world overflowing with data, both have their place. This article will point you in the right direction when it comes to a choice.
In the planet of database technology, there are two main types of databases: SQL and NoSQL—or, relational databases and non-relational databases. The differences are mainly in how they’re built, the type of information they store and how they store it. Relational databases are structured like phone books that store phone numbers and addresses. Nonrelational databases are document-oriented and distributed, like file folders that hold everything from a person’s address and phone number to their Facebook likes and online shopping preferences. We call them SQL and NoSQL.
The rise of RDBMSs
In 1970, E.F. Codd envisioned a new model of DBMS through his paper titled, ‘A Relational Model of Data for Large Shared Data Banks’, which paved the way for the emergence of relational DBMSs (RDBMSs).
-- RDBMSs formulated a new methodology for storing data and processing large databases.
-- The records (data) would be stored in ‘tables’ with fixed-length records, unlike the free-form list of linked records in an IDS (Integrated Data Store) and IMS (Information Management System).
-- Later, databases like Ingres, and a query language like SQL evolved. The nuances and benefits of RDBMSs had a wide impact, resulting in buy-in from different vendors and setting the stage for an era of the database wars.
Many RDBMSs such as Sybase, Microsoft SQL Server, Informix, MySQL, DB2 and Oracle got launched around the same time, each claiming to be better in terms of:
-- Performance
-- Availability
-- Functionalities
-- Cost of storage
-- Economy of usage
With no competition, RDBMSs got completely entrenched in the IT ecosystem by the early 2000s.
The evolution of NoSQL
This story is from the March 2018 edition of Open Source For You.
Start your 7-day Magzter GOLD free trial to access thousands of curated premium stories, and 8,500+ magazines and newspapers.
Already a subscriber ? Sign In
This story is from the March 2018 edition of Open Source For You.
Start your 7-day Magzter GOLD free trial to access thousands of curated premium stories, and 8,500+ magazines and newspapers.
Already a subscriber? Sign In
The Crucial Role of Open Source in Advancing Blockchain Technology
Open source and blockchain technology are like soulmates, forging connections, building bridges, and working together to create a future that is more open, inclusive, and equitable.
Why Open Source Dependencies Must be Managed
Unmanaged reliance on open source software may result in a Support crisis over a project’s life span, as well as financial loss for the organisation. Planned and regular upgrades of open source software components are a must.
Why Cloud Security Alone is Not Enough for Enterprises
Traditional and off-the-shelf security tools for the cloud may lull organisations into a false sense of being safe from cyber threats. This first article in the two-part series explains why organisations must develop an enterprise cloud security governance strategy’.
Openchain: Revolutionising Supply Chain Management
Openchain’s unique features cater specifically to enhancing supply chain management. This distributed ledger technology is helping to build a future where supply chains are more transparent, efficient, and secure.
Open Source, Private and Public Blockchain Platforms: What They Offer
Open source platforms play a crucial role in driving innovation and democratising access to blockchain technology. These platforms promise to have a significant impact on the future of society by offering a range of benefits.
Why Choose Hyperledger Sawtooth?
Hyperledger Sawtooth has earned a formidable reputation as a champion of modularity in the realm of enterprise blockchains. We delve into its components and functionalities, as well as the advantages it offers businesses seeking custom-crafted blockchain solutions.
Hyperledger Fabric: What You Should Know and Why
Understanding the essential features of Hyperledger Fabric is crucial for anyone looking to develop blockchain applications for enterprise use. These features provide the foundation for building secure, scalable, and privacy-focused applications, and can be leveraged to create innovative solutions that address real-world business challenges.
The Metaverse and Blockchain Technology: What the Future Holds
The integration of the metaverse with blockchain technology has opened exciting possibilities for managing digital assets in virtual environments. As virtual worlds become increasingly immersive and interconnected, the need for secure and efficient asset management solutions has never been greater.
Machine Learning Basics for a Newbie
Machine learning is a vast and rapidly evolving field, and this article serves as a stepping stone for those new to the domain. Explore the fundamental concepts of machine learning, from understanding the differences between traditional programming and ML to delving into various types of machine learning algorithms.
Human-AI Collaboration is the Future
Al-augmented decision making is making a transformative impact across various fields, benefiting a range of industries.