Comments
Transcript
Infrastructure Management Solutions and Data Quality
Infrastructure Management Solutions for the Utility and Telecommunication Industries ユーティリティとテレコム向け 設備管理ソリューション Geoff Zeiss Infrastructure Solutions Division Director of Technology Autodesk, Inc. 2005.9.7 1 講演概要 Outline ユーティリティとテレコム業界の設備管理の技術動向 Technical trends in facility management in the utility and telecom industries インフラストラクチャー・ライフサイクル・マネージメント 構築ソリューションのアーキテクチャ Infrastructure lifecycle management solution architectures 現実のライフサイクル・マネージメント・ソリューション のケース・スタディ Case studies of real world lifecycle management solutions Infrastructure Solutions Division 2 © 2005 Autodesk Technical trends in facility management in the utility and telecom industries ユーティリティとテレコ ム業界の設備管理の 技術動向 Infrastructure Solutions Division 3 © 2005 Autodesk ユーティリティとテレコム業界の設備管理 の技術動向 Technical trends in facility management in the utility and telecom industries オープンなオブジェクト型リレーショナル・データ ベース管理システム（ORDBMS) Open object-relational database management systems (Open ORDBMS) モバイル・コンピューティング Mobile computing 第2世代のWebマッピング Second generation web mapping 新しいアプリケーション開発ツール群 Modern application development tools Infrastructure Solutions Division 4 © 2005 Autodesk ORDBMSとは？ What is an ORDBMS ? 拡張されたリレーショナル・データモデル Extends relational model 配列、ネスト化された表、抽象データなどの拡張された データ形式への対応 Extended data types include arrays, nested tables, abstract data types 空間データ、時系列データ等への対応 Enables spatial, time-series, etc. 拡張性のあるインデックス作成 Extensible indexing 空間インデックス：四分木、Rツリー、グリッドへの対応 Enables spatial indexes: quadtree, r-tree, grid Infrastructure Solutions Division 5 © 2005 Autodesk ORDBMSの技術的優位性 Technical Advantages of ORDBMS 拡張されたデータ形式 動的なデータモデル Extended data types Dynamic data model 空間データ Spatial 拡張性 Scalability Data model (tables and columns) can be modified independent of application ペタバイトのデータクエリー能力 オンライン管理処理 Ability to query petabytes of data On-line administration クラスター技術 Clusters 組み込み型の管理処理 Built-in administrative tasks バックアップとリストア Back-up and restore Open SQLやODBC、JDBC,OLEDB等の 標準インターフェイスでのデータア クセスが可能 Data accessible through SQL and standard interfaces ODBC, JDBC, and OLEDB Strong security 認証と権限管理 Authentication and privileges Infrastructure Solutions Division バックアップやデータモデルの変更 をDBMSの停止なしに可能 Can backup, modify data model without taking DBMS down 強力なセキュリティ データモデル（表やカラム）はアプリ ケーション独自に変更可能 6 © 2005 Autodesk オープン地理空間データストアの革新 Evolution of open geospatial datastores Closed Old 独自コマンド ORDBMS New Spatial Versioning Infrastructure Solutions Division API Spatial Versioning API RDBMS Client Application SQLと独自拡張機能 SQL with proprietary extensions ODBC RDBMS Client Application Client Application SQLと標準拡張機能 SQL with spatial & versioning extensions ODBC Proprietary Datastore 独自コマンド Client Application Proprietary Commands SQL Proprietary Commands Server 独自コマンド Server Proprietary Commands Spatial Versioning 7 Open © 2005 Autodesk マルチベンダー環境を支援する 空間データ形式 Multi-vendor support for spatial data types ポイント、線分、ポリゴン Points, lines, closed polygons 指向性ポイント、地図製作テキスト、他 Oriented points, cartographic text, … 線分トポロジー ポリゴン・トポロジー 位置座標付ラスター 線分参照システム バージョン対応データ Infrastructure Solutions Division Linear topology Polygon topology Georeferenced rasters Linear referencing systems Versioned data 8 © 2005 Autodesk 標準 Standards W3C HTML, XML, SVG, … Web services: UDDI, WSDL, SOAP, … Open Geospatial Consortium ISO SQL SQL/MM TC211 Interoperability Initiative (Autodesk, Intergraph, MapInfo, Laser-Scan) Oriented points, cartographic text, … Infrastructure Solutions Division Simple Feature Specification GML OWS: WMS, WFS, WCS, FE, SLD, … Multispeak J2EE, .Net 9 © 2005 Autodesk 設備管理に於けるORDBMSのビジネス 上の利益は何か？ What are the business benefits of an ORDBMS for infrastructure management ? 企業全体でのオープンなデータアクセス Open data access across the enterprise マルチベンダーでの相互運用性 Multi-vendor interoperability 顧客は業務毎の最適な製品を選択できる Customer can buy best-of-breed 特定ベンダーの囲い込みを回避できる Avoid vendor lockin データ品質をドライブする業務プロセスを可能にする Enables business processes that drive data quality 業務アプリケーションの統合 Application integration コスト削減 Reduces cost Infrastructure Solutions Division 10 © 2005 Autodesk ORDBMSはマルチベンダー相互運用性 を提供します ORDBMS enables multi-vendor interoperability ODBC Autodesk Map PC SQL PC SQL Geospatial RDBMS SQL ODBC ODBC GeoMedia Data Server MapInfo SQL PC Infrastructure Solutions Division ODBC Custom Application PC 11 © 2005 Autodesk 企業全体でのオープンなデータアクセス Open data access across the enterprise Engineering Design ERP Engineering Analysis SQL SQL Outage Management SQL SQL Asset Management Wireless or Sync SQL Geospatial RDBMS SQL Workflow Handheld Field Applications Infrastructure Solutions Division 12 © 2005 Autodesk モバイル コンピューティング Mobile computing 事業経営者の調査では、次の3年間のトップ5のイニシアチブ の中に一貫して入っている Consistently placed within the top 5 initiatives of the next 3 years in surveys of business executives. 最近の研究では、次の3‐4年後に実現を予測 Recent study suggests that in next 3-4 years 65%のモバイル労働者が、ハンドヘルドや高度自動機能電話などのデータ・ア クセスデバイスをもっている 65% of mobile workers with data access devices such as handhelds and smart phones ユニバーサルワイヤレスインターネット接続や3Gデータアク セスが成長しているトレンド Growing trend to universal Wi-Fi and 3G data access 例: Intel Digital Cities initiative ハンドヘルド機器の処理能力の向上 Increased computing power in handheld devices. Handheld devices with energy-efficient x86 compliant processors and peripheral chips Infrastructure Solutions Division 14 © 2005 Autodesk 第2世代のWebマッピング Second generation web mapping 第1世代 ： First generation Http and HTML pages Ex. Mapquest 第2世代 ： Second generation AJAX: Streaming XML OGC standards: WMS, WFS, GML Industry standard architecture Ex. Google maps Infrastructure Solutions Division 15 © 2005 Autodesk 新しいアプリケーション開発ツール Modern application development tools Desktop Object-oriented APIs Ex. .Net CLR, Java Web PHP, JSP Server .Net J2EE Infrastructure Solutions Division 16 © 2005 Autodesk Infrastructure lifecycle management solution architectures インフラストラクチャ・ライ フサイクル・マネージメン ト・ソリューション構築の アーキテクチャ Infrastructure Solutions Division 17 © 2005 Autodesk ユーティリティとテレコムに於ける設計 から保守までのライフサイクル Utility and Telecom infrastructure design and maintenance lifecycle Prepares workprint sketch Drafter Workprint sketch Records Engineer Workprint Prepares Estimates Drafts workprint Workprint Customer Engineer Customer Service Request Workprint Workprint Field Install and repair Paper, Microfiche PDF Records Work prints Plotter Construction subcontractor Paper Constructs facilities Record u -b As Records Clerk ilt Drafter As built Prepares as builts Final Posts record Infrastructure Solutions Division 18 © 2005 Autodesk 崩れたプロセスがデータ品質の悪化を 招く Flawed Processes lead to poor data quality 業務プロセスはデータ品質向上の為には設計されていない Business processes are not designed to promote data quality 既存のバックログ As-built backlogs 現場へ信頼できるデータへのアクセスを提供するのは不可能 Inability to provide access to reliable data to the field 低いデータ品質はいずれ高くつく Poor data quality is expensive 例えば「手戻り」：現場作業の幾らかは、2∼3回現場へ出向いている For example, “returns”, the proportion of work orders requiring two or more trips Infrastructure Solutions Division 19 © 2005 Autodesk 崩れたプロセス：既存プロセス Flawed process: As-builts 既存プロセスは「紙」中心 As-built process is paper-based 殆どのユーティリティとテレコムは紙の工事図面を作成 Almost all utilities and telecoms generate paper construction drawings 現場から戻ってくる追記された工事図面が、設備レコード （GIS）データベースに再入力される Marked up construction drawings returned form the field are redigitized into the records (GIS) database 崩れたプロセスはエラーを誘発し、データの2重管理を 招き、そして高い費用がかかっている Process is error-prone, creates redundant data, and is expensive Infrastructure Solutions Division 20 © 2005 Autodesk 崩れたプロセス：信頼できるデータの現 場への提供 Flawed Process:Providing field access to reliable data 誰が設備実態を把握していますか？ Who knows your facilities first hand ? 大企業では数千から数万の現場スタッフがいる Large organizations have thousands or tens of thousands of field staff 特徴的に、現場からのフィードバックは歓迎されない-バックログと低い品質を 招く Typically, feedback from the field is not encouraged – backlogs or low priority 誰が業務遂行の為に正確なデータを求めますか？ Who requires accurate data to do their job ? 手戻りは工事全体の25％から33％も発生している Returns are in the range of a quarter (25%) to a third (33%) of all work orders. 誰が設備レコード・データベースを所有していますか？ Who owns the Records database ? 技術者、管理者、記録担当部署・・・ Engineers, managers, records department, … 設備レコードデータベースの品質はどのようになっていますか？ What is the trend in the quality of the Records database ? 品質は時間と伴に低下する Quality decreases with time Infrastructure Solutions Division 21 © 2005 Autodesk Solution: Open Spatial Enterprise Open ORDBMS 真実は一箇所で管理 Single point of truth データ2重管理の削減 Eliminates data redundancy 既存問題の解決 Resolve as-built problem CADとGISの統合はデータ2重化を排除しバックログの消化と今後 の発生を防ぎます CAD/GIS integration to eliminate redundant data and processes and eliminate backlogs 現場作業者の自動化支援 Automate field-force 事務所から現場への拡大 Extend the office to the field 現場作業者にデータ品質向上のために設備データに関して責任を 持たせる Making field staff accountable for facilities data leads to improving data quality over time Infrastructure Solutions Division 22 © 2005 Autodesk ORDBMSベースのソリューション・アーキテクチャ ORDBMS-based Solution Architecture Object-Oriented API Object-Oriented API SQL Object Relational Mapping SQL RDBMS C/C++ API ObjectRelational DBMS Object Relational Mapping SQL RDBMS C/C++ API Data Server Standard Desktop Application Platform Custom Application Web Server Infrastructure Solutions Division Desktop http & HTML Web Client Web Mapping CGI,ISAPI NSAPI Web Application ODBC, JDBC, OLEDB Third-party Application ` http & XML Web Services Client ` 23 © 2005 Autodesk モバイル・ソリューション・アーキテクチャ Mobile Solution Architecture ObjectRelational DBMS Object-Oriented API SQL Object Relational Mapping RDBMS C/C++ API Data Server Map Sheet Generator and Refresh Cache of Stylized Map Sheets RDBMS C/C++ API Up l oa d Object Relational Mapping Markups Object-Oriented API Standard Desktop Appn Platform Synchronize Markups SQL Local Cache Map Sheets ` Edit Application Handheld Desktop Infrastructure Solutions Division 24 © 2005 Autodesk Key components of solution architecture 1. Open ORDBMS for open data access 2. Object-oriented API for rapid application development 3. Second-generation web mapping for publishing 4. Disconnected clients for deploying facilities data to the field Infrastructure Solutions Division 25 © 2005 Autodesk Case studies of real world lifecycle management solutions ライフサイクル・マネージ メント・ソリューションの ケーススタディ Infrastructure Solutions Division 26 © 2005 Autodesk Infrastructure Management Solutions: Case Studies 1. ENMAX Power Corporation - Canada 2. First Energy - USA 3. Telefonica - Brazil Infrastructure Solutions Division 27 © 2005 Autodesk FirstEnergy Fifth-largest investor-owned electric system in US, headquartered in Akron, OH. Provides retail energy and related services to 4.4 million customers in Ohio, Pennsylvania and New Jersey. Use SAP (ERP), Logica (Workflow), Millsoft (Electrical analysis), and PowerOn (Outage Management). Infrastructure Solutions Division 28 © 2005 Autodesk FirstEnergy: Integration Architecture SAP -CCS SAP -PM WebMethods AGDS Server CREWS Workflow Oracle MapGuide Routing Extract Routines PowerOn Outage Mgmt Infrastructure Solutions Division Autodesk Map MapGuide Millsoft Electrical Analysis 29 Locate Services © 2005 Autodesk FirstEnergy: Benefits Reliability • 20,000 workorders per month Scalability • 400 concurrent users (2,000 total users) Low cost of maintenance • Less than one FTE per year Integration • • • • SAP (ERP) PowerOn (Outage Management) Logica (CREWS Workflow) Millsoft (Electrical Analysis) Infrastructure Solutions Division 30 © 2005 Autodesk FirstEnergy: Benefits Resolved as-built problem CAD/GIS integration Improved data quality Universal data access Easy-to-use data access for casual users Improved energy delivery reliability Reduced costs Infrastructure Solutions Division 31 © 2005 Autodesk Technical Architecture of ENMAX Mobile Solution Data Server Spatially-enabled RDBMS Server Central Facilities Mapsheets Cache Cache Refresh Markups Sy nc hr on i Edit Updates za tio n Mobile Facilities Mapsheets Cache Markups Desktop Computer Infrastructure Solutions Division MobileLaptop with GPS 33 © 2005 Autodesk ENMAX Impact Analysis Example: Cable Locate Services Call Before You Dig Involves public safety Digging up cables is hazardous Cable locate services are expensive for ENMAX, Over 25 cable locate services staff Over 20 vans. Cost of maintaining 50,000 microfiche records costs ENMAX C$1.8 million annually. Indirect costs associated with hits and resulting outages Hit rate was 9 hits per 1000 cable locate calls. For every thousand calls, there were nine incidents where electrical cables were damaged. Infrastructure Solutions Division 34 © 2005 Autodesk ENMAX Impact Analysis: Quality of Service and Safety Hit rate dropped from 9 hits per thousand cable locates to 0.25, 36-fold improvement Even though demand for underground locates has greatly increased over the past 10 years. ¾ Increased safety for excavating contractors and the public. ¾ Reduced Infrastructure Solutions Division outages due to hits. 35 © 2005 Autodesk ENMAX Impact Analysis: Data Quality ENMAX is required to undergo annually by the regulator. Most recent auditor’s report reported that 99.6% of the records audited were found to be correct in a field facilities survey. For many utilities and telecommunications firms, 70-80 % is typical. ¾ Data quality has improved. ¾ Atypical for the utility and telecom industries. Infrastructure Solutions Division 36 © 2005 Autodesk ENMAX Impact Analysis: Financial Benefits ¾Reduced operating cost of cable locate services • From over 20 vans to 5 • From over 25 personnel to 5 • Significant reduction in operating costs associated with cable locate services ¾Reduced operating costs by replacing paper and microfiche records • Reduced from C$1.8 million to C$1.2 million, • Annual savings of C$600 thousand. Infrastructure Solutions Division 37 © 2005 Autodesk Telefonica: Business Drivers Reduce costs Be more responsive to customers Engineering Automate as-built process Eliminate backlogs Operational Reduce cost of provisioning Reduce resources required for provisioning Scalability 12,000,000 customers 16,000,000 access lines. 1 300 major engineering design projects per month 200 000 service orders per month. Infrastructure Solutions Division 38 © 2005 Autodesk Telefonica: Benefits Operational Dramatically higher proportion of automatic assignments Reduced number of assignment errors Resources required for provisioning reduced by 60% Cost of provisioning reduced by 40% Engineering Backlogs eliminated Project life cycle reduced from weeks to days Automated as-built process Automated job estimates and BOM Integrated with SAP asset management ROI over the three year lifetime of this project is 100% Infrastructure Solutions Division 39 © 2005 Autodesk Telefonica: Solution Scalability 1000 concurrent users 1 300 major engineering design projects per month 1,000,000 geographic queries per month 2 billion databases queries per month 200,000 service orders / month 100 million spatial objects in an Oracle RDBMS Infrastructure Solutions Division 40 © 2005 Autodesk Summary Solution Open ORDBMS – data maintainability and open access Object-oriented API - rapid application development CAD/GIS integration - streamlines infrastructure engineering design and maintenance Second-generation web mapping – enterprise-wide data access Disconnected clients - field access to facilities data Business benefits: Increasing data quality Better quality of service Reduced costs Infrastructure Solutions Division 41 © 2005 Autodesk [email protected] Infrastructure Solutions Division 42 © 2005 Autodesk