 | Oracle eXpress Edition (XE) Tutorial (http://st-curriculum.oracle.com/tutorial/DBXETutorial/index.htm) Oracle Database 10g eXpress Edition (XE) Tutorial. Oracle XE is a free, entry-level, small-footprint database.
| |
| 10G RMAN Testing Part 1 (http://www.dbazine.com/blogs/blog-cf/chrisfoot/10grmanpart1) Recovering an Oracle database is a wonderfully complex task. Data files, log files, control files, full backups, hot backups and point-in-time recoveries all combine to make many administrators lie awake nights wondering if their databases can be easily recovered. Oracle10G contains numerous enhancments to the RMAN backup utility. As a result, a thorough testing of 10G RMAN is warranted.
| |
| A Gentle Introduction to SQL (http://sqlzoo.net/) Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer SQL, PostgreSQL and Access.
| |
| A Practical Guide to Data Warehousing in Oracle - Part 3 (http://databasejournal.com/features/oracle/article.php/3317621) One feature that is almost ubiquitous in Oracle data warehousing is the use of the Partitioning Option. Over the past few major releases the feature set associated with partitioning has increased to cover four different partitioning types and improvements in the manageability of partitioned objects.
| |
| A Practical Guide to Data Warehousing in Oracle, Part 1 (http://databasejournal.com/features/oracle/article.php/3113551) If there is one adjustment to make to an OLTP mindset when you start working with data warehouses that I would emphasize more than any other, then it is that your new Enemy Number One is the disk subsystem. Nothing will cripple a data warehouse more effectively than a failure to manage your i/o requirement vs. your i/o capacity, and there will be continual reminders of this throughout the series.
| |
| A Practical Guide to Data Warehousing in Oracle, Part 2 (http://databasejournal.com/features/oracle/article.php/3304791) Some of the major differences from OLTP systems that you will encounter in data warehousing are the types of tables. The Oracle Data Warehousing Guide names and describes two major table types - facts, and dimensions, and if you were not sure of the difference, it would be worthwhile having a look at that document before we continue. In this article, we will be looking at various possible attributes of tables, and seeing what use we can make of them in different table types of a data warehouse.
| |
| A Practical Guide to Data Warehousing in Oracle, Part 4 (http://databasejournal.com/features/oracle/article.php/3332641) On a regular OLTP system, one of the perennial sources for doubt and debate is the number, type and configuration of indexes, and for good reason. An OLTP system generally runs with some limited set of select queries and a range of updates, inserts, and deletes. A balance has to be struck between providing rapid access to data for all of these operations - the selects in particular, I suppose - and avoiding an excess of overhead when the delete, insert, or update actually modifies the table, and hence the indexes.
| |
| A Practical Guide to Data Warehousing in Oracle, Part 5 (http://databasejournal.com/features/oracle/article.php/3345451) On a regular OLTP system, the integrity of the data is generally supported in two ways - firstly by logic embedded in the application, and secondly by constraints placed on the logical structure of the database itself. The two may be complementary, as a designer may rely on the latter to support the former, through interpretation of error messages raised by the database.
| |
| A Practical Guide to Data Warehousing in Oracle, Part 6 (http://databasejournal.com/features/oracle/article.php/3353191) Materialized views have been available in Oracle for quite a while, under their alter ego "Snapshots," and OLTP persons will be familiar with them through their Replication abilities. In the world of data warehousing they serve a rather different function, although in an abstract way they are doing exactly the same thing, which is to make a set of information available in multiple places.
| |
| A Practical Guide to Data Warehousing in Oracle: Series Introduction (http://databasejournal.com/features/oracle/article.php/3098791) Some six or seven years ago, I was working for a utility company, trying to extract high-level reports from their complex OLTP system. It turned in to a project of fiendish complexity, that essentially tried to answer the question, "Are we making a profit?" from a system holding all the individual income and expenses. Even for a person with a pretty extensive background in extracting information from transactional data it was a daunting task, with many failed experiments, dead-ends encountered, and systems-brought-to-their-knees by full table scans. What was really needed, although we did not realize it until rather late in the game, was a separate data warehouse or decision support system. However, even with some books by experts on data warehousing in general, and with Oracle-specific technical documentation, making the mental leap from OLTP to this new paradigm was a daunting prospect.
|
Oracle Tutorials - portal for direct links to free tutorials. Basics, PL/SQL programming, DB administration & optimization, SQL etc.
Most searched keywords