Database Management Articles
Docker has announced the latest release of Docker Enterprise Edition (EE), a container as a service (CaaS) platform for managing and securing Windows, Linux, and mainframe applications across both on premises and cloud infrastructure.
Posted August 16, 2017
IDERA, a provider of database lifecycle management solutions, has released ER/Studio 17, incorporating significant updates to its Business Architect process modeling tool. The new capabilities are aimed at helping business analysts to map and model relationships between people, processes, and data as the foundation for enterprise architecture and data governance initiatives.
Posted August 16, 2017
Microsoft has acquired cloud computing orchestration company Cycle Computing to make it easier for customers to use high-performance computing (HPC) and other computing capabilities in the cloud. The purchase was announced in a blog post by Jason Zander, corporate VP, Microsoft Azure.
Posted August 15, 2017
Kyvos Insights, a big data analytics company, is releasing Kyvos 4.0, providing users with new capabilities for creating data cubes with near limitless scalability and performance. Kyvos 4.0 delivers new levels of scalability, performance, and support for concurrent users, enabling organizations to provide self-service, interactive business intelligence (BI) on big data for all of their users across the enterprise.
Posted August 15, 2017
At the SHARE summer 2017 event in Providence, RI, Harry Williams, SHARE's president, reflected on the changes taking place in the enterprise technology ecosystem, and what's ahead for the IBM users group and the industry overall.
Posted August 14, 2017
You may think your company is behind the curve because you are not 100% in the cloud. Very few companies are there, and most won't make it all the way to 100% due to security, performance, or other strategic reasons. Most, however, are at least getting some workloads into the cloud for price, scalability, and competitive advantage. If you are just starting your journey, here are a few things to consider.
Posted August 09, 2017
Referential integrity (RI) is a method for ensuring the "correctness" of data within a DBMS. People tend to oversimplify RI, stating that it is merely the identification of relationships between relational tables. It is actually much more than this. RI embodies the integrity and usability of a relationship by establishing rules that govern that relationship.
Posted August 09, 2017
The emergence of cryptocurrencies and blockchain technology may prove to be almost as significant an innovation as the internet itself. Blockchain offers a mechanism for the mediation of any transactions that previously would have required trusted third parties, while cryptocurrencies such as Bitcoin may eventually become a significant alternative to traditional "fiat" (e.g., government-backed) currencies. These technologies could eventually revolutionize the global banking infrastructure which has underpinned global commerce for centuries.
Posted August 09, 2017
Poorly written SQL statements can cause significant performance problems in your database environment. According to some experts, poorly written SQL can cause up to 70% of performance problems overall. Adding resources can mask many issues surrounding poorly written SQL, but comes with a cost. Is writing good, quality SQL (including block code—stored procedures, packages, functions, etc.) a dying art? And if it's so important, why is that?
Posted August 09, 2017
Hackers are rarely far from the news these days, whether they're perpetrating cyber-intrusions into political campaigns or take-downs of major retail websites, social media sites, movie studios, or entertainment conglomerates. But some of the "hacking" headlines can be deceiving. In fact, a significant number of cybersecurity breaches around the digital world actually represent a kind of all-too-familiar crime that is as old as the abacus.
Posted August 09, 2017
Redgate Software, a Cambridge, UK-based database tools provider, has launched a new one-stop resource to help software professionals find the information and advice they need faster and easier.
Posted August 09, 2017
BackOffice Associates, a provider of information governance, data stewardship, and data migration solutions, has announced that Bridge Growth Partners, a private equity firm, has signed an agreement to make a majority equity investment in the company.
Posted August 03, 2017
Accenture has acquired Search Technologies, a Herndon, Virginia-based technology services firm specializing in the design, implementation and management of big data and search analytics. Terms of the transaction were not disclosed. Kamran Khan, president and CEO of Search Technologies, will lead a new Content Analytics team within Accenture Analytics.
Posted August 03, 2017
Creative Media Works, operating as BBM Messenger has selected Pythian to help them migrate to the Google Cloud Platform. Pythian, a global IT services company that helps businesses adopt technologies to better compete, will help BBM Messenger move its mission-critical IT infrastructure for Android, iOS and Windows consumer BBM from BlackBerry on-prem data centers in Canada to Google Cloud Platform (GCP) in Asia.
Posted August 03, 2017
IDERA, a provider of database, development, and test management tools, announced it is acquiring AquaFold, a provider of cross-platform database tools. AquaFold will join IDERA's database development and management portfolio, enabling the company to expand its multi-platform support.
Posted August 02, 2017
Streaming data solutions can evaluate data quickly and enable predictive analytics based on sources of rapidly changing data—including social media, sensors, and financial services data, to head off future problems, machine failures, natural disasters, and take advantage of unfolding opportunities.
Posted August 02, 2017
Change data capture (CDC) is a function within database management software that makes sure data is uniform throughout a database. CDC identifies and tracks changes to source data anywhere in the database, and then applies those changes to target data in the rest of the database.
Posted August 02, 2017
In today's always-on economy, database downtime can inflict a mortal wound on the life of a business. That's why having a trusted backup solution that can ensure that databases can be back up and running quickly in the event of an outage is critical. Today, close to one-fourth of organizations have SLAs of four nines of availability or greater, meaning they require less than 52 minutes of downtime per year, according to a recent Unisphere Research survey.
Posted August 02, 2017
If data is the new oil, then getting that resource pumped out to more users faster with fewer bottlenecks is a capability that must be achieved. The issue of under-performing database systems cannot be seen as simply an IT problem. Remaining up and running, always available and functioning with lightning speed today is a business necessity.
Posted August 02, 2017
Geographically spread-out development teams with varied skill levels and different areas of proficiency, ever-faster software development cycles, multiple database platforms—all this translates to a challenging development environment that database development solutions providers seek to streamline.
Posted August 02, 2017
As data stores grow larger and more diverse, and greater focus is placed on competing on analytics, processing data faster is becoming a critical requirement. In-memory technology has become a relied-upon part of the data world, now available through most major database vendors. In-memory can process workloads up to 100 times faster than disk-to-memory configurations, which enables business at the speed of thought.
Posted August 02, 2017
Addressing the need to store and manage increasingly large amounts of data that does not fit neatly in rows and columns, NoSQL databases can run on commodity hardware, support the unstructured, non-relational data flowing into organizations from the proliferation of new sources, and are available in a variety of structures that open up new types of data sources, providing ways to tap into the institutional knowledge locked in PCs and departmental silos.
Posted August 02, 2017
The rise of new data types is leading to new ways of thinking about data, and newer data storage and management technologies, such as Hadoop, Spark, and NoSQL, are disruptive forces that may eventually result in what has been described as a post-structured world. But while Hadoop and NoSQL are undoubtedly growing in use, and a wider array of database management technologies in general is being adopted, the reality is that at least for now the relational database management system is still reigns supreme and is responsible for storing the great majority of enterprise data.
Posted August 02, 2017
Coined over a decade ago, the term "polyglot persistence" has come to be seen as a shorthand phrase in the database world for using the best tool for the job, or in other words, the right database for the data storage need at hand. Today, that might mean NoSQL, NewSQL, in-memory databases, and cloud databases—also known as database as a service—approaches.
Posted August 02, 2017
Oracle is adding hundreds of new capabilities to Oracle Cloud Applications with Release 13. Key enhancements are aimed at enhancing the user experience and supporting business users across the organization through greater personalization, productivity, insight, and collaboration. Supply chain is a key focus of the release.
Posted August 02, 2017
Workiva, a provider of solutions for enterprise productivity and Gold-level member of Oracle PartnerNetwork, has announced data integration between its Wdesk platform and more than 100 cloud, SaaS and on-premise applications, including Oracle Enterprise Resource Planning (ERP) Cloud.
Posted August 02, 2017
TIBCO Software, a provider of integration, API management, and analytics, is acquiring nanoscale.io, a provider of microservices technology and tooling. The acquisition extends and enhances TIBCO's leadership in the development of microservices and APIs that connect and integrate with a more expansive on-premises or hybrid cloud environment, and bolster its Connected Intelligence platform.
Posted July 27, 2017
It's been long acknowledged that data is the most precious commodity of the 21st-century business, and that all efforts and resources need to be dedicated to the acquisition and care of this resource. Lately, however, executives have become enamored with the vision of transforming their organizations into "data-driven" enterprises, which move forward into the future on data-supported insights. So, what, exactly, does the ideal "data-driven enterprise" look like?
Posted July 27, 2017
EnterpriseDB has released EDB Postgres Enterprise Manager 7. Part of the EDB Postgres Platform, EDB Postgres Enterprise Manager 7 provides a new web client and tools to give DBAs greater ability to improve database performance across large installations.
Posted July 27, 2017
InfluxData has announced general availability of the InfluxData platform, version 1.3 of its open source platform built from the ground up for metrics and events.
Posted July 24, 2017
Southbank Software has launched its first product, dbKoda, an open source database development and administration platform, initially available for MongoDB. MongoDB was targeted first because of its rapid growth and popularity among full stack developers, according to Guy Harrison, Southbank's founder.
Posted July 24, 2017
Datavail, a provider of managed services for applications, business intelligence, and databases, is acquiring Accelatis, an enterprise performance management software platform company.
Posted July 19, 2017
The data manager now sits in the center of a revolution swirling about enterprises. In today's up-and-down global economy, opportunities and threats are coming in from a number of directions. Business leaders recognize that the key to success in hyper-competitive markets is the ability to leverage data to draw insights that predict and provide prescriptive action to stay ahead of markets and customer preferences. For that, they need to keep up with the latest solutions and approaches in data management. Here are 12 of the key technologies turning heads—or potentially opening enterprise wallets—in today's data centers.
Posted July 19, 2017
Microsoft's SQL Server platform has been on a roll lately, with its smooth and feature-rich SQL 2016 release gaining accolades across the industry, including the DBMS of the Year award from db-engines.com. The company's increased focus on cloud, strong BI tool set, impressive functionality and emerging cross-platform capability with SQL on Linux has made this RDBMS a staple of database shops around the world.
Posted July 14, 2017
OpenText, a provider of enterprise information management (EIM) solutions, is unveiling a new artificial intelligence (AI) platform that combines open source machine learning with advanced analytics. The platform, named Magellan will acquire, merge, manage and analyze big data and big content. Magellan's cognitive computing platform offers users machine-assisted decision making, automation, and business optimization, in an easy to use and affordable package.
Posted July 12, 2017
Often, when working with technical people, they get excited over the latest and greatest piece of software or hardware. They try and get their management excited, but it seems as if their management just doesn't "get" how good it is.
Posted July 05, 2017
MicroStrategy, a provider of enterprise analytics and mobility software, is releasing MicroStrategy 10.8, updating critical capabilities across enterprise analytics, enterprise mobility, embedded analytics, enterprise cloud, and enterprise IoT.
Posted July 05, 2017
The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new features. One set of features that I really like focus on adaptive query processing. These new features speed processing of workloads, especially those that have historically been the hardest to tune.
Posted July 05, 2017
For everyone normalizing their designs, just remember: There ain't no such thing as a partial foreign key. When a project pretends that partial foreign keys are a valid concept, the end result is a database model that either lies to viewers, or does not give them the necessary information to readily join tables together.
Posted July 05, 2017
MongoDB has become a favorite among developers in no small part because of its alignment with modern software development practices. Its flexible schemas are compatible with agile software development and the JSON-based document structure is well-matched with modern JavaScript-centric web architectures. However, databases don't exist solely for the convenience of software developers: Data in a database is a critical business asset.
Posted July 05, 2017
There's a wide and growing acceptance that containers are replacing operating systems as the deployment target for application components. While application modules were previously designed to be installed upon a specific version of an operating system on a particular hardware platform, they are now increasingly being designed to run within a virtualized representation of an operating system—most frequently within a Docker container.
Posted June 29, 2017
IBM is boosting its data governance and data science initiatives to help developers and analysts tap into the power of cognitive computing to gain greater understanding and control of their data, while improving their ability to comply with data regulations such as the European Union's upcoming General Data Protection Regulation (GDPR).
Posted June 22, 2017
New England Water Heater is a plumbing services company specializing in water heater repair and installation based in North Waltham, MA. The company provides a centralized service through a network of geographically dispersed plumbing companies in the surrounding region, including its own company, Home Services of New England (HSNE) Plumbing. As a longtime Revelation Software customer, NEWH uses a system on Revelation's OpenInsight 9.4 for business processes such as document management, phone calls, and customer support.
Posted June 21, 2017
Oracle has expanded the Oracle Cloud Platform's integration offerings with the availability of the Oracle API Platform Cloud Service.
Posted June 21, 2017
SAP and Accenture are expanding their collaboration to co-innovate, co-develop, and jointly go to market with digital solutions based on the new SAP Leonardo digital innovation system. The long-standing strategic partners will focus on embedding digital technologies including additional machine learning, analytics, and the Internet of Things (IoT) at the core of clients' businesses to deliver even greater value from their SAP investments.
Posted June 21, 2017
GridGain Systems, provider of enterprise-grade in-memory computing platform solutions based on Apache Ignite, has introduced GridGain 8.1. The new release provides a new memory-centric architecture that leverages advancements in memory and storage technologies.
Posted June 20, 2017