[teiid-issues] [JBoss JIRA] (TEIID-2958) MongoDB: Remove the need to have parent id in embedded table

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-2958.
---------------------------------

    Fix Version/s: 8.7.1
                   8.9
       Resolution: Done


Removed the need to contain the parent document key in the embedded document, which is duplication. This applies to all MERGE, EMBEDDED scenarios.

TEIID-3040 takes this concept further and removes the need for specifying the values as IDRef

> MongoDB:  Remove the need to have parent id in embedded table
> -------------------------------------------------------------
>
>                 Key: TEIID-2958
>                 URL: https://issues.jboss.org/browse/TEIID-2958
>             Project: Teiid
>          Issue Type: Enhancement
>      Security Level: Public(Everyone can see) 
>          Components: Misc. Connectors
>    Affects Versions: 8.7
>         Environment: MongoDB with Teiid
>            Reporter: Ivan Chan
>            Assignee: Ramesh Reddy
>              Labels: teiid
>             Fix For: 8.7.1, 8.9
>
>
> Currently, it seems like ID needs to be appear in parent and child for nested documents.  But it is unlikely a case for MongoDB customers.  It would be nice if Teiid can flatten out data in one single table.  Therefore, users would not need to insert parent id in the child document in order for Teiid to work.
> I am thinking the following case.  For example I have a JSON object like this:
> {code} 
> Customer
> {
>   _id: 1374932,
>   FirstName: "John",
>   LastName: "Doe",
>   Address:  {
>        _id: 43839430,
>        customer_id: IDRef("Customer", 1374932)
>         Street: "123 Lane",
>         City: "New York",
>         State: "NY",
>         Zipcode: "12345"
>      }
> }
> {code}
> the Teiid should work with document such as
>  
> {code} 
> Customer
> {
>   _id: 1374932,
>   FirstName: "John",
>   LastName: "Doe",
>   Address:  {
>        _id: 43839430,
>         Street: "123 Lane",
>         City: "New York",
>         State: "NY",
>         Zipcode: "12345"
>      }
> }
> {code}



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)