Database Development

Database Development is the activity of program designers. They create programs that long established firms use to organize, store and distribute their information. There are models of enterprise data developed that these institutions rely on. Examples of this would be Oracle and SAP. They are packages that give maximum control to the organizations involved.

Architecture of the system involves rules governing the processing of the data, processes to manipulate the data, the people who process the information and receive the data and networks that transport the data.

When planning a program that meets the objectives of these long established companies the needs of the company are first. This is accomplished by project identification and planning. This is followed by analysis and logical design. The analysis makes sure that the project is still relevant while beginnings of logical design enter into presentation of the physical designs and processing rules. The next steps include physical design where programming and organizational redesign is implemented to support the particular database development. Testing can also be included in this area of development. Finally, the process of system modification is initiated as the system operates. As the organization or company needs change this becomes part of the maintenance process.

Designers are using CASE or computer aided software engineering tools to automate development of the components. Examples of this would be Oracle Designer for data processing and Oracle Developer for generating computer screens, reports and programs. This allows for the information to be shared by a team of developers. A repository is used to contain the components developed for sharing.

Data is viewed in four levels: reality, concept schemes, external schemes and internal schemes. This is a breakdown of the processes involved in database development. It is a very simple breakdown and there is a great deal involved in the process but it gives you a general idea of the development process and some of the particulars associated with it.

There are a number of models associated with database development. A model is a theoretic of the systems operation. Some of the models are hierarchical, network, relational, entity, object relational and object model. The models are more than the way the data is structured. It includes how the data can be manipulated. An example of this would be the joining of data, projection of the data and selection of the data. This is the foundation of the development process. Again this is a simple reflection of the ideas associate with the processes. Many of the systems created are created surrounding the base model with a number of support elements.

Database Development is the activity of program designers. Architecture of the system involves rules governing the processing of data. Planning a program that meets the objectives of companies is the first phase. Oracle Designer and Oracle Developer are key to the designer’s development processes. Developers see the data in a multiple of dimensions and there are a wide variety of models associated with the development.

Author: James V Salisbury