Author Archive

Yes, we have a copy of it. No, we’re not selling it. However, we’ll be putting our data analytics and data quality glasses on to see what lies within.

Several Australian cities featured prominently on the list of AM users. Singapore, which had banned the website was highly represented.

There is nothing special about Ashley Madison’s leak except that the brand attracts alot of negative emotions. They probably stepped on the toes on a capable geek. Reality is that nothing is safe on the internet, and transparency is your only defence.

Should Ashley Madison have done more to protect their data? Yes! The next simple step of basic data encryption should have been done. But it wasn’t.

Bye bye Ashley Madision. You’re not the first, and I am sure you won’t be the last. There is no defence against cheating spouses expect character, honesty, truth and love.

 

Oracle 12c was released in Jul, 2014. It packs a number of new features which bring its up to date with utilising significant improvements in hardware, virtualisation and storage technology.

1. Pluggable Databases Through Database Consolidation

The cloud has driven Oracle to address the problem of Multi-tenancy in Oracle 12c. The core database architecture has introduced Container Databases also called (CBD) and Pluggable Databases (PDB). Memory and processes are now owned by the Container Database. A container holds the metadata where the PDBs hold the user data. You can create upto 253 PDBs including the seed PDB.

In a larger Oracle setup, it is common to see 20 or 30 different instances running in production environment. This can create a maintenance nightmare as all these instances have to be separately

Upgraded Patched Monitored Tuned RAC Enabled Adjusted Backed up and Data Guarded.

Pluggable Databases feature allows you to do all this in ONE single instance. This is a significant efficiency improvement for DBAs.

2. Redaction Policy

Data Redaction helps you to mask data. You can setup a Data Redaction policy, for example SSN field in a Employee table can be masked. This is called redaction.

From Sql Develop you can do this by going to the table: Employee->Right click on Security Policy->click on New->click on Redaction Policy->Enter SSN. When you do a select * from employee, it will show that the SSN is masked. The new data masking will use a package called DBMS_REDACT. It is the extension to the FGAC and VPD present in earlier versions. By doing this, whoever needs to view the data will be able to see it where as the other users will not be able to view it.

3. Adaptive Query Optimization and Online Stats Gathering:

With this feature, it helps the optimizer to make runtime adjustments to execution plan which leads to better stats. For statements like CTAS (Create Table As Select) and IAS (Insert As Select), the stats is gathered online so that it is available immediately.

4. Restore a Table easily through RMAN:

Earlier if you had to restore a particular table, you had to do all sorts of things like restoring a tablespace and or do Export and Import. The new restore command in RMAN simplifies this task.

5. Size Limit on Varchar2, NVarchar2, Raw Data Types increased:

The previous limit on these data types was 4K. In 12C, it has been increased to 32,767 bytes. Upto 4K, the data is stored inline. I am sure everyone will be happy with this small and cute enhancement.

6. Inline PL/SQL Functions and Procedures:

The in line feature is extended in Oracle 12C. In addition to Views, we can now have PL/SQL Procedures and Functions as in line constructs. The query can be written as if it is calling a real stored procedure, but however the functions do not actually exist in the database. You will not be able to find them in ALL_OBJECTS. I think this will be a very good feature for the developers to explore as there is no code that needs to be compiled.

7. Generated as Identity/Sequence Replacement:

You can now create a col with ‘generated as identity’ clause. Thats it. Doing this is equivalent to creating a separate sequence and doing a sequence.nextval for each row. This is another handy and a neat feature which will help developer community. This is also called No Sequence Auto Increment Primary Key.

8. Multiple Indexes on a Single Column:

Prior to 12C, a column cant be in more than one index. In 12C, you can include a column in B-tree index as well as a Bit Map index. But, please note that only one index is usable at a given time.

9. Online Migration of Table Partition or Sub Partition:

You can very easily migrate a partition or sub partition from one tablespace to another. Similar to how the online migration was achieved for a non-partitioned table in prior releases, a table partition or sub partition can be moved to another tablespace online or offline. When an ONLINE clause is specified, all DML operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. In contrast, no DML operations are allowed if the partition|sub-partition is moved offline.

10. In Database Archiving:

This feature enables archiving rows within a table by marking them as inactive. These inactive rows are in the database and can be optimized using compression but are not visible to the application. These records are skipped during FTS (Full Table Scan).

Other Features:

Other Oracle features are:

Advanced Replication and Streams is deprecated. Oracle Golden Gate (a separate product) can provide this functionality. Invisible Columns. You can now have a invisible column in a table. When a column is defined as invisible, the column won’t appear in generic queries

 

You’ve heard of bitcoin. Its built using the blockchain. This is a distributed database that keeps track of every bitcoin transaction. Bitcoin popularity may have diminished, but the importance of the blockchain as truly revolutionary technology remains. 

The Internet’s key design objective was to survive nuclear attack. The need for resilience is what led to the distributed design pattern. But certain core features, like the IP address space and Domain Name Servers (DNS) systems were never decentralised as the solutions had yet to be defined.

Even early peer-to-peer products (like Skype and Napster) relied on managed super-nodes or centralised directories.

The blockchain provides a method of distributing trust and facilitating decentralised systems.

