mysql - Database design: Best Way to store heterogeneous subtypes of a parent class? -

-

website has products different categories (phones, tablets, washing machines, ... etc)

  • each product have diff. prices depending on store (if user views galaxy s4 16gb show $x xstore , $y ystore)

  • the website have heavy filtration. instance phones might filtered according price, color, .. etc. filtered manufactures or stores. (all samsung products, products @ xstore, ... etc)

  • for reason specs of each category should stored separately (phones: screensize, memory, os, ... etc. watches have different spec ..).

  • each category (phones or watches) expected have ~1000+ product.

question:

i first thought of pyramid-like design. 1 table products adding general table each category common specifications (for phones have screen-size, os, ..), third table variations (memory:16gb or 32gb, price @ each store, ... etc).

problem is: main table products large (thousands), , heavy filtrations have go , forth between 3 tables @ least, , if i'm filtering samsung products, have deal more table (tablets, laptops, ... etc). i'm not sure whether go performance point of view.

so thought of straight forward way; creating 1 single table each category. variations duplicated (galaxy s4 16gb , 32gb 2 rows , 16gb price @ xstore , ystore in 2rows). know violates normalisation. table can barely exceed 1000 rows way, i'll end having simpler code, , think performance efficient don't need index. case need deal tables when i'm filtering manufacturer i'll 've grab samsung tablets, phones, etc..

sorry elaborating, trying make clear possible don't have schemas. patience appreciated , i'm open new suggestions.

thanks in advance :)

edit

the questions categorization (only 1 level phones, tablets, ..etc) each in separate table vs in 1 table , subs category , diff attributes or specs. it's performance question.

category sub category can single table parent child relation have many sub levels

or list category in 1 table , table specify relation

id category parent 1 samsung    0 2 note       1 3  apple     0 4 ipad       3

store sperate table products table category id foreign key pricing table product id , store id foreign keys

just brief idea !!


Comments

Post a Comment

Popular posts from this blog

java - Run a .jar on Heroku -

-
i trying run .jar file on heroku, , can't find instructions anywhere on how this. have read wants me compile uploading heroku. possible, , if is, how this? if helps, trying run minecraft craftbukkit server, , don't have pom.xml file yet. you didn't provide details i'll try give , people reaches question way it. first of all, create heroku account , create heroku application (assumed have done that). second, need generate application jar , upload heroku. so, open terminal , install heroku cli (assuming unix terminal): $ sudo npm install -g heroku-cli you need have npm , nodejs installed, can check link: https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-16-04 once done that, can use npm update node version acceptable heroku-cli: $ sudo npm install -g n $ sudo n 7.10.0 and run: $ sudo npm install -g heroku-cli in order deploy jars, need install deploy plugin: $ sudo heroku plugins:install heroku-cli-deploy ...
Read more

java - Jtable duplicate Rows -

-
Image
when add new rows in jtable duplicate rows many times this method update jtable public final void tableaucomande(){ ((defaulttablemodel)tabcommande.getmodel()).getdatavector().clear(); session s=hibernateutil.getsessionfactory().opensession(); criteria cr1= s.createcriteria(commande.class); list <commande> lcs=cr1.list() ; criteria cr2= s.createcriteria(lignecommande.class); list <lignecommande> lck=cr2.list() ; if(lcs.size()!=0 && lck.size()!=0) { (commande lc:lcs) { for(lignecommande lig:lck){ ((defaulttablemodel)tabcommande.getmodel()).addrow(new object[]{ lc.getid_cmd(),lc.getnumcmd(),lc.getdate_cmd(),lc.getclient().getnomprenom(), lig.getproduit().getlib_prd(),lig.getquantite(),lig.getproduit().getid_prd() }); } } // tabcommande.setrowselectioninterval(tabcommande.getrowcount()-1,tabcommande.getrowcount()-1); } } this code add add data rows displaye...
Read more

validation - How to pass paramaters like unix into windows batch file -

-
i need pass various parameters .cmd file unix format file.cmd -configuration=value -source=value -flag but, try this: startlocal @echo off cls setlocal set cmdline=%* set configuration= set source= set badargs= set validation= goto main :splitargs echo splitargs(%*) if "%*" neq "" ( /f "tokens=1,2,* delims== " %%i in ("%*") call :assignkeyvalue %%i %%j & call :splitargs %%k ) goto :eof :assignkeyvalue echo assignkeyvalue(%1, %2) if /i %1==-configuration ( set configuration=%2 ) else if /i %1==-source ( set source=%2 ) else ( rem append unrecognised [key,value] badargs echo unknown key %1 set badargs=%badargs%[%1, %2] ) goto :eof :validate echo validating set validation=fail if defined configuration ( echo -configuration ok if defined source ( echo -source ok if not defined badargs ( set validation=success ) ) ) goto :eof :main cl...
Read more