aspose file tools*
The moose likes JDBC and the fly likes your opinion of the most important part of database-based developing? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "your opinion of the most important part of database-based developing?" Watch "your opinion of the most important part of database-based developing?" New topic
Author

your opinion of the most important part of database-based developing?

Eliot Skywalker
Greenhorn

Joined: Oct 22, 2003
Posts: 18
Hi all,
I think it's really a general question,perhaps not bound to JDBC only.
What would you guys consider to be the most important part of the whole process of the development of softwares based on database? I need your opinion please.
THX
--eliot


Every man dies, not every man really lives.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1134

Understanding the business that you're developing the application for.
Good Luck,
Avi.
Joel McNary
Bartender

Joined: Aug 20, 2001
Posts: 1821

More specifically, understanding the data structures associated with that business and designing the database correctly.
Understanding the concept of database normalization is an important part of designing a database, and it is even more important to understand when you should "de-normalize" portions of your database. (This is not often recommended, but sometimes the business just doesn't do business in a fully-normalized situation, and that can cause unnecessary overhead in the form of DB I/O in an application.) Usually, however, the problem is that the database is not normalized enough (or not at all....)
Understanding how to design reports based off of the data in your database. Mostly, data is not useful unless it is reported back to someone somehow. Views are incredibly important here (don't de-normalize your database for reporting concerns! Use views instead)
Other concerns involve understanding how your application handles concurrent users and obtaining primary keys; these are more app-specific thatn DB-design specific, though.


Piscis Babelis est parvus, flavus, et hiridicus, et est probabiliter insolitissima raritas in toto mundo.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: your opinion of the most important part of database-based developing?