This excellent IEEE Spectrum essay explores how the blockchain could inveigle its way to improving core internet services from payment transactions, to online communities, to video games, to preventing spam email and more.

Bimodal IT refers to having two modes of IT, each designed to develop and deliver information- and technology-intensive services in its own way. Mode 1 is traditional, emphasizing scalability, efficiency, safety and accuracy. Mode 2 is non-sequential, emphasising agility and speed.

After fads of Agile Management, PRINCE2, ITIL, P3M3, Waterfall etc… which all remain relevant to project execution, today’s enterprise recognises that different parts of the organisation operates under different parameters.

Agile remains the high suitable for smaller teams with high performance goals. The Agile Director is an expert in agile project management.

 

Linode opens its newest datacenter in Singapore! This is Linode’s seventh datacenter, and is purpose-built to serve the already huge and growing markets in Southeast Asia, India, Australia, and surrounding regions.

Linode’s Singapore network is powered by Cisco ASR 9000-series routers, and currently blends connectivity from Telstra/Pacnet and PCCW, along with direct peering into the Equinix Internet Exchange (EIE) – providing you with access to hundreds of peering opportunities. Check out our Speedtest page to test latency and download speeds.

Singapore supports all of the standard Linode features available in all of our datacenters – like 40 Gbps redundant connectivity to each hypervisor host machine, the Linode Backup service, NodeBalancers, native IPv6, etc – and is the same simple pricing as in other Linode datacenters.

 

Microsoft announced in Jan 2015 of a new browser for Windows 10. Code-named the Spartan project, it is designed to work on all devices across the Microsoft family from Laptops, Desktops, Phones, Tablets etc… Internet Explorer will still be distributed to support legacy enterprise applications.

Read more

The tech portal Gigaom which has been covering tech news since 2006 has closed citing “Financial difficulties”. It has literally run out of money and its financiers will now own the assets of the portal.

Bye Gigaom!

Jeremy Snyder of Entiviti gets onboard as a startup advisor. Jeremy is a multi-talented individual who has been involved in several successful startups. Jeremy currently advises several startups in Big Data space.

Over the coming weeks we will be looking at tweaking the Glitchdata business, and engaging with folks in the USA.

I recently ordered a copy of the book “Directing the Agile Organisation”. Since I know the author, I am obliged (disclosure) to say something brilliant about the concept and the book. Unfortunately, I haven’t read the book yet (its in the mail), but since I have a little time this morning, I’d thought I plug the book with some Agile commentary. Agile methods are evolutionary. In the scale of doing things faster, and in a flexible way, Agile breaks the rigidity of Waterfall, PRINCE2. Agile methods are well proven in the open source community, game development, and product development where the parameters of a project like cost, time, features, and quality tend to be established.

However in most enterprises, project parameters like cost, time, features and quality are fluid. And that is where the Agile project horror stories begin. Business executives who hear about the brilliance of Agile unwittingly adopt it for an environment where it will fail. Traditional project controls like project costing, feature management, stakeholder management etc… are not addressed adequately. So the Agile engine splutters. If we are able to address the business management of a project in an agile way, Agile methods will find a more relevant place at the core of the enterprise.

I know the author has plenty of experience and insight in transitioning Agile into the enterprise, and this is what I am keenly looking forward when I read this book. 🙂

You can purchase this book at: http://www.itgovernance.asia/p-958-directing-the-agile-organisation-a-lean-approach-to-business-management.aspx

DISCOUNT: To get the 10% discount, enter ‘agile10’ (without the apostrophes) into the discount code box during the checkout process. This special will run until the 15th of September. About the Book

What is ‘Directing the Agile Organisation’ about ? Business systems do not always end up the way that we first plan them. Requirements can change to accommodate a new strategy, a new target or a new competitor. In these circumstances, conventional business management methods often struggle and a different approach is required.

Agile business management is a series of concepts and processes for the day-to-day management of an organisation. As an Agile manager, you need to understand, embody and encourage these concepts. By embracing and shaping change within your organisation you can take advantage of new opportunities and outperform your competition.

Using a combination of first-hand research and In-depth case studies, Directing the Agile organisation offers a fresh approach to business management, applying Agile processes pioneered In the IT and manufacturing industries. Agile business management is divided into four domains, which each changes the way your business operates.

In data analytics, alot of decisions frequently need to be made. These can be data issues, business issues, technical issues, to people issues. In larger data projects, sizable data team performing multiple functions need to be managed. This is where delegation becomes important. Michael Hyatt discusses the 5 levels of delegation that a manager would encounter.

Level 1: Do exactly what I have asked you to do. Don’t deviate from my instructions. I have already researched the options and determined what I want you to do. Level 2: Research the topic and report back. We will discuss it, and then I will make the decision and tell you what I want you to do. Level 3: Research the topic, outline the options, and make a recommendation. Give me the pros and cons of each option, but tell me what you think we should do. If I agree with your decision, I will authorize you to move forward. Level 4: Make a decision and then tell me what you did. I trust you to do the research, make the best decision you can, and then keep me in the loop. I don’t want to be surprised by someone else. Level 5: Make whatever decision you think is best. No need to report back. I trust you completely. I know you will follow through. You have my full support.