Database management

HSBC platform uses AI to analyse trading data thousands of times faster

HSBC is offering its US share trading customers artificial intelligence-powered insights into public information about listed companies Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

Flagship digital investment at Abu Dhabi’s Adnoc pays off

Abu Dhabi National Oil Company sees flagship digital project in high demand after proving its value in responding to the Covid-19 crisis Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

Will the NHS’s Covid-19 contact-tracing app work?

In this week’s Computer Weekly, we get the expert reaction to find out if the NHS contact-tracing app will work. Staying close to clients is crucial through lockdown – we look at the importance of customer experience management. And imagine implementing a digital transformation plan in two weeks – one CIO explains how he did it. Read the issue now. Continue Reading

Australian researchers tap cloud to save the Tasmanian devil

Researchers at the University of Sydney are using Amazon Web Services to speed up genomics research in one of Australia’s wildlife conservation programmes Continue Reading

By

• Aaron Tan, TechTarget

Dark data is contributing to carbon emissions

Almost six million tonnes of carbon dioxide will be pumped into the atmosphere this year as a result of dark data, Veritas research finds Continue Reading

By

• Aaron Tan, TechTarget

Nasdaq gives customers real-time data through cloud platform

US stock exchange uses public cloud and APIs to provide investment companies with real-time data on trading activity Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

How DBS is reaping the dividends of digital transformation

At DBS Bank, the Covid-19 coronavirus outbreak has demonstrated the value of technology and the investments it made over the past decade to modernise its technology stack Continue Reading

By

• Aaron Tan, TechTarget

How Singapore’s Niometrics is changing network analytics

By extracting granular data and emphasising privacy protection, Niometrics’ network analytics technology is being put through its paces in a variety of use cases Continue Reading

German diabetes institute uses graph database to connect coronavirus research

DZD, the German Federal Diabetes Research Centre, is using a Neo4j graph database to link up Covid-19 scientific research and scientists Continue Reading

By

• Brian McKenna, Enterprise Applications Editor

Coronavirus and privacy – finding the middle ground

Data collection has a role to play in fighting the deadly Covid-19 coronavirus outbreak, but governments need to be accountable for how it is used Continue Reading

By

• Eduardo Ustaran

CIO interview: Sarah Wilkinson, NHS Digital

NHS Digital has been racing to ensure the systems and protocols are in place to prepare the health service for the coronavirus. We speak to its CEO about the preparations Continue Reading

By

• Cliff Saran, Managing Editor

WikiLeaks founder Julian Assange cannot be legally extradited for ‘political offences’, say lawyers

Lawyers for WikiLeaks founder Julian Assange argue that he has been charged with political offences and cannot be legally extradited to the US under the US-UK extradition treaty Continue Reading

By

• Greg Wilford

Weather Source uses Snowflake to keep ahead of extreme weather

The impact of Storm Ciara shows the importance of accurate weather data. We look at the tech behind Weather Source’s service. Continue Reading

Refinitiv uses Google Cloud to revolutionise delivery of huge datasets

Financial data giant is expanding delivery of its services in the cloud, removing the need for customers to use hard disks and trucks to transport large datasets onsite Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

Dutch tech firm transforms real-life football through video game concept

Tech company that helped the Belgian football team in the last World Cup is changing the way footballers are scouted and teams are trained Continue Reading

By

• Kim Loohuis

Smart use of data takes Dutch railways further

De Nederlandse Spoorwegen (Dutch Railways), ensures, among other things, that 1.2 million train passengers arrive at their destination every day. Through a subsidiary, it’s using data to improve both the customer experience and internal processes Continue Reading

By

• Kim Loohuis

Weather Source uses Snowflake to keep ahead of extreme weather

The impact of Storm Ciara shows the importance of accurate weather data. We look at the tech behind Weather Source’s service Continue Reading

By

• Cliff Saran, Managing Editor

Disguise uses data management firm Boomi to gain visibility of estate

Integration has given entertainment company Disguise visibility of its entire digital estate while also connecting its various pools of siloed data Continue Reading

By

• Sebastian Klovig Skelton, Data & ethics editor

Russia’s VTB and Rostelecom focus on big data

Russian financial services and telecoms enterprises to create a platform that will allow them and other organisations to utilise big data technology Continue Reading

By

• Vladimir Kozlov

