Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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: 1132

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

Joined: Aug 20, 2001
Posts: 1817

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.
 
 
subject: your opinion of the most important part of database-based developing?