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]<mailto:[email protected]>
Cell: +1 801 706 9731
www.marklogic.com<http://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,Gallery]
Thanks & Regards,
Srinivas | Sr CakePHP Programmer
+91 - 9538025790 | [email protected]<mailto:[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]<mailto:[email protected]>
http://developer.marklogic.com/mailman/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