LGBTQ+ social app Grindr accused of breaching GDPR

Norwegian Consumer Council files complaints about LGBTQ+ social networking app, alleging it is in breach of the General Data Protection Regulation Continue Reading

By

• Alex Scroxton, Security Editor

Cloud adoption in ANZ gathering pace

Australia and New Zealand have seen a four-fold increase in the amount of data moving from on-premise environments to the top public clouds, survey finds Continue Reading

By

• Aaron Tan, TechTarget

Top 10 information management stories of 2019

Here are Computer Weekly’s top 10 information management stories of 2019 Continue Reading

By

• Brian McKenna, Enterprise Applications Editor

Has Y2K windowing been addressed by banks or is Y2.02K a risk?

Big banks that haven't replaced legacy systems or fixed temporary windowing solutions to Y2K could have problems at the beginning of 2020 Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

APAC IT leaders lay out priorities for 2020

Robotic process automation and data analytics are among the top priorities for IT leaders in the Asia-Pacific region in the new year Continue Reading

By

• Aaron Tan, TechTarget

Get ready for CCPA: Implications for UK businesses

The California Consumer Privacy Act, a wide-ranging data privacy and consumer protection law, comes into effect on 1 January 2020. How does CCPA differ from the EU GDPR regulations and what are the responsibilities for UK businesses operating in the US? Continue Reading

By

• Peter Ray Allison

Get to know Microsoft Azure Cosmos DB use cases

Organizations can deploy Cosmos DB for a range of important applications. Learn how to bolster Azure workloads with this Microsoft database service that is highly distributed and multi-model. Continue Reading

By

• George Lawton

What is QLC flash and what workloads it is good for?

QLC flash offers low per-gigabyte costs and lots of capacity, but can be limited by endurance and I/O performance. It can be a good disk replacement for several workloads, however Continue Reading

By

• Rene Millman

Alternative databases set for mainstream adoption?

The rise of non-relational databases has been a feature of the data management landscape in the wake of big data – but to complement or replace relational? Continue Reading

By

• Lindsay Clark

Software architects struggle with relational database legacy

Legacy relational database management systems were originally designed as systems of record, but they don’t work as well in modern, cloud-native designs Continue Reading

By

• Cliff Saran, Managing Editor

PLC flash: A solid state candidate for analytics and archives?

We thought flash would end at QLC, but storage media makers are working on penta-level cell, which could push capacity to double figures, but at a further performance cost Continue Reading

By

• Antony Adshead, Storage Editor

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle cloud, database and application users. Continue Reading

By

• Craig Stedman, Industry Editor

Cloud database services multiply to ease admin work by users

The list of vendors offering managed cloud database services is growing rapidly, which gives IT teams more opportunities to offload management of database systems. Continue Reading

By

• Craig Stedman, Industry Editor

Can Oracle substantiate its cloud bluster?

Larry Ellison talks aggressively about having more datacentres than AWS and how Oracle’s cloud sales are growing – but it may have to provide legal proof Continue Reading

By

• Cliff Saran, Managing Editor

How Malaysia is nurturing data analytics talent

The Southeast Asian nation has spearheaded several programmes to build up its data analytics talent pool in efforts to improve efficiency and productivity of Malaysians Continue Reading

By

• Avanti Kumar

New cloud and on-premises options for Oracle Autonomous Database

Oracle introduced new cloud and on-premises deployment options for its namesake database and automated cloud service as Oracle OpenWorld 2019 got underway. Continue Reading

By

• Sean Michael Kerner

Brexit disrupts FCA exploration into data use in wholesale banking

The extra work for banks due to Brexit preparations has caused a delay to FCA work on the use of data in the wholesale banking sector Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

Consolidating databases in Oracle systems: Methods and tips

A well-planned consolidation strategy can help overcome Oracle database sprawl. But there are different ways to consolidate your databases, each with pros and cons. Continue Reading

By

• Lindsay Moore

How to manage Oracle database upgrades and annual releases

Oracle consultants offer tips and advice on upgrading databases, including new considerations created by the annual release schedule that Oracle is now following. Continue Reading

By

• George Lawton

Melbourne researchers uncover privacy lapses in transport dataset

A team of University of Melbourne researchers has been able to re-identify individuals from a public transport dataset, raising serious privacy, safety and security issues Continue Reading

