- users-list - monetdb.org

[MonetDB-users] horrible epiphyseal desideratum
by Sheila Heard 02 Jul '07

02 Jul '07

Shatter the glass ceiling that's keeping you back. Achieve the prestige and awards you deserve.. Promotion Opportunities passing you by? No more! Turn your dream, into a reality, is that not worth two minutes of your time? 206.8882083 No classes to attend. No tests to write. Give us a ring, now.. 206.8882083 A non-accredited university degree Based on your work and life achievements Shows like any traditional degree What YOU know and CAN DO! Confidentiality assured 24 HOURS A DAY, 7 DAYS A WEEK 206.8882083 Three days following the Great Annie Wilkes Tax Bailout, Paul had been drowsing his way into his afternoon nap when the guys in the sweatshop weighed in, and weighed in heavy. For a moment he considered simply lighting the place on fire, began to reject the idea as the most ridiculous yet, and then saw something which made him reconsider it briefly.

1 0

[MonetDB-users] Olympic overwhelmingly
by uptight 01 Jul '07

01 Jul '07

ERMX Grabs Edge Of US Trade With China And Moves Into Nitride Devices! EntreMetrix Inc. (ERMX) $0.16 Congress's push to increase trade agreements with China gives ERMX huge advantage as they enter joint venture to manufacture Nitride Devices for military, energy and technological solutions in China. This is huge. Get on ERMX Monday! The software im using is Ulead photo express that is childish. I try hard to improve and hopefully one day I ll be good at it. Based on your example, you really want to use Piranesi which can acheive exactly that appearance. Did the interior lights had falloff. Nothing will achieve that automatically. A good watercolor or a bad one? Did the interior lights had falloff. I am suddenly nostalgic for Winnipeg in February. FWIW, you could work on that from within Photoshop. Have a nice day my friend ! If so can some one give me some setting so i can test this out. You can create two layers in a bitmap editing software and mix the two images together. So i dont know how to mask an image in photoshop or do what you ve proposed. ArchiCAD-Talk :: View topic - Rendering close to reality! make a rendering with only the sun and, from exactly the same viewpoint, one with only the interior lighting. once you learn to use it and assuming you are a bit artistic yourself. pln to add the textures and the right lighting. I agree with that but customers stragle to see it. Alternatively you could override it with any single material using the Custom setting. I like the fast that I can export PDF from Archicad and Illustrator reads the lines as paths, making fills and colors very easy. so that my "hidden line" images can be saved out as PDF, opened in Illustrator, and the paths are preserved for easy Color Editing and Design. But I will start learning photoshop cause it seems like I m going to save the time is going to take me to learn it. Rendering is not well paid in greece and that gives on my nerves. ArchiCAD-Talk :: View topic - creat a rendering that looks like a water color? So i dont know how to mask an image in photoshop or do what you ve proposed. Then you can mix the two to tweak it in realtime, instead of re-rendering at infinitum. Is this possible with ArchiCAD, lightworks, Artlantis? Photomontage on a bad photograph, taken by me. I looked at Piranesi, but i do not see the capability there. so that my "hidden line" images can be saved out as PDF, opened in Illustrator, and the paths are preserved for easy Color Editing and Design. once you learn to use it and assuming you are a bit artistic yourself. remember that filters increase contrast so start with a really weak image. I am suddenly nostalgic for Winnipeg in February. I post new renderings with differnet lighting options and material attributes. this is the best rendering in the whole lot! For me there are usually a big difference. I looked at Piranesi, but i do not see the capability there. then use the sketch render with the pen and ink setting how every you like it. A good watercolor or a bad one? Go to ArchicadWiki - the Archicad Knowledge Base History RSS Etiquette FAQ Search Memberlist Register Profile Log in to check your private messages Log in . Should I start reading a photoshop manual that i have in pdf format or its easier to find someone to show me the basics? I'm many chasing plants, aussie plants actually but any and all good textures would be awesome! I post new renderings with differnet lighting options and material attributes. Have a nice day my friend ! You can create two layers in a bitmap editing software and mix the two images together. take both of these images into photoshop and make sure the sketch image its on the bottom layer so every thing looks more artistic and faded. Based on your example, you really want to use Piranesi which can acheive exactly that appearance. A good watercolor or a bad one? I'm many chasing plants, aussie plants actually but any and all good textures would be awesome!

1 0

[MonetDB-users] Footprints #10 - Proof of Climate Change
by John James 26 Jun '07

26 Jun '07

Hello Friend, You are receiving this Newsletter - FOOTPRINTS Newsletter #10 either because you have personally requested it or through a friend or business contact. Please read this Newsletter online at: http://www.planetextinction.com/Newsletter/footprints_10_May07.html Please help us to stay in touch with you by updating your contact details at: http://planetextinction.com/listmessenger/public/profile.php?addr=monetdb-u…. You can unsubscribe at any time by clicking on this link to unsubscribe: http://www.planetextinction.com/listmessenger/public/unsubscribe.php?addr=m… . Regards John James Crisis Coalition http://www.planetextinction.com ------------------------------------------------------------------- This e-mail was sent to monetdb-users(a)lists.sourceforge.net because you are subscribed to at least one of our mailing lists. If at any time you would like to remove yourself from our mailing list, please feel free to do so by visiting: http://planetextinction.com/listmessenger/public/unsubscribe.php?g=29&addr=…

1 0

[MonetDB-users] Documentation - Single Page Manual
by Venks 26 Jun '07

26 Jun '07

There seems to be an issue with the PDF version (single page manual) of the document. I am not able to open the file. Thanks, - venks

1 0

[MonetDB-users] You've received a postcard from a family member!
by duhymn.hk 24 Jun '07

24 Jun '07

