Analytics Vidhya

FEBRUARY 2, 2023

Introduction SQL injection is an attack in which a malicious user can insert arbitrary SQL code into a web application’s query, allowing them to gain unauthorized access to a database. We can use this to steal sensitive information or make unauthorized changes to the data stored in the database.

Database 204

Database SQL Coding Accessible 204

KDnuggets

JUNE 28, 2024

Explore the world of modern databases that are fast, secure, and cost-efficient, designed to tackle large-scale and diverse data challenges.

Database 125

Database SQL Designing Data 125

KDnuggets

OCTOBER 18, 2023

Cloud databases have made it easier and cheaper to develop enterprise-level applications, offering flexibility, convenience, and standard database functionality. See what KDnuggets recommends.

Database 133

Database Cloud IT Data Engineering 133

Data Engineering Podcast

FEBRUARY 25, 2024

Summary Building a database engine requires a substantial amount of engineering effort and time investment. In this episode he explains how he used the combination of Apache Arrow, Flight, Datafusion, and Parquet to lay the foundation of the newest version of his time-series database.

Database 162

Database Technology Data Lake High Quality Data 162

KDnuggets

MARCH 5, 2024

Looking to learn SQL and databases to level up your data science skills? Learn SQL, database internals, and much more with these free university courses.

SQL 135

SQL Database Data Science Data 135

KDnuggets

OCTOBER 4, 2022

Among the four big NoSQL database types, key-value stores are probably the most popular ones due to their simplicity and fast performance. Let’s further explore how key-value stores work and what are their practical uses.

Database 158

Database NoSQL SQL 158

Data Engineering Podcast

AUGUST 27, 2023

In the era of the cloud most developers rely on hosted services to manage their databases, but what if you are a cloud service? Learn more about Datafold by visiting dataengineeringpodcast.com/datafold You shouldn't have to throw away the database to build with fast-changing data. With Materialize, you can!

Database 130

Database Building PostgreSQL BI 130

Towards Data Science

MAY 11, 2024

When architecting a transactional database or a data warehouse, it’s important not to forget about various types of technical columns… Continue reading on Towards Data Science »

Database Design 87

Database Design Database Designing Data Warehouse 87

KDnuggets

SEPTEMBER 8, 2023

Understand the relevance of databases in data science. Also learn the fundamentals of relational databases, NoSQL database categories, and more.

Database 118

Database Data Science NoSQL Relational Database 118

Hevo

DECEMBER 26, 2023

Databases are the cornerstone of almost all business projects. As a result, organizations should focus on designing superior databases to meet the objectives of projects without losing direction. Consequently, Database Schema Design Examples and the Database Schema Example have […]

Designing 98

Designing Database Project Systems 98

Towards Data Science

MARCH 7, 2024

With over two decades in Data Engineering, I’ve uncovered a secret to clear and consistent database columns: classwords. This favorite… Continue reading on Towards Data Science »

Database 91

Database Data Science Data Engineering Data Engineer 91

KDnuggets

SEPTEMBER 12, 2023

This blog discusses vector databases, specifically pinecone vector databases. A vector database is a type of database that stores data as mathematical vectors, which represent features or attributes. These vectors have multiple dimensions, capturing complex data relationships.

Database 109

Database Machine Learning Data Analysis Systems 109

Pinterest Engineering

JANUARY 4, 2024

While KVStore was the client facing abstraction, we also built a storage service called Rockstorewidecolumn : a wide column, schemaless NoSQL database built using RocksDB. Additionally, the last section explains how this new database supports a key platform in the product. All names, addresses, phone numbers are illustrative/not real.

Database 86

Database Building Datasets Relational Database 86

Hevo

JULY 3, 2024

If you need to lower your expenses, optimize speed, or avoid vendor lock-in, PostgreSQL offers excellent open-source database solutions. Have you considered moving to PostgreSQL yet? Do you need to know what you should do? However, the whole conversion might appear scary. Luckily, there are necessary tools that can improve our lives.

Database 52

Database PostgreSQL Systems Management 52

KDnuggets

MAY 30, 2022

Interested in a survey of important database concepts and terminology? This post concisely defines 16 essential database key terms.

Database 133

Database Data Science Data 133

KDnuggets

MAY 21, 2024

Get started with SQLIte databases in Python using the built-in sqlite3 module.

Database 122

Database Python 122

KDnuggets

NOVEMBER 2, 2023

We will explore their use cases, key features, performance metrics, supported programming languages, and more to provide a comprehensive and unbiased overview of each database.

Database 113

Database Programming Language Programming 113

KDnuggets

OCTOBER 20, 2023

Start learning today with CS50 SQL, a free course on databases with SQL from Harvard. Want to learn SQL the Harvard way?

