Embedded database on the edge of the IoT
Petrosoft selected IBM Informix Enterprise Edition as the strategic database platform for powering its next-generation IoT devices.
Vladimir Peregoncev, CTO of Petrosoft, recalls: “We were looking for an enterprise-class database that was truly tailored for use in an IoT environment, and IBM Informix fit the bill perfectly. With Informix, we get excellent scalability and strong security, and can manage both structured and unstructured data effectively. What’s more, the platform has a very small footprint, making it ideal as an embedded database.”
Sergei Gorloff adds: “Choosing an enterprise solution from a company like IBM means that we get a mature, proven platform that is backed by professional support. We know we can rely on IBM and that peace of mind is a great bonus.”
Petrosoft took advantage of a flexible payment solution from IBM Global Financing to help finance the new Informix software and related support services. Sergei Gorloff says: “We found working with IBM Global Financing to be very easy. We were able to negotiate a flexible payment plan that allows us to conserve capital to meet other strategic needs—a big plus for a mid-sized company.”
Petrosoft has enlisted Advanced DataTools, an IBM Silver Business Partner and Informix specialist, to help develop and deploy its new database environment.
By embedding the Informix database platform in its Direct Connect devices, Petrosoft will make it possible for the devices to capture streaming data from numerous devices and systems used in clients’ forecourts and convenience stores.
Petrosoft will also replicate that data to IBM Informix Advanced Enterprise Edition databases on its back-end cloud platform. Here, Informix provides enterprise class hybrid data management capabilities across various data types—structured, unstructured, time-series, spatial and more—and consolidates these disparate sources of information into a single source of intelligence. Clients can then load the data into analytics and enterprise reporting systems to support better-informed decisions and optimize their operations.
To drive even shorter time-to-insight, Petrosoft will make use of Informix Warehouse Accelerator—a feature of Informix Advanced Enterprise Edition—to boost the performance of data warehouse queries. By using the same proven enterprise technology on both its cloud platform and embedded devices, Petrosoft will gain a truly end-to-end analytics foundation—helping it deliver rapid and reliable fuel information services to clients.
In addition, to ensure that clients have round-the-clock access to the latest data from their front-end systems, Petrosoft will use Informix High Availability Data Replication (HDR) to continuously replicate data from the primary Informix database to a secondary data server. This means that clients will be able to continue capturing and working with data even in the event of network downtime or a hardware failure.
Crucially, IBM Informix offers very fine-grained security—both for data in motion and at rest in the database. Sergei Gorloff explains: “Security is a prime concern for our clients, as they are trusting us with their operational data. Informix provides very strong encryption and data governance features, so we can rest assured that all data will be in safe hands.”
Pumping up performance
With its new generation of Direct Connect devices offering data management both in the cloud and at the edge of the network, Petrosoft can offer clients a much more powerful, reliable and efficient way to capture and aggregate data from connected devices and business systems.
Vladimir Peregoncev states: “By embedding databases on the Direct Connect devices, we can minimize the impact of factors such as bandwidth and latency on database performance. So, while the platform will remain connected to back-end systems via the cloud, it will be much less dependent on those connections, helping clients enjoy steady performance—a key benefit for clients in countries where internet connections are not very reliable.”
Sergei Gorloff adds: “With Informix, we can manage a huge volume and variety of data in a very flexible way—and all on a single database platform. This allows us to serve up information to clients through their Direct Connect device faster than ever. With more rapid insight into operations, clients can make quicker, better-informed decisions about everything—from forecasting the quantity of fuel they should order for the coming week to planning what merchandise they stock in different convenience stores. Having this kind of control helps our clients to keep operations running smoothly, safely and profitably.”
The straightforward scalability of the solution will support Petrosoft’s ambitious plans to expand its operations. Currently, Petrosoft serves clients in 13 countries worldwide; it is planning to increase this to 27 countries in the next 18 months—adding thousands of new client locations and an even greater number of connected devices and systems.
“Right now, our Direct Connect devices interact with thousands of devices at clients’ facilities, but we expect that number to grow to more than 100,000 connected devices by the end of 2018,” notes Sergei Gorloff. “Having an enterprise-class database like Informix at the heart of our solution will make it possible for us to scale up to support this huge growth in client numbers and data volumes without missing a beat.”
He concludes: “Petrosoft has been growing steadily over the past decade, and we have no intention of slowing down. We have big ambitions to expand the business to all corners of the globe, and support from strategic partners like IBM is key to reaching our goals. With leading technology like IBM Informix powering Petrosoft solutions, we are opening up new insights for our clients that help them fuel innovation and run more efficiently.”