Newsletters




Database Management

Relational Database Management Systems (RDBMSs) continue to do the heavy lifting in data management, while newer database management systems are taking on prominent roles as well. NoSQL database systems such as Key-Value, Column Family, Graph, and Document databases, are gaining acceptance due to their ability to handle unstructured and semi-structured data. MultiValue, sometimes called the fifth NoSQL database, is also a well-established database management technology which continues to evolve to address new enterprise requirements.



Database Management Articles

The DBA's role is becoming increasingly complex and now often involves managing data both on premise and in the cloud, and in a variety of database management systems including not only traditional relational systems such as Oracle, SQL Server, MySQL and others, but also new open source and NoSQL technologies, according to Gerardo Dada, vice president of product marketing, at SolarWinds.

Posted October 28, 2015

During the Sunday keynote presentation at Oracle OpenWorld, Oracle CEO Mark Hurd and Brian Krzanich CEO, Intel, introduced the new Exa Your Power Program to help customers migrate Oracle Database from IBM Power systems to Oracle Engineered Systems using Intel technology.

Posted October 26, 2015

Oracle kicked off the beta program for an updated release Oracle Database 12c which provides a multitenant architecture and dual format in-memory database technology. According to Oracle, Oracle Database 12c Release 2 further simplifies the journey to the cloud and enables efficient delivery of database services, with greater consolidation density and more administrative agility at cloud scale.

Posted October 26, 2015

Attunity Ltd., a provider of data management software solutions, has introduced the latest version of its data replication and loading solution. Designed to accelerate enterprise big data analytics initiatives, Attunity Replicate 5.0 automates big data movement to, from and between databases, data warehouses, Hadoop and the cloud, reducing the time and labor, and ultimately the cost of making big data analytics available in real time.

Posted October 26, 2015

To kick off Oracle Open World 2015, Oracle's annual user conference at the Moscone Center in San Francisco, CTO and executive chairman Larry Ellison detailed the steps that led Oracle be positioned in "every layer of the cloud." Ellison outlined the top design goals for the company in all three layers of the cloud - SaaS, PaaS and IaaS. These are cost, reliability, performance, standards, compatibility - as well as security, which he said is increasingly becoming a more critical concern.

Posted October 26, 2015

Until the safe harbor agreement between U.S. and Europe was ruled invalid recently in a European court, it was understood that for any European company the U.S. was safe, and the data security in the U.S. was acceptable. But the recent ruling by the European Court of Justice says that is "actually not true," said Andreas Gauger, chief marketing officer and cofounder of Profitbricks, a cloud computing IaaS company. Now, a new agreement will have to be forged between the different entities. "Now that band-aid has been ripped off and the wound is open. Now they have to sit down and finally agree on something."

Posted October 22, 2015

With the current rate of data growth, it is not inconceivable that in 3 years, we'll have 10 times the volume of data we have today. The challenge will only continue to grow, but by following the five C's of data visualization, it is possible to prepare data and present eye-opening data visualization to improve users' reporting, analytics, and overall business intelligence.

Posted October 22, 2015

Enterprise data security provider Protegrity has announced that it has earned Oracle Exadata Optimized status through the Oracle PartnerNetwork (OPN), demonstrating that Protegrity Database Protector for Oracle Exadata is recognized as having been tested and tuned on Oracle Exadata Database Machine to deliver speed, scalability and reliability to customers.

Posted October 21, 2015

Oracle today announced the general availability of MySQL 5.7, the latest version of the open source database. According to Tomas Ulin, vice president, MySQL Engineering, Oracle, the new version delivers greater performance, scalability, manageability, plus enhanced NoSQL capabilities with JSON support and MySQL Router, which makes it easy to connect applications to multiple MySQL databases.

Posted October 21, 2015

Ever since Linux became a viable server operating system, organizations have been looking to all kinds of open source software (OSS) to save on license and maintenance costs and to enjoy the benefits of an open platform that invites innovation. If you're considering MySQL or another open source DBMS as either your primary database or to, perhaps, operate alongside your existing commercial systems, such as Oracle or Microsoft SQL Server, for one reason or another, here are seven things to keep in mind.

Posted October 21, 2015

The Agile methodology is great for getting turgid development teams to start working faster and more coherently. With Agile, which focuses on more rapid, incremental deliverables and cross-departmental collaboration, the bureaucratic plaque is flushed from the information technology groups' arteries. But there is a dark side to Agile approaches.

Posted October 21, 2015

