You've requested...

Download this next:

Jargon buster guide to database management

Database management roles have long been a rich career seam for IT professionals. However, there has been, in recent years, a “Cambrian explosion” in the previously steady but sleepy world of databases.

The relational database model, breaking the traditional dependency between data storage and applications, held sway in enterprise IT for decades, from the time of its serious commercialisation by Oracle in the mid-7os. Also hegemonic has been the language implementation of the relational model, SQL – Structured Query Language; which is of the same mid-70s vintage.

But, in recent years, with the rise of the big data technologies of the Hadoop stack and the NoSQL databases, the data store and database scene has become more complex.

And when it comes to the Oracle database, its creator announced it to be “autonomous” at Oracle Open World in San Francisco October 2017. What does this mean for database administrators (DBAs)? Does it mean the opening up of new roles of higher intellectual interest and value? Or does it mean redundancy and early retirement?

As always with IT, the technology is only one-third of the story – the others being process and, crucially, people. What are the operational and organisational design problems to be solved in this more heterogenous database management landscape?

This Jargon Buster e-guide to contemporary database management is an aid to stepping back and thinking afresh about an area of enterprise IT that has many decades of heritage. Or, as many sometimes (arguably rudely) put it, legacy.

These are also closely related to: "Toad™ for Oracle Xpert Trial"

  • Infographic: Advantages and disadvantages of key-value databases

    Different database types exist to serve different purposes. This sometimes makes the choice of the right type of database to use obvious. While key-value databases may be limited in what they can do, they are often the right choice for many different situations.

    Unlike relational databases, key-value NoSQL databases do not have a specified structure. Relational databases store data in tables where each column has an assigned data type. Key-value databases are a collection of key-value pairs that are stored as individual records and do not have a predefined data structure.

    Here are the main advantages and disadvantages of key-value databases.

  • E-Guide: Database Tools for Auditing and Forensics

    Database auditing requires more than just the right tools: those tools also have to be properly configured to offer the information that's needed and database performance that's required.

    This e-guide presents the best practices for tuning database auditing tools. Continue reading this e-guide to learn more about these best practices which will allow you to audit without forfeiting  database performance.

