Flux rss
They need your help
Business Intelligence

Data warehouse and datamart

Datamining
Bookmark Bookmark & Share
Datawarehouse e datamart Datawarehouse e datamart Datawarehouse und Datamart Datawarehouse et datamart Almacén de datos y tienda de datos

Data warehouse

The different data for the intelligence information system are stored intermediately in a place called data warehouse.

The data warehouse is therefore the only place where all enterprise data are consolidated. The creator of the Data Warehouse concept, Bill Inmon, defines it as follows: 

"A data warehouse is a collection of thematic,
integrated, non-volatile and historized data for decision-making."
Its main characteristics are therefore as follows:
  • The data warehouse is subject-oriented, this means that the data collected must be "business" oriented and therefore sorted by topic.
  • The data warehouse consists of integrated data, i.e. preliminary "cleaning" of the data is necessary to ensure rationalization and standardization.
  • The data of the data warehouse are non-volatile, which means that a datum entered into the warehouse remains there permanently and can not be suppressed.
  • The data of the data warehouse must be historized, i.e. dated.

Datamart

The term Datamart refers to a subentity of data warehouses containing the data of the data warehouse for a particular sector of the company (department, division, service, product line, etc.). For example, there is a DataMart Marketing, DataMart Commercial, etc.

Last update on Thursday October 16, 2008 02:43:20 PM.This document entitled « Data warehouse and datamart » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the licence, as this note appears clearly.

Data transmission - Cabling Cabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted... en.kioskea.net/contents/transmission/transcabl.php3
Data transmission - The physical connection What is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be... en.kioskea.net/contents/transmission/transliais.php3
OOP - Data encapsulation The concept of encapsulation Encapsulation is a way of organising data and methods into a structure by concealing the the way the object is implemented, i.e. preventing access to data by any means other than those specified. Encapsulation... en.kioskea.net/contents/poo/encapsul.php3
Incremental backup of data with .BAT (Batch)Incremental backup of data with .BAT (Batch) Use of incremental back up Example Use of incremental back up Incremental back up can be used to save your important data before you format your computer. During the first batch launch, all... en.kioskea.net/faq/sujet-1049-incremental-backup-of-data-with-bat-batch
[Ingres] Importing/ Exporting data[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main... en.kioskea.net/faq/sujet-964-ingres-importing-exporting-data
Formatting Your Hard DriveFormatting Your Hard Drive Formatting and installing your Hard drive using the installation CD ] A hard disk drive is a non-volatile device mainly for data storage. Usually faster than any other storage device, this essential... en.kioskea.net/faq/sujet-194-formatting-your-hard-drive
Results for Data warehouse and datamart
32GB Kingston data traveller (Solved)Hello, i pruchased a new 32GB kingston data traveller when it is inserted into usb it is displayed as remove write protect from dirive So kindly solve this problem en.kioskea.net/forum/affich-56034-32gb-kingston-data-traveller
Import webpage data into Excel spreadsheetHello, I am attempting to import the web page data from "http://bet1.hkjc.com/..." through EXCEL - new web query function but unsuccessful, the 'odds' data cannot be captured. Any idea? Thanks. en.kioskea.net/forum/affich-31834-import-webpage-data-into-excel-spreadsheet
Can't access data on my usb mass storageHello, I have a 500GB Western Digital usb mass storage device with lots of data on it, and I have been using it without problems for several months. Now when I plug it in, the drive comes up in my computer as drive E as it usually does, but when i... en.kioskea.net/forum/affich-31442-can-t-access-data-on-my-usb-mass-storage
Results for Data warehouse and datamart
Download Advanced TCP IP Data LoggerDescription: Advanced TCP/IP Data Logger will help you in your daily technical needs. You will be able to get information about your network and any device that is connected to it in real time. Features: You can send and receive serial data... en.kioskea.net/telecharger/telecharger-2970-advanced-tcp-ip-data-logger
Download Zilla Data NukerBy abolishing files or sensitive or contaminated files, it is possible that fragments stay on the hard disk. These rags can again harm your system if they are not correctly abolished. Zilla Data Nuker abolishes not used files which take of the place... en.kioskea.net/telecharger/telecharger-506-zilla-data-nuker
Download Data LoaderData Loader is a tool to convert databases. The software supports the following bases: MS-SQL, MySQL, Oracle, MS Access, FoxPro, DBF' S, CSV & Delimited Files. You can use the application to transfer the data from one base to another and vice versa.... en.kioskea.net/telecharger/telecharger-3095-data-loader
Results for Data warehouse and datamart
Sensors for combat helmets could gather blast dataA US soldier is seen on patrol south of Baghdad. The US Navy is developing sensors for combat helmets to measure the force of roadside explosions and gather data that might be useful in treating traumatic brain injury, a researcher said... en.kioskea.net/actualites/sensors-for-combat-helmets-could-gather-blast-data-10993-actualite.php3
Results for Data warehouse and datamart
Data transmission - IntroductionData representation The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to... en.kioskea.net/contents/transmission/transintro.php3
Data transmission - Analogue transmissionThe principles of analogue transmission Analogue data transmission consists of sending information over a physical transmission medium in the form of a wave. Data is transmitted via a carrier wave, a simple wave whose only purpose is to transport... en.kioskea.net/contents/transmission/transanalog.php3
Spreadsheets - Data EntryCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example... en.kioskea.net/contents/tableur/tabsaisie.php3
Results for Data warehouse and datamart