Free Essay

Star Transformation

In:

Submitted By subratadass
Words 4912
Pages 20
About Cognizant
Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting and business Process outsourcing services. Cognizant’s single-minded passion is to dedicate our global technology and Innovation know-how, our industry expertise and worldwide resources to working together with clients to make their business stronger. With more than 40 global delivery centers and approximately 61,700 employees as of December 31, 2008, we combine onsite/offshore model infused by a distinct culture of customer satisfaction. A member of the NASDAQ-100 Index and S&P 500 Index, Cognizant is a Forbes Global 2000 company and a member of the Fortune 1000 and is ranked among the top information technology companies in Business Week’s Hot Growth and Top 50 Performers listings

Start Today
For more information on how to drive your business results with Cognizant, contact us at inquiry@cognizant.com or visit our website at: www.cognizant.com.

World Headquarters
500 Frank W. Burr Blvd. Teaneck, NJ 07666 USA Phone: +1 201 801 0233 Fax: +1 201 801 0243 Toll Free: +1 888 937 3277 Email: inquiry@cognizant.com

European Headquarters
Haymarket House 28-29 Haymarket London SW1Y 4SP UK Phone: +44 (0) 20 7321 4888 Fax: +44 (0) 20 7321 4890 Email: infouk@cognizant.com

India Operations Headquarters
#5/535, Old Mahabalipuram Road Okkiyam Pettai, Thoraipakkam Chennai, 600 096 India Phone: +91 (0) 44 4209 6000 Fax: +91 (0) 44 4209 6060 Email: inquiryindia@cognizant.com

© Copyright 2009, Cognizant. All rights reserved. No part of this document may be reproduced, stored in a retrieval system, transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the express written permission from Cognizant. The information contained herein is subject to change without notice. All other trademarks mentioned herein are the property of their respective owners.

Contents

Star Transformation in Siebel Analytics(OBIEE)
(Subrata Dass)

Introduction
Star Transformation is a join method mostly used in Data Warehousing Environments to fine tune typical query performance. It is of utmost importance in DB environments where reporting tools like Siebel Analytics (OBIEE) is in use. It can also be used for other tools such as Business Objects. The conventional join mechanisms that the star transformation seeks to supersede are Hash join, nested-loops and sort merge join.

This paper shows how to take full advantage of this RDBMS feature. Another myth it dispels is the fact that implementation of the Star Query is not possible without creating a physical primary key foreign key dependency between the fact and the dimension tables

All the necessary database parameters and other settings required for the set up of this feature have been highlighted in this paper. Parts of this paper which include the understanding of Star Transformation concept have been influenced by the paper Supercharging Star Transformations by Jeff Maresh in particular and various other Oracle resources mentioned in the References section All the results in this paper were produced on Oracle 10.2.0.4 64 Bit
.

Dimension Schema Used
The Schema used in this paper is same as the one shown above. It is a real life schema currently in use in a renowned pharmaceutical company. The following tables have been used to create the scenario described in this paper 1) W_SYNDD_IDS_F_BKP is the fact table that has been used. It mainly contains 3rd party sales data of the various products which are sold by the company. The fact table has 10 years sales data from 2001 – 2010 stored at a monthly granularity level. The table is un-partitioned and has about 3.6 million rows 2) W_PRODUCT_D_STAR is a dimension table used in this scenario. It mainly contains data regarding the various products which are in use by the company. It has been created from the W_PRODUCT_D table using the following statement create table w_product_d_star as select * from W_PRODUCT_D

3)

W_MONTH_D_STAR is the time dimension table. It has time data on a monthly granule for 10 years

4) W_AREA_D_STAR is the dimension table containing the information regarding the various areas in which the company is operating. Since the table has data at a province level granularity for the different states the number of records in this table is huge. Total count of records for this table is 3.6 million.

All the dimension tables have a numeric (Logical) primary key comprised of a sequence-generated number, also known as a surrogate key. The fact table columns include the surrogate key for each of the dimension tables, and a column to hold the measure value. Since one of the main objectives of this paper is to dispel the myth of the presence of primary key and foreign keys as a necessary precondition for Star Transformation such constraints have deliberately not been created. The schema in use here is a bit small by Data warehousing standards where the size of the tablespaces tends to be to the tune of terabytes. However because of the nature of this analysis the goal is to have a median query timing of about 3 seconds, which is considerably lower than the industry average of 30 seconds to 3 minutes for most warehousing environments

Pre Tuning Scenario
Prior to illustrating the benefits of star transformations, it is useful to get a clear picture as to how the Oracle CBO tends to behave in the absence of this feature. In doing so, the reader will gain a greater appreciation of the capabilities of star transformation. Consider the following query run against the above schema.

/* Formatted on 2010/08/16 14:12 (Formatter Plus v4.8.6) */ SELECT SUM (f.s_amt), d1.prod_name, d5.x_ath_position_name FROM w_syndd_ids_f_bkp f, w_product_d_star d1, w_month_d_star d2, w_area_d_star d3, w_position_d_star d5 WHERE f.prod_wid = d1.row_wid AND d1.prod_name = 'Rebif' AND f.month_wid = d2.row_wid AND f.x_ath_country_id = d3.x_ath_country_id AND d3.x_ath_country_id = 'IT' AND d5.x_ath_pos_level_tx = 4 AND d5.x_ath_position_name = '4GRN0000_TADir' AND d2.cal_month = 9 AND d2.cal_year = 2009 AND d5.row_wid = f.x_ath_postn_wid GROUP BY d1.prod_name, d5.x_ath_position_name

The Query will produce a sales report for the total sales of the product named ‘Rebif’ in the country of Italy in September 2009 under the person having the position name '4GRN0000_TADir' and having a position level of 4

Assuming that hash joins have been enabled on the instance, the query will execute according to the following execution plan.

The query follows the following steps . In the first step(Steps 7,8,9) the W_MONTH_D_STAR table is scanned and a hash table is created in the memory of the same . This table is created due to the presence of a limiting condition on the month of September 2009 which fetches a single row. This is then joined to the fact table. This rowset is then joined to the W_POSITION_D (Step 5,6)which has a limiting condition on the x_ath_position_name column .

Further the row set thus obtained is joined to the product dimension(Step 3,5) and finally to the area dimension (Step 2,10). In the final step (Step 1) the group by is done as specified in the query This query does 125041 physical reads and 125174 consistent gets and returns a single row in 23 seconds after grouping by 3960 records. While this is not a bad timings considering the usual 30 seconds SLA for Warehousing environments , we have to keep in mind that the objective of this paper is to reach a median timing of about 3 seconds . Much improvement is required to achive this higher requirement We can have a better understanding of why the query is running ineffiecienly by analysing the join methods it is inherently using. Point to be noted here is that no single limiting condition applied to the fact table produces a small row set. The first join between the Month dimension and the fact table results in a row set containing 1.5 million rows, or 42% of the entire table. Each successive join to a dimension table culls more rows, until the result of 3,960 rows is finally reached. While other indexing strategies, join orders, and join types may be employed in an attempt to improve performance, the fundamental problem is that the query will always be driven by joining a single dimension table to the fact table. This always results in a very large row set that will only be reduced by successive joins.

