This image shows how Oracle Data Platform for retail can be used to support merchandising optimization and help retailers predict, sense, and shape demand. The platform includes the following five pillars:
Data Sources, Discovery
Ingest, Transform
Persist, Curate, Create
Analyze, Learn, Predict
Measure, Act
The Data Sources, Discovery pillar includes four categories of data.
Business record data comprises sales transactions, customer data, product data, returns transactions, suppliers, inventory, POS system data, revenue, and margin data.
Application data comes from ERP, SCM, CX, and WMS, Fusion SaaS, NetSuite, E-Business Suite, PeopleSoft, JD Edwards, SAP, Salesforce, and Workday applications.
Third-party data includes data from Oracle Data Cloud and social data.
Technical input data includes logs, web clicks, event streams, and beacons.
The Ingest, Transform pillar comprises four capabilities.
Batch ingestion uses OCI Data Integration, Oracle Data Integrator, and DB tools.
Bulk transfer uses OCI FastConnect, OCI Data Transfer, MFT, and OCI CLI.
Change data capture uses OCI GoldenGate.
Streaming ingest uses Kafka Connect.
All four capabilities connect unidirectionally into the serving data store and cloud storage within the Persist, Curate, Create pillar.
Additionally, streaming ingest is connected to stream processing within the Analyze, Learn, Predict pillar.
The Persist, Curate, Create pillar comprises five capabilities.
The serving data store uses Autonomous Data Warehouse and Exadata Cloud Service.
Managed Hadoop uses Oracle Big Data Service.
Cloud storage uses OCI Object Storage.
Batch processing uses OCI Data Flow.
Governance uses OCI Data Catalog.
These capabilities are connected within the pillar. Cloud storage is unidirectionally connected to the serving data store and managed Hadoop; it is also bidirectionally connected to batch processing.
Managed Hadoop is unidirectionally connected to the serving data store.
Two capabilities connect into the Analyze, Learn, Predict pillar: The serving data store connects to both the analytics and visualization capability and the data products, APIs capability, and the cloud storage capability connects to the machine learning capability.
The Analyze, Learn, Predict pillar comprises four capabilities.
Analytics and visualization uses Oracle Analytics Cloud, GraphStudio, and ISVs.
Data products, APIs uses OCI API Gateway and OCI Functions.
Machine learning uses OCI Data Science, Oracle ML, and Oracle ML Notebooks.
Streaming processing uses GoldenGate Stream Analytics and stream analytics from third parties.
The Measure, Act pillar comprises three consumers: people and partners, applications and models.
People and partners comprise Historical Sales Analysis, Customer Segmentation, Promotion Impact Analysis, Pricing Impact Analysis.
Applications comprises Economic Indicators, Buying Behaviour, Real Time Demand Prediction, Inventory Prediction.
Models comprises Social Media Sentiment Analysis, Collaborative Forecasting and Demand Planning.
The three central pillars—Ingest, Transform; Persist, Curate, Create; and Analyze, Learn, Predict—are supported by infrastructure, network, security, and IAM.