Loading...
Answers
MenuWhat's the Best way to Set Up a Relational Database?
Answers
I'm a developer of over 20 years experience and I've been building relational databases the whole time with varying degrees of normalization. I like it best when the problem is given to me as you stated above.
From your statement, it seems like you are trying to design the database. Instead, you hired a developer, and that is what they do. Have him or her design the database. Give them all the information you have and answer all their questions in a timely manner and you'll get what you need.
I'm not sure of your area of expertise or the relationship with and faith you have in your developer, but I would provide him the information from your question above. From that he/she should fire back a bunch of questions to you such as:
1. does every product require every choice?
2. Can a product have multiple options for a given choice?
3. Are the options for choices different dependent on the product?
4. Is there a higher level to consider of product categories?
... I think you get the idea.
Using this dialog can help you both think of concepts or situations you both have missed and provide you with a more robust solution.
I'd be happy to get on a call with you to discuss this further but it sounds like you have everything you need except maybe confidence in your developer(s). Best of luck.
Hello,
My name is Erik and i'm a Senior Database Architect with more than 15 years of experience and I also have 10 years of experience managing programmers.
The best way to ensure data relations between your objects (Product selected, type of coating, etc) is the following: you should explain to the developer that you want a 100% dynamic parent/child associations between objects without any limits on associations between objects.
If you need more details and/or want to schedule a call, we can go over your business requirements and I can help you build the technical specs for your programmer. I am also available to develop the data structure that you need.
Regards,
Erik Hanley
Start with a LAMP Stack - Linux + Apache + MariaDB + PHP.
Be sure to use latest Ubuntu (Linux) as your OS.
Be sure to use latest MariaDB rather than MySQL for your database.
Hire someone who's written a truckload of SQL over decades.
Have them design your database, based on how products will be accessed + searched for, as this will determine speed of your system.
Can't tell you the number of clients I've taken on in my private hosting company, where years worth of code + database design has to be scrapped because it was done incorrectly.
Hire an expert to do this right... the first time + you'll save yourself a huge amount of time + money + you'll be able to sleep well at night.
Related Questions
-
What is the best reference book to develop a solid business plan for an e-commerce retail sales site?
This really depends on the type of e-commerce platform and the platform on which it is built. For my e-commerce clients, with less than 1,000 products, the best business plan reference book would be The Success Principles by Jack Canfield. However, you must first understand the triggers you would need to captivate and persuade your audience to purchase. For that, I would recommend Fascinate by Sally Hogshead. When you start to get into the larger e-commerce retail websites, you run into more dynamic data and database strategies to ensure that your website runs smoothly and can be indexed by the search engines properly. The book recommendation would depend on what platform your website is built. However, Don't Make Me Think by Steve Krug would be a good starting point as the business plan would be contingent on the flow of the website and customer purchase power. If I can further help you in any way, contact me. I'm always here to help.SK
-
What are best strategies to sell LED light tubes and industrial lighting/lamps online a) in general and b) on amazon?
I'd ask Rocco Baldassarre. He is the best online marketing consultant I've ever seen and can surely give you concrete advice. Said that, my advice would be a) your own e-commerce store so you can drive traffic to it without losing money on commissions b) learn from best selling products (you can see sales ranks of competing products if you register as an amazon affiliate marketer; it's free) and copy their structure, split test regularly Hope it helps!CM
-
Does the 30% apple transaction fee apply to physical goods purchased on an app? Really need help Struggling Startup!
Apple specifically precludes anything that can't be delivered via the app from using in-app purchases. So you're free to tie a credit-card to services and real-world fees (think Uber) without paying Apple any transaction fees. Here's Apple's documentation on what they support (and don't allow) for in-app purchases. https://developer.apple.com/in-app-purchase/In-App-Purchase-Guidelines.pdf Happy to help in any way I can. I run a mobile-based startup myself.TW
-
How do you setup a network of suppliers and what sort of infrastructure do you need to setup replicable dropshipping partnerships.
Heard good things about GoodsCloud (www.goodscloud.com)BW
-
SEO: Launching an ecommerce marketplace soon with nearly 250,000 product pages. What is the fastest way to get them indexed?
I agree with some of the recommendations above; 1) Focus on making sure your XML sitemap is accurate, and make sure your weightings (server priority weights) are set correctly from parent to child (category > sub-category > product detail). 2) Submit through Google webmaster tools 3) Submit partials in increments (again, good suggestion at 50k/time) and pay close attention to your index rate to see how fast these are picked up 4) you can brute force a lot of these crawls by submitting and re-submitting your sitemap(s) - as often as every day 5) For very important URL's that are not getting picked up a handy trick is to tweet them out from an account that has a positive share of voice (more followers than following)NE
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.