Teradata is introducing a series of platforms that will capture streaming IoT data, land that data in Hadoop, and use advanced Aster machine learning natively in Hadoop to analyze data.

Posted October 20, 2015

The topics of resilience and change have been on my mind a lot lately for a variety of reasons. First, IT is always at the center of technology change, so that's nothing new. We must continually learn and keep abreast of new technology and trends before they even materialize. Second, I am an IT leader in the energy industry, and when one is at the mercy of natural resource supply and demand, there will be peaks and valleys in production and financial performance over the years. With this latest dip in energy prices, I sense a different perspective—one of working smarter and more efficiently, emphasizing innovation, and analyzing decisions with an enterprise perspective of what is right for the company at this time, not just IT.

Posted October 14, 2015

There's unrelenting pressure on businesses to compete on analytics and to be able to anticipate customer needs and trends ahead of the curve. Enterprises are looking to expand BI and analytics capabilities as far and wide as technologies and budgets will allow them to go. As a result, the continuing advance of analytic capabilities across the enterprise has reached a "tipping point."

Posted October 14, 2015

At Strata + Hadoop World 2015, Attunity announced the release of Attunity Replicate Express, a downloadable edition of its data replication and loading software. The solution, which answers a growing demand for more accessible real-time big data analytics, is freely available to download online. The new solution supports ingesting data to and from Oracle, SQL Server, and Hadoop Data Lakes for test and development environments.

Posted October 14, 2015

As more and more applications, websites, and basic smart home devices ask users permissions for their data, people are starting to wonder where their information is going. The question of privacy, the Internet of Things, and what companies do with an individual's personal information was the subject of two different sessions at Strata + Hadoop World in NYC.

Posted October 13, 2015

In what is being hailed as the biggest tech merger ever, Dell Inc. and EMC Corp. today formally announced they have signed a definitive agreement under which Dell will acquire EMC. The total transaction is valued at $67 billion. The deal is expected to close in the second or third quarter of Dell's fiscal year which ends February 3, 2017 (within the months of May to October 2016). The industry is going through a "tremendous transformation," with the old style of IT being "pretty quickly disrupted" yet this rapid change is also presenting "incredibly rich" opportunities, said Joe Tucci, chairman and chief executive officer of EMC, during a conference call with media and industry analysts.

Posted October 12, 2015

IBM has entered into a definitive agreement to acquire Cleversafe, Inc., a developer and manufacturer of object-based storage software and appliances. The acquisition will enhance IBM's positions in storage and hybrid cloud.

Posted October 12, 2015

Prior to SQL Server 2016, currently in CTP, your main method for encrypting a SQL Server application was to use a feature called Transparent Data Encryption. TDE provides strong encryption, but with some shortcomings. First, you have to encrypt an entire database. No granularity is offered at a lower level, such as encrypting specific tables or certain data within a table. Second, TDE encrypts only data at rest, in files. Data in memory or in-flight between the application and server are unencrypted. Enter Always Encrypted.

Posted October 07, 2015

Too little emphasis overall is placed on the integrity and recoverability of the data—and too much is placed on performance. Yes, performance is probably the most visible aspect of database systems, at least from the perspective of the end user. But the underlying assumption of the end user is always that they want to access accurate and, usually, up-to-date data. But what good does it do to quickly access the wrong data? Anybody can provide rapid access to the wrong data!

Posted October 07, 2015

Embarcadero Technologies, a provider of software solutions for application and database development, recently unveiled DB PowerStudio 2016, a suite of database tools that provides database managers and data professionals with comprehensive administration, development, performance and monitoring capabilities across multiple platforms.

Posted October 07, 2015

Syncsort is continuing to grow its platforms capabilities by announcing new integration with two active open source platforms, Apache Kafka and Apache Spark, enabling users to better handle real-time, large-scale data processing, analytics, and feeds.

Posted October 01, 2015

Redis Labs is extending its cloud strategy to on-prem, private and hybrid, allowing enterprises to install an enterprise-grade cluster that acts as a container for managing and running multiple Redis databases.

Posted September 29, 2015

Traditional data warehousing models and open source alternatives such as Apache Hadoop and Storm have been touted as solutions to a variety of "big data" challenges. However, utilities have found that these approaches cannot handle the scale and complexity of data generated in industrial environments. Additionally, they fail to provide the real-time analysis and situational awareness that utilities need to improve decision making or address critical events in real-time, such as optimizing crews during outages and severe weather events.

Posted September 24, 2015

