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

As analytics continues to play a larger role in the enterprise, the need to leverage and protect the data looms larger. According to the IDC, the big data and analytics market will reach $125 billion worldwide in 2015. Here are 10 predictions from industry experts about the data and analytics in 2015.

Posted December 19, 2014

Violin Memory has announced availability of its Oracle Performance Analysis Service (O-PAS). Violin says the tool helps IT professionals remove the complexity of reporting, analyzing and decision-making around Oracle databases to lower the costs of their Oracle deployments while increasing Oracle database and associated application performance.

Posted December 17, 2014

2015 is going to be a big year for big data in the enterprise, according to Oracle. Neil Mendelson, Oracle vice president of big data and advanced analytics, shared Oracle's "Top 7" big data predictions for 2015. "The technology is moving very quickly and it is gaining to the point where a broader set of people can get into it - not just because it is affordable - but because they no longer require specialized skills in order to take advantage of it," he said.

Posted December 17, 2014

The introduction of increased transactional capability into non-relational databases makes sense—in the same way that providing SQL layers on top of Hadoop and many other non-relational stores makes sense. But it does raise the possibility of convergence of relational and non-relational systems. After all, if I take a non-relational database and add SQL and ACID transactions, have I still got a non-relational database, or have I come full circle back to the relational model?

Posted December 17, 2014

Based in the Chicago metropolitan region, Solution Specialties, Inc. has been developing information systems for justice agencies since 1987, and has customers using its Tracker software from coast to coast. Tracker is designed to provide a fully integrated view of the justice process from the point of an initial crime report all the way up to and including corrections and parole and long-term follow-up. This highly evolved software suite rests on Revelation Software's OpenInsight 9.4, a MultiValue-based application development environment.

Posted December 17, 2014

Data is increasingly being recognized as a rich resource flowing through organizations from a continually growing range of sources. But to realize its full potential, this data must be accessed by an array of users to support both real-time decision making and historical analysis, integrated with other information, and still kept safe from hackers and others with malicious intent. Fortunately, leading vendors are developing products and services to help. Here, DBTA presents the list of Trend-Setting Products in Data and Information Management for 2015.

Posted December 17, 2014

Aerospike has introduced new features and enhancements to its open source, flash-optimized, in-memory NoSQL key-value store database. Enhancements include new clients, easier installation and deployment, storage and performance improvements, enterprise security enhancements, Hadoop integration and numerous community contributions.

Posted December 15, 2014

2014 has been described as the year of the data breach. But 2015 will be the year of the regulator, says Suni Munshani, CEO of Protegrity, a provider of data security solutions. According to the Identity Theft Resource Center, there were 708 breaches that took place in the past year, grabbing headlines and sending warnings to retailers to prepare for the 2014 holiday shopping season that is now in full swing.

Posted December 15, 2014

Data has grown at an exponentially faster rate over the past 2 years than all of the previous years combined. "Ninety percent of data that exists today has been created in the past 2 years," said Bill Brunt, product manager of Dell SharePlex, during a recent DBTA webcast. This increase in data has caused companies to look for more efficient ways of moving data within their organizations. Dell SharePlex strives to offer the best overall customer experience when working with their software.

Posted December 15, 2014

Big data continues to have an impact on business, government, and society at large. Here's a look back at 10 noteworthy blog posts from 2014. These blog posts explore the benefits and downsides of advancements in big data technologies.

Posted December 15, 2014

Oracle has announced its latest-generation NAS storage system, the Oracle ZFS Storage ZS4-4. Co-engineered with Oracle Database 12c, the ZFS Storage ZS4-4 provides analytics for pluggable databases, doubles previous generation performance to enable faster time to actionable intelligence, and also provides high-level protection against security breaches with fine-grained encryption capabilities. The OS 8.3 adds over 30 enhancements and three new innovations that expand Oracle's leadership in NAS performance, efficiency, and application-engineered storage, said Oracle executive vice president John Fowler.

Posted December 10, 2014

Town Sports International (TSI) operates fitness clubs in major United States metropolitan areas, including New York, Boston, Washington DC, and Philadelphia. TSI needed a high-availability, high-performance platform to host its updated Oracle E-Business Suite applications, but wanted to avoid the complex and lengthy deployment timelines typically associated with integrating servers, networks, and storage from multiple vendors, as well as the costs and data center space requirements associated with such projects. To meet its goals, TSI deployed an architecture based on two Oracle Database Appliances with the virtualized platform, one for test and one for production, as the platform for its deployment of Oracle Database with Real Application Clusters, Oracle VM and Oracle E-Business Suite.

Posted December 10, 2014

