问题 单项选择题

在为业务繁忙的企业的多个部门服务的数据库系统中,同时开展各部门的OLTP业务和数据分析业务会给数据库系统带来性能冲突,下列方案中无法从根本上解决性能冲突的是______。

A) 抽取出各部门需要的分析数据,建立各部门独立的数据集市,将数据分析业务转移到数据集市中
B) 抽取出企业所有分析功能所需的分析数据,建立统一的企业级数据仓库环境,将企业的大部分分析业务转移到数据仓库环境中
C) 抽取出企业的近期业务数据,建立操作型数据存储(ODS),将一些快速分析业务转移到操作型数据存储中
D) 不建立新的数据存储体系,在基本业务处理时间内开展OLTP业务,在其余时间开展分析业务

答案

参考答案:C

解析: 解决企业联机事务处理业务和数据分析业务之间的性能冲突问题,根本的解决途径是从联机事务处理环境中抽取数据,建立新的数据分析环境,即建立操作型数据存储,将分析业务转移到操作性数据存储中。

填空题
完形填空
完形填空。
     People often fall ill because of me.   1  , they can hardly blame me; it is largely their own   2  . A tired person may get   3  , especially when he goes to crowded places with polluted air. A sudden change in   4   is another factor. In hot summer, people turn on the air-conditioner upon returning home. They will catch a cold easily.
     My latest victim is an energetic student. After school, he played football hard for two hours. Though   5 , he still went to the cinema. Then he got back home and took a cold shower immediately.
     I seized this golden chance to   6   him. He reacted, trying to   7   me, but I was already   8   deep in his throat. He kept sneezing (打喷嚏) and his nose was running.   9  he put on some warm clothes, it didn't work, for there were too many of us. Besides, his sore throat kept  10  him, and he developed a cough to force me and my family out, but  11 .
     The next day he couldn't go to  12 . He had lost his appetite and was not as  13  as before. His mother made him orange juice every few hours for more vitamin C, which would help his  14 .
     For two days he was  15  by his mother. As he rested more, his defense strengthened and I began to feel the  16 , I knew I had to  17  him before long. But I am not the one who gives up easily, and I made every effort to fight back.  18 , it was my turn to feel  19  now, for his defense system was starting an all-out attack against me. I became  20  and finally my time was over.
     Do you know what I am?
( )1. A .Therefore     
( )2. A .business      
( )3. A. punished      
( )4. A. temperature   
( )5. A. excited       
( )6. A. injure        
( )7. A. get on with   
( )8. A. reproducing   
( )9. A. Since         
( )10. A. reminding    
( )11. A. escaped      
( )12. A. bed          
( )13. A. peaceful     
( )14. A .recovery     
( )15. A. protected    
( )16. A. loss         
( )17. A. leave        
( )18. A. Uncertainly  
( )19. A. painful      
( )20. A. bigger       

B. Besides          
B. responsibility   
B. blamed           
B. season           
B. hurt             
B. bother           
B. get rid of       
B. waiting          
B. Once             
B. upsetting        
B. succeeded        
B. work             
B. afraid           
B. development      
B. nursed           
B. operation        
B. catch            
B. Unsuccessfully   
B. disappointed     
B. weaker           

C. However      
C. excuse       
C. caught       
C. place       
C. late       
C. attack     
C. put up with  
C. hiding       
C. Whether    
C. comforting      
C. regretted  
C. school       
C. active       
C. study      
C. scolded      
C. pressure     
C. forget       
C. Unusually    
C. nervous      
C. smaller    
D. Then          
D. fault         
D. killed        
D. condition     
D. tired         
D. destroy       
D .take hold of               
D. disappearing  
D. Although      
D. influencing   
D. failed        
D. hospital      
D. happy         
D. affected      
D. affected      
D. movement      
D. beat          
D. Unfortunately 
D. ashamed       
D. stronger