EnterpriseDB

YugabyteDB

YugabyteDB, What Is It Good For?

YugabyteDB, What Is It Good For? 800 507 Exist Software Labs

The database evolved from the network & hierarchical model of the 60s to what eventually became the dominant force in databases in the 70s up to the present time—the relational model. From this model arose the big names in Relational Database Management Systems like DB2, Oracle, and Sybase. In the 80s, a player emerged that would forever change the RDBMS landscape: Postgres.

Postgres is the only RDBMS to have won DB of the year 3 times: 2017, 2018, & 2020. This speaks of the universal trust that developers have placed on the system and this has only increased with the rise of open-source software and cloud-native computing.

Which begs the question: What is cloud-native computing? To put it simply, the rise in the services-based model championed by the major cloud providers like AWS, GCP, & Azure has given way to a new way of developing applications, with key emphases on scalability, resilience, high-availability, and agile deployments.

Combining the relational supremacy of Postgres and cloud-native computing, we are then faced with the next step in the evolution of the RDBMS—Distributed SQL— and YugabyteDB is the No. 1 Distributed SQL platform today.

Use Cases

What is YugabyteDB good for? I will mention 4: cloud-native applications, applications requiring massive scale, geo-distributed workloads, and traditional RDBMS modernization.

1. Cloud-native applications – Build stateful microservices by leveraging modern cloud-native frameworks such as GraphQL, or in any language of your choice like Django, Spring, Go, etc.

2. Massive-scale applications – Seamlessly deploy IoT and streaming services that demand high throughput, support for large data sets, and/or many concurrent connections.

3. Geo-distribution – Move data closer to users for resilience, performance, and compliance with the industry’s largest choice of deployment and replication models.

4. RDBMS modernization – Evolve Oracle, SQL Server, and DB2 workloads to a modern distributed SQL database with minimal disruption. If you can migrate to PostgreSQL, you can migrate to YugabyteDB.


Real-World Projects

We have deployed YugabyteDB in several government and educational institutions that employed cloud-native applications development—requiring user connectivity from various geo-locations—along with the migration of MySQL databases.

YugabyteDB has delivered in all of these projects, requiring very minimal tweaking in existing SQL code and even speeding up queries in many instances.

YugabyteDB will very soon be the de facto RDBMS of choice in a cloud-native world.

Exist is your data solutions partner of choice!

Explore the next level of your digital transformation journey with our Data Solutions Services. Let’s look at opportunities to better maximize your ROI by turning your data into actionable intelligence. Connect with us today, and we’ll proudly collaborate with you!

The Elephant Behind the Excellence

The Elephant Behind the Excellence 650 486 Exist Software Labs

The preceding year, 2021, was an eventful year for EXIST Data Solutions: new team members were added, new technologies were learned, and new projects were implemented.

In the enterprise database front, PostgrEX was implemented in a prestigious 5-star hotel and casino, a state university, and a major security agency handling the biggest mall in the country.

YugabyteDB, the No. 1 cloud-native, distributed SQL database in the world, was implemented in 3 government projects, and premium EnterpriseDB support was rendered to the country’s primary energy market corporation.

On the data analytics front, Greenplum was also successfully implemented in 3 government projects, thereby enabling these entities to turn their data into actionable insights.

But what do all these business-transforming technologies have in common? In a word: Postgres.

Postgres is the database engine upon which PostgrEX, YugabyteDB, EDB, and Greenplum are based. With most of them, modifications in varying degrees were done to core Postgres to deliver a product that is still Postgres, but better!

As indicated in the article, Databases in 2021: A Year in Review, the dominance of Postgres in the year 2021 was undeniable:

The conventional wisdom among developers has shifted: PostgreSQL has become the first choice in new applications. It is reliable. It has many features and keeps adding more. In 2010, the PostgreSQL development team switched to a more aggressive release schedule to put out a new major version once per year (H/T Tomas Vondra). And of course, PostgreSQL is open-source.

