As promised, the next entry in our 11gR2 explorations is In-Memory Parallel Execution. If you are going to Oracle OpenWorld next month make sure you check out...
As promised, the next entry in our 11gR2 explorations is In-Memory Parallel Execution. If you are going to Oracle OpenWorld next month make sure you check out the following session: Tuesday, October 13 2009 5:30PM, Moscone South Room 308Session S311420 Extreme Performance with Oracle Database 11g and In-Memory Parallel Execution.In this session you will get more details and insight from the folks who actually built this functionality! A must see if this is of any interest, so...
As promised, the next entry in our 11gR2 explorations is In-Memory Parallel Execution. If you are going to Oracle OpenWorld next month make sure you check out the following session: Tuesday, October...
What are we announcing, well... you just have a look over here:http://www.oracle.com/features/larry-ellison-webcast.htmlLarry Ellison will be introducing a very...
What are we announcing, well... you just have a look over here:http://www.oracle.com/features/larry-ellison-webcast.htmlLarry Ellison will be introducing a very cool new offering into the market. The webcast is tomorrow (Tuesday) September 15 at 1pm Pacific Time.Tune in, or come back after the session and read all about it here...
What are we announcing, well... you just have a look over here:http://www.oracle.com/features/larry-ellison-webcast.htmlLarry Ellison will be introducing a very cool new offering into the market. The...
By now you probably heard the news of the Oracle Database 11g Release 2. It is available and comes with a number of very interesting features for data...
By now you probably heard the news of the Oracle Database 11g Release 2. It is available and comes with a number of very interesting features for data warehousing.Obviously now you want to try this, so here is the download site for the software (OTN License required of course). The data warehouse collateral can be found on OTN as well, so here is the link for that.I would recommend everyone to first and foremost read the update on what the Oracle Database offers for data...
By now you probably heard the news of the Oracle Database 11g Release 2. It is available and comes with a number of very interesting features for data warehousing.Obviously now you want to try this,...
Got this comment on the blog from Satish. Satish is proposing (or forced) to create backup tables instead of using partitioning. I'm not sure you want to go...
Got this comment on the blog from Satish. Satish is proposing (or forced) to create backup tables instead of using partitioning. I'm not sure you want to go there.If you do, I think you will need to create views to show the data as a single entity, this means that you need to change the application to read from the views rather than from the original tables (or rename the tables first, then create views with the original names). You then want to compress the backup tables. So...
Got this comment on the blog from Satish. Satish is proposing (or forced) to create backup tables instead of using partitioning. I'm not sure you want to go there.If you do, I think you will need...
Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on...
Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on discussing some of the ODTUG session questions (see this post).One of the questions was about the use of partitioning and whether it is made obsolete by Exadata off-loading...In other words, should you look at one, the other or both? The answer is that you will want both, and there are a variety of reasons for that.First of...
Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on discussing some of the ODTUG...
This is your chance to learn from the experts in development. Maria is going to do a webcast in the BIWA TechCast series on the optimizer. August 5, 9am Pacific...
This is your chance to learn from the experts in development. Maria is going to do a webcast in the BIWA TechCast series on the optimizer. August 5, 9am Pacific Time.Since its introduction in Oracle7, people have been fascinated and intimidated by the cost-based optimizer and the statistics it relies on. While the Optimizer becomes more and more transparent and requires less and less attention, still a lot of people feel 'left out' and consider whatever happens inside the...
This is your chance to learn from the experts in development. Maria is going to do a webcast in the BIWA TechCast series on the optimizer. August 5, 9am Pacific Time.Since its introduction in Oracle7,...
Continuing on with this theme of securing your data warehouse…The next stage, having secured the transmission of all data be accessed via SQL net, is to make...
Continuing on with this theme of securing your data warehouse…The next stage, having secured the transmission of all data be accessed via SQL net, is to make sure that all tools and applications, or as many as possible, use these encrypted network transmission processes. Lets look at some of these tools in more detail:SQLDeveloperThis requires the use of SQLDeveloper 1.5 or later. There are a number of ways to configure database connections in SQLDeveloper and SQLDeveloper...
Continuing on with this theme of securing your data warehouse…The next stage, having secured the transmission of all data be accessed via SQL net, is to make sure that all tools and applications, or...
Does anyone take data security within their warehouse seriously? This is not a trick or facetious question because, according to news posting on the web a few...
Does anyone take data security within their warehouse seriously? This is not a trick or facetious question because, according to news posting on the web a few weeks ago most of the major systems, including the data warehouse, of a well-known Telco company were hacked. This made me wonder: how secure are most data warehouses?In general, when analysts and consultants take about data security the emphasis, or perceived emphasis, seems to be on the operational systems especially...
Does anyone take data security within their warehouse seriously? This is not a trick or facetious question because, according to news posting on the web a few weeks ago most of the major...
Just for being complete and to update people on a minor detail, here is a quick example of a data pump driven External Table.SQL> CREATE TABLE EMP_50 2...
Just for being complete and to update people on a minor detail, here is a quick example of a data pump driven External Table.SQL> CREATE TABLE EMP_50 2 ORGANIZATION EXTERNAL 3 ( TYPE oracle_datapump 4 DEFAULT DIRECTORY dmp_dir 5 LOCATION (‘emp_50.dmp')) 6 ) 7 AS SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 50 8 ;Table CreatedSQL> SELECT COUNT(1) FROM EMP_50; COUNT(1) ---------- 45There are a couple of things here. First of all, you can happily use the wildcards in the select...
Just for being complete and to update people on a minor detail, here is a quick example of a data pump driven External Table.SQL> CREATE TABLE EMP_50 2 ORGANIZATION EXTERNAL 3 ( TYPE oracle_datapump 4...
