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:
Objective 2: Maintaining the integrity of the database
- In a format users can understand and work with
- Extracted without issue
- Categorized logically
- Accessible to the right people when they need it
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:
Objective 3: Growing the database
- 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
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.
Tuesday, June 08, 2010Ingres unveils multicore-aware database Thanks to Intel-funded research, the new Ingres database, VectorWise, tackles multicore processing
Tuesday, March 23, 2010Start-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
Wednesday, July 01, 2009No 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?
Monday, April 16, 200710 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.
Thursday, February 15, 2007Vendors 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.
Wednesday, October 05, 2005IT 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.
Monday, July 19, 2004Jobs 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.
Thursday, March 07, 2002Company 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.