Hi Kris Iam from RDBMS world to the Marklogic world, :)
There is collection ( fn:collection()) that you can group the documents under one collection called as country. I assume the XML / json documents also will have the country id or country element that you can link and lookup values. Thanks Manju From: [email protected] [mailto:[email protected]] On Behalf Of Cocoram007 Sent: Thursday, September 03, 2015 8:27 AM To: [email protected] Subject: [MarkLogic Dev General] Converting SQL Server db to Marklogic ecosystem Hi, I am just trying to understand the scenario of converting an existing SQL Server relational Db to Marklogic ecosystem. In SQL, we have tables and relationships between tables In Marklogic, we handle rows as documents, and we have one document for each row of the database table, Is it possible to establish a relationship between a group of documents (say a directory) to another directory(another group of documents)? Say, in detail, We have a Region table and daily Sales transaction table linked by Sales.country = Region.Country In Marklogic, we have Region Directory (Similar to SQL Region Table) and Sales Directory(Similar to Sales Transaction Table). How do we link these two directories on country? Can someone please shed some light on this? Thanks Kris This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
