Philip M. Lewis

Rank/Position Title:

Professor

Home Page:

http://www.cs.sunysb.edu/~pml

Date of original appointment to this faculty, followed by dates and ranks of advancement:

1987, Professor and Chair

Degrees:

Degree

Field

Institution

Date

Ph.D.

E.E.

M.I.T.

1956

M.S.

E.E.

M.I.T.

1954

B.S.

E.E.

M.I.T.

1952

Conferences, workshops, and professional development:

  • 2003: Symposium on Engineering Ethics, Stony Brook University
  • 2002: Cornell University Computer Science Department: Review of Computer Science Theoretical Research: Presented paper

Other related computing experience:

  • 1956-1959 Assistant Professor in EE, M.I.T. 1956--1959
  • 1959-1987 Researcher and Manager of Computer Science Research, G.E.Research Lab
  • 1961-1987 Adjunct Professor, R.P.I.

Department, college, and/or university committee membership:

  • University: Committee on Non-Tenured Faculty
  • College: Executive Committee
  • College: Committee on Academic Standards and Appeals
  • Department: Undergraduate Committee
  • Department: Library Committee

Principal publications of the last five years.

  • M. Kifer, A. Bernstein, P. Lewis, "Databases: An Applications Oriented Approach (Introductory Version) Second Edition, 2005
  • P. Lewis, A. Bernstein, M. Kifer, "Databases and Transaction Processing: An Applications Oriented Approach" Addison Wesley, 2002
  • A. Bernstein, P. Lewis, and S. Lu, ``Semantic Conditions for Correctness at Different Isolation Levels'', 16th Int'l Conf. on Data Engineering, San Diego, CA, Feb., 2000.
  • A. Bernstein, D. Gerstl, and P. Lewis, ``Concurrency Control for Step-Decomposed Transactions'', Information Systems, vol 24, no 8. pp 673-698, 1999.
  • A. Bernstein, D. Gerstl, P. Lewis, and S. Lu, ``Using Transaction Semantics to Increase Performance'', 8th Int'l Workshop on High Performance Transaction Systems, Pacific Grove, CA, Sept., 1999.

Other scholarly activity: grants, sabbaticals, software development, etc.:

2002: Sabbatical in China in Nanjing Institute of Meteorology: Taught course and interacted with students and faculty

Scientific, professional, and honor societies of which you are a member:

ACM, IEEE, Tau Beta Pi, Eta Kappa Nu

Honors and awards:

  • 1999: Fellow ACM
  • 1979: Fellow IEEE
  • 1991: Who's Who in America
  • 1977: General Electric Coolidge Fellow

Courses taught this and last academic year term-by-term

Year/Term

Course Number

Course Title

S05

CSE308

Software Engineering

F04

CSE301

History of Computing

F04

CSE515

Into to Transaction Processing Systems

S04

CSE315

Database Transaction Processing Systems

S03

CSE308

Software Engineering

F03

CSE308

Software Engineering

S04

CSE300

Writing in Computer Science

S03

CSE300

Writing in Computer Science

F03

CSE300

Writing in Computer Science

Academic advising:

All ISE students

Brief description of major research and scholarly activities:

  • Research on Web Services partially funded by Reuters
  • Author of textbook on Databases (writing second edition)