Data Modeling Articles
Mullins Consulting president and principal consultant Craig S. Mullins recently discussed the challenges that DBAs face in DevOps environments. Understanding the trends occurring now and on the horizon, he says, is critical to being prepared for the rapidly changing data landscape.
Posted December 03, 2019
You've probably heard of ETL, or heard somebody talk about "ee-tee-elling" their data. It's a technology from the days of big iron for extracting data from many relational databases, transforming it to a corporate standard schema, and loading it into another unified relational database. That target database, the enterprise data warehouse (EDW), was intended to be a "single source of truth" for the enterprise. It included all the data that IT deemed fit (and available) for decision makers to use.
Posted December 02, 2019
Let's cut right to the chase. Today, "big data" is just data, and the majority of organizations recognize the importance of being data-driven. But data, of whatever size, is only valuable if it's accessible, trustworthy, and usable.
Posted December 02, 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
Access Innovations' Bob Kasenchak explains how to disambiguate duplicate named entities in data extraction and conversion in this clip from his presentation at Data Summit 2019.
Posted November 19, 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
To highlight organizations that are leading the charge in bringing DevOps to the database world, DBTA is launching its inaugural Database DevOps Innovation Awards program in partnership with Datical, Radiant Advisors, and 451 Research. By sharing your story, your company will have the chance to be among five winners selected by our special committee to be featured in a special, in-depth article published in the February 2020 edition of DBTA magazine and on www.dbta.com.
Posted November 04, 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
The call for speakers is open for the seventh annual Data Summit conference, to be held in Boston, May 19-20, 2020, with pre-conference workshops on May 18. Data Summit focuses on both the business and technical aspects of data management and analysis and how it is transforming the business world.
Posted October 31, 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
Each year, Big Data Quarterly presents the "Big Data 50," a list of forward-thinking companies that are working to expand what's possible in terms of capturing, storing, protecting, and deriving value from data.
Posted September 11, 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
Each year, Database Trends and Applications presents the Readers' Choice Awards, providing a unique opportunity to recognize companies whose products are selected by experts whose opinions carry more weight than any others—you, the readers. Here we present the top three vote-getters in each category. Congratulations to all and thanks to everyone who submitted nominations and voted!
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
Today's database administration solutions help to improve DBA productivity while simplifying repetitive administrative tasks, helping to locate and alleviate performance bottlenecks, and optimizing code.
Posted August 14, 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
The world's largest and most innovative businesses are turning to enterprise open source databases for mission-critical applications, with the most popular open source relational databases being MariaDB, MySQL, and Postgres.
Posted August 12, 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