All posts by mila.bakhmat

How to Make Your Hotel Mobile App Successful

Developing a high-quality mobile app is a necessary step for your hotel business. This will increase your customer base, because you will be giving potential visitors practicality and convenience. Those can only be achieved with a good mobile application. Mobile apps forecasts are promising with expected revenue of $189 billion in 2020.

Hotel Mobile App Development Recommendations

Top tech trends for hotel apps

First of all, your app needs a logical and simple layout. You don’t need big words and complicated functions: the simpler the app, the more convenient it is for your visitors and employees. It’s a good idea to have the app design resemble the visual style of your hotel. 

After that you will need to fill your layout with the functions that you provide at your hotel. For example, the “order room service” or “call maid” buttons. You also need to create a gallery with photos of the rooms and staff. Having photographs of hotel room details for a mobile application is necessary. 

Secondly, your application needs the “book a room” function. A simple booking form is preferable.

Thirdly, mobile check-in allows the built-in calendar to calculate the days of stay at the hotel, similar to short-term rental services.

And of course, your application must have a “leave feedback” function. This way, your future customers will be able to form an opinion about your hotel, and you will be able to improve the weak points, if there are any.

What is a hotel mobile app used for?

Wondering what is a hotel property management system (PMS) for your business? First of all, it is a good marketing move. 

For the customer, a hotel’s mobile application is a real opportunity to quickly book a room without leaving their home or car. In the modern world, when everyone is glued to their smartphones, people are not used to making calls anymore. 

It’s easier for visitors to just download your application and select the room they need.

Here are the main benefits of using a hotel mobile app for your business:

  • Staff management and task scheduling.
  • Price management.
  • Your guests will be able to see their room in advance. Providing your customers with choices is the key to success!
  • The guests can order room service without making any unnecessary old-fashioned calls. 
  • The guests can also call the maid, staff or private security when needed.
  • You will be able to read reviews left by your visitors, correct possible issues and improve your services. This will take your hotel to a new level.

As you can see, your hotel application is a direct reflection of your ability to take care of your guests.

Hotel booking app development

Developing an app is not done in a single day. This will be the face of your business, and you will need to engage the PR department, business analysts, and a team of people who can work out the exact strategy for supporting the application in the future. This is the only way your application will be successful with potential visitors.

Commercial property management systems must be perfectly built, otherwise the hotel business will only suffer losses. To prevent this, you need powerful hotel management software that will help you establish your hotel business and reach a new level of professionalism.

Which hotel booking app is the best?

Here is a list of the top hotel applications that can be used as an example to base your app on: 

  • Trip.com
  • Booking.com
  • Hotels.com
  • Agoda
  • Hotellok
  • OneTwoTrip
  • AccorHotels, etc.

Most of these  reliable and time-tested applications are available for both iOS and Android users. They have a lot of traffic and a large number of positive reviews. What’s even more important – customers trust them.

Hotel apps enrich yser experience

What is last-minute booking?

Even the most reputable hotels around the world offer last minute packages: large discounts for booking rooms on short notice.

Last minute booking is beneficial not only for your clients! As long as people think they are saving, the hotel makes big profits. After all, the lower the price, the more customers will be interested.

This is your chance to not only attract your target audience with reasonable prices but also keep them coming back by offering high-quality services. Convert them into regular hotel guests who will be ready to pay the full price knowing that your team are reliable!

Tips for Using Your Hotel Management System

Implementing the right technology and database is only half the battle. Knowing the right business processes, organizational resources and performance indicators is the key to success. There are two main recommendations for you:

Focus on data analysis and business intelligence

Analytical tools are becoming more complex and serve as the core function of next-generation commercial PMS.

The resulting insights can have such advantages: improving the effectiveness of marketing, sales and customer service. Key stakeholders can track hotel occupancy trends, guest demographics, market position, and hotel revenue.

Create an accurate management strategy 

Without this, your business will not succeed. If you are a good hotelier you can create a smart strategy that will bring pleasure to guests and profit for the hotel. 

To get the most out of your hotel business, you need predictive analytics. They help to calculate the potential demographics of your guests and their approximate number.

And, of course, if you want to create a reliable mobile application for your hotel, then you must have a strict privacy policy. Your company should ensure your guests’ safety and the security of their data. 