Star Transformations
The mechanism described below has been quoted from Supercharging Star Transformation by Jeff Maresh . “The star transformation is a join methodology that overcomes this problem by efficiently joining all dimension tables before accessing the fact table. The following steps show how a basic star transformation is performed within the Oracle RDBMS. 1. Build lists of fact table ROWIDs for each dimension table. a. Build a list of dimension table ROWIDs for a dimension based upon the limiting conditions in the query. This is achieved using one of two methods. For small dimensions, the table is scanned. For large dimensions, one or more bitmap indexes are accessed, Boolean operations are performed to arrive at a final unique set of ROWIDs, and the dimension table is accessed accordingly. In the above schema design, the dimension key is the sequence generated primary key. b. Using the dimension keys from step 1a, access the corresponding bitmap index on the fact table. This produces a list of fact table ROWIDs that match a single dimension key. This step is repeated for each value of the dimension key. c. Merge the results from all dimension keys for a particular dimension to produce a unique list of fact table ROWIDs and Boolean indicators. The indicators in the list would logically appear as any of the four columns, D1 through D4, which represent each value of all limiting conditions specified in the query. (Figure 2) d. Repeat steps 1a through 1c for all dimension tables in the query.

2. Perform an AND operation across each row of the lists, again illustrated in Figure 2. Only rows with values of 1 (TRUE) in each of the four dimensions will result in a value of 1 in the result column. Any result column with a value of 0 means that the fact table ROWID in question fails to meet all of the limiting conditions, so it should not be included in the result set. Conversely, a value of 1 indicates that the ROWID meets all of the limiting conditions. 3. Using the fact table ROWIDs from step 2, retrieve the fact table rows. 4. Join back to each dimension using the dimension key from the fact table rows to retrieve any attribute columns requested in the query. The most efficient access and join method will be used for this operation. 5. Perform any aggregation operations on the result set.”

Figure 2- Star Transformation Boolean Operations To make the query take up this execution path the following bitmap indexes are created in the fact and dimension tables -------------------------------------------------------------------------------------------------------------------------create bitmap index pk_f_idx on w_syndd_ids_f_bkp(row_wid); create bitmap index prod_wid_idx_f on w_syndd_ids_f_bkp(prod_wid); create bitmap index month_wid_idx_f on w_syndd_ids_f_bkp(month_wid); create bitmap index x_ath_country_id_idx_f on w_syndd_ids_f_bkp(x_ath_country_id);

create bitmap index x_ath_postn_wid_idx_f on w_syndd_ids_f_bkp(x_ath_postn_wid); create bitmap index row_wid_d1_idx on w_product_d_star(row_wid); create bitmap index row_wid_d2_idx on w_month_d_star(row_wid); create bitmap index row_wid_d3_idx on w_area_d_star(row_wid); create bitmap index row_wid_d5_idx on w_position_d_star(row_wid); --------------------------------------------------------------------

Basically a bitmap index is created on each of the joining keys used in the query , one each in the fact and the dimension table . An extra index is created on the column which is the logical primary key of the fact table . In total for a join of 4 dimension with a single fact based on 4 keys a total of 9 indexes (4 on the dimensions and 5 on the fact) are created . The following are the explain plans obtained based on two value of the star_transformation_enabled  true , temp_disabled
SQL> SELECT 2 FROM 3 4 5 6 7 WHERE 8 AND 9 AND 10 AND 11 AND 12 AND 13 AND 14 AND 15 AND 16 AND 17 GROUP BY

Star_Transformation = True

SUM (f.s_amt), d1.prod_name, d5.x_ath_position_name w_syndd_ids_f_bkp f, w_product_d_star d1, w_month_d_star d2, w_area_d_star d3, w_position_d_star d5 f.prod_wid = d1.row_wid d1.prod_name = 'Rebif' f.month_wid = d2.row_wid f.x_ath_country_id = d3.x_ath_country_id d3.x_ath_country_id = 'IT' x_ath_pos_level_tx = 4 x_ath_position_name = '4GRN0000_TADir' d2.cal_month = 9 cal_year = 2009 d5.row_wid = f.x_ath_postn_wid d1.prod_name, d5.x_ath_position_name;

Elapsed: 00:00:15.03

Execution Plan ---------------------------------------------------------Plan hash value: 449600493 -----------------------------------------------------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -----------------------------------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | 1 | 169 | 16589 (2)| 00:03:20 | | 1 | TEMP TABLE TRANSFORMATION | | | | | | | 2 | LOAD AS SELECT | SYS_TEMP_0FD9D6DDF_1156B922 | | | | | |* 3 | TABLE ACCESS FULL | W_PRODUCT_D_STAR | 22 | 484 | 91 (0)| 00:00:02 | | 4 | HASH GROUP BY | | 1 | 169 | 16498 (2)| 00:03:18 |

|* |* |* |* |* | | | | | | |*

5 6 7 8 9 10 11 12 13 14 15 16

| | | | | | | | | | | |

HASH JOIN | HASH JOIN | HASH JOIN | HASH JOIN | TABLE ACCESS FULL | TABLE ACCESS BY INDEX ROWID | BITMAP CONVERSION TO ROWIDS| BITMAP AND | BITMAP MERGE | BITMAP KEY ITERATION | TABLE ACCESS FULL | BITMAP INDEX RANGE SCAN|

| | | | W_MONTH_D_STAR | W_SYNDD_IDS_F_BKP | | | | | SYS_TEMP_0FD9D6DDF_1156B922 | PROD_WID_IDX_F |

1 1 1 1 1 4

| | | | | | | | | | 1 | |

169 107 85 32 12 80

| 16498 | 119 | 116 | 109 | 4 | 104 | | | | 13 | 2 |

(2)| (2)| (1)| (1)| (0)| (0)| | | | | (0)| |

00:03:18 00:00:02 00:00:02 00:00:02 00:00:01 00:00:02

| | | | | | | | | | 00:00:01 | |

