James Nicholas Gray (1944 –
declared dead in absentia 2012) was an American
computer scientist
A computer scientist is a scientist who specializes in the academic study of computer science.
Computer scientists typically work on the theoretical side of computation. Although computer scientists can also focus their work and research on ...
who received the
Turing Award in 1998 "for seminal contributions to
database
In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and a ...
and
transaction processing
In computer science, transaction processing is information processing that is divided into individual, indivisible operations called ''transactions''. Each transaction must succeed or fail as a complete unit; it can never be only partially c ...
research and technical leadership in system implementation".
Early years and personal life
Gray was born in
San Francisco
San Francisco, officially the City and County of San Francisco, is a commercial, Financial District, San Francisco, financial, and Culture of San Francisco, cultural center of Northern California. With a population of 827,526 residents as of ...
, the second child of Ann Emma Sanbrailo, a teacher, and James Able Gray, who was in the
U.S. Army; the family moved to
Rome
Rome (Italian language, Italian and , ) is the capital city and most populated (municipality) of Italy. It is also the administrative centre of the Lazio Regions of Italy, region and of the Metropolitan City of Rome. A special named with 2, ...
,
Italy
Italy, officially the Italian Republic, is a country in Southern Europe, Southern and Western Europe, Western Europe. It consists of Italian Peninsula, a peninsula that extends into the Mediterranean Sea, with the Alps on its northern land b ...
, where Gray spent most of the first three years of his life; he learned to speak
Italian before English. The family then moved to
Virginia
Virginia, officially the Commonwealth of Virginia, is a U.S. state, state in the Southeastern United States, Southeastern and Mid-Atlantic (United States), Mid-Atlantic regions of the United States between the East Coast of the United States ...
, spending about four years there, until Gray's parents divorced, after which he returned to San Francisco with his mother. His father, an amateur inventor, patented a design for a ribbon cartridge for
typewriter
A typewriter is a Machine, mechanical or electromechanical machine for typing characters. Typically, a typewriter has an array of Button (control), keys, and each one causes a different single character to be produced on paper by striking an i ...
s that earned him a substantial royalty stream.
After being turned down for the
Air Force Academy
An air force academy or air academy is a national institution that provides initial officer training, possibly including undergraduate level education, to air force officer cadets who are preparing to be commissioned officers in a national air forc ...
he entered the
University of California, Berkeley
The University of California, Berkeley (UC Berkeley, Berkeley, Cal, or California), is a Public university, public Land-grant university, land-grant research university in Berkeley, California, United States. Founded in 1868 and named after t ...
as a freshman in 1961. To help pay for college, he worked as a
co-op for
General Dynamics, where he learned to use a
Monroe calculator. Discouraged by his chemistry grades, he left Berkeley for six months, returning after an experience in industry he later described as "dreadful".
Gray earned his
B.S. in engineering mathematics (Math and Statistics) in 1966.
After marrying, Gray moved with his wife Loretta to
New Jersey
New Jersey is a U.S. state, state located in both the Mid-Atlantic States, Mid-Atlantic and Northeastern United States, Northeastern regions of the United States. Located at the geographic hub of the urban area, heavily urbanized Northeas ...
, his wife's home state; she worked as a teacher and he worked at
Bell Labs
Nokia Bell Labs, commonly referred to as ''Bell Labs'', is an American industrial research and development company owned by Finnish technology company Nokia. With headquarters located in Murray Hill, New Jersey, Murray Hill, New Jersey, the compa ...
on a digital simulation that was to be part of
Multics
Multics ("MULTiplexed Information and Computing Service") is an influential early time-sharing operating system based on the concept of a single-level memory.Dennis M. Ritchie, "The Evolution of the Unix Time-sharing System", Communications of t ...
. At Bell, he worked three days a week and spent two days as a Master's student at
New York University
New York University (NYU) is a private university, private research university in New York City, New York, United States. Chartered in 1831 by the New York State Legislature, NYU was founded in 1832 by Albert Gallatin as a Nondenominational ...
's
Courant Institute. After a year they traveled for several months before settling again in Berkeley, where Gray entered graduate school with
Michael A. Harrison as his advisor. In 1969 he received his
Ph.D. in
programming language
A programming language is a system of notation for writing computer programs.
Programming languages are described in terms of their Syntax (programming languages), syntax (form) and semantics (computer science), semantics (meaning), usually def ...
s, then did two years of
postdoctoral work for IBM.
While at Berkeley, Gray and Loretta had a daughter; they were later divorced. His second wife was Donna Carnes.
Research
Gray pursued his career primarily working as a researcher and
software design
Software design is the process of conceptualizing how a software system will work before it is implemented or modified.
Software design also refers to the direct result of the design process the concepts of how the software will work which co ...
er at a number of industrial companies, including
IBM
International Business Machines Corporation (using the trademark IBM), nicknamed Big Blue, is an American Multinational corporation, multinational technology company headquartered in Armonk, New York, and present in over 175 countries. It is ...
,
Tandem Computers, and
DEC. He joined
Microsoft
Microsoft Corporation is an American multinational corporation and technology company, technology conglomerate headquartered in Redmond, Washington. Founded in 1975, the company became influential in the History of personal computers#The ear ...
in 1995 and was a Technical Fellow for the company until he was lost at sea in 2007.
Gray contributed to several major database and transaction processing systems.
IBM's System R was the precursor of the
SQL relational databases that have become a standard throughout the world. For Microsoft, he worked on
TerraServer-USA and
Skyserver.
Roger Sippl
Roger J. Sippl (born February 22, 1955), an American entrepreneur in the computer software industry, was described in 2012 by The Wall Street Journal as a serial entrepreneur. Sippl was the founder and Chief executive officer, CEO of Informix Cor ...
described Gray as among the "technical gods in this industry", widely respected as a neutral arbiter on standards committees.
His best-known achievements include:
*
ACID
An acid is a molecule or ion capable of either donating a proton (i.e. Hydron, hydrogen cation, H+), known as a Brønsted–Lowry acid–base theory, Brønsted–Lowry acid, or forming a covalent bond with an electron pair, known as a Lewis ...
, an acronym describing the requirements for reliable transaction processing and its software implementation
*
Granular database locking
* Two-tier transaction
commit semantics
* The
Five-minute rule for allocating storage
*
OLAP cube
An OLAP cube is a multi-dimensional array of data. Online analytical processing (OLAP) is a computer-based technique of analyzing data to look for insights. The term ''cube'' here refers to a multi-dimensional dataset, which is also sometimes cal ...
operator for
data warehousing
In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for Business intelligence, reporting and data analysis and is a core component of business intelligence. Data warehouses are central Re ...
* Characterization of
software bug
A software bug is a design defect ( bug) in computer software. A computer program with many or serious bugs may be described as ''buggy''.
The effects of a software bug range from minor (such as a misspelled word in the user interface) to sev ...
types
He assisted in developing
Virtual Earth. He was also one of the co-founders of the
Conference on Innovative Data Systems Research.
Disappearance

