database-design

In order to improve insert performance and load on server, I've decided to divide a large table into 2. A big table which will only be used for…

I have millions of songs, each song has its unique Song ID. Corresponding to each Song ID I have some attributes like song name, artist name, album…

I am trying to understand the concept of document storage and fail to see how it would apply to some situations. For example, in the case of a…

I am building a business directory using php/mysql and am wondering what would be the best way to set up image slideshows for the advanced business…

We are providing document upload on different things like tasks, feeds, comments etc.. And there are lots different permission on documents for…

I need to build something similar to a dating site. Each account can have 1 or more "profiles". Each profile might have certain attributes, like…

I work in the promotional products industry. We sell pretty much anything that you can print, embroider, engrave, or any other method to customize.…

I have two databases: 1) accounts-management 2) games-management I want to make reports, which use data from both databases and i want to have third…

When building a category navigation system for a business directory with a many to many relationship, I understand that it is good practise to…

Just looking for what people see as the main differences when choosing between the two. Thanks.

I have a table in MySQL with multiple of reported events (primary key, date submitted, and text). Users can "like", or "+1" the reports, similar to…

I dont know what type of Audit logging system do I need for my tables design. Sometime staff change the name of the product, price, options or…

I am trying to come up with a database design to hold the "Top 10" results for some calculations that are being done. Basically, when all is said in…

An invoice can contain 1 or more orders, how to archive this? Example of Invoice: OrderID | Order Date | Amount 31 10/02/2011 £1.50 43 12/02/2011…

Which is better 100 tables with 10,000 rows or 1,000 tables with 1,000 rows? The above question is just a base.Its not completed without the…

If I have users, as well as user groups (like a local astronomy group/club), and I want both to have a one to many relationship with street…

I have a few programs that have to fetch HTML or XML and then cache it locally. Imagine that there are 1000-10,000 documents that need to be cached.…

I have a MySql table which consists of: ~25million rows (CURRENTLY) 3 indexes Each day, a crawler adds ~3million rows I'm currently not looking too…

I can't design mysql tables for "is user online" feature. Googled but can't find concrete solutions. Any help would be appreciated. Thank you.

if i have this table: users ----- id_users (pk) age name gender salary it is needed for each of these values an option to set visible or not in user…