Find more content like what you just read:

  • Infographic: NoSQL Databases

    NoSQL databases are geared toward managing large sets of varied and frequently updated data, often in distributed systems or the cloud. They avoid the rigid schemas associated with relational databases. But the architectures themselves vary and are separated into four primary classifications, although types are blending over time.

    Download

  • Taking stock of database technologies

    Database technologies have evolved over decades, from relational databases to NoSQL databases that make it easier to store & handle data in the cloud. In this e-guide, how organisations are addressing database management challenges & how Alibaba is using cloud-native databases to reduce downtime in its annual Singles' Day sales.

    Download

  • CW APAC: Trend Watch: Database technology

    In this handbook, focused on database technology in the Asia-Pacific region, Computer Weekly looks at the impact of graph databases and the different types of database management systems currently on the market.

    Download

  • Improve SQL Server performance with transformative database services

    Discover in this product overview why, as enterprises generate and store more and more operational data, they have come to rely on Microsoft SQL Server infrastructure more than ever before.

    Download

  • A Computer Weekly buyer's guide to graph databases

    In this 14-page buyer's guide, Computer Weekly looks at the technology that teases out connections between divergent datasets – and how it is revolutionising data analysis.

    Download

  • Preparing a database strategy for Big Data

    This e-guide outlines the key database challenges and opportunities introduced by big data, and offers expert advice to help you successfully prepare a big data database strategy.

    Download

  • A Computer Weekly buyer's guide to NoSQL

    There's a lot of data out there, much of which doesn't need to be stored in heavyweight relational databases complete with complex query languages. In this 13-page buyer's guide, Computer Weekly looks at a new category of NoSQL data stores and how they are being used.

    Download

  • Infographic: Comparing cloud database security

    More data than ever before is being put into cloud-based storage repositories. Leading cloud providers offer an array of storage options, yet databases remain the most common choice in today's enterprises. Because databases are updated so frequently, it's important to review their security controls regularly.

    Download

  • Oracle - Autonomous computing that declines a special name

    In this e-guide, follow Oracle's twin paths to adding AI and delivering software over the cloud – on its own platform and infrastructure as a service, from 2017 to 2018. An over-arching theme of Oracle's case regarding its infusion of machine learning and its declared re-architecting of its cloud delivery has been security, security, security.

    Download

  • Guinness World Records Goes "all in" on AWS to Manage Transformation Into Digital Media Company

    Watch this video clip to learn how Guinness World Records is leveraging their new cloud host to aid in their organization-wide digital transformation.

    Download

  • CW ASEAN – September 2018: Time to clear DevOps hurdles

    ASEAN organizations are generally aware of the benefits of DevOps, but lesser known are the pathways to success. What would an organization that has successfully implemented DevOps look like?

    Download

  • Riding the elephant: how to manage big data

    Big data vendors – such as the Hadoop distributors – will say they see signs that big data science projects are giving way to large scale implementations. But how are user organisations managing those? How are they designing their IT organisations, and the rest, to manage and capitalise on big data?

    Download

  • Databases and your unique environment: Your comprehensive guide

    In this comprehensive for dummies e-book, discover how Nutanix can help you tackle and tame the most challenging aspects of controlling a flexible database solution while bringing down costs.

    Download

  • 4 reasons to consider cloud database migration

    When it comes to cloud database migrations, it can be hard to weigh the many benefits of a migration with its various drawbacks. This web post helps you consider this important decision by exploring the top 4 reasons behind cloud database migrations. Check it out to explore some key factors behind why organizations move their DBs to the cloud.

    Download

  • How to achieve better database performance and consolidate your data center

    Discover in this detail-packed infographic how your organization can boost Oracle Database performance by moving from older servers to 16th Generation Dell PowerEdge R960 servers with Intel Xeon Scalable processors.

    Download

  • Computer Weekly - 15 February 2022: On a mission to track space junk

    In this week's Computer Weekly, we talk to the space experts tracking orbital debris using graph database technology. We meet the startups taking very different approaches in trying to develop commercial quantum computers. And we ask why it's so difficult to build a data science team and how to overcome the challenges. Read the issue now.

    Download

  • How Dell & Microsoft combine to deliver SQL server efficiency

    Between multi-cloud, on-premises and edge environments, the complex modern IT landscape is a breeding ground for challenges. Read this blog to learn how Dell’s as-a-service approach to Microsoft SQL Server modernization blends Kubernetes automation, elastic scaling, and enhanced data storage to accelerate digital transformation initiatives.

    Download

  • Stopping application layer DDoS attacks: What you need to know

    While a DDoS attack can be damaging to any organization, DDoS attacks specifically at the application-layer can be more ominous. Understanding these attacks are the first step to keeping your organization protected. In this e-guide, explore how DDoS is being used, what you can do to stop them, the future of the web threat landscape and more.

    Download

  • How to choose a database for your mobile apps

    Consumers rely on mobile applications, even when there is no internet connection. To help you provide the always-on experience customers demand, database solutions like Couchbase Mobile have added synchronization and offline capabilities to their mobile database offerings. This white paper helps you choose the best mobile database for your needs.

    Download

  • Enhancing database security with Zero Trust

    Browse this white paper to discover why and how to apply Zero Trust to your business’s database security.

    Download

  • How businesses can win talent war with mobile apps, HR data analytics, and cloud technology

    Becoming more digital has emerged as a ruling concept among forward-looking organisations in recent years. Now, while having multi-channel engagement with customers is a big aspect of digital, so too is attracting and retaining the employees who can make a reality of digital transformation.

    Download

  • How best to put collaboration tools to work for your team

    This collection of recent expert advice aims to make your quest for the best option a bit easier. Read on and learn the latest on what collaboration tools now offer, including advanced technology like AI and speech recognition.

    Download

  • Graph database: Enable real-time decisions at scale

    Organizations today are turning to multi-model, multi-cloud databases that can be effective and efficient when dealing with different scenarios. Read on to learn about such a database and discover how you can leverage it to make real-time decisions at scale.

    Download

  • Simplify database management with Nutanix Database Service

    Discover in this product overview how Nutanix delivers predictable, non-disruptive scaling of compute and storage as database demands for your enterprise continue to grow.

    Download

  • Who should get the technology vote in the UK General Election?

    In this week's Computer Weekly, we take an in-depth look at the technology and digital policies in the main political parties' election manifestos. We examine the rise of alternatives to relational databases that better support a big data environment. And we assess the security issues around container technology. Read the issue now.

    Download

  • Streamline PostgreSQL with DBaaS for faster app dev

    Nutanix Database Service streamlines PostgreSQL management to reduce costs, while empowering developers to deploy DBs in minutes and automate tasks. Read the product overview to learn how NDB simplifies fleet management and empowers developers.

    Download

  • Computer Weekly – 26 February 2019: Delving into viewer data at the BBC

    In this week's Computer Weekly, we talk to the BBC about how the UK broadcaster is using data analytics to better understand its viewers and grow its audience. We look at how CERN is using IT automation in its quest to unravel the mysteries of the universe. And we examine the impact of GDPR on cloud storage. Read the issue now.

    Download

  • Guiding Your Leadership Team Through the Zero Trust Mindset

    Zero trust identifies users and entities and grants them just the right amount of access as needed. In this e-book, LATAM Field Technology Director at CyberArk, Cláudio Neiva, leverages his 24 years of experience to break down the essential elements of zero trust. Read on to learn more.

    Download

  • Inside the successful projects that rely on NoSQL database applications

    Check out this white paper for a look inside the modern challenges that NoSQL databases address, as well as when to choose NoSQL over relational and why.

    Download

  • NoSQL operational database solution

    In this product overview, you’ll discover a multi-model real-time NoSQL database powered by a unified storage engine format that is designed to give architects, developers, and DevOps the tools they need to make faster, more informed decisions. Read on to gain a deeper understanding of its features and capabilities.

    Download

  • 10 common NoSQL use cases for modern applications

    With businesses racing to build hyper-personalized customer experiences powered by generative AI, Couchbase announces vector search at the edge, enabling AI-powered mobile applications. Read on to learn about the 10 most common NoSQL use cases from customers using the Couchbase high performing database platform.

    Download

  • 50-page eBook: Configuration Management and CMDB for Dummies

    This 50-page eBook takes a deep dive into configuration management and CMDB – covering how to create a configuration management plan, build a healthy database, and align your plan to business use cases. Download now to get started.

    Download

  • How a NoSQL databases addresses today’s big data challenge

    Big data is becoming a big challenge for enterprises, who are now inundated with enormous amounts of social media data, server logs, clickstream data, machine data, geolocation data, and more. Discover how today’s professionals are addressing this new challenge with NoSQL databases in this e-book.

    Download

  • Webmail Forensics: Investigating Issues with Email Forwarding Security

    In this expert e-guide, application security expert Mike Cobb discusses webmail forensics possibilities for dealing with the aftermath of an issue involving email forwarding. Discover how to avoid these issues with your webmail and employees.

    Download

  • App migration 101: Which to lift-and-shift

    This e-guide looks at the different ways of migrating apps to the cloud: re-architecting and "lift and shift" and which path an individual apps should take. Not all apps are created the same, and figuring out the correct approach could save an enterprise time and money.

    Download

  • Amazon EC2 & Intel Xeon Scalable processor use cases: DBs, AI/ML, and more

    Amazon Web Services has launched new Amazon EC2 instances with Intel's 4th generation Xeon Scalable processors. For large databases, gaming, AI/ML, and video streaming, they provide up to 151% improved price-performance. Discover how the latest Xeon processors and EC2 instances can boost your workload performance here.

    Download

  • Avoiding the Oracle traps and risks with AWS solutions

    Download this e-book to learn how you can identify all the cost traps and risks around Oracle licensing and technologies, and implement best-practices, solutions, and strategies to minimize them in AWS.

    Download

  • Case study: How PayPal improved its fraud detection strategy

    Like most banking services, PayPal experiences fraud challenges. To improve security and identify emerging threats in real-time, they realized they needed to process and analyze more data faster. Download this case study now to learn how PayPal was able to overcome the limitations of its legacy infrastructure and stay secure.

    Download

  • Spark Muscles Into Big Data Processing

    Armed with data processing, streaming and machine learning capabilities, the multitalented Apache Spark architecture is becoming a force in its own right.

    Download

  • Last chance to share your tech purchasing decisions for 2024

    As new technologies are invented and further developed, organizations' tech investment priorities may change. After all, it is the demands of the business that often guides the direction of these developments. This cyclical phenomenon is what allows for industries of all types to grow so quickly, including your company.

    Download

  • Oracle cloud applications exhibit pragmatic adoption curve

    Oracle prides itself on the full suite of the business applications it offers in the cloud, arguably ahead of its closest rival, SAP – which has prioritised building on its in-memory database Hana over the cloud per se, though its S/4 Hana ERP system is increasingly delivered over the cloud, too.

    Download

  • CW APAC, February 2021: Buyer’s guide to data management

    In this handbook, focused on data management in the Asia-Pacific region, Computer Weekly looks at best practices, Alibaba’s use of databases, the role of artificial intelligence in handling information and data trends to look out for

    Download

  • How Threat Intelligence Can Give Enterprise Security the Upper Hand

    Attackers and threats on security are advancing at an alarming rate and many enterprises are not able to keep up. Take a look at this guide to learn more about threat intelligence and how it can be incorporating into your current security program.

    Download

  • Data discovery: how to pick the right software

    In this guide, we break down data discovery software by defining the categories, explaining the features and revealing the benefits. We also highlight the major players and products in an effort to inform buying decisions.

    Download

  • The long march of S/4 Hana

    S/4 Hana, the ERP system built on SAP's in-memory, columnar database Hana has been on a long march through the enterprise since its launch in February 2013. In this e-guide, we discuss the pros and cons of upgrading to S/4 Hana, what the future has in store for the system and how its users are feeling about C/4 Hana integration.

    Download

  • Focus: Cloud application development

    In this e-guide we take a close look at some of the latest trends in cloud application development, with in-depth interviews with the likes of Cloud Foundry and Pivotal, and find out how one public sector organisation is tapping into all these ideas in their quest for efficiency.

    Download

  • Top 10 information management stories of 2019

    Consolidation and acquisition marked the supplier side of the IT industry in respect of information management in 2019. The question of how modern BI and analytics software shapes up to nonrelational big data is addressed. Here are Computer Weekly's top 10 information management stories of 2019.

    Download