By

• Aaron Tan, TechTarget

Oracle Generation 2 cloud service to debut in Australia

The Sydney Generation 2 cloud region will be delivered from a new datacentre to meet demand for Oracle’s cloud infrastructure and autonomous database services in Australia Continue Reading

By

• Aaron Tan, TechTarget

First Bus blends Infor asset management with SAP core ERP

When First Bus decided to upgrade its asset management and maintenance systems, it avoided senior management’s first choice, SAP, which provides its main business systems, and plumped for Infor Continue Reading

By

• Lindsay Clark

London Stock Exchange agrees to acquire Refinitiv for £22bn

The London Stock Exchange has agreed to a multi-billion pound takeover of data giant Refinitiv Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered advice on how to make that happen. Continue Reading

By

• Lindsay Moore

London Stock Exchange eyes £22bn acquisition of Refinitiv to expand data capabilities

The London Stock Exchange is looking at a huge tech acquisition to provide customers access to a wealth of data services built using the latest technologies Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options for migrating SQL Server to Azure. Continue Reading

By

• Michael Otey

Singapore shores up data protection capabilities

The Singapore government has developed a skills framework for data protection officers and is looking to certify organisations under a regional cross-border privacy rules system Continue Reading

By

• Aaron Tan, TechTarget

TfL launches wireless device tracking to gather Tube data

Transport for London aims to use passenger movement data to make using the London Underground a more pleasant experience Continue Reading

By

• Alex Scroxton, Security Editor

PostgreSQL database specialist EnterpriseDB gets new backing

EnterpriseDB is looking to push its database further with help from new financial backers. The deal sees Postgres originator Michael Stonebraker coming onboard as technical adviser. Continue Reading

By

• Jack Vaughan

Why database admins should embrace automation

There are certain functions in database administration, that are good candidates for automation. These are the nuts and bolts of the job - like how to partition the storage, what happens if a disk ... Continue Reading

By

• Cliff Saran, Managing Editor

ASEAN CIOs learn to navigate the data economy

A group of IT leaders in Southeast Asia will converge in Edinburgh this July to delve deeper into issues that have been holding back efforts to become better data-driven organisations Continue Reading

By

• Aaron Tan, TechTarget

Oracle results: Revenue flat, cloud progress claimed

Full-year 2018-19 results show revenue flat to slight, but executives claim cloud headway and progress on autonomous database uptake Continue Reading

By

• Brian McKenna, Enterprise Applications Editor

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary. Continue Reading

By

• Brian Peasland

Gartner: Blockchain lacks functionality needed by enterprise

Gartner has found there is generally a lack of understanding of how blockchain can be used in the enterprise Continue Reading

By

• Cliff Saran, Managing Editor

How Alibaba Cloud plans to win over APAC enterprises

The Chinese cloud supplier is counting on data analytics, industry-specific offerings and its knowledge of the China market to gain a foothold in the Asia-Pacific region Continue Reading

By

• Aaron Tan, TechTarget

Salesforce completes Pardot fix after 12 days’ disruption

Plug was pulled on 17 May after a data script went wrong. Most users have had full access since 18 May, but 10 services remained down Continue Reading

By

• Cliff Saran, Managing Editor

SAP extends Hana’s reach beyond enterprise applications

The benefits of Hana Cloud Services are clear to Asia-Pacific customers, although actual adoption will boil down to cost Continue Reading

By

• Aaron Tan, TechTarget

How to connect to a pluggable database in Oracle Multitenant

Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they can be used. Here's how to do that. Continue Reading

By

• Brian Peasland

Singapore proposes data portability provisions

The Personal Data Protection Commission is seeking public feedback on proposed provisions that will let consumers move their personal data across organisations Continue Reading

By

• Aaron Tan, TechTarget

CW APAC: Expert advice on data management

Data is growing exponentially, so managing it well is crucial to business success. In this handbook, Computer Weekly looks at how companies and data management experts are tackling data challenges, studies the findings of Gartner’s CDO study, and finds out how organisations are augmenting data management through artificial intelligence and machine learning. Continue Reading

Huawei debuts AI-powered database

Huawei is using reinforcement learning to deliver self-tuning and self-healing capabilities for the latest iteration of its GaussDB database Continue Reading

By

• Aaron Tan, TechTarget

