Leonard D. Shapiro is an American computer scientist and professor emeritus of computer science at Portland State University. He is known for his contributions to database systems, particularly in the areas of query processing and optimization.

Leonard Shapiro
Born
Leonard D. Shapiro
NationalityAmerican
EducationReed College
Yale University (PhD)
OccupationComputer scientist
SpouseElayne Shapiro
Children3, including Ari

Education

edit

Shapiro graduated from Reed College in 1965, Phi Beta Kappa. He earned a doctor of philosophy from Yale University in 1969.[1]

Career

edit

Shapiro held positions at the University of Minnesota from 1969 to 1977 and North Dakota State University from 1977 to 1987. He served as the chairman of the Division of Mathematical Sciences at North Dakota State University from 1977 to 1985.[1]

In 1987, Shapiro joined Portland State University as a professor of computer science, where he also served as department chair from 1987 to 1994. He later became the director of the Data Intensive Systems Center (DISC).[1]

Research and contributions

edit

Shapiro's research has significantly impacted database systems, particularly in the areas of query processing, optimization, and main memory databases. His work spans computer science, economics, statistics, and mathematics.[1]

One of his most cited works is "Implementation techniques for main memory database systems" (1984), co-authored with David J. DeWitt and others, which explored the changes necessary for relational database systems to take advantage of large amounts of main memory.[2]

Other notable contributions include research on join processing in database systems with large main memories,[3] and work on data compression and database performance.[4]

Awards and recognition

edit

In 2002-2003, Shapiro was elected by students as Outstanding Computer Science Teacher at Portland State University.[1]

Personal life

edit

Shapiro is married to Elayne Shapiro née Halpern. They have three sons, Daniel, Joseph and Ari Shapiro.[5] Shapiro is active in community service, having served on the Board of Directors for Our House of Portland, as Vice President of Hospice of Washington County, and as a volunteer consultant for Tri-Met on the use of computers and the web for bus on-time information.[1]

References

edit
  1. ^ a b c d e f "Leonard Shapiro". web.cecs.pdx.edu. Retrieved 2019-03-15.
  2. ^ DeWitt, David J.; Katz, Randy H.; Olken, Frank; Shapiro, Leonard D.; Stonebraker, Michael R.; Wood, David A. (1984-06-01). "Implementation techniques for main memory database systems". Proceedings of the 1984 ACM SIGMOD international conference on Management of data - SIGMOD '84. pp. 1–8. doi:10.1145/602259.602261. ISBN 0-89791-128-8.
  3. ^ Shapiro, Leonard D. (1986). "Join processing in database systems with large main memories". ACM Transactions on Database Systems. 11 (3): 239–264. doi:10.1145/5465.5466.
  4. ^ Graefe, G.; Shapiro, L.D. (1990). Data compression and database performance (Technical report). University of Colorado, Boulder, Department of Computer Science.
  5. ^ Moon, Deborah (2017-10-30). "Ari Shapiro considers all things". Oregon Jewish Life. Retrieved 2019-03-15.
edit