元(11g)的成文看法是数据仓中汇总表格的良好做法吗?
We have DW processes that replace 2 month of data each day. Some time it means few Gigs for each month (~100K rows). On top of them are materialized views that get refreshed after night cycle of data tranfer. My question is would it be better to create aggregated tables instead of the MVs?
我认为,一个合并表格可能是有益的案例是,汇总能够有效地与原子一级数据负荷相结合,最好举例说明。
请允许我说,你通过分治交流,每天把大量数据输入事实表。 利用分门别类变化跟踪进行有素的重新研究将在分级交流期间或之后启动,并将对修改的分部分进行扫描,并对磁带进行改动。
作为表层人口的一部分,你可以与事实表分数交换,你也可以利用CUBE/ROLUP对不同层次的合计数进行计算,并使用多表加装表格,然后可将分级交换成一个或一个以上汇总表。 这不仅可能通过避免重新评估原一级数据而具有内在效率,而且,如果有任何错误,你可以中止对事实表本身的修改,那么在事实表分部分交换之前就计算你的合计数。
其他想法可能稍后发生...... 如果其他人有想法,我就把答案作为社区。
I found in this article, that since ORACLE 10g, there is a way to make a particular connection-session compare strings case-insensitive, without needing any crazy SQL functions, using an ALTER SESSION....
I need remove the quotes from the names of the columns in many tables in my schema. there is any way to automate this process?, any function in oracle or some tool that allows me to change the names ...
We have a CRM solution where all metadata stored in Oracle table (don t ask me why). I am issuing an update statement but when get the data from database I see on front end as part of the text ...
I m getting some strange behaviour from an Oracle instance I m working on. This is 11gR1 on Itanium, no RAC, nothing fancy. Ultimately I m moving data from one Oracle instance to another in a data ...
I have two select statements joined by "union". While executing that statement I ve got: Error report: SQL Error: ORA-01790: expression must have same datatype as corresponding expression 01790. ...
What is the best way to handle connection pooling with Oracle 11g and asp.net, I m having issues where Oracle refuses to open up any new connections for the web app after a while. This causes the ...
I m using Oracle 11g. Also using the spool command to get the output of a query to a file. The problem is that sqlexec is wrapping the characters and making my life miserable. Now under normal ...
Working with Oracle 11g here. I m trying to figure out how to write a specific query against a sample table below: ID TYPE PRIORITY STATUS DATE ----------------------------------------------...
