Data warehouses play a crucial role in today's data-intensive operations. However, the physical infrastructures required for Big Data are increasingly being jettisoned in favour of more agile solutions. Logical data warehouses add a virtual … Read more
Database
Distributed Cache: How to Boost System Responsiveness
Distributed cache can improve the responsiveness of today's high-performance web and mobile apps. At heart it's a simple concept, but, when used well, it can bring improved capacity and flexibility to networked systems. As well as classic caching … Read more
How to Guide: Asynchronous Batching for Stampede Prevention
A cache stampede can occur when web servers face very high loads. To maintain the efficiency of backend services, caching is vital. But if the caching mechanism comes under intense strain, slow performance and even failure can occur. While there are … Read more
How To Migrate and Manage Your Databases with Cloud Data Management
Keeping your data under control is vital if you want to extract the most value possible from it. For this reason, many organizations are embracing cloud data management. But before migrating your data and applications to the cloud, there are … Read more
10 Commonly Used SQL Commands For Solid Databases
Structured Query Language (SQL) databases have a long history of reliability. That’s why, despite being invented in the 1970s, they are still in use today. By inputting SQL commands, a user can gain instant access to data records. Over the … Read more
Data Lake vs. Data Warehouse: Which to Use?
In 2022, businesses and other organizations face any number of operational challenges. From choosing the right type of business contract to implementing more effective remote working protocols, there’s a lot to think about. But perhaps the most … Read more
Case Study: Implementing the Actor Model for Managing Huge Amounts of Data
Introduction MSC's core business relies heavily on data that describes every single event related to shipping, vessels, and containers. This data needs to be shared quickly and efficiently with other systems that have a similar near-live time flow … Read more
Will NoSQL Survive Big Data?
The amount of data companies need to process has been increasing steadily over the years, and this has created an issue known as big data. Recently, lots of services and analytical applications that are based on big data have emerged. Since users … Read more
C++ to Microservices: Back-end Migration to Continuous Integration
What is Lyra? Lyra is a state-of-the-art solution for managing payments and liquidity. It receives all payment operations (money moving from one bank to another) and communicates with European settlement systems, while maintaining an up-to-date … Read more
Identifying and Resolving SQL Server Index Fragmentation
In this SQL technology guide, we explore how to spot and resolve Index Fragmentation in SQL Server. As administrators will know, identification of Index fragmentation and maintenance of the same are crucial elements in database maintenance. MS SQL … Read more
CI/CD Automation for Fn Project with Oracle FaaS and Developer Cloud Service
This article written by Shay Shmeltzer, Director of Product Management at Oracle, was originally published on Oracle Developers Portal. By this time you will probably have seen multiple blogs about the Fn Project - an open-source, … Read more
Use Azure SQL database in your web app
In a previous article, we described how to create an Azure Web App for your web application from scratch. This article explains how to add an Azure SQL database to an app and manage it through the Azure Portal. To complete these steps, you will need … Read more
System Administrator’s DOs and DON’Ts: interview with Kenneth Hess
It is quite clear that the most important skill for a System Administrator to have is problem solving. As a result, it can be a very stressful job, especially when there is little time to analyse the problem and find a solution. A lot depends on this … Read more
NewSQL: overcoming limitations of relational and NoSQL databases
Technologies behind databases have never been so variegated as today. After the rise of relational SQL-based databases, new needs have emerged, with the consequences of fostering a plethora of new database models, e.g. the NoSQL ones. Today, new … Read more