Storing Data

This chapter covers the following topics:

Overview of Storing Data

The robust and comprehensive data lake used by Oracle Adaptive Intelligent Apps for Manufacturing contains the following three types of data stores:

Oracle Adaptive Intelligent Apps for Manufacturing stores manufacturing operations data in the following two databases:

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:

Using the Database Cloud Service

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.

Using the Storage Cloud Service

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.