Email Alerts
-
SearchOracle.com Advisory Board
Advisory Board
-
Oracle 10g tops list of Oracle database platforms
In a survey taken in 2010, Oracle professionals listed Oracle Database 10g as their primary database platform, despite 11g having been out since 2007. Slideshow
-
Oracle upgrades lead expected database changes this year
Oracle database upgrades will be big on Oracle professionals' list of things-to-do this year, according to a recent survey by SearchOracle.com. Slideshow
-
Diving deeper into the SQL database features
There are dozens of SQL database features for Oracle, IBM and Microsoft that have advantages and disadvantages that must be sorted through. This guide should help. Guide
-
How to determine your SQL database through needs analysis
Finding the best SQL database for your company can be a long-drawn-out process that should not be taken lightly. The journey starts with a single step: a thorough 'needs analysis. Guide
-
The MySQL open source database in the enterprise
The MySQL open source database is not a head-to-head competitor with the SQL database offerings of Oracle, IBM and Microsoft, but many have discovered its hidden advantages. Guide
-
Breaking down the contenders in the SQL database market
In this chapter we take a look at the relative strengths and weaknesses in the SQL database offerings of The Big Three in the SQL database market: Oracle, IBM and Microsoft. Guide
-
Oracle database performance tuning guide
Learn the tricks of industry experts for identifying and eliminating performance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common problem... Learning Guide
-
Relational Database Management System (RDBMS) fundamentals tutorial
New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database management system. Learning Guide
-
Relational database theory for practitioners
Chris Date has long been a champion of relational theory, and his latest book, Database in Depth: Relational Theory for Practitioners is aimed at database professionals who "are honest enough to admit they don't understand the theory underlying their... Chapter Download
-
IBM aims new database squarely at Oracle users
The latest version of IBM's flagship DB2 database offers several features designed to coax Oracle customers out of their software comfort zones. News | 23 Apr 2012
-
Can SAP databases compete with Oracle?
SAP claims it wants to be the No. 2 database vendor by 2015, and it’s pushing to do so. But is its goal realistic, and what is Oracle doing about it? News | 17 Apr 2012
-
Oracle Advanced Analytics bundles R with Oracle Database
Oracle Advanced Analytics is the company’s newest announcement around data analytics, a market that Oracle seeks to blanket with products. News | 08 Feb 2012
-
Book explores Oracle, MySQL query methods
Michael McLaughlin, author of Oracle 11g & MySQL 5.6 Developer Handbook discusses the benefits of keyword querying and more in this interview. Q&A | 29 Nov 2011
-
Can Oracle be a NoSQL player?
The Oracle NoSQL database is mainly an attempt to satisfy existing Oracle Database customers interested in big data on the side, experts say. News | 25 Oct 2011
-
Oracle’s largest database runs Beehive on Oracle Exadata
Oracle’s in-house email and collaboration application runs a 101 TB database on Oracle Exadata. A company official explained the deployment. News | 05 Oct 2011
-
Facebook MySQL DBA gives tips on server management
Facebook MySQL database administrator (DBA) Rob Wultsch tells Oracle OpenWorld attendees to “keep it simple, stupid” and gives tips for preventing DBA burnout. News | 03 Oct 2011
-
Data replication software helps hospital network prepare for the worst
The UPMC health network faced several data replication software challenges when ramping up its disaster recovery site. News | 21 Jul 2011
-
Exadata and Exalogic's effect on database performance
Oracle Database performance can get a boost from newer Exadata and Exalogic server appliances, but the database design must still be good. Feature | 15 Jun 2011
-
Oracle Database 11g R2 High Availability sample book chapter
Here is a sample chapter from Oracle Database 11g R2 High Availability, a new book from Oracle Press. Book chapter | 27 May 2011
- See More: News on Oracle database design and architecture
-
Oracle vs. SQL Server faceoff: Oracle Database wins on high availability security
An Oracle user group member argues that Oracle wins in the battle of Oracle vs. SQL Server. Faceoff
-
In-memory databases: Oracle TimesTen vs. Sybase ASE, part 2
In this second part, expert Mich Talebzadeh looks at how Sybase’s Adaptive Server Enterprise (ASE) in-memory database compares with Oracle TimesTen. Tip
-
In-memory databases: Oracle TimesTen vs. Sybase ASE
In this first part, expert Mich Talebzadeh looks at the Oracle TimesTen in-memory database, detailing how it works and explaining when it’s beneficial over a traditional relational database management system. Tip
-
Addressing quality-of-service improves Oracle database consolidation
In this fourth installment of a series on Oracle database consolidation, Jeff McCormick writes about achieving multi-tenancy within Oracle Database by addressing more quality-of-service concerns. Tip
-
How to copy an Oracle database
Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database. Tip
-
How Oracle Virtual Private Database helps consolidation
In this third part of a series on Oracle database consolidation, contributor Jeff McCormick explains how the Oracle Virtual Private Database (VPD) can promote and encourage Oracle database consolidation. Tip
-
Consolidate Oracle databases with session schema management
In part two of this series on database consolidation, the author explains how an Oracle consolidation can be done using session schema management. Tip
-
Oracle database consolidation is a paradigm shift
Oracle database consolidation can save IT organizations a lot of money, but require them to get past the mental hurdle of so-called shared databases. Tip
-
Dealing with Oracle Database bottlenecks
Unclogging Oracle Database bottlenecks can range from simple SQL re-coding to examining CPU use and monitoring the network infrastructure. Tip
-
Oracle XML capabilities in Oracle Database 11gR2, part 3
This third part of a series on Oracle XML capabilities explains how to ingest, shred and publish XML data in Oracle Database. Tip
- See More: Tips on Oracle database design and architecture
-
Understanding Oracle Exadata Smart Scan
Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata. Answer
-
Oracle temporary tablespace too large
One reader asks how he can adjust a query to prevent his temporary tablespace file from getting too large. Answer
-
Mirroring in Oracle RAC and Data Guard
A reader asks a question about mirroring on Oracle RAC using Data Guard. Answer
-
Oracle RAC and distance limitations
One reader asks what the Oracle RAC distance limitations are for two environments being run in sync. Answer
-
Exadata, hybrid columnar compression, and inserts
One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata. Answer
-
Oracle Exadata and SGA caching
One reader asks Oracle Exadata book co-author Rick Greenwald about the SGA caching dynamic in Exadata. Answer
-
Cache Fusion for RAC on Exadata
One reader asks whether Cache Fusion for Oracle RAC is implemented differently on Oracle Exadata compared to other platforms. Answer
-
Can I use special characters in Oracle table names?
Learn why you may want to avoid using special characters in Oracle table names when they also have meaning in utilities or SQL scripts in this tip from Oracle database expert Brian Peasland. Answer
-
Server load problems after moving from Oracle 10g XE to 11g SE One
Experiencing server load problems when moving from Oracle 10g XE to 11g SE One? Learn ways to solve these server load issues in this tip from Oracle database expert Brian Peasland. Answer
-
Minimize database downtime when moving an Oracle DB to a new server
Learn how to minimize database downtime when moving your Oracle 10gR2 database from a Windows 2003 32-bit server to a Windows 2008 64-bit server, using the Database Configuration Assistant, in this tip from an Oracle database expert. Answer
- See More: Expert Advice on Oracle database design and architecture
-
virtual private database (VPD)
A Virtual Private Database (VPD) makes the database tables seem like they belong to one user when multiple users may actually be using that table. Definition
-
flexfield
In an Oracle environment, a flexfield is a database field that has flexibility built into it so that users can define reporting structures that are relevant to their specific organizations. Definition
-
E. F. Codd (Edgar F. "Ted" Codd)
E. F. Codd (Edgar F. "Ted" Codd) formed the concepts for organizing and accessing data that are embodied in the relational database, the predominant approach to data organization in today's business world. Definition
-
extent
An extent is a set of contiguous blocks allocated in a database. Definition
-
row
In a database, a row (sometimes called a record) is the set of fields within a table that are relevant to a specific entity. Definition
-
splay tree
A splay tree is a self-adjusting search algorithm for placing and locating files (called records or keys) in a database. Definition
-
field
A field is an area in a fixed or known location in a unit of data such as a record, message header, or computer instruction that has a purpose and usually a fixed size. Definition
-
quad tree
A quad tree is a method of placing and locating files (called records or keys) in a database. Definition
-
record
In computer data processing, a record is a collection of data items arranged for processing by a program. Definition
-
relational online analytical processing (ROLAP)
Relational online analytical processing (ROLAP) is a form of online analytical processing (OLAP) that performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually cons... Definition
- See More: Definitions on Oracle database design and architecture
-
Is Oracle Exadata vs. SAP HANA a valid comparison?
Experts Alex Gorbachev of Pythian and John Appleby of Bluefin Solutions debate the merits of Oracle Exadata and SAP HANA. Podcast
-
What managers should consider when starting a database scaling project
Learn about database scaling from Oracle consultant Don Burleson, who discusses the goals, costs and challenges of scaling an Oracle database in this podcast. Podcast
-
IBM aims new database squarely at Oracle users
The latest version of IBM's flagship DB2 database offers several features designed to coax Oracle customers out of their software comfort zones. News
-
Can SAP databases compete with Oracle?
SAP claims it wants to be the No. 2 database vendor by 2015, and it’s pushing to do so. But is its goal realistic, and what is Oracle doing about it? News
-
Oracle vs. SQL Server faceoff: Oracle Database wins on high availability security
An Oracle user group member argues that Oracle wins in the battle of Oracle vs. SQL Server. Faceoff
-
In-memory databases: Oracle TimesTen vs. Sybase ASE, part 2
In this second part, expert Mich Talebzadeh looks at how Sybase’s Adaptive Server Enterprise (ASE) in-memory database compares with Oracle TimesTen. Tip
-
In-memory databases: Oracle TimesTen vs. Sybase ASE
In this first part, expert Mich Talebzadeh looks at the Oracle TimesTen in-memory database, detailing how it works and explaining when it’s beneficial over a traditional relational database management system. Tip
-
Addressing quality-of-service improves Oracle database consolidation
In this fourth installment of a series on Oracle database consolidation, Jeff McCormick writes about achieving multi-tenancy within Oracle Database by addressing more quality-of-service concerns. Tip
-
How to copy an Oracle database
Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database. Tip
-
Understanding Oracle Exadata Smart Scan
Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata. Answer
-
Oracle Advanced Analytics bundles R with Oracle Database
Oracle Advanced Analytics is the company’s newest announcement around data analytics, a market that Oracle seeks to blanket with products. News
-
How Oracle Virtual Private Database helps consolidation
In this third part of a series on Oracle database consolidation, contributor Jeff McCormick explains how the Oracle Virtual Private Database (VPD) can promote and encourage Oracle database consolidation. Tip
- See More: All on Oracle database design and architecture
About Oracle database design and architecture
Have a question about best practices for Oracle database design, configuration and table design? This section contains the tips and expert adivce for DBMS versions 8, 9i, 10g and 11g to help you out.