DIFM Data Collaboration News & RSS Feed
What is Real Application Security, How to Enable It?
Real Application Security is a database authorization framework that enables application developers to define, provision, and enforce application - level security policies at the database layer. Our APEX Application development uses the IDCS User Group / Roles to define which end-users have access to pages, RAS, defines fine grain row access to data in tables for the end-user.
These Oracle Tools work together to allow our DIFM application developers to construct and define security policies that delineate access between research entity datasets, and farm datasets.
DIFM Ag Portal Now Integrated with Oracle IDCS!
The DIFM Ag Research Portal is now interfaced to the Oracle Cloud Identity Services. (IDCS) Integration allows scientists to spin up data tools in the cloud from the comfort of the end-user application. It also allows Group Roles and Access rights to data through a centralized management platform. The March IT Report will include a detailed video of the application development in progress.
Oracle Spatial Online Reference Guide
The spatial features in Oracle Spatial and Graph consist of a set of object data types, type methods, and operators, functions, and procedures that use these types. A geometry is stored as an object, in a single row, in a column of type SDO_GEOMETRY. Spatial index creation and maintenance is done using basic DDL (CREATE, ALTER, DROP) and DML (INSERT, UPDATE, DELETE) statements.
Ag Research Portal is in development at the University of Connecticut. Click here to review some screenshots of the new application under development. Using Oracle Apex, combined with Oracle Spatial Studio and Autonomous Transaction Database in the Oracle Cloud, the application runs close to the database and offers rich geospatial and reporting features. The application will be connected to Oracles IDCS for Administrator access, and have a custom users table for Farmer Access.
IT UPDATE (Code - Innovate)
RECENT DIFM IT NEWS (2023.01.17)
Today was the first meeting of the Oracle - DIFM Code-Innovate discussion. Topics were to manage expectations and establish a timeline and number of attendees. The scope of the project is to use Apex and an Oracle Autonomous Transaction database to build and create a version of trial design using the power of Oracle SQL, and Oracles Geospatial Studio Suite.