Shortcuts to losing your data

                 

Please stand by..

We are Experiencing Technical Difficulties !!!

Loss of DATA can break a business.It will effect to the business objective and that can be influence into organisation, information system and security program. Threats have a significant impact on Databases and it can be physical or non physical threats. Data can be misplaced because of hardware failures, data can mistakenly delete from user, data corruption, and environmental disruption.

According to research by the University of Texas, “Only six percent of companies suffering from a catastrophic data loss survive, while 43 percent never reopen and 51 percent close within two years.” Further it state that, some of the organisation never recover from major losses of data. Jim Martin, the chief operating officer with Worldport Ireland state that, majority of data in organisations is not stored in central repository off site. World Trade Center is one of the convenient locations for business and most of the financial and investment organisations are located, which was destroyed in the attack on 2001. Hardware failures, breakdowns are almost natural incidence on occasion, users are no longer able to access the data on the databases and it has major impact on large amounts of corporate data. These kinds of situations emphasise the importance of proper disaster and recovery plan. Also importance of maintain a remote site replication of data is an efficient means of protection.

1.     User Error

Human error causes most data loss; Erroneous updates, delete from database or can be overwriting. Deleting the contents of a table and dropping database objects can mistakenly happen. 

2.     Data Corruption

Data can be corrupt because of the Software bugs or Virus attacks. 

3.     Media Failure

A failure within the electronic circuits or hardware components may cause for data loss.

4.     Disaster

Data can loss because of natural event or human behavior such as Terrorist attacks. It can be electrical Failures or complete loss of a power to a geographic area because of weather related (earthquakes, tsunamis) or other causes of power outage.

Oracle and SQL server both provide strong recoverability features; whereas in some aspects superior to the other. ORACLE supports incremental backups which is a strong option when managing large scale databases, where this has to be accomplished through transaction log applying in SQL server. A scheduled oracle database with full, differential and incremental backups would guarantee 100% recoverability along with the support of Data guard. Database mirroring is equivalent to oracle’s data guard, but important features oracle offer is yet unavailable in SQL server database mirroring,

Comparing Database snapshot with oracle’s flashback, oracle stands way up high. Oracle flashback is as easy as issuing a query where in SQL server snapshot has to be created and then look for the changes.

Data corruption and human error causes most data loss, in this scenario it is important to back up data from database since there is no option other than to recreate the data. Data can be corrupt because of the virus attacks or bugs however it can be directly effect to entire database, its associated table or few files.

In the event of a disaster, Property, computer equipment can be caused and valuable data can be loss.  Recovery from this type of data loss requires hardware redundancy and mirroring. There should be a proper disaster recovery plan for database with manageable process. Because of the large quantity of data organisations should ensure the backup strategy and backup medium is stored at an offsite location.

Considering the options offered by ORACLE and SQL server it was evident that ORACLE is in the lead and rich in options. It offers smoother restoration, recovery, zero data loss and also easy recovery from user errors. 

Data as a Corporate Asset

As businesses today face more competition, organisations spend millions on updating their systems. They are finding new solutions to increase the effectiveness of operations to provide innovative services in order to survive customer base.

Mainly, large scale organisations consider data as a corporate asset because it has direct involvement to the growth of business. Although data is useful to the business there are several key challenges that need to be addressed.

Large scale organisations always deal with a vast quantity of data hence it can be extremely difficult to manage data.  They collect and store huge amount of data regarding the vendors, customers, employees, inventory, markets and competitors. Generally, this helps to make better decisions in the ever increasing reliance of businesses. It is important to protecting data against all causes of loss or damage.

Data is Vital to any organisation and large scale organisations have several databases to store different kinds of data. Because of the rapid growth of data in the organisation raises the data accuracy and protection. When there is data duplicates, incomplete or inaccurate data it directly impact to the customer satisfaction loyalty.  Data has quantifiable value that is important to achieve business objectives while considering the business strategies of the organisation. However data needs to be accurate and up to date, accessible and secure, usable and well-governed when managing the data.

Data and information are vital resource in an organisation and it should be properly manage and secured. They provide more attention on databases since corporate organisational data and information have become the lifeblood of large scale organisations and frequently generating large volumes of data.

However Customer data are just as valuable as money. Loss of data can break a business and it will effect to the business objective. It is important to give more attentions on the area of data protection in an effective and efficient way.