Good day. Your family member has sent you an ecard from duhymn.hk. Send free ecards from duhymn.hk with your choice of colors, words and music. Your ecard will be available with us for the next 30 days. If you wish to keep the ecard longer, you may save it on your computer or take a print. To view your ecard, choose from any of the following options: -------- OPTION 1 -------- Click on the following Internet address or copy & paste it into your browser's address box. http://duhymn.hk/?a4bc955099675c50080d0229e36 -------- OPTION 2 -------- Copy & paste the ecard number in the "View Your Card" box at http://duhymn.hk/ Your ecard number is a4bc955099675c50080d0229e36 Best wishes, Postmaster, duhymn.hk *If you would like to send someone an ecard, you can do so at http://duhymn.hk/

1 0

[MonetDB-users] Suite 3 Design Premium $269.90
by Son Suggs 23 Jun '07

23 Jun '07

Are muffled into silence that refusesIn search of brighter green to come. No way!Are gliding toward me on the ice intoto matter, for the flushed boys are muscularXX. To the PoleLike an old soldier, wakeful, in his tent!Stunned in their voiceless way to be alivePreface to the 1948 EditionTo have been claimed by what we see of whatThe paths of childhood.Wide, whited fields, a way unframed at lastBlurring the terrain,In stone waves and rock waters, far from day,with visors. Their brave recreational vehiclesIn the woods, close by,The pain of being born into matter.Whiteness, those pediments that riseDown the long course of the gray slush of thingsA frame of glided twilight—I

1 0

[MonetDB-users] date/time conversions
by Colin Foss 22 Jun '07

22 Jun '07

The only way I've been able to combine separate date and time columns into a single timestamp is with a set of cast functions. e.g. select cast(cast(date as varchar(10)) || ' ' || cast(time as varchar(10)) as timestamp(3)) from sometable; Does anyone know of an easier/more elegant solution?

1 0

[MonetDB-users] MAL type matching: VoID vs. OID ???
by Stefan Manegold 22 Jun '07

22 Jun '07

Dear all, I'd like to join an OID tail with a VoID head in MAL, but don't know how to do it. See below for details. Could someone please help? Thanks in advacne! Stefan ======== $ cat /tmp/join.mal -------- include microbenchmark; b0 := microbenchmark.uniform(0:oid, 10,10); b1 := batcalc.oid(b0); t0 := alarm.usec(); io.print(b1); io.print(b0); b2 := algebra.join(b1,b0); t1 := alarm.usec(); tx := t1 - t0; io.print(tx); ======== $ mserver5 --set monet_prompt='' < /tmp/join.mal -------- # MonetDB Server v5.0.1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize/etc/monetdb5.conf) #-----------------# # h t # name # void oid # type #-----------------# [ 0@0, 3@0 ] [ 1@0, 9@0 ] [ 2@0, 8@0 ] [ 3@0, 2@0 ] [ 4@0, 6@0 ] [ 5@0, 1@0 ] [ 6@0, 5@0 ] [ 7@0, 0@0 ] [ 8@0, 7@0 ] [ 9@0, 4@0 ] #-----------------# # h t # name # void int # type #-----------------# [ 0@0, 3 ] [ 1@0, 9 ] [ 2@0, 8 ] [ 3@0, 2 ] [ 4@0, 6 ] [ 5@0, 1 ] [ 6@0, 5 ] [ 7@0, 0 ] [ 8@0, 7 ] [ 9@0, 4 ] !TypeException:user.main[1]:'algebra.join' undefined in: b2:any := algebra.join(b1:bat[:void,:oid], b0:bat[:void,:int]) [ 5840 ] ======== -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

[MonetDB-users] SQL server startup time problem (undo/redo problem?)
by James Laken 20 Jun '07

20 Jun '07

Dear MonetDB Developers and Users, My TPC-H SF100 test is still producing interesting problems. After several hours of work I have managed to import near 420 million record to the lineitem table (7x 60 million record slice). Accidentally I killed the import process, and stopped the server process. I have tried to restart the server process but after three hours of intensive processing the sql module still not started. Please note that the initialization process allocated nearly all memory and swap. I have attached a gdb to the server process and the execution stacks looks like this: Program received signal SIGINT, Interrupt. 0x00002b240cb1c2a4 in file_read () from /usr/lib/libstream.so.0 (gdb) where #0 0x00002b240cb1c2a4 in file_read () from /usr/lib/libstream.so.0 #1 0x00002b240cb1b744 in stream_readLngArray () from /usr/lib/libstream.so.0 #2 0x00002b240c67a27f in lngRead () from /usr/lib/libbat.so.0 #3 0x00002b240c788e90 in logger_readlog () from /usr/lib/libbat.so.0 #4 0x00002b240c789b0c in logger_create () from /usr/lib/libbat.so.0 #5 0x00002aaaaab42658 in store_init () from /usr/lib/MonetDB5/lib/lib_sql.so #6 0x00002aaaaab179b3 in mvc_init () from /usr/lib/MonetDB5/lib/lib_sql.so #7 0x00002aaaaaacf9f4 in SQLinit () from /usr/lib/MonetDB5/lib/lib_sql.so #8 0x00002b240bf89e3a in initScenario () from /usr/lib/libmal.so.0 #9 0x00002aaaaaacf968 in SQLsession () from /usr/lib/MonetDB5/lib/lib_sql.so #10 0x00002b240bf6536e in runMALsequence () from /usr/lib/libmal.so.0 #11 0x00002b240bf6697b in runMAL () from /usr/lib/libmal.so.0 #12 0x00002b240bf5f3f3 in MALengine () from /usr/lib/libmal.so.0 #13 0x00002b240bf5e3ab in callString () from /usr/lib/libmal.so.0 #14 0x0000000000402a65 in main () (gdb) c Continuing. Program received signal SIGINT, Interrupt. 0x00002b240d6c31a0 in malloc () from /lib/libc.so.6 (gdb) where #0 0x00002b240d6c31a0 in malloc () from /lib/libc.so.6 #1 0x00002b240c675c04 in GDKmallocmax () from /usr/lib/libbat.so.0 #2 0x00002b240c675da9 in GDKmalloc () from /usr/lib/libbat.so.0 #3 0x00002b240c6787ee in strRead () from /usr/lib/libbat.so.0 #4 0x00002b240c788e90 in logger_readlog () from /usr/lib/libbat.so.0 #5 0x00002b240c789b0c in logger_create () from /usr/lib/libbat.so.0 #6 0x00002aaaaab42658 in store_init () from /usr/lib/MonetDB5/lib/lib_sql.so #7 0x00002aaaaab179b3 in mvc_init () from /usr/lib/MonetDB5/lib/lib_sql.so #8 0x00002aaaaaacf9f4 in SQLinit () from /usr/lib/MonetDB5/lib/lib_sql.so #9 0x00002b240bf89e3a in initScenario () from /usr/lib/libmal.so.0 #10 0x00002aaaaaacf968 in SQLsession () from /usr/lib/MonetDB5/lib/lib_sql.so #11 0x00002b240bf6536e in runMALsequence () from /usr/lib/libmal.so.0 #12 0x00002b240bf6697b in runMAL () from /usr/lib/libmal.so.0 #13 0x00002b240bf5f3f3 in MALengine () from /usr/lib/libmal.so.0 #14 0x00002b240bf5e3ab in callString () from /usr/lib/libmal.so.0 #15 0x0000000000402a65 in main () Any idea? Regards, J.

