How you can lose Important Data

When you lose your data you may lose very important
information; birthdays, appointments, contact
addresses, homework assignments, work documents and
other important information that you stored on your
computer not realizing that you could lose it.

Maybe it was a page you had pulled up and working on
when someone came in to talk. During the conversation
a button may have been pushed and all of your hard
work that day was deleted. Any other time you would
worry but this problem can be fixed easily.

When you lose your data sometimes you can fully
recover it simply by going into the recycle bin and
restoring it while other times it may be deleted from
the recycling bin as well.

You need to restore the document soon in order to
finish your work. There are other ways that you can
lose your data; Hardware problems, system problems,
computer virus, disaster such as a fire or other act
of nature that may cause damage to your computer.

With the technology that is available today you can
sometimes recover data from your hard drive even after
a fire, depending on the damage that was done.

There is hardly anything that prevents recovery of
data now. Just because your data seems lost or deleted
don’t underestimate what data recovery sources can do
to bring your data back and restore it to its original
form. Using software or an online service can prevent
loss of data at any time.

Read More

Online Data Recovery Solutions

Losing your data usually occurs when you don’t have
the extra time to fix the problem. You may rely on
your computer for work or you may use your home
computer to keep track of important personal files.

Whatever your reason you are going to be lost without
your data so you need to find a quick easy solution to
restore your data quickly and easily so you don’t have
to go long without those important files and
documents.

There are several online options to saving data to
prevent data loss. These online solutions are
available twenty four hours a day, seven days a week.

The first choice you may have is to hire an online
company that can store your data incase of a system
lock up, crash or failure. Using these types of
services may be your answer, especially if you
frequently depend on your computer to house vital
information and records.

You can also purchase an online backup and restore
software which will allow you to recover lost data
anytime you need to.

These online solutions can recover data from a hard
drive, laptop, desktop, server, RAID, OS, tape, email,
file, digital photo, mobile device and more.

These online companies make recovery simple and easy
to use and can protect you from losing data
permanently.

The main reason someone loses their data is due to a
hardware or system problem but there are other reasons
such as human error, disaster, virus, or software
corruption. Either way you don’t realize how nice an
online data recover solution is until you need it.

Read More

Oracle Compatibility Developer's Guide for DBAs & Application Developers

Get white paper on Oracle Compatibility Developer's Guide for DBAs & Application Developers by EnterpriseDB at http://research.bizreport.com/detail/RES/1240871902_713.html?li=201125&src=KA_RES_20090504&asrc=EM_KAR_6782029&uid=4401398

Below is the abstract.

In today's challenging economic climate, organizations running Oracle are struggling to meet rising information demands with constricted budgets. Oracle shops have historically been reluctant to explore alternative databases, due to perceived risks of performance degradation, application recoding, and the time and costs associated with re-training personnel.
EnterpiseDB's Postgres Plus provides over 300 organizations with a proven open source alternative to expensive proprietary database products like Oracle. Postgres Plus significantly reduces total cost of database ownership, without sacrificing performance and scalability by:

Eliminating up-front perpetual license fees
Dramatically reducing the time cost and risk of migrating Oracle applications to Postgres Plus
Leveraging an organization's existing Oracle skills and infrastructure investments
Providing 24/7 "follow the sun" support, training and professional services
This white paper examines how EnterpriseDB's Oracle compatibility makes it easy for enterprises with existing Oracle investments to enjoy the benefits and cost saving of an open source database

Read More

What is Data Recovery?

Data recovery is the process of saving the information
that you can no longer get to by using the normal
source. Without being able to reach your data you may
lose important documents and information that you
cannot find anywhere else.

Data recovery will help you to recover that
information even if your system has crashed. There are
several ways you can recover the information and you
can do it yourself or you can hire someone to do it
for you.

Recovering data can sometimes be more complicated,
depending on why you lost the data to begin with. You
may have no other choice but to find someone who can
recover the data for you.

Data can be lost by any physical damage done to the
storage media or any mechanical failure that would
cause the media to crash. For the most part with any
physical damage you may be able to recover some but
not all of the data lost.

You may be able to recover data from a mechanical
glitch as long as the media is not damaged in the
process. You may use data recovery tools to help you
recover your data that is lost.

These tools are available in different kits depending
on your need.

With today’s technology data recovery online or
offline is possible with tools and other solutions to
help you save as much as possible.

There are several data recovery agencies to help you
online with your data recovery and offer a lot of
information for those who wish to try recovery
themselves.

Read More

Customer data integration implementation: How to be a CDI success story

Highly accurate and up-to-date customer data is one of the keys to maintaining strong customer relationships and ultimately growing revenue. Furthermore, lacking a single view of the customer through a customer data integration (CDI) initiative or a master data management (MDM) system enables organizations to lack a realistic way of applying vital data quality tools enterprise-wide. At the same time, companies are turning from traditional batch-oriented techniques to real-time data integration in order to eliminate the scourge of out-of-date data.