Power your hotel with an app

Make an App to Move Forward

Nowadays, if your hotel does not have its own application, no one will know about it. 

Running the hotel property management system is a difficult task that only real professionals can handle. If you want to conduct your business in a modern way, provide high quality services for guests and ensure comfortable working conditions for your staff, you need a high-quality app.

Our team of experts has experience in delivering hotel solutions – Guestable– and can help you develop powerful software and provide you with assistance to make your hotel business prosper.

Technologies Powering Hospitality App Development

Did you know that the growing Alpha generation, a generation more than familiar with using smartphones right from the cradle, tends to travel about three times a year on average? Previously, when there were no such hospitality services available like Booking.com, for instance, one could only dream about affordable travel opportunities. 

Nowadays, traveling has become a lifestyle for many and a keen hobby for others. This is possible due, in part, to mobile applications (e.g., those that provide a wide range of profitable last-minute hotel deals) and other software solutions that serve as trusty virtual guides anywhere in the world. In this article, the focus is a few tech niceties that will be changing the world of hospitality and travel software in the very near future. It might even give you ideas on developing your own hospitality app.

traveling makes life brighter and travel apps make planning smoother

Types of Software for the Hospitality Industry

For starters, let’s figure out what kinds of apps can be implemented through a hospitality app development system:

  • Personal assistant – Such apps provide hotel guests with self-serving capabilities as well as minimize the need for live communication with service personnel. If you are interested in how it looks in practice, take a look at the capabilities provided by VirtualHotel
  • Hotel booking application -. The most common type of apps in the field of hospitality. These help users find the best offer in the area and book a hotel room with only a few clicks. A particular example of such solutions is Hotels.com.
  • Revenue management app This type of software is basically your handy expense calculator. The most thought-out development companies tend to launch complex solutions, such as the KittySplit mobile app, which helps to manage debts. 
  • Food and catering app -. Regardless of how great of a hotel you have that provides all-inclusive services, travelers still take great interest in the local cuisine. Applications like Yelp help travelers find available restaurant options and book a cozy table.
  • Controller-app – This type of mobile software may help manage smart home systems within hotel rooms. The most commonplace example here is stayConnect (a regular TV remote controller made as a mobile app).
  • Car/taxi booking app – When you’re in an unfamiliar town in a foreign country, it may be a challenge to find a good taxi service. Have a look at Uber or similar car-booking apps that open up a world of rides.
trends to consider for hospitality apps
  • Property management systems Such tools come in handy for those planning to rent a place (which, by the way, can be much more cost-efficient than booking a hotel room, especially, in the long run). For example, there’s the Guesty service. 
  • Boat booking platform Yet another useful kind of software that will certainly serve fans of water activities and sports quite well. Boataround offers a wide range of functionality. 

The Top 10 Features of Hospitality App Development

