Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-142

Read-only views over collection data.

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 3.3.12
    • Usability
    • None
    • Storage Execution
    • Fully Compatible

    Description

      Issue Status as of Aug 31, 2016

      ISSUE SUMMARY
      MongoDB 3.3.12 adds support for creating read-only views over existing collections or other views. To specify or define a view, MongoDB introduces the viewOn and pipeline options to the existing create command:

      db.runCommand( { create: <view>, viewOn: <source>, pipeline: <pipeline> } )

      In addition, there's also a mongo shell helper db.createView():

      db.createView(<view>, <source>, <pipeline>)

      Views are readable via the following commands:

      For more information views, as well as examples, please see the Read-only Views documentation.

      Original description

      Support for read-only views will consist of providing a mechanism for binding a namespace name to a (namespace name, query) pair, where the query might be a MongoDB query or an aggregation expression. For example, if you had a collection "housing.apartments", you might create a view 

      housing.cheapApartments = (housing.apartments, { rent: { $lte: 1000 } })

      Finds on cheapApartments would only consider those elements of housing.apartments where the "rent" field was less than 1000.

      By using an aggregation expression with an unwind stage, you could produce a view over a database that had one document for every member of an array in an input document, providing another means to examine and query embedded documents.

      Attachments

        Issue Links

          is depended on by

          New Feature - A new feature of the product, which has yet to be developed. SERVER-283 Push on objects in virtual collection

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is documented by

          Task - A task that needs to be done. DOCS-10547 Docs for SERVER-142: Read-only views over collection data.

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. SERVER-10787 Read-only views

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-22733 Need SQL View like capability ..

          • Major - P3 - Major loss of function.
          • Closed

          Task - A task that needs to be done. SERVER-20968 Non-materialized views

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-10788 Writable views

          • Major - P3 - Major loss of function.
          • Backlog

          New Feature - A new feature of the product, which has yet to be developed. SERVER-828 Support for selecting array elements in return specifier (projection)

          • Major - P3 - Major loss of function.
          • Closed
          related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-19153 Conditionally push $match before $project

          • Critical - P2 - Crashes, loss of data, severe memory leak.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-22760 Sharded aggregation pipelines which involve taking a simple union should merge on mongos

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              Votes:
              318 Vote for this issue
              Watchers:
              192 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: