An important part of a software development cycle is anaylsing a database. Julie has written this article to assist a dba to evaluate their database so that it matches the organisation's needs.
Having worked with most of the databases available on the market today, I am not boasting that I am an expert on all of them, but I sincerely believe that every database can suit a particular organization's needs. An organization on the verge of making a decision for database or software should first do a thorough study of information needs. This article presents some guidelines for that study.Information today is more important than ever. Smart information is precious. In this age of information overload, I have found it necessary to disregard any information which is not related to my needs, and I am sure that 99% of you do the same.
I want to write about Database Modeling and ER diagramming, but a layman might find that hard to understand. So let me try the simple ways...
To narrow down the requirements of "smart information," avoid the following:
- Information that is not to the point
- Duplicate information
- Erroneous information
- Abstract information
- Subjective information
An organization's information can be viewed by the following types of people:
- Customers (past, present, and future)
- Evaluators of the organisation, auditors
- Suppliers
- miscellaneous creditors
- miscellaneous debtors
- Bankers
- Employees (past, present, and future)
- Management
- Other general viewers (external or internal)
These people need to view information of different categories. In order for the organization to provide the requisite information, a systematic study of the information requirements is necessary. When considering information requirements, keep the following features in mind:
- Satisfying the related information seeker
- Satisfying the related information seeker
- Satisfying the related information seeker
If you follow these three magic points -- yes, they are all the same -- you will design the best database for the organization.
When designing databases, keep in mind the features of a good information system:
- Make a blueprint (flowchart) of your database flow structure.
- Divide the information of the organization into secured and unsecured layers.
- Divide the basic database structure to suit different types of information seeker.
- Keep a good backup system to avoid crashes
- Avoid duplicate data entry system
- Allow easy access to unsecured databases related especially to customers
- Keep the databases simple. That should be the mantra so that easy debugging of complicated problems is possible.
- Archive obsolete information to access it when required.
- Categorize your main information seekers
In short, you should have an information system which is robust, flexible, and can be managed even by a layman.
I have seen different types of companies and their needs are different.
- Companies which produce and sell the finished products themselves
- Companies which are third party merchants who buy and sell on behalf of them
- Companies which act as intermediaries between the buyer and sellers
- Companies which provide services (airlines, hospitals, etc.)
Influencing factors would be
- Information size
- Complexity of the flow of information
- Security for the information database
If you want the best for your organization, do a thorough analysis of your information requirements and cross-reference these with all the database models available. The database which you think is best matched with your organization is your "investment". Do not compromise your investment because of cost. Best of luck, and happy hunting.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
More Development Cycles Articles
More By Julie George
developerWorks - FREE Tools! |
As businesses grow increasingly dependent upon Web applications to provide services to customers, employees and partners, these complex applications become more difficult to secure. Although traditional security solutions protect Internet infrastructure layers, they do not guard against HTTP and HTML attacks. Many organizations that conduct security testing still deploy applications that allow attackers to manipulate their logic and wreak havoc on their business. To mitigate this risk, development and delivery teams must address Web application security throughout the lifecycle, addressing the many layers detailed in this paper. FREE! Go There Now!
|
|
|
|
This tutorial shows new users of IBM WebSphere Business Monitor Version 6.0.2 how to perform the "Hello World" equivalent for monitoring business process applications. It is intended to help you get familiar with the capabilities of the product. FREE! Go There Now!
|
|
|
|
Learn how Rational Build Forge can extend a simple compile and package build process by adding customization and deployment capability. Go from a manual method to automating: checking for code changes; getting the latest source; compiling and packaging; customizing; copying to and restarting a deployment server; and sending e-mail notification that a new version is available. FREE! Go There Now!
|
|
|
|
Listen to this webcast to get an overview of Info 2.0 and a technical demo of how to quickly build an enterprise mashup. IBM's Info 2.0 technology leverages emerging Web 2.0 technologies such as mashups, feeds, AJAX, and JSON in order to simplify assembly of information using feeds and services. Come learn about the technical elements of Info 2.0 including the Feed Generation framework, Mashup Engine, and mashup assembly components. Learn how to pull information from databases, departmental information, and the Web to create mashups critical to your company’s success. We will also discuss best practices to help you get started. FREE! Go There Now!
|
|
|
|
Ken Krugler, co-founder of code search company Krugle, and Laura Merling, vice president of Marketing and Business Development for Krugle, join to talk about the ins and outs of code search and what it means as a new feature for developerWorks users. FREE! Go There Now!
|
|
|
|
Join this Rational Talks to You teleconference on December 11 at 1:00 pm ET to get tips on building your own plugins with Rational Method Composer. Get your questions answered! FREE! Go There Now!
|
|
|
|
Join this Rational Talks to You teleconference on December 4 at 1:00 pm ET to discuss how Rational Method Composer can help meet your compliance objectives. Get your questions answered! FREE! Go There Now!
|
|
|
|
Visit IBM developerWorks to try the IBM SOA Sandbox for process. The SOA Sandbox for process focuses on providing a trial environment with the necessary tooling and components required to gain a better understanding of business processes and how to best improve existing business processes to derive value quickly. FREE! Go There Now!
|
|
|
|
Viper 2 brings a great value to developer communities including SQL, XML, PHP, Ruby, .NET and Java. You probably already know that DB2 Express-C is free for developers to develop, deploy and distribute. Viper 2 provides a variety of means that help move your application from the development stage to deployment more rapidly. This webcast shows how to best utilize the latest tools available for developing DB2 applications. FREE! Go There Now!
|
|
|
|
Explore how Rational and WebSphere software enable enterprise documentation in SOA environments. Specifically, a new integration between IBM WebSphere® Business Modeler and IBM Rational® Method Composer software can help technical writers more easily keep enterprise operations manuals in sync with changes that are made to business processes, resulting in more accurate and timely documentation that benefits the entire enterprise. FREE! Go There Now!
|
|
|
|
All FREE IBM® developerWorks Tools! |