Database Management Articles
Not too long ago, large volumes of information were available only to the select few organizations able to afford the expensive IT infrastructure to collect, store, manage, and analyze it—the big-budget companies with seemingly bottomless pockets, or the professional research services that built empires on collecting and interpreting data. But now, through the realized effects of Moore's law, along with the consumerization of BI tools, this data is increasingly available to everyone—and without having to dig deep into budgets or employ robust IT departments.
Posted November 13, 2015
As the business value of big data increases, vendors are offering cloud-hosted big data technology, known as big data as a service (BDaaS). Why choose BDaaS instead of on-premises deployments? Do you lack internal IT expertise in big data? Is the upfront cost for a cluster an issue? Or do you not have the luxury of time to build a cluster? These are all important questions when considering BDaaS.
Posted November 13, 2015
At Oracle OpenWorld each year, there are significant announcements about Oracle products and insight provided on key areas of focus for the future. Melissa English, president of the Oracle Applications Users Group (OAUG), recently reflected on some of the key developments at the 2015 OpenWorld conference and their relevance for OAUG members. In particular, said English, "Oracle's announcements about continuing to support on-premises apps for the next 10 years and beyond are significant."
Posted November 12, 2015
Dell expanded its PowerEdge 13th generation servers with the introduction of four new entry-level servers that provide greater performance, flexibility and efficiency for small and midsize businesses (SMBs). The latest Dell PowerEdge servers are designed to address the top IT pain points of SMBs which Dell says are performance, hardware capacity, and IT complexity. The new Dell PowerEdge servers include the PowerEdge R330 and R230 rack servers and the PowerEdge T330 and T130 tower servers.
Posted November 11, 2015
There are many different ways to look at database administration. It can be done by task, by discipline, by DBMS, by server, and so on. But one useful way to look at database administration is in terms of the type of support being delivered to applications. You can paint a broad brush stroke across the duties of the DBA and divide them into two categories: those that support development work and those that support the production systems.
Posted November 09, 2015
The PASS Summit 2015, the largest conference in the Microsoft SQL Server world, was held in October in Seattle, WA. The event provided a look at key initiatives that Microsoft's SQL Server group has been working on and a glimpse of what's ahead for the future.
Posted November 09, 2015
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 November 09, 2015
Oracle has announced that the new Oracle Exadata Database Machine X5-8, the latest in the X5 family of engineered systems which integrate hardware and software, is now available. The new Exadata X5-8 offers up to 576 CPU cores, more than 1.3 petabytes of disk storage or 180 terabytes of PCIe flash, and up to 24 terabytes of memory. The Oracle Exadata X5-8 is the new companion model to Oracle Exadata X5-2 and incorporates the same storage and networking capabilities of Oracle Exadata X5-2, which was announced in January 2015.
Posted November 04, 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 November 04, 2015
MongoDB is releasing an enhanced version of its platform, giving the company the opportunity to expand its capabilities to more users. "We're opening up MongoDB to a bigger audience in the enterprise, which is to say that traditionally the people that have used MongoDB were developers building modern applications and, with this release, we are building specific tools and capabilities targeted at data scientists, business analysts, and the C suite in terms of integration to business intelligence and visualization tools," said Kelly Stirman, vice president of strategy and product marketing at MongoDB. "We're also expanding MongoDB to DBAs and operations teams with specialized interfaces that make it easier to run MongoDB at any scale."
Posted November 03, 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 28, 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 28, 2015
Oracle has announced new services - Oracle Big Data Preparation Cloud Service, Oracle GoldenGate Cloud Service, Oracle Big Data Discovery Cloud Service and Oracle NoSQL Database Cloud Service - that complement Oracle's Big Data Cloud Service and Big Data SQL Cloud Service, to form a comprehensive portfolio of solutions for big data in the cloud.
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
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
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