| 17 | BITMAP MERGE | | | | | | | 18 | BITMAP KEY ITERATION | | | | | | |* 19 | TABLE ACCESS FULL | W_MONTH_D_STAR | 1 | 12 | 4 (0)| 00:00:01 | |* 20 | BITMAP INDEX RANGE SCAN| MONTH_WID_IDX_F | | | | | | 21 | BITMAP MERGE | | | | | | | 22 | BITMAP KEY ITERATION | | | | | | |* 23 | TABLE ACCESS FULL | W_POSITION_D_STAR | 2 | 106 | 7 (0)| 00:00:01 | |* 24 | BITMAP INDEX RANGE SCAN| X_ATH_POSTN_WID_IDX_F | | | | | |* 25 | BITMAP INDEX SINGLE VALUE| X_ATH_COUNTRY_ID_IDX_F | | | | | |* 26 | TABLE ACCESS FULL | W_POSITION_D_STAR | 2 | 106 | 7 (0)| 00:00:01 | | 27 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6DDF_1156B922 | 22 | 484 | 2 (0)| 00:00:01 | |* 28 | TABLE ACCESS FULL | W_AREA_D_STAR | 809 | 50158 | 16378 (2)| 00:03:17 | -----------------------------------------------------------------------------------------------------------------Predicate Information (identified by operation id): --------------------------------------------------3 5 6 7 8 9 16 19 20 23 24 25 26 28 filter("D1"."PROD_NAME"='Rebif') access("F"."X_ATH_COUNTRY_ID"="D3"."X_ATH_COUNTRY_ID") access("F"."PROD_WID"="C0") access("D5"."ROW_WID"="F"."X_ATH_POSTN_WID") access("F"."MONTH_WID"="D2"."ROW_WID") filter("CAL_YEAR"=2009 AND "D2"."CAL_MONTH"=9) access("F"."PROD_WID"="C0") filter("CAL_YEAR"=2009 AND "D2"."CAL_MONTH"=9) access("F"."MONTH_WID"="D2"."ROW_WID") filter("X_ATH_POS_LEVEL_TX"=4 AND "X_ATH_POSITION_NAME"='4GRN0000_TADir') access("F"."X_ATH_POSTN_WID"="D5"."ROW_WID") access("F"."X_ATH_COUNTRY_ID"='IT') filter("X_ATH_POS_LEVEL_TX"=4 AND "X_ATH_POSITION_NAME"='4GRN0000_TADir') filter("D3"."X_ATH_COUNTRY_ID"='IT')

Note ----- dynamic sampling used for this statement - star transformation used for this statement

Statistics ---------------------------------------------------------120 recursive calls 11 db block gets 73988 consistent gets 39794 physical reads 1584 redo size 314 bytes sent via SQL*Net to client 239 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 4 sorts (memory) 0 sorts (disk) 1 rows processed

Star Transformation = Temp_disabled
SQL> alter session set star_transformation_enabled=temp_disable; Session altered. Elapsed: 00:00:00.01 SQL> alter session set events 'immediate trace name flush_cache'; Session altered. Elapsed: 00:00:00.92

SQL> SELECT SUM (f.s_amt), d1.prod_name, d5.x_ath_position_name 2 FROM w_syndd_ids_f_bkp f, 3 w_product_d_star d1, 4 w_month_d_star d2, 5 w_area_d_star d3, 6 w_position_d_star d5 7 WHERE f.prod_wid = d1.row_wid 8 AND d1.prod_name = 'Rebif' 9 AND f.month_wid = d2.row_wid 10 AND f.x_ath_country_id = d3.x_ath_country_id 11 AND d3.x_ath_country_id = 'IT' 12 AND x_ath_pos_level_tx = 4 13 AND x_ath_position_name = '4GRN0000_TADir' 14 AND d2.cal_month = 9 15 AND cal_year = 2009 16 AND d5.row_wid = f.x_ath_postn_wid 17 GROUP BY d1.prod_name, d5.x_ath_position_name; Elapsed: 00:00:16.29 Execution Plan ---------------------------------------------------------Plan hash value: 3326886004 -----------------------------------------------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -----------------------------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | 1 | 169 | 16587 (2)| 00:03:20 | | 1 | SORT GROUP BY NOSORT | | 1 | 169 | 16587 (2)| 00:03:20 | |* 2 | HASH JOIN | | 1 | 169 | 16587 (2)| 00:03:20 | |* 3 | HASH JOIN | | 1 | 107 | 208 (1)| 00:00:03 | |* 4 | HASH JOIN | | 1 | 85 | 116 (1)| 00:00:02 | |* 5 | HASH JOIN | | 1 | 32 | 109 (1)| 00:00:02 | |* 6 | TABLE ACCESS FULL | W_MONTH_D_STAR | 1 | 12 | 4 (0)| 00:00:01 | | 7 | TABLE ACCESS BY INDEX ROWID | W_SYNDD_IDS_F_BKP | 4 | 80 | 104 (0)| 00:00:02 | | 8 | BITMAP CONVERSION TO ROWIDS| | | | | | | 9 | BITMAP AND | | | | | | | 10 | BITMAP MERGE | | | | | | | 11 | BITMAP KEY ITERATION | | | | | | |* 12 | TABLE ACCESS FULL | W_PRODUCT_D_STAR | 22 | 484 | 91 (0)| 00:00:02 | |* 13 | BITMAP INDEX RANGE SCAN| PROD_WID_IDX_F | | | | | | 14 | BITMAP MERGE | | | | | | | 15 | BITMAP KEY ITERATION | | | | | | |* 16 | TABLE ACCESS FULL | W_MONTH_D_STAR | 1 | 12 | 4 (0)| 00:00:01 | |* 17 | BITMAP INDEX RANGE SCAN| MONTH_WID_IDX_F | | | | | | 18 | BITMAP MERGE | | | | | | | 19 | BITMAP KEY ITERATION | | | | | | |* 20 | TABLE ACCESS FULL | W_POSITION_D_STAR | 2 | 106 | 7 (0)| 00:00:01 | |* 21 | BITMAP INDEX RANGE SCAN| X_ATH_POSTN_WID_IDX_F | | | | | |* 22 | BITMAP INDEX SINGLE VALUE| X_ATH_COUNTRY_ID_IDX_F | | | | | |* 23 | TABLE ACCESS FULL | W_POSITION_D_STAR | 2 | 106 | 7 (0)| 00:00:01 | |* 24 | TABLE ACCESS FULL | W_PRODUCT_D_STAR | 22 | 484 | 91 (0)| 00:00:02 | |* 25 | TABLE ACCESS FULL | W_AREA_D_STAR | 809 | 50158 | 16378 (2)| 00:03:17 |

-----------------------------------------------------------------------------------------------------------Predicate Information (identified by operation id): --------------------------------------------------2 3 4 5 6 12 13 16 17 access("F"."X_ATH_COUNTRY_ID"="D3"."X_ATH_COUNTRY_ID") access("F"."PROD_WID"="D1"."ROW_WID") access("D5"."ROW_WID"="F"."X_ATH_POSTN_WID") access("F"."MONTH_WID"="D2"."ROW_WID") filter("CAL_YEAR"=2009 AND "D2"."CAL_MONTH"=9) filter("D1"."PROD_NAME"='Rebif') access("F"."PROD_WID"="D1"."ROW_WID") filter("CAL_YEAR"=2009 AND "D2"."CAL_MONTH"=9) access("F"."MONTH_WID"="D2"."ROW_WID")

