Description
The owner of a company looks over your design and sees that you are using database centralization. He questions why you would do this since it violates the rule that data should be managed and stored in close proximity to its users.
Explanation & Answer
There are many benifits of using data centralisation:
Thses are
Data Integrity – The single greatest benefit of centralizing an assn’s data management is data integrity.One of the cardinal rules of database design is that no redundancy is allowed. That is, no piece of data should ever be repeated within the database. When an organization is operating multiple databases for the same group of people (for example, a membership database with a separate meeting registration database), they are by definition breaking this rule.And this leads to major data integrity issues. A centralized database means that each member has one primary record, with primary contact information. Thus when there is a change required (like a new phone number or email address), there is only one place to look to make these changes.
Valuable broad marketing info/history – With all the information centralized, it is much easier to develop reports that show the broad range of activities that your members are engaged in. With multiple databases, records need to be matched, de-duping needs to occur, and the opportunity for duplicate records is greatly increased.
Support – With a centralized system, support is focused on one product. With many databases, even if they are built on the same platform, separate support is required for each.
Ease of training – Another benefit of a centralized system is that the learning curve for users is greatly reduced. If all processes (membership, meetings, products, etc.) are in the same database, then users need only learn one system, not multiple systems.
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Goldfinch
by Donna Tartt
The Girl With The Dragon Tattoo
by Stieg Larsson
The Mayor of Casterbridge
by Thomas Hardy
As I Lay Dying
by William Faulkner
Steppenwolf
by Hermann Hesse
Orphan Train
by Christina Baker Kline
Girl Stop Apologizing
by Rachel Hollis
How to Win Friends and Influence People
by Dale Carnegie