• Portability

     Across

     Repositories

    Quickly migrate from high cost database and data warehouse infrastructure to low cost open source solutions.

    No code rewrites required to use your existing business rules and analytics with low cost Big Data infrastructure.

  • Automatic 

    Code 

    Translation 

    Compile your current queries and business logic to execute without modification on a new data processing platform.

    Save time and be confident that your code will execute exactly the same on your new platform.

  • Platform Emulation 

    Open source solutions imitate 

    proprietary systems. 

    Users think they are using a proprietary system:

    In reality their code is running on low cost infrastructure.

Solutions

Automatic Code Transpiling
(Offline)

CompilerWorks compiles from one dialect of SQL (and control language) and emits equivalent code in another.
  • Equivalent code produced for new platform
  • Automatically transform data structures for optimal execution
  • Clean, human readable code emitted
  • Automatically adheres to coding standards

Source Language

(SQL and Procedural)

Database Schema

Intermediate Representation

Compiler:
Transpilation from Source (proprietary) platform to equivalent code on target platform (open), including requested transformations.

 

Target Language

(open platform)

Platform Emulation
(Online)

Use CompilerWorks in front of an open source data processing repository - now it will appear like the proprietary system it is emulating.
  • Looks like a proprietary platform to end users
  • Compiles code on the fly to execute on the new platform
  • Automatically persists compiled code to deliver performance

Source Language

(SQL and Procedural)

Platform Emulator

Compiler and Executor:
Transpilation from Source (proprietary) platform and execution/control of execution on target platform (open).

 

Target Platform


Technology

CompilerWorks has developed a robust infrastructure that can ingest one dialect of SQL (and associated procedural language) into an Intermediate Representation (IR) and then emit in a different dialect of SQL (and associated procedural language).

Once represented in the IR, transformations can be applied to the entire code base to optimize performance on the target platform, and a comprehensive lineage model can be used for code dissection and clean-up.

Source Language

Query(s) in a growing number of languages and dialects.

Ingest

Intermediate Representation

Compiler Transformations


  • Business logic transformation
  • Platform specific optimization
  • Feature emulation
  • Standardize coding patterns

Lineage Model


  • Comprehensive data provenance and lineage
  • Identify dead code for process elimination
  • Highlight mis-use of operators (bad coding practices)
Emit

Target Language

Executable (or code) to run analysis on target platform:

  • Open platforms: Presto, Hive, Spark, Impala, Cassandra, Splice Machine, Map/Reduce, et.c.
  • Proprietary platforms: Oracle PL/SQL, Vertica SQL, Teradata SQL, Netezza SQL, et.c.
  • Procedural execution languages: Java, Python, BTEQ, et.c.
Control readability vs. "level of compatibility" through compiler configuration options.

Clients say about us

  • “We estimated it would take 10,000 developer hours to move our library of queries from Vertica. We did it in a few hundred with the help of CompilerWorks.”
    — GM Data Engineering, Major Social Networking Co.
  • “CompilerWorks separates business interests from technical implementation, letting our clients to put less effort into managing technology platforms and invest more time applying analytics to drive their business.”
    — CTO, Clarity Solution Group, North America’s largest data analytics professional services firm
  • “We wanted Oracle users to be able to port their query libraries to our high scalable, ACID compliant infrastructure. CompilerWorks has the knowledge and technology to make that a reality.”
    — SVP Marketing, Data Repository "Manufacturer"

(video coming soon)

Demo

Lineage Explorer Screenshot

 

Our Team

Shevek

Shevek

CTO
Gerald Wluka

Gerald Wluka

CEO
Future Team Members

Join Our Team

TBD