??????????? ????????????? ? ???, ?????????? ? ??????? ????????? (BI, business intelligence) ? ???????? ?????? Oracle, ??????? ? ?????? ????????????? ? ??????????, ??? Oracle Warehouse Builder, OracleBI Discoverer ?, ???????, ???? Oracle. ??? ??? ??????????? ???????? ?????????? ????? ? ????????????? ??? ??? ?????????????, ??????? ????? ??????? ???? ?????? Oracle ??????? ????? ????????????? ?????????. ?? ????????? ????????????? ????? ??????????? ?????? ??? ?? ??? ?????? Oracle, ??? ? ?? ?????? ?????????? ??????, ????? ??? ??????????? ???????, ????????? ? ??????? XML ?, ????????, ?? ??????, ??????? ??? ????? ??????? ?? ERP-?????? ??? ???? OLAP-???????? (? ???????? ?? ????? MDX), ????? ??? SAP BW ??? Microsoft Analysis Services. ??? ???? ????????????? ? ???????????? ??????? ????? ????????????? ????????? Oracle BI Suite Enterprise Edition ?? ?????????? Oracle, ??????? ???????? ?? ?????????? Siebel Analytics, ????? ???? ???????? ????????.

? ???? ?????? ? ??????????? ?? ?????????? ??? ????? ????????????? ????????? ?, ????????, ????????????? ?????? Oracle BI Server, ?????????????? ?????? ??????????? (?business intelligence application server?), ??????? ????????? ??????? ????? ???????????????? ???? ?????????. ?? ????????, ??? ?? ?????????? ? ????????, ???????????? ???????????? ????????? Oracle ? ?????????? ??? ???????? ??????? ??????????? ? ??????????? (OLAP) ?????? ? ???? ??????. ? ????? ??????????? ?? ?????? ??????????? ? ?????? ?????????? ???????????? ????????, ??????? ???????? ?????? Enterprise Edition, ? ?? ????????????????? ? ???, ??? ???????? ???????????? ????? ???????????? ???? ????? Oracle BI Server.

????????? ????????? ????? ????????????? ????????? Oracle

??????????? ????????????? Oracle ??????? ? ?????????? Oracle Business Intelligence 10g, ? ??????? ???????? Discoverer, Reports ? Discoverer Portlets ??????? ? ???? ??????????? ??????? ? ?????? ?????? Fusion Middleware. ? ??? 2006 ???? ?????????? Oracle ???????? ??? ??????????? ??????? ????? ?????????? ????????????? ????????????, ?????????? ????? ???????????? ???????? Siebel, ????????? ?????? ??? BI Suite Enterprise Edition. ??? ????????? ???? ???????????? ??? ?????????? ???????????? ??????????? ???????, ??????? ????? ?????????? BI Suite Standard Edition. ?

??? ??? ?? ??? ?????, Oracle BI Suite Enterprise Edition?

Oracle BI Suite EE ? ??? ????????????? ????????? Oracle’s «?????????? ?????????». ??????? ???? ????????? ???????? ?????? Oracle BI Analytics Server, ????????????? «?????? ??????????», ????? ???? Oracle BI Suite Enterprise Edition ???????? ????????? ???????????? ??? ???????????? ???????????????????? (ad-hoc) ????????, ???????? (delivery) ? ????????????? (presentation) (???????????) ? ???????????? ?????????? ? ???? ??????????? ?????????? ??????.

? ??????? ?? ????? ?????????, ??? OracleBI Discoverer, Oracle Reports Services ? Oracle Portal, ???????? ???????????? ???????? ? ???????? ??????????? ? BI Suite Enterprise Edition ???? ? ?????? ?????? ????????? ??? ??????????? ????????????? ????? ? ??? ?? ??????????, ????????? ??????? ??????????, ?????????????? ?????????? ? ???????????? ?????????????????. ??? ??? ???????? ???? ??????? ? ??????????? Dynamic HTML, ??? ????????????? ????????? (rich) ???????????????? ?????????, ?? ??????? ??????? ?????????? ?????? Web-????????. ?

?? ?????? Siebel Analytics

?????????? ? ????????, ??????? ?????????? Oracle BI Suite Enterprise Edition, ???????? ?? Siebel Analytics, ????????, ??????? ?????????? Oracle ????????? ??? ??????? ???????? Siebel ????? ? 2006 ????. Siebel Analytics ??? ??????? ?? ??????????, ??????? ????????? ???????? Siebel ?? ????? nQuire ? 1999 ???? ? ??????? ?????? ???????? ? ??????? ??? ????????????? ????????? ?????????? ?????????. ??? ????????? ????????? Siebel ????? 25% ?? ??????? ?? ??????? ????????. ?

