473,396 Members | 2,139 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Data Mart

What is Data Mart?
How does it help the data retrival process in terms of speed ?
Dec 17 '07 #1
2 2481
deepuv04
227 Expert 100+
What is Data Mart?
How does it help the data retrival process in terms of speed ?
In some data warehouse implementations, a data mart is a miniature data warehouse; in others, it is just one segment of the data warehouse. Data marts are often used to provide information to functional segments of the organization.


for more information visit'
http://msdn2.microsoft.com/en-us/library/aa905978(SQL.80).aspx
Dec 17 '07 #2
What is Data Mart?
How does it help the data retrival process in terms of speed ?
Hi there!
Actually a data mart is just a subset of a data warehouse... A single data mart typically represents a single business process. The data warehouse on the other hand is of course a collection of all those data marts, sharing/not sharing same/not same dimensions.

The analytical processing involve in a data mart is not that complex compare to a data warehouse, but it could vary actually, depending on the scale of the business process(es)
Feb 8 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Jeffrey Silverman | last post by:
First of all, I apologize for multiposting. I am now reposting and crossposting in an attempt to reach a broader audience. Here is the original posting... (with some small changes) I am tearing...
7
by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else...
0
by: Aashish | last post by:
Hi, I am currently working on building a real-time data mart. Am using DTS as the ETL tool and MS SQL 2000 as the database. The current infrastructure includes 2 4 Proc (1GHz) Xeon based servers,...
0
by: T-Bird | last post by:
Position Description: -Extensive hands-on experience with Informatica v 7 -Experience migrating data mart to new hardware infrastructure a major plus -Ability to document and set up UNIX file...
8
by: Anurag | last post by:
Hi, I am told that Oracle has this "data compression" feature that allows you to store online data ina compressed format. This is different from archived data - you compress only that data which...
4
by: Rob K. | last post by:
We have a DataMart (Approx 10GB) that is updated in batch at night. Is there a way that the database can be configured to be in a "Read Only" mode during the day? MS SQL offers this - improved...
2
by: Mart | last post by:
Hi, I need your advice for this. I would like to have an object that access the DataBase, let's name it objDB. This objDB object would be held by the MDI Parent. The MDI Child would use the...
4
by: power2005 | last post by:
Hi Experts I run into a problem I can't seem to be able to resolve or find the solution to. Basically I have a list of sample data as follow - Country Company ------- -------- US ...
3
by: ist | last post by:
Hi, I am trying to get (and transfer over ASP.NET) some encrypted data from some MySQL fields. Since the data contains many unicode characters, I tried to get the data as a series of ASCII...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.