Measure Calculations Based on a Structured Document
A method and system for calculating a measure result includes a specification loader that receives a measurement specification including a representation of a measure and identifies, based on a measure schema, one or more components in the measurement specification. The system also includes a specification compiler that generates, based on the identified one or more components, executable code. The system further includes an analytics engine that receives one or more parameters to apply to the measurement specification, executes the executable code using the one or more parameters to extract data from a data set, and stores a result set of the executed code in a database.
1 . A system for calculating a measure result, the system comprising:
a specification loader that receives a measurement specification including a representation of a measure and identifies, based on a measure schema, one or more components in the measurement specification;
a specification compiler that generates, based on the identified one or more components, executable code; and
an analytics engine that receives one or more parameters to apply to the measurement specification, executes the executable code using the one or more parameters to extract data from a data set, and stores a result set of the executed code in a database.
2 . The system of claim 1 , wherein the measurement specification is an XML document.
3 . The system of claim 1 , wherein the measurement specification is human readable.
4 . The system of claim 1 , wherein the specification compiler compiles the executable code and stores the compiled executable code in a second database.
5 . The system of claim 4 , wherein the executable code includes one or more relational database stored procedures.
6 . The system of claim 1 , wherein the specification loader parses, based on the measure schema, the measurement specification, and identifies, based on the measure schema, the one or more components in the measurement specification.
7 . The system of claim 1 , wherein the analytics engine extracts an evidence pool from the data set to determine measure evidence and calculate derivations based on the measure evidence.
8 . The system of claim 1 , wherein the analytics engine calculates assertions based on the derivations and measure evidence.
9 . The system of claim 1 , wherein the analytics engine processes a set of rules based on the assertions to determine an initial population, numerator, and denominator.
10 . The system of claim 1 , wherein the analytics engine determines a measure result based on the numerator and denominator.
11 . A method of calculating a measure result, the method comprising:
receiving a measurement specification including a representation of a measure;
identifying, based on a measure schema, one or more components in the measurement specification;
generating, based on the identified one or more components, executable code;
receiving one or more parameters to apply to the measurement specification;
executing the executable code using the one or more parameters to extract data from a data set; and
storing a result set of the executed code in a database.
12 . The method of claim 11 , wherein the measurement specification is an XML document.
13 . The method of claim 11 , wherein the measurement specification is human readable.
14 . The method of claim 11 , further comprising:
compiling the executable code; and
storing the compiled code in a second database.
15 . The method of claim 11 , wherein the generating includes generating one or more stored procedures.
16 . The method of claim 11 , further comprising:
extracting an evidence pool from the data set to determine measure evidence;
calculating derivations based on the measure evidence;
calculating assertions based on the derivations and measure evidence; and
processing a set of rules based on the assertions to determine an initial population, numerator, and denominator.
17 . The method of claim 16 , further comprising:
determining a measure result based on the numerator and denominator.
18 . The method of claim 11 , further comprising:
receiving data in a first format; and
transforming the data from the first format into a uniform structure.
19 . The method of claim 11 , further comprising:
generating a report based on the result set.
20 . A non-transitory machine-readable medium comprising a plurality of machine-readable instructions that when executed by one or more processors is adapted to cause the one or more processors to perform a method comprising:
receiving a measurement specification including a representation of a measure;
identifying, based on a measure schema, one or more components in the measurement specification;
generating, based on the identified one or more components, executable code;
receiving one or more parameters to apply to the measurement specification;
executing the executable code using the one or more parameters to extract data from a data set; and
storing a result set of the executed code in a database.