????????????? ???????? Oracle BI Suite EE ????? ???????? ?? ?????????? Siebel Analytics ? ????????? ? ????????? Oracle, ????????????????? ??? ?????? ? Oracle’s Fusion Middleware. ?? ???????? Oracle ??????? (? ??? ?????????) ?????? ???????????????? ?? ?????? ????? ?????????, ??????? ????? ????????, ??? XML Publisher, Oracle Business Activity Monitoring ? Oracle Portal, ? ???? ???????? Siebel ????? ????????? ??? ?????????????? ???????????? ?????????????. ?? ???????????, ???????? ??????? ? ?????? BI Analytics, ??????? ??????????? ? ???????????? ???????????, ?? ????????? ? ??? ???????????? ???????????? ????????? ?????????? ???????? Oracle ?? ??????????? ???? ????????????? ?????? ? ???? ?????? Oracle ? ????? ???????????? ??????? ? ?????????????? ???????????? Oracle ? ???? ???? ??? ????????? ??????.

????????? ????????? Siebel Analytics

?? ?????? ?????? ? Oracle, ????????? Siebel Analytics 7.8 ???????? ?? ???? ??????? ?????????:

• Siebel Business Analytics Platform ? ?????????????? ??????? ??????????, ???????????? ????????????????? ? ???????????? ???????, ??????? ?????? ?????????? Oracle BI Suite Enterprise Edition;
• Siebel Analytics Applications, ?????? ?????????????? ?????????????????? (pre-packaged), ???????????? ??????????, ??????????? ? ??????????? ???????????? Analytics Platform. ??? ?????????? ?????????? Oracle ????? ????????? ??-???????? ??? ?????? Siebel Business Analytics Applications. ?

?? ??????? ???????? Siebel ??????????? Oracle, ???????? ??????????? Siebel Analytics ? ???? ????????? ???? ?????????????? ?????????????????? ??????????, ???????? ??????? ???????????? ???, ??? ? ??? ??? ???? ?????????? ? Siebel CRM ? ???????? ERP-???????????, ?????????? ???????? workflow, ? ??? ????????? ?? ??????? ? ????? ??????? ????????????? ?????????. ?????????? ? ???????, ?????? ????????, ??? Oracle ??????? ??????? ??? ??????? ????????????? ?????????? ????????? Fusion ?????????? Siebel Business Analytics Applications. ?

?? ?????? ?????? ? ??????????? Oracle ???????? Siebel ??????????? ????? ???????????? ? ????????? ????????? Siebel Analytic Applications, ?????? ?? ??????? ?????? ???????????? ??? ???????? Oracle, ??, ?? ???? ?????????, ???????? ???? ??. ??? ????????:

• Sales Analytics,
• Service and Contact Center Analytics,
• Marketing Analytics,
• Financial Analytics,
• Supply Chain and Supplier Analytics,
• HR/Workforce Analytics ?
• Real-Time Decision Solutions. ?

??? ????????????? ?????????? ???????????? ? ETL-????????? ? ????? ??? 3000 ERP-????????, ??????? ?????????? ? Siebel CRM, Oracle e-Business Suite, SAP, PeopleSoft ? ??????????? ?????????? call-???????.

Oracle BI Suite Platform

?????? ????? Oracle BI Suite Enterprise Edition ??????? ?? ?????????? Siebel Analytics Platform, ?? ??????? ???? ???????? ????????? Oracle. ?? ???????? ?????? ???????? Oracle ????? ?????????? ? BI Suite Enterprise Edition ? ???????????? Siebel-???????? ????? ?????????. ??????????? ??????? ??????? ?????? Oracle BI Suite Enterprise Edition ????????:

• OracleBI Analytics Server, ????? Siebel Analytics Server
• OracleBI Interactive Dashboards, ????? Siebel Intelligence Dashboard
• OracleBI Answers, ????? Siebel Answers
• OracleBI Delivers, ????? Siebel Delivers
• OracleBI Disconnected Analytics, ????? Siebel Mobile Analytics
• OracleBI Reporting & Publishing, ?? ?????? ?????????? ?? Actuate

????????? ? ???????????? ???????????? ???????? ?????? Oracle

