International Business Machines Corporation
SYSTEMS AND METHODS FOR EXTRACTING DATA IN COLUMN-BASED NOT ONLY STRUCTURED QUERY LANGUAGE (NOSQL) DATABASES

Abstract:

A method and/or system of extracting a table having data in a plurality of rows from a Not Only Structured Query Language (NoSQL) database to a different type of database that includes: 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.