Database, data structure and framework transformer apparatuses, methods and systems
The Database, Data Structure and Framework Transformer Apparatuses, Methods and Systems (“DDSFT”) transforms variable list request, population selection, base table transform extract data inputs via DDSFT components into transformed, merged data outputs. The DDSFT includes a database structure that stores data used in the framework operations. A macro-tool includes one or more macros that control a sequence of database queries that extract the data from the database structure and then perform transformations on the extracted data. The macro-tool includes a series of binary flags indicative of whether or not statements are executed.
1. A processor-readable framework operably transformable data structure operations tool medium storing processor-executable components, the components, comprising:
a component collection stored in the medium, including:
a flag component;
a population join component;
an extract component; and
a transformation component;
wherein the flag component, stored in the medium, includes processor-issuable instructions to:
obtain a variable request list by a user;
generate a variable reference table datastructure;
determine and apply flags for variables in the variable request list, contexts and transformations, to join and mark for processing the variable request list with the generated variable reference table datastructure, wherein the determination and application of flags is configured to allow for the creation of a binary true data table with table element flags, and wherein contexts include time periods for an aggregation grain suitable for joining with a base table datastructure;
wherein the population join component, stored in the medium, includes processor-issuable instructions to:
obtain a population input selection from the user;
determine populations within specified time periods for an aggregation grain suitable for joining with the base table datastructure;
wherein the extract component, stored in the medium, includes processor-issuable instructions to:
obtain variables with applied flags from the flag component;
extract raw data from the base table datastructure in at least two dimensions including units of time and units of aggregation;
wherein the transformation component, stored in the medium, includes processor-issuable instructions to:
obtain a time grain flags from the flag component;
transform the user requested variable list requests, the population input selection, and base table datastructure transform extract data inputs into operably transformable merged data.
2. The medium of claim 1 , wherein the user may supply a transformation instruction on the operably transformable merged data without creating new variables.
3. The medium of claim 1 , wherein the units of aggregation may be at the plan/participant account level, an ip level, a plan level, a client level, a market segment level, and/or a business unit level.
4. A frameworking operations tool, comprising:
a memory;
a component collection in the memory, including:
a transform component,
an extract component;
a population join component; and
a flag component;
a processor disposed in communication with the memory, and configured to issue a plurality of processing instructions from the component collection stored in the memory,
wherein the processor issues instructions from the component collection, stored in the memory, to:
extract raw data, using said extract component, from a base table datastructure in at least two dimensions including units of time and units of aggregation;
compute flags, using said flag component, for tables, time units and variables, to join a user supplied variable definition file with a generated variable reference table datastructure to create a binary true data table datastructure with any of: table, element flags;
determine, using said population join component, populations within specified time periods for an aggregation grain suitable for joining with said base table datastructure; and
transform variable list requests, a population selection, and base table datastructure transform extract data inputs into transformed merged data outputs, using said transform component, to form a frameworking operations tool.
5. The apparatus of claim 4 , wherein the units of aggregation are at the plan/participant account level, an ip level, a plan level, a client level, a market segment level, and/or a business unit level.