IT Brief New Zealand logo
Technology news for New Zealand's largest enterprises
Story image

INFORMATION PRESERVATION

Sat 1 May 2010
FYI, this story is more than a year old

A staff member once told me that just as he was leaving his previous organisation, management had come to the realisation that the grounds, properties and infrastructure they owned and maintained weren’t their most important assets. No, that was, in fact, their data. This realisation has spread across business and industry with companies now heavily, if not totally, reliant on the quality and availability of their data. This has never been more important than over the past 12 months during some of the toughest economic times most can remember. The ability to extract and report on customer information to help retain and drive business during this time has been critical to the sustainability of a number of businesses. Businesses can no longer rely on tools such as Access to provide enterprise-scale database storage and reporting, and gone are the days of copying and pasting data into an Excel spreadsheet! Within the latest versions of these products, applications such as the Office suite become reporting tools in their own right. These hook directly into the database and include far increased functionality. By migrating Access databases to a true relational database, data can be scheduled and delivered to users or customers in the format of their choice and at whatever time they choose. Users and customers can even be given the opportunity to implement desired changes themselves. This is a huge leap in database capabilities and can be done through tools that come with the database engine, or via associated third-party tools . With so many systems and applications reliant on a database as their ‘backend’, there is an ever-more critical need to have a standardised set of data for reporting purposes. Companies will often have separate customer relationship management, enterprise resource planning, financial and sales tracking systems, all of which contain a base set of data for their customers. With the tools available within these database products, the ability to extract, translate and load a standardised and normalised set of base data has become a much easier process. By de-duplicating this base line data, errors in processing are reduced and more accurate and timely outcomes can be achieved, meaning better and quicker results – and happier customers. While the reporting capabilities have improved, so have the high-availability and disaster recovery options. The ability to take copies of customer data off-site no longer relies on writing backups to tape and having a courier move them to a different location. Current database technologies mean real-time copies of databases can be spread across multiple servers in one location using functionality such as real application clustering (RAC) or database clustering, or in disparate locations, geo clustering. Copies of databases can also be transferred in real time to off-site locations using tools such as data guard, database mirroring or log shipping. With the prevalence of virtualisation technologies and changes in product licensing, these options become easy to implement and cost-effective. With reliance on data being so high, it is critical that you maintain its security, ensure it can be used in the way it is needed, and that it can be recovered in times of crisis. You need to ensure there are well-documented processes and procedures for management, maintenance and backup of the databases. With regards this, businesses need to understand two key areas: the recovery point objective (RPO) – how much data can they afford to lose – and the recovery time objective (RTO) – how long can they afford to have their systems unavailable prior to recovery. This will drive backup and recovery strategies that match requirements. While new and improved tools provide great opportunities and leaps forward in functionality, the base tasks of securing and maintaining the database and the data remain fundamental to a great user experience. No matter what flavour of relational database management system you choose to run, it is imperative that processes and procedures are put in place to ensure its availability. Often the focus is placed on the delivery of the data and it’s only when it becomes unavailable, normally at the end of the month, that users and organisations realise how important the core database administration function is. Don’t wait to find yourself in this situation!