Read this E-Guide and explore a variety of suitable real-time data integration methods as well as relevant benefits and drawbacks. Learn how your organization can improve efficiency and obtain a competitive advantage with CDI.

More at www.bitpipe.com

Read More

Improve Performance, Reduce Data Growth Costs - Archiving ERP Applications

View this Webcast to find out from the experts how effective application archiving can help you effectively manage your production database, control data growth, and ultimately improve your bottom line. You'll learn to:

* Improve performance of the production environment
* Archive or purge inactive transactional data automatically to an online database or offline flat file
* Maintain complete application integrity
* Comply with data retention regulations
* Reduce application storage footprint
* Enable accessibility to archived data
* Further your bottom-line savings with application retirement
more on this...

Read More

Strategies for Centralizing Data Backup

Organizations are facing a massive challenge in protecting their data in a cost effective and timely manner. But with a growing number of branch offices, an increasing number of servers, and a high priority on reducing cost, backup is becoming increasingly difficult. In this paper, learn Riverbed's proven strategy for combining WAN-based backup with wide-area data services (WDS) solutions. Backup windows can be cut significantly and bandwidth use can be reduced by 60% to 95% at the same time. Riverbed will seamlessly integrate with your existing backup software and current storage infrastructure.
More on this ...

Read More

Storage Choices For Virtual Server Environments

Server virtualization is the most substantial shift in IT so far this decade. Adoption is high, and firms are virtualizing mission-critical and business-critical applications. But while server virtualization has become mainstream, firms still struggle with storage availability and performance. Storage configuration options abound, and successful deployment can be tricky.

In an attempt to add clarity to this tricky decision process, Forrester surveyed 124 of its global clients on the topic of storage for virtual server environments. Overall, Forrester found a high number of virtual server deployments in production, mainly using preexisting Fibre Channel storage area networks. For IT professionals who will either upgrade or deploy a new storage environment to support server virtualization, this report gives an overview of what firms have done in the past, as well as key Forrester recommendations.

more about Storage choices for virtual server environments at http://whitepapers.techrepublic.com.com/abstract.aspx?docid=949313&promo=099&tag=nl.e099.em040209&tag=nl.e099

Read More

Postgres Plus® Advanced Server

Postgres Plus claimedto be able to replace oracle database functionality, 100% compatible oracle database. We've tried it with out oracle database, and every triggers are working fine, all the same with procedure, view. The platform supported included windows, linux 32/64 bit MAC OS X... below are some of it's feature and download link.
some feature I took it from the official site: http://www.enterprisedb.com

Packed with Performance: discover DynaTune® , Bulk Collect and Bind, Query Optimization Hints, Distributed Memory Caching, Federated Queries and much more.

Productive Tools: check out Postgres Studio with advanced programming capabilities, Oracle® Replication Console, GridSQL® Monitoring Console, DBA Management Server and Migration Studio.

Tops in Compatibility: see why Advanced Server is the only open source database that runs applications that were written for Oracle without requiring changes for a fraction of their licensed cost! You can also migrate MySQL® and other commercial databases too.

Download

Read More

Database Tour Pro 5.1.0.715. Manage your database with variety of functions!

For a software developer, a «Swiss knife»-style tool can be incredibly useful, but only when that?s the «right» tool. The problem is, nobody can tell you exactly, how to determine whether a tool is «right». A right tool must be full-featured, but it must not be overloaded with features; a right tool must have laconic and functional interface, but it must be easy to learn and understand; it must support all possible platforms, but must also be not bloated. In the database area, Database Tour Pro is the right Swiss-knife tool.

As for the platform aspect, Database Tour Pro supports virtually all databases, which can be accessed through BDE or ADO database abstraction layers. That includes a wide range, from the simple CSV files through the enterprise-level Oracle databases.

As for the features aspect, Database Tour Pro allows all of the standard database management tasks (creating tables, viewing, editing and printing data) alongside with the more advanced ones (import and export, copy to clipboard, syntax-highlighting SQL editor and builder.) It also provides complex features for data analysis, sorting, filtering and reporting. The software also works in command-line mode, which makes it a good tool for DB scripting.

As for the interface side, Database Tour Pro has colorful, informative and quite slick interface; it provides outstanding BLOB viewing capabilities (for images, RTF’s and so on).


Cross-database tool with report builder. Tested on Paradox, dBase, FoxPro, ASCII, Lotus, HTML, InterBase, Oracle, SQL Server, MS Access, MS Excel, PostgreSQL, MySQL.

Main features are:

-Viewing, editing, and printing data.

-Automatically created reports and convenient report builder (with templates, expressions, preview, etc.).

-Building queries with tools for convenient writing the SQL statesments.

-Enhanced db grids, which allow to view and manipulate the data in the most convenient way.

-Creating, deleting, modifying BDE aliases.

-Command line support for most important operations like exporting, query executing etc. Log of performed operations.

