All Questions
Tagged with rdbms database-design
58 questions
7
votes
1
answer
3k
views
Full text search through many tables in MySQL
We have high traffic NEWS websites, I want to add a feature that every user can search through over all content of site, such as news, polls, comments, galleries,etc . Each of contents type has its ...
- 663
3
votes
1
answer
257
views
Plan for managing financial transactions in an easily and retrievable manner, indefinitely
I've got a large (many columns) MySQL database table (InnoDB) that has a fairly high number of INSERTs (~500/day). Think of the rows as financial transactions. Clients need to be able to view these ...
- 33
0
votes
1
answer
254
views
Database design in MySQL
I am designing a database for an web application, in this system there are multiple users. Consider,
Public (Buyer).
Merchant.
Tele Marketing Executive(TME).
Marketing Executive(ME).
Lead Generator......
- 2,300
31
votes
5
answers
3k
views
Is it OK to keep a value which updates in a table?
We are developing a platform for prepaid cards, which basically holds data about cards and their balance, payments, etc.
Up until now we had a Card entity which has a collection of Account entity, ...
- 529
1
vote
1
answer
2k
views
Connecting to a SQL Server database from a Flash program [closed]
I currently have the ability to utilize Microsoft SQL Server 2012. I am developing a project with Adobe Flash Builder 4.7.
If I link my database with Adobe Flash Builder is there any additional ...
- 131
5
votes
1
answer
924
views
Optimised Schema for City-to-City Distance Table
This is my first question, forgive me if this question is simple. I'm stuck here, trying to implement the relationships for the data represented below. I want to scale it vertically (new rows), ...
- 175
3
votes
1
answer
666
views
Surrogate key / Primary key: Better to use an existing unique data field or create a key field?
I am not sure if this question has been asked or not. At least I couldn't find it.
I am curious about a primary key in terms of efficiency with data searching and retrieval.
This is a hypothetical ...
- 133
8
votes
9
answers
6k
views
Which DBMS are fast enough for an online game (few thousand players)? [closed]
I'm currently making an MMORPG game, which could have a few thousand players online at the same time (probably not; just wishful thinking). First we wanted to use MySQL, but I have heard it isn't fast ...
- 203