20 21 22 23 24 25

-

filter("X_ATH_POS_LEVEL_TX"=4 AND "X_ATH_POSITION_NAME"='4GRN0000_TADir') access("F"."X_ATH_POSTN_WID"="D5"."ROW_WID") access("F"."X_ATH_COUNTRY_ID"='IT') filter("X_ATH_POS_LEVEL_TX"=4 AND "X_ATH_POSITION_NAME"='4GRN0000_TADir') filter("D1"."PROD_NAME"='Rebif') filter("D3"."X_ATH_COUNTRY_ID"='IT')

Note ----- dynamic sampling used for this statement - star transformation used for this statement Statistics ---------------------------------------------------------13 recursive calls 0 db block gets 74264 consistent gets 73666 physical reads 0 redo size 331 bytes sent via SQL*Net to client 239 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed

-------------------------------------------------------------------------------------------------------------------The two values are tried out because in a lot of cases in Oracle 10G there are bugs related to the temp table creation which takes place when the value of the parameter star_transformation_enabled is set to true. When the query above executes a star transformation, the following execution plan is taken as a result. Each of the three blocks beginning with step 11 in the second case and step 14 in the first case in the execution plan corresponds to step 1 in the star transformation. Steps 8 and 9 in the first and steps 11 and 12 in the second execution plan correspond to step 2 in the above description, while the second occurrence of step 7 in the second and step 10 in the first execution plan corresponds to step 3 in the description. Step 1 in the execution plan corresponds to step 4 in the above description.

In the above two examples there is an improvement in timing from 23 seconds to about 15 seconds . However even though this timing is good it is still not near enough our goal of 3 seconds

This brings us to our second phase where we create single bitmap indexes on each of the columns in the dimension tables on which a filter condition is applied . The following indexes are created -------------------------------------------------------------------------------------------------------------------------create bitmap index prod_name_d1_idx on w_product_d_star(prod_name); create bitmap index x_ath_country_id_d3_idx on w_area_d_star(x_ath_country_id); create bitmap index x_ath_pos_level_tx_d5_idx on w_position_d_star(x_ath_pos_level_tx); create bitmap index x_ath_position_name_d5_idx on w_position_d_star(x_ath_position_name); create bitmap index cal_year_d2_idx on w_month_d_star(cal_year) ;

create bitmap index cal_month_d2_idx on w_month_d_star(cal_month);

----------------------------------------------------------------------------------------------------------------Now when the query is executed again it executes using the following explain plan
SQL> SELECT SUM (f.s_amt), d1.prod_name, d5.x_ath_position_name 2 FROM w_syndd_ids_f_bkp f, 3 w_product_d_star d1, 4 w_month_d_star d2, 5 w_area_d_star d3, 6 w_position_d_star d5 7 WHERE f.prod_wid = d1.row_wid 8 AND d1.prod_name = 'Rebif' 9 AND f.month_wid = d2.row_wid 10 AND f.x_ath_country_id = d3.x_ath_country_id 11 AND d3.x_ath_country_id = 'IT' 12 AND d5.x_ath_pos_level_tx = 4 13 AND d5.x_ath_position_name = '4GRN0000_TADir' 14 AND d2.cal_month = 9 15 AND d2.cal_year = 2009 16 AND d5.row_wid = f.x_ath_postn_wid 17 GROUP BY d1.prod_name, d5.x_ath_position_name; Elapsed: 00:00:01.07 Execution Plan ---------------------------------------------------------Plan hash value: 2106571917 ---------------------------------------------------------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | 1 | 169 | 32 (10)| 00:00:01 | | 1 | SORT GROUP BY NOSORT | | 1 | 169 | 32 (10)| 00:00:01 | |* 2 | HASH JOIN | | 1 | 169 | 32 (10)| 00:00:01 | |* 3 | HASH JOIN | | 1 | 107 | 31 (10)| 00:00:01 | |* 4 | HASH JOIN | | 1 | 85 | 21 (10)| 00:00:01 | |* 5 | HASH JOIN | | 1 | 32 | 18 (6)| 00:00:01 | | 6 | TABLE ACCESS BY INDEX ROWID | W_MONTH_D_STAR | 1 | 12 | 2 (0)| 00:00:01 | | 7 | BITMAP CONVERSION TO ROWIDS | | | | | | | 8 | BITMAP AND | | | | | | |* 9 | BITMAP INDEX SINGLE VALUE | CAL_YEAR_D2_IDX | | | | | |* 10 | BITMAP INDEX SINGLE VALUE | CAL_MONTH_D2_IDX | | | | | | 11 | TABLE ACCESS BY INDEX ROWID | W_SYNDD_IDS_F_BKP | 4 | 80 | 16 (7)| 00:00:01 | | 12 | BITMAP CONVERSION TO ROWIDS | | | | | | | 13 | BITMAP AND | | | | | | | 14 | BITMAP MERGE | | | | | | | 15 | BITMAP KEY ITERATION | | | | | | |* 16 | VIEW | index$_join$_007 | 22 | 484 | 10 (10)| 00:00:01 |

|* | |* | | |* | | | | | |* |*

17 18 19 20 21 22 23 24 25 26 27 28 29

| | | | | | | | | | | | |

HASH JOIN | BITMAP CONVERSION TO ROWIDS| BITMAP INDEX SINGLE VALUE | BITMAP CONVERSION TO ROWIDS| BITMAP INDEX FULL SCAN | BITMAP INDEX RANGE SCAN | BITMAP MERGE | BITMAP KEY ITERATION | TABLE ACCESS BY INDEX ROWID | BITMAP CONVERSION TO ROWIDS | BITMAP AND | BITMAP INDEX SINGLE VALUE | BITMAP INDEX SINGLE VALUE |

| | PROD_NAME_D1_IDX | | ROW_WID_D1_IDX | PROD_WID_IDX_F | | | W_POSITION_D_STAR | | | X_ATH_POSITION_NAME_D5_IDX | X_ATH_POS_LEVEL_TX_D5_IDX |

| 22 | | 22 | | | | | 2 | | | | |

| 484 | | 484 | | | | | 106 | | | | |

1 8

2

| | (0)| 00:00:01 | | | (0)| 00:00:01 | | | | | | | | | (0)| 00:00:01 | | | | | | | | |