Creating an Oracle Multitenant container database and PDBs

Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the Oracle Multitenant architecture. Continue Reading

By

• Brian Peasland

MongoDB buys Realm database to boost mobile chops

MongoDB is buying Realm, the maker of an open source database for cross-platform mobile applications, to boost its Atlas cloud platform and Stitch backend as a service. Continue Reading

By

• Chris Kanaracus

SQL Server performance tuning best practices for DBAs

Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning best practices that can make it easier. Continue Reading

By

• Lindsay Moore

Pros and cons of using SQL Server audit triggers for DBAs

Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases. Continue Reading

By

• Lindsay Moore

Using data science at Sainsbury’s

In this week’s Computer Weekly, we talk to one of the UK’s leading retailers, Sainsbury’s, about its data science strategy and how it helps the firm to better understand customers. We take a detailed look at the evolution of the business intelligence market and the impact of big data. And we find out how simulated disaster management can tackle the security skills gap. Read the issue now. Continue Reading

How APAC firms can tame the data beast

Companies and data management experts across Asia-Pacific reveal how they are tackling data management challenges that have been compounded by growing cloud usage and compliance requirements Continue Reading

By

• Aaron Tan, TechTarget

What is the difference between a database engineer, architect and administrator?

Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading

By

• Michael Hillenbrand, Thermo Fisher Scientific

How to resolve and avoid deadlocks in SQL Server databases

Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and stop them from recurring. Continue Reading

By

• Lindsay Moore

Amadeus deploys cloud-native shopping application on Google cloud

Amadeus has moved off mainframes and is redeveloping its software to be cloud native. Its Master Pricer is the first of its core application to be deployed on Google Continue Reading

By

• Cliff Saran, Managing Editor

Australian firms grapple with business-IT gap

The growing chasm between business and IT has hit Australia more than other countries, according to a study on the state of digital transformation initiatives Continue Reading

By

• Aaron Tan, TechTarget

How D+1 keeps payroll woes at bay

The Singapore-based F&B business behind the Yolé frozen yogurt chain has consolidated its payroll data into a single database powered by Unit4’s HR management system Continue Reading

By

• Aaron Tan, TechTarget

Modernising IT at the Bank of England

In this week’s Computer Weekly, we talk to the Bank of England as it starts the modernisation programme for its core system – one that the UK economy relies on. We look at the rise of DevSecOps and how it can help deal with increasingly complex security threats. And we examine the different approaches to storage for structured and unstructured data. Read the issue now. Continue Reading

SQL Server auditing best practices: 3 key questions for DBAs

Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the top questions that auditors ask. Continue Reading

By

• Lindsay Moore

Redis Labs swaps out open source to protect against public clouds

While Redis remain open source, higher value modules are now covered by a commercial agreement which limits commercialisation of Redis-based products Continue Reading

By

• Cliff Saran, Managing Editor

Innocent people arrested following surveillance blunders, IPCO reveals

Interception of communications commissioner Adrian Fulford warns of “grave” repercussions for people wrongly identified as suspects due to errors made when government bodies access email, phone and telephone data Continue Reading

By

• Bill Goodwin, Computer Weekly

5 trends for SQL Server environments as SQL Server 2019 looms

SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes are also on tap for SQL Server users. Continue Reading

By

• Michael Otey

No-deal Brexit could lead to data issues, MPs told

Trade body TechUK is concerned smaller companies are far from ready for a no-deal scenario, while warning that leaving without a deal could lead to serious data issues for businesses Continue Reading

By

• Lis Evenstad

5 data management infrastructure technologies to evaluate

It's the start of a new year -- is your organization ready to face the data management challenges ahead? Here are five technologies to consider adopting. Continue Reading

By

• Chris Foot

Facebook’s objections to court concerns over privacy more about ‘optics’ than facts

Facebook’s challenge to a High Court ruling that raises serious concerns about data transfers between Europe and the US is more about appearance than facts, lawyers for the Irish Data Protection Commission told Dublin's Supreme Court Continue Reading

By

• Bill Goodwin, Computer Weekly

Advantages of graph databases: Easier data modeling, analytics

Graph databases are finding a place in analytics applications at organizations that need to be able to map and understand the connections in large and varied data sets. Continue Reading

By

• Jack Vaughan

AWS pushes MongoDB compatible alternative as licences change

