Clients & ProjectsAll projects completed in the last three years are listed, plus selected older projects, in reverse chronological order.
References available on request
Information management & technology planningThe Getty Research InstituteMulti-year project to improve use of Getty vocabularies for enhanced searching of all Getty websites and resources. Dozens of Getty offices create and/or use vocabularies for cataloging and searching. One major goal is to foster consistent use of the vocabularies as well as capturing new terms from numerous systems. Issues of data and its meaning, workflow, and system integration are foremost. February 2002 - present The J. Paul Getty Trust Information Technology ServicesDesign and development of formats, XML schemas, and conversion specifications for contribution to and distribution of the three Getty vocabularies (Art & Architecture Thesaurus, Thesaurus of Geographic Placenames, and Union List of Artist Names). Each vocabulary has three distribution formats: relational tables, XML, and MARC. January 2001 - present The World BankAnalysis of the information and records management policies of the World Bank, especially with reference to how policies relate to electronic documents and media. Development of a comprehensive policy framework for current and future information management addressing documents in all media. Work with Bank staff to prepare new policy statements to address problems found in the analysis and comprehensive framework. March - October 2000 Antelope Valley Indian MuseumPlanning for public access to existing museum catalog and images and for extensive web-based educational programs to teach the significance of the objects. Recommendations for infrastructure improvements. Cost estimates and three-year implementation schedule. The planning resulted in the Museum's successful application to the Getty Grants Program for full implementation funding. November 1998 - March 1999 Norton Simon Museum of Art in PasadenaPlanning for an online catalog of collections data and images. Recommendations for collections-management system to replace existing custom system. Recommendations for public access to catalog. Development of imaging strategies for inhouse and public use. Cost estimates and three-year implementation schedule. The planning resulted in the Museum's successful application to the Getty Grants Program for full implementation funding. August 1998 - March 1999 Los Angeles County Museum of ArtOngoing support for planning and implementation of art information systems.
May 1998 - September 2001 Pacific Asia Museum, PasadenaPlanning for an integrated collections information system with public access. Exploration of options for Web access to integrated museum, library, and photo-archive data. Development of three-year implementation plan with costs. The planning resulted in the Museum's successful application to the Getty Grants Program for full implementation funding. January - October 1998 Systems design & developmentLos Angeles County Museum of ArtIntegrated searching of two websites: Lacma.org and CollectionsOnline, which use different technologies for indexing and retrieval. Major technologies: Perl, MWeb XML Server, XSLT In development J. Paul Getty Trust Information Technology ServicesOngoing work related to vocabulary and bibliographic data. Major activities include conversion into and out of XML, conversion into and out of MARC, development of test data, data validations, XML schema design. Major technologies: Perl, PL/SQL, XML, Oracle, SQL Server July 2004 - present J. Paul Getty Trust Information Technology ServicesConversion of the 6-million record file of the National Imagery and Mapping Agency (NIMA) to XML format. These new terms will then be added to the Thesaurus of Geographic Names (TGN). Major technologies: Perl, XML May 2003 - present The Getty Research InstituteConversion of authority records from the Avery Index to Architectural Periodicals from MARC to XML. Conversion of authority records from the Bibliography of the History of Art (BHA) from Sybase to XML. The output of both conversions will be added to the Art & Architecture Thesaurus. Major technologies: Sybase, Perl, XML March 2003 - present J. Paul Getty Trust Information Technology ServicesMapping and conversion of the three Getty vocabularies from Oracle to export tables, XML, and MARC/Authorities. Development of XML schemas for the vocabularies to be used for all publications and contributions. (The three vocabularies are the Art & Architecture Thesaurus, the Thesaurus of Geographic Names, and the Union List of Artist Names). Major technologies: Oracle, PL/SQL, Perl, XML January 2001 - present Los Angeles County Museum of ArtDevelopment of a system to track workflow of photography, scanning, and image editing. Major technologies: Microsoft Access, Visual Basic Installed November 2000 J. Paul Getty Trust Information Technology ServicesTechnical Lead for reconstruction of the Art & Archaeology Technical Abstracts database and subsequent web publication. Four systems had been used over time to manage this database; the project merges all four into one editorial system, and then exports in XML to a web-publication system. This project had the following major components:
Major technologies: Data modeling, Access, FoxPro, Perl, XML August 2000 - December 2002 Canadian Heritage Information NetworkUpgrades to Newmatch system we developed in 1990 and which is still in use. Newmatch prevents duplicate records in the Conservation Information Network bibliographic database by implementing a sophisticated algorithm for matching records to find potential duplicates. Duplicates are presented to the editors on-screen in a format that permits merging 50 sets of duplicates per hour. Current work is primarily to convert the system to Windows, to change the underlying character set, and to provide more flexibility. Major technologies: Delphi Installed January 2000 MWeb™ Online Catalogs
More information and MWeb sites September 1997 - present The Getty Information Institute Census of Antique Art and Architecture Known to the Renaissance
Developer of Janus, the Web version of the Census of Antique Art & Architecture Known to the Renaissance, a large, complex database with images. Janus is the first time that this 50-year-old database has been available to scholars without special equipment. Janus accesses data sources through SQL and ODBC, and images on multiple servers. This system was completed in half the time (ten months) and at half the cost that the client had expected. Article on the development of Janus Installed March 1998 California Statewide Serials ProjectTechnical assistance to the University of California Division of Library Automation with loading serials records from 800 libraries state-wide into the Melvyl online catalog. March 1995 - June 1997 Luna Imaging, Inc.Developer of systems to provide access to high quality images and data. These systems are deployed in some of the world's major museums, universities, and research institutions.
September 1993 - August 1998 MARCView™ and MARConvert™
MARCView/Super provided an Internet/intranet solution. This product has been discontinued. March 1993 - present Sites with Systems Planning softwareThis is a partial list of sites with software developed by Systems Planning. Our software is now used in 54 countries around the world.
All contents of website, including HTML and JavaScript, copyright © 1996-2010 Systems Planning. MWeb, InFORMer, and CAPS are trademarks of Selago Design, Inc. MARCView and MARConvert are trademarks of OCLC, Inc. Systems Planning 4915 Redford Road Bethesda, MD 20816 USA (301) 652-1231 info@systemsplanning.com Including the name of one of our products in the subject of your message will bypass all spam filters. |