Month: February 2018

Database CobWeb – The future of Vessel Database ?

by admin admin 2 Comments

Data CobWeb – The future of Vessel Database ?

We all have studied the techniques of maintaining Database at some stage. We have discussed with our colleagues about this tedious task day in & day out. We’ve had similar debates about Vessel wise Database vs Global Database. However, these insights are lost in the very Group Discussions & hence we go for a universal rule:

Get back to work doing the task again & again

     …..till we find a problem.

Most times, we find this issue only when the situation is out of hands.

Coming back to the topic & asking ourselves the question.

What is a Data CobWeb ?

Like a Spider’s net, with one common point. Data Cobweb can be described as a one point common library for all your Databases.

So, Database Centralization ?

……. YES !

Allow us to quantify the facts for you !

Our team has been fortunate to have conducted 50+ interviews with top shipping & PMS software companies to help us have streamlined our take on the above topic.

Refer to the below pictures for better understanding.

Vessel Database Centralization

Needless to say, the difference between both of them is massive.

More so, to justify why De-Centralized DB is a hassle of an experience, we would attempt to show some insights that would influence your view in a broader fashion.

Here, the quick collaborative outline for root causes we think are of prime importance:

  1. VolumeDepth of Data
  2. VelocitySpeed of data built
  3. VarietyVariance in Data
  4. Veracity– Trustworthiness.

The Last Lap:-

Volume: Depth of Data.

As we start building the Vessel database, it starts with small volume but with time and usage the depth of the database drastically increases. The one which initially only included Data captured from OEM manuals now also include various other modules in the database. Apart from PMS and Stock Items, these modules would range from Crewing database to Accounting to procurement.

Some organizations also include their various Trading Certificates, Class certificates in the databases.

A Centralized database gives a chance to include whole fleet of vessels data into one common central library.

– Velocity: Speed of data built

If we take Speedy building of databases into consideration; In case of Vessel wise database, we have to construct and capture the data from scratch, whereas in case of Centralized database, we need not capture the data again as the data captured earlier is already present in central library. All need to be done is, just select the matching equipment’s and distribute the data from One vessel to other vessel equipment wise. Which will eventually result in building database in lesser time.

Variety- Variance in Data

In centralized database construction, “Data Variance” could be a deciding factor, wherein if in a vessels database there are 12000 odd spares and similar count with same makers and built yards is present on the other vessel (Say Sister vessel) and both databases are being separately managed, it becomes tricky task. Where as in case of centralized databases this “Variance data” factor can be taken into consideration at the initial stage of constructing database and only not matching equipment data will be captured and rest can be distributed from the Original vessel.

This effect can be a large in a fleet with about 20 vessels i.e. 20 different or same Databases, and how about 100 vessels i.e. 100 Databases.

Centralized database gives owners good way to track everything on one single platform.

Veracity- Trustworthiness.

Building a trust on a centralized database can be a fruitful decision, if taken at right time. In the long run, Centralized database gives an advantage over de-centralized databases. A centralized database will not have Duplicate Spares, maintenances, components, attachments etc. Tracking of various requisitions becomes easier as everything can be monitored at one single location. Icing on the cake would be if your centralized database is Cloud or web-based, as the database can be accessed from any platform, be it on Mobile or at any other medium available.

…………and the final report:

There are Pros & Cons to both of the mentioned approaches.

Some works better for one company while the other works better for the second.

One should understand the purpose they want to acheive.

What are your thoughts ?

Ask your self this question.

You have a Vessel Database, how much percent of the database is useful?

                                                                                           –Food for a thought !