Oracle BI Suite EE, ??? ? ????? Siebel Analytics, — ??? ???????????? (federated) ???????. ?????????? ?? ??? ? ???????????? ???????? Oracle ? ?????????? ??????, ????? ?????? ?????????? ?? ??????????? ?????????? ?????? ? ??????????? ? ???? ?????? (????????, ??????? ? ???? ????????????? ???? ?????? ? ????. ???.), ? ????? ????????????? ? ??????????????? ????????? ??????? ??????????? ?? Oracle BI Suite EE ????????????? ? ????????? ?????? ??? ??? ???-?? ?????????????? ? ?????

???????, ?? ??????? Oracle BI Suite EE ????? ????????????? ??? ???????????? ???????? ??????, ??????????? ? ???, ??? Analytics Server ???????????? ?????????? ???????? ? ????????? ?????????? ?????? ? ?????? (joins) ?????????? (???????? ? ???) ?????? ????? ?????????????? ????????????. ?? ????, ?? (Analytics Server) ????????? ?????????????? ????, ??????? ??????????? ??????????? ????????????? ???????? (staging area) ????????? ??????. ????? ????, Analytics Server ?????? ?????????? ? ?????? ?????????? ? ??????-??????????? (business definitions), ??????? ??????? ?????????????, ? ???????????.

??????, ?? ?????? ?????????? BI Suite EE ??????????? ????? ? ????????????? ??????????? ???????? Cognos ? Business Objects, ? ??????? ????? ??????????? ?? ????????? ??????? ?????? ??????????, ???????? ????? ? ?????????? (roles and permissions), ? ??????????? ????? ????????????? ?????? ? ??????/????.

? ????????????????, ??????????? ????????????? ????? ???????????? Oracle BI Suite EE ??? ?????????? ? ????????????? ????????? ?????? Oracle; Oracle BI Suite EE ????? ?????????????? ??? ???????? ???????????? ???????? ? ??????? ??? ????? ????????? ??????, ? ????? ????? ?????????????? ??????, ????? ??? ??????? ??????????????? ?????? ??? ??????, ???????? ? ??????????? ???????? ??? ?????? XML, ????? ??????????? ????? ? Analytics Server, ????? ??? ?????. ????????????? ? ??????? ? ??????????????? ?????? ?? ????????, ? ????????? ?????? ? ETL-????????????, ????? ??? Oracle Warehouse Builder, ???????? ????????? ?????? ??? ?????????? ?????? ???? ??????????.

????????????? ?????? Oracle — Oracle BI Server

??????? ????????? Oracle BI Suite EE ???????? ????????????? ?????? Oracle BI Server. ??? ?????????????? ?????? ??????????? («business intelligence application server»), ??????? ????????????? ????????? ??? Oracle Answers, Oracle Dashboards ? ?????? ??????? ???????????? ????????, ????????? ?????????? ? ??????? ? ????????????? (business and presentation), ???????? ?????? ?? ??? ?????? ? ??????????, ???????? ? ???????????? ?? ? ???????? ?????????? ???????? ???????????? ???????? (query tool).

????????????? ?????? Oracle ? ???, ? ????????, ROLAP (Relational OLAP) ??????????? (engine), ??????? ??????????? ? ?????????? ??????, ?? ?? ????? ????????? (???????) ?????? ? ????????????, ??? ??? ??????, ??????. ???? ? ???? ???? ????? (cache), ? ??????? ???????? ????? ????????? ??????, ??? ??? ??????????? ??????? ? ???? ?? ?????? ??????????? ???????. ??????? OracleBI Discoverer, ????????????? ?????? Oracle ?????????? Enterprise Semantic Model (????????????? Discoverer End User Layer), ???????, ??????, ?????????? ?? ???? ?????: Presentation (?????????????), Business (??????) ? Physical (??????????).

????????????? ?????? Oracle ??????? ????????????? ??? ??????????? ?? ??? ??????. ?????????? ?????????????? ?? ???? ???? ? ??????????? ODBC- ?????????, ? ????? ? ?????? ?????????? ????????????????? ??????, ????? ??? ??????????? ??????? Microsoft Excel ? XML-?????????. ??? ?????? ?????? ??????? ?? ???-??????????, Analytic Server ?????? ??? ??????, ???? ?????, ????????? ?????????? ? ?????? ????????? ? ????????????? ?????????? ????????????? ????? ????????? ??? ???????? ???????????? ????????. ??? ?????????????? ?????????????? ??????? ????? ?? ???????? ????? ???? ????????????, ????????? ??? ????????, ??????????? ???????? ? ????? ? ??????????? ??????? ? ?????-??????????. ? ??? ????????????? ?????? ????????????????? ?? ?????, ?????????????? (??????????) ??????, ?????????? ?????? ????????????? ? ????????????, ???????? ??????????? ???????? ???????????? ????????.

