David McGoveran (born 1952) is an American computer scientist and physicist, software industry analyst, and inventor. In computer science, he is recognized as one of the pioneers of relational database theory.

Education

edit

David McGoveran majored in physics and mathematics, and minored in cognition and communication at the University of Chicago from 1973 to 1976, with graduate studies in physics and psycholinguistics. He pursued additional graduate studies from 1976 to 1979 at Stanford University.

Career

edit

While a student he was employed by the Enrico Fermi Institute's Laboratory for Astrophysics and Space Research (Chicago 1973-4), Dow Chemical Company's Western Applied Science and Technology Laboratories (Walnut Creek, CA 1974), and University of Chicago Hospitals and Clinics (1975-6). After graduation from University of Chicago, he founded the consulting firm of Alternative Technologies[1](Menlo Park, CA 1976) under the mentoring of H. Dean Brown and Cuthbert Hurd. While starting his consulting practice, he worked at SRI International (1976-9), his first consulting client.[2]

Between 1979 and 1981, he taught electronics engineering in the Professional Engineering Institute at Menlo College (Redwood City, CA) and was Chairman of the Computer Science and Business Departments at Condie College (San Jose, CA), developing the schools bachelor program in computer science.[3]

Alternative Technologies has provided consulting on the design and development of numerous software systems, specializing in mission critical and distributed applications. Clients have included AT&T, Blue Cross, Digital Equipment, Goldman Sachs, HP, IBM, Microsoft, MCI-Worldcom, Oracle, and many others.[4]

McGoveran's software engineering contributions include a collaborative conferencing system (1978); multi-tier relational CIM (computer integrated manufacturing) system (Fasttrack, 1982); relational access manager (1984–89); international electronic funds transfer (1984); trading systems databases (1986–91); OLCP requirements (1986); an object-relational portfolio management (1986–89); first Sybase SQL Server PC client (1987); client-server API requirements (1988); object-relational API requirements (1990); query optimizer requirements (1990); first middleware market analysis and forecast (1991); Database Connectivity Benchmark (1993);[5] numerous high availability and scalable systems (1994–96); and designed BPMS products and established the BPM[6] category (1998-2000) with HP and IBM.

He has chaired various professional conferences (1975-2001). He assesses software opportunities and risks for vendors, venture capitalists and other investors; and occasionally serves as an expert in software intellectual property litigation.

Research

edit

Mathematical Logic

edit

Work on applications of mathematical logic has pervaded Mr. McGoveran's career (1971–present). He has done original research and published on the structure of paradoxes,[7] applications of quantum logic to schizophrenia,[8] linguistic logic[9] and computational semantics (under James D. McCawley), fuzzy logic,[10][11][12] and applications of logic, including multi-valued logics, to databases.[13][14][15][16][17][18]

Transaction Management

edit

Beginning in 1981,[19][20] Mr. McGoveran began consulting on the design of transaction processing systems, including distributed transactions. Investigations into the complexity and cost of distributed transactions, as well as the difficulty of maintaining transactional consistency in online applications led to research into alternatives to the traditional transaction models that used pessimistic concurrency control and enforced ACID properties.[21] McGoveran defined physical transactions as the unit of recovery, logical transactions as the unit of consistency, and business transactions as the unit of audit[22] The resulting adaptive transaction model introduces a transaction intrinsic definition of consistency, deferring the decision to combine the results of two or more transactions. His work on transaction management resulted in the award of US Patent No 7,103,597.[23]

edit

McGoveran's research on E.F. Codd's relational model has focused on the issues of data modeling (database design), missing information, and view updating. The last two are considered by some database researchers to be the most difficult and controversial problems in relational database research.[24]

Having worked on the design and development of several early large scale, distributed, commercial relational database applications,[25][26] McGoveran sought to improve upon the science of database design. This work lead to the development of

  1. new analyses of and solutions to the problem of "missing information" and avoiding the use of nulls and therefore many-valued logic
  2. the specification and uses of relation predicates (relation or set membership functions) as an application of Leibniz' Law[27][28][29]
  3. a new design principle (with C. J. Date) now known as the Principle of Orthogonal Design (POOD)

