Database administration and software
- Date: 2007-11-02 - Word Count: 485
Share This!
Data is vital to an organization’s functioning. Compromise of data due to security breach, access by unauthorized people, corruption of data due to human or machine error may irrevocably damage data integrity. A new breed of IT professionals has emerged to cater to this need. Data administration essentially means storing, backing up, and ensuring total data integrity of a database. The database administrator continuously monitors the health of a database. It is his responsibility to create a data recovery procedure or process in case of loss of data. This in popular parlance is known as disaster recovery. The need for data backup has been felt acutely after 11/7 where many corporations lost their entire database which may have been collected over many decades. This may include roll back to a state or time where the data is verifiable. This roll back operation is possible with some of the RDBMS like Oracle and IBM DB2. Extensive tests are available to ensure that roll back plan is effective and verifiable. Database administrators are to ensure that only authorized access is permitted to the database. Database availability is a key issue to be addressed. Data should be available as and when requested. Database tuning called performance tuning is required to make access faster. Tackling issue of performance may be one of the main activities of a database administrator.
Database software
Businesses run on data and storage, retrieval, manipulation and presentation of data is one of the most important functions of computers. Dedicated Database software has been designed to cater to this need. The early nineties were witness to windows based database software. The noteworthy ones are FOXPRO which started off as FOXBASE by FOX software. It later transformed the database field by introduction of Rushmore technology. It also introduced a graphical Screen Builder and Report Builder and integrated SOL support. FOXPRO became so popular that Microsoft soon acquired it and included it in its Visual Suite and renamed it as Visual FoxPro which continues by this name even today. Concurrent to the development of FoxPro another competing database offering was available in the market, dbase. Both these continued development head to head till version dbase IV after which it lost its way. The major reason given for its downfall was its inability to cater to a more technically savvy professional who demanded an advanced set of programming tools which dbase could not provide. However there were major limitations with both these software especially while handling large databases, real time application and online transactions. This space was filled up by Oracle. Subsequently Microsoft brought out two database software applications, Access and SQL server.
Data in the modern world is increasing by leaps and bounds. The quality of data is also quite sophisticated and requires specialist treatment. Database administrators are trained to manage large amounts of data and ensure its integrity, security and availability. Database is today a separate field of activity altogether.
Database software
Businesses run on data and storage, retrieval, manipulation and presentation of data is one of the most important functions of computers. Dedicated Database software has been designed to cater to this need. The early nineties were witness to windows based database software. The noteworthy ones are FOXPRO which started off as FOXBASE by FOX software. It later transformed the database field by introduction of Rushmore technology. It also introduced a graphical Screen Builder and Report Builder and integrated SOL support. FOXPRO became so popular that Microsoft soon acquired it and included it in its Visual Suite and renamed it as Visual FoxPro which continues by this name even today. Concurrent to the development of FoxPro another competing database offering was available in the market, dbase. Both these continued development head to head till version dbase IV after which it lost its way. The major reason given for its downfall was its inability to cater to a more technically savvy professional who demanded an advanced set of programming tools which dbase could not provide. However there were major limitations with both these software especially while handling large databases, real time application and online transactions. This space was filled up by Oracle. Subsequently Microsoft brought out two database software applications, Access and SQL server.
Data in the modern world is increasing by leaps and bounds. The quality of data is also quite sophisticated and requires specialist treatment. Database administrators are trained to manage large amounts of data and ensure its integrity, security and availability. Database is today a separate field of activity altogether.
Related Tags: computers, data, integrity, presentation, access, database, ibm, dedicated, integrated, sol, db2, foxpro, rdbms, professonals
Join me at Deans IT Support Your Article Search Directory : Find in Articles
Recent articles in this category:
- Using Keywords Effectively For an SEO Campaign
Keyword research is one of the most crucial parts of an SEO campaign. If you end up choosing the wro - Search Engine Optimization Copywriting Tips
SEO copywriting is not as technical as it sounds but is different from traditional copywriting for t - 3 Tips to Make Money Using Videos
For the last five years video has been a real success in the internet. Now you can find video in alm - Is Social Media Networking Your Next Strategy For Your Online Marketing?
When you try to work on online promotion and online marketing, social media especially social media - Submitting a URL of Your Website
People who make a website usually do research on how to improve not only the quality of their websit - 5 Bad Habits of Article Marketing
There are many ways to advertise your company but having a highly ranked website is the best. Most p - Facts About SEO Services Company
SEO services companies are becoming very popular in the internet marketing world but there are some - 4 Ways Search Engine Optimization Can Be So Powerful
Whether you are an affiliate marketer, small businessman or a large organization, your first step wh - A List of 3 Options For Internet Business
The trend of making money through online business has become trendy now a day. People are shifting t - Getting the Best Affiliate Products For Your Site
Making money online was never so difficult before. There are numerous ways through which you can mak
Most viewed articles in this category:
- The Revolutionized Ebay Etailsolution Software
With the help of eBay, the auction business has received a new meaning. With the help of the many eB - Internet Millions - by Ryan Orrell - Honest Review
REVIEW: "Internet Millions", by Ryan Orrell, is a refreshing new kind of internet marketing e-bo - A Google Adsense Addiction
54% of all Google Adsense publishers admit addiction to click income. A recent online study conducte - Lead Generation for Top Residual Income
At the heart of any good residual income business is a person who knows how to generate leads. Lead - Make Money With Information Ebook Products: The Other End
I don't like thinking of myself as the kind of person that has made it rich on the internet, but in - Repeat Business Equals a Residual Income Stream
Residual income comes from other people reacting to a single action by the business owner. What bet - The NFL & United Way
There are many ways that NFL players help with the United Way. First of all, they donate a lot of th - Seo - Making Money Writing Seo Reviews
If you are a reviewer or critic you are likely to find work writing reviews of products and services - Understanding Perfume Types
Understanding the various varieties of perfume can help to cut through the difficulty in selecting a - Ecommerce Basics: Three Things To Avoid
When you decide to put your ecommerce website together there are a few mistakes that are easy to mak