As a beginner, it is essential to understand the two most commonly used types of databases: SQL and NoSQL. In this article, I have tried my best to provide a comprehensive guide that will help beginners to understand the differences between SQL and NoSQL, their use cases, and the scenarios in which they perform better than the other. The information here will provide you with an overview of SQL and NoSQL databases and highlight the advantages and disadvantages of each. By the end of this article, you will be able to make an informed decision on which type of database to use for your project. W ..read more

Today I have one of those moments where I am absolutely sure if I do not write this down, I will forget how to do this next time. For one of the projects I am working on, we need to do SHACL validation of RDF data that will be stored in Ontotext GraphDB. Here are the 10 things I needed to learn in doing this. Some of these are rather obvious, but some were less than obvious to me. Number 1: To be able to do SHACL validation, your repository needs to be configured for SHACL when you create your repository. This cannot be done after the fact ..read more

This is an article from DZone's 2023 Software Integration Trend Report. For more: Read the Report A microservices architecture is an established pattern for building a complex system that consists of loosely coupled modules. It is one of the most talked-about software architecture trends in the last few years. It seems to be a surprisingly simple idea to break a large, interdependent system into many small, lightweight modules that can make software management easier.  ..read more

ClickHouse is an open-source real-time analytics database built and optimized for use cases requiring super-low latency analytical queries over large amounts of data. To achieve the best possible performance for analytical applications, combining tables in a data denormalization process is typical. Flattened tables help minimize query latency by avoiding joins at the cost of incremental ETL complexity, typically acceptable in return for sub-second queries.  However, denormalizing data isn't always practical for some workloads, for instance, those coming from more traditional data warehous ..read more

Modern technology has made communication easier than ever before. From smartphones to other smart devices, we can use a single gadget to accomplish a lot. However, have you ever wondered what makes it all possible? It's the microscopic chip circuits supported by powerful protocols and standards. Over the past two decades, the technology industry has revolutionized the way we see the world. Today, we use IoT devices that can communicate not only with us but also with other smart devices. This is all thanks to the continuous improvement of communication and networking protocols such as WiFi, Eth ..read more

At AISPEECH, we provide conversational AI services and natural language interaction solutions for a wide range of entities, including financial institutions, the government, and IoV and IoT companies. If you believe in the idea that big data is the fuel for artificial intelligence, you will see how important a performant data processing architecture is for us. In this post, I am going to share with you what data tools and techniques we use to power our AI services. Real-Time vs. Offline: From Separation to UnityBefore 2019, we used Apache Hive + Apache Kylin to build our offline data warehouse ..read more

This article compares QuestDB with one of the most popular databases on the market, MongoDB. We look at the two databases in terms of benchmark performance and user experience. Time-series data has gained popularity in recent years. It is used in a wide variety of industries and use cases (if you are new to this space, read our article 'What is Time-Series Data'). As a result, we have seen the emergence of new time-series databases, either purposefully built to handle time-series data, or as an additional functionality on top of a general-purpose database. Time series data is often processed w ..read more

Overview If you have ever downloaded a new Linux distribution ISO image, you may have wondered how to access the contents inside the image prior to repartitioning your disk and installing the operating system onto your local disk. This can be done via a loop mount in Linux. In Linux and other UNIX-like systems, it is possible to use a regular file as a block device. A loop device is a virtual or pseudo-device which enables a regular file to be accessed as a block device. Say you want to create a Linux file system but do not have a free disk partition available. In such a case, you can create a ..read more

So, you have been performing cross-browser testing to help eliminate any discrepancy around cross-browser compatibility, but have you ever pondered upon the cause of it? Why would your website look different from one browser to another? What lies at the center of these browser incompatibility issues? The answer, my friend, is browser engines. You may be familiar with the term if you have been a developer or a website tester. A browser engine interprets the HTML, CSS, and JavaScript code of your website and presents it in front of your audience. You are able to see this post because of the brow ..read more

Lately, I've come across a lot of discussions and articles about Spring's feature called Profiles that are promoting them as a way to separate environment-specific configurations, which I consider a bad practice. Common Examples The typical way profiles are presented is by having multiple configuration files within the resources folder that will be bundled within the application artifact with application-prod.yml like ..read more