Olympic Software - SQL Database Consulting

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

About Olympic Software

Olympic Software provides database consulting and development services in the areas of client/server computing, Web-database connectivity, and SQL database management systems (Oracle, Microsoft SQL Server and others). Consulting projects performed by Olympic Software 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 SQL and client/server topics for national computer magazines. Click on the Articles tab to see a list, including links to on-line 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 recent 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, VMS, NetWare

Web Servers: Apache, Microsoft IIS, Netscape Enterprise Server

Tools

Oracle: PL/SQL, SQL*Plus, Developer/2000, Pro*C

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

Sybase: Transact-SQL, PowerBuilder, APT-SQL

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

Centura/Gupta: Team Developer, SQLWindows

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, 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, WeSync.com.

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 in the late 1990's most of the projects 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

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 software to load the data and index it for fast retrieval using PL/SQL.

Event Finder

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 going back 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 and JavaScript.

Regional Mark Information System