Database Management Articles
Incorta, provider of a real-time analytics platform, is partnering with global cloud advisory and implementation services company Alcor to provide advanced analytics solutions to enterprises using ServiceNow and other leading software solutions and platforms.
Posted September 13, 2017
Alteryx, a provider of self-service data analytics, is releasing a new solution called Alteryx Promote as a component of the Alteryx Analytics Platform. The new solution will empowers both data scientists and citizen data scientists to deploy predictive models directly into business systems via an API and then manage model performance over time.
Posted September 12, 2017
New multi-cloud capabilities scale discovery and dependency mapping of all assets to go beyond on-prem data centers to public and private cloud.
Posted September 12, 2017
Redgate Software has released a new version of SQL Toolbelt, a portfolio of database development software, that lets developers and administrators determine immediately if database deployments have caused any adverse effects.
Posted September 11, 2017
data Artisans, founded by the creators of Apache Flink, has introduced dA Platform 2, a new release of its enterprise stream processing platform. Featuring the Application Manager, dA Platform 2 aims to productionize stream processing and enable companies to provide real-time data applications as a centralized enterprise service.
Posted September 11, 2017
Every few years we hear of one new idea or product that will surely bring death to the relational database, or death to the data warehouse, or death to something. It appears that many prefer to see death or at least they greatly enjoy planning for it. Often these finalities never seem to arrive.
Posted September 07, 2017
MongoDB recently announced some interesting, though incremental, enhancements. These included improved "joins" in the aggregation framework, better document validation using JSON schema, and more reliable behavior in the event of network failures. These features attempt to close the gap between the functionality of MongoDB and traditional relational databases - joins, schemas, and commits. On top of these incremental updates, MongoDB announced a couple of features that intrude on functionality usually provided by application servers or desktop programs.
Posted September 07, 2017
DBAs spend a lot of time on tuning application code and SQL statements to boost efficiency and optimize access. But SQL is only one aspect of database systems performance. It is also important for DBAs to devote time to tuning and optimizing the design, parameters, and physical construction of database objects, specifically tables and indexes, and the files in which their data is stored.
Posted September 07, 2017
Rocket Software is updating its UniData MultiValue Database, part of the MultiValue Application Platform, with the addition of Python programming support and audit logging capabilities. These enhancements expand the potential user base for UniData and improve the ability to recruit new development talent, allowing users to easily establish configurable histories of interactions, events, and activities.
Posted September 07, 2017
As organizations increasingly move their data and applications from on-premise deployments to the cloud, the role of the DBA is also shifting. According to Penny Avril, vice president of product management, Oracle Database, the transition means that DBAs have the opportunity to move from being data custodians and keepers to taking on a more strategic role in their organizations. But, she says,the time to prepare for the new cloud reality is now.
Posted September 07, 2017
Dell EMC has announced data protection capabilities designed to help enterprises streamline IT management and data governance for VMware environments. The new release adds support for Oracle and SQL Server databases. According to Dell EMC, application and database owners can now have self-service data protection capabilities for applications and databases from within their native GUI tools while remaining fully compliant with governance, service-level objectives (SLOs), and oversight of the IT data protection regime for Oracle and SQL Server databases. The support for Oracle will be available in Q4 2017.
Posted September 06, 2017
On Sunday at Oracle OpenWorld, several Oracle user groups, including the IOUG, will bring the experiences of our users and experts to San Francisco and share with thousands of our peers. If you're coming to OpenWorld, I can't say enough about how important it is to participate in the Sunday Program.
Posted September 06, 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 September 06, 2017
Dataiku Inc., a maker of Dataiku Data Science Studio (DSS) analytics and collaborative data science tools has announced a $28 million series B funding round led by Battery Ventures and supported by FirstMark, Serena Capital and Alven. The company plans to double its team and accelerate marketing efforts globally while strengthening its platform with new integrations and technologies.
Posted September 06, 2017
NuoDB, which provides a scale-out SQL database for cloud- and container-based environments, has announced a new release which provides customers with flexible hybrid cloud deployment options.
Posted September 01, 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 31, 2017
InfluxData provides an open source platform built for metrics, events, and other time-based data. Recently, Evan Kaplan, CEO of InfluxData, reflected on the future of databases and why time-series represents the next wave of databases for data—from humans, sensors, and machines.
Posted August 30, 2017
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 28, 2017
An education, networking and advocacy forum for users of Oracle Applications, the Oracle Applications Users Group (OAUG) helps members connect to find the solutions they need to do their jobs better and to improve their organizations' ROI in Oracle Applications. Each year during Oracle OpenWorld, the group hosts geographic (Geo) and special interest group (SIG) meetings as well as additional opportunities for networking and education.
Posted August 24, 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 23, 2017
SAP is releasing an S/4 HANA Cloud update that further enhances user experience and improves the platform's machine learning capabilities. Replacing the manual aspects of day-to-day finance with automation is a core focus at SAP S/4HANA Cloud. The latest update takes aim at financial transactions and reporting on currency risks by including treasury management. Treasury deals such as fixed term deposits, FX forwards, and interest rate swaps can be managed with ease.
Posted August 23, 2017
Quest Software, a global systems management and security software provider, is releasing Toad Edge, a new commercial database toolset that can manage next-generation open source database environments. This release will support MySQL, saving time, minimizing the MySQL learning curve, and mitigating risks that can be associated with building applications on an open source database platform.
Posted August 23, 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 18, 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
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
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
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
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