我集团汇总分析数据达600GB,虽然采用了部分dss分离设计,但远不能满足数据的多向、实时的汇总查询输出。因此想到了升级,从资料上查阅了sybase iq产品,很感兴趣:sybase的iq解决方案即是针对TB级海量数据的专用分析,sybase iq是按列而不是按行存储和访问表数据。决策处理中的很多查询只需要很少量的列数据,因而与传统的RDBMS相比,这种方法在选择满足查询条件的数据时,只须涉及到很少的数据页面。 就下面四个方面, 请用过此类...
--查看dbfile 信息 sp_iqfile --添加一个dbfile alter dbspace iq_main add file newiq_main 'newiq_main.iq' size 75MB reserve 200MB alter dbspace iq_SYSTEM_MAIN add file newiqdemo_main 'newiqdemo_main.iq' size 25MB reserve 200MB alter dbspace iq_SYSTEM_TEMP add file newiqdemo_temp 'newiqdemo.iqtmp' size 13MB reserve 0MB --设置原dbfile 为只读模式 alter dbspace iq_main alter file iq_main READONLY ...
打开iq库中的存储过程,将ase里写好的存储过程拷贝过来,保存,没报错,然后离开这个刚保存的存储过程,不进行其他任何操作。再次打开的时候,里面的程序格式全都错乱,还有些乱码,当然保存的时候也会报错。
This is my first web log chinaunix.net. Firstly, I think I want to say I love Linux. Why? Actually, I don't know clearly. Maybe I can't find a reasonable reason to pursuade to fall in love wich Linux. Like many things, maybe, people always fall in love with something just his or her first sight or first feeling, not reasonabe feeling, maybe the feeling is wrong, maybe it's a mistake impression,...