Take a look and find out which hospitality industry trends will be common in the years to come. 

  • Electronic key card – It is mainstream to make check-ins and check-outs as convenient as possible. Electronic key cards hit it big time. Currently, every other user can single-handedly book a room, get to the hotel, and open the door with a  key card generated in the specialized hotel mobile app. From the technical perspective, NFC or QR code scanning come in handy here. 
  • Voice assistantsVirtual voice assistants have covered practically every existing business niche since the impeccable success of Siri. The hotel business and, in particular, hospitality app development solutions aren’t an exception. Thus, hotel voice assistants make hotel stays as convenient as possible. Let software take care of setting an alarm clock, handling air-conditioning, and doing other tasks – for your users’ comfort. 
  • Augmented reality (AR)Pokemon Go made AR popular worldwide. Going way beyond the entertainment industry, augmented reality helps increase customer satisfaction in hospitality with advanced personal assistant solutions.
  • Blockchain – Considering the fact that the blockchain acquired most of its popularity due to bitcoin, the technology as a whole has an ambiguous reputation (cryptocurrencies continue to rapidly fall in price and there are loads of scam projects with blockchain at the core). Nevertheless, the technology itself is pretty viable. Moreover, its potential can be fruitfully fulfilled in terms of the travel agencies’ workflow. In particular, with the help of a blockchain-based platform, you’ll secure your customers’ transactions, eliminating additional verifications along with the respective time expenses. 
  • Autonomous shippingDrones are not mere hi-tech toys. They provide cheap and rapid shipping (for food and drinks, for instance). With autonomous shipping options, hotels receive a cost-efficient way to service guests while also avoiding many human-caused risks. Not only can such automated devices perform staff duties, they can also become an attractive feature of the establishment.
  • Smart rooms – IoT takes the hospitality industry to a new level of service. In the US and EU, there are modernized hotels using all the benefits of smart home. In terms of travel application development, we can clearly see that in the years ahead, the industry of travel and tourism won’t be able to avoid the custom solution of remote control via smartphone (something similar was already created by the developers of the Mi Remote Controller, a device only compatible with TVs). 
  • GeolocationThis feature helps users to easily locate lodging options in the area. This is very beneficial for travel mobile app development, allowing users to effortlessly find a place to stay nearby. Couchsurfing apps are gaining traction as budget tourism is becoming trendy right now.
  • Mobile eCommerce solutions – Hotel booking app development creates time-efficient and effort-saving experiences. You can go for hospitality-related mobile commerce and create a vacation rental app that would cover both the hotel reservation and payment.
  • SIP-DECT – Now, this is a solution that doesn’t wholly belong to the field of hospitality app development. However, the technology can come in handy both for hotel guests and personnel. It basically provides the ability to move throughout the territory of the hotel using the radio phone of the DECT standard. SIP-DECT implies the availability of several basic stations. It is roaming-based and allows guests to stay in contact with the guide at all times. Plus, it’s an excellent alternative to stationary phones in rooms.
  • Integration with social networks & public opinion – People have always trusted social proofs over empty company promises and this goes well for the hotel industry, too (91% of 18-34-year-old users tend to trust online reviews as much as personal recommendations). Travelers take a close look at hospitality app reviews before booking, which is precisely why solutions of travel portal development call for feedback, ratings, and social media sharing. Note that both complaints and suggestions are on.

Hospitality and Travel Software Development: Summary

As you can see, the hotel and accommodation industry is ripe for sweeping digitization. Take advantage of the ten mentioned features and add your own ideas about how to develop a travel management software solution that end-users would fall in love with. If you have any questions, we’d be glad to offer our expertise and experience in this niche.

Developing a Payment App in .Net Core 2

The mobile payment industry is quickly catching up to the users who make businesses focused on payment app development using .net technology. It’s a well-known fact that sending and receiving payments via mobile phones is becoming increasingly common throughout the globe. Not only can users browse the Internet and chat on the go, they also can move to cashless payments through the use of mobile devices.

Based on a recent survey, the usage of mobile payments among millennials will continue to increase and is expected to reach $503 billion by 2020. In addition, 75% of all financial transactions will be cashless by 2025. Sounds impressive, right?

That’s why companies need to start developing and implementing a mobile payment system that doesn’t require much infrastructure or technical knowledge on part of the user. Once users install a payment app on their smartphones they should no longer have the need to carry a credit card with them to make a purchase. There is a lot of information about how to develop an Android or iOS payment app, so here we’ve decided to provide an overview on how to create a peer-to-peer payment app using .net technology. Let’s delve into the details below:
PayPal mobile payment volume is $227 bln.

What exactly is a peer-to-peer payment app?

A peer-to-peer payment app, also known as P2P, is an app that users install on their smartphones to make transactions via a linked bank account or credit card. It’s key characteristics are:
— built for personal use and can be utilized between friends, relatives, etc.
— transaction time can range from a couple of days to a few minutes
— funding requirements or transaction fees depend on the bank account, debit/credit card, etc.

How to build a P2P payment app

Below you’ll find a step-by-step guide on how to develop a payment app.

#1: Choose the P2P app type

If you are going to create a P2P payment application, you should know what types of payment apps there are and choose the most suitable one.
Standalone: Offers person-to-person or company-to-business payments online that include or exclude the use of checking accounts, debit/credit cards. It provides a wallet feature to send, receive, or store money in a range of currencies. Among the most popular examples are PayPal, Venmo, Airfox, Alipay, M-Pesa, etc.
Social media-centric: Doesn’t require a strong authentication solution to make transactions, and provides a frictionless process of sending frequent payments. For instance, Facebook Messenger, Kik, and G Pay Send are the most common.
Bank-centric: Involves a bank that acts as a middleman, deposits directly into bank accounts instead of a stored currency account. ExcheQ, Zelle, People Pay, and Popmoney are the most popular.

