Prologis Leverages the Denodo Platform and Snowflake to Modernize and Accelerate Analytics

• 分析与建模 - 实时分析
• 基础设施即服务 (IaaS) - 云计算
• 基础设施即服务 (IaaS) - 云存储服务

• 商业运营

• 质量预测分析
• 实时定位系统 (RTLS)

• 云规划/设计/实施服务
• 数据科学服务

Prologis, a global real estate asset management company, was struggling with its data management system. The company's data was stored in a variety of languages and dispersed across different geographical locations. The existing system was an on-premises data warehouse comprised of 27 servers supporting a series of databases, integration servers, and reporting servers. The system was becoming outdated and inefficient, with ETL scripts needing to be rewritten and re-tested whenever there was a change in the source environment. Migrations were all-day events that required the entire team, and with every test, a complete regression test of the entire stack was needed to ensure that nothing broke. Prologis wanted to modernize its data infrastructure to include cloud capabilities and introduce efficiencies that would accelerate analytics, without causing undue downtime.

Prologis is a global leader in logistics real estate solutions. Founded in 1983, the company has 1,600 employees in 19 countries and manages over $111 billion in assets, representing over 797 million square feet across these countries. Prologis collaborates with customers to achieve operational efficiencies, reduce environmental impacts, and improve communities. The company's vast portfolio of real estate assets generates a staggering amount of data every day, which needs to be integrated effectively for the company to operate its business.

To modernize its data infrastructure, Prologis implemented a Snowflake cloud-based data warehouse alongside its existing on-premises data warehouse. Snowflake's ability to scale on demand based on the query being run and accommodate both structured and semi-structured data made it an ideal choice. To further enhance its data infrastructure, Prologis leveraged the Denodo Platform, which uses data virtualization to integrate data in real time from myriad disparate data sources without replicating data to a new consolidated repository. The Denodo Platform acts as an intelligent data-access layer between data sources and data consumers, abstracting data consumers from the complexities of access. This enabled Prologis to establish a logical data warehouse architecture that provides real-time access to data across on-premises, cloud, and other sources. The Denodo Platform's data catalog lists all available data assets in a single location, and also delivers the listed data on-demand. Using this catalog, Prologis was able to implement a higher level of diligence in data management, providing standard definitions for every column and every view, as well as detailed documentation for every object.

• Prologis was able to transition smoothly to Snowflake with the help of the Denodo Platform, moving chunks of data from the old architecture to the new one without impacting business operations.
• The implementation of a logical data warehouse configuration allowed Prologis to accelerate analytics. The company could virtualize a new table and immediately start doing analytics on it.
• Prologis leveraged the query push-down capabilities of the Denodo Platform to push key workloads to Snowflake, resulting in substantial performance improvements on larger data sets.

• Accelerated analytics activities by as much as 30%.