Hi Sam,
Thank you for the response, that really helped me. As you mentioned Im going to try out things with example you have given. Thanks & Regards, Srinivas | Sr CakePHP Programmer +91 - 9538025790 | [email protected] nerve centrex software (India) pvt. Ltd. 122 soudhamini 3rd main gruhalakshmi layout II stage Kamalanagar Bangalore 560079 Karnataka India cid:[email protected] Disclaimer: This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of Nerve Centrex Software (India) Pvt. Ltd., its subsidiaries and affiliates. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify Nerve Centrex immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Nerve Centrex Software (India) Pvt. Ltd., its subsidiaries and affiliates therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by Nerve Centrex Software (India) Pvt. Ltd., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. From: [email protected] [mailto:[email protected]] On Behalf Of Sam Mefford Sent: Friday, February 13, 2015 11:18 PM To: MarkLogic Developer Discussion Subject: Re: [MarkLogic Dev General] Problem designing DB Architecure for MarkLogic I don't want to overwhelm you, but it's worth pointing out that in order to design a schema I usually take much more into account: 1. What kinds of queries will you run? Which data items need value queries, range queries, facets, term queries, wildcard queries, etc.? What will be your peak query throughput? 2. Where does your external data come from? How often will you get updates? What transformations will you perform as you get it? 3. What data is created/managed in MarkLogic? How do you keep data managed in MarkLogic distinct from data managed elsewhere but copied to MarkLogic? 4. How is data presented through the application? What transformations for search results, list pages, detail pages? Since I've done mostly search applications, one of the most important things I'm trying to determine is the granularity of search results so ideally one document maps to one search result. Since there's a lot to account for, you might engage some consulting to help you through the process until you're ready to do it yourself. With that said, to just try things out you can model your data several different ways. Here's one example: <User> <Id>1</Id> <Group_id>Group1</Group_id> <Name>Mark</Name> <Project> <Name>Project1</Name> </Project> </User> <User> <Id>2</Id> <Group_id>Group2</Group_id> <Name>Lisa</Name> <Gallery> <album_Id>1</album_Id> <Album_Name>Myalbum1</Album_Name> </Gallery> </User> Sam Mefford Senior Engineer MarkLogic Corporation [email protected] Cell: +1 801 706 9731 www.marklogic.com This e-mail and any accompanying attachments are confidential. The information is intended solely for the use of the individual to whom it is addressed. Any review, disclosure, copying, distribution, or use of this e-mail communication by others is strictly prohibited. If you are not the intended recipient, please notify us immediately by returning this message to the sender and delete all copies. Thank you for your cooperation. On 2/13/2015 12:45 AM, Srinivas wrote: Hi All, Can some body assists me how to build an architecture for this in Marklogic DB. This application is built on MySQL now we are trying to migrate it to MarkLogic. If somebody could assist me building this in MarkLogic, that would help me a lot. How to relate one document collection to another. Ex: Ø User group1 has Projects, Products as their sub level of data storage Ø User Group2 has Gallery associated with him User Table: Id Group_id Name 1 Group1 Mark 2 Group2 Lisa Project Table: Project_Id User_id Name 1 1 Project1 2 1 Project2 Gallery: album_Id User_id Album Name 1 2 Myalbum1 Registration,Profile1,Profile2,projects,Products,achievements,Postings,Galle ry Thanks & Regards, Srinivas | Sr CakePHP Programmer +91 - 9538025790 | [email protected] nerve centrex software (India) pvt. Ltd. 122 soudhamini 3rd main gruhalakshmi layout II stage Kamalanagar Bangalore 560079 Karnataka India cid:[email protected] Disclaimer: This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of Nerve Centrex Software (India) Pvt. Ltd., its subsidiaries and affiliates. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify Nerve Centrex immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Nerve Centrex Software (India) Pvt. Ltd., its subsidiaries and affiliates therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by Nerve Centrex Software (India) Pvt. Ltd., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
