(EN)
Thank you for reading this blog post. The Japanese version can be found below.
Recently, I wandered about strage type of tables.
I would write here the topic with basic knowledge of HANA database.
(JP)感谢您阅读这篇报道。
这次，因为对表格的存储类型抱有疑问，所以结合HANA数据库的构造进行了调查。
可能已经有很多人知道了，虚拟主机，如果能带着复习的意思和我交往的话就太好了。
日语文章记载在后半部分。
HANA is column databaseAlmost all the tables is column tableThe specific of Row table is following,There is no item to be culculated.ID is unique for the information.Not be modified informationThere is less rows than column tableThere is less columns than column table
We will be able to imagine specifically and use Properly both of column store and row store.
HANA DB has the structure of "in-memory database" and "column database".Two types of table storage types can be selected: row store and column store.
If you frequently calculate using stored information,use the column store.If this is not such case,use the low store basically.However, I was wondering how it was used concretely.
At first,I will compare HANA database with other database for prerequisite knowledge.Next,I explain the differences between Row store and Column store.I will also mention about concretely use cases.
Database
Memory close to the CPU: High-speed data communication possible / small capacity / volatileMemory away from the CPU: Access speed is relatively slow / large capacity / NonvolatileSpeed is different depending on where you place the data (there is a data hierarchy)
On-disc database and In-memory database
The delta buffer is concept for column storage database. It consists of three parts: L1 delta, L2 delta, and main store that is a column type database.
L1: Addition, Update, and Delete information for Database is stored as raw store without being compressed in the raw store
L2: L1 which is a row store in the background is converted to L2 which is a column store and it is compressed by an index
Main store: After acquiring and storing data from L2, it is compressed and relocated for high-speed access.
Thank you for reading
Best Regard，
Rena Takahashi
本文的总结
HANA为列型数据库大多数表格都是列类型低型表的特征如下没有可计算的值ID对于信息是唯一的不更改的信息行数比较少列数比较少
这篇文章的目标
具体想象列店和小铺，物联网智能家居，企业应用平台，可以正确区分使用。
我抱有的疑问
HANA DB具有"内存数据库"和"柱型数据库"的结构。表格的存储类型可以选择低存储和列存储两种。
使用保存的信息频繁计算时，基本上是列店，
如果不是这样的话，基本上是低店，
具体是如何活用的，我对此抱有疑问。
首先，作为解决该疑问的前提知识，将HANA的数据库结构与其他一般数据库进行对比。接下来，我们将说明小铺、列店的区别，网站建站平台，im即时通讯云，具体的使用方法将在实际的表格中进行说明。
关于数据库
靠近CPU的存储器：可高速进行数据通信/容量小/易失性
远离CPU的存储器：访问速度相对慢/容量大/非易失性
根据放置数据的位置访问的速度不同（数据等级有~。）
数据库的构造磁盘数据库和内存数据库
