维's profile·°★.¸¸.´¯¤·._Freelyonlin...PhotosBlogListsMore Tools Help

Blog


    November 23

    Lost & Back

    钱包丢了,里面现金很少,卡片一大堆。
    “捡”到钱包的人给我发来电子邮件,不要我主动要给他的500元钱,但索“借”5万人民币。没有答应借他钱,他就不再联系我了。
    于是立刻报警、重办身份证及银行卡。然后,佯装答应借他钱,他竟信了并给了我他的帐号手机号。今日“捡”钱包者把钱包寄还给我。
    当然,我没有借他5万块钱。。。。
     
    我迷茫了,到底他坏还是我坏?
     
    谨以此帖献给我最近迷糊的状态。。。
    November 11

    恰恰

    今天上了一节拉丁课,课上的人基本都是像我差不多,身材一般的,没有hot的美女。

    老师更是长得很pp(pangpang)。。。可是虽然胖胖但是舞得很美,就把她当作我的目标吧~

    还有一个阿姨,感觉至少50+。略胖,但是骨架很小那种,穿拉丁舞鞋,一看就特专业,跳起来也真是很有气质很有感觉。

    至于我。。。今天才发现原来自诩擅长的恰恰原来是健美操改良的那种,今天老师跳的是国标恰恰:第一步要从第四拍起步的。。。搞得我手忙脚乱找不到节奏,郁闷。。。

    Anyway, 今天我算是运动了,hiahiaa~~~ 可恶的浩泰停车场开始收费也没拦住我想锻炼的热切心情(交了3块钱停车费 ^^)~~

    October 09

    joke

    发信人: Nowitzki41 (休赛期), 信区: Joke
    标  题: 北京市民举报;110的回复
    发信站: 水木社区 (Fri Oct  9 16:04:04 2009), 站内
     
    北京市民举报:110民警同志,
    2009年10月1日上午10时许,一辆牌照为京V02009的红旗牌轿车沿长安街逆向行驶,压双
    实线,违章掉头。其中一名乘客还将头伸出窗外,并在公共场所大声喧哗
     
    110警回复:
    您好,同志:经我所同志与交警大队调查核实,你反映的情况是真实的,但我们无法处
    置。对方人太多,飞机大炮坦克都带来了,核武器也有。手下有全球最大的社团,本所
    内部也大部分都是该社团人员,实在招惹不起,敬请保持围观姿态!
    October 01

    曲奇:烘培初来乍到

    家里的烤箱烤过培根卷和鸡翅,一直想尝试蛋糕和点心,一周前买了两本烘培书,。。虽然今天我限行,还是毅然决定去买材料。今天(昨天)在水母上问到一家淘宝实体店,下午开完会就冲过去采购了一堆早上上班时在出租车上想的单子上的东西。基本上我是照着曲奇、cheese cake和普通小圆蛋糕买的材料,晚上回家后决定做一个难度中等的最爱吃的曲奇。不能免俗,贴下做法和步骤吧,自娱自乐一下~~
     
    网上的配方:1、黄油130克砂糖35克糖粉65克鸡蛋1个;2、低筋粉200克香草粉5克。
    秤糖的时候感觉好多,于是擅自把砂糖降到25克,糖粉60克。后来由于面有一些浪费,所以很庆幸没有足量加进去那么多糖。
     
    上网看了一圈,做法都不是很一样,下面是自己的步骤和教训
    1,黄油化开打蛋器打开(第一次打着东西要悠着点,我把水槽上和身上都弄上不少油点)
    2,分两次加入砂糖,每次都要打蛋器打开。(打砂糖最让我没底,打了好久还是看到细细的小糖没有融化,后来证明其实没有关系)
    3,加入糖粉,打蛋器打开(这里很有成就感,眼看着盘里的东西性状发生改变,还蛮像那么回事)
    4,加入香草粉5克,打蛋器打开(也有说不用打,直接下一步的)。
    5,用筛子筛入低筋面粉,然后用小刮刀拌匀。(a.筛面的时候如果盆比筛子大不了太多,最好采用一只手拿着筛子向另一只手掌轻轻磕的方式筛面,如果两只手拿着那样摇晃,就会像我一样撒出去不少面粉。。。b.千万不要擅自加牛奶,我就是感觉这面糊好粘啊,就加了1/3小杯牛奶,结果虽然面糊好看了些,但最后烤的时候发现太软,都有点塌下去了)
    6,面糊装入挤花袋(挤花袋的制作也有学问,刚买来的那东西前面的口小,需要剪掉一些才能放入曲奇挤花头,挤花头的安装我是参考烘培书上的做法很成功),在烤盘上垫烘培纸然后排上小曲奇。烤箱预热10分钟(预热就是空转啦,我还在说明书上面找了半天预热按钮。。。汗,还是神奇的google让我知道了如何预热),然后上下火16/7分钟。到了十分钟的时候,我是感觉下面有点变色但上面没变色,于是就改成了上火加吹风,时间到了之后看上下都有一点点变色,挑了一个最丑的尝了一下,还不错 :D...
     
    上图:^^
    September 11

    越来越迷糊

    N多次把钥匙丢在门上,遭到批评。。。昨天煮咖啡忘了放滤纸、今天煮咖啡忘了放喷头。。。
    觉得每天的事情好多好多,做也做不完,看不到头,也不知道是工作的原因还是我的原因,sigh...
     
    好想做只树袋熊,每天只有吃叶子和睡觉两件事...
    July 26

    一个月了,还没搬进去

    自以为考虑周全、经验丰富的我们还是遇到了很多问题:厂家送错货、窗帘杆没装好、空调漏水。。。
    我们已经迫不及待地在啥都没有的家里住了好几天,再上点片子
    June 18

    俺们家地装修

    装修地差不多了,鸣谢俺老公辛勤地工作~~
    //blush
    灌几张照片,有的是拿手机拍的,效果不大好,目前进了家具,尚未装饰,一个月后全部搞定再到相册中加照片~~~
     
    March 18

    Manipulating CSV files (zz)

    Manipulating CSV files

    from http://weblogs.asp.net/fmarguerie/archive/2003/10/01/29964.aspx

    It doesn't seem to be well known that you can easily access data in CSV files (Comma-Separated Values) using ADO.NET components. For example, you can use the OleDbConnection, OleDbCommand, and OleDbDataAdapter objects to fill a DataSet from a CSV file. You can also update the data. Also notice that it is possible to use Visual Studio's Server Explorer to visualize or edit CSV files.

    All you need is to use the Jet engine thanks to a connection string like the following one:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TxtFilesFolder\;Extended Properties='text;HDR=Yes;FMT=Delimited'"

    Note: "HDR=Yes" indicates that the first row contains columnnames, not data (source: connectionstrings.com).

    Once you have a connection to a directory, you can refer to files as tables as follows:

    "SELECT * FROM data.txt"

    Hint: Think about JOINs if you need them...

    So, why not use ADO.NET's power to access CSV files instead of coding this all by yourself?

    Update: this post seems very popular, so I guess it's useful that I add two links about the Schema.ini file for more information:

    March 12

    A Brief History of Decision Support Systems (zz) -3

    VII. References

    Alavi, M., & Joachimsthaler, E. A., 揜evisiting DSS Implementation Research: A Meta-Analysis of the literature and suggestions for researchers,?MIS Quarterly, 16, 1, 1992, 95-116. Alter, S.L., "A Study of Computer Aided Decision Making in Organizations," Ph.D. dissertation, M.I.T., 1975. Alter, S.L., "Why Is Man-Computer Interaction Important for Decision Support Systems?", Interfaces, 7, 2, Feb. 1977, 109-115. Alter, S.L. Decision Support Systems: Current Practice and Continuing Challenge. Reading, MA: Addison-Wesley, 1980. Armstrong, M. P., Densham, P. J. and Rushton, G., 揂rchitecture for a microcomputer based spatial decision support system,?Second International Symposium on Spatial Data Handling, 120, 131 International Geographics Union, 1986. Arnott, D. and G. Pervan, "A critical analysis of decision support systems research", Journal of Information Technology, 20, 2, 2005, 67-87. Baskerville, R., and Myers, M., 揑nformation Systems as a Reference Discipline? MIS Quarterly, 26, 1, 2002, 1 -14. Berners-Lee, T., 揟he World Wide Web: Past, Present and Future,?August 1996, URL http://www.w3.org/People/Berners-Lee/1996/ppf.html, last accessed March 5, 2007. Bhargava, H. K., R. Krishnan and R. M黮ler, 揇ecision Support on Demand: Emerging Electronic Markets for Decision Technologies,'' Decision Support Systems, 19:3, pp. 193-214, 1997. Bhargava, H. and D. J. Power. Decision Support Systems and Web Technologies: A Status Report. Proceedings of the 2001 Americas Conference on Information Systems, Boston, MA, August 3 - 5, 2001. Bonczek, R. H., C.W. Holsapple, and A.B. Whinston. Foundations of Decision Support Systems, New York: Academic Press, 1981. Buchanan, B.G. and E.H. Shortliffe (eds.): Rule-Based Expert Systems: The MYCIN Experiments of the Stanford Heuristic Programming Project, 1984. Bui, T. X. and M. Jarke, "Communications Design for Co-op: A Group Decision Support System." ACM Transactions on Office Information Systems, 4 2, 1986, 81-103. Bush, V. "As We May Think", The Atlantic Monthly, 176, 1, July 1945, 101-108, http://www.theatlantic.com/unbound/flashbks/computer/bushf.htm Codd, E.F., S.B. Codd and C.T. Salley, "Providing OLAP (On-Line Analytical Processing) to User-Analysts: An IT Mandate", E.F. Codd and Associates, 1993 (sponsored by Arbor Software Corporation). Crossland, M. D., Wynne, B. E. and Perkins, W. C., 揝patial Decision Support Systems: An overview of technology and a test of efficacy,?Decision Support Systems, 14, 3, 1995, 219-235. Davis, G., Management Information Systems: Conceptual Foundations, Structure, and Development. New York: McGraw-Hill, Inc., 1974. DeSanctis, G. and R. B. Gallupe. "A Foundation for the Study of Group Decision Support Systems," Management Science, 33, 5, May 1987, 589 - 609. Dickson, G. W., M. S. Poole and G. DeSanctis. "An Overview of the GDSS Research Project and the SAMM System", in Bosttrom, R. P., R. T. Watson, and S. T. Kinney, Computer Augmented Teamwork: A Guided Tour, New York: Van Nostrand Reinhold, 1992, 163-179. Dhar, V. and R. Stein. Intelligent Decision Support Methods: The Science of Knowledge. Upper Saddle River, NJ: Prentice-Hall, 1997. Donovan, J.J. and S.E. Madnick. "Institutional and Ad Hoc DSS and Their Effective Use", Data Base, 8, 3, 1977. Engelbart, D.C., "Augmenting Human Intellect: A Conceptual Framework,?October 1962, Air Force Office of Scientific Research, AFOSR-3233, URL www.bootstrap.org/augdocs/friedewald030402/augmentinghumanintellect/ahi62index.html . Eom, S.B. and S. M. Lee. "DSS Applications Development Research: Leading Institutions and Most Frequent Contributors (1971-April 1988)," Decision Support Systems (6)3, 1990a, 269-275. Eom, H. B. and S.M. Lee., 揂 Survey of Decision Support System Applications (1971-April 1988),?Interfaces, 20, 3, 1990b, 65-79. Eom, S.B., Decision Support Systems Research (1970-1999), Lewiston, NY: Edwin Mellen Press, 2002. Fedorowicz, J. "A Technology Infrastructure for Document-Based Decision Support Systems", in Sprague, R. and H. J. Watson, Decision Support Systems: Putting Theory into Practice (Third Edition), Prentice-Hall, 1993, 125-136. Fedorowicz, J., "Document Based Decision Support" in Decision Support for Management, in R. Sprague Jr. and Hugh J Watson (eds.) Upper Saddle River, N.J.: Prentice-Hall, 1996. Ferguson, R. L. and C. H. Jones, "A Computer Aided Decision System," Management Science, 15, 10, 1969, B550-B562. Gerrity, T. P., Jr., Design of Man-Machine Decision Systems: An Application to Portfolio Management. Sloan Management Review, 12, 2, 1971, 59-75. Gorry, A. and M.S. Scott-Morton, 揂 Framework for Information Systems? Sloan Management Review, 13, 1, Fall 1971, 56-79. Goul, M., J.C. Henderson, J. C., and F.M. Tonge, 揟he emergence of Artificial Intelligence as a Reference Discipline for Decision Support Systems Research,?Decision Sciences, 23, 6, 1992, 1263-1276. Gray, P., "The SMU decision room project", Transactions of the Ist International Conference on Decision Support Systems (Atlanta, Ga.), 1981, pp. 122-129. Gray, P., Guide to IFPS (Interactive Financial Planning System), New York: McGraw-Hill Book Company, 1983. Hackathorn, R.D. and P.G.W. Keen, 揙rganizational Strategies for Personal Computing in Decision Support Systems,?MIS Quarterly, 5, 3, September 1981, 21-26. Holt, C. C. and G. P. Huber, "A Computer Aided Approach to Employment Service Placement and Counseling," 15, 11, 1969, 573-595. Holsapple, C. and A. Whinston, Decision Support Systems: A Knowledge-Based Approach, Minneapolis/St. Paul, MN: West Publishing, 1996. Houdeshel, G. and H. Watson, "The Management Information and Decision Support (MIDS) System at Lockheed-Georgia", MIS Quarterly, 11, 1, March 1987, 127-140. Huber, G. P., "Group decision support systems as aids in the use of structured group management techniques", Transactions of the 2nd International Conference on Decision Support Systems, 1982, 96-103. Joyner, R. and K. Tunstall, "Computer Augmented Organizational Problem Solving," Management Science, 17, 4, 1970, B212-226. Keen, P. G. W. and M. S. Scott Morton, Decision Support Systems: An Organizational Perspective. Reading, MA: Addison-Wesley, 1978. Keen, Peter G. W., "MIS Research: Reference Disciplines and Cumulative Tradition", in E. McLean, Proceedings of the First International Conference on Information Systems, Philadelphia, Pennsylvania, December 1980, 9-18. Kersten, G.E., "NEGO - Group Decision Support System", Information and Management, 8, 5, 1985, 237-246. Kreamer, K.L. and J. L. King, 揅omputer-based systems for cooperative work and group decision making,?ACM Computing surveys 20, 2, 1988, 115-146. Klein, M. and L. B. Methlie, Knowledge-based Decision Support Systems with Applications in Business. Chichester, UK: John Wiley & Sons, 1995. Little, J.D.C. and L.M. Lodish, "A Media Planning Calculus," Operations Research, 17, Jan.-Feb. 1969, 1-35. Little, J. D. C., "Models and Managers: The Concept of a Decision Calculus". Management Science, 16, 8, , April 1970, B466-485. Little, J. D. C., 揃randaid, an On-Line Marketing Mix Model, Part 2: Implementation, Calibration and Case Study,?Operations Research, 23, 4, 1975, 656-673. McCosh, A., 揅omments on 慉 Brief History of DSS??email to D. Power, Oct 3, 2002 at URL http://dssresources.com/history/dsshistory.html , last accessed March 10, 2007. McCosh, A. M. and B. A. Correa-Perez, "The Optimization of What?" in Gupta, J. G. Forgionne, and M. Mora, Intelligent Decision-making Support Systems: Foundations, Applications and Challenges, Springer-Verlag, 2006, 475-494. McCosh, A. M and Scott Morton, M. S., Management Decision Support Systems, London, Macmillan, 1978. Nunamaker, J. F., Jr., A. R. Dennis, J. F. George, W. B. Martz, Jr., J. S. Valacich, and D. R. Vogel, "GroupSystems" in Bosttrom, R. P., R. T. Watson, and S. T. Kinney, Computer Augmented Teamwork: A Guided Tour, New York: Van Nostrand Reinhold, 1992, 143-162. Nylund, A., "Tracing the BI Family Tree", Knowledge Management, July 1999. National Research Council ,Committee on Innovations in Computing and Communications, 揊unding a Revolution: Government Support for Computing Research,?1999,URL http://www.nap.edu/readingroom/books/far/contents.html Pendse, N., "Origins of today's OLAP products," The OLAP Report, URL www.olapreport.com, 1997. Power, D. J. "What is a DSS?". DSstar, The On-Line Executive Journal for Data-Intensive Decision Support, October 21, 1997: Vol. 1, No. 3. Power, D. J. "Web-based Decision Support Systems". DSstar, The On-Line Executive Journal for Data-Intensive Decision Support, August 18 and 25, 1998b: Vol. 2, Nos. 33 and 34. Power, D. J., 揂 History of Microcomputer Spreadsheets,?Communications of the Association for Information Systems, 4, 9, October, 2000, 154-162. Power, D. J., 揝upporting Decision-Makers: An Expanded Framework,?In Harriger, A. (Editor), e-Proceedings Informing Science Conference, Krakow, Poland, June 19-22, 2001, 431-436. Power, D. J., Decision Support Systems: Concepts and Resources for Managers, Westport, CT: Greenwood/Quorum, 2002. Power, D.J., 揂 Brief History of Decision Support Systems,?DSSResources.COM, World Wide Web, URL DSSResources.COM/history/dsshistory2.8.html, version 2.8, May 31, 2003. Power, D. J., 揇ecision Support Systems: From the Past to the Future,?Proceedings of the 2004 Americas Conference on Information Systems, New York, NY, August 6-8, 2004a, 2025-2031. Power, D. J., 揝pecifying an Expanded Framework for Classifying and Describing Decision Support Systems,?Communications of the Association for Information Systems, Vol. 13, Article 13, February 2004b, 158-166. Powell, R. 揇M Review: A 10 Year Journey? DM Review, February 2001, URL http://www.dmreview.com, last accessed March 10, 2001. Raymond, R.C., "Use of the Time-sharing Computer in Business Planning and Budgeting, Management Science, 12, 8, 1966, B363-381. Rockart, J. F. "Chief Executives Define Their Own Data Needs," Harvard Business Review, 67, 2 March-April 1979, 81-93. Rockart, J.F. and M.E. Treacy, 揟he CEO Goes On-Line,?Harvard Business Review, January-February, 1982, 82-88. Scott Morton, M. S., "Computer-Driven Visual Display Devices -- Their Impact on the Management Decision-Making Process," Doctoral Dissertaion, Harvard Business School, 1967. Scott Morton, M. S. and J. A. Stephens, 揟he impact of interactive visual display systems on the management planning process,?IFIP Congress, 2, 1968, 1178-1184. Scott Morton, M. S. and A. M. McCosh, "Terminal Costing for Better Decisions," Harvard Business Review, 46, 3, May-June 1968, 147?6. Scott Morton, M. S., Management Decision Systems; Computer-based support for decision making, Boston, Division of Research, Graduate School of Business Administration, Harvard University, 1971. Saaty, T., Decision Making for Leaders; the Analytical Hierarchy Process for Decisions in a Complex World, Wadsworth, Belmont, Calif., 1982. Sharda, R., S. Barr, and J. McDonnell, "Decision Support Systems Effectiveness: A Review and an Empirical Test, Management Science, 34, 2, 1988, 139-159. Silver, M.S., Systems that Support Decision Makers: Description and Analysis, New York: John Wiley & Sons, 1991. Simon, H.A., Administrative Behavior, New York, NY: Macmillan, 1947. Simon, H.A., The New Science of Management Decision, New York, NY: Harper and Row, 1960. Sprague, R. H., Jr. and H. J. Watson, "Bit by Bit: Toward Decision Support Systems", California Management Review, XXII, 1, Fall 1979, 60-68. Sprague, R, H., Jr., "A Framework for the Development of Decision Support Systems," Management Information Systems Quarterly, vol. 4, no. 4, Dec. 1980, pp. 1-26. Sprague, R. H., Jr. and E. D. Carlson. Building Effective Decision Support Systems. Englewood Cliffs, N.J.: Prentice-Hall, Inc.,1982. Swanson, E. B. and M. J. Culnan, "Document-Based Systems for Management Planning and Control: A Classification, Survey, and Assessment", MIS Quarterly, 2, 4, Dec. 1978, 31-46. Turban, E., "The Use of Mathematical Models in Plant Maintenace Decision Making," Management Science, 13, 6, 1967, B342-359. Turoff, M., 揇elphi Conferencing: Computer Based Conferencing with Anonymity,? Journal of Technological Forecasting and Social Change. 3, 2, 1970, 159-204. Turoff, M. and S. R. Hiltz, "Computer support for group versus individual decisions", IEEE Trans. Communications, COM-30, 1, 1982, 82-90. Urban, G.L., "SPRINTER: A Tool for New Products Decision Makers," Industrial Management Review, 8, 2, Spring 1967, 43-54. Watson, H., G., Houdeshel and R. K. Rainer, Jr., Building Executive Information Systems and other Decision Support Applications, New York: John Wiley, 1997.

    Appendix I. DSS Timeline

    Year

    Major Milestones

    1945

    Bush proposed Memex

    1947

    Simon book titled Administrative Behavior

    1952

    Dantzig joined RAND and continued research on linear programming

    1955

    Semiautomatic Ground Environment (SAGE) project at M.I.T. Lincoln Lab uses first light pen; SAGE completed 1962, first data-driven DSS

    1956

    Forrester started System Dynamics Group at the M.I.T. Sloan School

    1960

    Simon book The New Science of Management Decision; Licklider article on 揗an-Computer Symbiosis?o:p>

    1962

    Licklider architect of Project MAC program at M.I.T.; Iverson抯 book A Programming Language (APL); Engelbart's paper "Augmenting Human Intellect: A Conceptual?Framework"

    1963

    Englebart established Augmentation Research Center at SRI

    1965

    Stanford team led by Feigenbaum created DENDRAL expert system; Problem Statement Language/Problem Statement Analyzer (PSL/PSA) developed at Case Institute of Technology

    1966

    UNIVAC 494 introduced; Tymshare founded and Raymond article on computer time-sharing for business planning and budgeting

    1967

    Scott Morton抯 dissertation completed on impact of computer-driven visual display devices on management decision-making process; Turban reports national survey on use of mathematical models in plant maintenance decision making

    1968

    Scott Morton and McCosh article; Scott Morton and Stephens article; Englebart demonstrated hypermedia梘roupware system NLS (oNLine System) at Fall Joint Computer Conference in San Francisco

    1969

    Ferguson and Jones article on lab study of a production scheduling computer-aided decision system running on an IBM 7094; Little and Lodish MEDIAC, media planning model; Urban new product model-based system called SPRINTER

    1970

    Little article on decision calculus support system; Joyner and Tunstall article on Conference Coordinator computer software; IRI Express, a multidimensional analytic tool for time-sharing systems, becomes available; Turoff conferencing system

    1971

    Gorry and Scott Morton SMR article first published use of term Decision Support System; Scott Morton book Management Decision Systems; Gerrity article Man-Machine decision systems; Klein and Tixier article on SCARABEE

    1973

    PLATO Notes, written at the Computer-based Education Research Laboratory (CERL) at the University of Illinois by David R. Woolley

    1974

    Davis抯 book Management Information Systems; Meador and Ness article DSS application to corporate planning

    1975

    Alter completed M.I.T. Ph.D. dissertation "A Study of Computer Aided Decision Making in Organizations"; Keen SMR article on evaluating computer-based decision aids; Boulden book on computer-assisted planning systems

    1976

    Sprague and Watson article "A Decision Support System for Banks"; Grace paper on Geodata Analysis and Display System

    1977

    Alter article "A Taxonomy of Decision Support Systems", Klein article on Finsim; Carlson and Scott Morton chair ACM SIGBDP Conference DSS Conference

    1978

    Development began on Management Information and Decision Support (MIDS) at Lockheed-Georgia; Keen and Scott Morton book; McCosh and Scott Morton book; Holsapple dissertation completed; Wagner founded Execucom to market IFPS; Bricklin and Frankston created Visicalc (Visible Calculator) microcomputer spreadsheet; Carlson from IBM, San Jose plenary speaker at HICSS-11; Swanson and Culnan article document-based systems for management planning

    1979

    Rockart HBR article on CEO data needs

    1980

    Sprague MISQ article on a DSS Framework; Alter book; Hackathorn founded MicroDecisionware

    1981

    First International Conference on DSS, Atlanta, Georgia; Bonczek, Holsapple, and Whinston book; Gray paper on SMU decision rooms and GDSS

    1982

    Computer named the 揗an?of the Year by Time Magazine; Rockart and Treacy article 揟he CEO Goes On-Line?HBR; Sprague and Carlson book; Metaphor Computer Systems founded by Kimball and others from Xerox PARC; ESRI launched its first commercial GIS software called ARC/INFO; IFIP Working Group 8.3 on Decision Support Systems established

    1983

    Inmon Computerworld article on relational DBMS; IBM DB2 Decision Support database released; Student Guide to IFPS by Gray; Huntington established Exsys; Expert Choice software released

    1984

    PLEXSYS, Mindsight and SAMM GDSS; first Teradata computer with relational database management system shipped to customers Wells Fargo and AT&T; MYCIN expert system shell explained

    1985

    Procter & Gamble use first data mart from Metaphor to analyze data from checkout-counter scanners; Whinston founded Decision Support Systems journal; Kersten developed NEGO

    1987

    Houdeshel and Watson article on MIDS; DeSanctis and Gallupe article on GDSS; Frontline Systems founded by Fylstra, marketed solver add-in for Excel

    1988

    Turban DSS textbook; Pilot Software EIS for Balanced Scorecard deployed at Analog Devices

    1989

    Gartner analyst Dresner coins term business intelligence; release of Lotus Notes; International Society for Decision Support Systems (ISDSS) founded by Holsapple and Whinston

    1990

    Inmon book Using Oracle to Build Decision Support Systems; Eom and Lee co-citation analysis of DSS research 1971?988

    1991

    Inmon books Building the Data Warehouse and Database Machines and Decision Support Systems; Berners-Lee抯 World Wide Web server and browser, become publicly available

    1993

    Codd et al. paper defines online analytical processing (OLAP)

    1994

    HTML 2.0 with form tags and tables; Pendse抯 OLAP Report project began

    1995

    The Data Warehousing Institute (TDWI) established; DSS journal issue on Next Generation of Decision Support; Crossland, Wynne, and Perkins article on Spatial DSS; ISWorld DSS Research pages and DSS Research Resources

    1996

    InterNeg negotiation software renamed Inspire; OLAPReport.com established;

    1997

    Wal-Mart and Teradata created then world抯 largest production data warehouse at 24 Terabytes (TB)

    1998

    ACM First International Workshop on Data Warehousing and OLAP

    1999

    DSSResources.com domain name registered

    2000

    First AIS Americas Conference mini-track on Decision Support Systems

    2001

    Association for Information Systems (AIS) Special Interest Group on Decision Support, Knowledge and Data Management Systems (SIG DSS) founded

    2003

    International Society for Decision Support Systems (ISDSS) merged with AIS SIG DSS

    Author Profile

    Daniel J. Power is a Professor of Information Systems and Management at the College of Business Administration at the University of Northern Iowa, Cedar Falls, Iowa and the editor of DSSResources.COM, the Web-based knowledge repository about computerized systems that support decision making, the editor of PlanningSkills.COM, and the editor of DSS News, a bi-weekly e-newsletter. Dan writes the column "Ask Dan!" in DSS News.

    Dr. Power's research interests include the design and development of Decision Support Systems and how DSS impact individual and organizational decision behavior.?Since 1982, Power has published more than 40 articles, book chapters and proceedings papers. He was founding Chair of the Association for Information Systems Special Interest Group on Decision Support, Knowledge and Data Management Systems (SIG DSS).


    Thanks for visiting. If you have any suggestions for improving this brief history of DSS, I'd like to hear from you. I'm trying to collect retrospective reports for my "Brief History of Decision Support Systems" hypertext document at DSSResources.COM. I'm including recollections, reflections and comments of those involved in the various DSS "threads" and I'm trying to correct any errors of omission or misinterpretation.

    How to cite

    A Brief History of Decision Support Systems should be cited as:

    Power, D.J. A Brief History of Decision Support Systems. DSSResources.COM, World Wide Web, http://DSSResources.COM/history/dsshistory.html, version 4.0, March 10, 2007.

    A Brief History of Decision Support Systems (zz) -2

    IV. DSS Applications Development

    Beginning in about 1980 many activities associated with building and studying DSS occurred in universities and organizations that resulted in expanding the scope of DSS applications. These actions also expanded the field of decision support systems beyond the initial business and management application domain. These diverse systems were all called Decision Support Systems. From those early days, it was recognized that DSS could be designed to support decision-makers at any level in an organization. Also, DSS could support operations decision making, financial management and strategic decision-making.

    A literature survey and citation studies (Alavi & Joachimsthaler, 1990, Eom & Lee, 1990a, Eom, 2002, Arnott & Pervan, 2005) suggest the major applications for DSS emphasized manipulating quantitative models, accessing and analyzing large data bases, and supporting group decision making. Much of the model-driven DSS research emphasized use of the systems by individuals, i.e., personal DSS, while data-driven DSS were usually institutional, ad hoc or organizational DSS. Group DSS research emphasized impacts on decision process structuring and especially brainstorming.

    The discussion in this section follows the broad historical progression of DSS research. The first subsection examines model-driven DSS, then the focus turns to data-driven DSS and executive information systems and notes the growing prominence of such systems beginning in the late 1980s. The origins of communications-driven DSS are then briefly explored and the bifurcation into two types of group DSS, model-driven and communications-driven. Developments in document storage technologies and search engines then made document-driven DSS more widely available as web-based systems. The last subsection summarizes major developments in Artificial Intelligence (AI) and expert systems that made suggestion or knowledge-driven DSS practical.

    IV.1 Model-driven DSS

    Scott-Morton抯 (1971) production planning management decision system was the first widely discussed model-driven DSS, but Ferguson and Jones?(1969) production scheduling application was also a model-driven DSS. Many of the early decision systems mentioned in section 2, e.g., Sprinter, MEDIAC and Brandaid, are probably model-driven DSS.

    A model-driven DSS emphasizes access to and manipulation of financial, optimization and/or simulation models. Simple quantitative models provide the most elementary level of functionality. Model-driven DSS use limited data and parameters provided by decision makers to aid decision makers in analyzing a situation, but in general large data bases are not needed for model-driven DSS (Power, 2002). Early versions of model-driven DSS were called model-oriented DSS by Alter (1980), computationally oriented DSS by Bonczek, Holsapple and Whinston (1981) and later spreadsheet-oriented and solver-oriented DSS by Holsapple and Whinston (1996).

    The first commercial tool for building model-driven DSS using financial and quantitative models was called IFPS, an acronym for interactive financial planning system. It was developed in the late 1970's by Gerald R. Wagner and his students at the University of Texas. Wagner抯 company, EXECUCOM Systems, marketed IFPS until the mid 1990s. Gray抯 Guide to IFPS (1983) promoted the use of the system in business schools. Another DSS generator for building specific systems based upon the Analytic Hierarchy Process (Saaty, 1982), called Expert Choice, was released in 1983. Expert Choice supports personal or group decision making. Ernest Forman worked closely with Thomas Saaty to design Expert Choice.

    In 1978, Dan Bricklin and Bob Frankston co-invented the software program VisiCalc (Visible Calculator). VisiCalc provided managers the opportunity for hands-on computer-based analysis and decision support at a reasonably low cost.?VisiCalc was the first "killer" application for personal computers and made possible development of many model-oriented, personal DSS for use by managers. The history of microcomputer spreadsheets is described in Power (2000). In 1987, Frontline Systems founded by Dan Fylstra marketed the first optimization solver add-in for Microsoft Excel.

    In a 1988 paper, Sharda, Barr, and McDonnell reviewed the first 15 years of model-driven DSS research. They concluded that research related to using models and financial planning systems for decision support was encouraging but certainly not uniformly positive. As computerized models became more numerous, research focused on model management and on enhancing more diverse types of models for use in DSS such as multicriteria, optimization and simulation models.

    The idea of model-driven spatial decision support system (SDSS) evolved in the late 1980抯 (Armstrong, Densham, and Rushton., 1986) and by 1995 the SDSS concept had become firmly established in the literature (Crossland, Wynne, and Perkins, 1995). Data-driven spatial DSS are also common.

    IV.2 Data-driven DSS

    In general, a data-driven DSS emphasizes access to and manipulation of a time-series of internal company data and sometimes external and real-time data. Simple file systems accessed by query and retrieval tools provide the most elementary level of functionality. Data warehouse systems that allow the manipulation of data by computerized tools tailored to a specific task and setting or by more general tools and operators provide additional functionality. Data-Driven DSS with On-line Analytical Processing (cf., Codd et al., 1993) provide the highest level of functionality and decision support that is linked to analysis of large collections of historical data. Executive Information Systems are examples of data-driven DSS (Power, 2002). Initial examples of these systems were called data-oriented DSS, Analysis Information Systems (Alter, 1980) and retrieval-only DSS by Bonczek, Holsapple and Whinston (1981).

    One of the first data-driven DSS was built using an APL-based software package called AAIMS, An Analytical Information Management System. It was developed from 1970-1974 by Richard Klaas and Charles Weiss at American Airlines (cf. Alter, 1980).

    As noted previously, in 1979 John Rockart抯 research stimulated the development of executive information systems (EIS) and executive support systems (ESS). These systems evolved from single user model-driven decision support systems and from the development of relational database products. The first EIS used pre-defined information screens maintained by analysts for senior executives. For example, in the Fall of 1978, development of an EIS called Management Information and Decision Support (MIDS) system began at Lockheed-Georgia (cf., Houdeshel and Watson, 1987).

    The first EIS were developed in the late 1970s by Northwest Industries and Lockheed 搘ho risked being on the 慴leeding edge?of technology ? Few even knew about the existence of EIS until John Rockart and Michael Treacy抯 article, 慣he CEO Goes On-line,?appeared in the January-February 1982 issue of the Harvard Business Review. (Watson, Houdeshel and Rainer, 1997, p. 6)?Watson and colleagues. further note 揂 major contributor to the growth of EIS was the appearance of vendor-supplied EIS software in the mid-1980s. Pilot Software抯 Command Center and Comshare抯 Commander EIS made it much easier for firms to develop an EIS by providing capabilities for (relatively) easy screen design, data importation, user-friendly front ends, and access to news services. (p. 6)?In a related development in 1984, Teradata抯 parallel processing relational database management system shipped to customers Wells Fargo and AT&T.

    In about 1990, data warehousing and On-Line Analytical Processing (OLAP) began broadening the realm of EIS and defined a broader category of data-driven DSS (cf., Dhar and Stein, 1997). Nigel Pendse (1997), author of the OLAP Report, claims both multidimensional analysis and OLAP had origins in the APL programming language and in systems like Express and Comshare抯 System W. Nylund (1999) traces the developments associated with Business Intelligence (BI) to Procter & Gamble抯 efforts in 1985 to build a DSS that linked sales information and retail scanner data. Metaphor Computer Systems, founded by researchers like Ralph Kimball from Xerox抯 Palo Alto Research Center (PARC), built the early P&G data-driven DSS. Staff from Metaphor later founded many of the Business Intelligence vendors: The term BI is a popularized, umbrella term coined and promoted by Howard Dresner of the Gartner Group in 1989. It describes a set of concepts and methods to improve business decision making by using fact-based support systems. BI is sometimes used interchangeably with briefing books, report and query tools and executive information systems. In general, business intelligence systems are data-driven DSS.

    Bill Inmon and Ralph Kimball actively promoted decision support systems built using relational database technologies. For many Information Systems practitioners, DSS built using Oracle or DB2 were the first decision support systems they read about in the popular computing literature. Ralph Kimball was "The Doctor of DSS" and Bill Inmon was the "father of the data warehouse? By 1995, Wal-Mart抯 data-driven DSS had more than 5 terabytes of on-line storage from Teradata that expanded to more than 24 terabytes in 1997. In more recent years, vendors added tools to create web-based dashboards and scorecards.

    IV.3 Communications-driven DSS

    Communications-driven DSS use network and communications technologies to facilitate decision-relevant collaboration and communication. In these systems, communication technologies are the dominant architectural component. Tools used include groupware, video conferencing and computer-based bulletin boards (Power, 2002).

    Engelbart's 1962 paper "Augmenting Human Intellect: A Conceptual?Framework" is the anchor for much of the later work related to communications-driven DSS. In 1969, he demonstrated the first hypermedia/groupware system NLS (oNLine System) at the Fall Joint Computer Conference in San Francisco. Engelbart invented the both the computer mouse and groupware.

    Joyner and Tunstall抯 article (1970) reporting ?/span>testing of their Conference Coordinator computer software is the first empirical study in this research area. Murray Turoff抯 (1970) article introduced the concept of Computerized Conferencing. He developed and implemented the first Computer Mediated Communications System (EMISARI) tailored to facilitate group communications.

    In the early 1980s, academic researchers developed a new category of software to support group decision-making called Group Decision Support Systems abbreviated GDSS ?/span>(cf., Gray, 1981; Huber, 1982; Turoff and Hiltz, 1982). Mindsight from Execucom Systems, GroupSystems developed at the University of Arizona and the SAMM system developed by University of Minnesota researchers were early Group DSS.

    Eventually GroupSystems matured into a commercial product. Jay Nunamaker, Jr. and his colleagues wrote in 1992 that the underlying concept for GroupSystems had its beginning in 1965 with the development of Problem Statement Language/Problem Statement Analyzer at Case Institute of Technology. In 1984, the forerunner to GroupSystems called PLEXSYS was completed and a computer-assisted group meeting facility was constructed at the University of Arizona. The first Arizona facility, called the PlexCenter, housed a large U-shaped conference table with 16 computer workstations.

    On the origins of SAMM, Dickson, Poole and DeSanctis (1992) report that Brent Gallupe, a Ph.D. student at the University of Minnesota, decided in 1984 "to program his own small GDSS system in BASIC and run it on his university抯 VAX computer".

    DeSanctis and Gallup (1987) defined two types of GDSS. Basic or level 1 GDSS are systems with tools to reduce communication barriers, such as large screens for display of ideas, voting mechanisms, and anonymous input of ideas and preferences. These are communications-driven DSS. Advanced or level 2 GDSS provide problem-structuring techniques, such as planning and modeling tools. These are model-driven group DSS. Since the mid-1980s, many research studies have examined the impacts and consequences of both types of group DSS. Also, companies have commercialized model-driven group DSS and groupware.

    Kersten (1985) developed NEGO, a computerized group tool to support negotiations.?Bui and Jarke (1986) reported developing Co-op, a system for cooperative multiple criteria group decision support. Kraemer and King (1988) introduced the concept of Collaborative Decision Support Systems (CDSSs). They defined them as interactive computer-based systems to facilitate the solution of ill-structured problems by a set of decision makers working together as a team.

    In 1989, Lotus introduced a groupware product called Notes and broadened the focus of GDSS to include enhancing communication, collaboration and coordination among groups of people. Notes had its roots in a product called PLATO Notes, written at the Computer-based Education Research Laboratory (CERL) at the University of Illinois in 1973 by David R. Woolley.

    In general, groupware, bulletin boards, audio and videoconferencing are the primary technologies for communications-driven decision support. In the past few years, voice and video delivered using the Internet protocol have greatly expanded the possibilities for synchronous communications-driven DSS.

    IV.4 Document-driven DSS

    A document-driven DSS uses computer storage and processing technologies to provide document retrieval and analysis. Large document databases may include scanned documents, hypertext documents, images, sounds and video. Examples of documents that might be accessed by a document-driven DSS are policies and procedures, product specifications, catalogs, and corporate historical documents, including minutes of meetings and correspondence. A search engine is a primary decision-aiding tool associated with a document-driven DSS (Power, 2002). These systems have also been called text-oriented DSS (Holsapple and Whinston,1996).

    The precursor for this type of DSS is Vannevar Bush抯 (1945) article titled "As We May Think". Bush wrote "Consider a future device for individual use, which is a sort of mechanized private file and library. It needs a name, and to coin one at random, ?span class=SpellE>memex?will do? Bush抯 memex is a much broader vision than that of today抯 document-driven DSS.

    Text and document management emerged in the 1970s and 1980s as an important, widely used computerized means for representing and processing pieces of text (Holsapple and Whinston, 1996). The first scholarly article for this category of DSS was written by Swanson and Culnan (1978). They reviewed document-based systems for management planning and control. Until the mid-1990s little progress was made in helping managers find documents to support their decision making. Fedorowicz (1993, 1996) helped define the need for such systems. She estimated in her 1996 article that only 5 to 10 percent of stored business documents are available to managers for use in decision making. The World-wide web technologies significantly increased the availability of documents and facilitated the development of document-driven DSS.

    IV.5 Knowledge-driven DSS

    Knowledge-driven DSS can suggest or recommend actions to managers. These DSS are person-computer systems with specialized problem-solving expertise. The "expertise" consists of knowledge about a particular domain, understanding of problems within that domain, and "skill" at solving some of these problems (Power, 2002). These systems have been called suggestion DSS (Alter, 1980) and knowledge-based DSS (Klein & Methlie, 1995). Goul, Henderson, and Tonge (1992) examined Artificial Intelligence (AI) ?/span>contributions to DSS.

    In 1965, a Stanford University research team led by Edward Feigenbaum created the DENDRAL expert system. DENDRAL led to the development of other rule-based reasoning programs including MYCIN, which helped physicians diagnose blood diseases based on sets of clinical symptoms. The MYCIN project resulted in development of the first expert-system shell (Buchanan and Shortliffe, 1984).

    Bonczek, Holsapple and Whinston抯 (1981) book created interest in using these technologies for DSS. In 1983, Dustin Huntington established EXSYS. That company and product made it practical to use PC based tools to develop expert systems. By 1992, some 11 shell programs were available for the MacIntosh platform, 29 for IBM-DOS platforms, 4 for Unix platforms, and 12 for dedicated mainframe applications (National Research Council, 1999). Artificial Intelligence systems have been developed to detect fraud and expedite financial transactions, many additional medical diagnostic systems have been based on AI, expert systems have been used for scheduling in manufacturing operation and web-based advisory systems. In recent years, connecting expert systems technologies to relational databases with web-based front ends has broadened the deployment and use of knowledge-driven DSS.

    V. Web-based DSS

    Beginning in approximately 1995, the World-wide Web and global Internet provided a technology platform for further extending the capabilities and deployment of computerized decision support. The release of the HTML 2.0 specifications with form tags and tables was a turning point in the development of web-based DSS. In 1995, a number of papers were presented on using the Web and Internet for decision support at the 3rd International Conference of the International Society for Decision Support Systems (ISDSS). In addition to Web-based, model-driven DSS, researchers were reporting Web access to data warehouses. DSS Research Resources was started as a web-based collection of bookmarks. By 1995, the World-Wide Web (Berners-Lee, 1996) was recognized by a number of software developers and academics as a serious platform for implementing all types of Decision Support Systems (cf., Bhargava & Power, 2001).

    In November 1995, Power, Bhargava and Quek submitted the Decision Support Systems Research page for inclusion in ISWorld. The goal was to provide a useful starting point for accessing Web-based material related to the design, development, evaluation, and implementation of Decision Support Systems. Nine months later, a DSS/WWW Workshop organized by Power and Quek was held as part of the IFIP Working Group 8.3 Conference on 揑mplementing Systems for Supporting Management Decisions: Concepts, Methods and Experiences? July 21-24, 1996 in London, UK.

    In 1996-97, corporate intranets were developed to support information exchange and knowledge management. The primary decision support tools included ad hoc query and reporting tools, optimization and simulation models, online analytical processing (OLAP), data mining and data visualization (cf., Powell, 2001). Enterprise-wide DSS using database technologies were especially popular in Fortune 2000 companies (Power, 1997). Bhargava, Krishnan and M黮ler (1997) continued to discuss and experiment with electronic markets for decision technologies.

    In 1999, vendors introduced new Web-based analytical applications. Many DBMS vendors shifted their focus to Web-based analytical applications and business intelligence solutions. In 2000, application service providers (ASPs) began hosting the application software and technical infrastructure for decision support capabilities. 2000 was also the year of the portal. More sophisticated "enterprise knowledge portals" were introduced by vendors that combined information portals, knowledge management, business intelligence, and communications-driven DSS in an integrated Web environment (cf., Bhargava and Power, 2001).

    Power (1998) defined a Web-based decision support system as a computerized system that delivers decision support information or decision support tools to a manager or business analyst using a "thin-client" Web browser like Netscape Navigator or Internet Explorer. The computer server that is hosting the DSS application is linked to the user's computer by a network with the TCP/IP protocol.

    VI. Conclusions

    DSS practice, research and technology continue to evolve. By 1996, Holsapple and Whinton had identified five specialized types of DSS, including text-oriented DSS, database-oriented DSS, spreadsheet-oriented DSS, solver-oriented DSS, and rule-oriented DSS. These last four types of DSS match up with some of Alter抯 (1980) categories. Arnott and Pervan (2005) traced the evolution of DSS using seven sub-groupings of research and practice: personal DSS, group support systems, negotiation support systems, intelligent DSS, knowledge management-based DSS, executive information systems/business intelligence, and data warehousing.?These sub-grouping overlap, but reflect the diverse evolution of prior research.

    This chapter used an expanded DSS framework (Power, 2001, 2002) to retrospectively discuss the historical evolution of decision support systems. The Web has had a significant impact on the variety, distribution and sophistication of DSS, but handheld PCs, wireless networks, expanding parallel processing coupled with very large data bases and visualization tools are continuing to encourage the development of innovative decision support applications.

    Historians use two approached to apply the past to the future: reasoning by analogy and projection of trends. In many ways computerized decision support systems are like airplanes, coming in various shapes, sizes and forms, technologically sophisticated and a very necessary tool in many organizations. Decision support systems research and development will continue to exploit any new technology developments and will benefit from progress in very large data bases, artificial intelligence, human-computer interaction, simulation and optimization, software engineering, telecommunications and from more basic research on behavioral topics like organizational decision making, planning, behavioral decision theory and organizational behavior.

    Trends suggest that data-driven DSS will use faster, real-time access to larger, better integrated databases. Model-driven DSS will be more complex, yet understandable, and systems built using simulations and their accompanying visual displays will be increasingly realistic. Communications-driven DSS will provide more real-time video communications support. Document-driven DSS will access larger repositories of unstructured data and the systems will present appropriate documents in more useable formats. Finally, knowledge-driven DSS will likely be more sophisticated and more comprehensive. The advice from knowledge-driven DSS will be better and the applications will cover broader domains.

    Decision Support Systems pioneers came from a wide variety of backgrounds and faced many challenges that they successfully overcame to demonstrate the value of using computers, information technologies and specific decision support software to enhance and in some situations improve decision making. The DSS pioneers created particular and distinct streams of technology development and research that serve as the foundation for much of today抯 interest in building and studying computerized decision support systems. The legacy of the pioneers must be preserved. Check the Decision Support Systems Pioneers list at DSSResources.com/history/pioneers/pioneerslist.html.

    The future of decision support systems will certainly be different than the opportunistic and incremental innovations seen in the recent past. Decision support systems as an academic discipline is likely to follow a path similar to computer architecture and software engineering and become more rigorous and more clearly delineated. DSS consulting, teaching and research can be mutually supportive and each task can help establish a niche for those interested in building and studying DSS whether in Colleges of Information, Business or Engineering.

    The history of Decision Support Systems covers a relatively brief span of years, and the concepts and technologies are still evolving. Today it is still possible to reconstruct the history of Decision Support Systems (DSS) from retrospective accounts from key participants as well as from published and unpublished materials. Many of the early innovators and early developers are retiring but their insights and actions can be captured to guide future innovation in this field. It is hoped this paper leads to email and retrospective accounts that can help us understand the "real" history of DSS. The Internet and Web have speeded-up developments in decision support and have provided a new means of capturing and documenting the development of knowledge in this research area. Decision support pioneers include many academic researchers from programs at MIT, University of Arizona, University of Hawaii, University of Minnesota and Purdue University. The DSS pioneers created particular and distinct streams of technology development and research that serve as the foundation for much of today抯 work in DSS.

     

    A Brief History of Decision Support Systems (zz) -1

    A Brief History of Decision Support Systems

    by D. J. Power
    Editor, DSSResources.COM

    version 4.0 or see version 2.8

    Summary

    Information Systems researchers and technologists have built and investigated Decision Support Systems (DSS) for approximately 40 years. This paper chronicles and explores the developments in DSS beginning with building model-driven DSS in the late 1960s, theory developments in the 1970s, and the implementation of financial planning systems, spreadsheet DSS and Group DSS in the early and mid 80s. Data warehouses, Executive Information Systems, OLAP and Business Intelligence evolved in the late 1980s and early 1990s. Finally, the chronicle ends with knowledge-driven DSS and the implementation of Web-based DSS in the mid-1990s.

    I. Introduction

    Computerized decision support systems became practical with the development of minicomputers, timeshare operating systems and distributed computing. The history of the implementation of such systems begins in the mid-1960s. In a technology field as diverse as DSS, chronicling history is neither neat nor linear. Different people perceive the field of Decision Support Systems from various vantage points and report different accounts of what happened and what was important (cf., Arnott & Pervan, 2005; Eom & Lee, 1990b; McCosh & Correa-Perez, 2006; Power, 2003; Power, 2004a; Silver, 1991). As technology evolved new computerized decision support applications were developed and studied. Researchers used multiple frameworks to help build and understand these systems. Today one can organize the history of DSS into the five broad DSS categories explained in Power (2001; 2002; 2004b), including: communications-driven, data-driven, document driven, knowledge-driven and model-driven decision support systems.

    This hypertext document is a starting point in explaining the origins of the various technology threads that are converging to provide integrated support for managers working alone, in teams and in organization hierarchies to manage organizations and make more rational decisions. History is both a guide to future activity in this field and a record of the ideas and actions of those who have helped advance our thinking and practice. Historical facts can be sorted out and better understood, but more information gathering is necessary. This web page is a starting point in collecting more first hand accounts and in building a more complete mosaic of what was occurring in universities, software companies and in organizations to build and use DSS.

    This document traces decision support applications and research studies related to model and data-oriented systems, management expert systems, multidimensional data analysis, query and reporting tools, online analytical processing (OLAP), Business Intelligence, group DSS, conferencing and groupware, document management, spatial DSS and Executive Information Systems as the technologies emerge, converge and diverge. All of these technologies have been used to support decision making. A timeline of major historical milestones relevant to DSS is included in Appendix I.

    The study of decision support systems is an applied discipline that uses knowledge and especially theory from other disciplines. For this reason, many DSS research questions have been examined because they were of concern to people who were building and using specific DSS. Hence much of the broad DSS knowledge base provides generalizations and directions for building more effective DSS (cf., Baskerville & Myers, 2002; Keen, 1980).

    The next section describes the origins of the field of decision support systems. Section 3 discusses the decision support systems theory development that occurred in the late 1970s and early 1980s. Section 4 discusses important developments to communications-driven , data-driven, document driven, knowledge-driven and model-driven DSS (cf., Power, 2002). The final section briefly discusses how DSS practice, research and technology is continuing to evolve.

    II. Decision Support Systems Origins

    In the 1960s, researchers began systematically studying the use of computerized quantitative models to assist in decision making and planning (Raymond, 1966; Turban, 1967; Urban, 1967, Holt and Huber, 1969). Ferguson and Jones (1969) reported the first experimental study using a computer aided decision system. They investigated a production scheduling application running on an IBM 7094. In retrospect, a major historical turning point was Michael S. Scott Morton's (1967) dissertation field research at Harvard University.

    Scott Morton抯 study involved building, implementing and then testing an interactive, model-driven management decision system. Fellow Harvard Ph.D. student Andrew McCosh asserts that the 揷oncept of decision support systems was first articulated by Scott Morton in February 1964 in a basement office in Sherman Hall, Harvard Business School?(McCosh email, 2002) in a discussion they had about Scott Morton抯 dissertation. During 1966, Scott Morton (1971) studied how computers and analytical models could help managers make a recurring key business planning decision. He conducted an experiment in which managers actually used a Management Decision System (MDS). Marketing and production managers used an MDS to coordinate production planning for laundry equipment. The MDS ran on an IDI 21 inch CRT with a light pen connected using a 2400 bps modem to a pair of Univac 494 systems.

    The pioneering work of George Dantzig, Douglas Engelbart and Jay Forrester likely influenced the feasibility of building computerized decision support systems. In 1952, Dantzig became a research mathematician at the Rand Corporation, where he began implementing linear programming on its experimental computers. In the mid-1960s, Engelbart and colleagues developed the first hypermedia梘roupware system called NLS (oNLine System). NLS facilitated the creation of digital libraries and the storage and retrieval of electronic documents using hypertext. NLS also provided for on-screen video teleconferencing and was a forerunner to group decision support systems. Forrester was involved in building the SAGE (Semi-Automatic Ground Environment) air defense system for North America completed in 1962. SAGE is probably the first computerized data-driven DSS. Also, Professor Forrester started the System Dynamics Group at the Massachusetts Institute of Technology Sloan School. His work on corporate modeling led to programming DYNAMO, a general simulation compiler.

    In 1960, J.C.R. Licklider published his ideas about the future role of multiaccess interactive computing in a paper titled 揗an-Computer Symbiosis.?He saw man-computer interaction as enhancing both the quality and efficiency of human problem solving and his paper provided a guide for decades of computer research to follow. Licklider was the architect of Project MAC at MIT that furthered the study of interactive computing.

    By April 1964, the development of the IBM System 360 and other more powerful mainframe systems made it practical and cost-effective to develop Management Information Systems (MIS) for large companies (cf., Davis, 1974). These early MIS focused on providing managers with structured, periodic reports and the information was primarily from accounting and transaction processing systems, but the systems did not provide interactive support to assist managers in decision making.

    Around 1970 business journals started to publish articles on management decision systems, strategic planning systems and decision support systems (cf.,?Sprague and Watson 1979).. For example, Scott Morton and colleagues McCosh and Stephens published decision support related articles in 1968. The first use of the term decision support system was in Gorry and Scott-Morton抯 (1971) Sloan Management Review article. They argued that Management Information Systems primarily focused on structured decisions and suggested that the supporting information systems for semi-structured and unstructured decisions should be termed 揇ecision Support Systems?

    T.P. Gerrity, Jr. focused on Decision Support Systems design issues in his 1971 Sloan Management Review article titled "The Design of Man-Machine Decision Systems: An Application to Portfolio Management". The article was based on his MIT Ph.D. dissertation. His system was designed to support investment managers in their daily administration of a clients' stock portfolio.

    John D.C. Little, also at Massachusetts Institute of Technology, was studying DSS for marketing. Little and Lodish (1969) reported research on MEDIAC, a media planning support system. Also, Little (1970) identified criteria for designing models and systems to support management decision-making. His four criteria included: robustness, ease of control, simplicity, and completeness of relevant detail. All four criteria remain relevant in evaluating modern Decision Support Systems. By 1975, Little was expanding the frontiers of computer-supported modeling. His DSS called Brandaid was designed to support product, promotion, pricing and advertising decisions. Little also helped develop the financial and marketing modeling language known as EXPRESS.

    In 1974, Gordon Davis, a Professor at the University of Minnesota, published his influential text on Management Information Systems. He defined a Management Information System as "an integrated, man/machine system for providing information to support the operations, management, and decision-making functions in an organization. (p. 5)." Davis's Chapter 12 was titled "Information System Support for Decision Making" and Chapter 13 was titled "Information System Support for Planning and Control". Davis抯 framework incorporated computerized decision support systems into the emerging field of management information systems.

    Peter Keen and Charles Stabell claim the concept of decision support systems evolved from "the theoretical studies of organizational decisionmaking done at the Carnegie Institute of Technology during the late 1950s and early '60s and the technical work on interactive computer systems, mainly carried out at the Massachusetts Institute of Technology in the 1960s. (Keen and Scott Morton, 1978)". Herbert Simon抯 books (1947, 1960) and articles provide a context for understanding and supporting decision making.

    In 1995, Hans Klein and Leif Methlie noted 揂 study of the origin of DSS has still to be written. It seems that the first DSS papers were published by PhD students or professors in business schools, who had access to the first time-sharing computer system: Project MAC at the Sloan School, the Dartmouth Time Sharing Systems at the Tuck School. In France, HEC was the first French business school to have a time-sharing system (installed in 1967), and the first DSS papers were published by professors of the School in 1970. (p. 112).?o:p>

    III. Theory Development

    In the mid- to late 1970s, both practice and theory issues related to DSS were discussed at academic conferences including the American Institute for Decision Sciences meetings and the ACM SIGBDP Conference on Decision Support Systems in San Jose, CA in January 1977 (the proceeding were included in the journal Database). The first International Conference on Decision Support Systems was held in Atlanta, Georgia in 1981. Academic conferences provided forums for idea sharing, theory discussions and information exchange.

    At about this same time, Keen and Scott Morton抯 DSS textbook (1978) provided the first broad behavioral orientation to decision support system analysis, design, implementation, evaluation and development. This influential text provided a framework for teaching DSS in business schools. McCosh and Scott-Morton抯 (1978) DSS book was more influential in Europe.

    In 1980, Steven Alter published his MIT doctoral dissertation results in an influential book. Alter's research and papers (1975; 1977) expanded the framework for thinking about business and management DSS. Also, his case studies provided a firm descriptive foundation of decision support system examples. A number of other MIT dissertations completed in the late 1970s also dealt with issues related to using models for decision support.

    Alter concluded from his research (1980) that decision support systems could be categorized in terms of the generic operations that can be performed by such systems. These generic operations extend along a single dimension, ranging from extremely data-oriented to extremely model-oriented. Alter conducted a field study of 56 DSS that he categorized into seven distinct types of DSS. His seven types include:

    ?span style='font:7.0pt "Times New Roman"'>         File drawer systems that provide access to data items.

    ?span style='font:7.0pt "Times New Roman"'>         Data analysis systems that support the manipulation of data by computerized tools tailored to a specific task and setting or by more general tools and operators.

    ?span style='font:7.0pt "Times New Roman"'>         Analysis information systems that provide access to a series of decision-oriented databases and small models.

    ?span style='font:7.0pt "Times New Roman"'>         Accounting and financial models that calculate the consequences of possible actions.

    ?span style='font:7.0pt "Times New Roman"'>         Representational models that estimate the consequences of actions on the basis of simulation models.

    ?span style='font:7.0pt "Times New Roman"'>         Optimization models that provide guidelines for action by generating an optimal solution consistent with a series of constraints.

    ?span style='font:7.0pt "Times New Roman"'>         Suggestion models that perform the logical processing leading to a specific suggested decision for a fairly structured or well-understood task.

    Donovan and Madnick (1977) classified DSS as institutional or ad hoc. Institutional DSS support decisions that are recurring. An ad hoc DSS supports querying data for one time requests. Hackathorn and Keen (1981) identified DSS in three distinct yet interrelated categories: Personal DSS, Group DSS and Organizational DSS.

    In 1979, John Rockart of the Harvard Business School published a ground breaking article that led to the development of executive information systems (EISs) or executive support systems (ESS). Rockart developed the concept of using information systems to display critical success metrics for managers.

    Robert Bonczek, Clyde Holsapple, and Andrew Whinston (1981) explained a theoretical framework for understanding the issues associated with designing knowledge-oriented Decision Support Systems. They identified four essential "aspects" or general components that were common to all DSS: 1. A language system (LS) that specifies all messages a specific DSS can accept; 2. A presentation system (PS) for all messages a DSS can emit; 3. A knowledge system (KS) for all knowledge a DSS has; and 4. A problem-processing system (PPS) that is the "software engine" that tries to recognize and solve problems during the use of a specific DSS. Their book explained how Artificial Intelligence and Expert Systems technologies were relevant to developing DSS.

    Finally, Ralph Sprague and Eric Carlson抯 (1982) book Building Effective Decision Support Systems was an important milestone. Much of the book further explained the Sprague (1980) DSS framework of data base, model base and dialog generation and management software. Also, it provided a practical, and understandable overview of how organizations could and should build DSS. ?/span>Sprague and Carlson (1982) defined DSS as "a class of information system that draws on transaction processing systems and interacts with the other parts of the overall information system to support the decision-making activities of managers and other knowledge workers in organizations (p. 9).?o:p>

    January 18

    工程师 vs 科学家 -- zz自smth某ID签名档

    工程师说,世界应该是被改造的;科学家说,世界应该是被认识的。
    工程师说,世界应该是和谐的;科学家说,世界应该是多彩。
    工程师说,世界应该是幸福的;科学家说,世界应该是真实的。
    工程师说,世界应该是人类的;科学家说,人类应该是世界的。
    工程师说,我想成为这个世界的上帝;科学家说,我想了解这个世界的上帝。
    工程师说,我只相信统计;科学家说,我还相信奇迹。
    December 09

    爱惜自己

    爱护牙齿,定期去医院检查。
    保持营养均衡,不暴饮暴食、不刻意减肥。
    吃早餐,哪怕一小块巧克力。
    坚持做皮肤护理。
    如果没时间坚持健身,每天早晚在家里自己活动一下筋骨。
    心情平和、少发脾气。
    得病的时候在家休息半天。
    大病、顽疾去医院。
    每个月至少一次彻底放松:睡上一天觉、做一整天家务、运动出一身汗、购物一整天或者泡个温泉。
    熬夜每周不超过三次。
    每周至少下厨两次。
    每年体检。
     
    30年前的今天,我满月了....
    在这个特别的日子决心在以后的日子里做到爱惜自己.
    October 23

    Academe Niubility (zz)

    1、最牛的博士论文就是在还没答辩之前已经发表在最好的期刊上,而且鉴于论文很长,该期刊必须像小说一样连载。 实例:张五常博士论文《佃农理论》,当年在JLE上连载四期。
    2、最牛的博士论文答辩就是答辩人一直在挑战答辩委员会成员,直到问的这些教授们紧张到恍惚以为自己才是答辩人。 实例:萨缪尔森的博士论文答辩结束后,答辩委员会成员之一的熊彼特(上世纪最伟大的经济学家之一)转过头去问另一位成员里昂剔夫(诺奖得主):“瓦西里,我们通过了么?”
    3、最牛的投稿论文就是让编辑满世界都找不到一个能看懂这篇论文的匿名审稿人,最后只能发表,根本不需要修改的。 实例:SIMS1971年发表在《数理统计年鉴》上的论文《无穷维参数空间中的分布滞后估计》。SIMS写完这篇论文后没投经济学杂志,因为他显然知道没人看的懂。于是投给了 最牛的数理统计杂志,结果编辑死活找不到审稿人,最后好不容易凑合拉来一个,审稿 报告是这么写的:“我真的不明白这篇论文在说什么,但是我检验了其中的几个定理,好像是对的。所以我猜应该发表。”
    July 21

    Config Trac notification using gmail smtp server

    Finally make it work after 24 hours struggling....
    trac version: Trac-0.12dev_r7190-py2.5
    mission: enable notification through a ssl smtp server (i.e. gmail)
     
    1) add a ssl lib file (http://aleph-null.tv/downloads/ssmtplib.py) to your trac directory, where your notification.py file locates
     
    2) modify notification.py
    add "import ssmtplib" together with other import declarations;
    find the second " def begin_send(self):" function, and change "self.server = smtplib.SMTP(self.smtp_server, self.smtp_port)" to "self.server=ssmtplib.SMTP_SSL(self.smtp_server, self.smtp_port)"
     
    3) config "trac.ini" like following:
    [notification]
    admit_domains =
    always_notify_owner = true
    always_notify_reporter = true
    always_notify_updater = true
    ignore_domains =
    mime_encoding = base64
    smtp_always_bcc =
    smtp_always_cc = UrAccount@gmail.com
    smtp_default_domain =
    smtp_enabled = true
    smtp_from = UrAccount@gmail.com
    smtp_from_name = UrAccount@gmail.com
    smtp_password = UrPasswd
    smtp_port = 465
    smtp_replyto = UrAccount@gmail.com
    smtp_server = smtp.gmail.com
    smtp_subject_prefix = __default__
    smtp_user = UrAccount@gmail.com
    ticket_subject_template = $prefix #$ticket.id: $summary
    use_public_cc = false
    use_short_addr = false
    use_tls = false
     
    4) restart you trac server (or apache server)
     
    everything is done~  ^^
     
     
     
    June 10

    Windows2003下apache+svn+mysql+trac的配置

    为了更好地管理乱七八糟各种软件开发项目,在咨询了多方意见并在网上作了一周左右的功课之后,决定安装Trac作为项目管理的工具。
    选择Trac主要基于下面几个理由:
    1,现有项目是apache+subversion管理,希望项目管理系统可以与subversion有效的集成,至少要能够与现有代码控制系统公用用户登录。
    2,要求有任务分配、Bug追踪、里程碑与项目进度控制等功能。。。这个一般的SCM管理工具都有。
    3,我们的软件开发项目需求比较复杂,涉及很多开发软件的人不熟悉的经济理论/模型/方法,所以必须要有wiki来管理开发中的术语。
    4,轻量级,学习成本低。
    虽然Trac在管理带有层级结构的项目方面显得有些力不从心,但最终还是决定用Trac。
     
    安装Trac颇费周折,由于原来是在RHEL4上部署的apache+subversion,所以首先尝试在原有服务器上面部署Trac,结果尝试了一周之后最终放弃,实在俺是对Linux不够熟悉,而且那个版本的匹配实在是让人头痛。好在Linux下的svn版本库直接拷贝就可以移植到Windows下,所以索性整个项目管理的环境改到Windows啦~
     
    下面简单说一下Windows2003下apache+svn+mysql+trac的配置:
    1,安装apache和subversion,并进行配置,在这里略去
    Apache 2.0.59
    Subversion 1.4.6
    2,安装mysql和python,并在path里面添加python的安装目录和/Scripts目录
    MySQL 5.0.22
    python 2.5 (注意不是2.5.1也不是2.5.2)
    3,安装mysql、svn、apache的python插件
    MySQL-python-1.2.2.win32-py2.5.exe
    mod_python-3.3.1.win32-py2.5-Apache2.0.exe
    svn-python-1.4.6.win32-py2.5.exe
    4,安装Trac和Genshi
    Trac 0.12dev-r7190
    Genshi-0.4.4.win32.exe
    5,建立一个Trac专用的mysql用户,并建立一个数据库用于存放项目管理数据。
    6,在命令行状态下新建一个 Trac project
    trac-admin D:\TracRoot\myproject initenv
    然后用交互式的方式指定数据库的位置和svn的位置,这里输错了没关系,之后可以到trac.ini里面修改
    7,在apache的httpd中添加:
    LoadModule python_module modules/mod_python.so
    <Location /trac>
        SetHandler mod_python
        PythonHandler trac.web.modpython_frontend
        PythonOption TracEnvParentDir D:\TracRoot
        SetEnv PYTHON_EGG_CACHE /tmp
        PythonOption TracUriRoot /trac
        AuthType None
    </Location>
    8,重新启动apache,应该一切都ok了,在你的apache站点的 /trac目录下,应该可以看到刚刚建的那个trac project的链接,如果点击这个链接能够进入项目主页,那么就大功告成了~ ^^
     
    Tips:
    1,安装配置Trac最关键的一点就是版本的兼容性,这个问题导致我在Windows上又搞了一个星期才装好。上面列出我安装的软件版本,至少我已经验证个组合是可以的。注意:为保证软件版本的正确性,上面所有的软件一定要到该软件开源项目的主站上下载!
    2,上面的安装过程每完成一步都要验证一下这一步是否成功,便于修正配置中的错误~
     
    下面的任务就是如何有效地把Trac用起来了 ^^
    God bless me~
     
     
     
     
     
     
     
     
     
     
    June 08

    Joke - Happy Zongzi Festival

    发信人: Iceberg (千面怪), 信区: Joke
    标  题: 看不懂的请举手
    发信站: 紫丁香社区 (Fri Jun  6 22:45:44 2008), 站内
     
    Aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in waht
    oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht the frist and
    lsat ltteer be at the rghit pclae. The rset can be a total mses and you can
    sitll raed it wouthit porbelm. Tihs is bcuseae the huamn mnid deos not raed
    ervey lteter by istlef, but the wrod as a wlohe. Amzanig!
     
     
    --
    记得那一天  上帝安排我们见了面
    我知道  我已经看到了春天
    ……
    那一天  那一天  留在我心里
    已烙上了印  永远无法抹去
    ……

    ※ 来源:·紫丁香社区 lilacbbs.com·[FROM: 61.167.*.*]
    April 19

    爱国日

    有没有可能有那么一天。。。
     
    所有在中国大陆的中国人,所购买和使用的所有商品都是中国品牌中国制造的?
     
    可以不吃进口品牌食品吧?
    可以不用进口品牌化妆品化妆吧?
    可以不去7/11吧?
    可以一天不开自己的丰田车吧?
     
    仅一天而已,应该不会很难吧?
     
    在每一年的这一天,让每个人在忙碌的生活工作中驻足,向全世界表明我们心中对我们的国家我们的民族的热爱。也提醒我们自己,我们的国家还不足够富强,世界对我们的认识还不够完整!
     
     
     
    March 10

    活着真好。。。

    最近碰巧跟了几集中央8台的电视剧“活着真好”,讲的是患乳腺癌的一家三姐妹的故事。。。不知多少年没有这样坐在电视机前看电视了,竟然还被感动得不时落泪。
    爱生活、爱家人、爱朋友,宽容、信任、勇敢,这些看似平常的品质在生死攸关的时刻是如此让人震撼。。。
    February 04

    闯关东

    明天要回家过春节了,今天给爸妈刻了电视剧"闯关东" ^^
    我爷爷当年是从山东北马尚家出来闯关东到哈尔滨的。电视剧里的龙口港,可能就是黄县,也就是我的籍贯地。
    爷爷的旅程和电视剧里的那一家差不多啊,不过应该是晚了2-30年。忽然对以前的事情产生了浓厚的兴趣,不知道我爷爷当年怎么闯过来的?都发生了些什么事情?这次回去一定要问问我爸... 大笑