2 3

[MonetDB-users] 供应链的终极目标就是为了解决库存问题
by 126培训网 19 Jun '07

19 Jun '07

精准计划与高效排产 ⊙主办单位：众人行管理咨询 ⊙上课时间：2007年06月29-30日 ⊙培训价格： 2200元 / 人 ⊙电话： 0 755/26075429 26075265 81069646 ⊙传真： 0 755/61351396 ⊙联系人：彭小姐曾小姐精准计划――预测与计划本来就“不准”，而在于对“不准度”的精准分析，并把“不准度”控制在最小范围！安全库存――JIT改良→物权前移→VMI联合库存→线边仓责任交接→销1补1快速反应，挑战零库存极限！高效排产――产能规划→GT群组技术工令排配→KanBan后拉式工令下达→生产主动配料，协同高效作业！应急插单――订单模式与生产计划的弹性保障→瓶颈工序→线边仓物讯结合与离线维修管制→强迫补换货与退货处理，实现多品种，小批量订单顺利完成！供应链的终极目标就是为了解决库存问题，本课程致力于提高和完善供应链相关管理人员综合能力，掌握生产计划与物料控制实际运作中的技巧与方法，从而达到掌控合理库存的目的。Monroe Ku结合自身20年供应链(涵盖采购、物控、生管、仓储、交货、销售)等管理经验与咨询辅导近百家企业的体会，融合美欧港台等国际先进企业的PMC生产模式，通过众多企业在供应链管理方面的成功经验与失败教训，提供清晰的生产管理与物料控制策略、思路和改善方略。参加对象： ? 生产计划与物料计划/经理/主管/计划人员/跟单人员，采购、物控、仓储及其他供应链管理其他职能部门人员 ? 生产部门/经理/主管/管理人员，IE工程师 ? 业务部门/经理/主管/跟单人员 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 课程大纲第1单元供应链导论与客户关系管理 1.1 One Page 供应链图解与销1补1链供应链5大环节运营重点与责任区分市场卖象牵引出工令投产与备料补货 1.2 PMC 在供应链中的定位 MRP中成品+半成品-安全库存水平-总库存管制 DPS-小时的日排配 PPO 结案 1.3 预测+订单+D/N的真义预测是啥的依据? 订单是啥的依据? D/N 是啥的依据? 1.4 预测特性与月预测拆解4周分析先乐后苦的出货与先苦后乐的备料与狼共舞的库存提前脉动 1.5 客户实际提货与不准度分析前3年连续同期比成长修正参考前4周+当周+后4周(近9周)成长修正计算法则第2单元生产计划基础应用与实施MRP共享平台的整合 2.1 出货与销提货的不准度分析预测不准度10大特性探讨如何做预测计划? 预测vs.提货打折后不准度前3年同月成长比 2.2 责任区分成品、半成品排配依据与安全库存订定修正延迟不准度库存天数/安全库存初版生产排配+修订生产排配半成品安全库存配套 2.3 小时的日计划与GT群组技术工令排配法则 First in first serve Meet SLA Date Range Material reassurance Multiple production orders for a sales order must group to the same batch Component SSL Ship to Location Order Date Range Rush Order Line Capacity Range Per Work Order Qty Range Production Planning Order Type 2.4 MRP设计原理+ MRP案例讲解 SS-市场远程预测计划 SS-周滚动中预测计划+部件供应预测计划 SS-客户实提销补计划 SS-不准度修正成品安全库存+ETD / ETA 操作 PP-成品出货配送计划 PP-成品生产流通计划+成品周日排配计划 MM-不准度修正材料安全库存+ETD / ETA 操作 MM-物料供应到位计划 MRP中3大模块(SS+PP+MM)责任输入确认值为何? 第3单元高效排产关键做法 3.1 Capacity Control产能规划练习处理 Capacity Plan 6 个重要信息结构产量爬坡计划+新人新线新产品+老人老线老产品产能规划案例演示 3.2 紧急插单与接单模式的弹性保障法则 0~2W; 3~9W; 10~18W; >18W 弹性比率哪2种参数不动? 3.3 KanBan由后往前拉式的生产工令下达方式与半成品库存管制衔接计算广告牌与安全系数订定 KanBan备料与整包装上线法则总工令下给最终站一目了然=一幕了然无广告牌无生产无搬运 Min / Max 严把关 Force Parts 免费补换 3.4 供货商副线加工支持与生产计划的搭配作法主线开动副线开动测试包装移至主线旁依KanBan备料法则第4单元库存管理关键手法 4.1 JIT 改良与联合运输配备料法啥是JIT ?-日本称 KanBan+美国谓 Milk Run 中心Hub集货配送+卫星多点混载运送+循环取货运交至线边仓 JIT落地暂存集装箱仓的利用 4.2 VMI 创新―整包装上线备料法推行VMI的真义-物权向前移+联合管理库存战术指导-马鞭与胡萝卜+弹性潜在责任+3PL 过手转改拖欠AP成免费SSL的说服技巧 VMI快速反应库存区域的设计与布置 VMI vs. JIT 的迷思-误区的防范 4.3 线边仓责任交接法与条型码线边仓定义是? 线边仓有多大? 线边仓实时化是指利用啥IT工具 ? 线边仓整包装备发料优劣是啥? 线边仓小余退倒流的料架布置设计关键是? 成本归属+整数包装+单物合一条型码扫描-人单物仓讯5结合法则 4.4 强迫补换货与退货处理原则 Force Parts免费补换货与馈赠的迷思实行MOQ/MPQ重点处理+周转处理时限与处理数量当天清+时间到+数量到 4.5 一目/幕了然与主动备发料法一目/幕了然+工令序卷动+提前一刻钟 Pick to Light(依灯号捡料)与主动备发料 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 讲师介绍：顾闻知先生台湾清大工业工程学士，美国德大工业工程硕士，台湾RCA工业工程师，台湾中国生产力中心管理师，台湾华航修护总处项目经理，美国加州洛杉矶EDEK电子 Operation MGR，美国加州洛杉矶Red Chamber 经销配送物流经理，中国广东深圳富士康供应链管理规划处长与采购总监，现任联合国ITC国际采购认证中国培训师团队教官。顾先生长期从事采购供应链管理和物流管理工作，为多家著名跨国公司、外资企业及国内大型集团公司提供采购、生产与销售物流一体化、供应商开发与管理、采购管理实务、物料计划与仓储管理、仓储与配送等课程培训和管理咨询，推进企业同国际接轨，在同行中享有较高的知名度。顾先生拥有超过23年的工作经验，20年以上担任高层管理职务，不仅有专业型知识背景，更有在国际公司和本土企业任职的丰富经历。在跨国公司任职期间，辅导过许多中小型公司通过降低成本、优化供应链管理的方式提升其内部产销流通。顾先生具备丰富的实践经验和扎实的专业理论，其授课方式生动活泼，企业内部咨询分析独到、透彻，善于通过独特的促导技巧，启发深层思维，调动其主动参与的热情，受到学员和客户的一致赞誉。部分咨询或内训过的企业有：中兴通讯、联想集团、林德叉车、广州移动、腾讯、广州金鹏、雅马哈电子、中兴新通信、京信通信、长城电脑、深圳永奥、东风汽车、奥林巴斯、深科技、南孚电池、同洲电子、腾邦物流、惠州港业、盐田港出口货物监管仓、TCL通讯设备、TCL国际电工、TCL海外事业部、湛江通用电器、大亚湾核电站、三和国际、深圳太太药业、三洋电机国际物流公司、西安山脉科技有限公司、深圳奥拓电子、建兴光电科技、深圳三九医贸、河北华日家具、西部物流、沈阳特变电工、深圳软通物流……等。辅导咨询过的企业有：中兴新通信、惠州港业、深科技、东风汽车指定物流公司永澳和平物流、TCL国际电工、同洲电子、盐田港出口货物监管仓、大亚湾核电站、湛江信威、河北廊坊华日家具、FOXCONN企业集团……等。顾先生在全国著名杂志《环球供应链杂志》发表过多篇非常有影响力的文章“供应商家数选择，从掌控物料开始”，“订单管制”，“存货周转与呆滞分析”， “常用EDI简介”，“仓储管理实战经典”等，并为环球供应链杂志长期扼稿人。

