Automated extension of database field length

A computer system for automating an extension of field length in a database, comprising:

• one or more processors;
• and
• non-transitory computer-readable storage media encoding instructions which, when executed by the one or more processors, causes the computer system to:
• perform data mining on the database by analyzing database structures;
• identify patterns in column usage, data types, and storage requirements across the database;
• train an artificial intelligence algorithm based upon the data mining and the patterns to develop predictive models for optimal chunking strategies based on database-specific characteristics;
• allow the artificial intelligence algorithm to automatically determine when data in a first column of a table in the database exceeds a field length based upon the predictive models;
• define, by the artificial intelligence algorithm, a chunk size for the data in the first column, wherein the chunk size is a predetermined size used to divide the data that exceeds the field length into manageable portions for storage across multiple columns to enhance database efficiency;
• create a second column in the table;
• break the data according to the chunk size into a first portion to be stored in the first column and a second portion to be stored in the second column;
• and
• create a vector representing the data stored in the first column and the second column by transforming the data into a vector representation that enables efficient indexing.