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

Recursive SQL can be very elegant and efficient. However, because of the difficulty developers can have understanding recursion, it is sometimes thought of as "too inefficient to use frequently." But, if you have a business need to walk or explode hierarchies in your database, recursive SQL will likely be your most efficient option.

Posted May 08, 2014

At an event in NYC, Oracle president Mark Hurd and EVP John Fowler unveiled Solaris 11.2, which represents an evolution from operating system to a complete platform, they said. The phenomena of cloud and engineered systems are driven by the same requirement, which is the need to transfer work from the IT budget to the R&D budget to make things work more efficiently, observed Hurd, who asked, "Who really wants to glue an operating system to a server?"

Posted May 08, 2014

BackOffice Associates' HiT Software division has announced that DBMoto version 8.2 includes support for SAP Sybase IQ, and support for Oracle Database 12c as a multitenant database with one or many pluggable databases;

Posted April 30, 2014

In recent years, PostgreSQL has become the default back-end choice of developers for many web and enterprise applications. PostgreSQL recently became available as one of the managed database offerings provided by Amazon RDS alongside MySQL, Oracle and SQL Server. If you haven't tried it already, RDS provides a great platform for those getting started with PostgreSQL. Here's what you need to know.

Posted April 23, 2014

Enhancing its portfolio of enterprise cloud services, Oracle has introduced two new services, Oracle Database Backup Service and Oracle Storage Cloud Service. According to Rex Wang, vice president, Product Marketing, Oracle, the new services help simplify IT, reduce costs, and accelerate innovation to drive competitive advantage.

Posted April 16, 2014

Cloud database technology may be ready for the enterprise, but enterprises are not quite ready for cloud databases. Even leading cloud database proponents agree that cloud databases are a relatively new—and untested phenomenon.

Posted April 16, 2014

Calypso Technology, Inc., an integrated capital markets platform provider, announced that Calypso version 14 has achieved Oracle Exadata Optimized status through Oracle PartnerNetwork (OPN). According to Tej Sidhu, senior vice president for Engineering and CTO at Calypso Technology, in simulations of data-intensive straight through-processing tasks, Calypso achieved performance gains of up to 500% using Exadata hardware.

Posted April 10, 2014

TeamWork, a database change management solution from DBMaestro, is now available for SQL Server as well as Oracle.

Posted April 09, 2014

Kelly Stirman, director of product marketing at MongoDB, emphasized simplicity, reliability, and security in a recent conversation about the new capabilities of MongoDB 2.6. "Don't let the 2.6 fool you. It is absolutely the biggest release we have ever done."

Posted April 08, 2014

Teradata has introduced the Teradata Database 15 with a new software product called Teradata QueryGrid that provides virtual compute capability within and beyond the Teradata Unified Data Architecture. The company also announced Teradata Active Enterprise Data Warehouse 6750 platform with new capabilities to support customers' most demanding real-time workloads.

Posted April 07, 2014

Driving a wide range of applications, from operational applications such as fraud detection to strategic analysis such as customer segmentation, advanced analytics goes deeper than traditional business intelligence activities into the "why" of the situation, and delivers likely outcomes.

Posted April 04, 2014

Using the Oracle Database 12c Multitenant features sets up the 12c environment in a way that provides some additional flexibility and supports a move to a pluggable databases setting. If database instances are created as CDB with a single PDB, and the requirement comes to consolidate several of these instances together, the move to a Multitenant environment is a whole lot easier.

Posted April 04, 2014

Ntirety, a provider of remote DBA, data consulting, and DBA on-demand services for Oracle, SQL Server and MySQL, has been acquired by HOSTING. With the acquisition, said Ntirety founder Michael Corey, the Dedham-based company becomes a division of HOSTING, with Corey as president of the division.

Posted April 04, 2014

The theme for COLLABORATE 14-IOUG Forum is "Become Your Office Superhero," because, while you may look like a mild mannered technical resource in meetings or at your desk, you fight a daily battle to protect your organization's data, improve performance and generate new business opportunities. COLLABORATE is your chance to recharge your superpowers and to take on new skills.

Posted April 02, 2014

