Database Worst Practices: The Top 5 Mistakes Developers Make and How to Avoid Them
By: EnterpriseDB Corporation View more from EnterpriseDB Corporation >>
Download this next:
Jargon buster guide to database management
By: TechTarget ComputerWeekly.com
Type: eGuide
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: "Database Worst Practices: The Top 5 Mistakes Developers Make and How to Avoid Them"
-
Infographic: Advantages and disadvantages of key-value databases
By: TechTarget ComputerWeekly.com
Type: Infographic
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.
-
CW APAC: Trend Watch: Database technology
By: TechTarget ComputerWeekly.com
Type: Ezine
Innovative data management offerings are improving the efficiency of enterprise operations. In this handbook, focused on database technology in the Asia-Pacific region, Computer Weekly looks at the impact of graph databases, Neo4j’s partnership with Deloitte, TigerGraph’s added security features and the different types of database management systems currently on the market.
Find more content like what you just read:
-
Infographic: NoSQL Databases
By: TechTarget ComputerWeekly.com
Type: Infographic
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.
-
Taking stock of database technologies
By: TechTarget ComputerWeekly.com
Type: eGuide
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.
-
Oracle - Autonomous computing that declines a special name
By: TechTarget ComputerWeekly.com
Type: eGuide
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.
-
A Computer Weekly buyer's guide to NoSQL
By: TechTarget ComputerWeekly.com
Type: eBook
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.
-
A Computer Weekly buyer's guide to graph databases
By: TechTarget ComputerWeekly.com
Type: eBook
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.
-
Infographic: Comparing cloud database security
By: TechTarget ComputerWeekly.com
Type: Infographic
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.
-
Computer Weekly – 23 July 2024: Serving up a GenAI experience at Wimbledon
By: TechTarget ComputerWeekly.com
Type: Ezine
In this week's Computer Weekly, we go behind the scenes at Wimbledon to find out how technology is improving the tennis experience for fans. We talk to Meta's AI research chief about the challenges and opportunities of large language models. And we find out why cloud databases are becoming increasingly popular. Read the issue now.
-
CW ASEAN – September 2018: Time to clear DevOps hurdles
By: TechTarget ComputerWeekly.com
Type: Ezine
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?
-
Riding the elephant: how to manage big data
By: TechTarget ComputerWeekly.com
Type: eGuide
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?
-
Computer Weekly - 15 February 2022: On a mission to track space junk
By: TechTarget ComputerWeekly.com
Type: Ezine
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.
-
How businesses can win talent war with mobile apps, HR data analytics, and cloud technology
By: TechTarget ComputerWeekly.com
Type: eGuide
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.
-
Top 10 information management stories of 2019
By: TechTarget ComputerWeekly.com
Type: eGuide
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.
-
4 reasons to consider cloud database migration
By: AllCloud
Type: Blog
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.
-
An Insiders Guide to AI Databases
By: Aerospike
Type: eBook
This e-book provides an insider's guide to AI databases, explaining vector data, use cases, and how to choose the right database for your AI project. Inside, you'll learn how to match AI database capabilities with your requirements and drive innovation. Read the full e-book now to explore the complex AI database landscape.
-
How to choose a database for your mobile apps
By: Couchbase
Type: White Paper
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.
-
Who should get the technology vote in the UK General Election?
By: TechTarget ComputerWeekly.com
Type: Ezine
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.
-
Data discovery: how to pick the right software
By: TechTarget ComputerWeekly.com
Type: eGuide
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.
-
Last chance to share your tech purchasing decisions for 2024
By: TechTarget ComputerWeekly.com
Type: Landing Page
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.
-
5 Places Your True Database Costs are Hiding
By: Aerospike
Type: eBook
In this e-book, you'll discover the 5 hidden costs of database selection that can significantly impact your business. You'll also learn how to choose a scalable, efficient database that delivers high performance, reliability, and cost savings. Read the full e-book now to find out how you can optimize your database TCO.
-
Choosing the right database for your workload
By: Aerospike
Type: Webcast
Several years ago, it was easy – there was only one choice for your database: RDBMS. Today, there are dozens of options for your application data layers and it is not that easy anymore. This session will help you choose the right database for your application and make sure you have the right tool for the job. Tune in now to learn more.
-
Global IT Priorities Report 2016
By: TechTarget ComputerWeekly.com
Type: Research Content
Benchmark your IT spending plans with our in-depth study of IT spending priorities from around the world.
-
Building a Micro-Segmentation Strategy in 5 Steps
By: Illumio
Type: White Paper
Download this white paper to learn how to build an effective micro-segmentation strategy including identifying high-value assets, mapping your application dependencies and enrich with vulnerability data, understanding the types of segmentation for security, and more.
-
Strategies to extend the life of your Oracle database investment
By: Rimini Street
Type: Research Content
Explore strategies to extend the life of your Oracle database investment without costly upgrades. Learn how to maximize existing investments, reduce risks, and improve support - all while staying on older versions. Read the full research content to discover practical solutions.
-
Why NoSQL for AI-powered applications: An architectural guide
By: Couchbase
Type: White Paper
NoSQL databases are built to be flexible, scalable, and capable of rapidly responding to the data management demands of modern businesses, which means they can serve as the basis for AI applications that need ultimate adaptability now and into the future. Read this architectural guide now to learn more.
-
Graph Database Buyers' Guide
By: Aerospike
Type: Buyer's Guide
This buyer's guide examines considerations for choosing a graph database, including performance, scalability, developer experience, and total cost of ownership. Inside, you'll learn how to evaluate graph databases for transactional and analytical use cases. Read the full guide now to help your organization make an informed decision.
-
Database as a service (DBaaS): Key questions
By: Silk Technologies Inc
Type: eBook
The shift to Database as a Service (DBaaS) marks a significant stride in cloud transformation, offering unmatched scalability, performance, and security for database workloads. Read on to learn how DBaaS can alleviate your in-house teams from the intricacies of database management, empowering them to focus on innovation and strategic initiatives.
-
50-page eBook: Configuration Management and CMDB for Dummies
By: ServiceNow
Type: eBook
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.
-
Innovation Awards APAC 2023 - Telecommunications: SensorFlow
By: TechTarget ComputerWeekly.com
Type: eGuide
Smart building management specialist SensorFlow topped the telecommunications category for the APAC Innovation Awards with its project to re-architecture its entire platform. The project had 3 initiatives - reduce cost, improve data-driven decision making, and implement a real-time business intelligence dashboard for its customers.
-
A Computer Weekly buyer’s guide to data visualisation
By: TechTarget ComputerWeekly.com
Type: Essential Guide
Data visualisation is proving its value throughout a period of economic uncertainty. In this 16-page buyer’s guide, Computer Weekly looks at the rise of embedded analytics, the advantages of real-time data and Siemens’ exploration of industrial metaverse use cases
-
Inside the successful projects that rely on NoSQL database applications
By: Couchbase
Type: White Paper
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.
-
10 common NoSQL use cases for modern applications
By: Couchbase
Type: White Paper
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.
-
Computer Weekly – 25 July 2017: How the DVLA is making driving digital
By: TechTarget ComputerWeekly.com
Type: Ezine
In this week's Computer Weekly, we hear from the DVLA about how it is becoming a digital hub for motoring and moving away from its legacy IT. Our latest buyer's guide examines the future of data management. And we look at the importance of understanding the small print in your software licensing agreements. Read the issue now.
-
Couchbase in an AI-first world
By: Couchbase
Type: Analyst Report
Couchbase announced CapellaIQ, generative AI (GenAI) capabilities, into its database-as-a-service (DBaaS) product Couchbase Capella. The new capability enables developers to write SQL++ and generate sample data and application-level code more quickly by offering recommendations.
-
JSON data modeling in document databases
By: Couchbase
Type: Webcast
Are you interested in using a JSON document database, but feeling a little overwhelmed by some of the complexities? In this webcast, Couchbase makes JSON feel more familiar by using comparisons to traditional RDBMS modeling to guide you through the basics of data modeling with JSON.
-
Your GDPR guide
By: TechTarget ComputerWeekly.com
Type: eGuide
Despite the focus on data protection, many organisations are still leaving their data wide open for attack through the digital equivalent of leaving the front door open and the windows unlocked from a hacker perspective.
-
Jargon buster guide to GDPR
By: TechTarget ComputerWeekly.com
Type: eGuide
In this guide, we provide the 10 most important things you need to know about GDPR, and a jargon-buster explanation for some of the key terminology.
-
Vector databases: What you should know
By: Aerospike
Type: Webcast
To learn about what vector databases are and why they matter, check out this 23-minute guide by Developer Advocate at Aerospike, Tim Faulkes.
-
Computer Weekly – 30 July 2024: CrowdStrike blue screen bug serves a stark warning
By: TechTarget ComputerWeekly.com
Type: Ezine
In this week's Computer Weekly, we analyse the lessons from the global IT outage caused by the blue screen bug in CrowdStrike security software. We talk to the data chief of Barilla, the €4bn pasta maker, about the benefits of asking, "So what?" And we find out how Finland is taking a lead on quantum computing. Read the issue now.
-
Cloud database as a service (DBaaS): Build a more resilient architecture
By: Silk Technologies Inc
Type: Webcast
In this webinar, you’ll hear from Tom O’Neill, International CTO, and David Berliner, Senior Director of Product, of Silk as they share insights into how organizations can overcome key database challenges by leveraging cloud database-as-a-service. Tune in now to gain expert knowledge and discover the potential of cloud DBaaS for your business.
-
MicroScope – January 2022: Squaring up to ransomware
By: MicroScope
Type: Ezine
In this issue, discover how to best fend off the ever-increasing threat of ransomware, learn what the next stage of the data warehouse could be, and find out what leading channel experts believe awaits the industry in the year ahead
-
Big Data and Analytics Applied to Oil and Gas
By: TechTarget ComputerWeekly.com
Type: Essential Guide
Companies that leverage data to optimise business processes will not only survive, but thrive during market downturns, and dominate the industry on the next upswing, this report from Quorum argues.
-
Oracle cloud applications exhibit pragmatic adoption curve
By: TechTarget ComputerWeekly.com
Type: eGuide
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.
-
Towards more robust internetworks
By: TechTarget ComputerWeekly.com
Type: Essential Guide
This article in our Royal Holloway Security Series explains how graph theory can be used to model internetworks and improve their resilience against failures and attacks.
-
The technological evolution of IT industry leaders: Part two
By: TechTarget ComputerWeekly.com
Type: eGuide
Companies leading the technological evolution have gone through changes. This second part of this e-guide explores the technological evolution of SAP, Microsoft and some business analytics vendors throughout the past two decades.
-
AI to advance Swedish military systems
By: TechTarget ComputerWeekly.com
Type: eGuide
The rapid advance of artificial intelligence (AI) and machine learning is poised to play an ever-increasing role in the development of next-generation military systems. Swedish report into use of artificial intelligence in military systems reveals opportunities and concerns. Read the story now.
-
5 reasons to replace your database
By: Aerospike
Type: Webcast
This webinar highlights 5 reasons to replace your data platform, as well as real-world case studies on improving efficiency through strategic database transition, proven strategies to enhance database performance, and more
-
Why NoSQL for AI-powered apps: A guide for developers
By: Couchbase
Type: White Paper
Modern NoSQL databases incorporate multiple data access methods and encompass a variety of models including key-value, document, column, time series, graph, text search, and AI vector search. This developer’s guide explains the many advantages that are making multipurpose NoSQL databases the developer’s choice for AI-powered adaptive applications.