Dynamic Table Creation for For Each Catalog and Related Product Table for Every Season---Is Good or Bad Idea in term of Performance and DataMaintance

We are creating catalog for product. As part of our requirement

1. We are creating catalog for different season in year for different customers.Catalog can be configured depend on different data source type which is blank,direct,inherited.

Blank: We are first time creating catalog by uploading data using excel sheet Direct: We can share Catalog to other customer. Inherited: We can share Catalog to customer but customer can add some more attribute to product etc

There are two steps. a) Select configuration of catalog b)Upload data for catalog.

2.Important requirement is that We should be able to share catalog to other customer or one customer can share catalog to other customer.

Approach:

Catalog Configuration Step 1: a)We are creating Attribute group .At The Same time Product dynamic table will be created (ref AttribGroupTable Coloumn)

AttribGroupTable

AttribGroupID AttribGroupName AttribGroupTable 1 Season123 Attribute Group Prd_Dyn_Season123 2 Season435 Attribute Group Prd_Dyn_Season435

AttribType Table AttribTypeID AttribType 1 string

2 int

Attribute Table AttribID AttribName AttribTypeID 1 xyz 1 2 abc 1

Prd_Dyn_Season123 ProductCode xyz abc 111111 dd cc 111112 bb ff

b) Now we will also insert catalog related information in catalog table.This table have dynamic catalog table name which we will create at the time of catalog configuration

Catalog Table CID Code Name DataSourceTypeID ProductDataSource RefProductDataSource IsFullCataLogShared

1 123 Season123Catalog 1 Null Catalog_Prd_Season123 1 2 124 Season435Catalog 2 Null Catalog_Prd_Season435 1

Catalog_Prd_Season123 CPID CatalogCode ProductCode ExtendedAttribGroupID IsArticalShared 1 123 111111 NULL 0 2 123 111112 NULL 0 3 123 111113 NULL 0

C) Finally Master Product Table is where we will uplaod product data after complete catalog configuration

ID ProductCode ProductNumber AttribGroupID 1 111111 12345 1 2 111112 67890 1 3 111113 66756 1

Case2. If Now I want to share my Catalog to other customer for inherited data source type reference then I am again creating attribute group and dynamic table for product (Not master table) and catalog dynamic table and referencing to parent catalog table to in other catalog creation using reference catalog column.

Is Dynamic table and dynamic catalog table creation is good idea in term of performance and maintenance plus retrieval,insert,update

The approach which I am using is in right direction or should i use another one.Please provide your suggestion