#2: Identify key features of the app and set up work process flows

At this step, you should document the details of your app or use a wireframing tool. It is also imperative to think of the features you would like to develop, define how the user will navigate the app, and set up the flow. Not only does it help the mobile dev team to clearly understand your expectations, but they can meet the requirements as well. Now let’s take a look at the key features of payment apps:

  • Notification: Keeps users informed about sent or received payments, and notifies the user of any wallet activity, bill due dates, or bookings.
  • Billing and invoicing: Enables users to scan the bill and generate invoices.
  • Transaction history: Users can view summary information that includes the date, amount, positions, and status of each transaction made through the app.
  • Chatbot: Allows customers to ask questions and get answers quickly within an app.
  • Fingerprint security: Relies on a person’s actual thumbprint and ensures secure access to their account.
  • Cryptocurrency: Allows users to safely buy and sell cryptocurrencies.

#3: Focus on the right technology

There is a lot of information on how to develop a payment application in Java or Swift. However, there is another technology for creating a payment app that’s worth mentioning — .NET Core 2. Designed by Microsoft, this technology is an open-source, server-side web app framework. It’s also worth pointing out that this technology requires less configuration and setup in comparison to other web platforms. In addition, asp.net-powered payment apps can utilize the following databases — MySQL, Microsoft SQL Server, Postgres, MongoDB, CouchDB, all of which are in great demand. Not only can you use .Net for small applications and MVPs. Sounds impressive, right? Let’s find out the most significant benefits:

  • Provides a cloud-ready, environment-based configuration system
  • Includes a lightweight, high-performance, and modular HTTP request pipeline
  • .Net Core 2’s code is easy to maintain and update
  • Building and running on Windows, Linux, and Mac operating systems offer great support systems with a huge developer community
  • Scalability is easy to enable
  • Easy to integrate with out-of-the-box and custom solutions, as well as host on Google Cloud Platform, Microsoft Azure, AWS, and Heroku using IIS, Nginx, Apache, Docker, etc.
  • Excellent code analysis support and comprehensive editors/IDEs.

Also, it should be mentioned that .NET Core 2 is bringing positive changes in developing high-quality enterprise web applications.

Revolutionizing one-touch by PayPal

#4: Focus on security

The truth is that security is a must for the payment apps. Only by providing secure payment services can you keep users engaged. That’s why you should design the architecture concentrating on security and reliability. With that in mind, make no doubt that your payment service will be reputable in the app market and give peace of mind to end-users.

For example, Venmo uses bank-level security and data encryption to protect users against unauthorized transactions.

#5: Choose the monetization model

There’s a good revenue model behind every successful app. Below you can find out what revenue model to choose in order to boost revenue and drive growth:
Transaction fees allow you to typically charge a percentage of every in-app transaction.
Ads are a user-focused business model that allows you to get paid by ad-owners for each click when displaying ads.
Paid subscription packages provide exclusive features for an additional cost.

How much to build a mobile app or what is the cost of developing a payment app

Now that you know the revenue options, let’s get down to brass tacks. Average costs when it comes to app development start from $50,000 and depends on the factors such as features and functionality, dev team extension model, and its location. Above all, whenever you hire mobile app developers make sure you have discussed all the questions and are on the same page about app design and development.

The benefits of developing a payment app for your business in .Net Core 2

A great number of businesses are taking full advantage of today’s modern financial software. However, the market is still growing and there’s plenty of room to launch more P2P apps:

— Provide your users with the value they need
— Build the recognition of your company and increase the customer base
— Improve customer service experience and create engagement
— Generate more income to drive business growth.

Aionys has a team of .Net Core developers who have successfully launched a number of projects. Medical Care Platform offers solutions for both patients and caregivers. The medical billing software is built-in along with time-tracking and task-management systems.

Bottom line: Are you equipped with a P2P app?