??????, ??????? ????? ?????? ??? ???????????? ?????????????? ???????, — ?? ????? ??????? ?? ???????????? (scale up), ????? ?????????? ? ?????????? ?????? ?? ???????????? ??? ??????. ? ??? ?? ?????????? ????????????? ?????? ? ???????? ?????? ??????,? ?????? ????????????? ????????? Siebel ??????????, ??? ?????? ????? ????????????? ??????? ????? ???????????? ?????????????, ???????? ???????? ? ??????????? ? ?????????? ?????????? ??????, ????????? ?? ?????? ??????????. ????? ????, ???? ????????????? ?????? ?? ?????? (?? ??????? ??????) ???? ??????, ?? ???????? ??????? ?????????? ???? ???????? ???????????, ??????? ????????? ????????? ???????????? ?????????????, ??????????? ????????????, ??????????? ?????????? ?? ????????? ?????????? ?????????? (Unix ? Microsoft Windows, ???? Linux ??? ???), ??????? ?????????????????? ? ???????? ???????? ??????, ????????? ??????? ?????????? (highly available) ? ??????? ??????? ???????????. ???????????? ??????? ?? ??????????? ???? ? ??? ?????????? ???????? ?????? ?? ??????? ?????? (?? ??????????? ???????????? ??????????? ????????) ? ?????????? ????????? ??????????.

Oracle Analytics Web

Oracle Analytics Web ? ??? ?????????? ???????? (application framework), ??????? ????????????? ?????? ? OracleBI Answers, Delivers ? ?????? ???????????? BI Suite Enterprise Edition. ??? ??? ?????????? ?????? Analytics Web ??????????? ??? ?????????? ?? Web, ? ??? ??????? ??????? c ????????? ???????????????? ??????????? ?? ?????? HTML, DHTML ? Javascript. ? ??????? ?? OracleBI Discoverer Plus ??? ?? ??????? JVM (??????????? ?????? Java) ?? ?????????? ?? ? ???????? ? ????????? Java-???????. ?

Oracle Analytics Web ????????? ???????? ????????? web-???????? ??? ????????????????. ?

OracleBI Answers

OracleBI Answers ? ??? ?????????? OracleBI Discoverer ? BI Suite Enterprise Edition. ??? ?????????? ???????????? ???????????????????? ???????? ?, ??? ? ?????? ??????????? Analytics Web, ???????? ? ??????-??????? (business model). ?? ???????????? ??? ???????? ? ?????????? ???????, ??????? ????? ????????????? ????? OracleBI Interactive Dashboards. ?

OracleBI Interactive Dashboard

OracleBI Interactive Dashboard (????????????? ?????????????? ??????) ????????? ?? ?? ????, ??? Oracle Application Server Portal ? BI Suite Standard Edition; ???? ?????????? ????????????? web-???????? (framework) ??? ???????? ????????? ??????? ????????????? ?? ?????? ?????????? Web-????????. ? ??????? ?? BI Suite Standard Edition, ?????? ? ?????????????? ?????? ????????? ???????????? ? ?????????? ?????? ?? ???? ?? ??????????? ? ?????? ????????? ??????? (display live, up to date data) ?? ??????????. ?

??????????? ????????? ? ??????????? ?????????????? ??????

?????????? ???????? Interactive Dashboards ???????? ????????? ??? ?Guided Analytics? ? ??????????? ?????????. ??? ??????? ?????? ? ???????????? ????????? ? OracleBI Delivers ??????????? ??? ????, ????? ?????? ??????-????????????? ?????? ? ?????????? ??????????/???????? (navigate) ??????????? ???????? ? ????????????? ??????????????? ????????. ?

???????? Oracle BI Server

??????? ????????????? ? ????????? Oracle BI Suite Enterprise Edition, ????????? ????????? ?? ?? ????????????? ??????.

???????????

Oracle BI Suite EE ? ??? ?????? ????????? ??? ?????????? ????????????? ??????????. ??? ???????? ????????? ????????????, ?????????? ??????????, ??????????? ????????????????? ? ODBC-?????????? ??? ????????? ? ????? ??. ??? ????? ???????????????? ????????????? Oracle BI Server ?????????????? ? ???????? ?????????????? (authentication cab) ????? ???? ?????????? ??? ????????? ??? ??????? ? ?????????????? LDAP ???? ???????? ?????????????? ???? ??????.