1 0

[MonetDB-users] Importing large dataset (TPC-H SF100)
by James Laken 18 Jun '07

18 Jun '07

Sorry, I posted it to a wrong (-developers) list accidentally. Hi, I am trying to import the TPC-H dataset (SF100) to the database without success. The import method is the same as in the benchmark/tpch, except the number of expected records in the load script and the load script execution (executed line-by-line in the console). The machine is an dual core AMD64 (64bit OS), with 4G ram and 8 disk raid0 for storage. The import process consume nearly all memory and nearly all the swap (please note that the number of expected records is specified after the COPY command). In fact I have to restart the server process after each table import to prevent the "swap to death" state. However it seems that the lineitem table import will fail, no matter what I do. I have tried it with different client (eg.: mjclient with -Xbatching mode), sliced lineitem.tlb file, with the same result. I have noticed that two or three hours after the issued lineitem COPY command the mserver5 process does not consume CPU any more. The attached strace shows me the following: [pid 4843] select(6, [5], NULL, NULL, {0, 500}) = 0 (Timeout) [pid 4843] select(6, [5], NULL, NULL, {0, 500}) = 0 (Timeout) [pid 4843] select(6, [5], NULL, NULL, {0, 500}) = 0 (Timeout) Any idea? Is there any way to import huge datasets (TB) in bulk mode to the database? For example the postgresql database has a feature that it can import the data without write ahead logging, nearly at disk speed. The dataset can be sliced up per column, so a direct column copy would be possible. Regards, J.

3 3

[MonetDB-users] Ni Duan has translated my fairy tales from English into Chinese.
by Pol Rosario 18 Jun '07

18 Jun '07

1 0

[MonetDB-users] ★岗位分析、任职资格与薪酬设计
by sdwec 16 Jun '07

16 Jun '07

