SYBASE列式数据库2BCEP.pptVIP

列式数据库+　 CEP= 完美分析系统;议题;Sybase的过去10年股票表现;数据库市场的细分格局;;Sybase ASE;行式数据库市场;列式数据库市场;Sybases (Dublin, CA) IQ Analytics Server was the first of the column-store DBMS systems. It is available as a stand-alone DBMS and as a data warehouse appliance. Sybase also correctly positions Sybase IQ as a performance-capable tool for data marts as well as data warehouses. Strengths Sybase IQ achieves data compression ranging from two to five times compression, depending on the structure of the data. Because analytics typically makes use of fewer columns but larger numbers of rows, Sybase IQ performs very well for analytic applications. The company has been consistently winning POCs with analytic applications, on occasion, with a performance of 100 times greater. This makes Sybase IQ an extremely desirable DBMS platform for an analytic data mart to optimize and enhance an organizations overall data warehouse architecture. Over the past two years, Sybase has increased its Sybase IQ engineering FTEs by more than 70%, as well as its marketing/sales staffing — demonstrating significant commitment. ;列式数据库是革命性的;使用列式数据库;列式数据库 vs. 行式数据库;列式数据库(Columnar Database)潮流;尼尔森媒体研究: 5020亿条数据(2005年全球第一名) -- 15年的收视数据 美国税务局(IRS): 全美国所有报税人7年报税记录(及原始文档) (15亿条记录) 花旗银行: Sybase IQ保存6年所有交易记录，HR数据及文档 联邦快递(FedEx): 全球所有送递品的海关报关单;国内列式数据库用户;Sales Case Studies ;原系统与基于IQ的系统结构对比;Sybase IQ vs 原有系统－－性能;Sybase IQ vs 原有系统－－硬件成本 ;Sybase IQ vs 原有系统－－软件成本 ;;IQ 15.0 新功能;更强的压缩能力IQ FP 索引 ：FP(1)，FP(2)，FP(3);3FP 索引更高的磁盘压缩;查询性能提升;IQ 15.x: 信息生命周期管理: 分级存储;并行多表数据加载;超快 并行分析;;SYBASE IQ: 展望未来;议题;算法交易;从数据中分析规律;;;SYBASE CEP体系结构;持续计算语言 “Continuous Computation Language – CCL”;Window Policies in CCL;Development – Output Control;Development – Output Control;Development – Output Control;金融行业以外的应用;金融行业以外的应用;金融行业以外的应用;积累;