|* 30 | BITMAP INDEX RANGE SCAN | X_ATH_POSTN_WID_IDX_F | | | | | | 31 | BITMAP MERGE | | | | | | | 32 | BITMAP KEY ITERATION | | | | | | | 33 | TABLE ACCESS BY INDEX ROWID | W_MONTH_D_STAR | 1 | 12 | 2 (0)| 00:00:01 | | 34 | BITMAP CONVERSION TO ROWIDS | | | | | | | 35 | BITMAP AND | | | | | | |* 36 | BITMAP INDEX SINGLE VALUE | CAL_YEAR_D2_IDX | | | | | |* 37 | BITMAP INDEX SINGLE VALUE | CAL_MONTH_D2_IDX | | | | | |* 38 | BITMAP INDEX RANGE SCAN | MONTH_WID_IDX_F | | | | | |* 39 | BITMAP INDEX SINGLE VALUE | X_ATH_COUNTRY_ID_IDX_F | | | | | | 40 | TABLE ACCESS BY INDEX ROWID | W_POSITION_D_STAR | 2 | 106 | 2 (0)| 00:00:01 | | 41 | BITMAP CONVERSION TO ROWIDS | | | | | | | 42 | BITMAP AND | | | | | | |* 43 | BITMAP INDEX SINGLE VALUE | X_ATH_POSITION_NAME_D5_IDX | | | | | |* 44 | BITMAP INDEX SINGLE VALUE | X_ATH_POS_LEVEL_TX_D5_IDX | | | | | |* 45 | VIEW | index$_join$_002 | 22 | 484 | 10 (10)| 00:00:01 | |* 46 | HASH JOIN | | | | | | | 47 | BITMAP CONVERSION TO ROWIDS | | 22 | 484 | 1 (0)| 00:00:01 | |* 48 | BITMAP INDEX SINGLE VALUE | PROD_NAME_D1_IDX | | | | | | 49 | BITMAP CONVERSION TO ROWIDS | | 22 | 484 | 8 (0)| 00:00:01 | | 50 | BITMAP INDEX FULL SCAN | ROW_WID_D1_IDX | | | | | | 51 | BITMAP CONVERSION TO ROWIDS | | 264 | 16368 | 1 (0)| 00:00:01 | |* 52 | BITMAP INDEX SINGLE VALUE | X_ATH_COUNTRY_ID_D3_IDX | | | | | ---------------------------------------------------------------------------------------------------------------------Predicate Information (identified by operation id): --------------------------------------------------2 3 4 5 9 10 16 17 19 22 28 29 30 36 37 38 39 43 44 45 46 48 52 access("F"."X_ATH_COUNTRY_ID"="D3"."X_ATH_COUNTRY_ID") access("F"."PROD_WID"="D1"."ROW_WID") access("D5"."ROW_WID"="F"."X_ATH_POSTN_WID") access("F"."MONTH_WID"="D2"."ROW_WID") access("D2"."CAL_YEAR"=2009) access("D2"."CAL_MONTH"=9) filter("D1"."PROD_NAME"='Rebif') access(ROWID=ROWID) access("D1"."PROD_NAME"='Rebif') access("F"."PROD_WID"="D1"."ROW_WID") access("D5"."X_ATH_POSITION_NAME"='4GRN0000_TADir') access("D5"."X_ATH_POS_LEVEL_TX"=4) access("F"."X_ATH_POSTN_WID"="D5"."ROW_WID") access("D2"."CAL_YEAR"=2009) access("D2"."CAL_MONTH"=9) access("F"."MONTH_WID"="D2"."ROW_WID") access("F"."X_ATH_COUNTRY_ID"='IT') access("D5"."X_ATH_POSITION_NAME"='4GRN0000_TADir') access("D5"."X_ATH_POS_LEVEL_TX"=4) filter("D1"."PROD_NAME"='Rebif') access(ROWID=ROWID) access("D1"."PROD_NAME"='Rebif') access("D3"."X_ATH_COUNTRY_ID"='IT')

Note ----- dynamic sampling used for this statement - star transformation used for this statement Statistics ---------------------------------------------------------17 recursive calls 0 db block gets 276 consistent gets

424 0 331 239 2 2 0 1

physical reads redo size bytes sent via SQL*Net to client bytes received via SQL*Net from client SQL*Net roundtrips to/from client sorts (memory) sorts (disk) rows processed

With the presence of indexes on the limiting condition the query timing using star transformation shows a significant improvement . The entire query executes in about 1 second which is 20 fold gain. The logical read comes down from 125041 to 424 and the consistent gets from 125174 to only 276. This gain in performance is due mainly to two reasons A) The reads in the table have been reduced because only those rows in the fact table are accessed which are grouped by in the final result The inefficient procedure of culling rows from the fact table through successive dimension table joins has been eliminated. Unlike the conventional method that joins a single dimension to the fact table, the star transformation effectively joins all of the dimensions to arrive at a unique set of ROWIDs before accessing the fact table. B) The second reason for the improvement is the prevalence of Boolean operations used in the star transformation. These operations are much more efficient than the more resource consuming hash joins used to cull rows in the conventional execution plan. On careful viewing it can be seen that a new feature which comes in this case is that there is an additional Index Join Step which comes in between the different bitmap indexes which was not present in the earlier plans

Basic Requirements for Star Transformation

The following are the basic requirements for a star transformation to be considered by the CBO 1) Value of parameter STAR_TRANSFORMATION_ENEBLED=TRUE/TEMP_DISABLED Setting the value of the parameter to TEMP_DISABLED is used as a way around the various bugs which occur in Oracle due to the creation of temp tables which are created on the fly during the process of transformation. These temp tables are totally transparent to the end user but are however visible in the explain plans as shown in the paper 2) Value of parameter QUERY_REWRITE_ENABLED=TRUE 3) Value of parameter QUERY_REWRITE_INTERITY=TRUSTED