? ?????? ??????????? ???? ????????? — Oracle BI Server. ?? ???????? ???????, ????????? ? ???????????????? ?????????? ???????? — Intelligent Request Generation. ??? ??????????? (?? ?????? ?? ?????????? ?????????) ???????????? ???????? ???????, ???????? ?????? ?? ??????????????? ??????????, ?????? ?? ? ????????? ????????? ??????????. ????????????? ?????? ????? ????????? ?????????? ???????? ? ???????????? ????????, ????????? ??????? ???????????? ? ??????????? ?????? (security and scopes data), ? ???????????? ?????? ????????????? ???????? ?????????? ??????-?????? (logical business model).

Oracle BI Web ? ??? web-?????????? ?? C++, ??????? ????????????? Web Catalog, ?????????? (front-end) ??????????, ????? ??? Oracle Answers ? Oracle Dashboards, ODBC ?????? ? XML- ? URL-???????????? web-???????? SOAP. ?

????????????????? ??????? Oracle BI Server ?????????????? ? ??????????? ???????????? ??????????? (? ????? Windows), ??????? ????????????? ?????? ? ????????? Semantic Model, ? ????? ? (????????????) ????????????? ? ?????, ????????????, ????? (jobs), ???????????? ????????????????? ???? ? ???????????????.

?, ???????, ???????? ? ?????????? ?????? ???????????? ???????? ??????????? ?????????????? ??????? ? ?????????? ? ??????????? ?????????? ??????, ? ???? ????? ??? ODBC ? Oracle BI Web ????????? ??????????? ??????? ????, ????? ??? Business Objects, ???????? ?????? ? ?????? (??????????????) ??????? ????? Semantic Model.

???????????? ????????? ??????

??? ????? ??????????, ???????? ????? ?????????????? ??? Siebel Analytic Server ???? ????????????, ????????? ??? ????????, ??????????? ????????? ? ????? ?????? — ??????????, ??????? ?????? ??????. ? ???????? ??????, ????? ?? ?????????????? Siebel Analytics, ?? ??????????? ?????????? ? ???? ????? ?????? (Oracle, Microsoft SQL Server, IBM DB2), ?????????? ??????, ??????

??? ???????, ? ????? ??????????? ???? ??????? ? ????????????? (business and presentation layers (the «Enterprise Semantic Model»)) ? «Enterprise Semantic Model» ??? ????? ?????? ???????. ? ?????, ????? ???????????? ??????????? Analytic Server, ????????? ?????????? ???????, ?? «??????????» ?????? ????????????? ? ???? ??? ????????? ???????? ? ????? ?????? ?????????? ? ??????????????? ?????? ??????????. ???? ??? ? Analytic Server ???????????, ?????????? ????? ??????? ???????????? ? ??? ??? ????? ???????? ????????????? ? ???????????? ???????????? ????????????.

Siebel Analytic Server ? Oracle BI Analytic Server ???????????? ?????????? ?? ?????? ?????????? ??????. ??????????? ?????? ????? ???? ??????? ?? ????? ???? ?????? (? ??????????? ODBC-????????), ??????? Oracle, Microsoft SQL Server, IBM DB2 ? Teradata. Analytic Server ????? ???????????? ?????????? ? ?????????? ??????????? ?????? (???? ??????? MDX), ????? ??? Microsoft Analysis Services ? SAP Business Warehouse, ? ????? ? ???????? ? XML-??????????. ????? ?????? ?? ???? ?????????? ????????????? ? Analytic Server, ???????????? ????? ??????????????? ????????????? ????? ?????? ????????? ??????, ??????? ????? ???????? ???????? ?? ???????????? ?????????? ??????, ????????? ??????? ? ???? ? ?? ?? ??????? ?????? ? ????????? (fact and dimension objects).

????????????? ?????? ?????? ???????????

??? ? OracleBI Discoverer, ?????? Oracle BI Server ???????????? ?????? ????????????? ???????? ?????????? ??????-??????. ? Discoverer ??? ???????? ??? End User Layer, ? ? ???? ??????? ??? Enterprise Semantic Model.

??? Semantic Model ???????? ??? ????:

• ?????????? ????, ??????? ???????? ?????????? ? ?????????? ?????????? ??????, ????? ??????, ????????? ? ??????????? (primary and foreign) ????? ? ???????? ????? (row counts);
• ??????-????, ?????????? ????, ??????? ???????? ??????????? ????????? (dimensional constructs), ?????????? ???????, ??????? ?????????? ? ????????? ?
• ???? ????????????? — ??????????, ????????????????? ????????????? ??????, ? ??????? ????????? ? ??????????? ???????????? SQL?.

