Data Modeling Articles
In dimensional modeling, business events are typically designated as facts while descriptive information elements are dimensions. However, events (or information about them) occasionally serve as dimensions as well as facts. A good data architect must watch their p's and q's and be certain when it is appropriate for a fact to also serve as a dimension—or when the dual function is not appropriate.
Posted February 08, 2019
Platform9, a provider of a SaaS-managed hybrid cloud, is introducing a managed Kubernetes service on VMware vSphere with Platform9 Managed Kubernetes. Platform9 Managed Kubernetes (PMK) allows enterprises to be up and running in less than an hour with Kubernetes on VMware that is both simple to use and production-ready.
Posted February 04, 2019
How do you prepare for the unexpected with your Oracle environments? Or ensure that you can meet SLAs for restoring critical data in your production Oracle databases?
Posted January 31, 2019
Alfresco, an open source provider of process automation, content management, and information governance software, is releasing an updated version of its Application Development Framework. ADF 3.0 extends Alfresco's content market leadership with significant performance enhancements designed to increase user satisfaction and adoption, serve up deeper insights securely, and connect content, processes and people more rapidly.
Posted January 31, 2019
Express Scripts provides pharmacy and medical benefits management, specialty pharmacy care, and everything in between. The company seeks to uncover opportunities to make healthcare better and they rely on the uptime and availability of data to be a market leader. This is where Quest comes in. In a recent DBTA webinar, Mertz and Jason Hall, Jason Hall senior technical sales engineer, Quest Software, explained how Quest helped Express Scripts manage its database and prepare for the future.
Posted January 25, 2019
A.M. Turing Award Laureate and database technology pioneer Michael Stonebraker will deliver the opening keynote at Data Summit 2019. The sixth annual Data Summit conference will be held in Boston, May 21-22, 2019, with pre-conference workshops on May 20. Registration is now open.
Posted January 23, 2019
It is essential to have access to detailed, real-time information on the performance of database servers and databases. Database performance problems affect the business-critical applications that they support. These issues were considered during a recent webinar featuring Patrick O'Halloran, senior sales engineer, IDERA, who discussed the use of SQL Diagnostic Manager for MySQL to ensure application responsiveness and database security.
Posted January 22, 2019
From self-service data preparation and real-time data streaming, to the Internet of Things and Artificial Intelligence, the world of big data and analytics continues to evolve. DBTA recently held a roundtable webinar with Clive Bearman, director of product marketing, Attunity; Greg Davoll, VP of product marketing, Alteryx; and Clarke Patterson, head of product marketing, StreamSets, who discussed upcoming challenges and opportunities in 2019.
Posted January 14, 2019
Databases offer a lot of metrics. How does the enterprise go about wading through it all to uncover the insights businesses and customers are looking for? DBTA recently held a webinar with Katy Farmer, developer advocate, InfluxData, who discussed which metrics can offer insight into the database and why they matter.
Posted January 11, 2019
OneLogin, a provider of Unified Access Management, is closing $100 million in growth financing which will be used to accelerate the growth of new products and innovations.
Posted January 10, 2019
As the tech world continues to change, so too is the evolution of data warehousing. Enterprises today need flexibility, agility and scalability. The goal of modern data warehousing is to not only deliver insights faster to more users, but provide a richer picture of your operations afforded by a greater volume and variety of data for analysis.
Posted January 02, 2019
More harm than good has been done to software development by letting the planning dates drive the work instead of having the work drive the dates. This planning-date-driven approach causes more stress, more bad decisions, more rework, more failed projects than all other causes combined.
Posted January 02, 2019
Big data continues to be top of mind while new technologies are also emerging to reel in and uncover important insights. In 2018, a variety of solutions came to the fore and 2019 is setting the stage for another data explosion. Here, several experts in the big data space offer their predictions for what's ahead in 2019.
Posted January 02, 2019
MongoDB recently released the beta offering of its native data visualization tool, MongoDB Charts, on its cloud database-as-a-service, MongoDB Atlas, which runs on runs on Amazon Web Services, Microsoft Azure and Google Cloud Platform. According to the vendor, the new feature allows users to quickly create data visualizations and share them with their teams with no code to write, no tools to configure and no data movement or duplication.
Posted December 19, 2018
ArangoDB, an open source native multi-model database, is releasing ArangoDB 3.4, enabling developers to efficiently interact with multiple data models by using just one technology and one query language. Major new enhancements in ArangoDB 3.4 include ArangoSearch, a feature which transforms ArangoDB, when combined with traversals or joins in AQL, from a data retrieval to an information retrieval solution; and full GeoJSON Support enabled by a Google S2 Geo Index library integration.
Posted December 06, 2018
Looker closed a Series E financing round of $103 million that will continue to help boost the company and upcoming innovations. This latest funding round is being led by Premji Invest, with new investment from Cross Creek Advisors and participation from Looker's current investors. Looker has raised a total of $280.5 million since 2013.
Posted December 06, 2018
Data mart builders must understand what they are working to accomplish. The DBMS is not going to magically guide them to a solution. The builder is responsible for knowing how dimensional techniques work, why they work, and what options may exist within the dimensional framework.
Posted December 04, 2018
GraphQL has emerged as the favorite alternative to REST for modern web API design. GraphQL was first used internally at Facebook before being open sourced in 2015. GraphQL is described as a data query and manipulation language which at first glance might suggest more in common with SQL than with REST. However, in reality both GraphQL and REST are applicable across a very similar range of web API scenarios.
Posted December 04, 2018
The call for speakers is officially open for the sixth annual Data Summit conference, to be held in Boston, May 21-22, 2019. Whether you are an IT practitioner or a business stakeholder, we encourage you to consider participating in this exciting conference. The deadline for submitting proposals is December 21, 2018.
Posted December 04, 2018
Datical, a provider of database release automation solutions, is introducing a new feature that will allow Liquibase users access to Datical's platform for automating database releases. The millions of software professionals that use the Liquibase open source project can upgrade to an solution offering efficiency, speed, and risk reductions for all database deployments without having to change their existing process or workflow, according to Datical.
Posted November 28, 2018
Oracle DBAs and managers are under pressure to deliver high-performing and responsive systems that can scale with the business. Many enterprises are turning to cloud solutions and automation to reduce costs and increase their agility and capacity. The use of public cloud services among Oracle database sites is increasing, particularly in the area of backup and recovery. At the same time, most transaction environments still remain on-premises today.
Posted November 28, 2018
Snowflake Computing, a data warehouse built for the cloud, is introducing two new performance features - automatic clustering and materialized views - that will optimize query performance, eliminating the manual work associated with other data warehouse solutions. When combined, these features can deliver an exponential increase in performance, generating even faster and deeper insights from all of an organization's data by all of its business users.
Posted November 14, 2018
Quest Software is launching the new Spotlight Cloud, offering users features such as 24/7 performance monitoring, instant diagnostics, and powerful tuning to ensure consistent performance and high availability across Microsoft SQL Server database environments.
Posted November 01, 2018
While relational database management systems are still the workaday workhorse, we are now adding into the mix document, columnar, and graph datastores, and their variants. Each datastore has something at which it excels, and other things it may not. Similarly, the rules followed in composing data structures, based on the platforms selected, also vary greatly.
Posted November 01, 2018
Data is everywhere and it's no small feat creating the right app for data storage. Building a mobile app with local data storage capabilities can be a daunting task —but it doesn't have to be. DBTA recently held a webcast with Priya Rajagopal, principal product manager, Couchbase, who examined the main challenges of an offline or offline-first storage solution and discuss how users can overcome the toughest obstacles using NoSQL with JSON documents.
Posted October 30, 2018
The trend of increasing adoption of open source databases like MySQL, Postgres and flavors of NoSQL isn't going away any time soon.Resistance to the OSDBMS in the enterprise is diminishing as CIOs and IT managers realize that it is indeed a low-cost yet reliable alternative to the proprietary RDBMS, especially with the advent of better management functions and support.
Posted October 26, 2018
New tools and technologies are becoming established in enterprises, helping organizations extract more value from data. To explore the ways that data-centric companies are managing their data more effectively, we asked industry experts about the trends that loom large in the future and those that appear to be waning.
Posted October 24, 2018
Tableau Software is releasing new product integrations with industry leading technology providers, from mapping to data cataloging, that extend Tableau's powerful analytics capabilities to better fit customers' needs. Tableau's partner program expansion plans feature new certification and training programs to help increase the number of skilled partner employees, in order to ensure customer success with Tableau.
Posted October 24, 2018
Talend is making major updates to its Talend Data Fabric platform, the company's unified, data platform for data integration across multi-cloud and on- premise environments.
Posted October 24, 2018
SAP is releasing the latest update to SAP Data Hub, helping to build agile, data-driven pipeline applications. SAP Data Hub allows customers to build, execute, orchestrate and govern flow-based pipelines, providing the maximum reuse of existing data developments while encompassing digital innovations.
Posted October 24, 2018
Lenovo is releasing a hyperconverged system certified by SAP for SAP HANA HCI. The certification uses Nutanix AHV, the first hypervisor certified for production SAP HANA on Hyperconverged Infrastructure.
Posted October 24, 2018
SolarWinds—a provider of IT management software, which just began trading on the New York Stock Exchange (NYSE) under the ticker symbol "SWI"—has announced the release of the new Application Performance Monitor (APM) powered by AppOptics.
Posted October 23, 2018
Coined nearly 10 years ago by Patrick Debois, the term "DevOps" is now broadly accepted as a methodology by which software development teams and IT operations teams work collaboratively for a continuous delivery approach. The methodology puts a premium on speed. With the 10-year anniversary coming up, leading IT executives offer their DevOps predictions for 2019.
Posted October 17, 2018
Blockchain is more than just a new buzzword. Blockchain is a distributed ledger technology that is most commonly known for enabling the cryptocurrencies and payment networks.
Posted October 16, 2018
Juniper Networks, a provider of automated, scalable, and secure networks, is releasing a variety of new solutions to accelerate the industry's adoption of automation practices. Juniper is unveiling a collaborative community that includes tools, labs, libraries and an exchange of innovative applications to accelerate automation adoption for companies and individuals.
Posted October 12, 2018
Snowflake Computing, a data warehouse built for the cloud, is closing $450 million in additional growth funding led by Sequoia Capital to help Snowflake execute new and existing strategies. The remainder of Snowflake's existing investors also participated: Altimeter Capital, Capital One Growth Ventures, ICONIQ Capital, Madrona Venture Group, Redpoint Ventures, Sutter Hill Ventures and Wing Ventures.
Posted October 12, 2018
Companies are now managing a variety of open source and non-relational databases alongside relational databases like SQL Server and Oracle. While managing these systems involve the same set of challenges most DBAs are used to: ensuring availability, diagnosing performance problems and managing capacity, just to name a few, each database platform has its own set of processes and workflows for collecting and analyzing information.
Posted October 11, 2018
There has always been a need to tightly control some data items, such as passwords and Social Security numbers. Today, with the rise of concerns over personally identifiable information (PII), the General Data Protection Regulation (GDPR), and other legal mandates, a much larger group of data elements must be controlled. These legal data governance issues may need to guide our hands as we establish database designs.
Posted October 10, 2018
Looker's is updating its signature platform, designing the latest iteration to be a unified and extensible platform for data that flexes and scales to the ever-changing needs of business. Looker 6 is designed to flex and scale as needs for information change and expand.
Posted October 10, 2018
Commvault, provider of backup, recovery, cloud, and data management, is making a variety of improvements to its existing portfolio and adding new solutions to its suite of cloud-ready appliances.
Posted October 10, 2018
Many organizations are still doing traditional data science -- confining themselves to problems that are answerable with traditional statistical methods -- rather than utilizing the broad range of interfaces and techniques available today.
Posted October 09, 2018
SolarWinds, a provider of IT management software, is releasing the latest version of Database Performance Analyzer (DPA), a powerful database and query performance monitoring, analysis, and tuning tool built for many of today's popular databases.
Posted October 08, 2018