Zamm
Data warehousing is more of a concept that a type of application. In broad terms, you load archived data into a separate database, often used for reporting or analytical processing. The difference is that many of the table relationships are 'de-normalized', ie you might store a customer's main address in the customer table, instead of in a normalized way, where the address would be in an Address table, where the customer might have many addresses. In addition, many totals fields, ie. are added to tables as 'redundant' fields, ie Order total wouldn't be calculated by reading all detail records, it would have it's own field in the order header. Since the data is static, these types of redundancies are always accurate and you don't need all sorts of triggers and update programs to keep them in sync as you would in an live transaction processing database.
This serves to make the reports run faster, since fewer tables are read to get the data needed, and also it allows management to have an easier time writing their own reports, since they don't need to know all the intricacies of joining tables.
This is only a very surface level look at it, but there is a Data Warehousing forum here.
Oh, and Access can be used for data warehousing, in fact I'm using it as an interem solution for a client right now--with about 10 .mdb files all stretched to close to the 1gig max, some containing just a single table. (This until the client waits for Oracle to drop prices!)
--Jim
Thanks for the valuable information. Now I have an overview of what Data warehousing is. Can you recommend me books or websites about datawarehousing using Access?
Zamm,
Sorry, I can't think of any books on DW in general offhand, nor any websites specific to Access as a datawarehouse tool. There probably aren't many sites about DW specific to Access, since typically you'll want to use a true dbms, such as DB2 or Oracle. SQL7 I'm sure is used for this, but as far as I know it hasn't reached the 'industrial strength' category of DB2 or Oracle.
There is a DW forum here at Tek-Tips, and one of the experts there might be able to point you in the right direction.
--Jim
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.