????????????? ?????? (Semantic Models) ???????? ? ????????????, ?????????? ?????????? ?? ???? ??????, ??????? ????? ???? ???????????? ??? ????????? (offline or online). ?? ????????????????? ??????????? ? ?????????????? ??????????? Administration tool ?????????? ????, ??? ???????????? OracleBI Discoverer Administrator.

?????????? ?????????????????

Analytic Server ? ? ??????????? Enterprise Semantic Model ???????????????? ? ?????????????? Administration Tool — Windows-??????????, ??????? ??????????? ? ???????????? ? online ??? offline ?????????.

Administration Tool ???????????? ??? ???? Enterprise Semantic Model ??? ??? ?????? (panes), ????????? ???? Presentation, Business Model and Mapping ? Physical layer ????? ???? ? ??????. ????????? ???? ??????????, ?? ?????? ????????? ? ?????? ????????????? ? ??????, ????????? ?? ?????????? (assign permissions), ????????? ????? ? ????????? ?????? ??????.

?????????? ???? — Physical Layer

?????????? ???? ????????????? ?????? ?????? ? ??????????? ???????????? ? ?????????? ??????, ?????? ? ??????????? ??????????? ?????? (physical data structures), ? ??????? ??? ???????????? ??????. ??? (?????????) ????? ???? ??????????? ??????????? ??????, OLAP ????? SQL-????????????? (views) ??? MDX-, XML-, ??? ????? ???????? ?????? ? ODBC ???????????. ? ? ?????????? ? ??????????? ? ???????? ??? ??????, ?????????? ???? ????? ???????????? ?????????? ? ERP- ? ?????? ???????????, ????? ??? Siebel CRM ??? Oracle E-Business Suite.

??????-???? — Business Layer

??????-???? ???????????? ??????? ?????????? ??? ??????????? ????????? ? ????????? ?????????????? ???????????? ?????? ? ?????????? ???????????? ??????? (logical subject areas). ????????? ?????????? (Drill paths) ????? ???? ??????????? ?????? ??????????? ????????? (dimensions) ? ??????????? (measures). ??? ????? ???????????? ?????????????? ??????????? ??????????? ?????????? (in-built calculation engine) ? ????????????? ???????.

???? ????????????? — Presentation Layer

???? ????????????? ??????????, ??? ???????? ???????????? ??????, ????? ??? ?????? ???????? ?????? ? OracleBI Answers. ??? ????? ???? ?????? ????? ?????? ? ??????-???? ??? ?????? ????????, ? ?? ?????? ????????? ??????? ? ??????????? (scoping), ??? ??? ????????? ???????????? ?????? ?????? ???? ??????.

????????? ????????

??? ???????? ????, ????? ?? ??????? ????? ?????????????? Oracle BI Server ???????? ????????????, ????????? ??? ????????, ??????? ????????? ??????? ? ????? ???????? ??????. ?? ???? ????? ?? ???????????, ??? ?????????? OLAP ???? ?????? ????? ????? ??? ?????????? OLAP-?????????? ? ???????; ?????????????????????? ??????????? ???? ??????, ????? ??? Oracle, ????? ????? ? ?????? ?? ????????????? ???????? ?????? ?, ????? ??? ????????, ?????? ??? ?????????? ?????? ?????????????? ??? ?????????, ? ?? ????????????? ??????. ????, ??????? ???? ?????? ??????, ??????????? ? ???, ??? ?? ????????? ?????? ? ?????????? ???????? ?? ??????????? ???????? (query tool) ? ????? ??????????? ???? ?????????? ?????? ? SQL (? MDX) ? ????? ???????? ??????. ????? ??? ???? ?????? ?????????? ???? ??????????, ????????????? ?????? ?????? ??????, ???? ?????, ????????? ??? ????????? ??????????, ??????????? ??? ?????? ? ?????????? ?? ??????????? ????????.

