Blog

integration and implementation of technology-focused business solutions

May 2019

Putting Oracle XE to work

May 21st, 2019

We’ve seen how Oracle XE has changed since the 18c update. It’s now a fully-fledged database, if shackled by some resource limitations compared to the full database solution. But what can Oracle XE do for your business? Do the limitations really make a difference? What will it take to get up and running, and is it workable down the road?

The short answer is yes, Oracle XE can work for your business. And there are quite a few things that make Oracle XE an attractive choice.

A feature-rich package

Oracle XE is a good option for developers, proof of concept projects, evaluations, and database administrators. What makes it really interesting, though, are some of the free features that make it easy to get things up and running quickly.

Low-code app development can run well through Oracle Application Express (APEX) sitting on top of Oracle REST Data Services (ORDS) and XE. That allows you to put together an easy app development environment at no extra cost-and you’re not losing out on features. It’s a fully-fledged solution that only takes some elbow grease to set up. There’s even a handy FAQ that can help you do it.

Oracle XE also allows you to develop in multiple APEX environments, which makes it even easier to use the low-code, enterprise-quality APEX suite for your apps.

Database Vault is also usable with XE, allowing you to control access in a way that other tools for Oracle Databases don’t. Data compression, partitioning, data encryption and more are also supported through Database Vault, making it an extremely useful part of XE.

A scalable future

If your business is growing and you think you might outgrow Oracle XE, you’re probably wondering if it’s scalable.

It is-and it’s easier than you think. If you set up your database in Oracle XE, it’s a snap to upgrade to Oracle Database on-premises. It’s also possible to move over to Oracle Database Cloud for the increased support and unlimited storage, and you can use Autonomous Transaction Processing and Autonomous Data Warehouse through Cloud if you want to upgrade. XE is designed to be compatible with other Oracle Database editions, too. Oracle even has a library of data movement tools that make it easy to move from Oracle XE to one of its big brothers.

The biggest thing you need with Oracle XE is a good database administration and management team. Third-party support is a must for products that don’t have built-in Oracle support. But if your business isn’t sure whether to use XE or one of the bigger databases, contact us. You might be able to save some money while still having a fantastic, fully-fledged database system that does everything you need it to do. We’ll help you get set up with the right system for your needs.

Comments: None

Oracle XE is now free

May 7th, 2019

Oracle databases have been an industry standard for years, with the Oracle Database framework underpinning many businesses. Oracle XE was a little different, though.

The original idea behind Oracle XE when it came out in 2005 was to have a smaller, lighter, less resource-intensive database that could be run on smaller hardware. It was meant to be a sandbox, something developers could play with and use to hone skills with databases, as well as familiarizing themselves with Oracle.

That has changed.

The new face of Oracle XE

With XE 18c, Oracle has finally opened the playground. No longer is Oracle XE solely a developer use case. Instead, it’s a much more flexible, much more powerful option that runs like its big brother.

Oracle developer Gerald Venzi noted this on his personal blog when Oracle first started to push these changes. “We had an idea,” he says, “the idea that the new Oracle XE should be a fully capable, free to use but resource limited, single instance Enterprise Edition.”

With 18c, Oracle took a different direction. The hardware restrictions were lessened, and the feature set opened up to a whole new level. Instead of a barebones small-footprint version of the full Oracle database, XE is now a fully-fledged database system of its own.

For everyone?

Oracle XE 18c’s tagline states that it’s for everyone. That’s true to some extent, but there are definitely some applications where it’s not necessarily the right choice. For many businesses and science applications, it’s too dangerous to operate without direct vendor support from Oracle themselves.

In some cases, though, Oracle XE is enough to do what a business needs. That’s where a third-party vendor like LSG comes in. We can help you get a database running that will do what your business needs and provide the support you need to keep it going.

Comments: None

CONTACT

501 E. 15th St., Suite 200B
Edmond, OK 73013
(405)285-2500
info@lsgsolutions.com