摘要
传统的关系型数据库在字段扩展方面一直存在争议,主要表现在流量大的情况下,更新过程中会出现负载过高等风险。文章通过分析库、表、字段、主键、索引、行、列等数据库特性,提出一种新的数据库设计,以行转列方式动态添加字段,实现数据库的字段扩展。
The traditional relational database has always been controversial in terms of field expansion,mainly in the case of large traffic,and there will be risks such as excessive load during the update process.By analyzing database characteristics such as database,table,field,primary key,index,row,column,etc.,this paper proposes a new database design,which dynamically adds fields by row-to-column and realizes field expansion of the database.
作者
李春炜
LI Chunwei(Armed Police Command Academy,Tianjin 300250)
出处
《软件》
2023年第3期128-130,共3页
Software
关键词
数据库
关系型
行
列
字段
索引
属性
范式
中间件
聚集
database
relational
row
column
field
index
property
paradigm
middleware
aggregation
