华为ERP系统架构.doc

华为ERP系统架构管理工程部.AD系统分析部2004年3月目录ISC流程简介ERP 应用架构系统架构容量规划The ISC Process Model Covers 5 Major Level 1 Process Areas MAKEMake ProductEnable MakeORDERMarket ProductSOURCESource ProductEnable SourceDELIVERDeliver ProductEnable DeliverPLAN Plan Supply ChainEnable PlanSuppliersCustomersRETURNCustomer Return is currently out of ISC project scope. However Source Return processes have been incoporated into Source process area.This is newly added areaISC Process Model can be Broken Into a Total of 49 L2 Processes Planning(Level 2)Executing(Level 2)Enabling(Level 2)Capture Demand & Consume ForecastP1.1Develop S&OP PlanP1.2Develop Master PlanP1.3Develop Production PlanP1.4Plan Product PromotionO2.1Manage OpportunitiesO2.2Process Customer RFP / RFQD2.1Receive Contract, Configure & Validate OrderD2.2Schedule Product DeliveriesS2.1Schedule Production ActivitiesM2.1Consolidate OrderD2.4Receive Product at WarehouseD1.8Transfer ProductS2.4Plan & Build LoadsD2.5Route ShipmentsD2.6Assign Carriers & Rate ShipmentsD2.7Produce & TestM2.3Stage ProductM2.5Pick Staged ProductD2.8Load Veh, Gen Ship Docs, Verify Credit & Ship ProdD2.9Enable SourceManage Sourcing RulesES.1Assess Supplier PerformanceES.2Maintain Source DataES.3Manage Product InventoryES.4Manage Supplier NetworkES.7Manage Supplier AgreementsES.9Enable MakeManage Production RulesEM.1Assess Production PerformanceEM.2Manage Production DataEM.3Manage In-Process Products (WIP)EM.4Manage Production NetworkEM.7D2.3Receive Resources & Determine Delivery DatePrepareDomestic ForecastO2.3Prepare Overseas ForecastO2.4PublishForecastO2.5O2.5Enable PlanManage Business RulesEP.1Manage Performance of SCEP.2Manage Plan Data CollectionEP.3Manage ISC InventoryEP.4Manage ISC Capital AssetsEP.5Manage Planning ConfigurationEP.7Align SC Unit Plan with Financial PlanEP.9Assess Planning & Dmd For. PerformanceEP.10Enable DeliverManage Deliver RulesED.1Assess Delivery PerformanceED.2Manage Delivery InformationED.3Manage Int SC TransportationED.6ED.4Manage Finished Goods InventoryPick ProductD1.9ISC 1C1O第一层流程目录ISC流程简介ERP 应用架构系统架构容量规划华为Oracle ERP系统实施历程1995年前自行开发独立小系统19941995年底进行MRPII选型, 最终引进Oracle公司的MRPII产品1996年3月MRPII实施工作的全面开展1997年4月上线运行2000年开始启动与IBM合作的ISC ( Integrate Supply Chains)项目2001年成功实施了海外ERP项目2002年启动R11i实施项目, 2003年春节升级到R11i，扩大应用范围，更好满足客户需求Oracle ERP软件包功能覆盖领域华为已成功实施了制造和财务共16个模块Oracle 合同管理(CM)Oracle 订单录入管理系统（OM）Oracle 库存管理系统（INV）Oracle 物料清单/工程管理系统（BOM/ENG）Oracle 主生产计划/物料需求计划管理系统（MPS/MRP）Oracle 能力计划管理系统（CRP）Oracle 车间生产管理系统（WIP）Oracle 采购管理系统（PO）Oracle 电子采购系统(i-Procurement)Oracle 成本管理系统（CST）Oracle 帐务管理系统（AR/AP/GL/FA）华为Oracle 11i ERP应用构成工 程BOM采 购应 付主生产计划物料需求计划库 存固定资产能力计划车间作业成 本订单管理发 货应 收总 帐顾客信息流市场计划物流合同管理ERP支持华为的多种制造模式专项生产需求周期定货生产需求周期设计采购加工装配发运签订合同签订合同签订合同定货组装需求周期签订合同现货生产需求周期交货ETO生产周期MTOATOMTS采用PTO、ATO、MTO、MTS等结合的制造模式，大大提高了产品的客户化能力、压缩了交货周期，提高了企业核心竞争力ATO: Assemble-to-OrderPTO: Pick-to-OrderETO: Engineer-to-OrderMTO: Make-to-OrderMTS: 现货生产MTF:Oracle 11i 与APS等外围系统的集成架构,把ISC的各流程和数据有机地集成在一起. 它集成了高级计划,发货,销售,物流等60多各系统Oracle ERPi2 DPi2 DF(ForecastNetting)i2 FPSAP HRPDMNSASMSPRPMFCAT_TOOLSASRSDMS IISPSOSPEVCSPMSConfigItem,BOM, ECOSalesOrderForecastNetted ForecastCustomer,Item,BOMSO, WOOn-hand Qty, Item, BOMWork Order(manual)Sales Order, Task OrderMTBCSSales Order, Task OrderTask Order, Sales Order DetailsWork Order #, Scheduled Dates, Detailed Scheduling, Special Materials Remarks, Special HandlingPR, WO,SO Planned DatesEmployeeBanking InfoItem,Receipt Notice, Onhand Qty, Stock OrderDescriptiveElementWork Order(manual)Material TransactionWork Order Details, Onhand QtyReceipt, Inventory TransferHistoricalSales Data,Sales BOM(derived)SalesOrderBOM,ECO,WIP, Inv,PO, ASL,SOWork Order Exec StatusTask Order Exec StatusPick Confirm, Ship ConfirmPOC Pick ListProjected MaterialShortage ReportMaterial TransactionItem, Subinventory, LocatorPOC PickRequirementWork Order #Config(via EDAS)Move TransactionWO, RoutingMove TransactionWO, RoutingATO ConfigDelivery Lead-time(processed by ROI)Item, Sales Orderi2 DF(OrderPromising)i2 SCPi2 SCCNetted ForecastWIP StatusMTS Forecast for CriticalItemsAllocated ATPForecastfor Non-critical ItemsISC Launch 2ATP CheckSales Order PromiseATP Enquiry, Sales OrderForecast for Critical ItemsPOSupply CommitmentsPO_FAXSupplier, PO, BuyerPRBOM, Inv,SO, PO, ASLContract #(manual)BCSPO ChangeWork Order ShortageMove TransactionMoveTransactionSoftware VersionISC ApplicationArchitectureOverview v 2.02002-12-3CISCustomer TierISC Launch 1Stock Order使用的技术Oracle NetOracle 11i APIOracle 11i InterfaceWeb Method目录ISC流程简介ERP 应用架构系统架构容量规划收集客户需求并与软件、硬件、流程和过程进行映射， 描述了主要的Oracle 11i高层次 组件及其层次关系ERP组件概图为了达到业务目标，根据组件概图和识别华为ERP技术服务需求，推导出ERP详细组件概图ERP详细组件概图从逻辑层面描述主要应用组件和基础架构组件类型，将有助于识别支撑所有需求组件的基础架构需求应用拓扑显示了ERP应用组件及组件间的通信协议Oracle 11i ERP系统架构，满足了ISC第一阶段的业务需求特点由一台GS320承担数据库服务器应用与Web服务器都部署在一台GS320使用了SAN架构，和高性能的HDS9980存储系统一台Stand by服务器作位备份系统网络部署在公司内部Network and security technicalNetworkWAN: DDN,ATMLAN: EthernetSwitch:Huawei RadiumRouter: TCP/IP router (Huawei Quidway)Session/Transport/Network Layer: TCP/IPApplication Layer: HTTPPresentation Layer: IIOPTransport Layer: Sockets + SSLDatabase Link: Oracle Net8Exchange Message: XML (Dont use)Firewall (未使用)Cisco PIXNS-100软件硬件配置数据库服务器Compaq Alpha Server GS320 32CPU 21264A/ 1 GHz内存 64 GB ECCOS: Compaq Tru64 UNIX v5.1RDBMS: Oracle 8.1.7Oracle Concurrent Manager应用服务器Compaq Alpha Server GS320 16CPU 21264A/ 1 GHz内存 32 GB ECCOS: Compaq Tru64 UNIX v5.1Oracle Application Server , ApacheOracle 11i Application Suite存储系统SAN架构SUN StorAdge (HDS 9980)Oracle 11i ERP高可用性系统架构，满足了华为不断增长的业务需求特点由2台GS320承担数据库服务器使用Oracle 9i RAC实时应用群集技术应用与Web服务器都部署在一台GS320使用了SAN架构，和高性能的HDS9980存储系统一台Stand by服务器作位备份系统网络部署在公司内部目录ISC流程简介ERP 应用架构系统架构容量规划容量规划目录简介容量规划技术ISC项目容量规划技术ISC容量规划结果容量规划的定义建立详细的容量规划是确保: 获得足够的硬件资源满足未来工作负载的需求实现最佳的成本效益 以及满足项目的总体性能目标系统容量与响应时间的关系0%10%20%30%40%50%60%70%80%90%系统资源利用率响应时间容量规划技术或方法单凭经验的方法 Rule Of Thumb (ROT)比率法 Ratio (Ratio)分析建模 Analytical Modeling (QM)多重线性回归法 Multiple Linear Regression (MLR)性能测试法 Performance Testing (PT)仿真法 Simulation (SIM)单凭经验的方法 Rule Of Thumb (ROT)潜心于利用简单的单凭经验的方法来决定容量的需求速度快,且便宜精确性低, 但为初始容量规划提供一种适当的指导,基于许多其它项目的经验或硬件供应商提供的数据的惯例比率法 RATIO使用相似的硬件和配置的已确定的性能数据，可以从Oracle已经完成的基准项目中获取。将选定的参考基准应用于具体的项目关键需求是相似的硬件和配置 精确性很好Oracle提供基准性能指标数据库，不同的平台都可以该技术，包括Compaq, SUN, IBM等硬件平台多线性回归 Multiple Linear Regression (MLR)找出最佳描述系统行为的变量，比如OM,PO等基于当前系统使用情况，使用这组变量预知未来系统使用情况的未来行为仅应用于正在运行的系统，部适合升级项目模型的适合度取决于数据、信心程度和预测的范围分析建模 Analytical Modeling (QM) 测量单用户（或单线程）测试结果，估算系统的容量需求请求典型交易，正确地判断测试系统规模，纠正测定容量精确（假如好的输入)，但成本高在很短的时间内完成新场景的重新计算最好关注于高风险领域使用该方法通常使用于高风险关注的领域，比如销售订单工作流性能测试 Performance Tests (PT)基于利用率模型开发并执行一种人工测试方法，利用负载生成器或远程终端仿真程序(RTE),在测试期间获得性能指标在高成本下，提供很好的精确性 当测试时，主要精力是观察所有组件行为的能力一般在项目的压力测试阶段使用该方法，而不是在容量规划阶段容量规划技术的成本精确性比较 Cost / Accuracy成本精确性ROTRatioMLRPTSIMQM容量规划规划什么?服务器规模 (Server Sizing)CPU 需求 - TPM-c内存需求 - Gbytes磁盘资源规模 (Disk Resource Sizing)数据库磁盘需求 Gbytes每个节点软件的磁盘需求 - Gbytes网路规模 (Network Sizing)网路流通量带宽需求 KB per SecondISC项目使用的容量规划方法 Capacity Plan Method-两步法初步规划收集华为的业务需求指标收集华为未来的业务需求使用ROT和RATIO建模识别风险领域和使用UNIX和Oracle工具测量使用QM模型进行高风险建模提出容量规划修正创建技术体系架构将技术架构TA反馈给容量规划执行压力测试 (PT 模型)基于压力测试结果修正容量规划和TA完成容量规划容量规划技术在ISC项目的应用服务器容量规划单凭经验的方法 Rule Of Thumb (ROT)比率方法 Ratio 风险领域使用分析建模 (QM)磁盘容量规划多重线性回归分析 Multiple Linear Regression (MLR)网络容量规划比率方法 Ratio容量规划技术在ISC项目的应用 服务器规划系统使用率确定为80%,使用了 Ratio and ROT高风险领域使用QM建模完成例如,销售订单,电子采购使用其它一些工具获得实际数据, 例如使用 statspack, collect, sar, iostat, vmstat 等工具收集CPU消耗和内存消耗等.什么是高风险领域? 需要根据业务确定容量规划技术在ISC项目的应用 硬盘资源规划(数据库)按照模式和大对象(超过10MB)排列R11i已经升级的数据库基于已有的和新的存储数据,估算每个对象的增长确定规划多长时间确定任何流程变化或业务增长变化、关键交易变化，因此修订模型应用新模型并重新确定数据库的大小如果估算到表和索引,那么将将很精确容量规划技术在ISC项目的应用 网络容量规划基于活动用户量和Oracle 提供的典型比率值测定高峰和平均值远程访问是一个问题,需要进一步测定使用ROT和基准法预测的结果Database Server104,02274,29856,09140,060Value124,84465,08644,85333,197Oracle CTC Model104,02274,29856,09140,060Oracle EMEA Model102,70479,67059,18646,229Oracle AsiaPac Rule of Thumb ModelTPM-C 2005TPM-C 2004TPM-C 2003TPM-C 2002Model73,98468,09659,39257,600Value72Gb64Gb52Gb48GbOracle CTC Model73,98468,09659,39257,600Oracle EMEA Model97,68683,75171,23563,630Oracle AsiaPac Rule of Thumb ModelMemory(Mb) 2005Memory(Mb) 2004Memory(Mb) 2003Memory(Mb) 2002Model使用ROT和基准法预测的结果Application Servers129,38492,40969,94849,956Value124,84489,40861,37345,593Oracle CTC Model129,38492,40969,94849,956Oracle EMEA Model107,27580,39055,72240,374Oracle AsiaPac Rule of Thumb ModelTPM-C 2005TPM-C 2004TPM-C 2003TPM-C 2002Model56,05442,11929,60321,728Value56Gb42Gb32Gb24GbOracle CTC Model31,23222,27215,87211,520Oracle EMEA Model56,05442,11929,60321,728Oracle AsiaPac Rule of Thumb ModelMemory(Mb) 2005Memory(Mb) 2004Memory(Mb) 2003Memory(Mb) 2002ModelISC 项目对Oracle 11i 服务器第一阶段的容量规划1GS80Memory = 24GbCPU = 4 (731 MHz)DMZ Web Server Tier2GS80Memory = 24GbCPU = 8 (731 MHz)Application Tier1GS160Memory = 32GbCPU = 16 (731MHz)Disaster Recovery Database Tier (2 Tier)Location = Beijing (TBC)Minimum Specification. Higher will be better1GS320Memory = 64GbCPU = 32 (731MHz)Standby Database Tier (N Tier)Location = ShenzhenPhase 1: 1Later : 2GS320Memory = 64GbCPU = 32 (1001MHz)Database Tier (N Tier)Location = ShenzhenInitially one server, then using RACCountModel / SpecificationTier NameISC 项目对Oracle 11i 服务器第二阶段的容量规划1GS80Memory = 24GbCPU = 8 (731 MHz)DMZ Web Server Tier3GS80Memory = 24GbCPU = 8 (731 MHz)Application Tier1GS160Memory = 32GbCPU = 32 (731MHz)Disaster Recovery Database Tier (2 Tier)Location = Beijing (TBC)Minimum Specification. Higher will be better0GS320Memory = 64GbCPU = 32 (731MHz)Standby Database Tier (N Tier)Location = ShenzhenNow optional and not necessary2Note 1 : GS320Memory = 64GbCPU = 32 (1001MHz)Node 2 : GS320Memory = 64GbCPU = 32 (731MHz)Database Tier (N Tier)Location = ShenzhenRAC ClusteringCountModel / SpecificationTier NameISC 项目对Oracle 11i 存储容量规划2341202136223411201280234104012002349361096Mirror TOTAL (Gb)117601681117560640117520600117468548TOTAL (Gb)0018001800180018Rollback Segments005005005005Temporary0076007600760076Archive Redo Logs0036003600360036Online Redo Logs501000501000501000501000WorkSpace0018001800180018Archive Out0036003600360036Archive Log 0030003000300030Online Outp0060006000600060Online Log0032003200320032Oracle S/W110110110110Temporary641280641280641280641280SWAP220220220220OS03700032900289002370Online Bkp DB00370003290028900237DatabaseApp Server Tier DiskDB Tier DiskRAID DiskApp Server Tier DiskDB Tier DiskRAID DiskApp Server Tier DiskDB Tier DiskRAID DiskApp Server Tier DiskDB Tier DiskRAID DiskResource2005 Disk Resource Sizing2004 Disk Resource Sizing2003 Disk ResourceSizingCurrent Disk Resource Sizing (2002)网络容量规划最大容量需求15,67214,9162,508Total6,3676,0648.0758Heavy5,8595,5806.0930Medium3,4463,2724.0818LightSecure Total Kbits/secondUnsecure Total Kbits/secondKbits/second per user requirementTotal Number of UsersUser Load39,47137,5902,508Total11,93911,37015.0758Heavy14,64813,95015.0930Medium12,88412,27015.0818LightSecure Total Kbits/secondUnsecure Total Kbits/secondKbits/second per user requirementTotal Number of UsersUser LoadClient Application Server Network RequirementsApplication Server Database Server Network Requirements网络容量规划平均容量需求6,2625,9641002Total2,5452,4248.0303Heavy2,3442,2326.0372Medium1,3731,3084.0327LightSecure Total Kbits/secondUnsecure Total Kbits/secondKbits/second per user requirementAverage Number of UsersUser Load15,78115,0301002Total4,7724,54515.0303Heavy5,8595,58015.0372Medium5,1504,90515.0327LightSecure Total Kbits/secondUnsecure Total Kbits/secondKbits/second per user requirementAverage Number of UsersUser LoadClient Application Server Network RequirementsApplication Server Database Server Network RequirementsOracle 推荐的PC配置要求一般用户配置10/100 Mb/s10/100 Mb/s10/100 Mb/sNetwork Interface CardWin 95/98/2000/NT4Win 95/98/2000/NT4Win 95/98/2000/NT4Operating System4 Mb2 Mb2 MbVideo Card1024 x 768 SVGAn/a1024 x 768 SVGAMonitor30Gb1