Go Back   TechArena Community > General Discussion > Off Topic Chat
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 01-12-2010
Member
 
Join Date: Aug 2010
Posts: 62
Accessing data from Data Warehouse

I am a first year Bsc Student. Although there are five subjects in my upcoming semester, but there is one subject that attracts me the most , it is DBMS or you can call it as database management system. I am looking forward to study that subject and make it thorough from now on because I look myself as a Data Base Administrator. Yes there is a long path to walk ahead , for that I know I should be very strong with my basics, although the semester has not started yet I am thinking to do a bit of study myself , so I had some doubts regarding the data warehouse, can you please explain in brief how it helps in managing and accessing the data stored in it. I would be so glad if you share your ideas with me.
Reply With Quote
  #2  
Old 01-12-2010
Member
 
Join Date: May 2009
Posts: 258
Re: Accessing data from Data Warehouse

As the name suggests a data warehouse is also a warehouse , but here it does not store grains or eatables , but it is a repository of data been archived in the form of relational data. By relational data I mean in the tabular form where it can be retrieved easily by querying it. In earlier days the data was not stored in organized way, but in the data ware house , it is well organized , planned and tooled easily to meet the functional requirement of any organization and support in decision making
Reply With Quote
  #3  
Old 01-12-2010
Member
 
Join Date: May 2008
Posts: 2,293
Re: Accessing data from Data Warehouse

There were various problems connected with this conventional method, mostly the high costs included in data storage. In the presence of legacy systems architecture, a huge amount of redundancy was there which was the biggest hinge for the multiple decision support enterprises. So a process was required that could the process of gather, cleanse off the redundancy and integrate the whole data from various resources, this gave emergence to Data warehousing
Reply With Quote
  #4  
Old 01-12-2010
Member
 
Join Date: May 2008
Posts: 4,829
Re: Accessing data from Data Warehouse

Querying the data from the the database is known as Data mining, the most preferable tool to mine a data from a data base is an SQL query. Since we know that the data in a relational data base is stored in a tabular format. Then we can use SQL queries to retrieve data stored from those records. It stands for Structured Query Language and is normally designed to manage the data stored in a relational database. Its basic principal include to insert a data, to update it and to delete it from the data base. The records are being fetched on the basis of rows and columns. Select clause is the most common clause being used , for example if you want to fetch the record of the employee whose salary is more than 15000 then you can use the SELECT statement , in which you will mention the name column and the FROM clause will include the name of the table and the WHERE clause will include the condition
SELECT ename
FROM employee
WHERE salaray>15000
Reply With Quote
  #5  
Old 01-12-2010
Member
 
Join Date: Nov 2009
Posts: 747
Re: Accessing data from Data Warehouse

There are four features of a data warehouse, and the first is that the data ware house is subject oriented, it means that the data can be fetched on the base of any particular subject. Suppose if want to know the maximum sale of the month, then you can first lookout for your regular customer. The next feature of a data warehouse is that the data stored in the warehouse is in integrated format. Or you can say it is consistent, any changes made in the architecture does not harm the consistency of the data being stored in it and a data warehouse is non volatile and time variant.
Reply With Quote
Reply

  TechArena Community > General Discussion > Off Topic Chat
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Accessing data from Data Warehouse"
Thread Thread Starter Forum Replies Last Post
Restrict thief for accessing windows 7 personal data if laptop stolen Robert Beck Networking & Security 6 09-05-2011 10:10 AM
E72 - Remote Drives - Accessing Data On PC - Configuration? KAIRU26 Portable Devices 4 21-04-2010 01:38 PM
Accessing Linux from Windows drives to recover data Calum Operating Systems 5 26-03-2010 10:13 PM
How to design and setup data warehouse Kalanidhi Software Development 5 03-03-2010 02:00 AM
Windows xp get hang while accessing data Ximen Operating Systems 5 06-01-2009 10:23 PM


All times are GMT +5.5. The time now is 01:37 PM.