Abstract: A table scan predicate with integrated semi-join filter is provided. A method includes receiving a query including: a request to join first data from a first table and second data from a second table, a first predicate for use in a table scan of the second table, and a second predicate including an expression associated with the first data from the first table and a reference to a column associated with the second data from the second table. The method may include transforming the second predicate into a dynamic predicate for execution of the query. the method may include applying the dynamic predicate to at least the first data. The method may include executing the query by at least scanning the second table based on the first predicate and filtered first data from the application of the dynamic predicate. Related systems and articles of manufacture are provided.

Abstract: A method for on-demand access to table partitions may include receiving, at a data execution engine, a query accessing a database table divided into a first partition and a second partition stored at different nodes of the database. The data execution engine may respond to the query by acquiring a lock on the database table and instantiating data structures to support the execution of the query without loading any of the partitions of the database table into a main memory. Instead, the loading of the individual partitions of the database table may be delegated to the operators tasked with performing the operations included in the execution plan for the query. Each operator may refrain from loading those partitions of the database table that are determined to be unnecessary for performing the individual operations. Related systems and computer program products are also provided.

Abstract: A query is received at a database execution engine. A query plan is generated by the database execution engine and for execution of the query. The query plan includes a first operator including computer executable instructions that upon execution queries a data structure of a database, determines whether the data structure satisfies a precondition for execution of a second operator of the query plan, and generates a signal indicating that the precondition is not satisfied. Execution of the query plan is initiated. A new query plan is generated by the database execution engine and in response to receiving the signal indicating that the precondition is not satisfied. Related systems, methods, and articles of manufacture are also described.

Abstract: The invention provides methods of assessing unbound PCSK9 or effective PCSK9 activity in a subject based on the novel insights of the inventors that high levels of PCSK9 are bound to HDL in vivo and that this HDL can activate PCSK9 function. Specifically depleting HDL from a sample from a subject allows improved assessment of the level of unbound PCSK9. The invention provides such analytical methods, plus also associated methods of treatment and related kits.

Abstract: A query is received at a database execution engine. A query plan including a sub plan structured as a directed acyclic graph is determined by the database execution engine. A set of trees characterizing the sub plan is generated by the database execution engine and using the directed acyclic graph. The set of trees include a first tree and a second tree, the first tree including at least one leaf characterizing a memory store operation and the second tree including a root characterizing a memory access operation. The set of trees are stored for use in execution of the query at run time. Related systems, methods, and articles of manufacture are also described.

Abstract: A method for enriching map functions of a digital geographical map is provided. Additional data are stored in a storage unit outside map data of the digital geographical map and direct related map metadata. Elements of the additional data are correlated to coordinates of the digital geographical map. Further, access is provided to the additional data via an authentication service while navigating the geographical map.

Abstract: A query is received at a database execution engine. A query plan including a sub plan structured as a directed acyclic graph is determined by the database execution engine. A set of trees characterizing the sub plan is generated by the database execution engine and using the directed acyclic graph. The set of trees include a first tree and a second tree, the first tree including at least one leaf characterizing a memory store operation and the second tree including a root characterizing a memory access operation. The set of trees are stored for use in execution of the query at run time. Related systems, methods, and articles of manufacture are also described.

Abstract: A query is received at a database execution engine. A query plan is generated by the database execution engine and for execution of the query. The query plan includes a first operator including computer executable instructions that upon execution queries a data structure of a database, determines whether the data structure satisfies a precondition for execution of a second operator of the query plan, and generates a signal indicating that the precondition is not satisfied. Execution of the query plan is initiated. A new query plan is generated by the database execution engine and in response to receiving the signal indicating that the precondition is not satisfied. Related systems, methods, and articles of manufacture are also described.

Abstract: A method for enriching map functions of a digital geographical map is provided. Additional data are stored in a storage unit outside map data of the digital geographical map and direct related map metadata. Elements of the additional data are correlated to coordinates of the digital geographical map. Further, access is provided to the additional data via an authentication service while navigating the geographical map.

Abstract: An optimized skiplist iterator technique for RCU-protected skiplists. A skiplist iterator operation may attempt to validate a cached pointer hint that references a skiplist element of an RCU-protected skiplist, the skiplist element having an associated first key. If the pointer hint is validated, the pointer hint may be dereferenced to access the skiplist element. A pointer in the skiplist element may be dereferenced to advance to a next skiplist element of the RCU-protected skiplist, the next skiplist element having an associated second key that is larger than the first key. If the pointer hint is not validated, a value-based skiplist iterator operation may be performed that includes traversing the RCU-protected skiplist using the first key to find the next skiplist element having the second key. A new pointer hint that references the next skiplist element may be cached for use in a next invocation of the skiplist iterator operation.

