[teiid-issues] [JBoss JIRA] (TEIID-3040) MongoDB: Remove the IDREF fields for the FK fields

[Ramesh Reddy (JIRA)]

Ramesh Reddy created TEIID-3040:
-----------------------------------

             Summary: MongoDB: Remove the IDREF fields for the FK fields
                 Key: TEIID-3040
                 URL: https://issues.jboss.org/browse/TEIID-3040
             Project: Teiid
          Issue Type: Enhancement
      Security Level: Public (Everyone can see)
            Reporter: Ramesh Reddy
            Assignee: Steven Hawkins


TEIID-2958 has been working towards removing the IDREF fields from embedded documents. I see no reason to represent FK in the parent table with IDREF either. This will make the document model representation simple and aligns with how a typical developer would design.

for ex: Currently we have

{code}
{
	"_id" : 1,
	"firstName" : "Ramesh",
	"lastName" : "Reddy",
	"email" : DBRef("EMail", "abc at abc.com"),
	"acct_id" : DBRef("Accounts", 1),
	"Accounts" : {
		"Name" : "Wireless"
	},
	"EMail" : {
		"provider" : "Comcast"
	}
}
{code}

change to:
{code}
{
	"_id" : 1,
	"firstName" : "Ramesh",
	"lastName" : "Reddy",
	"email" :  "abc at abc.com",
	"acct_id" : 1,
	"Accounts" : {
		"Name" : "Wireless"
	},
	"EMail" : {
		"provider" : "Comcast"
	}
}
{code}




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