The data extracted from diverse sources will have to be checked for integrity and will have to be cleaned and then loaded into warehouse for meaningful analysis. Therefore, harnessing efficient data cleaning and loading technologies (ETL—Extraction, Transformation and Loading) to warehousing system will be another objective of data warehouse. This process is known as Data Transformation service or Data preparation and staging.

The cleaned and stored data will have to be partitioned, summarized and stored for efficient query and analysis. Creating of subject oriented data marts, dimensional models of data and use of data mining technologies would follow, as next objective of data warehousing. This process is called Data Storage.

Finally tools necessary for query, analysis and reporting on data would have to be built into system to process to deliver a rich end user experience. This process is known as Data Presentation.

Users need to understand what rules applied while cleaning and transforming data before storage. This information needs to be stored separately in a relational database called Metadata.

Metadata is “data about data”. Mapping rules and maps between data sources and warehouse; Translation, transformation and cleaning rules; date and time stamps, system of origin, type of filtering, matching; Pre-calculated or derived fields and rules thereof are all stored in this database. In addition metadata database contains a description of data in data warehouse; navigation paths and rules for browsing data in data warehouse; data directory; list of pre-designed and built in queries available to users. For more visualization of this article along with screen shots and more visit http://www.exforsys.com/content/view/1295/332/

2. Don't Broadcast Your Signal

This is also an option in settings you go to from hard wired computer. To see an example, click here. As you can see, as outlined by a red box, there is an option to not allow router to "Broadcast" it's signal. If this box stayed in "Broadcast" position, then anyone with a wireless card in their computer within 300 feet could pick up on your signal and steal your internet connection.

This has happened to my friend who happens to live in an apartment complex. There are three signals available for him to use internet with, including his own. It's caused so much of a problem that now he can't even connect to his own router in his own house. So not only does this keep people from stealing your connection, it also helps to prevent any confusion or conflicts, especially in an apartment complex!

If you follow these steps to ensure a secure connection, then you can prevent someone from taking your internet connection!