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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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: 1112

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

Joined: Aug 20, 2001
Posts: 1815
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: jrebel
 
subject: your opinion of the most important part of database-based developing?
 
Similar Threads
What is Multi-Core Complexity
Book review for SCEA part I
Javascript is not showing any result under iframe in Safari 5.1
use OOP to design database tables schema?
i did terrible.