Data is the lifeblood of business
It’s essential to all transaction processing systems and elemental in any business intelligence system. Over the past three decades, it was relatively easy to store and to share data, and Relational Database Management Systems (RDBMS) were the tool of choice. In recent years, Big Data has arrived with an explosion in the volume, velocity and variety of data. New technologies are now available to help meet the challenges associated with Big Data. Integra has the expertise to help you understand the potential and harness the power of these new technologies.
Integra provides expertise in three related areas:
Oracle, SQL Server, MySQL, PostgreSQL, DB2, Sybase
Relational Database Management Systems have been around since Oracle version 2 was released in 1979 by Relational Software, Inc. (RSI), which eventually changed its name to Oracle Corporation. Integra’s experience with Relational Databases goes back to this very first release of the very first RDBMS when founder and CEO David Teplow became one of Oracle’s first customers in 1981. As RDBMS became the standard for storing data and Oracle maintained its lead in the industry, Integra has stayed ahead of the curve with its deep and comprehensive RDBMS expertise. Our decades of experience in designing, building, and supporting RDBMS helps you derive the utmost value from your investment in this technology.
Integra’s consultants are recognized leaders in the Oracle Users Group community, having served as presidents and directors of the Northeast OUG, Independent OUG and Oracle Development Tools UG. We have given numerous presentations at conferences such as IOUG Collaborate, East Coast Oracle (ECO), ODTUG Kscope, RMOUG, NYOUG and NOUG Training Days / Meetings. We are proud of the knowledge we have gained over the years and we are committed to sharing that knowledge with our community and our clients.
Integra’s RDBMS expertise goes beyond Oracle, and includes PostgreSQL, MySQL, SQL Server, DB2, and Sybase. This gives us an understanding of the relative strengths and weaknesses between products when making recommendations. It also helps when building a data warehouse that pulls data from a variety of operational systems that may use different RDBMS products, for example, or when migrating a client from one RDBMS product to another.
Hadoop / NoSQL
Cloudera, Hortonworks and Apache Hadoop, Spark Framework / Vertica, MongoDB, Cassandra, Pivotal Greenplum
Relational Databases are ideally suited for transactional systems, which deal with structured data and benefit when that data is normalized (see Third Normal Form (3NF)). The same is not true for Decision Support / Analytical Systems. Using Relational Databases for these systems introduces unnecessary Expense, Time and Liability (the other ETL).
- The expense associated with incremental labor and database licenses for ODS and Data Marts.
- The time it takes to transport, transform, aggregate, and denormalize data.
- The liability that comes with denormalized data with regard to update anomalies.
An even bigger challenge to Relational Databases posed by Big Data is its largely unstructured format, which makes it unsuitable for database tables made up of fields that are rigidly typed (for example, six-digit integer, floating point number, fixed- or variable-length character string of exactly X or no more than Y characters, and so on) and often come with constraints (for example, range checks or foreign key lookups).
In recent years, a number of NoSQL Databases have emerged, from both the commercial and open source communities, and matured to the point of being sufficiently robust and dependable. NoSQL Databases include key-value, document-oriented and column-oriented Databases. The most interesting entry to the NoSQL space is Hadoop, a distributed storage and processing framework that runs on clusters of commodity hardware. Even more recently, Spark was introduced as another open source project and even better processing framework.
Integra has hands-on experience with Hadoop and Spark, as well as with NoSQL Databases like MongoDB, an open source document-oriented database, Cassandra, an open source key-value store, and Vertica, a column-oriented database now owned by HP.
Languages and tools to analyze, visualize and transport data
Integra has experience with a number of open source and commercial products that work with data in Relational and Non-relational Databases. These include: