Andy Woods

Andy Woods

Brooklyn, New York, United States
3K followers 500+ connections

About

I lead product at DualEntry, the ERP built from the ground up to solve what legacy…

Activity

3K followers

See all activities

Experience

  • DualEntry

    New York, New York, United States

  • -

    New York, New York, United States

  • -

    New York, New York, United States

  • -

    New York, New York, United States

  • -

    New York, New York, United States

  • -

    New York, New York, United States

  • -

    Greater Chicago Area

  • -

    San Francisco Bay Area

  • -

    Greater Chicago Area

  • -

    Washington DC-Baltimore Area

  • -

    Washington DC-Baltimore Area

  • -

    Washington DC-Baltimore Area

Education

  • Northwestern University - Kellogg School of Management

    -

    -

    Activities and Societies: Kellogg Growth Scholarship, Dean's Service Award, Chair Private Equity and Venture Capital Conference, EATZ Director, Beta Gamma Sigma

    I am an MBA graduate with distinction from the Kellogg School of Management who majored in marketing with a focus on entrepreneurship.

  • -

    -

Publications

  • Enabling the Next Generation of Multi-Region Applications with CockroachDB

    SIGMOD

    A database service is required to meet the consistency, performance, and availability goals of modern applications serving a global user-base. Configuring a database deployed across multiple regions such that it fulfils these goals requires significant expertise. In this paper, we describe how CockroachDB makes this easy for developers by providing a high-level declarative syntax that allows expressing data access locality and availability goals through SQL statements. These high-level goals…

    A database service is required to meet the consistency, performance, and availability goals of modern applications serving a global user-base. Configuring a database deployed across multiple regions such that it fulfils these goals requires significant expertise. In this paper, we describe how CockroachDB makes this easy for developers by providing a high-level declarative syntax that allows expressing data access locality and availability goals through SQL statements. These high-level goals are then mapped to database configuration, replica placement, and data partitioning decisions. We show how all layers of the database, from the SQL Optimizer to Replication, were enhanced to support multi-region workloads. We also describe a new Transaction Management protocol that enables local, strongly consistent reads from any database replica. Finally, the paper includes an extensive evaluation demonstrating that CockroachDB's new declarative SQL syntax for multi-region clusters is easy to use and supports a variety of configuration options with different performance tradeoffs to benefit a variety of workloads. We also show that throughput scales linearly with the number of regions, and the new Transaction Management protocol reduces tail latency by over 10x compared to prior approaches.

    See publication
  • CockroachDB: The Resilient Geo-Distributed SQL Database

    SIGMOD

    We live in an increasingly interconnected world, with
    many organizations operating across countries or even continents. To serve their global user base, organizations are
    replacing their legacy DBMSs with cloud-based systems capable of scaling OLTP workloads to millions of users.
    CockroachDB is a scalable SQL DBMS that was built from
    the ground up to support these global OLTP workloads
    while maintaining high availability and strong consistency.
    Just like its namesake…

    We live in an increasingly interconnected world, with
    many organizations operating across countries or even continents. To serve their global user base, organizations are
    replacing their legacy DBMSs with cloud-based systems capable of scaling OLTP workloads to millions of users.
    CockroachDB is a scalable SQL DBMS that was built from
    the ground up to support these global OLTP workloads
    while maintaining high availability and strong consistency.
    Just like its namesake, CockroachDB is resilient to disasters
    through replication and automatic recovery mechanisms.
    This paper presents the design of CockroachDB and its
    novel transaction model that supports consistent geo-distributed transactions on commodity hardware. We describe how
    CockroachDB replicates and distributes data to achieve fault
    tolerance and high performance, as well as how its distributed
    SQL layer automatically scales with the size of the database
    cluster while providing the standard SQL interface that users
    expect. Finally, we present a comprehensive performance
    evaluation and share a couple of case studies of CockroachDB
    users. We conclude by describing lessons learned while building CockroachDB over the last five years.

    See publication

Patents

  • SYSTEMS AND METHODS FOR CONTROLLING REPLICA PLACEMENT IN MULTI-REGION DATABASES

    Issued US 12,499,127 В2

    Systems and methods for controlling placement of replicas of data in a multi-region database are provided. A selection of a super region including at least first and second database regions can be received. A voting replica of data can be stored within the second database region based on the selection of the super region and a failure of the first database region. A selection of a secondary database region can be received. A voting replica of data can be stored within the secondary database…

    Systems and methods for controlling placement of replicas of data in a multi-region database are provided. A selection of a super region including at least first and second database regions can be received. A voting replica of data can be stored within the second database region based on the selection of the super region and a failure of the first database region. A selection of a secondary database region can be received. A voting replica of data can be stored within the secondary database region based on the selection of the secondary database region and a failure of a primary database region. Non-voting replicas of data can be stored in a subset of a plurality of database regions. A selection of a restricted replica placement configuration can be received. The non-voting replicas can be removed from database regions based on the selection of the restricted replica placement configuration.

    Other inventors
    See patent

Honors & Awards

  • Kellogg on Growth Scholarship Recipient

    Kellogg School of Management

  • iContact Scholarship Recipient

    iContact Foundation

Recommendations received

2 people have recommended Andy

Join now to view

View Andy’s full profile

  • See who you know in common
  • Get introduced
  • Contact Andy directly
Join to view full profile

Other similar profiles

Explore top content on LinkedIn

Find curated posts and insights for relevant topics all in one place.

View top content

Add new skills with these courses