PostgreSQL compatibility is a distinguishing feature for a lot of systems now. Such compatibility is achieved by supporting PostgreSQL’s SQL dialect (DuckDB), wire protocol (QuestDB, HyPer), or the entire front-end (Amazon Aurora, YugaByte, Yellowbrick). The big players have jumped on board. Google announced in October that they added PostgreSQL compatibility in Cloud Spanner. Also in October, Amazon announced the Babelfish feature for converting SQL Server queries into Aurora PostgreSQL.

One measurement of the popularity of a database is the DB-Engine rankings. This ranking is not perfect and the score is somewhat subjective, but it’s a reasonable approximation for the top 10 systems. As of December 2021, the ranking shows that while PostgreSQL remains the fourth most popular database (after Oracle, MySQL, and MSSQL), it reduced the gap with MSSQL in the past year.

Another trend to consider is how often PostgreSQL is mentioned in online communities. This gives another signal for what people are talking about in databases.

What does all this mean for you and your business? It means you can entrust your most mission-critical applications to Postgres and its derivatives; it means you can break free of vendor lock-in and redirect cost savings to core business initiatives; it means your company can be a better version of itself–a more profitable version–in the year 2022!

Contact us and find out how EXIST Data Solutions can meet all your database-related requirements.

Exist is your data solutions partner of choice!

Explore the next level of your digital transformation journey with big data and analytics. Let’s look at opportunities to better maximize your ROI by turning your data into actionable intelligence. Connect with us today, and we’ll proudly collaborate with you!

The EDB Postgres Platform Means “Enterprise” Need Not Cost an Arm and a Leg

The EDB Postgres Platform Means “Enterprise” Need Not Cost an Arm and a Leg 768 487 Exist Software Labs

Introduction

A piece of software is enterprise-grade when it caters to the needs of not a single individual, nor a select group of individuals, but the whole organization. When applied to database management systems, an enterprise database is an implementation of database software that serves the organization by managing their humongous collection of data. It must be robust enough to handle queries from hundreds to tens of thousands of users at a time. It must also have a host of features that are geared towards improving the productivity and efficiency of the organization, such as multi-processing, parallel queries, and clustering, to name a few.

For many organizations, the choice, when it comes to the selection of an enterprise database management system, has been Oracle (even MS SQL Server). To be sure, Oracle is a very capable enterprise DBMS, but at what cost?

As the title of this article suggests, it need not cost an arm and a leg. Why should it when you have the EDB Postgres Platform, the only open source-based enterprise DBMS with native Oracle compatibility?

Oracle Compatibility?

When you subscribe to EDB Postgres Enterprise, you get the EDB Postgres Advanced Server, the heart of the EDB Postgres Platform.

But first, a few brief definitions are in order.

What is the EDB Postgres Platform? According to the definition on the official EDB website: “The EDB Postgres Platform provides an enterprise-class data management platform based on PostgreSQL, including toolkits for management, integration, and migration; flexible deployment options; and services and support to deploy Postgres responsibly at scale.”

Dummy Image

What is an EDB Postgres Enterprise subscription? Again, according to the official website: “The EDB Postgres Enterprise subscription includes the use of EDB Postgres Advanced Server, EDB’s enhanced Postgres distribution with enhanced security, enterprise tooling for DBAs and application developers, and Oracle database compatibility.”

And now to the heart of the matter, what is EDB Postgres Advanced Server? Where better else to turn than, once again, the official website:

“EDB Postgres Advanced Server is EDB’s enhanced Postgres database designed to meet the needs of the digital enterprise.

  • EDB Postgres Advanced Server incorporates all of PostgreSQL’s features with additional enterprise-class functionality for enhanced performance and security requirements for enterprise workloads.
  • EDB Postgres Advanced Server features improve DBA and developer productivity.
  • Oracle users benefit from EDB Postgres Advanced Server’s native database compatibility with Oracle, including PL/SQL, built-in packages, and many DBA tools to accelerate and simplify migrations.”