SQL-???????????, ??????? ???????????? ??? ?????? ???? ??????, ??????????????, ????? ??????????????? ?????????????? ????????? ?????? ???? ??????, ? ?? ?????? ????? ???????? ?????? ? ?????? ? ?????????????? ???????? (aggregate tables), ???? ?? ??????? ? ???????. ??? ????? ????????, ????????, ??? ?? ?????? ????? ?????????? ????????? ?? ????? ??????? ??????? ?????????????, ?? ?????????????? ?????? ? ???? ??????, ??????? ?? ?????? ???????????? ??? ?????? ??? ????????? ?????????? ? ??????? (query rewrite mechanism) ? ???? ?????? Oracle. ??? ??????????? ????? ????? ??????????????, ????? ?????? ?????????????? ??????? ????????????? ??????? SQL-????????????? ??? ?????????????? ???????????? (analytic workspace), ???? ????????? ????????????? ????? ???????? ??????. ????? ???????? ??????????? ? ???, ??? ??????? ????????????? ???????? ????????, ????????? ????? ???? ? ????? ???????? (?A day in the life of a query?) ?

????? ???? ? ????? ????????

???????????? ?????????????? ? OracleBI Answers ? ?????????? ??????. ???? ?????? ???????? ???????? ?????? ?? ????????? Products ? ??????????? (measures), ?????????????? ????? ?? ???????? ??????? (total closed revenue), ?????????? ???????? ?? ???????????? (numbers of service requests) ? ???? ?????? ?? ??????? (revenue share by brand).

???? ?????? ????? ??????????? ? ?????? ?logical SQL? ? ?????????? ?????????????? ???????.

??????, ??? ??????? ????????????? ??????, — ??? ???????? ????, ????? ??????????, ??? ?? ??? ??? ??????, ??????? ????????????? ???????? ???????.

??????? ?????????, ??????????????? ????????????????? ????????????? ? ?????????? ????????, ?????? ?? ???? ????? ???? ????????????, ???? ???? ??? ?? ????????????? ??????? ???????; ???????????? ???????????? ?????? ????? ??????????????, ??? ????? ??????????????. ?????????? (derivations) ????? ??????????????, ???? ??? ???????????? ?????? ???????, ??? ??????? ???????? ???????????.

???? ?? ??? ?? ????? ????????????? ??????, Navigator ?????????? ???? ?????? ? ?????? ??????? ??????? ?????? ?? ??? ?????? ??????????.

?????? ???, ??????? ????????? navigator, — ??? ??????????? ????, ??????? ?? ???????? ??????? ??????????? ???????, ?????? ??? OLAP-??????????. ???? ??, ?? ?????? ???????? ??? ????????? ??????, ? ?????? ???? ?? ???????? (OLAP-capable) ? ????? ?????????; ???? ?? ???????? ?? ???????? ? ??? (????????, ??? ???? ?????? ???? Microsoft Access ??? ????), ?? ?????????? ????? ????????? ?????? ?????????????? ???????. ? ????? ?????? ?????????? ???? ??????????? ???? ?????? (Revenue Share) ???????? ?????? ? ??? ????????? ?, ???? ? ???? ?????? ???? ?????? — Oracle, ?? ??? ??????????, ????????, ????? ???????? ??????? ???? ???? ?????? ??? ??????????.

??? ?????? ??????? ?????? ? ??????? ?? ???????? ??????? (closed revenue data) ????????? ? ???? ?????? ??????? ????? (general ledger), ? ?? ?? ????? ?????? ?? ???????????? (service request data) ????????? ? ???? ?????? ?????????? ?????? ???????????? (call centre application). ??????? ??????????? ???????????? (fragmentation optimization element) ?????????? ????? ?????????? ????????? ?????? ???????? ??????? ??????????????? ???????? ??????, ????????????? ???????? ??????? (fan traps), ???? ?????.

????? ????, ???? ?????? ?????? ????????? ? ????? ??? ????? ?????????, ?? ?????????? ?? ??????, ?? (?????????) ??????????? ????? ?? ?????? ?? ????? ?????????.

?????, navigator ????? ????????? ??????? ????????, ??????? ????????????? ? ????? ?????????????, ????? ??????, ????? ?? ?? ???????????? ?????? ?????????? ????????????? ?? ????????? ?????? (detail-level data) ??? ?????.

???????, ?????? ????????? ??????, ????? ???????????? ?????? (internal) ???????????????? ??????????, ???? ???????? ?????? ?? ????? ?? ?????????, ??? ????? ??????????? ????????? ??????? ???? ???????????????? ???? ?????????? ??????.

SQL- ? MDX- ???????????, ??????????????? ??? ????????? ????????, ?????????????? ??? ?????? ?? ???, ? ????????????? ?????????????? ??????? ????? ?????????? ??? ??????????? ????????? ??????? ??? ?????????? ????????, ??? ???, ????????, SQL-??????????? ? ?????????????? ????????? (analytic SQL) ????? ????????? ??? ?????????, ?????????????? ????? ???????, ????? ??? ????? ??????????.

