This chapter covers the following topics:
The robust and comprehensive data lake used by Oracle Adaptive Intelligent Apps for Manufacturing contains the following three types of data stores:
Relational/structured data store to store data from various relational data sources such as Enterprise Resource Planning (ERP), Supply Chain Management (SCM), Customer Relationship Management (CRM), Human Capital Management (HCM), Manufacturing Execution Systems (MES), and Quality systems.
Time series data store to store data from various machines and sensors such as temperature, pressure, and vibration as well as from external environmental sources such as temperature and humidity.
Unstructured data store to store information such as notes, comments, and log files.
Oracle Adaptive Intelligent Apps for Manufacturing stores manufacturing operations data in the following two databases:
Oracle Database Cloud Service
Oracle Storage Cloud Service
Oracle Database Cloud Service and Oracle Storage Cloud Service are underlying architectural components of Oracle Adaptive Intelligent Apps for Manufacturing. General information about how Oracle Adaptive Intelligent Apps for Manufacturing uses each database is provided below. For detailed information about these two databases, see:
Oracle Database Cloud Service serves as the data lake for Oracle Adaptive Intelligent Apps for Manufacturing by storing structured data used for analysis. The types of data stored in this database include Enterprise Resource Planning (ERP) application data, Manufacturing Execution System (MES) data, and Quality/LIMS, sensor device mapping definition, and summarized machine sensor data. This data is used for model building and analysis, lot genealogy, presenting the manufacturing time line, and providing a real-time overview of factory events in the Factory Command Center.
Oracle Storage Cloud Service serves as the data lake for semi-structured data. The types of data stored in this database include raw sensor data and contextualized machine sensor data in parquet partition tables. It stores the granular data of both stream and alert data processed from the sensor data files. Save the sensor data in CSV file format and store it in the Storage Cloud. Specify the file path in the Upload Files page in the Data tab of the Sensor Devices page. Storage cloud also stores the sensor device mapping definition CSV files which are used to import sensor device mappings.