I learned a number of things watching the recently concluded Women’s Soccer World Cup.
- it is possible for a human body to be fouled in the penalty area without then falling over as if it has just been shot (see Lisa-Marie Utland for Norway against England for proof)
- England have developed a happy knack of reaching the Semi-Final of every tournament they enter
- Alex Morgan is a tea-drinker
There were some complaints that Morgan’s celebration of her goal against England were disrespectful. Personally, I though it was rather witty. Let’s face it, if she’d really want to stir up some controversy, she’d have mimed putting the milk in first.
That said, she is going to face a challenge at the Olympics next year were she may herself up against a united Great Britain team.
If you’re not up on your sporting geopolitics, Great Britain (for now at least) comprises four nations – England, Wales, Northern Ireland and Scotland.
Should Morgan need to celebrate in a similar vein, the tea will be just the start. She’ll then need to neck a pint of Brains SA (known as “Skull Attack” in Cardiff) followed by a Guinness ( there is no border in Ireland when it comes to the Black Stuff) before moving on to a Scotch single-malt chaser.
Anyone looking for an object lesson in how to up their game could do far worse than have a look at how Oracle Express Edition has evolved from 11g to 18c…
Using the License documentation for 18c XE and that of 11g XE, I’ve compiled a list of features which are now included in Express Edition but were not in 11gXE.
This is mainly for my own benefit as I keep being surprised when I find another – previously Enterprise Edition only – feature in Express Edition.
I’ve also listed the new stuff that wasn’t previously available in any edition of Oracle 11g.
Anyhow, for anyone who might find it useful…
Extra functionality in 18c
Using the Functional Categories mentioned in the license documents as a template, the features newly available in 18c Express Edition are :
Perhaps the most profound structural change is the advent of Multitenant functionality.
18c XE comes with Oracle Multitenant and allows up to three Pluggable Databases (PDBs).
SQLJ is now available.
- Online Index Rebuild
- Online table organization
- Online table redefinition
- Trial recovery
- Fast-start fault recovery
- Flashback Table
- Flashback Database
- Cross-platform Backup and Recovery
Sharded Queues have been introduced in Oracle since 11g.
Network Compression is also new to Oracle since 11g.
- Client Side Query Cache
- Query Results Cache
- PL/SQL Function Result Cache
- Adaptive Execution Plans
- In-Memory Column Store
- In-Memory Aggregation
- Attribute Clustering
- Column-Level Encryption
- Tablespace Encryption
- Oracle Advanced Security
- Oracle Database Vault
- Oracle Label Security
- Centrally Managed Users
- Fine-grained auditing
- Privilege Analysis
- Real Application Security
- Transparent Sensitive Data Protection
- Virtual Private Database
Spatial and Graph Data
11g XE contained no spatial functionality at all. In 18c you get :
- Oracle Spatial and Graph
- Property Graph and RDF Graph Technologies (RDF/OWL)
- Partitioned spatial indexes
VLDB, Data Warehousing, and Business Intelligence
- Oracle Partitioning
- Oracle Advanced Analytics
- Oracle Advanced Compression
- Advanced Index Compression
- Prefix Compression (also called Key Compression)
- Basic Table Compression
- Deferred Segment Creation
- Bitmapped index, bitmapped join index, and bitmap plan conversions
- Transportable tablespaces, including cross-platform and full transportable export and import
- Summary management—Materialized View Query Rewrite
Stuff that’s not included
Unlike it’s predecessor, 18cXE does not come with a version of Application Express (APEX). Fortunately, you can still get APEX and Oracle Rest Data Services for the same low, low price of – well, nothing – and install them separately.