This blog discusses how we can see if SQLServer memory configuration is suitable for BY WMS Systems

Overview

BY WMS is a high-end WMS system provided by BlueYonder (formerly JDA and formerly RedPrairie). This can be classified as an OLTP (Online Transaction Processing) system. If configured properly, it can easily meet most business requirements around performance constraints. We may have to adjust some settings though. In the current blog post, I will be focusing solely on the memory settings. I have created other postings that discuss:

Expected Cache Hit Ratio


BLOB or Binary Large Objects are used to store binary data in an Oracle database. The basic functionality is the same as the traditional long raw data type but with quite a few enhancements. Typically this data type is used to store documents, images, and various other types of binary data. Oracle also provides a companion data type called CLOB for storing large text fields, but in most cases BLOB data type will be sufficient.

BLOB data type provides much more functionality than the equivalent LONG RAW data type. The functionality is provided through the dbms_lob PL/SQL package and its…


Problem Statement

We have a complex business application where we have several business rules. The application needs to be available in online mode, e.g. a responsive web application and also in offline mode, e.g. a mobile app when the connectivity cannot be guaranteed. In offline mode, same business rules must be respected. When the device gets connectivity, it should seamlessly synchronize with the server.

For this problem, we can assume that

  • The data model is striped in a fashion that appropriate related data can be replicated easily to the mobile device
  • The business logic, if applied on the replicated local data, is…


Really simple Array of Inexpensive Cameras (RAIC — pronounced “rake”)

Image taken from https://www.scandit.com/scandit-barcode-scanner-sdk-5-2-includes-matrixscan-premium-scanning-ar-tracking-feature/

Problem Statement

During some business use cases, it is necessary to capture a very high resolution closeup image so that we can then extract barcodes from the image or perform OCR. If the barcode is small, e.g. see a bottle of Tylenol — then imagine a small carton full of these bottles. You would need a very high resolution camera to take the image so that you can then process it successfully.

Solution Overview

Such a problem can be solved using RAIC (Really simple Array of Inexpensive Cameras).

Idea is that we take simple cameras of decent resolution, e.g. 12MP 4K cameras and put…


Solution

Bluetooth 5.1 standard allows for a receiving antenna to know the signal strength and also the angle. This fundamental concept would allow for accurate positioning.

This blog describes the details about some of the concepts. You can find additional details about this standard on Nordic website.

So this seems extremely promising and centimeter level accuracy would be possible so definitely this can form the basis of flights inside!

See Also


Solution

This seems a very interesting approach.

Currently they are simply repeating the signal that the antenna outside receives to the transmitter inside. So this concept cannot be used as-is to provide navigation inside buildings.

If we simply start receiving GPS signals inside then the whole array of solutions already available for dones would simply start working inside!

Some companies that have this solution are:

Some general blogs:

See Also


Smart Traffic Visibility System For Drones (STVS)

UAVs (also referred to as drones) have wide ranging uses in business applications within defined 3D space. This implies that the domain of the operation of the vehicles is a known space such as a large building. Within that defined space, we may have several such vehicles operating and at the same time there may be fixed or non-fixed obstacles. For such vehicles to operate autonomously and safely, it is necessary that a central system provides overall visibility.

The solution described here provides the following capabilities:

  • A framework to define the 3D space (Separate patent application … deals with more…

Solution by marvelmind

They approach the problem by utilizing “ultrasonic beacons” on fixed locations inside the building. They communicate using the same protocols as GPS so it is “as if” your drone started getting the GPS signal inside.

Very innovative approach. Per their FAQ and bulletin board — looks like several users are trying to use it with drones. The solution is much more generic and could be used for general purpose asset tracking as well.

You can get more information from their website https://marvelmind.com/

See Also


Smart Visual Internal Positioning Ecosystem (SVIPE).

Pronounced as SWIPE

UAVs (also referred to as drones) have wide ranging use inside large buildings for example large warehouses. They are relatively low-cost and can freely roam the facilities without interfering with other entities. They also can reach any height within the building. They can carry a variety of attachments, for example cameras, which can simplify operations.

A primary challenge inside the buildings is to know their exact position in the 3D space inside. …


This document provides sample data for concepts described here.

Here we are going to describe a sample use case for IOT devices. The requirements for creating IOT type devices are becoming simpler — yet the challenge of making sense of the data seems overwhelming.

Even modest manufactuers can easily turn their devices into IOT devices. Creating a device like this is extremely simple — all we need is an emedded computer that can communicate over internet. But once they have made the device how would they make sense of the data? Where will that data go from the device? …

Saad Ahmad

I am a computer software professional and live in Oshkosh WI USA. I enjoy exploring ideas in a variety of disciplines including Economics, History, and Religion

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store