The invention discloses a method for automatically generating
library table resources based on data collection, and relates to the technical field of
big data. Comprising the steps of 1, configuring basic information of
library table resources through a front end, 2, uploading an Excel
data file, 3, creating a
library table: automatically detecting whether the library table exists or not, updating a table structure if the library table exists, and automatically constructing a data table structure according to the configured basic information of the library table resources if the library table does not exist, 4, importing data: sending a request to a
file server, the method comprises the following steps: step 1, acquiring an Excel file by introducing a
unique identifier of a file, analyzing file content, and generating and executing
SQL (Structured
Query Language) statements to import data in batches, and step 2, creating library table resources: associating the imported data with a corresponding catalog according to a configured
information resource catalog, and setting resource attributes: setting a corresponding attribute for each library table resource, the method comprises the following steps of: storing basic information of library table resources in a
metadata system, and generating and managing the library table resources: generating a library table
resource management system which comprises all imported data tables and catalogs and
metadata information associated with the data tables,
data resources are managed and queried through a
system.