Patent ID: 11892973
Assignee: WESTERN DIGITAL TECHNOLOGIES, INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 7:
8. 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.