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.
-
E-Guide: Database Tools for Auditing and Forensics
By: TechTarget Security
Type: eGuide
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:
-
CW APAC: Trend Watch: Database technology
By: TechTarget ComputerWeekly.com
Type: Ezine
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.
-
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.
-
Preparing a database strategy for Big Data
By: TechTarget Data Management
Type: eGuide
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.
-
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.
-
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?
-
Stopping application layer DDoS attacks: What you need to know
By: TechTarget Security
Type: eGuide
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.
-
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.
-
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.
-
Simplify database management with Nutanix Database Service
By: Nutanix
Type: Product Overview
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.
-
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.
-
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.
-
Improve SQL Server performance with transformative database services
By: Nutanix
Type: Product Overview
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.
-
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.
-
Databases and your unique environment: Your comprehensive guide
By: Nutanix
Type: eBook
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.
-
AIOps: Quieting Alerts & Predicting DB Issues
By: AWS & Solarwinds
Type: Blog
As data grows, monitoring tools generate too many alerts, reducing productivity. AIOps uses AI to reduce noise, predict issues, and automate fixes. Read the full blog post on the future of database monitoring to learn how SolarWinds applies AI to accelerate time to detect, time to isolate and time to recovery of database issues.
-
How to achieve better database performance and consolidate your data center
By: Dell
Type: Infographic
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.
-
Boost AWS Migration & Optimize with SolarWinds DPA
By: AWS & Solarwinds
Type: Product Overview
Streamline SQL migration to AWS using SolarWinds Database Performance Analzer (DPA). Gain DBA insights for swift, secure SQL transfers. Optimize performance, manage costs, and maintain data availability. Download this white paper to explore the full capabilities of SolarWind’s newest DB solution.
-
Enhancing database security with Zero Trust
By: Trustwave
Type: White Paper
Browse this white paper to discover why and how to apply Zero Trust to your business’s database security.
-
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.
-
Virtual Data Center E-Zine Volume 32: Public vs. Private: Comparing Cloud Architectures
By: TechTarget Data Center
Type: Ezine
Before committing to a public or private cloud architecture, evaluate the benefits and especially the tradeoffs associated with each. Also in this issue, determine what needs are most important when planning your virtual applications, and find out how to monitor the performance of applications in the cloud.
-
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.
-
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.
-
33-pg e-book: Vector databases 101
By: KX
Type: eBook
Thanks to advances in AI and machine learning, vector databases are capable of automatically sorting through data based on content similarity to help your business process unstructured data with ease. Download this 33-page e-book now to learn about the basics of vector databases and discover how they can enable simplified data management.
-
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
-
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.
-
How to optimize performance of your SaaS applications
By: Silk Technologies Inc
Type: White Paper
Building and deploying SaaS applications and database services can be a complex and costly initiative. This white paper dives into the key factors that you need to consider during the development process. Read on to learn about principles you can leverage to maximize the performance of your applications.
-
Graph database: Enable real-time decisions at scale
By: Aerospike
Type: White Paper
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.
-
Streamline PostgreSQL with DBaaS for faster app dev
By: Nutanix
Type: Product Overview
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.
-
Amazon EC2 & Intel Xeon Scalable processor use cases: DBs, AI/ML, and more
By: AWS & Intel
Type: Resource
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.
-
Achieving Comprehensive Observability of Your Digital Business
By: AWS & Solarwinds
Type: Product Overview
To operate complex, distributed applications, enterprises adopt observability solutions. SolarWinds Observability provides 360-degree visibility into apps, databases & user experience. Leveraging AI, it detects issues & automates fixes. Read how SolarWinds Observability enables resilient, performant apps.
-
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.
-
Accelerate SQL Server DB migration with performance monitoring
By: AWS & Solarwinds
Type: Product Overview
Migrate SQL Server to AWS efficiently with SolarWinds SQL Sentry. It monitors workloads, sets baselines, and spots issues, enhancing migration. Gain insights on resource use and query performance for 1,000+ databases. Discover how DocuSign achieved 99.999% reliability with SQL Sentry in this resource.
-
Comprehensive guide: Migrating SQL Server to AWS
By: AWS & Solarwinds
Type: eBook
Migrating SQL Server workloads to AWS needs careful planning and testing. Utilize AWS with SolarWinds SQL Sentry and Database Mapper to speed up migration. Discovery, analysis, validation, and support ensure reliable cloud data platforms. Consult the full guide for safe migration insights.
-
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
-
4 leading approaches to software integration
By: CData Software
Type: White Paper
You can build drivers into your applications to provide a more productive overall developer experience when compared to other integration approaches.
-
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.
-
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.