Get Red Brick Warehouse! World's best bulk loader, and automatic maintenance of aggregates.
(Is Aggre Gates the name of Bill's next child?)
![Laughing :lol:](./images/smilies/icon_lol.gif)
Moderators: chulett, rschirm, roy
Code: Select all
order_nbr <pk>
order_line_nbr <pk>
customer_key <fk>
product_key <fk>
order_dt_key <fk>
order_ts
transaction_type
qty
price_amt
ext_price_amt
This is EXACTLY why I asked. My understanding of the aggregate is limited to what others have used it as -- an action, not as a concept.kcbland wrote:OLAP is about analyzing volumes of transactions, not individual transactions. Most queries involve rollups of some nature. An aggregate is usually three types. Read this:
http://www.intelligententerprise.com/02 ... e1_1.shtml
Not only does Red Brick automatically maintain its aggregates, it automatically rewrites SQL executed against the base table in order to use the precomputed results stored in the aggregates, where appropriate.Only my solution was more flexible and easier to implement than Red Brick's
ray.wurlod wrote:Not only does Red Brick automatically maintain its aggregates, it automatically rewrites SQL executed against the base table in order to use the precomputed results stored in the aggregates, where appropriate.Only my solution was more flexible and easier to implement than Red Brick's![]()
Bet your "solution" doesn't do this!
marc_brown98 wrote:Peter,
Fine work. I also agree query re-write should be enabled at the DB level, let it figure out what tables to use to resolve the query instead of the developer or front end tool, that requires synchronization of some technical meta-data. I actually believe redbrick's value proposal has little to do with agg. awareness and more to do with manageability & performance. Years ago when I was doing exclusive RBW work, I had a chance to see an independent bake off of load performance between all of the heavyweigt DBMS's. RedBrick stomped all of them and they did it with 1 redbrick person there in 3 days vs. an army of dbms vendor people there for weeks. Just my take. The technology has changed since then.
Ray, I'm interested - Do you have a site with performance stats on the bulk load? I'd like to compare it to Sybase IQ bulk loading.ray.wurlod wrote: Get Red Brick Warehouse! World's best bulk loader, and automatic maintenance of aggregates.