SAP has officially announced Adaptive Server Enterprise (ASE) 16, a major release of the company's RDBMS, as well as Replication Server, 15.7 SP200 which includes synchronous replication for HA/DR for SAP Business Suite on ASE. It has been 9 years since Sybase (acquired by SAP in 2010) announced ASE 15 in August 2005. With the new release, said Dan Lahl, SAP VP, Database & Technology Marketing, SAP is providing "the right system of record that is going to be able to handle the new world of transaction processing."

Posted April 02, 2014

Attunity Replicate, a data replication and loading solution, has introduced new support for MySQL as a source and target as well as for multiple non-relational sources including Enscribe, RMS, IMS, and VSAM.

Posted April 02, 2014

A new Development Milestone Release for MySQL 5.7, as well as other MySQL product releases and early access features, has been announced by Oracle. With MySQL 5.7.4 DMR, the open source database is twice as fast as the previous version.

Posted April 01, 2014

Alyssa Johnson, who became president of the OAUG in January, recently spoke with DBTA about the challenges and choices facing OAUG members. A major topic of discussion for Oracle users at the upcoming COLLABORATE 14 conference will be how and when to migrate to E-Business Suite 12, says Johnson. Covering a range of business areas, including CRM, financial management, supply chain management, EBS is a backbone suite of ERP applications on which many companies rely to run their businesses. End of support is looming for 11i, Johnson says, and it's time to decide on 12.1.3 or 12.2 and start planning that upgrade now.

Posted March 26, 2014

Today, businesses are ending up with more and more critical dependency on their data infrastructure. If underlying database systems are not available, manufacturing floors cannot operate, stock exchanges cannot trade, retail stores cannot sell, banks cannot serve customers, mobile phone users cannot place calls, stadiums cannot host sports games, gyms cannot verify their subscribers' identity. Here is a look at some of the trends and how they are going to impact data management professionals.

Posted March 26, 2014

Finding high quality education and training remains a key challenge for SAP users, according to Mike Harrold, executive director for the Independent SAP Technical Users Group (ISUG-TECH). With the 2014 ISUG-TECH conference fast-approaching (April 14-17), Harrold talked about SAP's planned launch of ASE (Adaptive Server Enterprise) 16 at the conference and the best ways for SAP users to get the product information they need.

Posted March 26, 2014

CAKE, a provider of business intelligence to marketers and advertisers, has selected the ParStream real-time database to query and analyze data quickly.

Posted March 26, 2014

Newton, Mass.-based ScaleBase has announced the 3.0 version of its Distributed Database Platform. ScaleBase also introduced a beta program for a new product called Analysis Genie that helps companies determine the best way to scale out a database from a single MySQL instance to a distributed cluster by analyzing their schema and queries.

Posted March 20, 2014

Oracle announced that fiscal 2014 Q3 total revenues were up 4% to $9.3 billion. In constant currency, Oracle's Cloud Software subscriptions revenues grew 25% and its Engineered Systems revenue grew more than 30% in the quarter, said Oracle president and CFO Safra Catz in a statement released by the company.

Posted March 19, 2014

HP, which has a decades-long partnership with Oracle, has been named an Oracle PartnerNetwork (OPN) Diamond level partner, which is the highest ranking available in the OPN Specialized program.

Posted March 19, 2014

Historical content within data structures increases their complexity. Making complexity "easy" for the initial developers and "harder" for the later users is a short-sighted approach.

Posted March 12, 2014

Database disaster recovery must be an integral component of your overall business recovery plan. Just because your organization has not yet experienced a disaster, or is not in a high-risk area, does not absolve you from the need for contingency planning. Here is what all DBAs should do to be prepared.

Posted March 12, 2014

Oracle announced Oracle Enterprise Manager 12c Release 3 back in November 2013, which features new capabilities for managing Oracle Multitenant, an Oracle Database 12c enterprise edition option. The announcement was supported by a live webcast, titled "Delivering Pluggable Database as a Service." In this article, we provide answers to some of the common questions from the webcast.

Posted March 10, 2014

SAP underscored the company's strategy which focuses squarely on HANA and the cloud in a webcast presented by Jonathan Becher, chief marketing officer of SAP, and Vishal Sikka, member of the Executive Board of SAP AG, Products & Innovation. The company rolled out new and enhanced offerings for the SAP HANA Cloud Platform, the SAP HANA Marketplace, HANA's new pricing, innovations on top of HANA, and also announced that HANA had broken the Guinness World Record for the largest data warehouse ever built - 12.1PB.