A bitmap index needs to be present on each of the join keys in both the fact and the dimension and the logical primary key in the fact table . The creation of a primary key and foreign key relationship between the fact and dimension is not at all a necessity and is totally avoidable If the creation of a bitmap index is not possible then star transformation is possible even by creation of a normal B-Tree index. In that case there will be a further bitmap transformation from the rowids present in the using the BITMAP CONVERSION FROM ROWIDS event. However this is not discussed in the present paper Proper stats needs to be collected for all the tables which act as participants in a star query . Post 9i the stats needs to be collected using DBMS_STATS. Sometimes even when proper stats are present the presence /absence of histograms prevents the CBO from taking up a star transformation path . In such cases the value of the parameter optimizer_dynamic_sampling needs to be set to a value of 2 and above to facilitate the collection of statistics on the fly so that the CBO can take up star transformation Another general problem that is seen when star transformation is involved is that when a star schema is not implemented properly ( Absence of proper indexes etc) star queries tend to do a lot of Cartesian Merge joins which are similar to the star transformation but tend to take a lot more time. In such cases the parameters “ _optimizer_mjc_enabled” and “_optimizer_cartesian_enabled “ can be set to false . Since these are undocumented parameters, setting these parameters at a DB level can cause a lot of problems . In Siebel Analytics/OBIEE the value of these parameters can be changed using a logon script . However due to a bug in Siebel (Below version 10.1.3.4), the usage of these parameters in a rpd logon script causes Siebel to crash . In such a case a DB level trigger can be used which changes the value of these parameters everytime a SIEBEL user logs in . The script is as below
CREATE OR REPLACE TRIGGER rds_logon_trigger AFTER LOGON ON DATABASE BEGIN IF SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA') IN ('SIEBEL') THEN BEGIN EXECUTE IMMEDIATE 'alter session set "optimizer_mjc_enabled"=false'; EXECUTE IMMEDIATE 'alter session set "optimizer_cartesian_enabled" = FALSE'; END; END IF; EXCEPTION WHEN OTHERS THEN NULL; END;

Summary
The star transformation is a powerful feature for querying dimensional data warehouses. Unlike conventional join methods that can only join two tables at time, the star transformation effectively joins all of the dimension tables to arrive at a composite set of ROWIDs before accessing the fact table. Oracle has enhanced the basic star transformation to greatly improve its performance. It is no longer a necessity to have a physical primary key foreign key relationship between the fact and dimensions for proper Star Query formation. Neither is the presence of bitmap indexes an absolute necessity. The Index join feature also adds on a new dimension to the star transformation feature However several other database parameters still needs to be set and there still exists a whole range of bugs with the value of the parameter star_transformation_enabled=true. Workaround is to set the value to temp_disabled. Proper statistics needs to be collected on the underlying table and the parameter optimizer_dynamic_sampling needs to be set to a proper value to smooth roll any statistical discrepancies. All these features if set properly , the star_transformation provides us a unique and exciting weapon in our arsenal to tune and effectively deal with traditional warehousing queries which usually involves mining through a huge volume of data

Attachments
The following are the attachments which contain the script used to create the tables given in the examples and the spool of the test conditions

Obj105 Obj104

References
Supercharging Star Transformations by Jeff Maresh Supercharging Star Transformation Lewis, Jonathan. 2004. Understanding Bitmap Indexes, www.dbazine.com Lewis, Jonathan. 2004. Bitmap Indexes 2: Star Transformations, www.dbazine.com Oracle 9i Data Warehousing Guide Release 2 (9.2). 1996, 2002. Oracle Corporation Scalzo, Bert. 2003. Oracle DBA Guide to Data Warehousing and Star Schemas. Prentice Hall

Similar Documents

Premium Essay

Business Plan for a Coffee Shop

...Alice Watson BUSINESS ASSIGNMENT A Cup of Books Hypothetical Business Plan A CUP OF BOOKS A CUP OF BOOKS 1. Executive Summary This business plan outlines the main goals and features of A Cup Of Books a second hand as well as new bookstore with a café within. This business plan includes: * Business Goals -Two short term -Two long term * Business idea/description/outlook -Situational analysis -Description of motive * Operational Plan -Inputs - Process Transformation - Outputs - Quality management * Marketing Plan -Target Market identification -Marketing mix * Financial plan -Budget * Human resource plan - Staff number - Staff role -Staff acquisition - Staff training and development - Employment contracts 88 words 2. Goals 2.1 Short-term goals: 2.11 To establish a customer basis in the wider area by receiving a thousand likes on Facebook and 500 followers on Instagram, within 12 months so to establish the brand and product name and create popularity amongst younger generations. 2.12To create goodwill within the local area by creating a regular business rate as part of peoples morning routines via either morning discounts or loyalty coffee cards, so to ensure the businesses reputation is positive and therefore create a good atmosphere in association to the store and returning customers, all within 12 months. 2.2 Long-term goals: 2.21 To become the sole bookstore within 50km radius due to directing the target...

Words: 2014 - Pages: 9

Premium Essay

Operations Management for Mbas 5th Edition

...Operations Management for MBAs Operations Management for MBAs Fifth Edition Jack R. Meredith Scott M. Shafer Wake Forest University VICE PRESIDENT & EXECUTIVE PUBLISHER EXECUTIVE EDITOR PROJECT EDITOR ASSOCIATE DIRECTOR OF MARKETING MARKETING MANAGER MARKETING ASSISTANT PRODUCT DESIGNER MEDIA SPECIALIST SENIOR CONTENT MANAGER SENIOR PRODUCTION EDITOR PHOTO DEPARTMENT MANAGER DESIGN DIRECTOR COVER DESIGNER PRODUCTION MANAGEMENT George Hoffman Lisé Johnson Brian Baker Amy Scholz Kelly Simmons Marissa Carroll Allison Morris Ethan Bernard Lucille Buonocore Anna Melhorn Hillary Newman Harry Nolan Wendy Lai Ingrao Associates This book was set in 10/12 ITC Garamond light by MPS Limited and printed and bound by RRD/Jefferson City. The cover was printed by RRD/Jefferson City. This book is printed on acid free paper. Copyright © 2013, 2010, 2007, 2002, 1999 John Wiley & Sons, Inc. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc. 222 Rosewood Drive, Danvers, MA 01923, website www.copyright.com. Requests to the Publisher for permission should be addressed to...

Words: 67515 - Pages: 271

Free Essay

Stratafin Inc

... The imperatives for transformation were twofold. First, the company wanted to become global and position itself as a best-practice international accounting firm in the African continent. Second, it wanted to achieve race and gender diversity at all levels within the organisation. Ben Adams was appointed to manage the change. Analysis: Key changes that Ben Adams drove: Adams took several key steps like creating a new identity, creating a vision/strategy and communicating it effectively thus getting the buy-in of employees, insuring short-term wins and managing resistance to change in order to support the transformation process. However this paper will focus on two key steps that he took and address if Adams was effective in his leadership of these two areas. 1 Developing a vision/strategy & Effective communication to obtain employee buy-in Adams pursued active management by taking into account employees’ views of the firm. He took a participative approach towards formulating an effective transformation strategy for the firm. Organisation of a conference with a cross-section of employees balanced between race and gender helped solicit recommendations on a transforming strategy and encouraged buy-in from StratAFin staff. There was free-flow of information and the effects of transformation on employees and the firm were discussed. He consolidated all information into one common vision, value system and strategy to ensure unity. A transformation covenant with seven objectives...

Words: 1377 - Pages: 6

Premium Essay

Anz Case Study