Related stories
Top stories
Story image
Tech job moves
Tech job moves - ARMA International, Avec, Komo & YouGov
We round up all job appointments from August 15-18, 2022, in one place to keep you updated with the latest from across the tech industries.
Story image
Microsoft
CCL launches Managed M365 offering for NZ work environments
CCL, the cloud specialist within Spark Business Group, has recently launched its Managed M365 offering.
Story image
Update
InterSystems releases updates to its IRIS data platform
Provider of next-generation solutions InterSystems has announced a series of new releases to its award-winning InterSystems IRIS data platform.
Story image
Cloud Security
Organisations struggling to secure new cloud environments
“In the wake of COVID-19, organisations substantially accelerated their digital transformation initiatives to accommodate a remote workforce."
Story image
Cloud
Microsoft accelerating NZ tech sector with new data centres
Microsoft’s forthcoming New Zealand data centres are introducing hyperscale public cloud capabilities on a scale previously unseen in the country.
Story image
LawVu
Exclusive: LawVu streamlines the in-house legal struggle
LawVu is a New Zealand-born company successfully transforming the in-house legal industry with its category-defining workspace.
Story image
Mobility
Micro-mobility companies caught at a crossroads - study
Reformulating models, operations and goals, shared micro-mobility companies can tap into a market worth US$9 billion in ride revenues in 2030.
Story image
SaaS
Cloudera launches all-in-one data lakehouse cloud service
CDP One makes it faster, easier and less risky for businesses to move to the cloud and migrate existing workloads to a modern data architecture.
Story image
Environment
Lenovo launches CO2 Offset Service for SMBs across A/NZ
Lenovo has announced the rollout of a new, first-of-its-kind CO2 Offset Service for SMBs across Australia and New Zealand. 
Story image
Mobility
Cradlepoint launches architectural extension of NetCloud solution
With this latest release Cradlepoint is focused on helping lean IT organisations with advanced SD-WAN and zero trust capabilities.
Story image
Banking
Virgin Money works with 9Spokes to create custom offering
Virgin Money has worked with Kiwi SaaS 9Spokes to build a custom version of its business dashboard offering, M-Track, to generate stronger insights for the bank and its customers.
Story image
Blockchain
Australian Grand Prix uses CENNZnet blockchain for fan experience
CENNZnet was employed by Power'd Digital to deliver the Formula 1 Heineken Australian Grand Prix's 2022 AusGP Access program.
Story image
Cyber resilience
NZ’s Cyber Resilience Framework to be evolving and potentially automated
The government's already putting $2.4 million into the Cyber Resilience Framework in its initial stages, what is it and why is it important?
Story image
Cloud
Whispir reports significant revenue growth as CaaS market expands
Australian cloud platform Whispir has announced its financial results, reporting significant growth as it continues to introduce new Communications-as-a Service (CaaS) offerings to the market.
Story image
Microsoft
8x more users attacked via old Microsoft Office vulnerability in Q2
"Criminals craft malicious documents and convince their victims to open them through social engineering techniques."
Story image
MarTech
CM Group recognised as Best Overall MarTech Company
MarTech Breakthrough has ranked CM Group as the Best Overall MarTech Company for the third year running and Cheetah Digital as Best Overall Marketing Campaign Management Solution.
Story image
Gartner Magic Quadrant
Spryker named Gartner Visionary in 2022 Magic Quadrant for Digital Commerce
Spyker has announced it has been recognised by Gartner as a Visionary in the 2022 Magic Quadrant for Digital Commerce.
Story image
Cybersecurity
‘Windows shops’ target admin rights to de-risk their environments
New data shows up to 75% of critical vulnerabilities could be mitigated through a rights and privileges crackdown
AWS Marketplace
Learn how security orchestration, automation, and response (SOAR) enhances your security strategy.
Link image
Story image
Sustainability
CDC hyperscale data centres now open in New Zealand
CDC Data Centres (CDC) says two new, state-of-the-art hyperscale data centres are now open for business in Auckland.
Story image
IDC
Collaboration app market revenue grows 28.4% year-over-year
IDC has found that global revenues in the collaboration applications market grew 28.4% year-over-year in 2021 to $29.1 billion.
Story image
Cybersecurity
Verizon supports Fujifilm's cybersecurity advancements
Verizon Business is supporting Japan’s Fujifilm Holdings to strengthen its global cybersecurity monitoring and cyber intelligence capabilities.
Story image
Cybersecurity
CISOs need to consider a risk-based cybersecurity strategy
Rather than talking in terms of attack vectors and vulnerabilities, CISOs and security decision-makers must look at actual business risk.
Story image
Radware
DDoS activity rises dramatically - Radware report
The first six months of 2022 were marked by a significant increase in DDoS activity across the globe, according to a new report.
Story image
Solutions
Ivanti reveals potential ROI of 261% for Endpoint Management Solution
Ivanti has announced the results of a commissioned Total Economic Impact (TEI) study conducted by Forrester Consulting.
Story image
Business Intelligence / BI
TIBCO ranks highly in 2022 business intelligence study
Dresner Advisory Services has recognised TIBCO as a Service Leader and a Credibility Leader in Business Intelligence in the 2022 Wisdom of Crowds Business Intelligence Market Study.
Story image
Unified Communications
MAXHUB reveals latest innovations for ANZ at Integrate 2022 in Sydney
Some of the most exciting and innovative updates from this year's Integrate 2022 event have come from the leaders at MAXHUB.
Story image
Facial recognition
Benefits vs risks of facial recognition technology
Once a distant, futuristic concept, facial recognition technology is now found in many technological applications with a variety of different functions. 
Story image
Data Protection
Safeguarding your financial data
As the digital revolution marches on, managing data security has never been more important. Here are five important steps to take toward better financial data security.
Story image
Customer experience
Exclusive: How Accenture is changing the customer experience game
Creating highly personalised real-world customer experiences using API, near-field communication, and spatial technology is about taking a traditional experience and elevating the customer journey into a digital world.
Story image
Cryptocurrency
Crypto crime: Illicit activity falls with rest of market
Cryptocurrency scams, which typically present themselves as passive crypto investing opportunities, are less enticing to potential victims.
Story image
Collaboration
Schneider Electric launches Connected Services with Claroty
Schneider Electric is teaming up with Claroty to assist in maintaining cybersecurity for physical assets - a critical issue.
Story image
Mobiles
Demand grows for future-proof mobile access solutions
HID Global, in partnership with IFSEC Global, recently released the 2022 State of Physical Access Control report for the fourth year running.
Story image
Email scams
HelpSystems shines light on impact of response-based threats
Response-based attacks targeting corporate inboxes have climbed to their highest volume since 2020, representing 41% of all email-based scams.
Story image
Innovation
Arcion extends data replication platform with new capabilities
"Arcion is committed to investing in continuous innovation. Our goal is to be the first choice in whole-product solutions for large-scale data replication."
Story image
5G
Worldwide 5G mobile data traffic exploding - report
"With 5G, there is a wider range of deployment scenarios, forcing vendors to provide comprehensive solutions to support every need."
Story image
Storage
On-premise micro data centres an emerging option for storage
Digital transformation is occurring in all industries, resulting in unprecedented amounts of data. Explore the option of storing your information on-site using micro data centres.
Story image
Hybrid Cloud
The essential guide to digital transformation by SolarWinds
Digital transformation is a buzzword thrown around all the time by companies, but what does it actually mean and why is it important? SolarWinds breaks it down.
Story image
Digital Transformation
Federated change is the best path to digital evolution
Businesses that can successfully manage the exponentially expanding masses of data produced by modern consumers will be the businesses that survive and prosper.
Story image
Contact Centre
Treasure Data launches new customer experience functionality
Treasure Data has introduced a new strategic vision and product positioning for Customer Data Cloud, reflecting the company's focus.
Story image
Artificial Intelligence
Concentric AI protects sensitive data with new capabilities
The new capability reveals sensitive data shared across email and business messaging platforms and highlights who has inappropriate access to content.
Story image
Data
Workday research finds A/NZ organisations becoming leaders in digital agility
New research from Workday and IDC has revealed that Australia and New Zealand are becoming leaders in digital agility.