Method and system for dynamically modifying database metadata and structures
First Claim
1. A computer implemented method for modifying a database structure in a computer, the computer having a processor coupled with a memory and adapted to enable a database management software, the method comprising:
- a. Structuring a database table having at least one data field having a data field width allocation;
b. Receiving a data record having at least one data field that exceeds the a corresponding data field width allocation;
c. Attempting to insert or update the data record into the database;
d. Detecting a DBMS error message indicating that at least one data field exceeds a data field allocation width;
e. Comparing each data field content of the data record with a corresponding data field width allocation as described by metadata of the database;
f. Determining a new metadata data field width allocation, the new metadata data field width allocation greater or equal to a width sufficient to store the corresponding data field content of the data record;
g. Adjusting the metadata data field width allocation to the new metadata data field width allocation; and
h. Inserting or updating the data record into the database.
1 Assignment
0 Petitions
Accused Products
Abstract
A system and method enable the selection of database records for editing and writing. A database record is queried for the size of the data fields contained therein. The size of the data field is compared to the field width limitation of a storage database. When it is determined that the data field displays a size greater than the size of the field width limitation of the storage database, a computing device extends the size of the limitation to accommodate the new database record data field. When the size of the limitation is expanded, the new database record is written to the storage database. The system and method may optionally include the input of a user at the final steps, wherein the user may optionally approve or disapprove the extension of the size of the field width limitation.
17 Citations
16 Claims
-
1. A computer implemented method for modifying a database structure in a computer, the computer having a processor coupled with a memory and adapted to enable a database management software, the method comprising:
-
a. Structuring a database table having at least one data field having a data field width allocation; b. Receiving a data record having at least one data field that exceeds the a corresponding data field width allocation; c. Attempting to insert or update the data record into the database; d. Detecting a DBMS error message indicating that at least one data field exceeds a data field allocation width; e. Comparing each data field content of the data record with a corresponding data field width allocation as described by metadata of the database; f. Determining a new metadata data field width allocation, the new metadata data field width allocation greater or equal to a width sufficient to store the corresponding data field content of the data record; g. Adjusting the metadata data field width allocation to the new metadata data field width allocation; and h. Inserting or updating the data record into the database. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A computer implemented method for modifying a database structure in a computer, the computer having a processor coupled with a memory and adapted to enable a database management software, the method comprising:
-
a. Structuring a data base having at least one data field having a metadata width allocation; b. Receiving a data assigned to the at least one data field that exceeds the metadata width allocation; c. Determining a new metadata width allocation, the new metadata width allocation equal to a memory size sufficient to store the data; d. Informing a user that the data exceeds the metadata width allocation of the data field; and e. Increasing the metadata width allocation to the new width allocation. - View Dependent Claims (7, 8, 9, 10)
-
-
11. A computer comprising:
-
a. a memory; b. a processor coupled with the memory, the processor and memory adapted to enable a database management software, wherein the memory is configured to store instructions that, when executed by the processor, cause the computer to; i. Structure a database having at least one data field having a metadata width allocation; ii. Receive a data assigned to the at least one data field that exceeds the metadata width allocation; iii. Determine a new metadata width allocation, the new metadata width allocation equal to a memory size sufficient to store the data; and iv. Increase the metadata width allocation to the new width allocation. - View Dependent Claims (12)
-
-
13. A computer implemented method for modifying a database structure in a computer, the computer having a processor coupled with a memory and adapted to enable a database management software, the method comprising:
-
a. Structuring a database table having at least one data field having a data field width allocation as maintained in a metadata; b. Receiving a data record having at least one data field having a content that exceeds a corresponding data field width allocation of the metadata; c. Determining a new metadata data field width allocation, the new metadata data field width allocation greater or equal to a width sufficient to fully store the content of the at least one data field of the data record; d. Adjusting the corresponding metadata data field width allocation to the new metadata data field width allocation; and e. Inserting or updating the data record into the database. - View Dependent Claims (14, 15, 16)
-
Specification