...It is generally accepted that the first step in maximising performance and gaining the people advantage is through an organisations culture. Why is this the case? “Culture can be defined as the set of key values, beliefs, understandings and norms shared by members of an organisation” (Kitmann et al., 1986; Smircich, 1983). For a company to maintain an advantage over their competitors they must first look internally to ensure they have effective employees. ANZ recognised just how important this is when they identified the need to make changes to the organisation, “... then we needed to change the hearts and minds of the people inside the organisation” (ANZ Case Study, 2012). Managing corporate culture is important for two reasons, the first reason is that managers are unable to be present for every minute during business hours so culture will shape the way employees work without constant supervision and secondly, maintaining a strong corporate culture influences the employees decision making so they make the best decision for the organisation. The effects of culture are not limited to the internal environment but also the external environment, the culture of the workplace controls the way employees behave amongst themselves as well as with people outside the organization. Because the culture of an organisation is highly visible they facilitate adaptation to the external setting plus integration of internal processes. Negative corporate culture has effects on immediate stakeholder...

Words: 850 - Pages: 4

Free Essay

Transformation Through Self-Control and Assertion

...Metamorphosis is the process in which a caterpillar transforms into a butterfly. The lowly caterpillar wraps itself into an ugly cocoon and over time the miraculous transformation occurs and out of that cocoon emerges this beautiful butterfly. Bill Rago, the main character in the movie Renaissance Man, goes through a similar transformation in his life. Bill is a divorced, passive-aggressive, advertising executive who reaches rock bottom when he loses his job and is forced to seek out unemployment. His unfortunate circumstance lands him a temp job as a civilian teacher on a military base. The problem is that he does not have any teaching experience and he is given a class of eight students who supposedly lack the basic comprehension skills to be successful in the military and are required to pass his class in order to complete basic training. Bill had to learn how to assert himself with this ragtag bunch in order to complete his assignment. According to Randy Paterson, assertiveness is a communication style in which a person realizes that they are in control of their own behavior and decision making (19). Bill, played by actor Danny DeVito, needed to learn that he dictates and controls his life and not other people or life circumstances. In order for him to transform and regain control of his life, Bill had to begin to assert himself in all areas of his life. One thing that portrayed Bill Rago’s lack of assertiveness, was the fact that he minimal self-control at best....

Words: 1058 - Pages: 5

Premium Essay

Business

...10.1 HSC topic: Operations -> is about planning & controlling operations with the aim of minimizing cost, maximizing productivity, improving efficiency and achieving strategic business goals 25% of indicative time The focus of this topic is the strategies for effective operations management in large businesses. | Outcomes The student: H1 critically analyses the role of business in Australia and globally H2 evaluates management strategies in response to changes in internal and external influences H3 discusses the social and ethical responsibilities of management H4 analyses business functions and processes in large and global businesses H5 explains management strategies and their impact on businesses H6 evaluates the effectiveness of management in the performance of businesses H7 plans and conducts investigations into contemporary business issues H8 organises and evaluates information for actual and hypothetical business situations H9 communicates business information, issues and concepts in appropriate formats Content Students learn to: examine contemporary business issues to: discuss the balance between cost and quality in operations strategy examine the impact of globalisation on operations strategy identify the breadth of government policies that affect operations management explain why corporate social responsibility is a key concern in operations management investigate aspects of business using hypothetical situations and...

Words: 1745 - Pages: 7

Premium Essay

Create

...The Design Space of Metamorphic Malware Andrew Walenstein†, Rachit Mathur‡, Mohamed R. Chouchane†, and Arun Lakhotia† University of Louisiana at Lafayette, Lafayette, LA, U.S.A. McAfee Avert Labs, Beaverton, OR, U.S.A. arun@louisiana.edu rachit_mathur@avertlabs.com mohamed@louisiana.edu walenste@ieee.org ‡ † Abstract: A design space is presented for metamorphic malware. Metamorphic malware is the class of malicious self-replicating programs that are able to transform their own code when replicating. The raison d'etre for metamorphism is to evade recognition by malware scanners; the transformations are meant to defeat analysis and decrease the number of constant patterns that may be used for recognition. Unlike prior treatments, the design space is organized according to the malware author's goals, options, and implications of design choice. The advantage of this design space structure is that it highlights forces acting on the malware author, which should help predict future developments in metamorphic engines and thus enable a proactive defence response from the community. In addition, the analysis provides effective nomenclature for classifying and comparing malware and scanners. Keywords: Metamorphic Malware, Virus Scanner. 1. Introduction Metamorphism is the ability of malware to transform its code. This ability was first introduced in viruses and was later used by worms, Trojans, and other malware. There now exist several metamorphic engines—programs that implement...

Words: 5825 - Pages: 24

Premium Essay

Oticon (a) – Case Analysis

...The RIGHTS about the process of transformation of OTICON  In 1987 the firm analysed itself and made a judgment to transform itself for survival.  Decided to select a person from outside organisation to lead who was capable of taking risks, well experienced in different fields and proven track record.  Transformation from a rigid structure to flexible knowledge based company.  Introduction of sense of equality among the employees eliminating the vertical structure.  Creation & implementation of the theme – “think the unthinkable”  Excellent communication regarding transformation and holding a press conference to float the information in turn turning the employees themselves in to ambassadors of the theme or vision that was created.  Initiated the change in employees for the transformation by “empowering” them by providing the necessary support and training and giving them the freedom as to what role they need to play in the transformation.  Integration was effective in organizing employees from different functionalities to form a cross functional team exposing them to different corners of business. The WRONG about the process of transformation of OTICON  The employee retrenchment process could have been done in a better way as it created some amount of fear initially.  The transformation started in a bad way with retrenchment and later on the good things were put into picture...

Words: 253 - Pages: 2

Free Essay

Fsu Essay

...and create an environment inside so when you look through the cut hole on the side of the box, your perspective would shift and the box would seem bigger than it really was. I watched my peers use reflection or miniature things to give the illusion of a larger space, but I took a different approach. I created device through which light changes, shapes transform, the back-, mid- and foreground become one, and the world is not fixed: a kaleidoscope. The evolving patterns and sequences appeal to my vision of nature, my view of myself. I am, like everyone really, a “masterpiece” in the making. I begin as a sketch, or many sketches, and evolve into something greater than the pieces of my origin. No one ends up the way she expects. Like the transformation of the grey clouds into beautiful images, or the constrained box into an expanse of possibilities, I believe it is all about perspective. Our ideas change just like the way we want to execute our “dreams”. So, here I sit, writing an essay for FSU, thinking about perspective and change and the future. Isn’t this what global awareness is about? Recognizing the same in the difference,...

Words: 362 - Pages: 2

Free Essay

Management Consulting

