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
-
How important is it for a marketplace startup to drive enough demand (customers) for your supply (sellers) to make a full time living off of it?
It's very important. (first, read this article by Josh Breinlinger - http://acrowdedspace.com/post/47647912203/a-critical-but-ignored-metric-for-marketplaces) The way you achieve success in a marketplace is by driving liquidity for both your supply & demand. Demand-side Liquidity = When users come to your marketplace, they can achieve their goals. Supply-side Liquidity = When supply comes to your marketplace they can achieve their goals... which are almost always to make money. If you're making a large amount of your supply-side users a full-time income, then you're helping them achieve liquidity. Now it's not so black and white and it doesn't always have to be a "full-time income." It depends what their goals are. E.g., 1) At Airbnb, renters aren't looking to quit their day jobs and become landlords full-time... they're just look to earn a substantial amount of income to offset their rent, mortgage, etc. So in this case, I would probably goal on # of renters that earn >$500 / month... and (in the first 1-5 years) try to grow this number by 10-20% MoM... and maybe by just 5% once you're in the mid-high tens of millions in yearly revenue. 2) At Kickstarter, the goal of the supply-side is to get their project successfully funded. They don't care if the project creator is "full-time"... they just want to make sure they meet their funding goal. This is why they talk about their 44% project success rate all the time - http://www.kickstarter.com/help/stats 3) At Udemy, our instructors want a substantial amount of their income to be driven from their Udemy course earnings... so we look at how many instructors are earning >$2k / month.DT
-
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
-
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
-
My startup just failed. What could I start to "immediately" generate $1,000/mo?
The quickest path to cash is almost always consulting. Be very specific about what it is you can offer. Don't just offer "business consulting". Find a niche and serve it. Reach out to your network, including friends and family and ask if they need or know of anyone who might want to hear about what your consulting has to offer. That will be way faster than trying to go at it from scratch or cold calling. If you call 100 people in your network this week, you will have a consulting gig within 3 weeks. Good luck, and let me know if you'd like advice on entering a digital marketing/lead generation consulting niche. I've grown from zero to $8,000 of monthly recurring payments in the last 40 days! DaveDR
-
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.