The above Architecture is taken from the www.databaseanswers.com . We would recommend you to visit this site to get good understanding towards data modeling.
Now we are goanna define each and every terminology in the above picture to facilitate better understanding of the subject.
1. Operational Data Store : is a database designed to integrate data from multiple sources for additional operations on the data. The data is then passed back to operational systems for further operations and to the data warehouse for reporting.
2. ERP : Enterprise resource planning integrates internal and external management information across an entire organization, embracing finance/accounting, manufacturing, sales and service, etc.
Its purpose is to facilitate the flow of information between all business functions inside the boundaries of the organization and manage the connections to outside stakeholders.
3. CRM : Customer relationship management is a widely-implemented strategy for managing a company’s interactions with customers, clients and sales prospects. It involves using technology to organize, automate, and synchronize business processes—principally sales activities, but also those for marketing, customer service, and technical support.
Customer relationship management describes a company-wide business strategy including customer-interface departments as well as other departments.
4. Flat Files In data Ware Housing : Flat Files Doesn’t Maintain referential Integrity like RDBMS and are Usually seperated by some delimiters like comma and pipes etcs.
Right from Informatica 8.6 unstructured data sources like Ms-word,Email and Pdf can be taken as source.
5. ETL (Extract,Transform, And load) :
is a process in database usage and especially in data warehousing that involves:
- Extracting data from outside sources
- Transforming it to fit operational needs (which can include quality levels)
- Loading it into the end target (database or data warehouse)
6. Data Marts: A data mart (DM) is the access layer of the data warehouse (DW) environment that is used to get data out to the users. The DM is a subset of the DW, usually oriented to a specific business line or team.
For the Definition of the Data Warehouse Please Refer to Introduction to the Data ware Housing.
7. OLAP : OLAP (Online Analytical Processing) is a methodology to provide end users with access to large amounts of data in an intuitive and rapid manner to assist with deductions based on investigative reasoning.
OLAP systems need to:
- Support the complex analysis requirements of decision-makers,
- Analyze the data from a number of different perspectives (business dimensions), and
- Support complex analyses against large input (atomic-level) data sets.
8. OLTP : Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.
9. Data Mining: Is the process of extracting patterns from large data sets by combining methods from statistics and artificial intelligence with database management. Data mining is seen as an increasingly important tool by modern business to transform data into business intelligence giving an informational advantage.
Dataware Housing is very nice look
ReplyDeleteNPO network planning and optimization
this is very nice and informative article. informatica training, informatica online training, informatica training in bangalore, informatica online training in bangalore
ReplyDeleteinformatica training, informatica online training, informatica training in bangalore, informatica online training in bangalore
Good post. I learn something totally new and challenging on blogs I stumble upon on a daily basis. It will always be interesting to read articles from other authors and practice something from their websites...
ReplyDeleteData warehousing Training in Chennai
I have read your blog and i got a very useful and knowledgeable information from your blog.You have done a great job .I feel happy to read your post, thanks for sharing your knowledge of sap with us keep posting with new concepts...
ReplyDeleteDataware Tools
HADOOP Training in Chennai
Base SAS Training in Chennai
MSBI Training in Chennai
INFORMATICA Training in Chennai
DATAWAREHOUSE Training in Chennai
I got a good answer from the above description,but it still requires some more update to be made. Please share more content on MSBI Online Training Hyderabad
ReplyDeleteThanks for Sharing this Valuable Information i like this i Can Share this with My Friend Circle.
ReplyDeleteData Warehousing Training in Noida
Thanks for sharing this valuable information and we collected some information from this blog.
ReplyDeleteData Warehousing Training in Noida
Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
ReplyDeleteArtificial Intelligence Certification Course
Java Certification Course
AWS Certification Course
Machine Learning Certification Course
Data Science Certification Course
DevOps Certification Course
Fiducia Solutions is an ISO certified institute providing course certifications to all its students. We, at Fiducia Solutions, see to it that the candidate is certified and entitled to bag a good position in acclaimed companies. We provide certificates that are valued, and our alumni reputation proves that we are good at what we offer.
ReplyDeleteAnd that is not all! We are known to provide 100% live project training and 100% written guaranteed placements to our students. That’s what makes us the best PHP/ HR/ Digital Marketing training institutes in Noida and Ghaziabad.
PHP Training Institute in Noida
HR Training Institute in Noida
Digital Marketing Training Institute in Noida
Android Training Institute in Noida
perde modelleri
ReplyDeletesms onay
mobil ödeme bozdurma
nft nasıl alınır
Ankara evden eve nakliyat
Trafik Sigortası
Dedektör
SİTE KURMAK
aşk kitapları
çekmeköy mitsubishi klima servisi
ReplyDeleteataşehir mitsubishi klima servisi
maltepe vestel klima servisi
maltepe bosch klima servisi
maltepe arçelik klima servisi
kartal samsung klima servisi
ümraniye samsung klima servisi
kartal mitsubishi klima servisi
ümraniye mitsubishi klima servisi
yurtdışı kargo
ReplyDeleteminecraft premium
lisans satın al
özel ambulans
uc satın al
en son çıkan perde modelleri
nft nasıl alınır
en son çıkan perde modelleri