Gray, an experienced sailor, owned a sailboat. On January 28, 2007, he failed to return from a short solo trip to scatter his mother's ashes at the
Farallon Islands near
San Francisco
San Francisco, officially the City and County of San Francisco, is a commercial, Financial District, San Francisco, financial, and Culture of San Francisco, cultural center of Northern California. With a population of 827,526 residents as of ...
.
The weather was clear, and no distress call was received, nor was any signal detected from the boat's automatic
Emergency Position-Indicating Radio Beacon.
A four-day
Coast Guard
A coast guard or coastguard is a Maritime Security Regimes, maritime security organization of a particular country. The term embraces wide range of responsibilities in different countries, from being a heavily armed military force with cust ...
search using planes, helicopters, and boats found nothing.
On February 1, 2007, the
DigitalGlobe satellite scanned the area
and the thousands of images were posted to
Amazon Mechanical Turk. Students, colleagues, and friends of Gray, and computer scientists around the world formed a "Jim Gray Group" to study these images for clues. On February 16 this search was suspended, and an underwater search using sophisticated equipment ended May 31.
Marine search expert Bob Bilger explains that the type of boat used by Gray, a
C&C 40 is vulnerable to hull damage, and can sink as quickly as in 30 seconds, also taking any equipment with it, not leaving any loose debris.
The
University of California, Berkeley
The University of California, Berkeley (UC Berkeley, Berkeley, Cal, or California), is a Public university, public Land-grant university, land-grant research university in Berkeley, California, United States. Founded in 1868 and named after t ...
and Gray's family hosted a tribute on May 31, 2008. Five years after the disappearance, Carnes petitioned a court to have her husband declared dead and on January 28, 2012, Gray was
declared legally dead.
In 2012, Carnes co-authored a paper on coping with
ambiguous loss. In 2014, in conjunction with the disappearance of
Malaysia Airlines Flight 370, CNN interviewed Carnes.
At the time, she lived with her elderly mother who was suffering from dementia in Wisconsin.
Legacy
Microsoft's
WorldWide Telescope software was dedicated to Gray. In 2008,
Microsoft Research
Microsoft Research (MSR) is the research subsidiary of Microsoft. It was created in 1991 by Richard Rashid, Bill Gates and Nathan Myhrvold with the intent to advance state-of-the-art computing and solve difficult world problems through technologi ...
opened Gray Systems Lab, a research center in
Madison, Wisconsin
Madison is the List of capitals in the United States, capital city of the U.S. state of Wisconsin. It is the List of municipalities in Wisconsin by population, second-most populous city in the state, with a population of 269,840 at the 2020 Uni ...
, named after Jim Gray.
Database conference
SIGMOD confers the Jim Gray Doctoral Dissertation Award annually to doctoral candidates researching databases.
Each year,
Microsoft Research
Microsoft Research (MSR) is the research subsidiary of Microsoft. It was created in 1991 by Richard Rashid, Bill Gates and Nathan Myhrvold with the intent to advance state-of-the-art computing and solve difficult world problems through technologi ...
presents the
Jim Gray eScience Award to a researcher who has made an outstanding contribution to the field of
data-intensive computing.
Award recipients are selected for their ground-breaking, fundamental contributions to the field of eScience. Previous award winners include
Alex Szalay (2007),
Carole Goble (2008),
Jeff Dozier (2009),
Phil Bourne (2010), Mark Abbott (2011),
Antony John Williams
Antony John Williams is a British chemist and expert in the fields of both nuclear magnetic resonance (NMR) spectroscopy and cheminformatics at the United States Environmental Protection Agency. He is the founder of the ChemSpider website t ...
(2012), and Dr.
David Lipman, M.D. (2013).
See also
*
List of people who disappeared mysteriously at sea
Notes
References
External links
Gray's Microsoft Research home pageGordon Bell, Leslie Lamport, and Butler W. Lampson, "James N. Gray", Biographical Memoirs of the National Academy of Sciences (2013)
{{DEFAULTSORT:Gray, James N.
1944 births
2000s missing person cases
2007 deaths
American computer scientists
Courant Institute of Mathematical Sciences alumni
Database researchers
Digital Equipment Corporation people
IBM Research computer scientists
Members of the United States National Academy of Engineering
Members of the United States National Academy of Sciences
Microsoft employees
Missing person cases in California
Microsoft technical fellows
People declared dead in absentia
People lost at sea
Scientists from California
Turing Award laureates
UC Berkeley College of Engineering alumni