Database Management & Programming News, Articles & Tutorials for Database Administrators
Big Data Holiday Planning! 12/15/2014
Your big data repository won't simply add another twelve months of data over the next year. More data is coming, more categories of data will be created, and your analytical environment must expand to fit future needs. But size alone won't be your only problem. In the rush to accumulate a sufficient amount of valuable data and implement a business analytics environment that can produce usable results, several items may have been ignored, postponed, or simply forgotten. These missing details can make or break your company in the future.
Do You Really Need Oracle Optimizer_index_cost_adj Set? 12/11/2014
Performance is the watchword with a database and indexes can be a major part of that performance equation. Oracle provides the optimizer_index_cost_adj parameter but do you REALLY need to set it differently than the default? Read on to see what may happen when you do.
An Overview of the MySQL Performance Schema 12/08/2014
MySQL's Performance Schema provides a way to troubleshoot a lot of common performance issues without having to rely on specialized third-party solutions. The fact that it uses regular SQL is also a big plus! Join Rob Gravelle as he explores the Performance Schema.
Using the MERGE Statement to Perform an UPSERT 12/04/2014
The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement. Not only does the MERGE statement support the UPSERT concept, but it also supports deleting records. Greg Larsen discusses how to use the MERGE statement to UPDATE, INSERT and DELETE records from a target table.
Introduction to Azure SQL Database Scalability 12/01/2014
One of the primary advantages of Platform-as-a-Service (PaaS) solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.
How to Maintain Enterprise-Level Service with Oracle Standard Edition 11/26/2014
For business executives looking to save on information technology costs, it may seem like a win-win scenario in Oracle database environments to transition from Oracle Enterprise to Standard Edition. However, executives making this decision may not always be aware of or truly understand how transitioning from Enterprise to Standard Edition will affect the delivery of critical IT services, ultimately creating the potential to impact end user efficiency and revenue.
IBM Opens Watson Analytics to Public Beta 12/04/2014
After an early beta of IBM's Watson Analytics pulled in 22,000 early testers, Big Blue is now opening the service to everybody.
Splice Machine Ships Version 1.0 of Hadoop RDBMS 11/19/2014
Splice Machine takes its Hadoop relational database management system (RDBMS) to general availability.
Amazon Claims New Aurora DB Engine Screams With Speed 11/12/2014
NEWS ANALYSIS: Aurora may become a formidable competitor for comparable database engines by MySQL, SAP, Oracle, Teradata and EMC.
OpenStack Juno Cloud Features Trove Database-as-a-Service Updates 10/12/2014
The upcoming open-source OpenStack Juno cloud platform will now support more databases and database features.
Couchbase Launches v3.0 of Its NoSQL Database 10/10/2014
Couchbase 3.0 introduces more than 200 new features and enhancements, including major extensions to its core architecture.
IBM Tweaks DB2 With BLU Acceleration for Big Data 10/03/2014
IBM has updated its DB2 with BLU Acceleration in-memory solution to handle transactional data as well as analytical workloads.
Microsoft to Cut Azure SQL Prices This Fall 08/27/2014
Microsoft is getting ready to slash prices by up to 50 percent after Azure SQL's new service tiers are made generally available next month.
Microsoft Entices Oracle Shops With SQL Server 2014 Migration Tool 07/25/2014
The company focuses on SQL Server 2014's in-memory capabilities in its bid to siphon enterprise database workloads from rival Oracle.
Oracle Big Data SQL Connects Various Data Sets for Analysis 07/16/2014
This can run a single SQL query on Oracle's own 12C database at the same time as in Hadoop and NoSQL data stores.
Couchbase Raises $60 Million to Fuel NoSQL Database Efforts 06/30/2014
Investors continue to be confident in the prospects of NoSQL database technology.
More Database News...