Database, Data Structure and Framework Transformer Apparatuses, Methods and Systems
AssigneeFmr LLC
InventorsMelissa Christine Nysewander, Robert L. Virgile, Alexis Arias-Vargas
Life of this patent
Estimating the term…
Abstract
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.
Claims30
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;
- 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, 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;
- 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;
- wherein the extract component, stored in the medium, includes processor-issuable instructions to:
- obtain the variables with applied flags from the flag component;
- extract raw data from the base table 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 transform extract data inputs into operably transformable merged data.
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 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 to create a binary true data table with 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;
- and
- transform variable list requests, a population selection, and base table transform extract data inputs into transformed merged data outputs, using said transform component, to form a frameworking operations tool.
A processor-implemented method for orthogonal database table transformation operations, comprising:
- receiving a first data set responsive to a user's query based on a first particular context factor and a first particular transformation factor;
- receiving a second data set responsive to a user's query based on a particular context factor and a particular transformation factor;
- wherein said first data set and said second data set are generated without generating a new variable for each context factor and transformation factor.
A processor-implemented method for orthogonal database table transformation operations, comprising:
- applying a series of context factors, using a processor, to a variable;
- and
- applying a series of transformation factors, using said processor, to said variable;
- receiving a first data set responsive to a user's query based on a first particular context factor and a first particular transformation factor;
- receiving a second data set responsive to a user's query based on a particular context factor and a particular transformation factor;
- wherein said first data set and said second data set are generated without generating a new variable for each context factor and transformation factor.
A frameworking tool executing on a process for performing frameworking operations comprising:
- selecting and flagging a variable from a plurality of variables;
- using a macro-tool to select one or more macros that control a sequence of first SQL commands that extract data from a database structure;
- based on a selected context of a selected variable, generate second SQL commands to extract data from a database structure;
- based on a selected transformation of a selected variable, generate third SQL commands to extract data from a database structure;
- aggregate said first, second and third SQL commands to generate a custom variable for use in said frameworking tool.
A frameworking tool executing on a process for performing frameworking operations comprising:
- a database structure that stores data used in the frameworking operations;
- and
- a macro-tool that 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.
A method for performing frameworking operations comprising:
- providing a database structure that stores data used in the frameworking operations;
- implementing a macro tool being executed on a processor that 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 whether or not statements are executed.
Dependencies are inferred from the claim text.