Business Environment

Visualization, sharing and systematization of goods and software through IoT

2016/09/06

IOTによるモノとソフトの見える化・共有化・体系化

IoT to share information from hardware

About 10 years ago, the word "ubiquitous" was used to describe "a society where users can use computers, networks, etc., anytime, anywhere without being aware of it".
Recently, the term "IoT" has been changed to "IoT" and is now being implemented in real-world devices, and there are some familiar examples here and there in Indonesia.

CCTV Internet Distribution

Normally, the internal LAN is not accessible from outside the company due to firewall settings, but by using DDNS (Dynamic Domain Name System) service, the global IP address dynamically assigned by the provider to the router at the entrance of the internal LAN is mapped to a fixed domain name.

CCTVのインターネット配信

In this case of a manufacturer in MM2100 in Cibitung, the output port 5400 from a DVR (Digital Video Recorder) connected to CCTV was opened up to view videos through the Internet, but in a subdomain of the domain edns.biz to a global IP address that is dynamically assigned to the Mikrotik router.

The client's browser requires a Flash player as an add-on, but the Chrome on my Android phone, Sony Z Ultra, doesn't support Flash and can't play CCTV videos, so I use Dolphin Browser, which is said to be the world's fastest Flash and adblock free Android browser.

The Dolphin Browser is a convenient god browser for playing flash games, but there have been allegations of spyware embedding in Dolphin, so please do so at your own risk.

Incoming call confirmation and barometer collection with wearable devices (smartwatches)

Recently, Huawei watches, Motorola's Moto 360 and ASUS's ZenWatch have started to appear on the shelves of gadget stores in Indonesia as well, but if you ask me if I would spend tens of thousands of yen to buy one, I probably wouldn't.
ウェアラブルデバイス(スマートウォッチ)による着信確認・バロメーター収集

For such people, I recommend cheap so-called Chinese smartwatches, I bought a 96,000 rupiah U8 watch at lazada.co.id the other day and it's quite a lot of fun.

The thing I wanted to do most was to be able to detect incoming calls and line calls with the vibrations at hand, but until now, the vibrations don't work at all.

Well, it's a mistake to ask too much of a 96,000 rupiah watch and if you only look at the positive aspects, you will be happy enough.

First of all, being able to check for incoming messages at hand means that you can sort out whether the message is important enough to open your phone or not, so you can save a few seconds of time for each incoming call, and if this stacks up 10 times a day, 365 days a year, it will save you quite a bit of time over the course of the year.

Remotely check the indoor air quality from your smartphone with an air purifier

I recently bought a Dyson vacuum cleaner for 6juta and it's expensive, it has a strong suction power, it has a lithium battery and no power cable, so it's small enough to clean more often.

空気清浄機で室内空気の状態をスマホからリモートチェック

I bought it at Dyson's Pameran (exhibition booth) in Grand Indonesia, and besides the vacuum cleaner, Dyson is now selling a featherless air purifying fan called "pure cool link". It's an IoT product that can do just that.

You could use it to check the air quality of your room on your phone from the office in the evening before you go home, and feel refreshed from the moment you arrive at your room and open the door, but I think the peace of mind that comes from being able to visualize how dirty the air you are breathing is great.

We just got a new Sharp plasmacluster, so I won't be buying this air purifier, but this British company, Dyson, keeps coming up with innovative products that have stories to tell.

Definition, Purpose and Effectiveness of IoT

The general definition of the IoT is to obtain information from not only PCs and smartphones, but also other devices and place them in the Internet environment.

The information acquired by the IoT is meaningful only when it is value-added and useful in our daily lives, such as creating a step count chart using the pedometer function of a smartwatch, making a chart showing the relationship between the number of steps and heart rate, or creating a transition chart for PM2.5 outdoors and PM0.1 indoors that is detected by a Dyson air purifier. The state transition table for outdoor PM2.5 and indoor PM0.1 that Dyson's air purifier detects.

The information collected by the IoT is then placed on the Internet (web environment), where it can be easily accessed through a browser, making the information visible and shared.

