Home > IT Blogs > RDBMS in Oracle/SQL >

RDBMS in Oracle/SQL:

Development

Feb 25 2008   4:12AM GMT

What are the benefits of Database Approach?



Posted by: Rhiana
Database, RDBMS, DataCenter, DataManagement, Development, Oracle, SQL Server

The benefits of database approach is to
1. reduce redundancy of information
Data’s are being made simple and complex, we don’t have to input as many data’s which can only result in overloaded space in computer hard disk/ memory.
2. Consistent data flow
Once the data’s are being analyzed in sequence, once can easily identify the flow of information and hence, results will come in reliable output.
3. Integration of data
Incorporating of data’s in tables should result in a highly assimilation of information.
4. Security and User privileges
Protection of data’s from unwanted users and giving user’s rights to what level they are to use the application.
5. Ease of application development.
It is a more comfortable workspace for the relevance of its factual purpose.

AddThis Social Bookmark Button     0 Comments     RSS Feed     Email a friend

Feb 23 2008   4:10AM GMT

Why do we need to consider Database Approach?



Posted by: Rhiana
Database, RDBMS, DataCenter, DataManagement, Development, Oracle, SQL Server

Because it emphasizes the integration and sharing of data across the organization. We have two types of Database Approach the Process Design and the Data Driven Design.
The Process Design requires a top level analysis to process the data’s. One should first consider a complete analysis of how the design would end up like then one would analyze the datum into logical order then there goes the implementation.
As for Data Driven Design, unlike the Process design which is more likely the analysis of breaking down data’s the Data-Driven Design come in full pack of making a database design in chronological order, we process data’s and break them down into smaller units/parts, we will discuss more about this in normalization.

AddThis Social Bookmark Button     0 Comments     RSS Feed     Email a friend