-Searching and replacing text.

-Importing data to table from another table or a query.

-Exporting data from any open table or query to another database or file (with format conversion).

-Copying data to clipboard.

-Calculating numeric fields (sum, avg, min, max, count).

-Editing BLOB fields (MEMO, graphic).

-Tools for editing string fields (trimming, changing case of symbols).

-Sorting (logical and physical) data.

-Filtering data.

-Viewing structure with ability to print it.

-Limited table restructure.

-Reindexing tables.

-Customized data view (color, font style, temporarily hiding any column).

-Transaction control.



More about Database Tour Pro 5.1.0.715

Download

Read More

Oracle Maestro 8.12

Oracle Maestro is a powerful solution for the Oracle server administration and development. Key features include:

- support for all Oracle server versions on the market;

- easy database object management ;

- database designer;

- PL/SQL debugger;

- data management: viewing, editing, grouping, sorting and filtering abilities;

- handy SQL editor with code folding, syntax highlighting, SQL formatter and multi-threading;

- visual query builder;

- data export/import to/from the most popular formats;

- powerful BLOB Viewer/Editor.

The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more.


Download

Read More

Public Synonym

If you are the owner of a table or view and you create a public synonym for the table
or view, when you grant select on the synonym mane you are in effect granting select
on the table or view. The synonym eliminates the need to clarify the table or view
with the schema.table name.

And here is how yo create public synonym

CREATE public SYNONYM [table/view name] FOR [owner].[table/view name];

and then you can grant select/insert/update/delete on this object to the role which will apply to any user who was assigned that role. Without the role assigned to that specific user he/she would still not be able to access that object event it was create as public synonym

Read More

Oracle 11g Data Compression Tips for the DBA

One of the exciting new features of Oracle 11g is their inline data compression utility. While it is true that data storage prices have fallen dramatically over the last decade, and continue to fall rapidly, Oracle data compression has far more appealing benefits than simply saving on disk storage cost. Because indexes and the data itself can be highly compressed, information can be fetched off of the disk devices with less physical IO, which radically improves query performance under certain conditions.

Let's take a closer look at how one would implement Oracle 11g Data Compression in order to achieve the optimal results.

Understanding data compression

Data compression techniques, such as the Huffman algorithm, have been around for nearly a century, but only today are being put to use within main stream information systems processing. Using these techniques, a decompression utility is called immediately upon the data block fetch. Within the Oracle data buffers, the fully uncompressed version of the data remains in the data buffers, even though the information remains compressed on the data blocks themselves. This leads to an anomaly between the size of information on the data blocks and the size of the information within the data buffers. Upon applying Oracle data compression, people will find that far more rows will fit on a data block of a given size, but there is still no impact on the data base management system from the point of view of the SGA (system global area). Because the decompression routine is called upon block fetch, the Oracle data buffers remain largely unchanged while the data blocks themselves tend
to have a lot more data on them.


Tests show that 11g compression results in slower transaction throughput but creates less writes because of higher row density on the data block. Overall, the benchmark slows that I/O writes being reduced while CPU increases, resulting in slowing SQL throughput:

* Slower transaction throughput – As we expect, Oracle transactions run faster without the encryption/decryption processing overhead. This encryption benchmark shows significantly slower throughput when deploying TDE, almost 20% (81 transactions/second with TDE, 121 transactions/second with TDE).

* Less Disk Writes – Since transparent data encryption compresses the data, the benchmark with TDE required less disk writes.

* More CPU required - As we would expert, TDE required CPU cycles for the encrypt/decrypt operations, and in this benchmark test we see User CPU rise from 46 to 80 when using TDE data encryption.

Read more

Read More

Oracle Critical Patch Update January 2009

The Critical Patch Update for January 2009 was released on January 13, 2009. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities for each product suite, and links to other important documents. Supported products that are not listed in the "Supported Products and Components Affected" section of the advisory do not require new patches to be applied.

Also, it is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches, as this is where you can find important pertinent information.

The Critical Patch Update Advisory is available at any of the following locations:

Oracle Technology Network: http://www.oracle.com/technology/deploy/security/alerts.htm

Oracle, PeopleSoft and JD Edwards products: https://metalink3.oracle.com/od/faces/secure/km/BrowseResults.jspx?fid=15948.1

Oracle BEA products: https://support.bea.com/application_content/product_portlets/securityadvisories/index.html

The next four Critical Patch Update release dates are:

Read More

New Release of MySQL 6.0.9 (Alpha)

New Release of MySQL 6.0.9 (Alpha)

MySQL 6.0.9-alpha, a new version of the MySQL database system has been released. A new algorithm that uses both index access to the joined table and a join buffer has been implemented. It's called Batched Key Access (BKA) Join algorithm. The algorithm supports inner join, outer join and semi-join operations, including nested outer joins and nested semi-joins.

View the complete list of changes

Download MySQL 6.0.9 (Alpha) »

Read More