SQL 134

SQL Database 134

KDnuggets

NOVEMBER 17, 2023

The top vector databases are known for their versatility, performance, scalability, consistency, and efficient algorithms in storing, indexing, and querying vector embeddings for AI applications.

Database 124

Database Algorithm 124

Hevo

JUNE 26, 2024

Many organizations often ponder if Snowflake, a modern data analytics platform, is a data warehouse or database. Data warehouse and database are two key components of Snowflake’s architecture. Both play distinct but complementary roles, helping you store, process, and analyze data efficiently.

Database 40

Database Data Warehouse Architecture Data Analytics 40

Monte Carlo

JUNE 24, 2024

Domain integrity is a group of restrictions a database follows to ensure that the data it contains is accurate and consistent. For example, if I have an INT column in a SQL database, it will only accept whole number integers. When creating a database table, each column of data needs to have a type.

Database 52

Database MySQL SQL Datasets 52

KDnuggets

NOVEMBER 6, 2023

Graph databases are quickly becoming a core part of the analytics toolset for enterprise IT organizations. If you know SQL, you can easily learn Cypher and open up a huge opportunity for data analysis.

Database 108

Database Data Analysis SQL Data 108

Knowledge Hut

MARCH 27, 2024

Think of a database as a smart, organized library that stores and manages information efficiently. In simpler terms, a database is where information is neatly stored, like books on shelves, while data structures are the behind-the-scenes helpers, ensuring data is well-organized and easy to find. What is a Database?

Database 52

Database Relational Database Algorithm PostgreSQL 52

KDnuggets

AUGUST 14, 2023

Vector databases enable fast similarity search and scale across data points. For LLM apps, vector indexes can simplify architecture over full vector databases by attaching vectors to existing storage. Choosing indexes vs databases depends on specialized needs, existing infrastructure, and broader enterprise requirements.

Database 99

Database Python Architecture Data 99

Hevo

SEPTEMBER 28, 2023

Row store and Column store databases are two different approaches to retrieve and store data from Database Management Systems (DBMS). Both databases are appropriate for many use cases, and each has unique qualities.

Database 52

Database Systems Process Management 52

Knowledge Hut

DECEMBER 28, 2023

Automation is important in handling large databases. If your CI/CD pipelines are not extended to the databases, a wide range of technical problems may arise. The collaboration between developers and database executives could be facilitated using certain strategies, which lays the stage for database DevOps.

Database 52

Database Banking Coding Technology 52

KDnuggets

MARCH 16, 2023

Learn about NoSQL Databases and their types like key-value, document, graph and column family with their use cases.

NoSQL 117

NoSQL Database SQL 117

Confluent

NOVEMBER 2, 2021

What will the next important category of databases look like? For decades, relational databases were the undisputed home of data. They powered everything: from websites to analytics, from customer data […].

Database 115

Database Systems Relational Database Data 115

Cloudyard

JANUARY 1, 2023

Read Time: 4 Minute, 18 Second During this post we will discuss the significance of Database role in snowflake. This Role is authorized to have access on Database SALES_DB, Schema inside the DB, and all respective tables. These Roles require access to the SALES_DB database. Eventually,Grant DB role to Account Role.

Database 52

Database Accessible Accessibility Process 52

Seattle Data Guy

DECEMBER 19, 2022

Data analysts, data scientists, engineers, and managers all require a robust data storage solution for… Read more The post Data warehouses vs Data Lakes vs Databases – Which One Do You Need appeared first on Seattle Data Guy.

Data Lake 130

Data Lake Data Warehouse Database Data Storage 130

KDnuggets

NOVEMBER 13, 2023

This week, we delve into the vital world of Databases, SQL, Data Management, and Statistical Concepts in Data Science. Welcome back to Week 2 of KDnuggets’ "Back to Basics" series.

Database 115

Database SQL Data Management Management 115

KDnuggets

SEPTEMBER 16, 2022

Get up to speed on SQL and relational databases with this free video course.

SQL 136

SQL Database Relational Database 136

Knowledge Hut

DECEMBER 28, 2023

The answer lies within databases. That is precisely what a database offers— a secure location. "Once "Once the business data have been centralized and integrated, the value of the database is greater than the sum of the preexisting parts." What are Database Management Tools? But where does it all reside?

Database 52

Database MySQL SQL Relational Database 52

Rock the JVM

APRIL 24, 2024

Introduction In modern application development, efficient database interactions are crucial for building scalable and maintainable systems. One such powerful tool among others ( Doobie , Slick , Quill etc) is the Skunk Scala library , which provides a functional and typesafe interface for PostgreSQL databases access in Scala applications.

Scala 57

Scala Database PostgreSQL SQL 57