d**m
发帖数: 50 | 1 Big Finance Company which located in New York City urgently needs 6 Database
Administrators with entry level. This is full time positions. You must be
quick learner. If you are interested in this position, please send your
resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Managem... 阅读全帖 |
|
d**m
发帖数: 50 | 2 Big Finance Company which located in New York City urgently needs 6 Database
Administrators with entry level. This is full time positions. You must be
quick learner. If you are interested in this position, please send your
resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Managem... 阅读全帖 |
|
d**m
发帖数: 50 | 3 Big Finance Company which located in New York City urgently needs another 2
Database Administrators with entry level. This is full time positions. You
must be quick learner. If you are interested in this position, please send
your
resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database... 阅读全帖 |
|
d**m
发帖数: 50 | 4 Big Finance Company which located in New York City urgently needs one
Database Administrators with entry level. This is full time positions. You
must be quick learner. If you are interested in this position, please send
your resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Manag... 阅读全帖 |
|
d**m
发帖数: 50 | 5 Big Finance Company which located in New York City urgently needs three
Database Administrators with entry level. This is full time positions. You
must be quick learner. If you are interested in this position, please send
your resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Man... 阅读全帖 |
|
d**m
发帖数: 50 | 6 Big Finance Company which located in New York City urgently needs 6 Database
Administrators with entry level. This is full time positions. You must be
quick learner. If you are interested in this position, please send your
resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Managem... 阅读全帖 |
|
d**m
发帖数: 50 | 7 Big Finance Company which located in New York City urgently needs another 2
Database Administrators with entry level. This is full time positions. You
must be quick learner. If you are interested in this position, please send
your
resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database... 阅读全帖 |
|
d**m
发帖数: 50 | 8 Big Finance Company which located in New York City urgently needs one
Database Administrators with entry level. This is full time positions. You
must be quick learner. If you are interested in this position, please send
your resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Manag... 阅读全帖 |
|
d**m
发帖数: 50 | 9 Big Finance Company which located in New York City urgently needs three
Database Administrators with entry level. This is full time positions. You
must be quick learner. If you are interested in this position, please send
your resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Man... 阅读全帖 |
|
p********a
发帖数: 5352 | 10 options obs=max;
proc import datafile="C:\SAS Projects\Stock analysis\NYSE_symbols.xls" out=
NYSE dbms=excel2000 replace;
getnames=Yes;
run;
proc import datafile="C:\SAS Projects\Stock analysis\AMEX_symbols.xls" out=
AMEX dbms=excel2000 replace ;
getnames=Yes;
/*guessingrows=20;*/
run;
proc import datafile="C:\SAS Projects\Stock analysis\NASQ_symbols.xls" out=
NASQ dbms=excel2000 replace;
getnames=Yes;
run;
data TICK;
set NASQ(in=a) NYSE(in=b) AMEX(in=c);
if a then Srce="NASQ";
else if b then Sr |
|
s******8
发帖数: 102 | 11 if your SAS is 64bit 9.3, but you MS is 32 bit, you need download 'SAS PC
files server' and install it.
then dbms=exclecs like:
if there is a file ="&outpath.\&outfile..xls then,
proc export data=yourdata
outfile="&outpath.\&outfile..xls" dbms=excelcs replace;
run;
if there is not a file ="&outpath.\&outfile..xls then
proc export data=yourdata
outfile="&outpath.\&outfile..xlsb" dbms=excelcs replace;
run; |
|
d**m
发帖数: 50 | 12 Big Finance Company which located in New York City urgently needs 6 Database
Administrators with entry level. This is full time positions. You must be
quick learner. If you are interested in this position, please send your
resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Managem... 阅读全帖 |
|
d**m
发帖数: 50 | 13 Big Finance Company which located in New York City urgently needs another 2
Database Administrators with entry level. This is full time positions. You
must be quick learner. If you are interested in this position, please send
your
resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database... 阅读全帖 |
|
d**m
发帖数: 50 | 14 Big Finance Company which located in New York City urgently needs one
Database Administrators with entry level. This is full time positions. You
must be quick learner. If you are interested in this position, please send
your resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Manag... 阅读全帖 |
|
d**m
发帖数: 50 | 15 Big Finance Company which located in New York City urgently needs three
Database Administrators with entry level. This is full time positions. You
must be quick learner. If you are interested in this position, please send
your resume in Word format to [email protected]
/* */
Job Description:
Provide assistance and support to higher level staff through database design
and data Integration.
Serve as part of a project team to develop and document data
Consult with Senior Analysts Database Man... 阅读全帖 |
|
w*******y
发帖数: 60932 | 16 Rosewill RNX-N180UB (1T2R) IEEE 802.11b/g/n USB 2.0 Wireless Adapter with
Hardware WPS Button
Up to 300Mbps Download Data Rates
Support 64/128-bit WEP (Hex & ASCII)
WPA/WPA2
WPA (TKIP with IEEE 802.1x)/WPA2(AES with IEEE 802.1x)
$24.99
-$13.00 Instant
$11.99
-$3.60 30% off w/ promo code [COUPON=32756]RWYEAREND[/COUPON], ends 1/6/12
$8.39
http://www.newegg.com/Product/Product.aspx?Item=N82E16833166049
Brand: Rosewill
Model: RNX-N180UBSpec
Standards:IEEE 802.11b/g/n
Wireless Data Rates: Up to 30... 阅读全帖 |
|
t******t
发帖数: 15246 | 17 德新型电动汽车605公里不充电
10月26日，一辆由奥迪A2改装的电动汽车在中途没有充电的情况下从慕尼黑驶到柏
林，605公里的行驶距离给期待电动车的人们带来了极大惊喜。德国联邦经济部长布吕
德勒赞扬这是一次打破世界纪录的事件，是电动汽车的“突破”，并表示“现在要做的
是，将这一‘柏林制造’的伟大业绩打造成一项世界成就”。
电动汽车的跨越式进步
如果仅看电动汽车单次充电行驶里程，德国此次605公里的行驶距离远低于今年5月
日本电动汽车俱乐部实现的单次充电连续行驶1003.18公里的世界纪录。然而，与日本
试验所用的不适于“普通驾驶”的电动汽车不同，此次德国试验的电动车几乎与传统汽
车相差无几，丝毫没有降低车辆的舒适性。四座的车内有空调、音响设备、座椅暖气和
气囊等，后备箱也完全可供使用，一个普通的司机可能都不会注意到该车的改装和布线
。另外，德国试验车行驶过程中最高时速130公里，平均时速90公里，远高于日本试验
车的40公里时速。还值得一提的是，605公里并非该试验车的极限行驶里程，因为到达
柏林的终点后它还有18%的剩余电力。研究者表示，试验车还可以考虑使用不同容量的
电... 阅读全帖 |
|
发帖数: 1 | 18 歷史上的記仇達人勾踐先生一定很羨慕大硬盤先生有個大硬盤，這樣就不會忘記仇家說
了什麼話、貼了什麼圖。
不過光有個大硬盤還不夠，必須有個良好的檢索系統，不然以他儲存了幾萬幾十萬個帖
子的容量，找都找不到！大硬盤，你是用什麼 DBMS 管理你的帖子庫？
以前微軟有個 Access，不知道現在是不是還含在 Office 裡面，還是要另外買？這是
一個本地使用的 Relational DBMS，應該夠用了。自己做一兩個 form，搜尋起來還算
方便。只不過它是本地電腦上的，不能移動。
如果想放在雲端，當然有個免費的 MySQL，只要租個 web hosting sevice，他們多半
會提供 MySQL。有很多前端可以配合使用，例如 HeidiSQL，不過這些前端程式好像
沒有移動版的，只能在電腦上使用。當然，您也可以自己用 PHP 做一個，在自己租的
virtual server 上跑。壞處當然是自己做的東西，功能不如 HeidiSQL 強大，但好
處是手機上也可以用。
嗯，洗碗工才疏學淺，想不出來什麼，我相信一定還要更多的 solution，大家討論一
下，集思廣益幫大硬盤管理他的帖子庫。 |
|
f****e
发帖数: 923 | 19 【 以下文字转载自 biojailbreak 俱乐部 】
发信人: justforonce (submarine), 信区: biojailbreak
标 题: CSMS 毕业，说说选课和找工作的感想
发信站: BBS 未名空间站 (Sun May 15 02:03:18 2016, 美东)
本人背景： 生物博士后，有绿卡，两年前转行读csms， 很快就要毕业了。
上学的感受： 累。 无时无刻不在写作业，没时间泡论坛之类的。 从第一年末尾开始
，开始上一些作业要全身心投入一周的课程（一半的可能是一周的时间也不够）， 真
正的没日没夜。
最重要的事情是找工作，以及为了找工作要选对课程。不要把上学的时间浪费在没用的
课程上面， 就算上没用的课程也不要上那种占用大量时间的。
首先说一下课程：
1. 学校和专业内部的方向。
学校和学校是不一样的，要求不一样。我知道有些学校相同的课程简单很多，有些学校
干脆整个课程安排都是面向编程找工作。即便同一个学校，不同专业的要求也不同。
我们学校出现过统计系的学生来上cs的... 阅读全帖 |
|
n**********e
发帖数: 75 | 20 【 以下文字转载自 Database 讨论区 】
发信人: notencourage (Not Encouraged), 信区: Database
标 题: Senior Database Developer Position for Hedge Fund
发信站: BBS 未名空间站 (Fri Oct 16 11:52:58 2015, 美东)
替朋友发的。有兴趣的请用dice申请
https://www.dice.com/jobs/detail/Senior-Database-Developer-Citadel-L.L.C.-
Chicago-IL-60603/10120369/254107
或发CV给 [email protected]
/* */
Job Description:
Citadel L.L.C., Chicago, IL
Title: Senior Database Developer
Summary:
The Front Office Core Technology Database group works closely with other
F... 阅读全帖 |
|
t*********u
发帖数: 26311 | 21 or you can pay shipping
Antec Smartbean Bluetooth Receiver (Silver)
Free after $15 Rebate
Antec Smartbean Bluetooth Receiver (Black)
Free after $15 Rebate
Antec Smartbean Bluetooth Receiver (Black/White)
Free after $15 Rebate
Antec dBM In-Ear Headphones (Black)
Free after $6 Rebate
Antec dBM In-Ear Headphones (White)
Free after $6 Rebate
Antec Wedge Compact Bluetooth Speaker/Mobile Stand (Black)
Free after $15 Rebate Thanks vksduser
Bluetooth 2.1 Speakers
Free after $15 Rebate |
|
|
f******u
发帖数: 250 | 23 (导入数据)
proc import out=aapl
datafile="C:\Users\aapl.xlsx"
dbms=xlsx replace;
sheet="sheet1";
getnames=yes;
run;
proc import out=spy
datafile="C:\Users \spy.xlsx"
dbms=xlsx replace;
sheet="sheet1";
getnames=yes;
run;
(筛选数据)
data aapl;
set aapl(keep=date adj_close);
label adj_close="Aclose";
rename adj_close=Aclose;
run;
data spy;
set spy(keep=date adj_close);
label adj_close="Sclose";
rename adj_close=Sclose;
run;
(整理数据)
proc sort data=spy;by descending date;run;
proc sort data=aapl;by descendin... 阅读全帖 |
|
h********8
发帖数: 7355 | 24 【 以下文字转载自 LosAngeles 讨论区 】
发信人: zhoudy (sunwind), 信区: LosAngeles
标 题: Job Opportunities
发信站: BBS 未名空间站 (Tue Apr 10 11:42:17 2012, 美东)
听取上次某位同学的提议，这次给出详细的职位介绍。公司在Fontana。
两个职位：
Business Intelligence Engineer
Information Technology – Fontana, CA – Corporate Offices
Position Summary: Seeking a highly experienced technical Data Warehouse
Informatica expert with Microstrategy 9 as a secondary skill to design,
develop and maintain Data Warehouseing solutions using the informatica
PowerCenter Suite ve... 阅读全帖 |
|
n**********e
发帖数: 75 | 25 【 以下文字转载自 Database 讨论区 】
发信人: notencourage (Not Encouraged), 信区: Database
标 题: Senior Database Developer Position for Hedge Fund
发信站: BBS 未名空间站 (Fri Oct 16 11:52:58 2015, 美东)
替朋友发的。有兴趣的请用dice申请
https://www.dice.com/jobs/detail/Senior-Database-Developer-Citadel-L.L.C.-
Chicago-IL-60603/10120369/254107
或发CV给 [email protected]
/* */
Job Description:
Citadel L.L.C., Chicago, IL
Title: Senior Database Developer
Summary:
The Front Office Core Technology Database group works closely with other
F... 阅读全帖 |
|
u******e
发帖数: 758 | 26 首先，写操作系统和写数据库就不是一码事（我也不知道你说的写了数据库是指的DBMS
还是只是应用层的）。学计算机的DBMS是人都写过，以课内程度来说，千行帖顶了。os
的冗余代码要多一些，我自己也写过，但至多写到5000行左右实在坚持不下去了。说“
该有的都有了”并不是说代码都完备了，只是说这个东西作为一个骨架至少在方向上是
全面的，而不是个支离破碎的东西。 |
|
z****y
发帖数: 403 | 27 听取上次某位同学的提议，这次给出详细的职位介绍。公司在Fontana。
两个职位：
Business Intelligence Engineer
Information Technology – Fontana, CA – Corporate Offices
Position Summary: Seeking a highly experienced technical Data Warehouse
Informatica expert with Microstrategy 9 as a secondary skill to design,
develop and maintain Data Warehouseing solutions using the informatica
PowerCenter Suite version 9. MicroStrategy BI Stack and Microsoft SQL Server
DBMS. Additionally, develop and maintain documentation, support month end,
pe... 阅读全帖 |
|
L******k
发帖数: 33825 | 28 PROC IMPORT DATAFILE='C:\Users\best\Desktop\SAS 2\DrugAB.xls' OUT=DrugAB
DBMS=EXCEL REPLACE;
RUN;
PROC IMPORT DATAFILE='C:\Users\best\Desktop\SAS 2\DRUGABinfo.xls' OUT=
DRUGABinfo DBMS=EXCEL REPLACE;
RUN; |
|
L********r
发帖数: 758 | 29 Good article.
Just 1 question. Why the reviewer would not post the ideal reception dbm
data (with no human hand interference)? He said it's because it is ideal
case, and I don't get him. Given it's ideal case, it will definitely prove
or disprove if iphone4 is truly better in terms of antenna design comparing
to other brands or its predecessor, but he did not want to show it in
absolute dbm.
The rest sensitivity improvement on iphone4 only shows that this time they
pick a much better RF-analog/b |
|
c***3
发帖数: 20 | 30 We are looking for a new member for our development team that supports the
Energy Compensation System (ECS) for the Division of Energy Employees
Occupational Illness Compensation (DEEOIC) at the US Department of Labor (
DOL). The position is on site at the DOL facility at 3rd and Constitution
in Washington DC and is conveniently located near the Judiciary Square Metro
station. This is a full time Application SQL Server DBA position.
The selected candidate will perform the following:
•Pro... 阅读全帖 |
|
f*********n
发帖数: 11154 | 31 http://www.tacticalcoordination.com/308-tactical-sniper-rifles.
Model ...................... FN A2 SPR
Item Number ........... 21801
Caliber / Ga. ........... 308 Win
Magazine Capacity ... 4
Barrel Length ........... 24"
Weight .................... 12 lbs. 2 oz.
Operating Principle ... Bolt-action
Magazine Type ......... DBM
Stock / Grip ............. McMillan fiberglass tactical rifle stock A4
The FN A2 SPR features a Pre-'64 Winchester-type action with claw extractor,
Controlled Round Feed (CR... 阅读全帖 |
|
g***r
发帖数: 826 | 32 看下面的小字：
1. Tests performed on commercially available mobile phones on carrier
networks with cellular signal strength between -80 dBm and -90 dBm. Testing
results will vary based on site conditions. |
|
X***n
发帖数: 366 | 33 Wireless router 是 802.11g的。
总是在网上待个十五分钟左右，点任何链接都说没有网络。系统菜单右上角的airport
的信号还是满格，只能Turn off the
airport，等一分钟再turn on，就能用个十五分钟左右，就又不行了。
以下是一些基本信息。
谢谢
Model Name: MacBook
Model Identifier: MacBook4,1
Processor Name: Intel Core 2 Duo
Processor Speed: 2.1 GHz
Number Of Processors: 1
Total Number Of Cores: 2
L2 Cache: 3 MB
Memory: 4 GB
Bus Speed: 800 MHz
Boot ROM Version: MB41.00C1.B00
SMC Version (system): 1.31f1
System Version: Mac OS X 10.6.... 阅读全帖 |
|
i******y
发帖数: 70 | 34 You mentioned Oracle.
As the foundation of databases, both relational model and ER model come from C
S research;
Dynamic-programming query optimization, used by many commerical DBMS such as SQL server, DB2 and Oracle, comes from CS research;
B-tree index and R-tree index, used in every DBMS, comes from CS research; Dat
abase transaction management and concurrency control, applied everyday in bank
s, come from CS research;
Data cube, a model in almost every industrial data mining product, comes f |
|
r*****3
发帖数: 143 | 35 中文名: 数据库系统基础 (第6版)
原名: Fundamentals of Database Systems
作者: Ozsu
Valduriez
Hellerstein
Stonebraker
Halpin
Groppe
Garcia-Molina
Ullman
Widom
Laszewski
Elmasri
Navathe
图书分类: 软件
资源格式: PDF
版本: 文字版
出版社: Springer
书号: 978-1-4419-8833-1
发行时间: 2011年
地区: 美国
语言: 英文
简介:
内容简介：
本书是一本非常适合作研究生数据库教学用的教材。其内容包括了分布式数据库所用的
基本原理、方法、重要的算法介绍及部分系统的实际实现技巧。新版还增加了一些新的
内容如：用整整两章来介绍并行数据库和分布式对象数据库管理系统。
本书具有以下特点：1．内容较为全面，系统地覆盖了分布式数据库的主要方面；2．反
映了目前的一些研究成果如：数据仓库，万维网和数据库，基于推理的技术以及移动
DBMS；3．叙述清楚，容易阅读。
目录:
preface
1 1 ntroduction
1... 阅读全帖 |
|
A***g
发帖数: 158 | 36 发信人: chrs (胖胖), 信区: database
标 题: 数据库知识入门之2.(数据库管理系统简介)
发信站: 西北网络中心兵马俑 BBS 站 (Thu Dec 24 13:59:46 1998)
数据库管理系统（DBMS）是用于描述、管理和维护数据库的程序系统，
是数据库系统的核心组成部分。它建立在操作系统的基础上，对数据
库进行统一的管理和控制。其主要功能有：
1.描述数据库:描述数据库的逻辑结构、存储结构、语义信息和
保密要求等。
2.管理数据库：控制整个数据库系统的运行，控制用户的并发
性访问，检验数据的安 全、保密与完整性，执行数据检索、插入、删除、修改等操作。
3.维护数据库:控制数据库初始数据的装入，记录工作日志，
监视数据库性能，修改更新数据库，重新组织数据库，恢复出现故障的数据库。
4.数据通信 :组织数据的传输。
DBMS主要有四种类型:文件管理系统、层次数据库系统、
网状数据库系统和关系数据库系统。 |
|
s*k
发帖数: 144 | 37
Read classical book of Stevens, you can find
a chapter on dbm programming(or man dbm).
You can use sequential index on nearly
every unix platform.
If you use newer version linux, you also can
use B tree.
Good luck! :-) |
|
ug
发帖数: 1643 | 38
I still don't understand. I am barely new to DB, only learned some stuff
from school, haven't real experience yet.
What do you mean by go back? And how do you instruct the DBMS to do that?
And what is the file orgnization of the table?
Is there any indexes on the table? and what kind of index?
How large is the buffer bool in each DBMS you test?
What is the average size of your row?
Do you test the query alone OR together with other query running concurrently?
Again, the question are for my curi |
|
p******n
发帖数: 874 | 39 I am now working on rewrite some part of mysql DBMS and make it can
recogenize a new datatype (DNA sequence), I have donwload the source
code, but I can not find what I should do. I do not mean user defined
type(UDT) but some datatype imbed in the DBMS. Anyone can help me? I
need know what files I shoud do with and I really want to know the
relationship of the source file. Any hints and advises will be appreciated.
Thanks!!! |
|
w******e
发帖数: 355 | 40 hey! are there any website provides pretty database
fundamental knowledge,
such as: hieratical DBMS & Network DBMS?
3Xs! |
|
w*r
发帖数: 2421 | 41 Iam trying to use pb6.0 to develop a project by using sql server 200
as the dbms server. the problem is that I can connect to the server
but in the application, it cannot. Imean i can use the dba tools by
connect to sql server using sql6.x driver in teh pb, but the application does
not connect, it walways tell me the DBMS is not currently supported
it seems likea compatibility problem. is that mean that I cannot use the
pb6 to develop the program on sql server 2000? |
|
xt
发帖数: 17532 | 42
You call Access a DBMS? If you want a small DBMS, in my
opinion Sybase SQL Anywhere Studio is the best. |
|
r****y
发帖数: 1437 | 43 就现在主流的DBMS，哪儿能找到review这些DBMS的各种技术性质的文章？
中文，英文的都可以，网址，杂志，或者书都行，侧重技术的比较，比如data model,
information integration, etc. 不是那种比哪个在那个操作系统下面好的。
主要对数据库是个门外汉，所以找不到多少有用的线索。谢先。
|
|
s**o
发帖数: 584 | 44 If you are using Oracle, try DBMS Alert or DBMS Scheduler. |
|
y****w
发帖数: 3747 | 45
dbms相关的有listagg, group_concat,xml function, etc.google一下一大堆。
dbms无关的用recursive CTE。现在基本上大家都支持了。 |
|
y****w
发帖数: 3747 | 46 nice。
有些是不可能兼顾的。比如最后一条就经常成为性能杀手。不过对dba script来说，这个就又非常实用，单条性能就是慢上三五秒也不会让我发狂。
大家讨论一下，看看有没有什么更好办法， SUBQUERY放到CTE或者TEMP TABLE里，
--------这个现有的dbms解决的都不太好，多层查询中间结果的join经常会是性能瓶颈
。 我做过些简单的尝试，以函数封装subquery，借助temp table实现indexed CTE。效
果还不错，限制也很多，只能用于比较简单的情况。dbms厂商在sql compiler里加上
index hint要容易的多。 |
|
y****w
发帖数: 3747 | 47 good point. 这个我这几天也在考虑，不过没有做实验验证过。毕竟我不是programmer
,这些也就是，思考思考。
argument:
1. executeBatch是成批将sql语句送到dbms执行，节省反复传送大批sql语句的时间，
是否本地执行就可能有比较大区别。
2. dbms这边这些insert还是单行插入的。数据库寻找slot，插入，logging等cost跑不
了，也很零碎。这是自己组装大型sql语句的考虑。与1相比，假如batch size相同，性
能应该更有优势。
3. 将executeBatch与组装大型sql语句结合。这是我目前最倾向的方案，对于中等规模
的数据。应该能够有不错的性能，关键是够简洁，也可配置。
其他可以加进来的是a) 流水。引进一个provider/consumer模式并不难。 b) 很容易扩
展a支持并发。
对大型数据，还是包装loader合适。
btw,我只是想讨论下这块的实现技术。即便说ssis之类，这些工具把数据倒到内村里也要考虑怎么做，所以就假设你自己在实现一个c或者java版本的ssis好了。
input |
|
y****w
发帖数: 3747 | 48 we don't really have mature process for this, just very basic masking.
what tools suggested with security concern? either dbms is ok. if something
not limited to specified dbms, that would be great. |
|
e**1
发帖数: 452 | 49 agree
OS memory mgmt 完成很大一部分内存和硬盘的换入换出
DBMS底层实现通过系统调用完成一部分，但是如果物理内存上有限制的话， 谁家的
DBMS 都不好用。 |
|
n**********e
发帖数: 75 | 50 替朋友发的。有兴趣的请用dice申请
https://www.dice.com/jobs/detail/Senior-Database-Developer-Citadel-L.L.C.-
Chicago-IL-60603/10120369/254107
或发CV给 [email protected]
/* */
Job Description:
Citadel L.L.C., Chicago, IL
Title: Senior Database Developer
Summary:
The Front Office Core Technology Database group works closely with other
Front Office and Middle Office IT application teams as well as Global
Infrastructure teams to develop high performance and highly available
database systems. Key responsibilit... 阅读全帖 |
|