Abstract: Some embodiments are directed to a method of collecting information useful in predicting clinical outcome in a subject, the method including providing a sample from said subject, and determining the level of octameric PTX3 in said sample, wherein determining the level of octameric PTX3 includes measuring the total amount of PTX3 present, and measuring the amount of octameric PTX3 present, and calculating the proportion of total PTX3 which is present as octamer, wherein if the proportion of octameric PTX3 is greater than 50%, the subject is identified as a likely non-survivor. Some embodiments are also directed to a method of collecting information useful in predicting clinical outcome in a subject, the method including providing a sample from said subject, and determining the level of octameric PTX3 in said sample, wherein an elevated level of octameric PTX3 compared to a reference level indicates a reduced likelihood of survival.

Abstract: The present invention relates to a predictive diagnostic method for identifying whether a patient will develop metabolic syndrome and/or type-2 diabetes in the future. In particular, the invention relates to a method for identifying a subject which has a risk for developing metabolic syndrome and/or type-2 diabetes, wherein the method comprises (a) analyzing (i.e. determining/measuring/quantifying) in a sample obtained from a test subject the amount of miR-122; and (b) identifying (i.e. detecting) a subject, which has a risk for developing metabolic syndrome and/or type-2 diabetes, wherein an increased amount of miR-122 as compared to the amount of miR-122 of a healthy reference population indicates a risk for developing metabolic syndrome and/or type-2 diabetes. Another aspect of the invention relates to a method for monitoring the therapeutic success during the treatment of metabolic syndrome and/or type-2 diabetes, wherein the method comprises (a) analyzing (i.e.

Abstract: An optimized skiplist iterator technique for RCU-protected skiplists. A skiplist iterator operation may attempt to validate a cached pointer hint that references a skiplist element of an RCU-protected skiplist, the skiplist element having an associated first key. If the pointer hint is validated, the pointer hint may be dereferenced to access the skiplist element. A pointer in the skiplist element may be dereferenced to advance to a next skiplist element of the RCU-protected skiplist, the next skiplist element having an associated second key that is larger than the first key. If the pointer hint is not validated, a value-based skiplist iterator operation may be performed that includes traversing the RCU-protected skiplist using the first key to find the next skiplist element having the second key. A new pointer hint that references the next skiplist element may be cached for use in a next invocation of the skiplist iterator operation.

Abstract: Some embodiments are directed to a method of collecting information useful in predicting clinical outcome in a subject, the method including providing a sample from said subject, and determining the level of octameric PTX3 in said sample, wherein determining the level of octameric PTX3 includes measuring the total amount of PTX3 present, and measuring the amount of octameric PTX3 present, and calculating the proportion of total PTX3 which is present as octamer, wherein if the proportion of octameric PTX3 is greater than 50%, the subject is identified as a likely non-survivor. Some embodiments are also directed to a method of collecting information useful in predicting clinical outcome in a subject, the method including providing a sample from said subject, and determining the level of octameric PTX3 in said sample, wherein an elevated level of octameric PTX3 compared to a reference level indicates a reduced likelihood of survival.

Abstract: The present invention relates to a method of detecting diabetes and associated complications. The present invention also relates to a method of predicting diabetes. The present invention also relates to a method of detecting and/or predicting vascular disorders and cardiovascular disorders. The present invention also relates to kits for performing the methods of the present invention.

Abstract: The invention relates to markers for acute myocardial infarction (AMI), particularly markers that may be used in the rapid and accurate diagnosis of AMI or reinfarction. A method of diagnosing cardiac injury comprising identifying an elevated concentration of cardiac myosin binding protein C (cMyBP-C) or a fragment thereof or myosin regulatory light chain 2 (MLC2) or a fragment thereof in a sample obtained from a subject.

Abstract: The present invention relates to a method of detecting diabetes and associated complications. The present invention also relates to a method of predicting diabetes. The present invention also relates to a method of detecting and/or predicting vascular disorders and cardiovascular disorders. The present invention also relates to kits for performing the methods of the present invention.

Abstract: The invention relates to markers for acute myocardial infarction (AMI), particularly markers that may be used in the rapid and accurate diagnosis of AMI or reinfarction. A method of diagnosing cardiac injury comprising identifying an elevated concentration of cardiac myosin binding protein C (cMyBP-C) or a fragment thereof or myosin regulatory light chain 2 (MLC2) or a fragment thereof in a sample obtained from a subject.