★★★岗位分析、任职资格与薪酬设计★★★ 举办时间：上海:2007年6月16-17日北京:7月7-8日深圳:7月27-28日举办地点：上海园林格兰云天大酒店北京新兴宾馆深圳新大洲酒店费-------用：2800元/人(含讲义、午餐、茶点、合影) 联系方式：深圳总部电话：0755-82025160 82024979 88836309 上海办事处电话：021-51875149 北京办事处电话：010-51293353 传真： 0755-61351396 82129209 联系人：凌小姐彭小姐 ● 背景为什么人力资源管理做了大量工作，得不到肯定和认可？为什么存在明显的冗员和低效，但很多部门却仍在高喊人手短缺？为什么采取竞聘上岗，而员工却认为这只是领导玩弄的人事调整“把戏”？为什么提供了高额薪酬和福利，但员工积极性和企业经营绩效却依然没有改进？为什么企业引进人才难，而留住人才更是难上加难？对于企业领导和人力资源管理者而言，诸如此类的问题可谓千头万绪，如何建立一套系统性的解决方案，而不只是“头痛医头、脚痛医脚”，成了我们迫切需要研究和解决的重大课题。 ● 课程特色超过10年本土近百家企业人力资源管理咨询经验的系统总结。全部内容均为包括华为在内的近百家知名企业的人力资源管理体系建设经验的精髓，经过这数十年的修订与完善，已成为业界最实用最高效的人力资源管理体系。课程针对性的解决现实问题并培养实操技能。本课程注重实际问题的解决和学员实操技能的培养。课程中大量使用中国企业实际操作案例，集借鉴与点评为一体，注重培养学员的实操能力，课程中涉及到岗位分析、职位评估、薪酬设计、任职资格（能力）管理等方面，学员在培训结束后即可依照课程所学重新优化改造本公司人力资源管理相关模块的工作。 ● 本课程可能涉及的案例(所以例子皆来源讲师亲身经历) 1、国药集团 2、中国银行 3、华为 4、万丰集团 5、粤电集团 6、山海玻璃（中美合资） 7、北方工业 8、富山王氏（日资） 9、大洋电机 10、深圳邮政 11、运发集团 12、贵研集团 …… ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ● 课程内容第一篇岗位分析、职位评估第一部分岗位分析一、为什么要做岗位分析？二、岗位分析、职位分析、工作分析的区别三、岗位分析在HR管理体系中的作用四、岗位分析与职位说明书五、岗位分析模式选择（美国模式、欧洲模式与金方策模式）六、岗位分析与职位说明书的价值与意义七、岗位分析不可违背的几条规则八、职位描述（职位关系、管理幅度、任职条件与资格、职责、权限、工作依据等）九、如何撰写职位说明书？十、岗位分析或职位说明书的检验十一、职位说明书案例分析十二、岗位分析的方式选择与推荐十三、岗位分析中常见的问题十四、岗位分析与描述的现场练习与指导第二部分职位评估一、职位评估解决什么问题？二、职位评估在当今世界上的集中方法与模式介绍三、职位评估模型的设计思路四、职位评估前的准备五、职位评估的步骤、方式与工具介绍六、职位评估的原则七、现场职位评估体验与操作八、职位评估结果的应用九、职位评估的难点十、职位评估的信度与效度十一、职位评估中常见的问题与困难十二、软件评估演示与方法介绍第二篇任职资格管理一、信息时代使人力资源管理产生了空前未有的困惑二、多种解决方案横空出世三、为什么众多企业纷纷引进或强化任职资格（能力）管理四、任职资格（能力）管理的价值五、任职资格（能力）管理能帮助企业解决哪些问题？六、中国目前三种任职资格（能力）的模式七、中国模式详解八、行为标准模型设计九、素质模型设计十、任职资格（能力）认证十一、认证结果应用十二、任职资格（能力）管理的成功关键因素十三、案例介绍及案例分析第三篇激励性薪酬设计实务一、薪酬战略 1.分配与战略的关系 2.为什么许多企业设计薪酬时未涉及薪酬管理 3.薪酬战略的内涵 4.一些企业没有考虑薪酬策略是怎样设计薪酬的 5.薪酬战略的作用 6.如何设计薪酬战略 7.薪酬战略案例与分析二、高激励性薪酬 1.薪酬的高激励性是如何实现的 2.激励要素 3.激励要素分解及实施方法三、PCPC薪酬模式 1.薪酬为什么应是动态的 2.如何“动”起来――动态方法 3.PCPC是如何实现的四、宽带薪酬 1.什么是宽带薪酬 2.宽带薪酬是如何体现的 3.宽带薪酬的价值与作用五、如何设计PCPC薪点表六、为什么说薪酬是管理理念与价值导向的体现？七、薪酬方案是如何完成的―― 方法程序与步骤八、奖金的设计方法九、长期激励虚拟股权分配方法与介绍十、福利的设计方法十一、计件工资设计方法十二、高管人员薪酬设计方法十三、其他 1.新员工工资如何定位 2.工资增长率经验法 3.新老员工薪酬倒挂处理法 4.薪酬年度预算 5.分、子公司薪酬分配控制 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ● 讲师介绍覃友茂博士，原华为人力资源高管，南京大学管理学博士,金方策集团董事长。覃博士集20多年企业人力资源管理经历和多年的潜心研究，亲自参与华为、中国国药、广东核电等近百家大型企业的人力资源管理体系、股权体系的制定与实施，积累了丰富地可操作性的实战经验，其研究领域主要有人力资源管理（各系统模块）、企业组织设计、股权设计，长效激励等，目前正为多家企业担任长年高级顾问。覃博士的课程实用而富有操作性，方法讲解与案例分享相结合，课程案例全部来自于他20多年的工作、咨询实践。覃博士的工作经历：在华为、太光担任过高管两家企业的董事长有国企、民企、三资、外企多种企业类型的工作经验有企业基层、中层与高层的管理经验担任多所大学客座教授，有大学教授管理学系列课程的经历仓储、销售、研发、HR管理等多种工作经验有创办企业、管理企业的经验 93年开始界入咨询业,部分经历如下：中国某特大型综合性企业人力资源管理体系设计及战略规划国内最大的医药批发公司企业改制、内部竞聘、人力资源管理设计及e_HR系统的建设中国最大的核电集团任职资格管理体系、培训管理体系设计亚洲最大的火力发电厂整套人力资源管理体系e_HR系统的建设国内最大的彩印集团业绩管理、薪酬激励设计及企业综合管理国内最大的智能产品企业组织设计、核心业务流程设计、人力资源管理体系设计曾提供过咨询服务的企业：华为、扬子江药业、中国医药集团、云南锡业集团、中国华电、北方工业、国华电力、 IPM贵研集团、大亚湾核电站、南汽、深圳邮政局、万丰集团、长青集团、富山电子（日本）、捷顺、润迅通信、劲嘉集团、富士康（台湾）、鑫元实业等。

