How to use Oracle data mining API

After Oracle Releases PL/SQL and Java application programming interfaces (APIS), the click tool or builder that can use the newly released APIs will be launched on the market, this is generally the best practice. With this practice, developers can immediately integrate new features into their applications to benefit their enterprise.

However, developing specialized tools that can use the new APIs requires a lot of effort. Therefore, it may take at least a few months to release an intuitive end-user tool that uses the API until it is released. In fact, the latency is usually one or two years. At the same time, using APIs may require enterprises to use their own tools, or more commonly, using ad hoc solutions, such as embedding API calls in report builder and workbooks.

One common method is to wrap APIs in several scripts and then use custom buttons and menus to access these scripts from workbooks. However, the main drawback of this method is that today's workbooks process text and numbers in a single cell as values, so it is usually not a proper tool to process new features.

This article describes how to quickly integrate analysis and other APIs into a spreadsheet platform where end users can easily access new code. As a guiding example, it also explains how to repackage Oracle Data Mining (PL/SQL) APIs into Java APIs, and how to access this API from J Cells in the e-table style. J Cells are completely written in Oracle JDeveloper. It can not only use text and numbers as cell values, but also process Java objects as values. It can directly access any Java API from its cells for immediate deployment.

Workbook Platform

I am using the workbook interface, which only allows users to create any Java objects in cells and use the primitive Java type. Each cell can be used as a variable for another cell. You can choose to write Java code directly in the cell or use other formats. It is automatically used to combine the workbook interface and objects (not just the numbers and text in the regular workbook): J Cells calculates the indication value for each object that fits the cell, this metric value gives you ample evidence about the displayed object. In addition, a complete value system is implemented to display objects in various formats as needed (for example, when you double-click a given cell. Even in a workbook, because the formula definition may be complex, the system also needs to identify whether the object to be created has a wizard. A wizard is usually a graphical code generator specific to an object type. This example will show you how to use the wizard in J Cells later.

Figure 1 shows the workbook page in this example.

Figure 1: Workbook page of J Cells

1 2 3 4 5 Next Page