Posted in Community :
Database Administration
|
||
|
Source : http://www.ciol.com
Activity:
0 comments
342 views
last activity : 07 06 2010 20:18:04 +0000
|
||
|
|
A database is a very important part of an organization and almost all applications use database management systems (DBMS) to create, store and manage data. These DBMS software, like Oracle, IBM DB2, Sybase, Microsoft SQL Server or MySql are responsible for creation, updation, retrieval and storage of information in a structured format.
Also, DBMS maintains data integrity, access control and security. Since there's so much to do in a database, the organization must dedicate a database administrator for the job, who has to ensure efficient and proper design of data in the database.
If anything goes wrong with an application, the DBA has to use his skills to check whether the problem arose because of a fault in the database design or due to the application's logic. This is not an easy task, which is why (fortunately) there are database management tools that help a DBA keep a real-time check on the performance of DBMS. Not only do these tools provide for performance optimality but also help in the design and development of database on various DBMS platforms. The database management tools can broadly be classified into two categories: Production, and Development tools.
A database administrator is required to maintain the production and test environments of an application development project. The tools used to manage the production environment are used to sort issues related with database performance, administration and database recovery.
The DBA can tune and improve the performance of a database by using such tools. The performance-monitoring tool helps a DBA gauge the efficiency and responsiveness of SQL queries, system parameters and database structures. Such performance monitoring tools run in the background and maintain a log of the database performance statistics and alert the DBA on occurrence of any problem. Some advanced tools can also take proactive steps to counter the problem so that database performance is not hindered at all.
The performance enhancement tools should monitor three aspects of a database application, which are database structure, the system itself and the application. These tools help manage the system resources perform optimally, while allowing you to analyze and optimize queries and run applications at top speed.
On a day-to-day basis a DBA requires some administration tools that help him in simplifying the tasks ranging from database object creation to database synchronization. In the absence of such administrative tools, the DBA would be required to write complex scripts for such intricate tasks that would consume time and would sometimes be error-prone too. Such administrative tools help DBA by automating some of the complex tasks and also help him in saving time.
Most of the DBMS applications provide basic backup and recovery features. However, these can't satiate the requirements of a DBA. He needs tools that can automate processes of backup and recovery and can also implement procedures for disaster recovery. The recovery tools help the DBA in such tasks. Some advanced recovery tools are also available that examine the database logs and then perform online SQL-based recoveries of the crashed or corrupted databases.
During the development of application database, the DBA focuses on building an effective database environment to support applications running in an organization. As the programs for an application are built, the DBA also has to look toward providing proper database structures that would be required by the application.
Also, DBMS maintains data integrity, access control and security. Since there's so much to do in a database, the organization must dedicate a database administrator for the job, who has to ensure efficient and proper design of data in the database.
If anything goes wrong with an application, the DBA has to use his skills to check whether the problem arose because of a fault in the database design or due to the application's logic. This is not an easy task, which is why (fortunately) there are database management tools that help a DBA keep a real-time check on the performance of DBMS. Not only do these tools provide for performance optimality but also help in the design and development of database on various DBMS platforms. The database management tools can broadly be classified into two categories: Production, and Development tools.
A database administrator is required to maintain the production and test environments of an application development project. The tools used to manage the production environment are used to sort issues related with database performance, administration and database recovery.
The DBA can tune and improve the performance of a database by using such tools. The performance-monitoring tool helps a DBA gauge the efficiency and responsiveness of SQL queries, system parameters and database structures. Such performance monitoring tools run in the background and maintain a log of the database performance statistics and alert the DBA on occurrence of any problem. Some advanced tools can also take proactive steps to counter the problem so that database performance is not hindered at all.
The performance enhancement tools should monitor three aspects of a database application, which are database structure, the system itself and the application. These tools help manage the system resources perform optimally, while allowing you to analyze and optimize queries and run applications at top speed.
On a day-to-day basis a DBA requires some administration tools that help him in simplifying the tasks ranging from database object creation to database synchronization. In the absence of such administrative tools, the DBA would be required to write complex scripts for such intricate tasks that would consume time and would sometimes be error-prone too. Such administrative tools help DBA by automating some of the complex tasks and also help him in saving time.
Most of the DBMS applications provide basic backup and recovery features. However, these can't satiate the requirements of a DBA. He needs tools that can automate processes of backup and recovery and can also implement procedures for disaster recovery. The recovery tools help the DBA in such tasks. Some advanced recovery tools are also available that examine the database logs and then perform online SQL-based recoveries of the crashed or corrupted databases.
During the development of application database, the DBA focuses on building an effective database environment to support applications running in an organization. As the programs for an application are built, the DBA also has to look toward providing proper database structures that would be required by the application.
TrackBack URL:
0 comments on "How to manage databases "
Sort by:
Most Recent
Top Rated
Found the article
"How to manage databases "
interesting ?
Share with your connections and communities
Need IT People Think Sampoorna
- Create a confidential Career Profile and Resume/C.V. online
- Get advice for planning their career and for marketing of experience and skills
- Maximize awareness of and access to the best career opportunities
Viewers also viewed
|
|
Trend in the database industry is rapid DBMS versioning. It seems like we just start to get a... |
|
|
2 referals
0 comments,
260 views
|
|
|
Today everybody is running for an MBA. But can an MBA make a better manager? After engineering... |
|
|
1105 referals
64 arguments,
3502 views
|
|
|
a comparison of top-down and bottom-up planning in management. |
|
|
40 referals
9 arguments,
1189 views
|
|
|
|
|
|
|
Recent Knowledge (34)
|
|
What could be the size of Indian Switch market ( Low Voltage) |
|
|
4 referals
15 comments,
526 views
|
|
|
Free Style Marketing How many times have you been to a business conference that guided the world... |
|
|
72 referals
5 comments,
723 views
|
|
|
Hello friends, Sharing you with you an interesting blog posted on TalentEquity.in about how to... |
|
|
1371 referals
17 comments,
397 views
|
|
|
|
|
Sponsored Jobs
More From Author
I dont think so, that Google will be able to dominate other business formats than search, though they are on a acquiring spree it will be difficult for them to come out with new product time and again, it would do good if they improve their search... |
Inappropriate use of caching... does that logic need to be cached or is its invocation infrequent enough that maybe a plain old CGI is exactly how it should be implemented? |
I personally feel that the main aim of providing a product or a service is to satisfy and to retain the customers in this competitive world. iStockphoto is both an online community for photographers and a source of high quality, low-cost stock...... |