There is still time to submit a speaking proposal for DBTA's Data Summit 2015, which will take place at the New York Hilton Midtown, May 11-13, 2015.

Posted December 08, 2014

Citus Data is releasing an open source extension, "pg_shard," that enables PostgreSQL to scale large datasets and operational workloads. "PostgreSQL continues to grow as one of the most popular databases in the world," said Umur Cubukcu, CEO and co-founder of Citus Data. "With pg_shard, CitusDB is making PostgreSQL horizontally scale in a simple way, while keeping the benefits of a mature, open ecosystem, and taking its relational advantages to the next level."

Posted December 04, 2014

Shunryu Suzuki, in his classic book, Zen Mind, Beginner's Mind, tells us that in the beginner's mind there are many possibilities, but in the expert's mind there are few. Both a beginner's and an expert's perspective have value, but bias toward either an expert or a beginner approach seems to consume an organization far too often.

Posted December 03, 2014

Delayed durability offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging. Why turn off the transaction log? You can accelerate performance in a lot of situations where you do NOT need transactional consistency.

Posted December 03, 2014

Lock contention issues can be frustrating problems to investigate and debug. Before blaming the database system (as is the usual response), there are a few questions to consider that can help identify the cause of the locking problems.

Posted December 03, 2014

With the new tools available that allow companies to monitor database resources, pinpoint the root cause of problems, speed up applications, and prevent crashes, some may wonder if companies will need DBAs at all in the future. However, the risk to DBAs and technology professionals as a whole is not that their jobs are going away, but that they may opt to not take the time to understand and use the tools and technologies that will allow them to be better professionals. This can place them at a disadvantage to their peers and curtail their ability to add value to the organization, therefore limiting their careers.

Posted December 03, 2014

Exploding data assets and the need for greater agility are helping to drive the move to virtualization. More than two-thirds of organizations in a recent Unisphere Research survey among members of the Independent Oracle Users Group indicate that the number of Oracle databases they manage is expanding. At the same time, many managers admit that their IT departments are sluggish when it comes to responding to new business requirements. For more than 50% of organizations, it takes their IT department 30 days or more to respond to new initiatives or deploy new solutions. For one-quarter of organizations, it takes 90 days or more.

Posted December 03, 2014

Kore Technologies' Kourier Integrator has helped improve Rockland Community College's speed and accuracy when it comes to its database performance. Kourier Integrator is Kore's flagship enterprise integration and data management suite with extract, transform, and load (ETL) and enterprise application integration capabilities (EAI).

Posted December 03, 2014

Oracle has introduced its latest-generation NAS storage system, Oracle ZFS Storage ZS4-4. Co-engineered with Oracle Database 12c, Oracle ZFS Storage ZS4-4 enables analytics for pluggable databases.

Posted December 03, 2014

EnterpriseDB, a provider of enterprise-class Postgres products and database compatibility solutions, has released a new Postgres extension to connect MySQL and Postgres databases, giving end users the ability to get more value from their data by combining systems for a single view.

Posted December 03, 2014

DBmaestro, a provider of DevOps for database solutions, has announced the availability of an open application programming interface (API), enabling customers and developers to connect to any release management system and continuous delivery product. According to the vendor, DBmaestro TeamWork will now automate and integrate with IBM, Microsoft, CA and others, allowing any release management manufacturer to offer database build and deploy automation and adding functionality to its product.

Posted December 02, 2014

To help IT and business stakeholders take action to benefit from the emerging technologies and trends in information management, Database Trends and Applications has just published the second annual Big Data Sourcebook, a free resource.

Posted November 25, 2014

Syncsort has announced the latest release of its flagship mainframe software product - Syncsort MFX for z/OS - which exploits IBM's zHPF architecture, the most recent advance in optimizing mainframe I/O for storage devices.

Posted November 24, 2014

KidoZen, a provider of mobility solutions, has added data visualization to its next-generation enterprise mobile app platform. "Every month almost 7 billion mobile devices access more than 1.5 exabytes of data," said Jesus Rodriguez, CEO of KidoZen. "Visualizing that data is not easy today, yet it is critical to enhancing the user experience and delivering on business objectives."

Posted November 24, 2014

As big data continues to explode, companies are exploring how they can leverage it for competitive advantage - to help them prepare for emerging trends within their industries, perform advanced analytics of data to help increase revenue and optimize processes or avoid potential pitfalls. A recent DBTA webcast highlighted the key considerations for selecting analytics tools and explored examples of how analytics are used in different industries. The webcast was presented by Dr. Thomas Hill, executive director for analytics at Dell's Information Management Group; and Marcia A Kaufman, principal analyst and COO, Hurwitz & Associates.

Posted November 21, 2014

