1-855-DBA-GURU

Back Up And Recover



Jagannath, Sushma “Back Up And Recover” Oracle Magazine.May/Jun 2008,:n-pag, Retrieved 02/26/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-may/o38ocp-084389.html Back Up And Recover TECHNOLOGY: OCP Back Up And Recover By Sushma Jagannath New backup and recovery features in Oracle Database 11g save time and data. A sound database backup and recovery plan is crucial to protecting data in the event of [...]

More Ways To Flash Back



Jagannath, Sushma “More Ways To Flash Back” Oracle Magazine. Sep/Oct 2008:n.pag, Retrieved 02/25/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-sep/o58ocp-084350.html More Ways To Flash Back TECHNOLOGY: OCP More Ways to Flash Back By Sushma Jagannath Query history and recover from corruptions with Oracle Flashback technology. Oracle Flashback technology comprises a group of Oracle Database 11g features with which you can [...]

Get Your Information In Order



Caffrey, Melanie,” Get Your Information In Order” Oracle Magazine. Sept 2011:n.pag, Retrieved 02/23/2013 from http://www.oracle.com/technetwork/issue-archive/2011/11-sep/o51sql-453459.html Get_Your_In formation_In_Oorder Get Your Information in Order By Melanie Caffrey Part 1 in a series on the basics of the relational database and SQL Ask most seasoned professionals working with Oracle Database instances today what their chief complaint regarding performance [...]

Smart Scans Meet Storage Indexes



Nanda, Arup.” Smart Scans Meet Storage Indexes” Oracle Magazine.May/Jun 2011:n.pag, Retrieved 02/21/2013 from http://www.oracle.com/technetwork/issue-archive/2011/11-may/o31exadata-354069.html Smart_Scans_Meet_Storage_Indexes TECHNOLOGY: Oracle Exadata As Published In May/June 2011 Smart Scans Meet Storage Indexes By Arup Nanda Understand how Oracle Exadata uses storage indexes to speed I/O. The Oracle Exadata Database Machine brings database performance to a whole new level, but [...]

How To Implement A Big Data System



Dijcks, Jean-Pierre.” How To Implement A Big Data System” Oracle Magazine. Jan 2012:n.pag, Retrieved 02/20/2013 from http://www.oracle.com/technetwork/articles/bigdata/implementing-bigdata-1502704.html How_To_Implement_A_Big_Data_System How to Implement a Big Data System by Jean-Pierre Dijcks Understanding a big data infrastructure by looking at a typical use case. Published January 2012 I often get asked about “big data,” and more often than not [...]

Preprocess External Tables



Nana, Arup.”Preprocess External Tables” Oracle Magazine. Mar/Apr.2011:n-pag, Retrieved 02/20/2013 from http://www.oracle.com/technetwork/issue-archive/2011/11-mar/o21nanda-312277.html Preprocess_External_Tables TECHNOLOGY: Oracle Exadata As Published In March/April 2011 Preprocess External Tables By Arup Nanda Use inline preprocessing on external tables to simplify extract, transform, and load operations. External tables, available since Oracle9I Database, enable you to view a text file as if it [...]

Cube Development For Beginners



Vasiliev, Yuli “Cube Development For Beginners” Oracle Magazine. Apr 2011:n-pag, Retieved 02/20/2013 from http://www.oracle.com/technetwork/articles/bi/cube-development-359587.html  Cube_Development_For_Beginners Cube Development for Beginners by Yuli Vasiliev Get the basics of data warehouse development using Oracle Warehouse Builder 11g. Published April 2011 From school, we know that although most math tasks have plain-English formulation, we still have to state an [...]

Intelligence And Identity



Rittman, Mark and Crisp, Joel” Intelligence And Identity” Oracle Magazine. Jan/Feb 2008:n.pag, Retrieved 02/20/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-jan/o18identity-087365.html Intelligence_And_Identity TECHNOLOGY: Identity Intelligence and Identity By Mark Rittman and Joel Crisp Integrating Oracle Business Intelligence and Oracle Identity Management When you are deploying Oracle Business Intelligence Enterprise Edition, how you handle identity management is as important as query [...]

Accelerating Data Warehouses



Vlamis, Dan” Accelerating Data Warehouses” Oracle Magazine. May/June.2008:n.pag, Retrieved 02/18/2013 from http://www.oracle.com/technetwork/issue-archive/2008/08-may/o38olap-085800.html Accelerating_Data_Warehouses TECHNOLOGY: Data Warehouse Accelerating Data Warehouses By Dan Vlamis Oracle OLAP 11g brings high-performance data warehouse features to Oracle Database 11g. An option of Oracle Database 11g Enterprise Edition, Oracle OLAP 11g is a full-featured online analytical processing engine. Because Oracle OLAP [...]

Managing Data Quality



Hardman, Ron.” Managing Data Quality” Oracle Magazine. Nov/Dec.2006:n.pag. Retrieved 02/18/2013 from http://www.oracle.com/technetwork/issue-archive/2006/06-nov/o66owb-095161.html Managing_data_quality TECHNOLOGY: Data Warehousing Managing Data Quality By Ron Hardman Oracle Warehouse Builder 10g Release 2 handles the truth. How much confidence do you have in the quality of your data? How about the data your business partners are feeding into your data [...]