LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices



Reply
 
Search this Thread
Old 04-21-2009, 04:23 PM   #1
mohtasham1983
Member
 
Registered: Apr 2005
Location: San Jose
Distribution: Fedora 3,4- Ubuntu 6.06 to 8.10, Gentoo and Arch
Posts: 408

Rep: Reputation: 30
Software for designing database architecture


Hi,

I have developed a few web based applications interacting with MySQL. They were mostly small and didn't require much design and I could do everything on a piece of paper.

However, I'm going to develop a new application with a relatively complex database schema. I'm pretty sure a piece of paper cannot help me with this application anymore.

I was wondering if there's any cool software that can be a replacement for paper when thinking and designing about database architecture?

Thanks in advance.
 
Old 04-21-2009, 05:15 PM   #2
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 15,087

Rep: Reputation: 2714Reputation: 2714Reputation: 2714Reputation: 2714Reputation: 2714Reputation: 2714Reputation: 2714Reputation: 2714Reputation: 2714Reputation: 2714Reputation: 2714
Quote:
Originally Posted by mohtasham1983 View Post
Hi,

I have developed a few web based applications interacting with MySQL. They were mostly small and didn't require much design and I could do everything on a piece of paper.

However, I'm going to develop a new application with a relatively complex database schema. I'm pretty sure a piece of paper cannot help me with this application anymore.

I was wondering if there's any cool software that can be a replacement for paper when thinking and designing about database architecture?

Thanks in advance.
I don't know of any, but I've been down that road before. The best thing I can suggest, is to keep a VERY close eye on things, specifically the transactions that are going on. You can do things like splitting up tables on different spindles, or optimizing the queries.

I've seen things scale up well, until a certain point, then have problems. Plateauing is the term, and it's hard to see coming, and harder to fix. I know Oracle has some good tools, but all the MySQL stuff I've done has been relatively small.
 
  


Reply

Tags
architecture, database, design, software


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
social networking database architecture mohtasham1983 Programming 4 08-01-2007 01:52 AM
good PCB designing software? bobbens Linux - Software 2 01-11-2005 03:05 PM
Help in designing educational software? mrperkins Programming 2 07-21-2004 09:07 PM
Designing Adverts software? HadesThunder Linux - Newbie 3 06-11-2004 05:40 PM
name/visiting card designing software satimis Linux - Software 4 09-18-2003 08:08 PM


All times are GMT -5. The time now is 10:01 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration