Data Warehousing and Data Mining

Data warehousing and data mining are all parts of the information systems.

Data warehousing is the process of storing data for a company that will later be useful and support decision making. It is basically a store of information that is no longer in use and is now historical, that does not mean that it won’t be needed in the future so it is stored. Previously in the past this information was physically stored in filing cabinets and boxes this took up a lot of space. These days the data is kept and backed up on computers, this cuts down on space mainly, you can store all that would take up a warehouse in one computers hard drive. This can also easily be printed of if needed and entered into a database for the different Information Systems to access. To access it will look for related queries in the old data compared to the new data. This will easily show trends and reoccurring things that are happening within a business aiding future productivity. For example data will be entered in with certain parameters like Male or Female, a user can then look up Male if that is what they want to add to there quire this then will show all the Male data, this is a set style. Often SQL is used to search for common themes in the information this will show if there is a problem or parts you can use to your advantage.

Data Mining is the process of looking at the data that you find. Looking in-depth into and analysing it to find patens and trends that can be used the company’s advantage.

These trends are like business picks up at Christmas so they know to keep prices competitive at Christmas and to order in a lot more stock so they can supply the demand, it will look at previous Christmas sales to see how much stock will be needed and forecast what the sales will be. It can also show the opposite like sales decrease during January so they should lower there prices in order to still shift units. Not only does it look at the sales but it can also look at customer habits and there buying trends. Tesco use this via a club card system, this allows them to see what each customer buys and prefers, so with this information they can tell what vouchers and offers to send to that pacific customer. So if they weekly spend £20 pounds in store then they know they could send them a voucher for ‘Spend over £30 and get £5 off’ this may convince the customer to spend more at the store and over time increase there weekly spending habit. Then Tesco will send out another voucher at a higher price increasing the spending habit once again, Brining in more profit.

Data is usually collected via an AI system, it learns what a customer will do and flag up its trends. Then learn to keep increasing the prices of vouchers for example. construction debris

Neural networks make connections within the data; it does this for itself using AI technology they are usually done by looking for similarities then matching them.

One part of data mining is data visualisation; this is where a large amount of data is shown in an image form. A great example of this would be a CT scan (Computed tomography scan) which creates a three dimensional image of the insides of an object kind of like a 3D X-ray. It works by scanning the object then manipulating it into an image this is a process called windowing. This 3d image can then be used to find cancerous cells or tumours.


Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>