Database Management Articles
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
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 07, 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 07, 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 07, 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
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 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
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 06, 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
Oracle has expanded its flash storage portfolio with the announcement of an all-flash model of its Oracle FS1 Flash Storage System. Designed to handle concurrent mixed workloads, such as OLTP and high-speed data backup, in enterprise SAN environments as well as in private or public clouds, the system delivers up to 64 all-flash domains, and enables secure data isolation in multitenant cloud environments.
Posted September 02, 2015
With the release of Oracle Cloud Platform 2015 and new Oracle Cloud Platform Services, things are clouding up across the Oracle landscape—but in a positive way. Larry Ellison, chairman and chief technology officer for Oracle, has made it clear in pronouncements that Oracle is in the cloud to stay.
Posted September 02, 2015
Whatever the reason, database administrators (DBAs) frequently sit in a corner alone, siloed from the rest of IT, with their potential for impact ignored. Organizations in which this happens—which is most companies—are typically characterized by an attitude that the role of the DBA is to simply keep things running. The order from the top is "Just make sure the database doesn't break anything, OK?" This is a missed opportunity and a waste of a very valuable resource that hampers IT organizations everywhere.
Posted September 02, 2015
Magnitude Software, a provider of enterprise information management solutions, is introducing new additions to its technology suite designed to assist users in making informed business decisions faster and easier. The release of its Kalido Information Engine 9.1 SP2 makes a variety of advancements in data warehouse automation capabilities including increasing automation that accelerates the migration process and reduces overhead tasks when moving from development to production.
Posted September 01, 2015
Unless you've been living under a rock, you've heard Microsoft has introduced the initial release of Windows 10. Windows 10 has been a widely anticipated release on the part of consumers and business alike, with Microsoft aiming to deploy Windows 10 on more than one billion devices within the next few years. Here are 10 technical and market reasons why Windows 10 will become Microsoft's biggest release ever.
Posted August 26, 2015
Hundreds of enterprise IT professionals converged in Orlando, August 9th-14th, for the annual SHARE summer conference, which featured more than 500 educational sessions. "Mainframe data is growing tremendously and companies want to utilize it," said James Vincent, president of SHARE. "They are investing in data analytics," he added. "But data security and privacy are really growing in importance."
Posted August 25, 2015
The Independent Oracle Users Group is headed to San Francisco this October to join the Oracle technology community at Oracle OpenWorld 2015. Representing the voice of Oracle technology professionals, IOUG members will present more than 35 sessions on critical Oracle technology topics, including big data, cloud, Oracle Enterprise Manager 12c, and more. There is a lot to discuss with the Oracle database and technology community, and I am looking forward to connecting with Oracle professionals with similar interests to address challenges and solutions face-to-face.
Posted August 19, 2015
Innovative Routines International (IRI) has released an enterprise-class, data-centric protection solution for corporations storing personally identifying information (PII) in Excel 2010 and 2013 spreadsheets. The IRI CellShield Enterprise Edition provides a full-featured, professional compliance package for Excel workbooks that can locate and automatically protect sensitive data across a network.
Posted August 18, 2015
Syncsort, a mainframe software provider, announced new software innovations designed to further take advantage of IBM z Systems zIIP processors to improve performance, reduce MIPS usage and lower costs.
Posted August 17, 2015
Melissa Data has introduced data quality integration for Microsoft Dynamics CRM to simplify global address verification for enterprise users. Available as a pre-integrated package with Microsoft Dynamics CRM, the Melissa Data plugin enables global address verification capabilities without complex programming or development resources.
Posted August 11, 2015