How to Manage Automatic Data Optimization (ADO)
apr 11,
2017
In this last posting on Automatic Data Optimization, we will look at issues related to monitoring and managing Automatic Data Optimization (ADO). Displaying Automatic Data Optimization (ADO) Policies Several dictionary views are available to verify configured policies. DBA_ILMPOLICIES provides the list of all policies and their respective ENABLED status:The DBA_ILMDATAMOVEMENTPOLICIES view contains information specific to data […]
Guide to Creating Automatic Data Optimization (ADO) Policies
mar 14,
2017
Defining Automatic Data Optimization (ADO) Policies In the previous posting, we discussed enabling Heat Map. The next step is to create the ADO policies. The policies: Define WHICH condition fires an action; for example: Low data access No access No data modification (updates/deletes/inserts on row or DDL ALTER statement on a segment) Object/row creation Define […]
How to Use Heat Map in Automatic Data Optimization (ADO)
jan 26,
2017
Heat Map and Automatic Data Optimization (ADO) Oracle Database 12c allows for activity tracking with Heat Map. This tool provides the ability to track and mark data as it goes through life cycle changes (see my previous blog on Information Lifecycle Management). Data accesses are tracked at the segment-level (table, index, etc.). Data modifications tracked at […]
Querying SQL Server Data from Matlab Using ADO
nov 11,
2016
Matlab has a database toolbox, but there are several reasons why you might decide to take matters into your own hands and query SQL Server data using the ADO library. One simple reason might be that you have not yet purchased the database toolbox but you want to get started now. Another reason is […]
Excel as a Database: How to Create a Data Model in Excel 2013
jul 28,
2015
Many blogs, including some originating from our friends in the rainy Pacific Northwest, have referred to the “new” data models in Excel 2013. I’m not sure “new” is quite the right word. “Useful”, absolutely. “Interesting”, most definitely. But what we are really seeing here is not so much new as it is another step in […]
ADO,
Commodities Trade Workbook,
Economic Data,
Excel Data Models,
Excel Power Pivot,
Excel SQL,
Excel VBA,
Linked Tables,
Pivot Tables,
SQL,
VBA