A Website where you can find everything about DBMS, Data Warehousing and Business Intelligence ….
Database Management Systems
A system whose overall purpose is to record and maintain information. A database is a repository for stored data and programs to manipulate it.
Advantages of DBMS
No Data Redundancy
Data can be shared
Standards can be enforced
Security can be enforced
Integrity can be maintained
Types of DBMS
Data is represented by a tree structure. Can not handle Many-Many relations, Can not reflect all real life situations, Anomalies in insert, delete and update operations. Network DBMS
Data is represented by records and pointers
Addresses Many-Many relations
Insert,delete,update operations possible
Complex in design Relational DBMS
Based on Relational Mathematics principles
Data is represented in terms of rows and columns of a table
Addresses all types of relations
Easy to design
No anomalies for insert/delete/update
A data warehouse is a subject-oriented, integrated, nonvolatile, time-variant collection of data in support of management’s decisions.
-by WH Inmon
A relational databse that is designed for query and analysis rather then transation processing. A datawarehouse usally contains historical data that is pulled from transactional data but i can be include data from other sources.
ETL(Extraction, Transformation and Loading) is a process by which data is integrated and transformed from the operational systems into the Data warehouse environment
Popular ETL Tools
■ PowerCenter Informatica – Company: Informatica
■ Oracle Warehouse Builder (OWB) – Company: Oracle
■ SAP Business Objects – Company: SAP
■ SQL Server Integration Services – Company: Microsoft
■ IBM Infosphere Information Server – Company: IBM
■ SAS Data Integration Studio – Company: SAS Institute
■ Talend Studio for Data Integration – Company: Talend
■ DataFlow Manager – Company: Pitney Bowes Business Insight
■ Pervasive Data Integrator – Company: Actian (Pervasive Software)
■ Open Text Integration Center – Company: Open Text
■ Oracle Data Integrator (ODI) – Company: Oracle
■ Data Manager/Decision Stream – Company: IBM (Cognos)
■ Clover ETL – Company: Javlin
■ Centerprise – Company: Astera
■ DB2 Infosphere Warehouse Edition – Company: IBM
■ Expressor Data Integration – Company: QlikTech
What is Informatica
Informatica provides an environment that can extract data from multiple sources, transform the data according to the business logic that is built in the Informatica Client application and load the transformed data into files or relational targets.
Business intelligence (BI)
Business intelligence is technique of collecting, gathering, sorting and analysing business data into meaningful and useful information for business.
Business intelligence software applications are used to provide current, historical and predictive views of internally structured data for products and departments by establishing more effective decision-making and strategic operational insights through functions like online analytical processing (OLAP), reporting, predictive analytics, data/text mining, benchmarking and Business Performance Management. Popular Business Intelligence Tools
■ QlikView ■ SAP BusinessObjects ■ IBM Cognos Series 10
■ Microsoft BI tools ■ MicroStrategy ■ SAS Enterprise BI Server
■ Oracle Enterprise BI Server (OBIEE) ■ JasperSoft
■ SAP NetWeaver BI ■ Oracle Hyperion System ■ BizzScore
■ Pentaho BI ■ Tableau Software
TipsToInterview.com can help you to Interview Questions with Answers on Following topics : (Click on link)TipsToInterview.com to help you design your resume. You resume is first impression on recruiter. Your resume needs to do an excellent job. TipsToInterview.com to help you get that sample resumes.