Hello,
I have a few questions that I gathered when working with MarkLogic 8 trial
version on windows 7 enterprise.
What are your recommended configurations on windows server for evaluation and
data nodes?
A commodity server in 2013 might be a box with 2 CPUs, each 8 cores, 128
gigabytes of RAM, and either a large local disk or access to a SAN. On a box
such as this a rule of thumb is you can store roughly 1 to 2 terabytes of data
was written in "Inside MarkLogic Server", does it apply to MarkLogic 8 running
on Windows servers (could be windows 2008R2 or windows 2012 server)?
How data encryption is handled for data file at rest on disk, data field in the
database etc.?
We have PHI data and we will need to have them encrypted. I didn't find much
information on how data are encrypted in a MarkLogic 8 database.
How do we set up application authentication so each user can access data
records only pertinent to the person or certain group level?
We may have multiple levels of user groups, some user can only access data
pertinent to the person, some user can access data pertinent to certain group
level. Some user may have access to all the data.
Are there any known issues when running MarkLogic on a windows system that we
need to be aware of?
What are some of the best ways to query (XQuery) distinct data records?
When multiple objects could join together and there could be one-to-many or
many-to-many relationship among objects? Or one data element could have
one-to-many relationship with another data element in a nested json document.
Some workable examples will help.
The query below was given by MarkLogic and it didn't return the distinct
records. (in this example, Patient, Claim and PatientAddress are three objects
and they can be joined together by using PatientIdentifier, a patient can have
multiple patient addresses, and a patient can also have multiple claims. We
plan to use nested json format to model all three objects in one document later
on.)
(
for $patient in /Patient
let $patient-address := /PatientAddress[PatientIdentifier =
$patient/PatientIdentifier] (:[State eq "LA"]:)
let $claims := /Claim[PatientIdentifier eq $patient/PatientIdentifier]
let $sum :=
cts:sum-aggregate(
cts:element-reference(xs:QName("MedicalServicesTotalCost")),
(),
cts:element-value-query(xs:QName("PatientIdentifier"),
$patient/PatientIdentifier))
for $claim in $claims
for $address in $patient-address
let $arr := json:array()
return (
json:array-push($arr, $patient/PatientIdentifier/fn:string()),
json:array-push($arr, $address/State/fn:string()),
json:array-push($arr, $claim/ClaimNumber/fn:string()),
json:array-push($arr, $sum),
$arr
)
)[1 to 10]
Why application builder didn't work with Json document when I tried to create
an application with patient, claim and patient address documents?
Error Message:
<error:error xsi:schemaLocation="http://marklogic.com/xdmp/error error.xsd"
xmlns:error="http://marklogic.com/xdmp/error";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<error:code>XDMP-CHILDNODEKIND</error:code>
<error:name/>
<error:xquery-version>1.0-ml</error:xquery-version>
<error:message>Invalid child node kind</error:message>
<error:format-string>XDMP-CHILDNODEKIND: fn:doc($uri)[fn:not(binary())] --
element nodes cannot have object node children</error:format-string>
<error:retryable>false</error:retryable>
<error:expr>fn:doc($uri)[fn:not(binary())]</error:expr>
<error:data>
<error:datum>element</error:datum>
<error:datum>object</error:datum>
</error:data>
<error:stack>
<error:frame>
<error:uri>/appbuilder/lib/preview.xqy</error:uri>
<error:line>95</error:line>
<error:column>65</error:column>
<error:operation>prev:do-preview()</error:operation>
<error:xquery-version>1.0-ml</error:xquery-version>
</error:frame>
<error:frame>
<error:uri>/appbuilder/lib/preview.xqy</error:uri>
<error:line>138</error:line>
<error:column>0</error:column>
<error:operation>xdmp:invoke("/appbuilder/lib/preview.xqy",
(fn:QName("","projectxml"),
fn:doc("/projects/16449182781019934866.xml")/project, fn:QName("","view"),
...), <options
xmlns="xdmp:eval"><database>6465878920948848186</database></options>)</error:operation>
<error:xquery-version>1.0-ml</error:xquery-version>
</error:frame>
<error:frame>
<error:uri>/MarkLogic/appservices/utils/common-amped.xqy</error:uri>
<error:line>276</error:line>
<error:column>9</error:column>
<error:operation>amped-common:appservices-invoke("/appbuilder/lib/preview.xqy",
(fn:QName("","projectxml"),
fn:doc("/projects/16449182781019934866.xml")/project, fn:QName("","view"),
...), <options
xmlns="xdmp:eval"><database>6465878920948848186</database></options>)</error:operation>
<error:variables>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/util-amped";>path</error:name>
<error:value>"/appbuilder/lib/preview.xqy"</error:value>
</error:variable>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/util-amped";>vars</error:name>
<error:value>(fn:QName("","projectxml"),
fn:doc("/projects/16449182781019934866.xml")/project, fn:QName("","view"),
...)</error:value>
</error:variable>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/util-amped";>options</error:name>
<error:value><options
xmlns="xdmp:eval"><database>6465878920948848186</database></options></error:value>
</error:variable>
</error:variables>
<error:xquery-version>1.0-ml</error:xquery-version>
</error:frame>
<error:frame>
<error:uri>/appbuilder/lib/render.xqy</error:uri>
<error:line>36</error:line>
<error:column>4</error:column>
<error:operation>rend:preview(fn:doc("/projects/16449182781019934866.xml")/project,
"search", "/PatientDocumentDB/LSU_Claim_31307382.json")</error:operation>
<error:variables>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/builder/render";>projectxml</error:name>
<error:value>fn:doc("/projects/16449182781019934866.xml")/project</error:value>
</error:variable>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/builder/render";>view</error:name>
<error:value>"search"</error:value>
</error:variable>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/builder/render";>uri</error:name>
<error:value>"/PatientDocumentDB/LSU_Claim_31307382.json"</error:value>
</error:variable>
</error:variables>
<error:xquery-version>1.0-ml</error:xquery-version>
</error:frame>
<error:frame>
<error:uri>/appbuilder/lib/render.xqy</error:uri>
<error:line>25</error:line>
<error:column>13</error:column>
<error:operation>rend:render(fn:doc("/projects/16449182781019934866.xml")/project,
"search")</error:operation>
<error:variables>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/builder/render";>project</error:name>
<error:value>fn:doc("/projects/16449182781019934866.xml")/project</error:value>
</error:variable>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/builder/render";>type</error:name>
<error:value>"search"</error:value>
</error:variable>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/builder/render";>db</error:name>
<error:value>xs:unsignedLong("6465878920948848186")</error:value>
</error:variable>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/builder/render";>sample</error:name>
<error:value>fn:doc("/PatientDocumentDB/LSU_Claim_31307382.json")/object-node()</error:value>
</error:variable>
<error:variable>
<error:name
xmlns="http://marklogic.com/appservices/builder/render";>project-name</error:name>
<error:value>xs:untypedAtomic("TestApplication")</error:value>
</error:variable>
</error:variables>
<error:xquery-version>1.0-ml</error:xquery-version>
</error:frame>
<error:frame>
<error:uri>/appbuilder/results.xqy</error:uri>
<error:line>114</error:line>
<error:column>40</error:column>
<error:xquery-version>1.0-ml</error:xquery-version>
</error:frame>
</error:stack>
</error:error>
This is the content in LSU_Claim_31307382.json document, range index was
created for every field in this document.
{
"Claim":
{
"ClaimNumber": "12345678",
"ClientGroup": "LSU",
"PatientIdentifier": "9999999",
"ServiceStartDate": "2014-03-25T05:00:00Z",
"ServiceEndDate": "2014-03-25T05:00:00Z",
"ProviderIdentifier": "111111",
"ProviderSpecialty": "HOSPITAL",
"ProviderSpecialtyCMSTaxonomy": "HOSP",
"PlaceOfServiceCMS": 4,
"RevenueCode": "I",
"ServiceType": "Medical Care",
"ClaimType": "FACILITY",
"FacilityIdentifier": 4,
"MedicalServicesTotalCost": 100.5,
"PharmacyTotalCost": 0,
"LoadDateTime": "2015-04-24T16:15:22.4558282Z",
"DischargeStatusCode": "01",
"ProviderType": "HOSP",
"ProviderStandardSpecialty": "HOSPITAL",
"LoadType": "Initial",
"ClientClaimType": "FACILITY",
"TypeOfBill": "21",
"TypeOfFacility": "Out-Patient Hospital",
"BillClassification": "0",
"TypeOfBill3": "21",
"ClaimFrequencyCode": "NA",
"EQClaimType": "Other",
"OutpatientServiceTypeCode": "U",
"OutpatientServiceType": "NA",
"AdmissionTypeCode": "U",
"AdmissionType": "NA",
"OperatingProviderIdentifier": "8888888888",
"OperatingProviderType": "Billing",
"ACO_ClaimType": "NA"
}
}
Thank you very much,
Cynthia Jiang
RDA Corp
_______________________________________________
General mailing list
[email protected]
Manage your subscription at:
http://developer.marklogic.com/mailman/listinfo/general
