Database Experts Opinions please. - Joomla! Forum - community, help and support

-

okay, @ work i'm having big disagreement project management team has no database experience @ all. here issue.

we have 10 product lines, in each product line there number of attribute names, such height, weight, color, price , on. have total of 670 attribute names 10 product lines. project management team wanting create master file in excel contains 670 attribute names, regardless if attribute name pertains product line or not. let's 'widget a' has 70 attribute names, want still add other 600 attribute names , enter dash value (you can import if value has character in field). have import each product line one-by-one since software requires.

to me, not proper way build database since creating database have hundreds of thousands of null characters. normalizing databse, , told them complete opposite of normalizing database.

i forward opinions well.

i'm not sure how pertains joomla installation (where post appearing) here's opinion.

if product 1 has 1 attribute want 669 blank attributes associated product 1?

same goes product 2 25 attributes leaving 645 blank fields.

seems huge waste of db space , representative of flat database (non-efficient) , not relational database. think amazon operates using excel? think not.

excel easier setup , use can maintenance nightmare. efficient way put data relational database (such access) , use db's features , powers make data work minimal "bloating".





Comments

Post a Comment

Popular posts from this blog

CS5 Adobe Media Encoder: Encode failed because the source duration is nil.

-
i've been running production premium on new windows 7 64bit, 6gb i7 system several weeks , haven't had issues exporting media encoder.   i installed trial version of dreamweaver without of add-on's thought might mess licensed installation.   every attempt export -> media -> queue get's following error in ameencodingerrorlog.txt   - source file: c:\users\rob\appdata\local\temp\someproject.prproj - output file: c:\users\rob\videos\someproject.mov - preset used: custom - video: - audio: - bitrate: - encoding time: 00:00:00 7/8/2010 10:14:34 : encoding failed ------------------------------------------------- encode failed because source duration nil.   doing export directly pp works without error, don't want wait each export complete.   any ideas other reinstall pp?   tia i noticed range selector triangles right next each other.   changed source range: work area   not sure why default set 0 range. doesn't remember last setting when selected entire sequ
Read more

cf_sql_integer vs cf_sql_bigint vs cf_sql_int??

-
i have id (primary key) set bigint in sql server. have query following: where whateverid = <cfqueryparam cfsqltype="cf_sql_integer" value="#url.id#"> i got invalid data type it. tried: where whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#url.id#"> i still got invalid data type it. tried: where whateverid = <cfqueryparam cfsqltype="cf_sql_int" value="#url.id#"> and worked. the weird thing cf_sql_int not listed being accepted: http://www.adobe.com/livedocs/coldfusion/5.0/cfml_reference/tags79.htm can explain me. > whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#url.id#"> what value of #url.id#? had no problems either using cf8. > weird thing cf_sql_int not listed being accepted: iirc, when pass in invalid sql type cf uses default: cf_sql_char, accepts anything. ms sql implicit convert() right type , why works. More discussions in Data
Read more

localhost/joomla15/administrator doesnt work - Joomla! Forum - community, help and support

-
hi, i'm starting , address http://localhost/joomla15/administrator doesn't work (it stays blank, no error or anything). wonder if have change in address or somewhere else. joomla installed through web-host dreamhost.com , didn't have much. i appreciate help. silvia http://localhost tells browser not go out internet use localized web server installed on pc. lack of better description, localized web server doing coding , test site development on local pc using software turns pc "local" web server; hence, term - localhost. you mentioned dreamhost.com installing joomla. assume mean installed joomla on hosting account? so need access joomla installation by: http://www.yourdomain.com/joomla15/administrator Board index Joomla! Older Version Support Joomla! 1.5 Installation 1.5
Read more