Dummy Image

That last bullet point is where we want to dwell. Simply put: Because EDB Postgres Advanced Server is an enterprise-class database that is natively compatible with Oracle, your organization can enjoy enterprise-class database management services at a drastically more cost-efficient manner by moving away from Oracle onto the EDB Postgres Platform.

This movement away from Oracle can take the form of outright migration of current Oracle databases to EDB Postgres Advanced Server. It can take the form of offloading Oracle reporting jobs to EDB, thus freeing up resources for Oracle OLTP. Operational data stores? New applications development? You don’t have to buy new (and very costly!) Oracle licenses for these initiatives when EDB Postgres Advanced Server can do the job just as well, at a fraction of the cost!

According to the whitepaper entitled, “EDB Postgres Advanced Server Database Compatibility for Oracle”, EDB Postgres Advanced Server is compatible with Oracle in the following way:

EnterpriseDB extends PostgreSQL to implement the same functionality as Oracle DB primarily with data type support, selected PL/SQL compatibility, Oracle SQL syntax, and built-in SQL functions. DBAs have similar catalog views, wait events and compatible tools such as EDB*Plus and EDB*Loader. Developers have access to popular packages for fast development, advanced object type functionality, object-oriented programming support and programming features such as bulk collections and SQL hints.

Addressing Resistance to Emancipation

There are 3 primary reasons why organizations may pose some hesitation to experiencing freedom from Oracle:

1. Technical Risks. Anxiety over whether EDB Postgres Advanced Server can do the job as relating to database features.

2. Re-training Risks. The pain points of learning new technology.

3. Integration Risks. Issues pertaining to the assimilation of new technology in the I.T. infrastructure.  


How does the EDB Postgres Platform mitigate these risks?

1. Technical Risks.

The EDB Postgres Platform addresses data compatibility issues through the EDB Migration Toolkit.

According to the official website, “EDB’s Migration Toolkit (MTK) migrates tables, data, stored procedures (Oracle only) and custom developed packages (Oracle only) from SQL Server, Sybase, Oracle and MySQL to EDB Postgres Advanced Server.”

Dummy Image

In terms of code compatibility, EDB Postgres Advanced Server executes PL/SQL stored procedures, triggers, packages, and understands extensions like DUAL, Rownum, Decode, NVL(2) and Substr(). Its execution of PL/SQL is not emulation, translation, nor a layer on top of PL/pgSQL. Its procedural language is compiled, interpreted, and debugged just like in Oracle. For database code embedded in client programs, it has ECPGPlus (Pro*C support). Oracle’s OCI (Oracle Call Interface) is supported through EDB’s OCL (Open Client Library).

There are tools included in the EDB Postgres Platform that support mission-critical applications, such as Postgres Enterprise Manager (provides much of the same functionality DBAs use in Oracle Enterprise Manager) for monitoring, managing, tuning, and alerting. High-availability and failover are handled by EDB Failover Manager along with the binary replication and hot standby features (similar to Oracle’s Active Data Guard).

2. Re-training Risks.

Oracle users migrating to EDB Postgres Advanced Server need not worry that their current Oracle skill sets will go to waste.

Oracle developers can still code in PL/SQL. They can still use query hints (default optimizer hints, access method hints, join order hints, join relation hints, global hints, append hints). The following packages are still available to them: DBMS_ALERT, DBMS_CRYPTO, DBMS_JOB, DBMS_LOB, DBMS_LOCK, DBMS_OUTPUT, DBMS_PIPE, DBMS_PROFILER, DBMS_SCHEDULER, DBMS_SQL, DBMS_RANDOM, DBMS_RLS, DBMS_UTILITY, UTL_ENCODE, UTL_FILE, UTL_HTTP, UTL_MAIL, UTL_SMTP, UTL_URL, and custom packages. Virtual private databases can be implemented using a package compatible with Oracle’s DBMS_RLS (row level security).

Oracle DBA’s will thoroughly appreciate the following tools at their disposal:

  • EDB’s Resource Manager (CPU & I/O resource allocation). Similar to Oracle’s Resource Management and Profile.
  • EDB’s password profiles (profiles for password management). Provides Oracle compatible user account and password policy management functions. DB-level security rules are migrated from Oracle to EDB Postgres Advanced Server.
  • The ability to capture, review, and diagnose “Wait” events in DB processing through EDB Postgres Advanced Server’s DRITA (Dynamic Runtime Instrumentation Tools Architecture) functions.

Functions: get_snaps(), sys_rpt(), sess_rpt(), sessid_rpt(), sesshist_rpt(), purgesnap(), truncsnap()

Statspack-like AWR (automatic workload repository) reports: edbreport(), stat_db_rpt(), stat_tables_rpt(),              statio_tables_rpt(), stat_indexes_rpt(), statio_indexes_rpt(), edb$system_waits, edb$session_waits, edb$session_wait_history

Catalog views: edb$system_waits, edb$session_waits, edb$session_wait_history

  • EDB Postgres Advanced Server includes over 50 of Oracle’s most popular dictionary views (Catalog views), including all DBA_views and USER_views.
  • EDB Postgres Advanced Server supports Oracle’s table partitioning syntax.
  • EDB*Plus – command line tool for working directly with the database which is nearly indistinguishable from its Oracle counterpart.
  • EDB*Loader – for bulk data loads and provides support for direct path and parallel direct path loading.

3. Integration Risks. 

With EDB Replication Server, replicating and migrating data to and from Oracle becomes a breeze.

From the official website: “EDB Replication Server (EPRS) provides a robust data replication platform that replicates between Postgres databases in a single-master or multi-master mode, or from non-Postgres databases to Postgres in a single master mode. EPRS provides geographic load balancing, simplifies real-time migration, and enables heterogeneous data integration.”

Dummy Image

EDB Postgres Advanced Server can participate with Oracle in XA, multi-database, 2-phase commit transactions by virtue of its XA resource manager.

With EDB Postgres Advanced Server’s implementation of the SQL/MED (Management of External Data) standard, foreign data wrappers for MySQL, MongoDB, and Hadoop make quick work of integrating website and NoSQL data into a relational data store. Many other foreign data wrappers that work with the Postgres ecosystem also work with EDB Postgres Advanced Server, like LDAP, ODBC/JDBC, File/CSV, Twitter/Facebook.

Dummy Image

Summary

What all this tells us is that the EDB Postgres Platform is compatible with:

1. Your technology (No application rewrites)
2. Your people (Minimal re-training)
3. Your business (Easy integration)

Inexpensive database compatibility with Oracle means that it is compatible with any organization’s Oracle technology, technical staff, and I.T. business infrastructure.

By reducing technology, re-training, and integration risks, it removes barriers to change, thereby enabling organizations to transform their I.T. infrastructures and freeing up the budget for building new applications of innovation and customer engagement. Hold on to your arm and leg and migrate to the EDB Postgres Platform. The strength and speed of your business depend on it.

The Future is Open: EDB Postgres and Your Enterprise Data

The Future is Open: EDB Postgres and Your Enterprise Data 768 487 Exist Software Labs

Introduction

The trend of adopting open source technologies by enterprise-grade organizations remains on the rise. This is markedly true in the area of database technologies.

Consider the following forecasts by Gartner with regard to the continuous adoption of open-source technologies and Open-source DBMS (OSDBMS):

“By 2019, OSDBMS technology will account for more than 10% of DBMS spending, reflecting accelerating adoption by enterprise users.

By 2022, more than 70% of new in-house applications will be developed on an OSDBMS, and 50% of existing commercial RDBMS instances will have been converted or will be in process of converting.

Through 2020, relational technology will continue to be used for at least 85% of new applications and projects.

Through 2020, open-source software in IT portfolios will increase at a 30% compound annual growth rate.

By 2022, more than 60% of all global organizations will improve their internal skills related to open source to enable better use of open source in production, which represents an increase from 20% in 2018.” [note]Gartner, State of the Open-Source DBMS Market, 2018, 02-28-2018[/note]

EDB Postgres: The viable OSDMS alternative to proprietary and commercial solutions.

Postgres has been the RDBMS of choice of many government and private enterprises for over 25 years. Government agencies depend on Postgres to deliver robust, secure applications for the public. In private companies, industries included in the extensive Postgres portfolio include financial services, insurance, health care, energy, media, retail, telco and pharma.[note]Which Postgres Is Right For Me?[/note]

The following signify the reasons for this confidence in Postgres:

Robust OLTP engine – Postgres’ database engine combines ACID transaction guarantees with referential integrity, advanced subquery processing and other enterprise-class features.

Rich, expressive data types – Postgres supports a broad range of data types, including multi-dimensional arrays and user-defined types. Postgres also provides indexing and query operations on JSON data, matching or exceeding the functionality of NoSQL document stores for many use cases.

Advanced concurrency control – Postgres maintains data consistency through multiversion concurrency control (MVCC), allowing database read and write operations to execute optimistically, without blocking each other.

Stored procedure flexibility – Postgres has loadable modules that enable database developers to write stored procedures in popular programming languages such as Java, C, Perl, Python, Ruby and even JavaScript.

Community ecosystem – In addition to delivering bug fixes and enhancements for the core Postgres database, the extended Postgres community provides a broad range of add-on products and services. [note]ibid[/note]

It is undeniable that Postgres is uniquely poised to act as the open source database backend for many sophisticated applications. However, many organizations require the enterprise class features and support that are missing in the community version.

EDB is the global leader in providing enterprise-class products and services for Postgres users.

EDB’s collaborative efforts within the Postgres community have been going on for over 10 years, initiatives that include the funding of research projects and contribution of core database functionality to the open source code base. As a highly-esteemed community partner, it is a major influence in the future direction of Postgres.

EDB offers two Postgres-based product subscriptions:

EDB Postgres Standard (EPS) – This subscription, based on the open source PostgreSQL database, provides technical support and mission-critical tools needed for enterprise class deployments. EPS is generally geared toward departments and smaller organizations building mixed-workload applications.

EDB Postgres Enterprise (EPE) – Leveraging the Postgres database core, EPE combines enterprise technical support SLAs and product roadmap influence with a wealth of high- value product features. EPE is geared toward organizations that need to build and manage durable, scalable, high performance database applications. EPE also includes advanced security and performance features in addition to a renowned suite of Oracle® compatibility capabilities that accelerate Postgres adoption in Oracle shops. [note]ibid[/note]

Advantages

Referencing the IDC (International Data Corporation) report entitled, The Economic and Business Advantages of EDB Postgres Database Solutions, wherein key organizations that have adopted EDB Postgres were assessed, it was determined that benefits in the following areas were realized: Business Value, DBA Staff Efficiencies, and Database-Related Costs.

Realizing Business Value With EDB Postgres

Lower cost-of-operation expenses (42% lower across three years) by virtue of the elimination of database-related licensing fees and lower maintenance costs (EDB’s opex-based pricing model as opposed to capex-weighted licensing models) enabled organizations to be more flexible and scalable in their use of database technology, thereby lending reliability and performance to the solutions that support their business operations.

The following are the ways these organizations are realizing value by leveraging EDB Postgres as a high-performance, cost-efficient database platform to better capitalize on business opportunities:

Scalability – EDB Postgres enables organizations to scale their database resources to match business demand. In particular, organizations do not face limitations imposed by up-front capex costs when they need to build new databases or expand a database. A database manager explained: “The scalability of EDB Postgres is a real benefit. We just started with the platform for customers to do queries on our databases, and we can very easily scale this up and down depending on the demand of our clients, which is difficult to predict. We shoot to be flexible and offer high scalability, and EDB Postgres can do this against relatively low costs. It would be far more difficult with another platform.”

Flexibility – EDB helps organizations avoid vendor lock-in by providing an open 
source–based alternative to other database solutions and gives them more flexibility to find database solutions that match their business and operational needs. A database manager commented: “We are always looking for alternative technology just in case our current technology proves to be a dead end or bottleneck in performance, which led us to EnterpriseDB.”

Cost impact – Beyond paying less for their database environments, organizations can embed lower database costs in their pricing and better compete because the overall cost of operating EDB Postgres databases is lower than the overall cost of operating their previous or alternative solutions. A database manager explained: “We are better able to sell to new customers in this new space. Without EDB Postgres, we could go after them, but we wouldn’t win them.”

Integration – EDB Postgres offers the ability to integrate with a number of Big Data analytics solutions, which can enable application development efforts and help tie Big Data analytics more closely to improved business and operational outcomes. A database manager noted: “As we come up with crazy query requirements for our application development, it’s easier to get [them] done and faster with EDB Postgres.” [note]The Economic and Business Advantages of EDB Postgres Database Solutions[/note]

These EDB Postgres attributes paved the way for the following positive business results:

More revenue and more customers – A database manager at one interviewed organization explained: “EDB Postgres allows us to be not only the best provider in the world but the lowest-cost provider. That’s the best way to describe it … We’re bringing in substantially more revenue because it has allowed us to take new contracts.”

Increased database functionality – Another database manager commented: “EDB Postgres gives us the ability to expand the type of databases that we’re actually interacting with. In that sense, it gives us a flexibility that says I don’t have to be tied to this other database or a particular database. We can do functionality in multiple databases. For us, that’s key. It gives us flexibility.” [note]ibid[/note]

As a result of EDB Postgres being a reliable and robust database platform, these organizations have also reported fewer unplanned, database-related outages and shorter resolution times (62% lower impact of such unplanned outages on their operations with EDB Postgres over three years).

Achieving DBA Staff Efficiencies

Another benefit realized was in the area of database administration. The ease of deployment and management of EDB Postgres environments resulted in an average of 15% less deployment, configuration, maintenance, and administration time, measured in a span of  three years, as compared to competing database technologies (16% more efficient administration). The respondents reported that it was the platform’s simplicity that undergirded these improvements.

As a database manager at one organization noted:

“There is a significant difference in DBA staff time with [our alternative database environment] — 10 hours per week with EDB Postgres compared with 40 hours per week previously … EnterpriseDB is a much simpler model and is built to be operated without dedicated operators — it’s not built on the premise of having people with deep knowledge about the database.” [note]ibid[/note]

Reducing Database-Related Costs

It is precisely in two areas that EDB Postgres showcases maximum profitability in terms of database-related costs:

  • No exorbitantly-priced, up-front licensing costs. This is particularly the bane of the majority of commercial database solutions.
  • Lower annual subscription rates. This translates to cost savings realized across more than three years in comparison to the organization’s prior or competing traditional or open source database technologies.

Conclusion

Adopting EDB Postgres, either as a greenfield implementation or migration initiative, is not a mere instance of jumping on the open-source bandwagon. While it is a fact that many may have had to settle for trade-offs in moving to open-source database management systems, trade-offs in terms of performance degradation and awkward administration for lower cost, this is never the case for any organization that decides to embrace EDB Postgres.

In fact, these organizations will reap the benefits of their systems running faster, easier to administer, and providing more flexibility than the systems they had used previously. EDB Postgres, aside from providing the standard benefits of open source, is the go-to solution to the problem of expensive, unduly complex, and poor performing database platforms.

EDB Postgres is the future.