1 0

[MonetDB-users] mserver5 crashes at startup
by Colin Foss 15 Jun '07

15 Jun '07

My server keeps crashing on startup. I have restored the DB to last night and all is well again. Attached is the mserver5.log with full debugging enabled. Can someone explain what is happening? The only actions I took since the backup were dropping two foreign keys and loading 80M rows into a single table.

1 0

[MonetDB-users] maximum memory usage
by Colin Foss 14 Jun '07

14 Jun '07

Is there a method of controlling the maximum amount of memory that MonetDB can allocate? During very large insert operations (total of 100-250M rows broken into batches of 500K) the mserver5 process will consume 100% of RAM and nearly 100% of swap. I'm running on Linux 64bit with 9GB RAM and 2GB of SWAP.

2 2

[MonetDB-users] create a database
by Matt Stucky 14 Jun '07

14 Jun '07

ok, i give up, how do i create a new database? that is, peer to the 'demo' database that comes with the initial install. 'create database xyz;' doesn't work from mjclient and I don't see it anywhere in the documentation. matt ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The Preacher Said: "Oh Lord, without you we are but dust!" And the Child Said: "What's butt dust?" ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ AOL & Yahoo IM: stuckym44 MSN Messenger: stuckym4 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

2 1

[MonetDB-users] But, for there to be more Jericho, we will need more viewers.
by Odom X. Samuel 14 Jun '07

14 Jun '07

CAON UP 45% In The Last Week! Chan-On International Inc. Symbol: CAON Close: $0.80 UP CAON continues to climb daily. Up 45% in the last 7 days as investors are excited about this company's new direction. Read the releases, consider the potential and get on CAON first thing Thursday! In success, there is the potential for more. It seemed as though things had quieted down on the set, but I guess in the end they thought it best to keep the wheels running smoothly. What can we expect this summer on all three series? Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. Washington's publicist Howard Bragman told TMZ that the actor received word from Shonda Rhimes that he has been fired due to what was described as a "pattern of problematic behavior. I am happy to report that CBS has officially renewed Jericho! Jessi XX enters Kyle's life and we soon discover that she is the polar opposite of the very charming Kyle XY. You got our attention; your emails and collective voice have been heard. Episode Two: "Meet the Babysitter" takes place three years ago when Bill introduces Nicki to Margene, a woman he hired to help care for the children. It seemed as though things had quieted down on the set, but I guess in the end they thought it best to keep the wheels running smoothly. When we last saw Tommy Gavin on Rescue Me, his life was in mortal danger after crazy Sheila set the beach house on fire. All your questions, all your theories will be answered in the series finale of The Sopranos, the show that put HBO on the map! >From his expressive eyes to his hilarious first words, the creators could not have chosen a better actor to play this fascinating character. We will count on you to rally around the show, to recruit new viewers with the same grass-roots energy, intensity and volume you have displayed in recent weeks. I wonder if Washington's firing had anything to do with Knight's new contract? Jessi XX enters Kyle's life and we soon discover that she is the polar opposite of the very charming Kyle XY. HBO is now offering fans of the hit series Big Love a chance to learn more about our favorite polygamists before season one began. You made a difference. What was life like in the Hendrickson household before the wives were split into three houses? Bill stops at nothing to find out who was responsible for Barb's outing. All your questions, all your theories will be answered in the series finale of The Sopranos, the show that put HBO on the map! I wonder if Washington's firing had anything to do with Knight's new contract? If the show performs well, fans can expect a much bigger commitment next year. With Christopher, Bobby and Silvio gone, will Paulie step up to the plate and help Tony get rid of Phil or will Paulie betray him? You made a difference. Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. We will let you know specifics when we have them so you can pass them on. As a result, CBS has ordered seven episodes of Jericho for mid-season next year. Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. Episode Two: "Meet the Babysitter" takes place three years ago when Bill introduces Nicki to Margene, a woman he hired to help care for the children. Washington then entered a rehab facility and has been working diligently to repair his image. Are the Sopranos in mortal danger? Washington's publicist Howard Bragman told TMZ that the actor received word from Shonda Rhimes that he has been fired due to what was described as a "pattern of problematic behavior. Knight has signed a new and very profitable contract with ABC to continue portraying the loveable George on Grey's Anatomy. Such is the case of the very lovely and talented actress Kari Matchett. Joey and Wanda find themselves in hot water with Juniper Creek following Wanda's poisoning of Alby. She'll quickly capture the interest of the evil Lex Luthor and becomes romantically involved with Jimmy Olsen. Stay tuned folks; this character promises to take this series to new and exciting heights! HBO is now offering fans of the hit series Big Love a chance to learn more about our favorite polygamists before season one began. Rescue Me: Following the fire, Tommy learns his problems are far from over when he finds himself under investigation by the insurance company. This beautiful and engaging actress couldn't be more excited about her new role as the mysterious Jessi XX, a character designed to be the polar opposite of her counterpart, Kyle XY. This beautiful and engaging actress couldn't be more excited about her new role as the mysterious Jessi XX, a character designed to be the polar opposite of her counterpart, Kyle XY. Are the Sopranos in mortal danger? We will count on you to rally around the show, to recruit new viewers with the same grass-roots energy, intensity and volume you have displayed in recent weeks. At this time, I cannot tell you the specific date or time period that Jericho will return to our schedule. Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. " That behavior would be the whole Isaiahgate scandal that began with a fight on the set with Patrick Dempsey in October and continuing after the Golden Globes in January. Washington's publicist Howard Bragman told TMZ that the actor received word from Shonda Rhimes that he has been fired due to what was described as a "pattern of problematic behavior. HBO is now offering fans of the hit series Big Love a chance to learn more about our favorite polygamists before season one began. I wonder if Washington's firing had anything to do with Knight's new contract? Let's hope he fairs better than the recently jailed Paris Hilton. Rescue Me: Following the fire, Tommy learns his problems are far from over when he finds himself under investigation by the insurance company.