Posted March 05, 2014

To take advantage of new Oracle Database capabilities, CSX Corporation, an international transportation company, upgraded more than 400 databases supporting critical commercial, packaged and proprietary business applications, including payroll, dispatching, and a customer-facing order entry system. To minimize the business impact and downtime during the transition, CSX used Oracle Real Application Testing, an Oracle Database option, in conjunction with Oracle Enterprise Manager.

Posted March 05, 2014

Percona, a provider of MySQL support, consulting, remote DBA, training, and software development for MySQL, is hosting its third Percona Live MySQL Conference and Expo from April 1-4 in Santa Clara. The company also recently introduced a new release of Percona XtraDB Cluster 5.6., the latest version of its open source high availability clustering solution for MySQL.

Posted March 04, 2014

Teradata and EMC have collaborated to provide a certified backup and recovery approach for Teradata Database customers. The Teradata and EMC partnership was formed in October 2013 when Teradata certified the Data Domain Operating System 5.4. Teradata has also just certified EMC's latest product - the Data Domain DD720 - bringing greater backup performance improvements to customers.

Posted March 03, 2014

Database Trends and Applications (DBTA) and IBM have launched a Big Data Survey to provide a timely analysis of the key technologies, practices and strategies that businesses across different industries are using to improve confidence in their decision making. Respond with a completed survey by March 2nd, 2014, in order to be included in a drawing to win one of three $200 American Express gift cards to be awarded at the conclusion of the study.

Posted February 26, 2014

The newest version of DataStax's eponymously named enterprise database platform adds a new in-memory option as well as enterprise search enhancements to support high performance. Along with the latest release of its enterprise NoSQL database, DataStax has also introduced version 4.1 of DataStax OpsCenter which supplies improved capacity management capabilities and visual monitoring of production database clusters.

Posted February 26, 2014

In order to be effective, big data analytics must present a clear and consistent picture of what's happening in and around the enterprise. Does a new generation of databases and platforms offer the scalability and velocity required for cloud-based, big data-based applications—or will more traditional relational databases come roaring back for all levels of big data challenges?

Posted February 26, 2014

Extending its partnership with SAP, BackOffice Associates, a provider of information governance and data migration solutions, announced that SAP will resell two of its solutions to help customers accelerate data migration projects and accelerate the governance of human resources (HR) data and other custom data domains.

Posted February 26, 2014

Mission-critical applications in the banking, education, retail, healthcare, oil and gas, government, and travel industries depend on trusted MultiValue database systems. Yet, new requirements are emerging for MultiValue technology vendors to support integration with other enterprise data sources, enable mobile and web access, provide comprehensive business intelligence, and enforce greater security. In this special report, executives of seven leading MultiValue companies discuss how they are responding to their customers' evolving needs.

Posted February 26, 2014

The challenges of funding and executing IT projects that support competitive advantage for the enterprise are explored in a new EMC-sponsored survey of 285 data managers and professionals who are members of the Independent Oracle Users Group. A fundamental process to support big data analytics initiatives is the delivery of reliable information through the integration of networks, data systems and applications. However, many organizations find themselves instead mired in low-level database administration tasks.

Posted February 24, 2014

Splice Machine, provider of a real-time SQL-on-Hadoop database for big data applications, has completed a $15M Series B round of funding, led by InterWest Partners, along with returning Series A investor Mohr Davidow Ventures (MDV). The investment will be used to accelerate product development and expand sales and marketing in preparation for the company's upcoming public beta offering later this quarter.

Posted February 18, 2014

Addressing CFOs' needs for real-time global views of their organizations and the ability to quickly forecast the effects of the dynamic world in which their businesses operate, Oracle has introduced the Real Time Bottom Line, which includes two new applications for PeopleSoft Financials customers. Engineered for Oracle Engineered Systems, the new Oracle In-Memory Applications are designed to help the office of the CFO drive business performance through faster, well-informed decisions based on real-time simulation of business, organizational and regulatory changes.

Posted February 14, 2014

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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162

Sponsors