Enabling dynamic data capture with database objects
A method and system for capturing dynamic data from data fields of a product has been developed. The method includes first collecting a product data set with multiple data fields. Static data fields of the product data set are identified that contain pre-defined standardized data for multiple other data sets. Next, dynamic data fields of the data set are identified. A dynamic data field is created by a user and contains additional data that is unique and applicable only to the product data set. The static data fields and the dynamic data fields are stored separately in a database repository for later recovery.
1. A method for capturing dynamic data from data fields for a product, comprising:
collecting a product data set containing multiple data fields;
identifying static data fields of the product data set, where a static data field contains pre-defined standardized data used by other data sets;
identifying dynamic data fields of the product data set, where a dynamic data field is created by a user and contains variable data from multiple different types of products and additional data that is unique only to the product data set; and
storing the static data fields and the dynamic data fields separately in a database repository for later recovery, where the dynamic data fields are stored in the database repository using a Javascript object notation (JSON) format and the dynamic data fields are treated as text values and do not require adherence to a specified data structure.
2. The method of claim 1 , where the static data fields contain pre-defined standardized data from multiple different types of products.
3. The method of claim 1 , where the pre-defined standardized data of the static data fields comprises a product name.
4. The method of claim 1 , where the pre-defined standardized data of the static data fields comprises a product identification number.
5. The method of claim 1 , where the pre-defined standardized data of the static data fields comprises metadata for the static data field.
6. The method of claim 1 , where the variable data of the dynamic data fields comprises characteristics of a product.
7. The method of claim 6 , where the characteristics of the product are physical features.
8. A system for capturing dynamic data from data fields for a product using multiple data fields in a database repository, comprising:
a processor and a non-transitory data memory storage media that control operations of the database repository;
a product data set containing multiple data fields;
at least one static data field that is fixed in the database repository and contains pre-defined standardized data used by other data sets of a user;
at least one dynamic data field of the product data set, where the dynamic data field is created by and edited by the user and contains variable data from multiple different types of products and additional data that is unique only to the product data set; and
where the static data fields and dynamic data fields are stored separately in the database repository for later recovery, where the dynamic data fields are stored in the database repository using a Javascript object notation (JSON) format and the dynamic data fields are treated as text values and do not require adherence to a specified data structure.
9. The system of claim 8 , where the static data field contains pre-defined standardized data from multiple different types of products.
10. The system of claim 8 , where the pre-defined standardized data of the static data field comprises a product name.
11. The system of claim 8 , where the pre-defined standardized data of the static data field comprises a product identification number.
12. The system of claim 8 , where the pre-defined standardized data of the static data field comprises metadata for the static data field.
13. The system of claim 8 , where the custom data of the dynamic data field comprises characteristics of a product.
14. The system of claim 13 , where the characteristics of the product are physical features.