His work on logic applied to relational databases and on design without nulls (1993) has been republished several times.[30][31]

McGoveran tackled the problem of view updating with Christopher J. Date starting in 1993 after having developed methods for reversible schema migration for clients on Wall Street.[32] His solution, based on relation predicates, formed the basis for the algorithms found in The Third Manifesto (Christopher J. Date, Hugh Darwen) for updating virtual relations (e.g., views). Date has credited McGoveran with originally suggesting the basic idea for the view updating approach,[33] and which Hugh Darwen[34] says represented a major shift in thinking on the issue. This work has resulted in two patents (U.S. Patent 7,620,664 and U.S. Patent 7,263,512).

Some of McGoveran's work on databases is discussed at Fabian Pascal's Database Debunkings web site.[35]

EAI and Business Process Management

edit

After consulting on numerous data integration and enterprise application integration projects, and related middleware products, McGoveran recognized that process aspects of integration were largely overlooked.[36][37] Most business process technology focused on analyzing and documenting existing business processes, then manually "reengineering" the processes to eliminate waste, remove bottlenecks, and improve cycle times. These efforts were largely disjoint from process automation systems and distributed control systems (which focused on highly repetitive, often continuous processes), and workflow technologies (which focused on highly repetitive sequential processes like document processing).

McGoveran postulated[38] an analogy between data management and process management.[39] Just as the relational data model proposed separating the logical model of the data from the physical storage model, it seemed that a logical process model (i.e., the business process model) should be separated from its physical implementation (e.g., as messaging, remote invocation, services, etc.). As with the relational model, this would permit business process design via models that were logically separated from specifics of process implementation, process scheduling, and process optimization. By introducing process measurement and analytics into the proposed process management system, closed loop process control became theoretically possible. The result was a set of requirements and a canonical architecture for the then largely unknown business process management system (BPMS).

The first commercial package compliant with this BPMS architecture ChangEngine - was then built and introduced by Hewlett-Packard in 1997-98 under McGoveran's direction.[40] Subsequently, McGoveran introduced these concepts at DCI's EAI conference in 1999,[41] through work as Sr. Technical Editor of the eAI Journal (Thomas Communications)[42] and worked with companies like IBM, Vitria, Candle, Fuego, Savvion, and numerous others to help shape the market and the BPM category.[43] Many workflow and business process reengineering (BPR) companies joined in the effort, transforming themselves into BPM companies during the period 1999-2010.

Affiliations

edit
  • Secretary-treasurer of the Alternative Natural Philosophy Association (Cambridge University) from 1982-1986, and served as co-editor of the organizations newsletter with John Amson.[44]
  • Co-founder, Alternative Natural Philosophy Association West (ANPA West) and its non-profit corporation (1984), along with H. Pierre Noyes and Chris Gefwert, organized its first three conferences, and was recipient Second Annual Alternative Natural Philosopher Award in 1990.[45]
  • Co-founder, Database Associates[46] with Colin White,[47] Richard Finkelstein, and Paul Winsberg (1990).[48]
  • Wrote and published (initially with Colin White) the Database Product Evaluation Reports (1989-1996).
  • Founded the 60 member Enterprise Integration Council (1999-2002).[49]
  • ACM Life Member (1983)
  • Amer. Math. Society Life Member (1996)
  • IEEE Member (1978).[50]
  • Consulting editor for an international research journal (1975-6)
  • Associate editor for InfoDB (1990-4)
  • Sr. technical editor of the eAI Journal/Business Integration Journal (1999-2006).[51]
  • He served as a judge in technology awards including the CrossRoads A-List, the eAI Journal and Business Integration Journal Awards,[52] and the IBM Beacon Awards.[53][54]

Selected publications

edit

