Systems and methods for extracting data in column-based not only structured query language (nosql) databases

A computer program product comprising a machine readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:

• scanning all the rows in a desired table in the NoSQL database and producing a list of column families and associated column names;
• creating a schema for a new table having a table catalog of new column names using a Java Script Object Notation (JSON) structure to extract the columns names from the list of column families;
• reading and extracting at least a portion of the data from the desired table in the NoSQL database into the new table having the table catalog of new columns names;
• associating a creation timestamp with the new table;
• and
• saving the new table having the table catalog of new column names to the different database.

A system comprising:

• at least one programmable processor;
• a column-oriented Not Only Structured Query Language (NoSQL) database comprising a plurality of tables storing data, each table having one or more rows, wherein each row has a row key, and one or more column families, each column family having one or more column names wherein each column name is associated with stored data where the stored data in each column name has a timestamp associated with the stored data;
• at least one alternative storage database comprising flat files;
• a machine-readable medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
• scanning all the rows in a desired table in the NoSQL database and producing a list of the one or more column families and associated column names;
• creating a schema for a new table having a table catalog of new column names using a Java Script Object Notation (JSON) structure to extract the columns names from the list of column families;
• reading and extracting at least a portion of the data from the desired table in the NoSQL database into the new table having the table catalog of new columns names;
• associating a creation timestamp with the data in the new table;
• and
• saving the new table having the table catalog of new column names to the alternative storage database.