Editing Ingres (database) (section)

===Storage architecture===
Ingres is a disk-oriented DBMS, and by default employ the n-ary storage model (NSM),<ref>{{cite web 
  |url=https://db.cs.cmu.edu/papers/2016/arulraj-sigmod2016.pdf
  |title=Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads
  |last1=Arulraj
  |first1=Joy
  |last2=Pavlo 
  |first2=Andrew
  |last3=Menon 
  |first3=Prashanth 
  |date=June 2016
  |website=db.cs.cmu.edu  
  |publisher=Association for Computing Machinery
  |access-date= June 16, 2023}}
</ref> also known as a row-store.

However, Actian has incorporated columnar storage into its latest version of Ingres (Actian X) to improve its performance on OLAP tasks. Actian X has two storage engines, the traditional Ingres and X100, the same engine from [[Actian Vector]].

Although it is currently branded as the "Actian X Hybrid Database", the term "Hybrid" refers to its capability of performing both OLTP and OLAP tasks by employing a hybrid storage model (i.e. both row and column), not that it has a hybrid storage architecture.<ref>{{Cite web|url=https://www.actian.com/wp-content/uploads/2017/04/DS21-ActianX_04A.pdf|title=Actian X Hybrid Database|website=[[Actian]]}}</ref>

Regarding the storage organization, Ingres supports [[Heap (data structure)|Heap]], [[Hash table|Hash]], [[ISAM]] and [[B-tree]].<ref>{{Cite web|url=https://communities.actian.com/s/article/Choosing-Storage-Structures-for-your-Ingres-Database|title=BaseChoosing Storage Structures for your Ingres Database|website=communities.actian.com}}</ref>