Analytics Vidhya

AUGUST 30, 2023

Introduction In the bustling arena of database management systems, two heavyweight contenders emerge, each carrying its arsenal of features and capabilities. In one corner, we have the suave and sophisticated Microsoft SQL Server (MSSQL), donned in the elegance of enterprise-level prowess.

MySQL 228

MySQL Database SQL Systems 228

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

Striim

NOVEMBER 19, 2024

SQL2Fabric Mirroring is a new fully managed service offered by Striim to mirror on premise SQL Databases. It’s a collaborative service between Striim and Microsoft based on Fabric Open Mirroring that enables real-time data replication from on-premise SQL Server databases to Azure Fabric OneLake. Striim automates the rest.

SQL 52

SQL Database Data Warehouse Data Pipeline 52

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. Data lakes are notoriously complex.

Database 162

Database Technology Data Lake High Quality Data 162

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 113

Database Data Science NoSQL Relational Database 113

Seattle Data Guy

DECEMBER 19, 2022

By Reseun McClendon Today, your enterprise must effectively collect, store, and integrate data from disparate sources to both provide operational and analytical benefits. Whether its helping increase revenue by finding new customers or reducing costs, all of it starts with data.

Data Lake 130

Data Lake Data Warehouse Database Data Storage 130

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 144

Database Cloud IT Data Engineering 144

Data Engineering Podcast

AUGUST 27, 2023

Summary Data persistence is one of the most challenging aspects of computer systems. In the era of the cloud most developers rely on hosted services to manage their databases, but what if you are a cloud service? It’s the only true SQL streaming database built from the ground up to meet the needs of modern data products.

Database 130

Database Building PostgreSQL BI 130

Hevo

NOVEMBER 11, 2024

Designing a database is similar. We use three main data models (conceptual, logical, and physical model) to ensure the design aligns with project goals, […] You would first need to create a high-level design. Next, you would create detailed plans for each floor. Lastly, you would choose the building materials and methods.

Database 52

Database Designing Data Project 52

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 138

SQL Database Data Science Data 138

KDnuggets

SEPTEMBER 13, 2024

Learn how to install ClickHouse DBMS, create a database, and run SQL queries using native and Python clients.

Database 103

Database SQL Python Data Engineering 103

Knowledge Hut

MARCH 27, 2024

Think of a database as a smart, organized library that stores and manages information efficiently. On the other hand, data structures are like the tools that help organize and arrange data within a computer program. What is a Database? SQL, or structured query language, is widely used for writing and querying data.

Database 52

Database Relational Database Algorithm PostgreSQL 52

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 81

Database Design Database Designing Data Warehouse 81

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. Individual rows constitute a dataset.

Database 93

Database Building Datasets Relational Database 93

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 121

Database SQL Designing Data 121

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 85

Database Data Science Data Engineer Data Engineering 85

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

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 104

Database Machine Learning Data Analysis Systems 104

KDnuggets

MAY 30, 2022

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

Database 144

Database Data Science Data 144

Start Data Engineering

JULY 18, 2020

Given Source database connection details (endpoint, port, username, password and database name) Source table to replicate destination schema name run frequency can be set to 10min We are assuming the destination data warehouse is already setup in stitch. Steps Log into your stitch account.

Data Warehouse 100

Data Warehouse Database PostgreSQL Data 100

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 110

Database SQL Data Management Management 110

Data Engineering Podcast

AUGUST 6, 2021

Summary Every organization needs to be able to use data to answer questions about their business. The trouble is that the data is usually spread across a wide and shifting array of systems, from databases to dashboards. Are you bored with writing scripts to move data into SaaS tools like Salesforce, Marketo, or Facebook Ads?

Database 100

Database SQL BI Business Intelligence 100

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 121

Database Systems Relational Database Data 121

Monte Carlo

NOVEMBER 28, 2023

Not only are there a lot of ways data downtime can strike, but there are a lot of places it can strike too. One of the increasingly common infiltration points is when data is being synced across databases. Data consistency suffers as multiple values for the same metric begin to propagate across the organization.

Database 59

Database Data Warehouse Machine Learning Data 59

Data Engineering Podcast

DECEMBER 11, 2022

Summary One of the most critical aspects of software projects is managing its data. Managing the operational concerns for your database can be complex and expensive, especially if you need to scale to large volumes of data, high traffic, or geographically distributed usage.

Database 100

Database MySQL Data Lake MongoDB 100

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

Monte Carlo

MARCH 6, 2024

If you’ve been keeping track of our integrations page you might have noticed Monte Carlo is adding support for different databases faster than a nested loop server crash. By the end of 2023, we added Azure SQL database to the list as well as enterprise databases such as Oracle DB , SAP HANA and Teradata.

Database 52

Database MySQL Data Warehouse Architecture 52

Data Engineering Podcast

MAY 8, 2022

Summary Many of the events, ideas, and objects that we try to represent through data have a high degree of connectivity in the real world. TigerGraph is a leading database that offers a highly scalable and performant native graph engine for powering graph analytics and machine learning. Missing data? Stale dashboards?

Database 100

Database Data Lake BI Business Intelligence 100

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 104

Database Data Analysis SQL Data 104

Data Engineering Podcast

MARCH 5, 2022

Summary When you think about selecting a database engine for your project you typically consider options focused on serving multiple concurrent users. Sometimes what you really need is an embedded database that is blazing fast for single user workloads. And don’t forget to thank them for their continued support of this show!

Database 100

Database Data Lake Java Data Engineer 100

Data Engineering Podcast

MAY 29, 2022

Summary A large fraction of data engineering work involves moving data from one storage location to another in order to support different access and query patterns. Singlestore aims to cut down on the number of database engines that you need to run so that you can reduce the amount of copying that is required.

Database 100

Database Architecture Data Architecture PostgreSQL 100

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

KDnuggets

SEPTEMBER 13, 2023

Getting Started with SQL in 5 Steps • Introduction to Databases in Data Science • Time 100 AI: The Most Influential?

Data Science 144

Data Science Database SQL Data 144

Cloudera

NOVEMBER 23, 2021

What is Cloudera Operational Database (COD)? Operational Database is a relational and non-relational database built on Apache HBase and is designed to support OLTP applications, which use big data. The operational database in Cloudera Data Platform has the following components: .

Database 90

Database Non-relational Database NoSQL Government 90