From:
gaopengyulnfi
Views: 559
Comments: 0
OraDump-to-MySQL is a program to convert Oracle dump files into MySQL database. The program has easy-to-use wizard style interface and works with all versions of MySQL server
Searching for 1Z0-042 Free Practice Questions. The Oracle 1Z0-042 Free practice questions are provided by Pass-Guaranteed.com. Visit: www.pass-guaranteed.com to order the full product. Pass-Guaranteed.com offers 1Z0-042 Practice Exam Test Questions. (more)
Searching for 1Z0-042 Free Practice Questions. The Oracle 1Z0-042 Free practice questions are provided by Pass-Guaranteed.com. Visit: www.pass-guaranteed.com to order the full product. Pass-Guaranteed.com offers 1Z0-042 Practice Exam Test Questions. Pass-Guaranteed.com offers detailed 1Z0-042 practice questions that are compiled by Certification Experts, Certified Computer Trainers, Technical Coworkers and Senior Industry Professionals in today’s prospering companies and data centers all whom have a solid, verified and certified background in their respective field. Go to www.Pass-Guaranteed.com to download the full product! Still not convinced? Feel free to try our exam sample and see for yourself that Pass-Guaranteed.com offers the most comprehensive 1Z0-042 exam available on the market today! (less)
The onset of technology oriented business environment has not only paved way for an increased IT infrastructure, but has also increased the amount of data and information being stored. Applications and databases are designed to store a number of tra (more)
The onset of technology oriented business environment has not only paved way for an increased IT infrastructure, but has also increased the amount of data and information being stored. Applications and databases are designed to store a number of transactional records pertaining to the business of the organization. (less)
Data management is an insoluble issue as enterprises struggle to maintain stability in budgets due to the exponential rise in data. The growth of data is an inevitable event due to implementation of new innovations and techniques tofulfill the deman (more)
Data management is an insoluble issue as enterprises struggle to maintain stability in budgets due to the exponential rise in data. The growth of data is an inevitable event due to implementation of new innovations and techniques tofulfill the demands of customers. (less)
From:
estuate
Views: 120
Comments: 0
Estuate expertise in proven Oracle BI methodologies mitigates key risk factors from your business intelligence implementations. Estuate can redefine your BI strategy and deliver cost effective deployments and adoption.
Slide 1: Bussiness Intelligence and Data Warehouse
Tomas Bartos
CIS 764, Kansas State University
Slide 2: Schedule
●
Bussiness Intelligence (BI)
– –
BI tools Oracle vs. Microsoft History Tools Oracle vs. Others
●
Data warehouse
– – –
●
Discussion
Tomas Bartos CIS 764, Kansas State University
Slide 3: Business Intelligence (BI)
●
●
Products (technologies and applications) used for collecting, analyzing and interpreting data Main goals
– – –
analyze and report data qualified decisions improve bussiness processes
●
Real-time reports
Tomas Bartos CIS 764, Kansas State University
Slide 4: BI Prerequisites
● ● ●
Secure computer system Sufficient data capacity Plan for data retention
Tomas Bartos CIS 764, Kansas State University
Slide 5: BI tools
● ● ● ● ● ● ●
Data mining Dashboards OLAP (Online Analytical Processing) Reporting software BPM (Bussiness Performance Management) DSS (Decision Support System) Data Warehousing
Tomas Bartos CIS 764, Kansas State University
Slide 6: Oracle products
● ● ●
Oracle BI Standard Edition (SE) Oracle BI Standard Edition One Oracle BI Suite Enterprise Edition (EE) Plus
Tomas Bartos CIS 764, Kansas State University
Slide 7: Oracle BI tools
●
Business Intelligence Server
–
bussiness model and layer of abstraction accessing content of applications quering and analyzing tool reporting tool
Tomas Bartos CIS 764, Kansas State University
●
Business Intelligence Interactive Dashboards
–
●
Bussiness Intelligence Answers
–
●
Bussiness Intelligence Publisher
–
Slide 8: Oracle Dashboards
Tomas Bartos CIS 764, Kansas State University
Slide 9: Microsoft tools
●
SQL Server 2005 Integration Services
–
extracting and loading tools reporting tools data mining tools management tools
Tomas Bartos CIS 764, Kansas State University
●
SQL Server 2005 Reporting Services
–
●
SQL Server 2005 Analysis Services
–
●
SQL Server 2005 Management Studio
–
Slide 10: Microsoft
Tomas Bartos CIS 764, Kansas State University
Slide 11: Data Warehouse
● ● ●
Main storage of company`s data Material for DSS (Decision Support System) Formally defined by Bill Immon as:
– – – –
Subject-oriented Time-variant Non-volatile Integrated
Tomas Bartos CIS 764, Kansas State University
Slide 12: Data Warehouse Progress
● ● ● ●
Off line Operational Databases Off line Data Warehouse Real Time Data Warehouse Integrated Data Warehouse
Tomas Bartos CIS 764, Kansas State University
Slide 13: Data Warehouse tools
●
Database
–
Oracle, SQL Server, DB2… MOLAP (Multidimensional OLAP) ROLAP (Relational OLAP) HOLAP (Hybrid OLAP)
●
OLAP
– – –
● ●
ETL (Extract, Transform and Load) Reporting (presentation layer)
Tomas Bartos CIS 764, Kansas State University
Slide 14: Data Warehouse vs. Data mart
●
Data Warehouse
– –
collects all information from entire enterprise large smaller focused on specific task may be part of bigger data warehouse
●
Data mart
– – –
Tomas Bartos CIS 764, Kansas State University
Slide 15: Summary of Data Warehouse
●
●
●
Access to large amount of data Place for combination of data from different locations Create reports without slowing down operational systems
● ●
●
●
Extracting cost time Active managing is required Problems with compatibility Security problems (web access)
Tomas Bartos CIS 764, Kansas State University
Slide 16: Oracle Data Warehousing tools
●
Oracle Warehouse Builder
– – –
management, transformation, optimization design ETL processes more data sources supported optional to Oracle DB 11g Oracle Data Mining JDeveloper and SQL Developer Extensions
Tomas Bartos CIS 764, Kansas State University
●
Oracle Data Mining (ODM)
– –
●
Oracle OLAP
Slide 17: Other products
●
Microsoft
–
SQL Server 2005 Business Intelligence Development Studio DB2 Data Warehouse Edition SAP NetWeaver BI
●
IBM
–
●
SAP
–
Tomas Bartos CIS 764, Kansas State University
Slide 18: Web pages (references)
●
Oracle Business Intelligence Blog
http://oraclebi.blogspot.com
●
Practical Guide to Data Warehousing in Oracle
http://www.databasejournal.com/article.php/3304801
●
Bussiness Intelligence diagram
http://www.avanco.com/_assets/img/gfx-bi_diagram.gif
●
Oracle Business Intelligence EE Plus
http://www.oracle.com/technology/products/bi/enterpriseedition.html
Tomas Bartos CIS 764, Kansas State University
Slide 19: Web pages (references)
●
Data Warehousing
http://www.1keydata.com/datawarehousing/datawareho use.html
Tomas Bartos CIS 764, Kansas State University
Slide 20: Summary
●
Bussiness Intelligence
– – –
could improve bussiness processes summaries, reports, predictions many available commercial products information gathered from different data source (large size) performing complex queries no effect on performance of operational systems
Tomas Bartos CIS 764, Kansas State University
●
Data warehousing
–
– –
Slide 21: Discussion
Tomas Bartos CIS 764, Kansas State University