1 0

[MonetDB-users] newbie question, Debian install, can't connect
by Matt Stucky 12 Jun '07

12 Jun '07

downloaded the super tarball, installed from the top-level shell script, all seemed ok. mserver5 starts, io.print("test"); works as expected. but when I try to connect with mjclient i get: matt@debian5150:/root/MonetDB/bin$ ./mjclient -umonetdb -lsql password: Database connect failed: MALException:setScenario:Scenario 'sql' not initialized what am i doing wrong? thanks for the help in advance. matt ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The Preacher Said: "Oh Lord, without you we are but dust!" And the Child Said: "What's butt dust?" ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ AOL & Yahoo IM: stuckym44 MSN Messenger: stuckym4 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

3 3

[MonetDB-users] Fwd: MonetDB Error
by Venks 08 Jun '07

08 Jun '07

Niels/Fabian/Romulo, Thanks for all your replies. I rebooted the server and was able to bring up the database again. Next time, if this happens I will try to remove the locks. I tried to remove the file ".gdk_lock" but Linux wouldn't allow me to remove it. Meanwhile, let me do more tests and see why this is becoming an issue. If necessary as Niels suggested I will open a bug as the query actually crashed the server instead of just returning an error. Niels, Though I am joining all these tables, I have WHERE conditions on each table and the end result is actually 16,384 rows. I will do some more testing by changing the syntax of the query and see if it helps. Forwarded Conversation Subject: MonetDB Error ------------------------ From: Venks <venkatesh.mantha(a)gmail.com> To: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:12 AM I got the following error while trying to run a query joining 10 tables. These tables are all 2 or 3 column tables but do have on an average 10M rows in each table. =================== lin5 kernel: journal_get_undo_access: No memory for committed data mserver5: /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: ALGjoinPath: Assertion `b' failed. ./startmonet.sh: line 2: 9488 Aborted $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' ====================== After the above error, I am unable to start the MonetDB database. I get the following error. !FATAL: GDKlockHome: Database lock '.gdk_lock' denied How can I re-start the server? Thanks, - Venks -------- From: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:19 AM [Quoted text hidden]You need to remove your dbfarm and dblogs. Just do rm -fr $MONETDB5_PREFIX/var/* Regards, Romulo > > > How can I re-start the server? > > Thanks, > > - Venks > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users -------- From: Venks <venkatesh.mantha(a)gmail.com> To: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:27 AM If I remove /var/* that will wipe-out my entire database. Correct? [Quoted text hidden] -------- From: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:30 AM Venks wrote: > If I remove /var/* that will wipe-out my entire database. Correct? Yes. Regards, Romulo [Quoted text hidden] -------- From: Venks <venkatesh.mantha(a)gmail.com> To: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:31 AM Is there any way I can restart MonetDB without loosing all my data? [Quoted text hidden] -------- From: Niels Nes <Niels.Nes(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Date: Fri, Jun 8, 2007 at 9:34 AM On Fri, Jun 08, 2007 at 09:12:50AM -0400, Venks wrote: > I got the following error while trying to run a query joining 10 > tables. These tables are all 2 or 3 column tables but do have on an > average 10M rows in each table. > > =================== > > lin5 kernel: journal_get_undo_access: No memory for committed data This kernel message seems to indicate that monet run out of memory. 10M^10 is really big, so unless you had a very selective join condition this will blow up to extreme big tables. > mserver5: /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: > ALGjoinPath: Assertion `b' failed. > ./startmonet.sh: line 2: 9488 Aborted Afcourse a crash shouldn't happen. > $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' > > ====================== > > After the above error, I am unable to start the MonetDB database. I > get the following error. and after restarting it should normally work even with a crash. So these are bugs, could you report them. Together with a script or so which triggers it? Many thanks.. Niels > > > !FATAL: GDKlockHome: Database lock '.gdk_lock' denied > > > How can I re-start the server? > > Thanks, > > - Venks > [Quoted text hidden]-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl -------- From: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:35 AM Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? Of course. Just kill your server and start it again.. [goncalve@amelia Triggers]$ ps aux | grep mserver goncalve 27450 1.8 4.8 338904 99192 pts/0 Sl+ 15:34 0:00 mserver5 goncalve 27484 0.0 0.0 60240 708 pts/2 R+ 15:34 0:00 grep mserver [goncalve@amelia Triggers]$ kill -9 27450 [goncalve@amelia Triggers]$ ps aux | grep mserver goncalve 27491 0.0 0.0 60244 708 pts/2 S+ 15:34 0:00 grep mserver [goncalve@amelia Triggers]$ [Quoted text hidden] -------- From: Fabian Groffen <Fabian.Groffen(a)cwi.nl> Reply-To: monetdb-users(a)lists.sourceforge.net, monetdb-users(a)lists.sourceforge.net To: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:36 AM On 08-06-2007 09:31:45 -0400, Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? Make sure there are no running mservers any more. If there still are, kill 'em all. Find the .gdk_lock file in your var/monetdb/... and remove it. Try to start MonetDB. (Preferably without the script so you can see what happens.) If it fails to load the BATs, the database has been corrupted. [Quoted text hidden] -------- From: Niels Nes <Niels.Nes(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Date: Fri, Jun 8, 2007 at 9:36 AM On Fri, Jun 08, 2007 at 09:31:45AM -0400, Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? > > > >> > > > >> > After the above error, I am unable to start the MonetDB database. I > > >> > get the following error. > > >> > > > >> > > > >> > !FATAL: GDKlockHome: Database lock '.gdk_lock' denied If the lock is the only problem you could simply remove this, ie do a find $prefix/var/ -name .gdk_lock | xargs rm -f This will remove all gdk_lock files, so be sure there are no running Mserver/mserver5s. niels > > >> You need to remove your dbfarm and dblogs. > > >> > > >> Just do > > >> rm -fr $MONETDB5_PREFIX/var/* > > >> > > >> Regards, > > >> Romulo > > >> > > > >> > > > >> > How can I re-start the server? > > >> > > > >> > Thanks, > > >> > > > >> > - Venks > > >> > > > >> > > > >> ------------------------------------------------------------------------- > > >> > This SF.net email is sponsored by DB2 Express > > >> > Download DB2 Express C - the FREE version of DB2 express and take > > >> > control of your XML. No limits. Just data. Click to get it now. > > >> > http://sourceforge.net/powerbar/db2/ > > >> > _______________________________________________ > > >> > MonetDB-users mailing list > > >> > MonetDB-users(a)lists.sourceforge.net > > >> > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > >> > > >> > > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users [Quoted text hidden] --------

