Oracle

Oracle Pro Members Standard Members

Machine Learning with R within Oracle Database

by

Machine Learning with R within Oracle Database By Yuli Vasiliev Using R – an open source statistical programming language and environment – within Oracle Database for statistical computing and machine learning is enabled with Oracle R Enterprise, a component of Oracle Advanced Analytics database option. R integrated with the database leverages database compute engine, taking advantage of query optimization and...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Setting Up an Environment for Machine Learning Tasks in Oracle Database

by

Setting Up an Environment for Machine Learning Tasks in Oracle Database By Yuli Vasiliev Machine Learning is a growing subfield of artificial intelligence, gaining immense popularity in recent years in both academia and the industry. Providing the ability to work with large volumes of data, machine learning algorithms are best suited for Big Data. This article discusses how you can...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

12.2’s JSON_OBJECT to Construct JSON in the Database

by

12.2’s JSON_OBJECT to Construct JSON in the Database Now with new release of Oracle Database (12.2), you can construct JSON data in the database from non-JSON data, using new SQL/JSON functions, such as: JSON_OBJECT, JSON_ARRAY, JSON_ARRAYAGG, and JSON_OBJECTAGG. This article takes a look at JSON_OBJECT, which you can use to generate JSON objects from name–value pairs. The examples in this...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

JSON Support Enhancements in Oracle Database 12c Release 2 (12.2)

by

JSON Support Enhancements in Oracle Database 12c Release 2 (12.2) By Yuli Vasiliev New release of Oracle Database (12.2) for the first time comes with Database JSON Developer’s Guide as a standalone book within Oracle Database Online Documentation Library. In the preceding release, JSON support in Oracle Database was covered in the JSON in Oracle Database chapter within XML DB...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle

Using Invisible Columns in Oracle Database 12c

by

Using Invisible Columns in Oracle Database 12c By Yuli Vasiliev Oracle Database 12c Release 1 (12.1) introduced the Invisible Columns feature that provides a convenient way to change a table’s structure without having to edit existing applications using that table. Invisible columns will not be seen in the SELECT list nor will be considered for insertion in an INSERT statement […]

Continue Reading →
Oracle

Count, Distinct, and Nulls

by

Count, Distinct, and Nulls By Yuli Vasiliev Counting distinct values in a dataset that may include nulls is a fairly common operation when it comes to data analysis. Sometimes, you need to count only not-null distinct values, while next time you may need to include nulls in your count. The examples in this article cover both situations, querying the ext_json […]

Continue Reading →
Oracle

Approximate Count Distinct in Oracle Database 12c

by

Approximate Count Distinct in Oracle Database 12c By Yuli Vasiliev Counting distinct values in a dataset is a commonly used operation in data analysis. In an Oracle Database, you can do this using function COUNT with the DISTINCT clause. Starting with Oracle Database 12cR1 (12.1.0.2), you can also use function APPROX_COUNT_DISTINCT, which – unlike COUNT with DISTINCT returning the exact […]

Continue Reading →
Oracle

Count with Distinct

by

Count with Distinct By Yuli Vasiliev Function COUNT can be used with the DISTINCT clause, which makes COUNT consider only distinct values of the specified expression. There are several ways in which you can use COUNT with DISTINCT. This article covers them all, using as an example the part table that you will get as a result of reverse-engineering process […]

Continue Reading →
Oracle

Including JSON in ODI 12c

by

Including JSON in ODI 12c By Yuli Vasiliev ODI 12c comes with JSON support, meaning you can now use JSON as a data source. Unfortunately, the documentation does not offer a comprehensive example on how to do it. This article explains in detail how you can take advantage of this functionality, using as an example the PurchaseOrders.dmp coming with Oracle […]

Continue Reading →
Oracle

Consolidating Diverse Data Sources With Oracle Database 12c

by

Consolidating Diverse Data Sources With Oracle Database 12c By Yuli Vasiliev Oracle Database 12c cannot only store different types of data natively, but also allows you to access that data stored outside of the database. This article overviews some Oracle Database 12c features that allow you to consolidate diverse data sources located outside of the database. In particular, you’ll look […]

Continue Reading →
1 2 3 4 … 7