f*******1
发帖数: 59 | 1 做一下广告：一家以省政府牵头，有30亿启动资金的民营银行要在上海建立科技和业务
中心。银行以互联网为主，做支付，借贷，理财，境内外转账,etc。
诚征拥有海外多年互联网金融工作及学习的背景，熟悉海内外互联网金融发展趋势，具
有创新理念，致力于归国投生于科技金融事业的人士
公司氛围将秉承创业精神，股权激励，以技术团队为主，占到60%或以上。公司主管将
于四月中旬来美现场招聘。
有意者或者有认识的朋友感兴趣 请与[email protected]/* */联系， 谢谢
招聘岗位：
业务类
资产管理产品设计
工作职责：
1、负责资产项目的引入、流程设计、机构、产品及项目准入、协议签署、除外部渠道
产品引入以外的商务谈判等工作；
2、协助配合持续期管理室和综合财务室与业务的相关工作；
3、牵头完善资管产品部资产引入的有关制度、办法、流程；
工作要求：
1、国外重点院校本科及以上金融相关学历；
2、有资产管理产品设计相关经验5年以上，了解市场客户需求和市场产品动态，具有产
品创新精神；
3、有较强的沟通能力和执行力，有高度的责任心和团队协作精神，能承受较强的工作
压力；
4、热爱移动... 阅读全帖 |
|
x****y
发帖数: 252 | 2 感兴趣。
可以介绍一下你们的背景吗？
I am a senior software engineer, focusing on back-end, and have hands-on
experience on UI and database. I also worked on web application, data
warehousing/ETL/OLAP application, and security application.
Thanks,
Rui |
|
s******a
发帖数: 12 | 3 Title:
Microsoft SQL Server Database Engineer
Skills:
Microsoft SQL Server 2005, SQL Server 2008, 2008 R2, Database designer,
Business Intelligence, BI 2.0, Analysis Services, Integration Services, Data
modelling, Database Administrator
Description:
Exciting opportunity to join an early-stage well funded technology startup
in the NYC area founded by a very successful and visionary management team.
We are looking to hire stellar technology professionals to join us in
developing a cutting edge per... 阅读全帖 |
|
m****l
发帖数: 61 | 4 公司有一些新的opening,如果需要我可帮忙refer。
这里是旧贴:
http://www.mitbbs.com/article_t/JobMarket/31185381.html
Primary test responsibilities:
1. Write test specs, test cases and test automation in your project to
meet the release requirements.
2. Write testing code to certify the component you own in your project.
3. Work closely with PM and development through the project cycle.
4. automation framework design and development
5.
Primary Dev responsibilities:
1. Write dev specs... 阅读全帖 |
|
h****n
发帖数: 298 | 5 关键字: Datawarehouse (DW),SQL,BI
发信站: BBS 未名空间站 (Thu Jun 9 12:27:52 2011, 美东)
3+ years of Data Warehouse (DW) solution experience including strong SQL
skills
2+ years BI testing experience, including an understanding of the business
requirements
Detailed Data warehouse development knowledge including experience writing
complex T-SQL and ETLs
Broad OLAP Experience including writing MDX queries
Demonstrated proficiency in an object oriented programming (C, C++, Java, or
preferably, C#)
Please email... 阅读全帖 |
|
h****n
发帖数: 298 | 6 Role Requirements
The candidate must have:
• Hands on advanced coding experience with T-SQL and C#
• Experience with Excel, OLAP, SSIS and SSRS
• Ability to extract and analyze large data sets
• Previous experience in Microsoft’s Online business (Bing, MSN,
Ad Center) is preferred
• Prior knowledge and hands-on experience with proprietary
Microsoft tools such as Cosmos / SCOPE is preferred
• Ability to work independently, when needed, collabo... 阅读全帖 |
|
h****n
发帖数: 298 | 7 Title: Reporting business analyst
Skills required: Excel, OLAP, SQL
Duration: 1 year
Location: Redmond, WA
More detials please contact me via h*******[email protected] |
|
m**********t
发帖数: 385 | 8 PRINCIPAL ACCOUNTABILITIES
• Play an active role in the project team by contributing creative
ideas aimed at designing and developing healthcare IT solutions (e.g. CDS,
EMR, Tele-medicine systems, etc.) for hospitals to help enhance their
efficiency and the quality of their healthcare service.
• Design and implement solutions, in collaboration with hospitals.
• Test your solutions in a hospital setting.
• Be up-to-date, and understand, existing literature in ... 阅读全帖 |
|
m**********t
发帖数: 385 | 9 PRINCIPAL ACCOUNTABILITIES
• Play an active role in the project team by contributing creative
ideas aimed at designing and developing healthcare IT solutions (e.g. CDS,
EMR, Tele-medicine systems, etc.) for hospitals to help enhance their
efficiency and the quality of their healthcare service.
• Design and implement solutions, in collaboration with hospitals.
• Test your solutions in a hospital setting.
• Be up-to-date, and understand, existing literature in ... 阅读全帖 |
|
h****n
发帖数: 298 | 10 Location: Kirkland, WA (Kirkland town center)
Position requirements
* Bachelor's degree or equivalent experience
* 3-6 years of experience in data analysis and reporting
* Superior quantitative, analytic, logical reasoning skills. Working
familiarity with statistics and statistical concepts
* Familiarity with Microsoft query and analysis tools and databases
including proficiency in transact SQL
* Experience managing design, development, and improvement of
... 阅读全帖 |
|
发帖数: 1 | 11 Marin Software 2006年在美国硅谷成立，总部在旧金山，目前全球有500多名员工。
Marin成立于2006年，总部位于美国旧金山。Marin以软件即服务 (SaaS) 的形式为
Ctrip，Dell，Gap，Fossil、Macy’s，Razorfish, Salesforce, 等全球顶级品牌和机
构提供强大的在线广告应用程序。广告主们可以通过Marin利用百度、谷歌、Facebook
、Twitter、Bing与其他世界知名的搜索引擎、社交网络及展示广告网络对其营销活动
进行管理。上述在线业务的运营模式与奇虎、QQ空间和新浪微博基本相同，在欧美地区
广受追捧，广告主们均获得了良好的收益。
办公地点：坐落于繁华的南京西路，公司大楼对面就是美食广场，周边美食云集，15-
30元人民币可以吃的不错。
办公设备：公司使用的都是最新的Macbook， 基本都是顶配
办公休闲：桌面足球，瑜伽垫，瑜伽球，飞镖盘，桌游，每月举办生日会，不定期的团
队活动，轰趴，出游等。
办公时间：弹性工作，基本不加班
科技实力：敏捷开发流程，2周一个Sprint，4周交付一次。遵循最佳运行模式。M... 阅读全帖 |
|
|
发帖数: 1 | 13 你想在北美留学期间获得Coop/Intern的机会么？想进入高薪High Tech行业，而苦于没
有实战经验么？你想拿到项目的实战经验，并提升你所掌握的BI和Big Data的技术和技
能么？ 快来加入BI+Big Data+CRM项目实践吧！
斯坦福IT是北美第一家以求职为导向的专业IT培训学校。导师均为IT领域的顶级专家和
学者，都曾在大公司做管理和技术工作，有着广泛的IT人脉。导师层就职的公司包括微
软，IBM,Oracle,Amazon,Facebook等。学员毕业后全部进入银行，政府，IT顾问公司等
领域，成为IT高薪专才
IT公司BI，大数据及CRM真实项目实践，真实项目交付经验
• 公司网站：http://www.followmedoit.com
• Youtube Channel(斯坦福IT的技术讲座，课堂及求职辅导视频—）：https
://www.youtube.com/channel/UCXT1lD9WEUAEO4KNSZFVniw
• 成功求职同学们（BI， CRM)经验分享（视频）：https://www.... 阅读全帖 |
|
发帖数: 1 | 14 你想在北美留学期间获得Coop/Intern的机会么？想进入高薪High Tech行业，而苦于没
有实战经验么？你想拿到项目的实战经验，并提升你所掌握的BI和Big Data的技术和技
能么？ 快来加入BI+Big Data+CRM项目实践吧！
斯坦福IT是北美第一家以求职为导向的专业IT培训学校。导师均为IT领域的顶级专家和
学者，都曾在大公司做管理和技术工作，有着广泛的IT人脉。导师层就职的公司包括微
软，IBM,Oracle,Amazon,Facebook等。学员毕业后全部进入银行，政府，IT顾问公司等
领域，成为IT高薪专才
IT公司BI，大数据及CRM真实项目实践，真实项目交付经验
• 公司网站：http://www.followmedoit.com
• Youtube Channel(斯坦福IT的技术讲座，课堂及求职辅导视频—）：https
://www.youtube.com/channel/UCXT1lD9WEUAEO4KNSZFVniw
• 成功求职同学们（BI， CRM)经验分享（视频）：https://www.... 阅读全帖 |
|
b*****t
发帖数: 1276 | 15 sounds like a data analysist in a Pharma company. "Cube" is an OLAP term. |
|
s*******m
发帖数: 51 | 16 如果我给的早, 我挺不到现在的.
今天早上, 我把我的SQL code 给了K, 因为他今天换了理由, 说我们的OLAP Cube 出
故障,一个重要的计算完成不了. 我替他补过两个洞, 今天,想想,算了, 把 code 给他
了. 两个小时后, 我被裁掉.
他就是个liar, 过河拆桥的人. 我早就知道. |
|
n****l
发帖数: 115 | 17 【 以下文字转载自 LosAngeles 讨论区 】
发信人: nofeel (女儿的眼中有最美的闪亮), 信区: LosAngeles
标 题: Job Opening
发信站: BBS 未名空间站 (Mon Dec 6 13:55:44 2010, 美东)
My group has 2 openings now. If you are interested, please send your resume
to h****[email protected].
My group deals a lot with database, data warehousing, data process, analysis
and reporting etc. Strong SQL skills and some programming in C#, Excel VBA
are required. Experience in data modeling and OLAP (such as MS Analysis
Service) are also very desirable. Prior experi... 阅读全帖 |
|
L*******s
发帖数: 138 | 18 【 以下文字转载自 JobHunting 讨论区 】
发信人: Livernois (Livernois), 信区: JobHunting
标 题: [Job Opening]新放出多个职位
发信站: BBS 未名空间站 (Fri Aug 3 09:49:56 2012, 美东)
最近又有多个长期职位放出，公司帮办H1b，绿卡。
大家有兴趣可以站内投条联系了解详情
1. Sr. Microstrategy Developer/Architect
2. Mainframe Developer
3. SQL DBA
1.
Job Title: Sr. Microstrategy Developer/Architect
Location: Los Angeles, CA
* Participate in requirements analysis and story boarding sessions with
business users
* Prototype BI solutions and assess their "fit-for-use"
* Develop an... 阅读全帖 |
|
n****l
发帖数: 115 | 19 My group has 2 openings now. If you are interested, please send your resume
to h****[email protected].
My group deals a lot with database, data warehousing, data process, analysis
and reporting etc. Strong SQL skills and some programming in C#, Excel VBA
are required. Experience in data modeling and OLAP (such as MS Analysis
Service) are also very desirable. Prior experience in fixed income area is a
plus, but not required.
Business Intelligence Analyst
US-CA-Calabasas
Description
Responsible for inde... 阅读全帖 |
|
s****g
发帖数: 329 | 20 洛杉矶的一个Start-up要招一个Data Analyst，公司在Santa Monica，现在不是很确信
办不办H1-B和绿卡。比较prefer是洛杉矶周围的。Founder是业内很有名的人，已经办
成至少两个公司。Co-founder是好莱坞明星。有兴趣可以站内联系我。要求如下：
• BA/BS Degree in Math, Computer Science, Economics, etc.
; Master is a plus.
• large database & data warehouse experience - i.e. SQL,
OLAP cubes, Data Warehouse, etc.
• Background structuring databases and using SQL to extract relevant
data to deduce answers to real world questions & issues
• Wri... 阅读全帖 |
|
s****g
发帖数: 329 | 21 洛杉矶的一个Start-up要招一个Data Analyst，公司在Santa Monica，现在不是很确信
办不办H1-B和绿卡。比较prefer是洛杉矶周围的。Founder是业内很有名的人，已经办
成至少两个公司。Co-founder是好莱坞明星。有兴趣可以站内联系我。要求如下：
• BA/BS Degree in Math, Computer Science, Economics, etc.
; Master is a plus.
• large database & data warehouse experience - i.e. SQL,
OLAP cubes, Data Warehouse, etc.
• Background structuring databases and using SQL to extract relevant
data to deduce answers to real world questions & issues
• Wri... 阅读全帖 |
|
j******3
发帖数: 18319 | 22 【 以下文字转载自 Seattle 讨论区 】
发信人: PenanceX (You can come with me), 信区: Seattle
标 题: 三年前天涯上关于软软，傻气牙内幕的文章
发信站: BBS 未名空间站 (Wed Feb 5 21:52:08 2014, 美东)
微软内部, 各部门争风吃醋, 争权夺利, 互相下黑手, 那是平常事了. 跟当年蒋军人人
自保, 看友军被围, 不仅不救, 反而抚掌大笑, 是惊人的类似.
而微软投敌者甚重. 高级将领投敌更是屡屡发生. GOOGLE的语音识别, 从无到有, 从有
到领先, 总共不到两年, 如果没有微软的叛将, 那根本就连做梦也别想.
（2）
人说, IBM的今天, 是微软的明天; 微软的今天, 是古狗的明天; 古狗的今天, 是
FACEBOOK的明天.
IBM, 微软, 古狗和脸书, 是四代IT公司的代表. 前三者都经历了从无到有, 从小到大,
都有过辉煌的时刻. 而脸书, 则是当下最火爆的公司.
现在校园的童谣是这样说的,
顶尖学校的顶尖学生, 去脸书;
顶尖学校的二流学生, 去古狗或苹果;
顶尖学校的三流学生或者... 阅读全帖 |
|
m*******u
发帖数: 26 | 23 【 以下文字转载自 JobHunting 讨论区 】
发信人: maomaoniu (Lufi), 信区: JobHunting
标 题: 【招聘】淘宝网 - DB Architect, Sr. DB Engineer, Sr. DBA - 地点：杭州、北京
发信站: BBS 未名空间站 (Mon Apr 19 03:47:16 2010, 美东)
职位：DB Architect，Sr database engineer，Sr. DBA
地点：北京、杭州
依托淘宝这个大平台,拥有国内团队规模最大,节点数最多,业务挑战最大,技术能力最强
,较高知名度和国内影响力的团队. 这个团队目前承载着业务最核心的OLTP系统的99.99
%可用性要求,以及最高计算压力的OLAP的计算平台的运维.
淘宝DBA 团队目前拥有31人的规模, 分为系统DBA,开发DBA,DB架构&工具小组,都为高可
用,高可扩展,低成本的目标努力! 目前我们拥有oracle,mysql,PostGsql,以及部分
nosql的平台运维,总数近千台.
如果你,
精通Oracle或mysql或pgsql或nosql的一种; |
|
d*****y
发帖数: 81 | 24 【 以下文字转载自 JobHunting 讨论区 】
发信人: dumbboy (Winners Never Quit.), 信区: JobHunting
标 题: Huawei USA (Santa Clara) is hiring Big Data Solutions Architects
发信站: BBS 未名空间站 (Wed Jun 6 13:13:44 2012, 美东)
Big Data Solution Architects will be responsible for guiding the full
lifecycle of a Hadoop solution, including requirements analysis, platform
selection, technical architecture design, application design and development
, testing, and deployment. We are looking for candidates with a broad set
of techno... 阅读全帖 |
|
d**u
发帖数: 240 | 25 大胖球：微软之走向死亡
（1）
微软现在内交外困, 大厦将倾, 摇摇欲坠. 但万足之虫, 死而未僵, 再撑个几年还不成
问题, 甚至其中昙花一现, 回光反照也有可能. 借句股市里的话, 目前抵抗力最小的方
向是向下.
微软目前如同一盘肥肉, 旧敌(IBM, ORACLE)未除, 新敌来势凶猛, 都贪婪地欲吞微软
为快.
如果打一比方, 微软与GOOGLE之战, 好比国军对共军的内战. 目前大概是国军被迫从全
面进攻转向重点进攻的1947年初. 虽然, 还有拿下延安的大捷在后, 微软已经天时地利
人和全无, 已经是必败之势.
微软内部, 各部门争风吃醋, 争权夺利, 互相下黑手, 那是平常事了. 跟当年蒋军人人
自保, 看友军被围, 不仅不救, 反而抚掌大笑, 是惊人的类似.
而微软投敌者甚重. 高级将领投敌更是屡屡发生. GOOGLE的语音识别, 从无到有, 从有
到领先, 总共不到两年, 如果没有微软的叛将, 那根本就连做梦也别想.
（2）
人说, IBM的今天, 是微软的明天; 微软的今天, 是古狗的明天; 古狗的今天, 是
FACEBOOK的明天.
IBM, 微软, 古狗和脸书,... 阅读全帖 |
|
h****n
发帖数: 298 | 26 Required Experience:
• 8+ years extensive experience in data warehouses with deep
understanding of dimensional modeling, star and snowflake Schemas, fact and
dimension Table
• Wide ranging hands on experience in data warehousing implementation;
ETL processes, OLTP, OLAP, data mart, transformations, data mining and
reporting-
• Extensive experience in Data warehouse, ETL- Extraction/
Transformation/Loading, E-LT -Extraction/Load/Transformation Data Analysis,
Data migration on MS... 阅读全帖 |
|
h****n
发帖数: 298 | 27 Title: Reporting business analyst
Skills required: Excel, OLAP, SQL
Duration: 1 year
Location: Redmond, WA
More detials please contact me via h*******[email protected] |
|
h****n
发帖数: 298 | 28 Title: Reporting business analyst
Skills required: Excel, OLAP, SQL (They are looking for someone who is
excellent in Pivot table.)
Duration: 1 year
Location: Redmond, WA
Please contact me via h*******[email protected]
Thanks! |
|
P******X
发帖数: 482 | 29 微软内部, 各部门争风吃醋, 争权夺利, 互相下黑手, 那是平常事了. 跟当年蒋军人人
自保, 看友军被围, 不仅不救, 反而抚掌大笑, 是惊人的类似.
而微软投敌者甚重. 高级将领投敌更是屡屡发生. GOOGLE的语音识别, 从无到有, 从有
到领先, 总共不到两年, 如果没有微软的叛将, 那根本就连做梦也别想.
（2）
人说, IBM的今天, 是微软的明天; 微软的今天, 是古狗的明天; 古狗的今天, 是
FACEBOOK的明天.
IBM, 微软, 古狗和脸书, 是四代IT公司的代表. 前三者都经历了从无到有, 从小到大,
都有过辉煌的时刻. 而脸书, 则是当下最火爆的公司.
现在校园的童谣是这样说的,
顶尖学校的顶尖学生, 去脸书;
顶尖学校的二流学生, 去古狗或苹果;
顶尖学校的三流学生或者是二流学校的顶尖学生, 去YAHOO或AMAZON;
YAHOO或AMAZON不要的学生, 去微软;
被以上公司辞退准备退休的人, 去IBM.
梨叔说过, 21世纪, 最重要的财富是人才. 人才的流动方向, 正代表了公司的走势
. 微软挖不到人才, 留不住人才, 已经到了震耳欲聋的地步了.
... 阅读全帖 |
|
|
发帖数: 1 | 31 斯坦福IT是北美第一家以求职为导向的专业IT培训学校。导师均为IT领域的顶级专家和
学者，都曾在大公司做管理和技术工作，有着广泛的IT人脉。导师层就职的公司包括微
软，IBM,Oracle,Amazon,Facebook等。学员毕业后全部进入银行，政府，IT顾问公司等
领域，成为IT高薪专才
IT公司BI，大数据及CRM真实项目实践，真实项目交付经验
• 公司网站：http://www.followmedoit.com
• Youtube Channel(斯坦福IT的技术讲座，课堂及求职辅导视频—）：https
://www.youtube.com/channel/UCXT1lD9WEUAEO4KNSZFVniw
• 成功求职同学们（BI， CRM)经验分享（视频）：https://www.youtube.
com/watch?v=udmyKIzHyzU
Dynamics CRM（Customer Relationship Management）， 客户关系管理系统, 这是一
套集销售管理、市场管理、服务管理、敏捷市场反应以及客户商... 阅读全帖 |
|
B******1
发帖数: 9094 | 32 Your company does not have a capable BI architect to oversee the whole
operation. That is the problem and may be the very reason for a Chinese
professional to venture into this market.
Reporting is only a small piece of the whole pie. Forecasting, budgeting,
and drill-down analysis of identified business or operational problems
should be the main draw of using the BI system. Automation of many labor-
intensive jobs might be an added bonus.
Again, the tools are set. But the operator (could be ... 阅读全帖 |
|
g********0
发帖数: 15010 | 33 One intermediate level .Net developer - Washington, DC.
Experienced in Microsoft Technology (DotNET especially ASP.net, SQL Server
2005/2008, SQLServer OLAP Services, Office 2007).
Good experience in rapid systems development and an ability to communicate
clearly and effectively.
Should have experience working with jquery modules.
Good knowledge of time series data manipulation, array processing, external
facing website design including session management, dissemination of large
data over web, m... 阅读全帖 |
|
r***e
发帖数: 10135 | 34 传统DBMS要维护ACID，要保证query response time，主要负责OLTP
data warehouse一般不是提供实时的transaction service，主要为complex query服务
，支持OLAP
数据也不是一股脑导进去的，要经过ETL
teradata主要通过hash存储大数据，但是贵的要死
不像狗家mapreduce开源可以免费用，所以一下子就流行了
当然，搞物理/气象的超算估计很多都是自己搭的架构谁也不用 |
|
a****a
发帖数: 21 | 35 The data will accumulate to 800G per year.
The JBOSS is a application server which is very similar to Websphere from IBM
or Weblogic from BEA.but the JBOSS is open source with better tech support.
The application is a work flow tracking system for small business used in LAN
internally, however, this will allow about 100 users or more to login out our
system, upload files from anywhere out of our LAN system.In addition, the
system serves as a portal to a OLAP system too. the potential bottleneck |
|
g*****u
发帖数: 298 | 36 在Implementing Data Cubes （Venky Harinarayan， Anand Rajaraman，Jeffery
Ullman,
Stanford University）这篇文章中，提到对于OLAP cube lattice，给定常数k,如何选
择k个节点view，以minimize the total query cost。说这个问题是straightforward
redcution from set cover problem。哪位大虾读过这几篇paper,能讲一下具体怎么
reduce from set cover?谢了。 |
|
f******2
发帖数: 2455 | 37 OLAP/OLTP/CEP都在这个领域吗？
有人懂吗？给个综述吧。 |
|
s****d
发帖数: 56 | 38 Hadoop的最大优点是 fault tolerance， 如果你有上百台普通机器，这些机器都不是
很稳定，并且是进行一过性数据分析，用Hadoop
如果你是要在固定的数据上做不同的OLAP，建议用并行数据库，比如Teradata
Hadoop：数据加载快，但处理执行慢；每次这些都要重新加载所有数据
并行数据库：数据加载慢，但一旦加载完成，由于索引和查询优化，反复查询处理就快
了。不过并行数据库fault-tolerance不如Hadoop强 |
|
p*s
发帖数: 10 | 39 So what(kind of ) software is usually uesd in real company?
I know it is associated with OLAP,but it must have some special ones for
itself???
|
|
|
lx
发帖数: 28 | 41 Online Analytical Processing
a topic in very large database(datawarehouse), can do
very complicated queries
web-enabled database application
... |
|
S*******s
发帖数: 13043 | 42 of course not.
one is OLAP, the other is OLTP.
why not search and read? |
|
w********g
发帖数: 2 | 43 我用Browse Data 的功能观看cube的数据的时候，为什么总是出现错误
“unable to browse the cube HR” uspecified error |
|
f*******h
发帖数: 1269 | 44 Use Oracle PL/SQL, or use OLAP functions. You can do everything
with that. |
|
g*******l
发帖数: 6 | 45 I am exporting a subset of records in two tables into a file. The command i
use
is:
exp usr/pass@db file=test.dat log=test.log tables=\(table1, table2\)
query=\"where the_time\
The command was running but it gave follow error:
"
Export: Release 9.2.0.4.0 - Production on Tue Sep 14 07:10:52 2004
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Expor |
|
w*r
发帖数: 2421 | 46 标准ANSI的SQL就那么些了，每个公司自己有自己的extension, Teradata的extension
还好，相对来说performance比较稳定，OLAP的的function优化得虽然一般但是比
oracle里面的看起来很powerful,但是效率不稳定的facey的东西要好. |
|
x***e
发帖数: 2449 | 47 search for DB replication for the second question.
for the first one, I recommend you create a seperate DB for DB warehousing
or other usages.
It all depends on what kind of Production DBs you got.
I assume they are OLTP, not OLAP.
It also depends on what kind of reporting and how fast you want that done.
How big the DBs are, how powerful your production servers and the offline
servers are, etc.
Anyway, my point is your question is too large to give a simple solution.
incremental |
|
m******y
发帖数: 588 | 48 production DB is OLTP. We do want a OLAP to do the reporting. But because of
time constraints, we will only starts with OLTP dbs copying to offline
servers insteading of doing all reporting on OLTP dbs right now.
It's easy to get the backup of OLTP dbs and restore them on the offline
servers, but it seems not very efficient. If we want to make changes on
offilne server dbs like tuning index better for reporting, it has to be made
every time we restore them from production dbs. So I'm wondering h |
|
x***e
发帖数: 2449 | 49 If your DB is only used to record inserting data and seldom do delete or
update.
Then, you can record update/insert date as a seperate column.
Use "select into" to do incremetal load and
if your DB is big, you will have to think about table partition.
For OLAP reporting, do you need the data warehouse and mart at the same
server
or you need a data warehousing server and a mart server?
different approach will lead to different design.
restore backups is not a quite efficient way.
If you have to d |
|
w*r
发帖数: 2421 | 50 build a tree diagram of your query you will find that you have several
tables scanned multiple times
i re-write your query by eliminating the IN() construct. Usually the IN
construct is not well optimized in most of RDBMS system. In addition to this
, I believe you can use OLAP MAX() PARTITION BY() function to eliminate the
cs_of_date subquery.
SELECT
DECODE (LENGTH (e.e_last_name),0, u.user_id, e.e_last_name || ', ' || e.
e_fi
rst_name) salesperson_name,
t.ca_care_id AS account_numb |
|
