首页 > 其他 > 详细

CS3402 Lecture 3

时间:2018-02-04 22:02:32      阅读:246      评论:0      收藏:0      [点我收藏+]

JSON

JavaScript Object Notation (JSON)

  • Serializing data objects 
  • Human-readable
  • Data Interchange
  • Representing and storing semistructured data 

 

Base Values:
  • Number, String, Boolean, etc
Objects ():
  • Sets of label-value pairs (key-value pairs) 
Arrays []:
  • List of values
{
"book": [
{
         "id":"01",
         "language": "Java",
         "edition": "third",
         "author": "Herbert Schildt"
}, {
      "id":"07",
      "language": "C++",
      "edition": "second",
      "author": "E.Balagurusamy"
}
]
}

Relational VS JSON

Relational JSON

  • Collection of Tables

  • Fixed Schema

  • Simple expressive language

  • Mature native systems 

JSON

  • Collection of Nested Sets and Arrays 
  • Schema not required in advance
  • Not as simple
  • Coupled with programming languages
    • Used in NOSQL systems anddoc-oriented DBMS 

 

JSON and PostgreSQL

 

 

Selecting

 

Filtering

 

 

Aggregation

 

 

 

 

 

 

 

 

 

 

CS3402 Lecture 3

原文:https://www.cnblogs.com/charon922/p/8414251.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!