Building a Data Pipeline Using QuestDB and Confluent Kafka

A data pipeline, at its base, is a series of data processing measures that are used to automate the transport and transformation of data between systems or data stores. Data pipelines can be used for a wide range of use cases in a business, including aggregating data on customers for recommendation purposes or customer relationship … Read more

String Data to Empower Your Similarity Search App

Milvus 2.1 comes with some significant updates, which make working with Milvus a lot easier. One of them is the support of string data type. Right now, Milvus supports data types including strings, vectors, Boolean, integers, floating-point numbers, and more. This article presents an introduction to the support of string data type. Read and learn … Read more

Paradigm Shift for Relational Database Schema

The relational database model was first proposed by English computer scientist Edgar Frank Codd in 1070 while working at IBM and has been commercially for over forty years. It’s a rare achievement in software development that continues to evolve today. Relational databases generally serve as backends for the smallest to the largest apps and products … Read more

Data Mining vs Data Warehousing

Data mining and warehousing are two processes essential for any organization that wants to be recognized on a global or national level. Both techniques help prevent data fraud and improve managerial statistics and rankings. Data mining is used to detect significant patterns by relying on the data gathered during the data warehousing phase. Data mining … Read more

Data Mining and Data Warehousing

Data mining and warehousing are two processes essential for any organization that wants to be recognized on a global or national level. Both techniques help prevent data fraud and improve managerial statistics and rankings. Data mining is used to detect significant patterns by relying on the data gathered during the data warehousing phase. Data mining … Read more

Pitfalls: Should We Have a Constructor on JPA?

The data in any modern and distributed architecture, such as microservices, work as a vein in a system. It fits like a state in a stateless application. On the other hand, we have the most popular paradigms in the code, especially when we talk about enterprise OOP. How do you combine both archive and software … Read more

Will a Graph Database Solve Your Problem?

One of the greatest questions to consistently badger a developer is “what technology should I use?””. Days of thought and analysis determines which option(s) (from an growing number) best suits the need, manages volume and demand, plans for long-term strategy, simplifies/reduces support, and gets approved by colleagues and management. Those steps may even seem easy … Read more

Data Model Tracing, Reporting: Relational Database

In relational databases, data is stored on tables created with a certain model and relationship network. Especially in systems that are not fully mature yet, changes in data models occur frequently and they make it difficult to control data and data models in terms of integrity, consistency, and granularity. This necessitates control mechanisms that will … Read more

From Relational to Really Relational: The RDB2RDF Working Group

While a lot of databases have been created listing information in a table format, the web isn’t set up in a tabular style. Neither is plenty of data in a variety of formats that the web uses. However, many databases are still using tables, because many web developers feel that tables handle plenty of data … Read more

When to Use JSON in Your Database

In this article, you will learn when you should consider adding JSON data types to your tables and when you should avoid it. Most relational database technologies can now store JSON data and perform queries on it. The introduction of the JSON data type to relational databases represented a turning point and opened up many … Read more