Although IoT stands for Internet of things, the data does not necessarily need to be made available to the public; what is important is that the information can be easily accessed through a browser.

Visualization and sharing of business data (internal use of data)

We have seen examples of how information from devices that have never been connected to the Internet, which is the original meaning of the IoT, are collected in a web environment, but what is important here is not the connection to the Internet itself, but the realization of the visualization and sharing of information that follows.

Here we would like to look at an example of adding value to the web environment by using software information rather than hardware.

Web-based master maintenance and performance collection

The Asprova production scheduler calculates MRP (Material Requirement Planning or Manufacturing Resource Planning) based on unofficial information from the customer and confirmed orders, and then combines manufacturing orders and Advanced Planning and Scheduling (APS), which generates purchase orders and creates optimal production and purchasing schedules while taking into account equipment capacity.

WEBベースのマスタメンテナンス・実績収集

To create a production schedule with Asprova, it is necessary to import requirements information such as unofficial and confirmed orders, inventory information, backlogs of orders and backlogs of orders from the production management system and Excel, but this information is entered by the purchasing, production control and sales departments, and master maintenance is performed.

The greatest merit of installing Asprova is that information that has been separated by divisions and processes can be integrated into a coherent system that allows us to easily formulate measures for total optimization rather than partial optimization.

The example of a mold manufacturing plant shown in the above figure is an example of a mold manufacturing plant where we are trying to achieve visualization and sharing of information by placing this information input and output in a web environment.

Maintenance of the Asprova BOM and equipment information is performed from the IT office in Jakarta, and the actual results for the production plan can be performed from the production site of the Civitun MM2100 because all Asprova data is managed on a server database and an environment is in place to access it through the Web.

The merits and demerits of a location- and device-agnostic system

場所や端末を選ばない仕組みの功罪The fact that you can refer to information stored in the business system and enter the results from your browser means that these tasks can be done from

  1. Any device (PC, tablet, smartphone)
  2. Any location (internal or external, domestic or international)

This means that visualization and sharing of information will be promoted.

The purpose of "visualization" is to build a relationship of trust through information disclosure, while the purpose of "sharing" is to put information on a level playing field as a common understanding for improvement.

On the other hand, a system that does not allow sharing of information from any location or terminal has the risk of unauthorized access to data from inside or outside the organization, and the risk of making the responsibility for information sharing unclear.

I don't trust emails with too many CC addresses.

Systematization of business data (external transmission)

In this era, the only way to add value to the information accumulated inside the organization is to systematize the information and disseminate it as useful information in order to obtain added value from the outside (potential customers), and for this reason, it is important to create a system.

Systematization of business system information

Not long ago, the Oxford University-approved list of "occupations that will disappear in the next 10 years" was discussed, and among these occupations related to business systems were payroll and benefits staff, data entry workers, and bookkeeping, accounting and auditing clerks.
業務システム情報の体系化

If accurate results are collected in real time from hardware by IoT, human input work will be eliminated.

In addition, if IFRS (International Financial Reporting Standards) principle of full mark-to-market accounting is thoroughly adopted and only one accounting standard is adopted, it will no longer be possible to manage the accounting standards for domestic use in Indonesia and for submission to the head office in Japan separately, which will eliminate the dependency work and may lead to the automation of accounting operations at once.

And after this, the systematization of accounting may lead to the usual trend that it is important for humans to make use of the accumulated data, but this is just a practical example of what has been said for 20 years already.

Web-based delivery of goods in and out of the warehouse (for customs)

入出庫実績WEB配信(税関用)

As an example of transmitting data from the business system to the outside world, we have a web-based system that provides bonded factories with information on inventory receipts and payments required by Indonesian customs.

Business system data is stored in the Postgres DB on the server, and an automatic update program resident on the server sends out update queries to the provider's MySQL server every four hours.

The new value-added information that is made visible and shared internally is achieved by further organizing the information and achieving the objectives of helping to promote sales to potential external customers and responding to requests from relevant agencies, such as customs.