P2P payment apps are there for users to send and receive money with a single one click only, along with simplifying transactions and keeping track of finances. That’s why payment apps are a great solution to boost any brand and connect with customers by delivering successful payment services. The bottom line is simple — concentrate on payment app design and development. If you know how to develop a mobile app from scratch, unlock the enormous potential of mobile payment applications to increase productivity, improve user experience, and drive growth. If you have an idea that you’d like to see become a reality, feel free to let us know and we can help.

How IoT in the Logistic Industry Changes the World

IoT in the logistic industry is a win-win trend. Companies get full control of goods and fleet, while customers get lower prices.
IoT in logistics has opened a wealth of business opportunities
Credit: cegoh/pixabay.com

Mankind has lived through several industrial revolutions. From the steam engines and the telegraph to the rise of electronics, science has made tremendous progress over the span of just a few centuries.

The advent of the Internet brought about the fourth industrial revolution, which has dramatically transformed our economies and everyday lives. It all started with computers and continued with smartphones. Now, almost any physical object can be connected to the global network to receive and transmit data. This technology is known as the Internet of Things or IoT.

While every industry can take advantage of IoT, its benefits are particularly tangible in the fields of logistics and transportation. Read on to learn what gains IoT can bring to both delivery companies and their customers.

IoT: Invisible Threads Connecting Everything

IoT on the logistic industry is widely used
Credit: Gerd Altann/pixabay.com
First, let’s dive into some technical aspects so that you know exactly what is IoT and what underlying technologies it employs.

IoT Defined

IoT has penetrated both earch and space
Credit: TheoLeo/pixabay.com

There’s nothing fancy about the concept of the Internet of Things. It simply implies all devices connected to the Internet and capable of receiving or transmitting data to a centralized platform or to another object within the IoT network. What’s particularly valuable is that all these objects do their jobs without human intervention.

The first person who used the term “Internet of Things” was Kevin Ashton in 1999. However, it was not until around ten years later that the term was universally adopted.

Along with IoT, other words were initially used to describe various objects that could send and receive data over a network. For example, “blogjects” or “ubicomp”. In the end, it was IoT that celebrated the victory.

Can we call every Internet-connected data-receiving or data-sending object an IoT device? No. An IoT device is something that normally has no access to the Internet, such as a hair dryer or microwave oven. For that reason, laptops, tablets, smartphones, or PCs don’t belong to the IoT cast.

What makes IoT devices really powerful is not their functionality but their connection to an IoT platform, where they can send and obtain data or perform power-intensive calculations.

Categories of IoT Devices

We can divide IoT devices into three broad categories:

  1. Those that monitor an environment and send data to a remote source. It’s all kinds of sensors, starting from air quality monitoring sensors and ending with temperature sensors.
  2. Those that receive data and do something with it. Example: an IoT-powered bulb that automatically turns on when someone walks past the lamp post.
  3. Those that serve both as data transmitters and data receptors. These are IoT devices capable of evaluating data they obtain and performing appropriate actions based on it. Example: a self-driving car that changes its route once it learns about a traffic jam ahead over the Internet.

It’s the last category that makes IoT especially desirable for businesses and individual consumers, giving them almost unlimited possibilities.

Technologies Behind IoT

Several important innovations have contributed to the development of the IoT industry.

  • Connectivity technologies. There’s a bunch of options for various IoT devices to connect and exchange data with one another:
    Bluetooth Low Energy
    Wi-fi
    LTE
    Ethernet
    Satellite
  • 5G Networks. This high-speed mobile network makes it possible to use a huge number of IoT devices within a limited space (up to one million to a square kilometer).
  • RFID (Radio Frequency Identification) tags. These are chips attached to various objects like machinery. They consume little energy and require no wires to transmit data.
  • IPv6. Using this Internet protocol, we can obtain an almost unlimited number of IP addresses for each and every IoT device on the planet.
  • AI. Artificial Intelligence technology is capable of “digesting” huge volumes of data that IoT devices collect and transmit. After processing this information, AI systems can make predictions regarding various industrial processes.

Popularity of IoT

Experts predict a huge growth of IoT. IDC forecasts the global spending on the Internet of Things to equal $745 billion in 2019. According to Statista, the worldwide expenditures for the Internet of Things will reach the 1 trillion dollars mark in 2022.
Many industries have introduced IoT into their business processes including the following:

  • Defense
  • Agriculture
  • Healthcare
  • Retail
  • Oil, gas, and mining
  • Infrastructure
  • Hospitality

