Knowledge Hut

MARCH 15, 2024

Making decisions in the database space requires deciding between RDBMS (Relational Database Management System) and NoSQL, each of which has unique features. Come with me on this adventure to learn the main differences and parallels between two well-known database solutions, i.e., RDBMS vs NoSQL. What is RDBMS?

NoSQL 52

NoSQL Database-centric Relational Database PostgreSQL 52

Grouparoo

MAY 13, 2021

In this post, we’ll look at the historical reasons for the 191 character limit as a default in most relational databases. The first question you might ask is why limit the length of the strings you can store in a database at all? Why varchar and not text ? s fault 255 makes a lot more sense than 191. How did we get to 191?

Database 52

Database Bytes MySQL Database-centric 52

Confluent

JUNE 18, 2019

As the databases professor at my university used to say, it depends. Using SQL to run your search might be enough for your use case, but as your project requirements grow and more advanced features are needed—for example, enabling synonyms, multilingual search, or even machine learning—your relational database might not be enough.

Architecture 97

Architecture Building Kafka Database-centric 97

François Nguyen

MARCH 22, 2021

To illustrate that, let’s take Cloud SQL from the Google Cloud Platform that is a “Fully managed relational database service for MySQL, PostgreSQL, and SQL Server” It looks like this when you want to create an instance. You are starting to be an operation or technology centric data team.

Technology 130

Technology Architecture Google Cloud Metadata 130

ProjectPro

MARCH 19, 2015

Big Data NoSQL databases were pioneered by top internet companies like Amazon, Google, LinkedIn and Facebook to overcome the drawbacks of RDBMS. There is a need for a database technology that can render 24/7 support to store, process and analyze this data. Table of Contents Can the conventional SQL scale up to these requirements?

NoSQL 49

NoSQL Big Data SQL Database-centric 49

ProjectPro

SEPTEMBER 11, 2021

RUP is a procedure of software development that is “iterative, architecture-centric, and use-case driven” The RUP method involves listing requirements as use cases, which helps keep track of value to the lone business stakeholders for each piece of serviceability. What is a database cursor? What is the RUP method?

Business Analyst 52

Business Analyst Database-centric MySQL SQL 52

ProjectPro

JULY 30, 2021

Compared to Cloud computing, Mobile computing is more customer-centric. Use cases are in-memory caches and open-source databases. They get used in NoSQL databases like Redis, MongoDB, data warehousing. Aurora is the database engine that gives reliability and speed at par with industry-standard databases.

Cloud Computing 40

Cloud Computing Cloud Amazon Web Services AWS 40