Cookies on this site

We would like to use cookies to understand how the site is used and to measure our campaigns. Nothing is set until you choose, and you can change your mind at any time from “Cookie settings” at the foot of every page. Privacy policy

Contact UsContact Us

Resources / Blogs

Oracle & databases

Oracle 12.2 Database: 9 Features

The mining models have now been made in an attempt of improving models with partitions. can you agree that the Oracle 12.2 Database is an attractive.

· · 2 min read

Oracle Database

With the launch of the onsite version of the Oracle 12.2 Database, people are interested in hearing about the new features. We detail 9 key features in conjunction with Oracle consulting services.

  1. Rebuilt OAA
  2. Detailed Analysis of Semantics
  3. SQL with R models
  4. Models with Partition
  5. Scoring for the Partition
  6. Association Rules of the Extension
  7. Extension of the Package of the DBMS_DATA_MINING
  8. Hint for SQL ODM Models
  9. Using the New function of CREATE_MODEL

Rebuilt OAA

The rebuilt Oracle Advanced Analytics (OAA) is the most important feature of Oracle 12.2 database, yet it is not obvious to the naked eye. However, the experts understand that the OAA that has been underlying has been rebuilt improving its efficiency.

Detailed Analysis of Semantics

In this new Oracle 12.2 feature, semantic analysis, clients can spot the brand-new additions regarding the algorithms. As the experts are now pointing out, this addition makes the whole operation much easier than what it used to be previously. User experience improvements make for happier clients.

SQL with R models

Further extension of the of the R models is now available as the database and framework have been extended.

Models with Partitions

The mining models have now been made in an attempt of improving models with partitions. This is the place for making the specification and separation of the models, and the entire process will be done based on the attribute value.

Scoring for the Partition

The partition attributes based on the data dynamic score happens to be the similar and that dynamic score is possible to make now.

Association Rules of the Extension

Calculation of the rule values happens to be important and that is the reason that the extension of the algorithms is also possible. This is a big insight to the process.

Extension of the Package – DBMS_DATA_MINING

Extension of the PL/SQL package has been done now and new features and functions are included in the process. This is a very big change that one had banged for. The R algorithms and the models are now getting further extensions.

New SQL Hint for ODM Models

For the ODM models, you will be getting the new SQL hint. In the last few versions, the users were getting the hints for the new SQL for the ODM models and now the hints are also visible in the partition models also. Called as the GROUPING hint, these kinds of hints are the best options for you.

Using the New function – CREATE_MODEL

The resistance of the database is now possible with the CREAETE_MODEL2 option, and for that, the set will be based on the SELECT statement.

Oracle 12.2 Database

Alongside to these changes, you will also have the options for the SQL, DB and PL/SQL database features that are equally important.

With all these features, can you agree that the Oracle 12.2 Database is an attractive solution for your business’ needs?

← All articles

Case studies

Oracle Consulting in practice

Client names are withheld. We are happy to share details on a call.

All case studies
  • Delivered

    30 TB, zero downtime

    Financial services

    Oracle

    Zero-downtime move of a 30 TB Oracle database for a global retail bank

    The bank's transaction database served thousands of users around the clock. We built the new Oracle 12c RAC platform on IBM AIX alongside the old Solaris system, kept the two in sync with Oracle GoldenGate, tested everything and switched over with no downtime and no data loss.

    • 30 TB moved with zero downtime
    • Zero data loss at cut-over
  • Delivered

    Zero downtime

    Legal technology

    Oracle

    Sybase to Oracle with zero downtime for an e-discovery company

    Sybase was holding back a platform that processes large volumes of legal data. We converted the schema, kept both databases in sync with continuous replication, validated the data and switched over without interrupting the business.

    • Zero downtime at cut-over
    • No disruption to client workflows
  • Delivered

    No service disruption

    Local government

    Oracle

    A city's Oracle database moved off ageing Solaris hardware

    A major California city ran a mission-critical Oracle database on Solaris servers nearing end of life. We mapped the dependencies, confirmed the applications would work unchanged and re-platformed the database to Linux without disrupting public services.

    • No disruption to public services
    • Minimal application changes

Keep reading

All Oracle & databases articles

Planning an Oracle or database migration?

Request a migration plan consult with the DBAs who do this work, and leave with a fixed-scope plan.