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 |
Nationality | American |
Education | Reed College Yale University (PhD) |
Occupation | Computer scientist |
Spouse | Elayne Shapiro |
Children | 3, including Ari |
Education
editShapiro graduated from Reed College in 1965, Phi Beta Kappa. He earned a doctor of philosophy from Yale University in 1969.[1]
Career
editShapiro 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
editShapiro'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
editIn 2002-2003, Shapiro was elected by students as Outstanding Computer Science Teacher at Portland State University.[1]
Personal life
editShapiro 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- ^ a b c d e f "Leonard Shapiro". web.cecs.pdx.edu. Retrieved 2019-03-15.
- ^ 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.
- ^ 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.
- ^ Graefe, G.; Shapiro, L.D. (1990). Data compression and database performance (Technical report). University of Colorado, Boulder, Department of Computer Science.
- ^ Moon, Deborah (2017-10-30). "Ari Shapiro considers all things". Oregon Jewish Life. Retrieved 2019-03-15.
External links
edit- Leonard Shapiro publications indexed by Google Scholar