blueoakdb_name
Database_Engineering
Recent Examples of Blueoak's High Impact Work

An Oracle "SWAT" call. Web Recruiter's Advanced Search was running exceptionally slow. The application dynamically creates the SQL based on user input. By collecting metrics and analyzing the results, we were able to provide a set of rules by which we reduced the search time by as much as 1/10 of the original time. Web Recruiter
Implemented Quality of Service using Netfilters and Hierarchical Token Buffers (HTB) to provide a consistent user reponse and give VOIP packets a higher priority for their different upstreams. This WISP (Wireless Internet Service Provider) has two upstream feeds which run at different rates. The primary feed is 10x faster than the secondary. Blueoak engineered and implemented an ISP High-Availability program which allows the WISP to failover to its backup ISP when its primary connection goes down. Upon revival of the primary connection, the WISP failsback automatically. The solution is 100% transparent to the WISP subscribers, they only detect less throughput. When failover/failback occurs, the respective QoS profile is used to ensure even responsiveness. Wakenet
Ran a series of penetration tests to uncover vulnerabilities. The appropriate remedies were implemented. Wakenet
Ran a series of penetration tests to uncover vulnerabilities and effectively locked down public-facing servers. Courtland
Called upon to improve the performance of SQL Server applications in two settings:

www.tradestops.com

  • normalized and restructured the database to improve scalability and extensibility
  • wrote migration code to migrate the existing schema to the upgraded version
  • tuned batch processing to minimize the impact to the online sytem while reducing its wall-time

www.patternsforprofit.com

  • normalized and restructured the database for improved scalability and extensibility

Stratadat
Called in to data architect the next release of DigitalGlobe's satellite imaging system. This involved understanding the existing Federated systems to provide a migration plan to the new, centralized system. The project deliverables included the data model with over 200 tables, migration documents and migration code and the data dictionary. DigitalGlobe Inc
Tuned batch and online processes, resulting in a 2x - 10x speed up of every critical process. This effort provided essential optimizations for the latest release of the Michigan Child Support Enforcement System. State of Michigan, MICSES Project Management
Migrated 174,026 lines of C code from Oracle OCI 7 to OCI 8 by using Blueoak's OCI Shim. The shim allowed for the monumental task to be accomplished in record time. The shim compiles and runs on Windows, Linux, Solaris, AIX, OSF, HP-UX, IRIX and other platforms. Computer Associates
"Blueoak was an indispensable partner in SGI's recent success at Sybase TechWave 2002. With some key internal resources tied up with some other projects, we needed expert assistance to put together a presentation and demonstration very quickly. Because of their experience and technical expertise with SGI, Sybase and other databases, we turned to Blueoak, which did a superior job on a tight schedule and within budget." J. Tuleya, Strategic Alliance Manager, SGI
Called in on a SWAT-call by Online Software to develop the backend on a Java application. Blueoak designed the schema, wrote all the PL/SQL code and helped deploy the application well before the product deadline. VW/Audi
Provided onsite engineering services at Sybase Inc for SGI:
  • Designed and wrote the software to merge IRIX FailSafe with Sybase ASE High-Availability.
  • Wrote documentation to be rolled out with the product.
  • Wrote freeware scripts for customer use
Represented SGI at Sybase Inc
Helped Computer Associates tune one of their key commercial applications. The application is deployed across MS SQL, Oracle and Sybase ASE. The database tuning along with application refactoring resulted in a seven fold performance improvement! Computer Associates
Called in on a SWAT-call to merge the hardware SGI's FailSafe (High-Availability) solution with the Sybase ASE High-Availability product. SGI Federal, Denver CO
" ... rewrote our core business application after several other consultants had tried and failed. This effort saved our company." J. Newland, President, Computer Press
Provided a schema audit to ensure scalability and correctness. Additionally worked with the development team to demonstrate how to implement trees within an RDBMS. Sun Microsystems
Pro bono effort: " ... demonstrates a high degree of technical expertise matched by integrity. I personally recommend the services of Blueoak." G. Ching, Magnolia Road Internet Cooperative
" ... architected and implemented the backend of our highly scalable and award winning JobPlanet Application." P. Coulson - CTO of PureCarbon, Inc




USA, © 2003 - 2005 Blueoak Database Engineering, LLC. All Rights Reserved. 
Canada, © 2003 - 2005 Blueoak Database Engineering, Inc. All Rights Reserved.