?????, ??? ???????? ????????????? ??????, ?? ???????? ??????? ?????? ? ???????????? ???????, ??????? ???????????? ??? ?????????? Semantic Model.

?????? 1: ?????????? Semantic Model

? ???? ??????? ?? ????? ???????????? ????? ?????? Global Electronics, ??????? ?? ????? ????????? ?? ????????r. ???????, ?? ??????? ??????????? ???????, ?????????????? ??? ???????? ??? ??????????? ?????????????? ???????????? (Global analytic workspace) ? ???????? ??????, ???????? ??? ???????. ? ?????, ?? ??????? ??? ????????????? ???????????? ? ???????, ??? ????????? ?????? ? ???. ?

?????????? ? Oracle OLAP

?? ??? ???, ?????? ??? ?????????? Enterprise Semantic Model ??????? ?? ??????????? ?????? ? ???? ?????? Oracle, ??? ??????, ??????? ????????????? ???????? ?????? ??? Global analytic workspace. ? ????????? ???????????????, ??????, ???????? ????? ?? ????????????? ?????????? ?????? ? ??????? ???????? ???????????? (highly summarized data) ??? ??????, ? ???????? ??????? ???????, ??????????? ?????????? ??? ????????, ??, ????????, ??????????? ????? ???????????? ??????, ???????? ? OLAP Analytic Workspace. ?

?????? 2: ????????????? OLAP-??????

? ???? ??????? ?? ??????????, ??? Oracle BI Suite Enterprise Edition ????? ?????????????? ??? ??????? ? ?????? ? ????????????? ?????????????. ??? ???????????? ???????????? ????? ?????????? ??? ???????? ? ???????????? ?????? ??? ???????, ??? ??? ??? ???????? ?????? ????? ?? ??????, ?????????? ?????????? ??????? ? ??????????? ? ad-hoc ????????? ????? ??????????, ??? ??????????? ???????

?? ????? ???????????? Global Analytic Workspace ?? ?????? Global Sample Schema, ??????????? ??????? ?????????, ??????? ?? ???????????? ? ?????????? ???????. ??? Analytic Workspace ???????? ??? ?Units Cube?, ??????? ???????? ??????????? Product, Customer, Time ? Channel.

??? ??? ???????? ??? ???????????: Units, Sales ? Cost, ? ???? ????????? ????????? ???????? ????????? ????????, ??, ????? ?? ????????? ??????, ????? ???????????? ?????? ???? ???????? ??? ??????? ?????????.

? ??????? ?? OracleBI Discoverer Plus OLAP, Oracle BI Suite Enterprise Edition ?????? ?????? ? ????????????? ????????????? ? ?????????????? SQL views, ? ?? Java OLAP API. ?

????????????? Oracle BI Server ? Oracle Analytics Web

?????? ???? ???????? Semantic Model, ?? ????? ??????? Web-??????? ? ?????? ????????? ????????????? ?????????????? ?????? (interactive dashboards) ? ?????????????? OracleBI Answers ? OracleBI Dashboards, ???????????, ????????? ????? front-end ??????? Oracle BI Suite Enterprise Edition — Oracle Analytics Web. ?

??????????

Oracle BI Suite EE ? ??? ????? ??????? ????????????? ????????? Oracle, ??????? ???????? ?? ?????????? Siebel Analytics, ??????????? ? Oracle Fusion Middleware. ??? ???????? ?????????? ????????????? ??????, ?????????????? ?????????? ? ???????????? ?????? ?????? ? ????????????. ???? ?????? ???????? SQL-??????, ???????????? ???????? Semantic Model, ? ??????????? ??? ? SQL- ? MDX- ???????????, ???????????????? ??? ?????????? ????????. ?? ???????????? ???????????, OLAP-, XML- ? ?????? ????????? ?????? ???????? Enterprise Semantic Model, ?????????? ?????????? ????, ??????-???? ? ???? ?????????????.

Oracle Analytics Web ? ??? web-?????????? ????? ????????? BI Suite Enterprise Edition, ??? ???????? OracleBI Answers, Interactive Dashboards, Delivers, Disconnected Analytics ? Briefing Books. ????? Analytics Web ??? ??? ?????????? ????????? ?????????? ???????? ????????????, ??????????? ? ????? ????????????? (look and feel).

?c??????: http://www.oracle.com

Readers Comments (Комментариев нет)