๋ฌธ์„œ ๋ฉ”๋‰ด

๋ฌธ์„œ ํ™ˆ โ†’ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๊ฐœ๋ฐœ โ†’ MongoDB ๋งค๋‰ด์–ผ

$log10 (์• ๊ทธ๋ฆฌ๊ฒŒ์ด์…˜)

์ด ํŽ˜์ด์ง€์˜ ๋‚ด์šฉ

  • ์ •์˜
  • ํ–‰๋™
  • ์˜ˆ์ œ
$log10

๋ฒ„์ „ 3.2์— ์ƒˆ๋กœ ์ถ”๊ฐ€๋˜์—ˆ์Šต๋‹ˆ๋‹ค.

์ˆซ์ž์˜ ๋กœ๊ทธ์ง„์ˆ˜๋ฅผ ๊ณ„์‚ฐํ•˜๊ณ  ๊ฒฐ๊ณผ๋ฅผ double๋กœ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

$log10 ์˜ ๊ตฌ๋ฌธ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค:

{ $log10: <number> }

<number> ํ‘œํ˜„์‹์€ ์Œ์ˆ˜๊ฐ€ ์•„๋‹Œ ์ˆซ์ž๋กœ ํ•ด์„๋˜๋Š” ํ•œ ์œ ํšจํ•œ ํ‘œํ˜„์‹ ์ผ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ํ‘œํ˜„์‹์— ๋Œ€ํ•œ ์ž์„ธํ•œ ๋‚ด์šฉ์€ ํ‘œํ˜„์‹์„ ์ฐธ์กฐํ•˜์„ธ์š” .

$log10 ์€ $log: [ <number>, 10 ] ํ‘œํ˜„์‹๊ณผ ๋™์ผํ•ฉ๋‹ˆ๋‹ค.

์ธ์ˆ˜๊ฐ€ null ๊ฐ’์œผ๋กœ ํ•ด์„๋˜๊ฑฐ๋‚˜ ๋ˆ„๋ฝ๋œ ํ•„๋“œ๋ฅผ ์ฐธ์กฐํ•˜๋Š” ๊ฒฝ์šฐ $log10์€ null์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์ธ์ˆ˜๊ฐ€ NaN์œผ๋กœ ํ•ด์„๋˜๋Š” ๊ฒฝ์šฐ, $log10์€ NaN์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ์ œ
๊ฒฐ๊ณผ
{ $log10: 1 }
0
{ $log10: 10 }
1
{ $log10: 100 }
2
{ $log10: 1000 }
3

๋‹ค์Œ ๋ฌธ์„œ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ samples ๋ผ๋Š” ์ด๋ฆ„์˜ ์ƒ˜ํ”Œ collection์„ ์ƒ์„ฑํ•ฉ๋‹ˆ๋‹ค.

db.samples.insertMany(
[
{ _id: 1, H3O: 0.0025 },
{ _id: 2, H3O: 0.001 },
{ _id: 3, H3O: 0.02 }
]
)

๋‹ค์Œ ์˜ˆ์—์„œ๋Š” ์ƒ˜ํ”Œ์˜ ์‚ฐ๋„ ๊ฐ’์„ ๊ณ„์‚ฐํ•ฉ๋‹ˆ๋‹ค.

db.samples.aggregate( [
{ $project: { pH: { $multiply: [ -1, { $log10: "$H3O" } ] } } }
] )

์ด ์—ฐ์‚ฐ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

{ "_id" : 1, "pH" : 2.6020599913279625 }
{ "_id" : 2, "pH" : 3 }
{ "_id" : 3, "pH" : 1.6989700043360187 }

ํŒ

๋‹ค์Œ๋„ ์ฐธ์กฐํ•˜์„ธ์š”.

โ†ย $log (์• ๊ทธ๋ฆฌ๊ฒŒ์ด์…˜)

์ด ํŽ˜์ด์ง€์˜ ๋‚ด์šฉ