Database

Showing 302

Support expressions in $densify range bounds

The $densify aggregation pipeline stage seems unable to evaluate range bounds expressions, requiring the range bounds to be constant. See the following example (the collection testcoll contains a single documents with only the _id field): ``` s...

Guest almost 4 years ago in Querying & Aggregations 3 Submitted

1 VOTE

Multiple unique single indexes in sharded collections

MongoDB sharded collection can only have one unique index which is the shard key. However, in real applications, one might need more than one single unique index. "Proxy" collections suggested in https://www.mongodb.com/docs/manual/tutorial/unique...

Guest over 1 year ago in Data Modeling & Indexing 1 Submitted

4 VOTE

Low latency Change Stream for Global Cluster in Atlas

our event-driven applications need to publish events to Kafka triggered by Change Stream feature. It works perfect in replicaset MongoDB cluster. However, after migrating to Global Cluster in Atlas, the Change Stream cannot keep low latency becau...

Guest about 5 years ago in Database 1 Submitted

2 VOTE

Tool for score data model

It would be great to have a tool which can scores a data model from a specific database. I mean, I could allows this tool to scan a database model and score this data model based on best practices, patterns and anti patterns. It could also generat...

Guest over 2 years ago in Data Modeling & Indexing 0 Submitted

3 VOTE

collection-level users should be able to list their collections

Currently users with collection-specific read or read/write permissions are not authorized to perform the following commands: db.listCollections() show collections db.getCollectionNames() This impacts the shell (and also third party tools that w...

Guest almost 4 years ago in Database 0 Submitted

4 VOTE

Include schema validation events in changestream payload

let's say my document has JSON schema validation like: { $jsonSchema: { properties: { phone: { bsonType: 'string' } } } } and the validation action is set to "warning", if I do a command like: db.test.insert({"phone":1}), I would like t...

Guest over 5 years ago in Database 1 Submitted

4 VOTE

Data masking policy

Implement Data masking similar to Schema Validation in Mongo so that customer can define a server-side data masking policy to mask the results of a query and a new role which will give explicit permission to users for reading unmasked data

Guest over 5 years ago in Database 0 Submitted

2 VOTE

Flatten arrays in group stage

Have group operators to flatten document arrays into a single one with or without repeated elements. So -> doc1 = {arr: [1,2,3,4], gr: "group"}, doc2 = {arr: [5, 6, 7, 8], gr: "group"} {$group: {_id: "$gr", arrays: {$***: "$arr"} } } => {_id...

Guest over 2 years ago in Querying & Aggregations 1 Submitted

4 VOTE

Extend db.collection.distinct() to work with multiple fields in a compound key

Currently the distinct() command finds the unique set of values for a SINGLE specified field across a collection or view. For example: db.staff.distinct("last_name" ) If there is an index on the last_name field, the DISTINCT_SCAN plan can use th...

Guest over 5 years ago in Database 1 Submitted

2 VOTE

Cascading delete for DBRefs

Since transactions have been added in 2018, which work across collections (https://www.mongodb.com/docs/manual/core/transactions/) and across shards (https://www.mongodb.com/docs/manual/core/transactions-sharded-clusters/), shouldn't cascading del...

Guest over 2 years ago in Storage & Transactions 0 Submitted

Please enter your email address

FILTER BY CATEGORY