SAP has been hard at work delivering significant enhancements to SAP ASE culminating in the release of version 16 earlier this year, and continues to make major investments in new capabilities. A webcast on Tuesday, Dec. 9, 2014, at 11 am ET/ 8 am PT will present an overview of the key features and roadmap for ASE 16.

Posted November 20, 2014

Early bird registration for the ISUG-TECH 2015 conference in Atlanta is now open. The conference will be held March 29 - April 2, 2015, at the Hilton Atlanta in Atlanta, Georgia.

Posted November 20, 2014

Bradmark Technologies, a provider of database management solutions and a reseller of SAP database and solutions, has expanded its North American reseller agreement with SAP. Bradmark has now also become an SAP channel partner authorized to resell SAP database products in the United Kingdom. Under this agreement, Bradmark will offer SAP Adaptive Server Enterprise (SAP ASE), SAP IQ database software, SAP Replication Server, and the SAP HANA platform to its existing customers and prospects through its direct sales force and marketing campaigns in the North America and the UK.

Posted November 20, 2014

Progress is partnering with DataStax, which offers production-certified Apache Cassandra for the enterprise, to provide customers with data connectivity and integration solutions. The companies say the partnership is the result of increased demand from both Progress DataDirect and DataStax customers for a standards-based solution that allows Cassandra to integrate with existing IT processes and systems, including BI, analytics and ETL.

Posted November 20, 2014

Oracle has introduced a new release of its developer tool suite, Solaris Studio, with enhanced analysis tools and support for the latest programming language standards. "Oracle Solaris Studio engineers work closely with the Oracle Solaris and SPARC design teams to ensure the compilers generate the best possible code for Oracle servers," said Don Kretsch, senior director, Software Development, Oracle.

Posted November 19, 2014

Oracle has announced an updated version of Oracle GoldenGate 12c. With GoldenGate 12c, customers can implement real-time data integration and transactional data replication between on-premises and cloud environments and across a broader set of heterogeneous platforms, achieving faster time to value and a greater return from their data assets. "Inherent in the concept of integration is that we can effectively cover both like and unlike platforms, and that we offer our customers the ability to effectively capture and move their data regardless of which systems, platforms, and vendors their data originates from," said Jeff Pollock, vice president of product management at Oracle.

Posted November 19, 2014

Oracle and SAP are ending their legal battle through a settlement in which SAP will pay Oracle $359 million. The SAP-Oracle conflict began early in 2007 when Oracle sued SAP claiming that SAP stole Oracle's trade secrets.

Posted November 19, 2014

Splice Machine today announced the general availability of its Hadoop RDBMS, a platform to build real-time, scalable applications, that incorporates new features that emerged from charter customers using the the beta offering. With the additional new features and the validation from beta customers, Splice Machine 1.0 can support enterprises struggling with their existing databases and seeking to scale-out affordably, said Monte Zweben, co-founder and CEO, Splice Machine.

Posted November 19, 2014

The call for speakers for Data Summit 2015 at the New York Hilton Midtown, May 11-13, 2015, is now officially open. The deadline for submitting proposals is December 5, 2014.

Posted November 19, 2014

The increasing pressure of compliance regulations and security policies makes the deployment of high-level database protection a must-have for any organization. For those looking for ways to advance database security, here are 5 SQL Server best practices to maintain database security and streamline compliance.

Posted November 12, 2014

The holiday season is right around the corner, a time for cheer and goodwill towards men. That got me thinking about the whole "most wonderful time of the year" tune playing in the background and how that has some special implications for the SQL Server world. Here's a bit of context: I'm writing this article for you in the midst of the biggest gathering of SQL Server professions in any given year, the PASS Summit. One of the most visible activities when attendees get together for the very first time at the registration desk or the assembly hall for the first keynote address is the huge number of hugs, backslapping, fist bumps, high fives, and a variety of other happy and genuine reunions.

Posted November 12, 2014

Big data tool vendors try to downplay the notion that data warehouses and data marts still need to exist, even in a big data world. Relational DBMSs are painted as "old-fashioned," "yesterday," and "inadequate." They beckon potential customers to take a dip in the refreshing data lake. The fact that big data, in all of its glory, is only part of a larger business intelligence solution is getting lost in the dialog.

Posted November 12, 2014

Designing an appropriate set of indexes can be one of the more troubling aspects of developing efficient relational database applications. Perhaps, the most important thing you can do to assure optimal application performance when accessing data in a relational/SQL database is to create the correct indexes for your tables based on the queries your applications use. Of course, this is easier said than done. With the caveat that appropriate index creation can be complicated, let's look at the top 10 steps to building the right indexes on your tables.

Posted November 12, 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

Sponsors