14. The method of claim 8 , wherein the executing query is processed with the MPBPC cursor which uses a holistic tree pattern of multilevel nested recursive cursors to simultaneously join PS-Index partitions of the PS-Index.
8. A computer implement method for processing one or more inputted XPath queries against one or more inputted XML documents stored in a plurality of computer hardware processors (CPU) and memory, comprising: loading an XML document into computer memory; generating a first index that comprises unique root to leaf paths (SUM-Index), a second index that comprises tree nodes grouped by unique path identifiers (PS-Index), and a third index that comprises values of the tree nodes grouped by path identifiers (PV-Index) from the XML document, wherein the SUM-Index, the PS-Index and the PV-Index each have at least one root to leaf unique path identifier (PID) and are linked together by at least one PID originating from the SUM-Index; annotating the SUM-Index with PID for each unique root to leaf path; stores the SUM-Index, PS-Index, and PV-Index on column stores distributed across a plurality of CPUs partitioned by PID: parsing and splitting an XPath query at articulation points into multiple partial queries; determining cursor type index access methods; executing a multiple partial queries against the SUM-Index to generate a list of applicable one or more PID values in the PS-Index and the PV-Index that satisfies partial query segments; generating a set of ancestor-descendant PID identifiers list from an associated SUM-Index tree by extracting annotated PID values to initialize a simple cursor or a multi-predicate branching path cursor (MPBP); searches the PS-Index that is a search index that is portioned on PID; generating a result sequence using the simple cursor or the MPBPC cursor from a PS-Index tree; searches the PV-Index that is a search index that is partitioned on PID; filtering the result sequence of nodes by using a PV-Index tree; and producing one or more outputted XML documents from a final result sequence of nodes.