Home >> database management

database management


Database Management: The Objective of Database Managers

As organizations increasingly rely on a higher volume of information to make decisions and execute the day to day operations, database management is becoming increasingly important.

The sheer size of some organizations databases is uncanny. Every day, companies continue to collect information at a high rate and add it to their database. The goal is to uncover relationships and develop connections between data elements to extract insights that can be used to help organizations with decision making and forecasting future actions.

One area, however, that tends to get overlooked is database management. It is not uncommon for database issues to arise that can affect:

     

  • how users interact with the system
  •  

     

  • How data is stored and retrieved
  •  

     

  • The accuracy of reports and data that are extracted from the database
  •  

For this reason, many organizations are now creating the role of database manager to handle all database issues and ensure it is functioning at a high level at all times.

The role of a database manager

Database managers have four main objectives. These objectives, while they will vary from organization to organization and may change over time, are directly tied to how databases operate within the context of day to day operations of the business.

Objective 1: Database Availability

Databases are only effective if the data within the system is readily available at all times. Database managers must ensure that there is little downtime and that information should be easily accessible to people within their company. This means that data should be:

     

  • In a format users can understand and work with
  •  

     

  • Extracted without issue
  •  

     

  • Categorized logically
  •  

     

  • Accessible to the right people when they need it
  •  

Objective 2: Maintaining the integrity of the database

While issues will arise with any database, managers must have measures in place to deal with errors and issues as they surface. Therefore, to ensure the database is performing at its highest level managers must have protocols in place to ensure:

     

  • The data remains confidential and only authorized users access the system
  •  

     

  • The data is of high quality and free from errors that could affect meaning and knowledge
  •  

     

  • The database is not compromised in any manner and protected against outside threats and viruses
  •  

Objective 3: Growing the database

Nothing can remain static in an age where technology changes at such a rapid pace. Therefore, databases much be dynamic and have the ability to evolve over time as usage patterns change and new technologies add to the databases overall functionality.

 

The database must have the ability to conform to organizational needs and adapt to specific business initiatives, processes, and environments.

Database manager must use the information within the database to remain current about the market, technology, and trends in order to predict and make effective decisions about expanding the capabilities of the database.

Objective 4: Sharing database resources

Users must have the ability to share resources within the database. This is the fundamental objective of database management. Users from different departments, committees, and sections of a company with different agendas must be able to use a common pool of data at the same time as other users.

Additionally, database managers must ensure that the database is effective in its ability to:

  • Meet the needs of all types of users
  • Controlling concurrent updates to data
  • Connecting and building relationships between interrelated data
  • Handle database recovery operations for all users if the system goes down

When these objectives are effectively handled and database management is in order, users will be able to maximize the resources and functions provided by the database.


Articles Tagged - database management

 1
Ingres unveils multicore-aware database
Tuesday, June 08, 2010
Ingres unveils multicore-aware database
Thanks to Intel-funded research, the new Ingres database, VectorWise, tackles multicore processing
Start-ups target Oracle, SQL with cloud-based data management
Tuesday, March 23, 2010
Start-ups target Oracle, SQL with cloud-based data management
FathomDB and Cloudscale launched at DEMO Spring 2010 this week with more affordable alternatives to today’s costly traditional databases
No to SQL? Anti-database movement gains steam-1
Wednesday, July 01, 2009
No to SQL? Anti-database movement gains steam-1
The burgeoning NoSQL community, made up of Web and Java developers, promote building your own data storage. But can enterprises take open-source alternatives Hadoop, Voldemort seriously?
10 enterprise software companies to watch
Monday, April 16, 2007
10 enterprise software companies to watch
From business intelligence to CRM, from scheduling and e-procurement to database management and data governance, there is no shortage of enterprise applications available to help businesses make their processes more efficient. Choosing can be difficult, however: Do you go open source? Software-as-a-service, or in-house deployment? Every vendor has a sales pitch. Here are 10 worth watching.
Vendors use .NET to drive databases
Thursday, February 15, 2007
Vendors use .NET to drive databases
In the high stakes world of the oil and gas industry, managing corporate data is a demanding and complex process.
IT pros get serious about gaming
Wednesday, October 05, 2005
IT pros get serious about gaming
Fun and games are serious business. The gaming industry is growing up fast, and is generating impressive revenues and fascinating job opportunities for certain IT professionals who are young at heart.
Jobs at risk
Monday, July 19, 2004
Jobs at risk
MedSite Inc. figured it could save money by using offshore resources to bulk up its IT staff, but the online marketing and education services firm also knew it had to think carefully about which jobs would make sense to push overseas.
Company on a Quest to ease database management
Thursday, March 07, 2002
Company on a Quest to ease database management
A mish-mash of database management tools doth not a cost-efficient enterprise make — so says application management company Quest Software Inc. The Irvine, Calif.-based firm recently unveiled Quest Central for Oracle, a tool that takes an integrated-console approach to helping network and database administrators (DBAs) manage the data environment.
Database monitoring enters cyberspace
Thursday, September 21, 2000
Database monitoring enters cyberspace
 1