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! |
Download a free trial version of IBM DB2 9.5 for Linux, UNIX, and Windows. DB2 9 is the result of a five-year development project that transformed traditional (static) database technology into an interactive data server that merges the high performance and ease of use of DB2 with the self-describing benefits of XML. FREE! Go There Now!
|
|
|
|
Download the IBM WebSphere Portal V6.1 beta code and learn more about the rich features and enhancements in IBM WebSphere Portal V6.1. WebSphere Portal provides a composite application or business mashup framework and the advanced tooling needed to build flexible, SOA-based solutions, and scalability to meet the needs of any size organization. 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!
|
|
|
|
IBM Enterprise Modernization solutions help organizations evolve core IT systems towards modern architectures and technologies—reducing the burden of maintenance and freeing up resources to develop new business requirements and capabilities. With the IBM Enterprise Modernization Sandbox for System z you can evaluate IBM Enterprise Modernization solutions focused on five key areas: Assets, Architectures, Skills, Processes and Infrastructures, and Investment. Each solution is based upon real customer experiences and offers a proven path to get you started with your modernization projects. FREE! Go There Now!
|
|
|
|
This webcast outlines the best practices that must be instituted to gain the maximum benefit from SOA while maintaining high quality of service. Whether you are deploying new applications or managing and monitoring your existing infrastructure, learn how you can ensure high quality of services with SOA based solutions from IBM. All registrants who attend this live Web Seminar will receive complimentary access to a white paper titled “Maintaining QoS in an SOA Environment”. FREE! Go There Now!
|
|
|
|
Because access to government information continues to be an area of concern for many U.S. citizens with disabilities, the U.S. government enacted Section 508 of the Rehabilitation Act in 2001 to ensure that government agencies create accessible Web content, enabling all citizens to access the information they need. A fully accessible Web site makes Web content accessible to all individuals, including those with disabilities, who may be accessing Web content via a variety of user agents. Common user agents include standard Web browsers, text-only browsers, assistive devices and mobile devices such as cell phones or personal digital assistants (PDAs). FREE! Go There Now!
|
|
|
|
This paper is about the critical role that a discipline called integrated requirements management can play in helping to ensure that your business goals and IT investments are continuously aligned—whether you are sourcing, integrating, building or maintaining software. It also looks at ways that automated IBM Rational® products can work together to help you use requirements in the very best way. FREE! Go There Now!
|
|
|
|
Get a free trial download of the latest version of IBM Rational Method Composer V7.2 which helps you deliver customized yet consistent process guidance to your project teams and IT organization, and includes the latest version of IBM Rational Unified Process (RUP), which has provided process guidance to teams since 1996. FREE! Go There Now!
|
|
|
|
Visit IBM developerWorks to try the IBM SOA Sandbox for people. The SOA Sandbox for people provides a trial environment with the necessary tooling and components required to enable consistent human and process interaction and collaboration, showing how you can improve user experience and business productivity. FREE! Go There Now!
|
|
|
|
Whether you are creating new applications or modifying existing ones, managing integration of new components with traditional z/OS elements is a critical part of building and deploying modern applications. Listen to this webcast to see how IBM can help you optimize your development process using an IDE like Rational Developer for System z that integrates with management tools, such as ClearCase to manage your application development on mainframes. FREE! Go There Now!
|
|
|
|
All FREE IBM® developerWorks Tools! |