Difference between revisions of "Data Warehousing"

From ScenarioThinking
Jump to navigation Jump to search
 
(12 intermediate revisions by the same user not shown)
Line 16: Line 16:
* Privacy laws
* Privacy laws
* Public resistance
* Public resistance
* Processing power


==Paradigms:==
==Paradigms:==
* not enough information versus too much information
* increasing ability to store all data versus increasing resistance from consumers to store all data
* technical capacity to store all the data versus technical capacity to analyze all the data


 
==Experts:==
==Experts:==
;Bill Inmon (William H. Inmon)
:is the recognized "father of data warehousing" and the co-creator of the Corporate Information Factory, and the Government Information Factory, as well as DW 2.0, the next-generation data warehouse architecture. Mr. Inmon has over 35 years of experience in database technology management and data warehouse design, and has consulted with Fortune 1000 clients and leading IT executives on Data Warehousing, Business Intelligence, and Database Management. He is known world-wide for his seminars on developing and managing data warehouses, and has been a keynote speaker for all of the major computing associations and vendors. In addition, Mr. Inmon is a key participant in many industry conferences, seminars, and tradeshows.[1]


;Ralph Kimball, PhD
:is a widely published author on the subject of data warehousing and business intelligence. He is known for long-term convictions that data warehouses must be designed to be understandable and fast. His methodology also known as dimensional modeling or the Kimball methodology is frequently used to allow sharing of conformed dimensions.[2]


==Timing:==
==Timing:==
'''late 1980s and early 1990s''' : Data Warehouses became a distinct type of computer database  
;1970
:the data-processing department was not able to handle huge backlogs of requests for data analyses. Applications data was hid behind mainframe files and databases, and it was periodically recorded in tapes for specific information manipulation.
 
;1980
:real computer applications were decentralized. DDBMS (distributed database management system) became a hit. But accessing data directly from the transactional databases did not work in real life, and “islands of data” were still a problem.
 
;1990
:data warehousing has become the most feasible solution to optimize and manipulate data. The current trend is to gather the data that is needed in an optimized database, regardless of the number of different applications and different platforms that are used to generate the source data
 
;2000
:The use of data warehouse technology has been widespread among Fortune 1000 companies for over 20 years However, the tools, expertise, and costs associated with a data warehouse have placed it well out of reach of most, if not all, small to mid-sized companies.


==Web Resources:==
==Web Resources:==
*Bill Inmon|William H. Inmon, Richard D. Hackathorn: ''Using the Data Warehouse'', John Wiley & Son's, ISBN 0-471-05966-8
* [http://en.wikipedia.org/wiki/Data_warehouse Wikipedia Date Warehouse page]
*Pyle, Dorian. ''Business Modeling and Data Mining''. Morgan Kaufmann, 2003. ISBN 1-55860-653-X
*Ralph Kimball, Margy Ross: ''The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)'', John Wiley & Sons, ISBN 0-471-20024-7
*Stephen Haag, Maeve Cummings, Donald J. McCubbery, Alain Pinsonneault, Richard Donvan:''Managements Information System for the Information Age'', Third Canadian Edition, McGraw-Hill Ryerson, ISBN 0-07-095569-7
* [http://infotech.wsu.edu/datawarehouse/ Information Technology Data Warehouse]
* [http://www.dwinfocenter.org/gotchas.html Data Warehousing Gotchas]
* [http://www.dwinfocenter.org/gotchas.html Data Warehousing Gotchas]
* [http://dmoz.org/Computers/Software/Databases/Data_Warehousing ODP - Data Warehouse Resources]
* [http://dmoz.org/Computers/Software/Databases/Data_Warehousing ODP - Data Warehouse Resources]
* [http://dmoz.org/Computers/Software/Databases/Data_Warehousing/Articles/ ODP - Data Warehouse Articles]
* [http://dmoz.org/Computers/Software/Databases/Data_Warehousing/Articles/ ODP - Data Warehouse Articles]
[1] http://en.wikipedia.org/wiki/Bill_Inmon
[2] http://en.wikipedia.org/wiki/Ralph_Kimball

Latest revision as of 21:20, 5 March 2007

<< back to 'Technological Driving Forces for the Future of Privacy'

Description:

With costs of data storage decreasing dramatically, storing information forever has become a reality. Companies and governments are now able to store as much information as they want for an unspecified time and data mine or retrieve this information at any given moment. For instance, Google will store all your search queries and offers an email service which has ben designed so that you never have to delete anything, and even if you delete it, it will still be stored on their servers.

Enablers:

Inhibitors:

  • Privacy laws
  • Public resistance
  • Processing power

Paradigms:

  • not enough information versus too much information
  • increasing ability to store all data versus increasing resistance from consumers to store all data
  • technical capacity to store all the data versus technical capacity to analyze all the data

Experts:

Bill Inmon (William H. Inmon)
is the recognized "father of data warehousing" and the co-creator of the Corporate Information Factory, and the Government Information Factory, as well as DW 2.0, the next-generation data warehouse architecture. Mr. Inmon has over 35 years of experience in database technology management and data warehouse design, and has consulted with Fortune 1000 clients and leading IT executives on Data Warehousing, Business Intelligence, and Database Management. He is known world-wide for his seminars on developing and managing data warehouses, and has been a keynote speaker for all of the major computing associations and vendors. In addition, Mr. Inmon is a key participant in many industry conferences, seminars, and tradeshows.[1]
Ralph Kimball, PhD
is a widely published author on the subject of data warehousing and business intelligence. He is known for long-term convictions that data warehouses must be designed to be understandable and fast. His methodology also known as dimensional modeling or the Kimball methodology is frequently used to allow sharing of conformed dimensions.[2]

Timing:

1970
the data-processing department was not able to handle huge backlogs of requests for data analyses. Applications data was hid behind mainframe files and databases, and it was periodically recorded in tapes for specific information manipulation.
1980
real computer applications were decentralized. DDBMS (distributed database management system) became a hit. But accessing data directly from the transactional databases did not work in real life, and “islands of data” were still a problem.
1990
data warehousing has become the most feasible solution to optimize and manipulate data. The current trend is to gather the data that is needed in an optimized database, regardless of the number of different applications and different platforms that are used to generate the source data
2000
The use of data warehouse technology has been widespread among Fortune 1000 companies for over 20 years However, the tools, expertise, and costs associated with a data warehouse have placed it well out of reach of most, if not all, small to mid-sized companies.

Web Resources:

[1] http://en.wikipedia.org/wiki/Bill_Inmon

[2] http://en.wikipedia.org/wiki/Ralph_Kimball