Non-relational databases¶
Spreadsheets¶
workbook >> n worksheets >> m x n cells >> 1 data
A cell is the intersection of a row and column, where the columns are labeled with alphabetical characters and rows labeled numerically.
Formulas
Excel has functions, or predefined formulas to perform calculations on cell values.
NoSQL¶
NoSQL is an umbrella term for the different ways to store non-relational data and can be interpreted as "non-SQL", "non-relational" or "not only SQL".
These type of database systems can be categorized into 4 types.
Key-value databases 键值存储数据库¶
Graph databases 图形数据库¶
Columnar data 列存储数据库¶
Document data 文档型数据库¶
使用 Azure Cosmos DB 记录数据存储¶
拓展阅读¶
- Overview of formulas
- Overview of formulas in Excel
- Non-relational data and NoSQL
- This architectural documentation details the characteristics in the different types of non-relational data
- Work with NoSQL data in Azure Cosmos DB
- Excel 帮助和学习