Emulation of code-description tables on SQL databases using Enum data type

A controller for a data storage device, comprising:

• an I/O to one or more memory devices;
• and
• a processor configured to execute a method for data schema detection and migration, the method comprising:
• receiving a portion of a first file comprising a plurality of records;
• detecting a reference in one of the records to a code-description table;
• defining a schema for the first file based on the data types in at least one record of the plurality of records, comprising at least one schema element comprising at least two descriptors of the code-description table;
• storing data from the first file and the schema in the one or more memory devices;
• identifying a mismatch between data of the first file and a second file;
• updating a field type to match a mismatched data type by adding a new field to the schema resulting in a new column in a data table to allow for a missing field to have a location in the data table;
• maintaining an exception queue;
• determining the exception queue is empty;
• stopping identifying mismatches;
• determining a last data record has been reached;
• and
• executing a plurality of database operations comprising:
• a query on the data table;
• a record insert on the data table;
• a record update on the data table;
• and
• a record deletion on the data table.

A system for storing data, comprising:

• one or more memory means;
• and
• an SSD controller means configured to carry out a method for data schema detection and migration, the method comprising:
• detecting field hierarchy of a first file and a reference to a code-description table;
• defining a schema means based on the field hierarchy, the schema comprising a schema element describing a portion of the code-description table comprising a plurality of descriptors;
• defining a data table based on the schema means and the first file;
• identifying a mismatch between data of the first file and a second file;
• updating a field type to match a mismatched data type by adding a new field to the schema resulting in a new column in the data table to allow for a missing field to have a location in the data table;
• maintaining an exception queue;
• determining the exception queue is empty
• stopping identifying mismatches;
• determining a last data record has been reached;
• and
• executing a plurality of database operations comprising:
• a query on the data table;
• a record insert on the data table;
• a record update on the data table;
• and
• a record deletion, on the data table.