They probably didn't see that coming... MongoDB's switch to server-side licensing may have backfired, as AWS launches an API-compatible version Continue Reading

By

• Cliff Saran, Managing Editor

Storage 101: Structured data and its storage needs

Structured data is declining as a proportion of all data but its importance to business applications and its organised nature make its storage requirements very specific Continue Reading

By

• Stephen Pritchard

Key new features coming in Oracle Database 19c

With Oracle Database 19c, Oracle is aiming to boost the stability of its flagship software's latest generation. But 19c also offers DBAs a variety of added features. Continue Reading

By

• Robert Sheldon

Ellison slates AWS Aurora as Oracle posts flat second quarter

Oracle was late to the cloud, but CTO Larry Ellison is adamant that no one will swap out Oracle for Amazon Continue Reading

By

• Cliff Saran, Managing Editor

SQL Server 2019 improves Linux, container support

The SQL Server 2019 release includes new big data integration features, a collection of database engine enhancements and improved Linux and container support. Continue Reading

By

• Michael Otey

Tibco’s Orchestra acquisition will mean ‘faster IT integration’

Tibco’s strategic acquisition of Paris-based Orchestra networks will ‘benefit customers of both companies’ Continue Reading

By

• Bill Goodwin, Computer Weekly

Don't let blockchain complexity bog down business applications

Enterprise blockchain applications that run in a controlled environment don't require some of the components of cryptocurrency networks, explains expert David Teich. Continue Reading

By

• David A. Teich

Amazon Timestream, QLDB aim to grab more DBMS users for AWS

Built-for-purpose databases target general ones, especially in the cloud. At re:Invent 2018, AWS added time-series and transaction ledger databases to expand its line. Continue Reading

By

• Jack Vaughan

New forms of governance needed to safely and ethically unlock value of data

Despite today’s abundance of data, most of it remains locked in silos, meaning new governance structures are needed to open it up and unlock its potential value to society Continue Reading

By

• Sebastian Klovig Skelton, Data & ethics editor

CDO interview: Aidan Millar, DNB

Norwegian bank hires chief data officer to lead its data-driven transformation Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

5 FAQs on SQL Server containers and how to manage them

Running SQL Server in containers creates new challenges for database administrators. The answers to these questions can guide you through some of them. Continue Reading

By

• Michael Otey

Azure Data Studio (formerly SQL Operations Studio)

Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems. Continue Reading

By

• Lindsay Moore

Thailand’s Democrat Party holds election with blockchain

The Zcoin blockchain was used to store file hashes of voting data and identities of voting members of Thailand’s main opposition party Continue Reading

By

• Aaron Tan, TechTarget

The most useful new features in Microsoft SQL Server 2019

SQL Server 2019 includes welcome new features, particularly updates to its indexing and high availability capabilities and added SQL Server on Linux functionality. Continue Reading

By

• Brien Posey

Oracle OpenWorld 2018 news, trends and analysis

At its OpenWorld 2018 conference, Oracle tried to position its cloud platform as well-suited for enterprise uses. This guide compiles coverage of key developments from the event. Continue Reading

Microsoft results show hybrid benefit to Azure growth

The software company continues to push the benefits of on-premise Windows Server infrastructure alongside Azure PaaS Continue Reading

By

• Cliff Saran, Managing Editor

Oracle bullish on growth in ASEAN

Enterprise technology juggernaut Oracle claims traction in cloud applications and growing interest in its cloud-based autonomous database service in Southeast Asia Continue Reading

By

• Aaron Tan, TechTarget

Oracle Open World 2018: CEO Mark Hurd says SAP ERP customers will defect

Oracle co-CEO Mark Hurd opined at Open World that SAP ECC6 customers will defect, in some measure, to Oracle in preference to S/4 Hana Continue Reading

By

• Brian McKenna, Enterprise Applications Editor

MarkLogic Data Hub Service aims to ease cloud use of NoSQL DBMS

MarkLogic rolled out a cloud-service version of its NoSQL database management system, a move designed to make the technology more cost-effective for cloud users. Continue Reading

By

• Craig Stedman, Industry Editor

Geospatial Commission pumps £5m into unlocking value of location data

Commission wants to unlock the value of location data held by its partners through the use of emerging technologies Continue Reading

By

• Lis Evenstad