One of the sectors where the Internet of Things is also widely used is logistics. Let’s review the main applications of this technology in the logistics industry and discuss the benefits it provides for delivery companies and their customers.

IoT in Logistics

Sensors are great tools enabling the Internet of things
Credit: AG88/pixabay.com

The logistics industry is the economy’s locomotive. Manufacturers need their products to be delivered at the optimal price, at the exact time, and in the necessary quantity and condition.

A logistics company will most certainly fail if…

  • it can’t manage its inventory efficiently
  • its warehouse is a mess
  • its internal processes are not automated
  • it can’t deliver goods fast enough
  • it can’t ensure that goods will be delivered to customers safely and their quality will be perfect.

The Internet of Things addresses all of those challenges, bringing the logistics up to a completely new level. Here are the main benefits of IoT for delivery firms.

  1. More Efficient Management of Vehicles
    Different logistics companies have variously-sized fleets of delivery trucks. Even with a small number of cars, though, it’s often hard to track their location and condition on the road. IoT simplifies and streamlines this process:

    • It uses GPS or similar location-detection technologies to collect data about the exact place and maneuvers of a vehicle as it’s moving from point 1 to point 2.
    • It automatically sends a push notification to a manager once a vehicle arrives at the destination. This helps the manager plan deliveries more accurately and promptly.
    • It enables trucks to exchange information about their locations in real time. Thus, they can move in groups, adjusting their speed and keeping the optimal distance between themselves.
      As such, more road space is available to other vehicles. It also reduces the amount of exhaust gases and contributes to more efficient fuel consumption. Business Insider predicts that 98% of all new cars will have an Internet connection by 2020.
    • IoT devices installed inside vehicles notify technicians of any problems with the engine or other parts even before those occur. Thus, managers can immediately react to all kinds of issues to avoid or significantly reduce downtimes.
  2. Better Inventory and Warehouse Administration
    supply chain management and warehousing are promising spheres for IoT use
    Credit: icondigital/pixabay.comEfficient warehouse and inventory management is of paramount importance to any logistics company. The number of goods could be huge. Tracking them manually is prone to numerous errors that may cost too much in the end.IoT has made the life of warehouse administrators much easier. By attaching minute, cheap sensors to the stored items, managers can monitor the availability of goods and quickly find them.Information about the stock is sent to the cloud. Managers can retrieve it at any given moment wherever they are and use it for accurate planning. As a result, there’s no shortage of popular goods, while losing items is almost excluded.
  3. Better Quality of Delivered Products
    IoT devices can also ensure that the conditions inside vehicles that transport delicate or perishable products such as fruit, vegetables, or flowers are optimal throughout the route. That reduces the amount of wastage and contributes to higher customer satisfaction.
  4. Property Theft Prevention
    Stealing freight is not a rare occurrence in the United States. According to a report from Statista, in 2017 U.S. transport companies lost cargo worth almost $2.6 million due to theft. IoT can effectively prevent stealing property. One example: the SmarSensor solution from DHL. It can detect any temperature fluctuations, changes in the light intensity, or register any abnormal events during a trip. That helps managers immediately react to the alarm and avoid the loss of goods.
    It’s also good from the insurance perspective. Thanks to IoT, logistics companies can exactly identify the time and location of the theft. That simplifies recovering costs through insurance policies.

Benefits of IoT for Consumers

The new technology is advantageous not only for logistics companies themselves. It also contributes to higher customer satisfaction.

Real-Time Tracking

Customers can follow the entire path of their goods from the warehouse to the final destination. They can do it via one of the numerous tracking apps such as this to know when to expect their goods precisely.

Reduced Costs

IoT devices enable drivers of delivery vehicles to find the best routes. The data about the traffic situation, road condition, and relief is stored in the cloud and can be used by all other vehicles moving in the same direction. That contributes to lower fuel consumption. Customers pay less than they did before.

No Lost Merchandise

Thanks to the sensors that control the temperature, light, and humidity inside delivery trucks, customers get all their merchandise without wastage.

Real World Examples of IoT Usage in Logistics