There are various terms being bandied about that describe the new world data centers are entering—from the "third platform" to the "digital enterprise" to the "always-on" organization. Whatever the terminology, it's clear there is a monumental shift underway. Business and IT leaders alike are rethinking their approaches to technology, rethinking their roles in managing this technology, and, ultimately, rethinking their businesses. The underlying technologies supporting this movement—social, mobile, data analytics, and cloud—are also causing IT leaders to rethink the way in which database systems are being developed and deployed.

Posted September 24, 2015

Ricoh Company, Ltd, the printing and document management company, is using Oracle's SPARC T5 servers with Oracle ZFS Storage Appliances and Oracle Database to analyze data from RICOH @Remote, its real-time support service for customers in more than 100 countries and regions. To unify the data across the company for accurate views and analysis, Ricoh built a private cloud accessible by the entire remote service group that allows high speed access from internal networks.

Posted September 24, 2015

To help companies get more value from big data, SAP has introduced HANA Vora, a new in-memory computing engine that leverages and extends the Apache Spark execution framework to provide enriched, interactive analytics on Hadoop. HANA Vora is a completely new product built from the ground up and is aimed at better processing of data to make business decisions.

Posted September 23, 2015

Shortly after the explosion of non-relational databases, around 2009, it became apparent that rather than being part of the problem, SQL would instead continue to be part of the solution. If the new wave of database systems excluded the vast population of SQL-literate professionals, then their uptake in the business world would be impeded. Furthermore, a whole generation of business intelligence tools use SQL as the common way of translating user information requests into database queries. Nowhere was the drive toward SQL adoption more clear than in the case of Hadoop.

Posted September 23, 2015

Percona, a provider of enterprise-class MySQL and MongoDB solutions and services, is introducing Percona Server for MongoDB, an enhanced, open source, fully compatible drop-in replacement for MongoDB Community Edition that offers additional enterprise features and lower total cost of ownership. Completely open source and free to download and use, Percona Server for MongoDB offers all the features of MongoDB 3.0 Community Edition, along with two additional storage engine options - PerconaFT and Facebook's RocksDB - and enterprise-grade functionality, including Simple Authentication and Security Layer (SASL) and advanced auditing.

Posted September 22, 2015

SolarWinds, a provider of hybrid IT infrastructure management platforms, is adding support for MySQL databases to SolarWinds Database Performance Analyzer (DPA) 10.0. "DPA allows you to quickly pinpoint what is slowing down your database and applications and you can find problems that are usually very hard to find within your database," said Gerardo Dada, vice president of product marketing at SolarWinds.

Posted September 16, 2015

Whenever I get into a discussion about database standards I invariably bring up one of my favorite quotes on the topic: "The best thing about standards is that there are so many to choose from." It shouldn't be true, but it is.

Posted September 15, 2015

Data modelers face a choice when encountering multiple variations of a data item. Designers must focus on the longer term appropriateness of their decisions when choosing how their designs will play out; and going vertical or horizontal does have an impact over time.

Posted September 09, 2015

Kore Technologies has announced the release of version 5.4 KommerceServer eCommerce Suite. KommerceServer eCommerce Suite includes a storefront, customer portal, and mobile edition, and is engineered to integrate with any back office ERP system (e.g., Epicor Eclipse, Prelude, Infor LN and more). This release benefits both the customer and the e-commerce administrator.

Posted September 09, 2015

Entrinsik has announced a partnership with Ticomix to help companies enhance their customer relationships and improve business results. This partnership will offer Ticomix customers the ability to integrate Informer with SugarCRM to provide organizations with the ability to perform multidimensional reporting and advanced data analysis in order to better track, understand and manage their SugarCRM data with Informer.

Posted September 09, 2015

Revelation Software is preparing for the introduction of OpenInsight 10, the most significant release since Revelation took OpenInsight into the 32-bit world. To provide information to its user base in advance of the new release, Revelation has announced a Revelation Users Group (RUG) meeting in the EMEA region.

Posted September 09, 2015

Birst, a provider of cloud BI and analytics software, has introduced a new technology it calls "Networked BI" to enable global governance with local execution. According to Birst, the new approach furthers its vision of trusted and agile collaboration between both centralized and decentralized teams.

Posted September 08, 2015

There are fundamental differences in priorities and approaches in building operational solutions and in constructing analytical supporting solutions. However, these differences can produce a gap in understanding that occasionally results in minor battles and skirmishes between these groups along the path of getting work done. A critical area of conflict is access to production data. When building an operationally focused solution such as a website, the application is supreme.

Posted September 08, 2015

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102

Sponsors