I suspect you are curious if the PI Server's data is a SQL database or a similar relational database. The PI Server's "database" is referred to as the PI Archive. The PI Archive "database" is a unique data storage tool that stores timestamps and values for process information. The PI "System" as it is often referred to at OSIsoft is the Asset Framework Database (AF). This is a database in the traditional sense stored and accessed using Microsoft SQL server.
The definition of terms helps. The PI Archive "database" is where PI Point data is stored. For example the bearing temperature of a pump over time will be stored as timestamps, and values at those specific times. The PI AF Database is a brilliant tool for building a hierarchy of "elements" representing process equipment, plant systems, and many other frameworks of capital equipment (assets).
By the way, OSIsoft provides various tools to allow developers to access the PI Data Archive using SQL Tools. This means even though the archive data is not a SQL database you have the ability, using the tools available, to perform C.R.U.D. operations using SQL commands.
By the way, OSIsoft provides various tools to allow developers to access the PI Data Archive using SQL Tools. This means even though the archive data is not a SQL database you have the ability, using the tools available, to perform C.R.U.D. operations using SQL commands.
