Hi Kris, When we bring over documents (rows) from a relational system, we typically put the rows into a collection so we know something about their source and that they have some set relationship we wish to maintain.
http://docs.marklogic.com/guide/search-dev/collections As for joining, before you go there, you're likely going to denormalize the tables. If you haven't seen it yet, MarkLogic has a free, on-demand course for data modeling: XML and JSON Data Modeling Best Practices : http://mlu.marklogic.com/ondemand/ I also find Damon's presentation on moving from XML to document oriented models very helpful: http://www.marklogic.com/resources/slides-moving-from-relational-modeling-to-xml-and-marklogic-data-models/ Denormalizing can be done in MarkLogic using a simple transformation module and a utility such as CORB. http://developer.marklogic.com/code/corb After denormalizing, you may find your join key is no longer required. As for joins across the new objects that you create, the keys may present themselves naturally in the data, or then you have other options for how to perform joins in MarkLogic. Hope this helps, Pete From: [email protected] [mailto:[email protected]] On Behalf Of Rajendran, Manju Sent: Thursday, September 03, 2015 8:50 AM To: [email protected] Subject: Re: [MarkLogic Dev General] Converting SQL Server db to Marklogic ecosystem 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]> [mailto:[email protected]] On Behalf Of Cocoram007 Sent: Thursday, September 03, 2015 8:27 AM To: [email protected]<mailto:[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