...Client – Getting it Right from the Start 1. Client—getting it right from the start. “The whole consulting process begins and ends with the client,” Cope writes. “And it is imperative you apply sufficient time and energy to understanding the person as well as the problem.” Cope helps the reader consider several aspects of working with clients. At the end of each section, he asks a “back pocket question” that should be considered during a project, such as, “Am I able to view the problem as the client sees it?” All the questions are printed on a Seven Cs “pocket guide” that you can tear out of the book and take with you to assignments. “Trade is a social Act”. • Orientation – Viewing the problem as the Client sees it (including their perception) • Desired Outcome – Bringing clarity of the desired outcome (the real value and not just an end-state) • Change Ladder – Removing the fog from the problem by focusing on where change may be required • Situation Viability – Studying if the issue can be successfully resolved and see if the timing is right for change • Decision Makers – Having a clear picture of the decision makers who can influence the initial stages of contract development • Ethos – Considering if the changes will be coercive or participative in Nature • Contract – Establishing a contract that sets out a framework for action and measurement Clarify – Understanding the Real Issues 2. Clarify—understanding the real issues. Cope quotes Claude Levi-Strauss: “The...

Words: 1256 - Pages: 6

Premium Essay

Strategy Partnership

...on TD transformation planned. The transformation of TD is based on “ARMY 2 10 Plus 10” planned which started in 2004 and will continue until 2020 and beyond. The focus of this transformation planned is strategic transformation on the changes of equipment to cope up with current environment; the changes in threat and technological advancement on military hardware act as driving force for TD transformation. The transformation focuses on training and operational equipment together. However this transformation planned is not definite because of uncertain financial budget. TD could not decide on the equipment early on and must wait for the approve budget. Other than uncertain budget, Army also faces with the problem of underperforming contractors which resulted in delay in delivery and cancellation of project. Issues The transformation planning is not details enough since the type of equipment that going to be change or procure could not be decided earlier due to uncertain financial allocation that will be provided by the government. The loose planning may spell disaster in the process of transformation. The underperforming contractors also raised the eyebrows; where contract had been terminated which cause valuable time and money. Discussion The type of transformation is strategic in nature because the army is modernizing their forces to suit with current environment in order to maintain her competitive edge (Cumming & Worley, 2008, p. 12). This transformation is needed...

Words: 921 - Pages: 4

Free Essay

Health

...among the best hospitals in the United States, according to U.S. News and World Report. To maintain its leadership status, Partners establishes enterprise-wide, CEO-supported corporate initiatives under the banner of “HighPerformance Medicine.” “Ensemble has given us tremendous flexibility with data transformations, and made us much more agile in delivering on this type of integration.” Steve Flammini, CTO One of these initiatives includes electronic medical record (EMR) adoption by all community physician practices in the Partners system. To achieve this goal, Partners offers these physicians full, Webbased access to its internal EMR. But first, Partners must rapidly create interfaces (programs that handle data translation and transmission between systems) to the community physicians’ practice management and scheduling systems, and integrate that data into its EMR. The initiative also gives participating physicians access to more than three terabytes of data in Partners’ clinical data repository (CDR). InterSystems Ensemble® rapid integration platform is a key enabling technology for this initiative. High-performance HL7 messaging and data transformation In this application, Partners uses Ensemble as a hub to integrate and coordinate the flow of patient information between community-based medical practices and the...

Words: 851 - Pages: 4

Free Essay

Re: Light Pollution

...| | Selected Answer: | Helium fusion reaction is the transformation of 3 Helium nuclei into one carbon nucleus. It requires much higher temperatures than hydrogen fusion because it has a greater positive charge (two protons), which requires a strong force to deal with electromagnetic repulsion. | Correct Answer: | The helium fusion reaction is the "triple alpha process". In this process three helium-4 nuclei (the alphas) are converted into one carbon-12 nucleus.The triple alpha process requires higher temperatures than proton fusion because the Coulomb barrier is larger.  | | | | | * Question 2 Needs Grading | | | What happens to a low-mass star after it exhausts its core helium? | | | | | Selected Answer: | The low-mass star dies after exhausting its core helium.  | Correct Answer: | The process of fusing helium creates carbon. Eventually the core will run out of helium, leaving an inert carbon core surrounded by a helium fusing shell (still surrounded by a hydrogen fusing shell). Both shells will contract, creating higher temperatures forcing the star to expand to a double shell-burning giant. The double shell burning will last a few million years or less. The star will never again achieve equilibrium like it had on the main sequence. Instead the star will undergo thermal pulses where the fusion rate increases dramatically every few thousand years.The inert carbon core of a low-mass star will never get hot enough to fuse the carbon. Therefore the...

Words: 771 - Pages: 4

Premium Essay

Constellation Myths

...Stars are huge, radiant spheres of plasma. There are approximately 400 billion stars in the galaxy. They are made out of dust clouds dispersed throughout space. Did you know that stars don’t twinkle? It’s the turbulence in the sky that makes the stars appear like they are blinking. Since the dawn of recorded civilization, stars have been important to us throughout the world. They have been used for navigation, agriculture and even for religious reasons. There are also 58 important stars that are used by aviators and navigators worldwide. Have you ever heard about constellation myths? They are ancient stories about the gods, heroes, and mythological creatures (serpents, dragons etc…) featured in the constellations. Greeks and Romans created the stories for the constellation in the Northern Hemisphere, and for a petty in the Southern Hemisphere that they could sometimes see, near the horizon. Other cultures had their own mythologies for the stars. Some of their stories were part of their religions, helping them to explain everyday events, such as the seasons. These stories usually have a hero, who was given an honorary place in the sky, as either a reward or tribute. One of the very first use of the Constellations was for religion reasons. Ancient people...

Words: 1221 - Pages: 5

Free Essay

Recommendations for Change at Red Star

...Recommendations for Change at Red Star An Analysis of the Haier Group (A) Case As Haier Group looks to Acquire Red Star, Zhang Ruimin must consider the strategy for change that he must implement. While the changes that need to be made may be obvious on the surface, the method he chooses to invoke change is critical to the initiative’s success. Zhang faces an organization that has suffered years of poor management, where no motivation exists throughout the business. Careful consideration of the circumstances at Red Star must be analyzed before employing Theory E, Theory O, or a synthesis of the two. The most effective conclusion to the method of change to be used as Haier Group acquires Red Star is a synthesis between Theories E and O; specifically, a focus on cultural change using a very programmatic plan. To be successful in his change effort at Red Star, Zhang must first consider what has worked well for him in the past. He has been through several campaigns for change while at the helm of Haier Group, originally known as Qingdao General Refrigerator Factory. His first effort started in 1984, on his first day at QGRF. Zhang chose to lead the organization because he saw it as a challenge. The company was suffering from poor quality and increased competition. Zhang saw the potential for a star in the industry and knew he was the right person for the challenge. The changes he made were both structural (Theory E) and cultural (Theory O) in nature. After...

Words: 3293 - Pages: 14