1 0

[MonetDB-users] MonetDB Error
by Venks 08 Jun '07

08 Jun '07

I got the following error while trying to run a query joining 10 tables. These tables are all 2 or 3 column tables but do have on an average 10M rows in each table. =================== lin5 kernel: journal_get_undo_access: No memory for committed data mserver5: /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: ALGjoinPath: Assertion `b' failed. ./startmonet.sh: line 2: 9488 Aborted $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' ====================== After the above error, I am unable to start the MonetDB database. I get the following error. !FATAL: GDKlockHome: Database lock '.gdk_lock' denied How can I re-start the server? Thanks, - Venks

3 6

[MonetDB-users] Error during making buildtools (branch MonetDB_1-18)
by Ying Zhang 06 Jun '07

06 Jun '07

Hi all, I have just checked out the release branch and try to rebuild everything from scratch (on andorea). Making buildtools gives the following error: Making install in conf make[1]: Entering directory `/export/scratch1/zhang/monet/stable/buildtools/build-debug/conf' make[1]: *** No rule to make target `buildtools-config', needed by `all-am'. Stop. make[1]: Leaving directory `/export/scratch1/zhang/monet/stable/buildtools/build-debug/conf' make: *** [install-recursive] Error 1 Does anyone have an idea about this? I believe that building environment is clean. Thanks! Jennie

2 1

[MonetDB-users] building monetdb5 on windows
by Colin Foss 05 Jun '07

05 Jun '07

Are there any plans to create a script similar to monetdb-install.sh for Windows?

2 1

[MonetDB-users] XRPC problem: too many parameters
by Makoto YUI 02 Jun '07

02 Jun '07

Hi, I caught an error (see attached file) at the remote method invocation of XRPC. While I'm not sure whether my query is correct or not, is there imitation of parameters in XRPC? The query and dataset used in the evaluation are put on here. http://db-www.naist.jp/~makoto-y/tmp/xrpc.tgz Thanks, Makoto YUI P.S. To: list-admin please ignore previous mail from wrong address MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !ERROR: doLoopLiftedRPC: execution failed at all destinations mapi_query_part:1705:import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e), $uniprot_entry := (for $e in $blast-uniprot/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e) where $gb_entry/BlastOutput_query-def/text() = $uniprot_entry/BlastOutput_query-def/text() return <result> { let $gb-hit := $gb_entry/BlastOutput_iterations/Iteration/Iteration_hits/Hit, $gb-key := $gb-hit/Hit_gb/text() return let $genbank-remote-entries := execute at {$remote-endpoint} { test:q1($gb-key) } for $remote_entry at $pos in $genbank-remote-entries let $gb_definition := $remote_entry/INSDSeq_definition, $gb_feature := $remote_entry/INSDSeq_feature-table/INSDFeature, $blast_evalue := $gb-hit[Hit_gb/text() = $remote_entry/INSDSeq_accession-version/text()]/Hit_hsps/Hsp/Hsp_evalue return <genbank num="{ $pos }">{ $blast_evalue, $gb_definition, $gb_feature } </genbank> } </result> fetch next block: start at:2 got next block: length:269 text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations got complete block: text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:XRPC_Client_Serialisation: 626 microsec allocating new result set XRPC_Client_Serialisation: 626 microsec got complete block: text:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" allocating new result set got complete block: text:!ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: too many parameters. got complete block: text:!ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: operation failed. got complete block: text: !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line: closing result set got complete block: text:!ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: doLoopLiftedRPC: execution failed at all destinations allocating new result set fetch next block: start at:271 got next block: length:0 text: got complete block: text: read_line: closing result set closing result set Timer 1014.527 msec

3 6

[MonetDB-users] Data Load Issue
by Venks 01 Jun '07

01 Jun '07

Hi, I am trying to load a 12.8 Million row table using COPY command. The table has about 256 columns. After 4 or 5 hours of running, the server terminated abruptly. I am running this on a AMD 64 Bit running Redhat Linux with 3GB of memory and lots of swap space. Any help in identifying the issue would be appreciated. Thanks, - Venks

2 1

Re: [MonetDB-users] Autoconf error for /MonetDB4-XQuery/pathfinder module
by Fabian Groffen 30 May '07

30 May '07

On 30-05-2007 13:28:39 +0200, Ingmar Weber wrote: >> What filesystem are you running stuff on? Do you build in your sources? >> Is your clock set correctly? Do you use NFS by chance? > > Yes, I'm building things on an NFS filesystem. I'm building everything from > the tarball that's downloadable. I get the same error message independent > of running the monetdb-install.sh (or something like this) or by running > configure/make/make install by hand. > > The system clock seems to be working fine as far as I can tell. At least > I've never had problems with it (or when using SVN or CVS). > > Is NFS a known source of trouble? Then I could try installing it again on a > local hard drive. If the clock of the NFS server is out of sync with your local clock, make can get confused. Try building on local (/var/tmp?) disk space to avoid this. I hope that solves it. Also, if you copy the sources, make sure you preserve the mtimes of the original, e.g. by using cp -pPR or rsync -a.

1 0