Data Modeling Articles
Application developers typically do not spend a lot of time on optimizing performance. Their focus is on writing code that matches the project specifications and delivers the expected results. So, it makes sense that SQL performance testing should be conducted on all programs before they are migrated to a production environment, or you will likely experience performance problems
Posted January 02, 2020
In 2019 artificial intelligence and machine learning continued its upward trajectory in the market, promising to change the future as we know it. To help support data management processes and decision making, artificial and augmented intelligence is being infused into products and services. Machine learning sits in the center of all AI conversations, as combining machine learning with AI and cognitive technologies can make it even more effective in processing large volumes of information. Both technologies can lead to automation of tasks inside and outside the enterprise-another subject that promises to make waves in the future. Here, executives of leading companies offer 10 predictions for what's ahead in 2020.
Posted December 20, 2019
Ontotext is updating its signature platform with new GraphQL interfaces to make it easier for application developers to access knowledge graphs without tedious development of back-end APIs or complex SPARQL. The underlying Semantic Object service implements an efficient GraphQL to SPARQL translation optimized for GraphDB, as well as a generic configurable security model.
Posted December 17, 2019
Qualitest, a software testing and quality assurance company, has acquired AI and machine learning company AlgoTrace, marking the first step of Qualitest's growth strategy following an investment from Bridgepoint earlier this year.
Posted December 11, 2019
Oracle OpenWorld, which has for many years been held in San Francisco during the month of September or October, is moving to Las Vegas. "Oracle is excited to offer a modern, state-of-the-art experience for attendees at Oracle OpenWorld and Code One 2020 in Las Vegas," an Oracle spokesperson said in a written statement. "The city and its vast amenities are tailor-made for hosting large-scale events, and we look forward to bringing the industry's most comprehensive technology and developer conference to America's premier hospitality destination."
Posted December 11, 2019
Compuware has announced the findings of a global survey of 400 IT leaders, which reveals that manual testing practices, still in widespread use, are one of the biggest challenges large organizations face as they attempt to accelerate digital innovation. The survey examined the processes that organizations have in place to deliver innovation on the mainframe as quickly as in their distributed environments—which are highly reliant on the mainframe.
Posted December 09, 2019
What exactly is a data architecture? As the Zachman Framework exposed long ago, different people look for different kinds of details and documentation to answer fundamental questions about an enterprise's architecture. Someone involved with infrastructure will need to understand the tools used and the methods employed to move data and to be clear on concepts about how security will be enforced. But these aspects are only initial parts of the overall architecture, and as such, a simple diagram of tools used is incomplete and insufficient for a comprehensive view of data architecture.
Posted December 01, 2019
Kinetica's Active Analytics Platform now incorporates NVIDIA RAPIDS, a GPU-acceleration boost for machine learning, to deliver precision business predictions across the entire enterprise. The platform can be deployed on-premise or in the cloud via a broad ecosystem, including strategic partners such as NVIDIA, Dell Technologies, and Oracle Cloud Infrastructure.
Posted November 20, 2019
Alluxio, the developer of open source cloud data orchestration software, is providing a range of cloud offerings and integrations with the latest Alluxio version 2.1, as well as strengthening of partnerships with Amazon AWS and Google Cloud.
Posted November 11, 2019
ASG-PRO/JCL 3.5 increases productivity by enabling developers to run Job Control Language (JCL) scans from their preferred integrated development environments (IDE), enhancing the mainframe DevOps tool chain.
Posted November 11, 2019
Rockset, the serverless search and Analytics Company that enables real-time SQL on NoSQL data, is introducing the capability to build interactive, live Tableau dashboards on NoSQL data, without requiring users to write a single line of code.
Posted November 08, 2019
Grafana Labs, the company behind open source projects including Grafana and Loki, is recieving $24 million in Series A funding, which will be used to further invest in the open source community and accelerate the creation of an open and composable observability platform. The round was led by Lightspeed Venture Partners, with participation from Lead Edge Capital. The company also announced new executive appointments including Douglas Hanna, chief operating officer, Dave Kranowitz, vice president of global sales, and Ryan McKinley, vice president of applications.
Posted November 01, 2019
OpenLegacy, which delivers microservices-based API integration and management for core and legacy systems, is partnering with Compuware, which provides modern and agile mainframe software tools for DevOps, to accelerate mainframe integration with modern apps using APIs and microservices. Now that the OpenLegacy platform can be accessed directly from Topaz Workbench, such integration provides both mainframe and non-mainframe developers with a common framework to create APIs and visualize, understand, debug, and maintain their cross-platform applications.
Posted October 28, 2019
IBM has announced updates to IBM Developer for z/OS, including new automated unit testing capabilities for mainframe developers. For mainframe developers, IBM says, automating testing is an essential component for true agile development.
Posted October 28, 2019
SIOS Technology, a provider of IT resilience through intelligent application availability, and its platforms SIOS LifeKeeper 9.4 and SIOS DataKeeper 9.4, sold as SIOS Protection Suite for Linux, have achieved SAP certification (S/4-HA-CLU 1.0) for SAP S/4HANA. This certification recognizes that SIOS provides proven technology and deep expertise in delivering High Availability (HA) and Disaster Recovery (DR) for SAP in physical, virtual, and cloud environments.
Posted October 23, 2019
The cloud, ethics in artificial intelligence, privacy, and compliance were some of the topics that attendees were concerned about at Strata Data NY as data professionals converged at the Jacob Javits Center in New York City from September 24 - 26.
Posted October 15, 2019
Compuware has announced enhancements to Topaz for Total Test, which provides unit, functional, integration, and regression testing, enabling application leaders to adopt a "shift left" approach to testing to improve application quality and development velocity and efficiency. Compuware is also announcing a partnership with OpenLegacy.
Posted October 14, 2019
Syncsort, the provider o of big iron to big data software, is making enhancements to Ironstream for ServiceNow that enable IT to integrate mainframe and IBM i environments into ServiceNow Event Management. The new capabilities build upon Ironstream support for ServiceNow Discovery to help increase IT productivity, proactively eliminate service outages, and quickly resolve critical issues across the enterprise, delivering even greater value for customers with the cloud-based Now Platform.
Posted October 14, 2019
DataStax, the company behind a database built on Apache Cassandra, is opening early access to the DataStax Change Data Capture (CDC) Connector for Apache Kafka. The DataStax CDC Connector for Apache Kafka gives developers bidirectional data movement between DataStax, Cassandra, and Kafka clusters. CDC is designed to capture and forward insert, update, and delete activity applied to tables (column families).
Posted October 10, 2019
Certain kinds of issues in data modeling need to be addressed in specific ways. Many options may exist, but it is very rare for all the possible choices to be equally appropriate. The reasons for using a less-than-satisfactory path may be many. They may include a misguided concern for speed-to-completion or be a matter of the areas of control for those "in the loop" on the existence of the issue. Largely, this involves communication or, more precisely, the lack of communication.
Posted October 01, 2019
Back in the 1980s, a Stanford University computer scientist and professor named Donald Knuth introduced the concept of "literate programming," in which a computer program's logic is explained in a natural language such as English. The "literate" program would be further enriched with images, graphs, traditional source code, related macros, and scripts almost as if the programmer were writing an essay, and using all of these components together could still be compiled as usual. The most notable products to arise from this concept were notebooks, such as Azure Notebooks, Jupyter Notebooks, Apache Zeppelin, and the Apache Spark Notebook.
Posted October 01, 2019
TigerGraph, a provider of a scalable graph database for the enterprise, along with receiving $32 million in Series B funding, is releasing TigerGraph Cloud. The investment, led by SIG, will boost TigerGraph's global expansion, fueled by TigerGraph Cloud and its appeal to companies seeking a fast, easy way to harness the power of the graph.
Posted September 26, 2019
Pyramid Analytics, provider of the next-generation business analytics platform for the enterprise, is updating its signature platform, placing focus on ease of use and pairing the advanced analytics tool with a simplified user interface (UI). With over 150 new enterprise-grade features and capabilities, Pyramid v2020 represents a milestone in the company's roadmap and brings the organization closer to its goal of creating the self-optimizing decision platform.
Posted September 25, 2019
SAP has deployed Totango, a provider of customer success solutions for the enterprise, across the majority of its lines of business. The solution will be used as a single, integrated customer success platform to help SAP evolve, deploy, and expand its execution of customer success initiatives.
Posted September 25, 2019
Woolpert is launching STREAM:RASTER, a subscription software service that hosts and facilitates access to geospatial imagery in the cloud. Customers can upload raster data to STREAM:RASTER and it creates tile caches of the data that is ready for use in GIS and web mapping software. Customers are then able to manage and control access to their proprietary imagery in STREAM:RASTER, with support and a service level agreement from Woolpert.
Posted September 20, 2019
Yugabyte, a provider of open source distributed SQL databases, is releasing Yugabyte DB 2.0, allowing organizations looking to transition away from monolithic RDBMS to have access to the most compelling distributed SQL databases on the market. Yugabyte DB 2.0 also includes best-in-class PostgreSQL compatibility, Jepsen testing for correctness, and Blitzz-based Oracle-to-Yugabyte live migration utilities.
Posted September 17, 2019
Redgate is releasing SQL Monitor 9.1, with new features including an expanded API to help fine-tune alerting through Microsoft PowerShell and a unique permissions function. These updates support tightened security and compliance by providing a drill-down view of who has access to monitored databases and servers, and their permissions level.
Posted September 05, 2019
A critical aspect of migrating on-premise appliances to the cloud is converting existing schemas to take advantage of cloud innovation which can quickly become expensive even in proof of values. With this joint offering from Azure and Informatica, customers receive free code conversion for both the proof of value phase and when fully migrating to the cloud, as well as a SQL Data Warehouse subscription for the duration of the proof of value (up to 30 days)
Posted August 29, 2019
SAP is expanding its joint co-innovation project with insurance giant Swiss Re, which now provides software that goes beyond accounting to include simulation, forecasting and planning capabilities essential to support the business in financial analysis.
Posted August 28, 2019
Red Hat, which was recently acquired by IBM, has announced the general availability of Red Hat Enterprise Linux 7.7, the final Full Support Phase release of the Red Hat Enterprise Linux 7 platform. As hybrid and multicloud computing helps to transform enterprise IT, Red Hat Enterprise Linux 7.7 delivers enhanced consistency and control across cloud infrastructure for IT operations teams while also providing a suite of modern, supported container creation tools for enterprise application developers.
Posted August 19, 2019
Franz Inc., an early adopter of Artificial Intelligence (AI) and provider of Semantic Graph Database technology for Knowledge Graph Solutions, is now supporting Shapes Constraint Language (SHACL), a World Wide Web Consortium (W3C) specification for validating graph-based data against a set of conditions.
Posted August 15, 2019
Alegion, the Gold Standard Data Labeling Platform for enterprise data science teams, has completed a $12 million Series A-2 round of funding, allowing the company to accelerate the integration of Active Learning and other strategic technologies into its Machine Learning Data Labeling Platform. This funding round was led by RHS Investments.
Posted August 15, 2019
Social media, the Internet of Things, demands for mobile access, and real-time insights are just some of the factors that have increased the pressure on organizations to change how data is managed. And as a result there have never been so many data management choices to deal with it all.
Posted August 14, 2019
SnapLogic is releasing the August 2019 version of the SnapLogic Intelligent Integration Platform, delivering several new innovations that drive better productivity, deeper insights, and higher performance for customers. With this release, SnapLogic makes enterprise integration even faster and easier with new AI capabilities that recommend completed pipelines - from within the user's organization or from the SnapLogic Patterns Catalog - improving productivity and time-to-value for both citizen and expert integrators alike.
Posted August 14, 2019
Redgate Software is signing Grupo Babel to its Partner roster to help customers in the region adopt its database DevOps solutions. Based in Costa Rica, Grupo Babel joins a worldwide network of Redgate Partners, all of whom are chosen for their expertise and skills in helping customers get more value out of their IT infrastructure.
Posted August 08, 2019
Instana's automatic Jenkins monitoring capabilities include performance visibility of individual builds and deployments, as well as health monitoring of the Jenkins tool stack itself— including the hosts and JVMs running Jenkins. This gives Agile D\development and DevOps teams the data they need to understand exactly where they can optimize their application delivery process.
Posted August 08, 2019
An effective approach to processing and transforming large datasets is likely comprised of multiple steps. The large data will likely be split apart into several smaller sets, maybe even in a couple of differing fashions with a common and understandable theme. But there should not be too many split-apart variants; rather, as with the three bears, it should be just the right number of smaller datasets. And then, similar to solving a Rubik's Cube, a twist or two at the very end brings all the new and old datapoints together in a complete and organized fashion.
Posted August 07, 2019
Percona, a provider of open source database software and services, is releasing the Percona Cloud Native Autonomous Database Initiative, a series of products that expand support for cloud-native applications and makes it easier for organizations to manage their hybrid multi-cloud environments.
Posted August 07, 2019
Cockroach Labs, provider of the distributed SQL database CockroachDB, is receiving $55 million in series C funding, enabling the company to further grow CockroachDB. The round is led by Altimeter Capital, Tiger Global, and existing investor GV, with participation from existing investors Benchmark, Index Ventures, Redpoint Ventures, FirstMark Capital, and Work-Bench, and brings Cockroach Labs' total funding to $108.5 million.
Posted August 06, 2019
Dgraph Labs, the cloud-native graph database company, is closing a $11.5 million Series A funding round that will enable the company to expand enterprise features and its user base, support next-generation GraphQL applications and build Dgraph-as-a-Service.
Posted July 31, 2019
BMC has announced the BMC AMI DevOps for Db2 solution, which is designed to accelerate the delivery of new and updated applications to the market. The solution integrates with the Jenkins Pipeline suite of plug-ins to provide an automated way of receiving, evaluating, and implementing Db2 schema changes as part of an application update.
Posted July 30, 2019
While change has always been a part of the database credo, the growing emphasis on data-driven decision making in today's economy has resulted in a dizzying plethora of technologies and methodologies entering the market. The number and scope of game-changing technologies are too numerous to mention, and one thing is certain: Database management will never be the same. We have identified some of the most promising technology initiatives, based on discussions with and input from data experts from across the industry spectrum, gathering their views on the key technologies—well-known or under the radar—that are worth watching.
Posted July 25, 2019
SAP is further deepening its commitment to the developer and open source community with the contribution of UI5 Web Components, a comprehensive library for Web developers. This library enables them to create enterprise-grade Web applications more easily.
Posted July 24, 2019