SmarTrucking is IoT-based solution DHL introduced to the business processes
Credit: skeeze/pixabay.com

A huge number of shipping companies have already believed in the advantages of IoT for their businesses. Here are a couple of examples to illustrate this.

Maersk

The company from Scandinavia is one of the largest shippers on the planet. Around 7 years ago Maersk struck a partnership with Ericsson for the installation of satellite and mobile equipment to track the gigantic fleet of its containers on the move.

Ericsson’s devices send data about all parameters (current position, temperature, humidity, etc.) to the servers, where it’s analyzed by managers.

DHL

In 2018, the largest logistics and mail company on Earth introduced the IoT-based solution SmarTrucking to its business processes. The sensors installed inside DHL’s trucks now allow managers to determine the best routes and track deliveries in real time. Since then, transit times have decreased by half, while the movement of goods can be tracked with nearly 100% precision.

Conclusion

The future of the logistics industry belongs to IoT. Companies can track the movement of goods in real time, predict problems with vehicles, prevent property theft, and reduce fuel consumption. The customers’ main benefit is a lower price they have to pay for the shipment of their goods. So, if you’re still doing your business the old-fashioned way, it’s time to try out the new technology.

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

MS SQL Deadlocks Series

Deadlock

Aionys series on deadlocks is a step-by-step guideline for developers specializing in database programming. Find out what they are, why you have them, and what you should do to unlock and, ideally, prevent them.

Let’s start.

MS SQL Deadlocks: What are they to Block the Flow

There is no guideline to implement deadlocks. You see them popping up when least expected. I believe you know how it feels when the deadlines are approaching, too fast. And here you are – stuck with deadlocks, the issue you really don’t have time and energy to investigate and, most important, solve. And the priority is critical. Got a performance issue? You might be as well kissing your peace of mind goodbye. 

Most developers are lucky enough to have heard the buzzword only. And haven’t actually dealt with the issue. 

Things are different at Aionys. Having several projects in development and some of them with huge databases, we have experience in handling them. And we aim to share our challenges and solutions with you. So let’s get to the root of deadlocks starting with what the heck they are.

What are deadlocks?

Deadlock is a big issue of relational databases. It is about several processes blocking one another when necessary resources get locked.

The processes wait infinitely for resources (row, table, etc.) to get unlocked. As a result, a server kills one of them. 

Deadlocks not only slow down the system but also bring it to a halt. They most often surface when data gets changed – updated/ inserted/ deleted – and database servers are under high load. The DB size doesn’t matter that much as even the smallest one can get deadlocks. Most devs believe that the more create/update/delete requests, the more deadlocks. 

The project in focus

A recent project where we faced deadlocks is for healthcare. It has a huge database of patient records, appointments, and hospital lodging details. And it also has a long history. We started it three years ago. And over time, it has grown immensely with an increased amount of data handled. 

Initially, the project was delivered to optimize process management at a medical center, including time and attendance systems for staff and patients. Later, new features were added 

  • payment processing
  • billing and invoicing solutions
  • management of doctor offices, and wards, etc.

For the first few releases, when the number of users was limited, the system worked smoothly. The issues appeared when more medical units were added. Interestingly, when doing our testing we didn’t have them.

 Team A first-hand experience

At Aionys, we work with MS SQL. When we first faced the deadlocks at the project, we turned to the team lead developer with over 10 years of experience in developing custom software. Good or bad, he hadn’t had such serious issues. For him, logs were just: deadlocks happen. 

So our development team started digging into the issue. The info we came up with was focused on multiple threads. Miraculously, they did wonders but not with MS SQL server requests. 

Deadlock interview

Next, we set out on asking around, especially guys with more experience in MS SQL. They recommended taking the following steps

  • change the isolation level of the transaction 
  • remove huge transactions
  • split large transactions into smaller ones. 

Fortunately, 90% of deadlocks were solved. Unfortunately, performance decreased. Meanwhile, requirements advanced with database queries getting more complicated. 

We turned to asynchronization to increase performance. It didn’t take much time to understand that the more async requests, the more side issues. For example, updating/inserting/deleting data caused serious problems for the server. 

It looked like we were running in circles. In the end, we came up with a solution. Our next Unlock MS SQL Deadlocks post will shed light on it.