本文主要是介绍How to deal with document-oriented data，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
- Schema design
- Data models for e-commerce
- Nuts and bolts of databases, collection, and documents.
Principles of schema design
- What are your application access pattern?
- What's the basic unit of data? the basic unit of data is the BSON document
- What are the capabilities of your database?
- What makes a good unique id or primary key for a record?
Designing an e-commerce data model
[root@DBAMAXWELL ~]# vi user_actions.rb
require 'mongo'
VIEW_PRODUCT = 0 # action type constants
ADD_TO_CART = 1
CHECKOUT = 2
PURCHASE = 3
client = Mongo::Client.new([ '127.0.0.1:27017' ], :database => 'garden')
client[:user_actions].drop
actions = client[:user_actions, :capped => true, :size => 16384]
actions.create
500.times do |n| # loop 500 times, using n as the iterator
doc = {
:username => "kbanker",
:action_code => rand(4), # random value between 0 and 3, inclusive
:time => Time.now.utc,
:n => n
}
actions.insert_one(doc)
end
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"user_actions.rb" [New] 18L, 508C written
[root@DBAMAXWELL ~]# chmod 775 user_actions.rb
[root@DBAMAXWELL ~]# ruby user_actions.rb
[root@DBAMAXWELL ~]# mongo
MongoDB shell version v4.4.13
connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb
Implicit session: session { "id" : UUID("b9c56822-9b9a-4d7b-8a11-1e9b31be1f7b") }
MongoDB server version: 4.4.13
---
The server generated these startup warnings when booting:
2022-03-23T23:33:56.417+08:00: Access control is not enabled for the database. Read and write access to data and configuration is unrestricted
---
---
Enable MongoDB's free cloud-based monitoring service, which will then receive and display
metrics about your deployment (disk utilization, CPU, operation statistics, etc).
The monitoring data will be available on a MongoDB website with a unique URL accessible to you
and anyone you share the URL with. MongoDB may use this information to make product
improvements and to suggest MongoDB products and deployment options to you.
To enable free monitoring, run the following command: db.enableFreeMonitoring()
To permanently disable this reminder, run the following command: db.disableFreeMonitoring()
---
> use garden
switched to db garden
> db.user_actions.count()
199
> db.user_actions.find().pretty()
{
"_id" : ObjectId("623eaf017c6c2558c3a33434"),
"username" : "kbanker",
"action_code" : 0,
"time" : ISODate("2022-03-26T06:13:21.193Z"),
"n" : 301
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33435"),
"username" : "kbanker",
"action_code" : 2,
"time" : ISODate("2022-03-26T06:13:21.195Z"),
"n" : 302
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33436"),
"username" : "kbanker",
"action_code" : 3,
"time" : ISODate("2022-03-26T06:13:21.196Z"),
"n" : 303
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33437"),
"username" : "kbanker",
"action_code" : 3,
"time" : ISODate("2022-03-26T06:13:21.197Z"),
"n" : 304
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33438"),
"username" : "kbanker",
"action_code" : 0,
"time" : ISODate("2022-03-26T06:13:21.199Z"),
"n" : 305
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33439"),
"username" : "kbanker",
"action_code" : 3,
"time" : ISODate("2022-03-26T06:13:21.201Z"),
"n" : 306
}
{
"_id" : ObjectId("623eaf017c6c2558c3a3343a"),
"username" : "kbanker",
"action_code" : 3,
"time" : ISODate("2022-03-26T06:13:21.203Z"),
"n" : 307
}
{
"_id" : ObjectId("623eaf017c6c2558c3a3343b"),
"username" : "kbanker",
"action_code" : 1,
"time" : ISODate("2022-03-26T06:13:21.204Z"),
"n" : 308
}
{
"_id" : ObjectId("623eaf017c6c2558c3a3343c"),
"username" : "kbanker",
"action_code" : 0,
"time" : ISODate("2022-03-26T06:13:21.206Z"),
"n" : 309
}
{
"_id" : ObjectId("623eaf017c6c2558c3a3343d"),
"username" : "kbanker",
"action_code" : 1,
"time" : ISODate("2022-03-26T06:13:21.208Z"),
"n" : 310
}
{
"_id" : ObjectId("623eaf017c6c2558c3a3343e"),
"username" : "kbanker",
"action_code" : 1,
"time" : ISODate("2022-03-26T06:13:21.210Z"),
"n" : 311
}
{
"_id" : ObjectId("623eaf017c6c2558c3a3343f"),
"username" : "kbanker",
"action_code" : 1,
"time" : ISODate("2022-03-26T06:13:21.212Z"),
"n" : 312
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33440"),
"username" : "kbanker",
"action_code" : 3,
"time" : ISODate("2022-03-26T06:13:21.214Z"),
"n" : 313
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33441"),
"username" : "kbanker",
"action_code" : 3,
"time" : ISODate("2022-03-26T06:13:21.216Z"),
"n" : 314
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33442"),
"username" : "kbanker",
"action_code" : 1,
"time" : ISODate("2022-03-26T06:13:21.217Z"),
"n" : 315
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33443"),
"username" : "kbanker",
"action_code" : 1,
"time" : ISODate("2022-03-26T06:13:21.219Z"),
"n" : 316
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33444"),
"username" : "kbanker",
"action_code" : 1,
"time" : ISODate("2022-03-26T06:13:21.221Z"),
"n" : 317
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33445"),
"username" : "kbanker",
"action_code" : 2,
"time" : ISODate("2022-03-26T06:13:21.223Z"),
"n" : 318
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33446"),
"username" : "kbanker",
"action_code" : 0,
"time" : ISODate("2022-03-26T06:13:21.225Z"),
"n" : 319
}
{
"_id" : ObjectId("623eaf017c6c2558c3a33447"),
"username" : "kbanker",
"action_code" : 0,
"time" : ISODate("2022-03-26T06:13:21.227Z"),
"n" : 320
}
Type "it" for more
> db.createCollection("users.actions",{capped: true, size: 16384, max: 100})
{ "ok" : 1 }
> db.reviews.createIndex({time_field: 1}, {expireAfterSeconds: 3600})
{
"createdCollectionAutomatically" : true,
"numIndexesBefore" : 1,
"numIndexesAfter" : 2,
"ok" : 1
}
> db.system.namespaces.find()
> db.system.namespaces.find();
> db.system.namespaces.find();
> db.system.indexes.find();
>
Documents and insertion
> db.numbers.save({n: 5})
WriteResult({ "nInserted" : 1 })
> db.numbers.save({n: NumberLong(5)});
WriteResult({ "nInserted" : 1 })
> db.numbers.find({n: 5});
{ "_id" : ObjectId("623ec3abe05ac712a59cc348"), "n" : 5 }
{ "_id" : ObjectId("623ec3cde05ac712a59cc349"), "n" : NumberLong(5) }
> db.numbers.find({n: {$type: 1}});
{ "_id" : ObjectId("623ec3abe05ac712a59cc348"), "n" : 5 }
> db.numbers.find({n: {$type: 18}});
{ "_id" : ObjectId("623ec3cde05ac712a59cc349"), "n" : NumberLong(5) }
>
这篇关于How to deal with document-oriented data的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