McGoveran has written articles in the fields of relational databases, transaction processing, business intelligence, enterprise application integration, business process management, mathematics, and physics, including over 100 monthly columns for eAI Journal (a.k.a. Business Integration Journal) throughout the life of the journal.

Books

edit
  • McGoveran, D., Date, C. J. (1992). A Guide to SYBASE and SQL Server. Reading, MA: Addison-Wesley. ISBN 0-201-55710-X.
  • Date, C.J., Darwen, H., McGoveran, D. (1998). Relational Database Writings, 1994-1997. Reading, MA: Addison-Wesley. ISBN 0-201-39814-1.

Encyclopedia articles

edit
  • McGoveran, D., (1991). The Evaluation of Optimizers. Encyclopedia Computer Science and Technology: Volume 26, Supplement 11. New York, NY:Marcel Dekker.
  • McGoveran, D., (1993). The Evaluation of Optimizers. Encyclopedia of Microcomputers: Volume 13. New York, NY: CRC Press. ISBN 978-0824727116 & ISBN 0824727118.

References

edit
  1. ^ "Home". AlternativeTech.com.
  2. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  3. ^ "Home". AlternativeTech.com.
  4. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  5. ^ Finkelstein, R. (1993). Database Connectivity Benchmark.
  6. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  7. ^ McGoveran, D. (1981). Getting Into Paradox, In Kilmister, C. W. (Ed.). "Proc. ANPA 2". Cambridge, England: Cambridge University.
  8. ^ Oshins, E., and McGoveran, D. (February 1980). Thoughts About Logic About Thoughts. The Question: Schizophrenia? In Banathy, B. H. (Ed.). "Proceedings of the 24th Annual North American Meeting of the Society For General Systems Research, and the American Association for the Advancement of Science, San Francisco, CA Jan. 7-10, 1980". Louisville, KY: Systems Science Institute. OCLC Number 6263125.
  9. ^ McCawley, D. (1981). "Everything that Linguists have Always Wanted to Know about Logic . . . But Were Ashamed to Ask". Chicago, IL: University Of Chicago Press.
  10. ^ McGoveran, D. (January 1985). Fuzzy Logic. Letters to the Editor: IEEE Spectrum. (p.8).
  11. ^ Oshins, E., Adelson, D., McGoveran, D. (1982). Clarifying Fuzzy Logic: A Spectral Decomposition and Iconic Realization. (presented AAAS, 1980). In Gray, W. Fidler, J. & Battista, J. (Eds). "General Systems Theory and the Psychological Sciences. Vol. 2". Seaside, CA: Intersystems Publications. ISBN 978-0914105107 and ISBN 0914105108.
  12. ^ McGoveran, D. (1980). Fuzzy Logic and Non-Distributive Truth Valuations. In Wang, P.P., Chang, S.K. (Eds.). "Fuzzy Sets: Theory and Applications to Policy Analysis and Information Systems". New York: Plenum Press. ISBN 0-306-40557-1.
  13. ^ McGoveran, D., (Dec.1993-Mar. 1994) Nothing from Nothing, "Database Programming & Design". San Francisco, CA: Miller-Freeman. (in four parts).
  14. ^ Date, C. J. (1998) "Relational Database Writings 1994-1997". Reading, MA: Longman Pub. Group. (ISBN 0201398141 & ISBN 978-0201398144).
  15. ^ Date, C. J., McGoveran, D. (July, 1994). A New Database Design Principle. "Database Programming & Design".
  16. ^ Date, C. J. (1995). "Relational Database Writings 1991-1994". Reading, MA: Addison-Wesley. ISBN 0201824590 & ISBN 978-0201824599.
  17. ^ Date, C. J., McGoveran, D. (August, 1994). Updating Joins and Other Views. "Database Programming & Design".
  18. ^ [ Date, C. J., McGoveran, D. (June, 1994). Updating Union, Intersection, and Difference Views. "Database Programming & Design".]
  19. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  20. ^ Alternative Technologies.
  21. ^ McGoveran, D. (Nov. 2007). Beyond ACID: An Adaptive Approach To Transaction Management. "Middleware Spectra", 21(4). (pp. 14-23).]
  22. ^ McGoveran, D. (2004). Understanding Business Transactions. "Business Integration Journal". Vol. 5. Dallas, TX: Thomas Communications.
  23. ^ McGoveran, D. (2002) Adaptive Transaction Manager for Complex Transactions and Business Processes. US Patent No 7,103,597. Washington, DC: US Patent and Trademark Office.
  24. ^ [ Date, C. J. (December 20, 2012). "View Updating and Relational Theory". Foreword by Hugh Darwen. p. xv. Sebastopol, CA: O'Reilly Media. ISBN 1449357849 & ISBN 978-1449357849.]
  25. ^ Pascal, F. (April 11, 2015). An Interview with David
  26. ^ Alternative Technologies.
  27. ^ Date, C. J., McGoveran, D. (July, 1994). A New Database Design Principle. "Database Programming & Design". San Francisco, CA: Miller-Freeman.
  28. ^ Date, C. J., McGoveran, D. (June, 1994). Updating Union, Intersection, and Difference Views. "Database Programming & Design". San Francisco, CA: Miller-Freeman.
  29. ^ Date, C. J., McGoveran, D. (August, 1994). Updating Joins and Other Views. Database Programming & Design. San Francisco, CA: Miller-Freeman.
  30. ^ McGoveran, D., (Dec.1993-Mar. 1994) Nothing from Nothing. "Database Programming & Design". San Francisco, CA: Miller-Freeman. (in four parts).
  31. ^ Date, C. J. (1998) "Relational Database Writings 1994-1997". Reading, MA: Longman Pub. Group. (ISBN 0201398141 & ISBN 978-0201398144).
  32. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  33. ^ Date, C. J. (December 20, 2012). "View Updating and Relational Theory". Preface. p. xiv. Sebastopol, CA: O'Reilly Media. ISBN 1449357849 & ISBN 978-1449357849.
  34. ^ [Date, C. J. (December 20, 2012). "View Updating and Relational Theory". Foreword by Hugh Darwen. p. xv. Sebastopol, CA: O'Reilly Media. ISBN 1449357849 & ISBN 978-1449357849.
  35. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  36. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  37. ^ Alternative Technologies.
  38. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  39. ^ McGoveran, D. (1999). Think BPMS! McGoveran, D. (2004). Understanding Business Transactions. "eAI Journal". Vol. 1. Dallas, TX: Thomas Communications.
  40. ^ "Jannasch, D. (1998). "Proceedings of HP World '98". San Diego, CA: Hewlett-Packard". Archived from the original on 2016-03-04. Retrieved 2015-04-14.
  41. ^ (Jan. 7, 1999). Application Server Workshop and Enterprise Application Integration Conference to Premiere in 1999. Andover, MA: DCI/PRNewswire.
  42. ^ eAI JOURNAL and BUSINESS INTEGRATION JOURNAL ARTICLES. Alternative Technologies Publications Directory.[permanent dead link]
  43. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  44. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  45. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  46. ^ Bochenski, B. (Dec. 17, 1990) Client Server Products. "Computerworld", p.53-54, by Barbara Bochenski
  47. ^ "Home". bi-research.com.
  48. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  49. ^ Holt, S. (Apr 5, 1999,). Enterprise app integration vendors link up. "InfoWorld". p. 72.
  50. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  51. ^ Pascal, F. (April 11, 2015). An Interview with David McGoveran. "Database Debunkings".
  52. ^ "BEA Systems Named 'Vendor of the Year' by Business Integration Journal. - Free Online Library". Archived from the original on 2015-04-14. Retrieved 2015-04-14.
  53. ^ IBM Beacon Awards Distinguish Outstanding Business Partner Achievements In 2001. San Francisco, CA:IBM.
  54. ^ IBM Beacon Awards Distinguish Outstanding Business Partner Achievements in 2002. New Orleans, LA:IBM.
edit