Olympic Software
1081 NW Stannium Rd
Bend, OR 97701
Phone: 541-408-4057
Email: steveroti@olympicsoftware.com

About Olympic Software

Olympic Software provides database consulting and development services in the areas of data warehousing, cloud computing, Web-database connectivity, and SQL database management systems (Oracle, Microsoft SQL Server and others). Consulting projects have included needs analysis, software selection and installation, systems analysis, entity-relationship data modeling, database design, and application development. Click on the Consulting tab to see a list of supported platforms and tools.

Projects performed by Olympic Software have covered many industries and business areas including: distribution, engineering, manufacturing, marketing & sales, medical, pharmaceutical, scientific, transportation, and warehousing. Olympic Software was founded in 1984 and has successfully completed hundreds of projects for companies in Oregon, Washington, California and Alaska. Click on the Projects tab to see a partial list of projects and clients.

Steve Roti, the owner of Olympic Software, has 25 years of professional experience. He holds Bachelors and Masters degrees in Electrical and Computer Engineering from the University of California at Davis. Prior to forming Olympic Software, Steve worked in industry as a software engineer, participating in large-scale engineering projects and personal computer mass-market software development. In addition, Steve has written numerous articles on database topics for national computer magazines. Click on the Articles tab for a list of his articles.

Consulting Services

Olympic Software's consulting projects have spanned a wide range of database management systems and operating systems, and have involved the use of many different programming languages and software development tools. Platforms and tools used in previous projects are listed below. The Olympic Software philosophy is to use the right tool for the job, rather than a one-size-fits-all approach. If you would like more information about Olympic Software's consulting services please call or send an email message describing your project requirements.

Platforms

» Databases: Oracle, Microsoft SQL Server, MySQL, Sybase, Informix, Ingres, SQLBase

» Operating Systems: Windows Server, Linux, Unix, Macintosh

» Web Servers: Apache, Microsoft IIS

Tools

» Oracle: PL/SQL, SQL*Plus, Oracle Developer Suite, Pro*C

» Microsoft: Transact-SQL, ASP, Access, Visual Studio, Microsoft C

» Sybase: Transact-SQL, PowerBuilder, APT-SQL

» CA/Ingres: SQL, ESQL, ABF/4GL, Windows4GL

» Web Development: PHP, Perl, JavaScript, VBScript, HTML, CSS, XML, Google Maps

» Enterprise Resource Planning: SAP, Visual Manufacturing

Projects: Partial List of Clients

Acumed, Alaska Department of Fish and Game, BendBroadband, Disney Internet Group, ESCO Corp., Georgia-Pacific, Hewlett-Packard, Insurance Marketing Corp. of Oregon, Infoseek, Mentor Graphics, Pacific Power, Pacific States Marine Fisheries Commission, Rundel Products, Summit Research Network.

Overview of Projects

Olympic Software has been involved in a wide variety of database development projects since 1984. In general, most of the projects in the mid-1980's used host-based or minicomputer databases. In the late 1980's and early to mid-1990's most of the projects were client/server oriented. And since the late 1990's most of the projects have involved Web-database integration. The common thread in all of these projects has been professional, practical database design and application development using state-of-the-art SQL database management systems.

Example Projects

Event Finder The Event Finder, a nationwide database of events in categories such as Arts, Fairs & Festivals, Family, Music, Performing Arts, Recreation, and Sports. The event database was originally developed in Oracle running on Sun hardware, and later ported to Microsoft SQL Server running on Windows NT. The Event Finder search engine performs queries based on date, category, metro area, venue, artist and keyword. Olympic Software designed the database and wrote the PL/SQL software to load the data and index it for fast retrieval.
Regional Mark Information System The Regional Mark Information System, a coast-wide database of salmon releases and recoveries in California, Oregon, Washington, British Columbia and Alaska used by fishery researchers to perform stock assessments. There are approximately ten million rows of data over 30 years. The database was developed in Ingres on Sequent hardware and later ported to Oracle on Linux. Olympic Software designed the database, wrote the software to load the data, and wrote the Web-based query system using Perl and PHP.
PacFIN Explorer The Pacific Fisheries Information Network (PacFIN) provides data warehousing for commercial fisheries data. PacFIN is a joint Federal and State data collection and information management project covering California, Oregon, Washington and Alaska. There are approximately 100 million rows of data in the data warehouse. Olympic Software designed the Oracle database, wrote the PL/SQL software to load the data, and wrote the Web-based multi-dimensional query tool named PacFIN Explorer in PHP.
Google Maps Google Maps is a popular tool for visualizing geospatial information and interacting with the information in a familiar Web browser. The Google Maps API allows developers to embed customized maps in database-driven Web applications. Olympic Software has built many database front-ends in Google Maps using JavaScript, PHP and VBScript to display data stored in Oracle, SQL Server, and MySQL.

Magazine articles written by Steve Roti

  • Oracle's Universal Server: The Context Server Option, OReview, April 1997.
  • Hands On Review: Oracle Developer/2000, DBMS, April 1997.
  • Hands On Review: Crystal Reports 5.0, DBMS, January 1997.
  • Hands On Review: Data Director 2.0, DBMS, November 1996.
  • Hands On Review: Centura Team Developer, DBMS, July 1996.
  • Hands On Review: Sybase SQL Anywhere, DBMS, June 1996.
  • Indexing and Access Mechanisms, DBMS, May 1996.
  • Hands On: Gupta SQLBase 6.0, DBMS, September 1995.
  • Hands On: FileMaker Pro Server 2.1, DBMS, July 1995.
  • New Jet Engine in Access 2.0, Visual Basic Programmer's Journal, June/July 1994.
  • SQL Server Toolkit 4.2, Visual Basic Programmer's Journal, May/June 1994.
  • Client/Server: Getting the Big Picture, ComputerLand Magazine, January/February 1993.
  • The Server Side, DBMS, monthly column, September 1992 to November 1994.
  • CASE Meets Windows, Oracle Technical Journal 4, Winter 1992.
  • Ingres on Windows, DBMS, February 1992.
  • Exception Handlers in PL/SQL, International Oracle Users Journal 3, Fall 1991.
  • Pull-down Menus in Ingres 4GL, Ingres World 91 Proceedings.
  • SQLWindows, Data Based Advisor, September 1990.
  • Desktop Oracle, DBMS, monthly column, January 1990 to August 1992.
  • Oracle Demystified, Data Based Advisor, July 1989.
  • A Look at the New Informix, Data Based Advisor, February 1989.
  • Oracle Meets HyperCard, DBMS, January 1989.
  • SQL + 4GL = Informix, Data Based Advisor, September 1988.
  • Professional Oracle: The Industrial Strength DBMS, Data Based Advisor, June 1988.
  • Ingres for PCs, PC Magazine, May 17, 1988.
  • SQL Application Development: The Ingres Approach, Data Based Advisor, Nov. 1987.