Database Management Articles
Hortonworks has announced the Hortonworks DataPlane Service (Hortonworks DPS) to help improve the process of provisioning and operating distributed data systems for data science, self-service analytics or data warehousing optimization.
Posted September 25, 2017
Oracle has announced the availability of the first release candidate of MySQL 8.0, which focuses on making MySQL better for modern apps. The new release was announced in a MySQL team blog post by Morgan Tocker.
Posted September 25, 2017
Barracuda is evolving its MSP business unit, formerly known as Introns and now rebranded as Barracuda MSP, to expand its continued focus on helping users protect customers from data loss and security breaches.
Posted September 21, 2017
WaveMaker, Inc., a provider of Rapid Application Development (RAD) Platform software, is upgrading its platform, completely revamping its user interface. WaveMaker 9 focuses on providing a simplified and friendly first-time user experience, now offering video tutorials and tool run-throughs that can onboard fellow/partner developers to give them a clearer picture about the functions of all the components of the platform.
Posted September 21, 2017
Regardless of industry, the ability to collect, manage, and intelligently leverage data will clearly be a differentiator for the foreseeable future. Executives in healthcare are acutely aware of the disruption being driven by this new paradigm and understand that this trend is impacting every sector, from banking to farming to manufacturing. Ultimately, investing time and resources in data collection and analysis is only valuable if it provides insight for making proactive, tactical decisions. Innovative companies today are using big data and analytics to drive attributable revenue and compete more effectively.
Posted September 20, 2017
It's still months away, but it is never too early to start thinking about the holiday shopping season, especially since most Americans are already anticipating outages and system failures from their favorite online retailers. According to a survey, 52% of shoppers expect to experience an outage on days like Black Friday and Cyber Monday. When web and mobile sites buckle under huge volumes of traffic and experience outages, retailers lose revenue, and their brands suffer significantly. To prepare for the busiest online shopping season, companies need to ensure their systems are ready for extreme scalability and continuous IT operations, year-round.
Posted September 20, 2017
As companies grow increasingly data-centric in their decision making, product and services development, and their overall understanding of the world they work in, speed and agility are becoming critical capabilities. A common theme in big data and analytics today is "Industry 4.0," representing a new wave of technology that enables the automation necessary for scaling. There's compelling justification for this as companies seek to unlock business value from big data with two broad approaches: the democratization of data with greater access by more users, and the enablement of automation everywhere possible.
Posted September 20, 2017
Businesses of all sizes across all industries are rapidly adopting digital transformation models that put data at the center of driving the business forward—as they should. However, putting data at the center of everything the business does can be risky without proper planning and rigorous management. Many companies have been wise to introduce data governance programs to protect corporate data assets and establish a framework for operational excellence when it comes to data management and use. Data governance emphasizes the enforcement of defined standards or policies and provides mechanisms for consistency and repeatable processes, but it is not enough to protect businesses in today's world of data.
Posted September 20, 2017
TigerGraph is emerging from stealth, securing of $31M in Series A funding and launching TigerGraph - a native parallel graph database platform for enterprise applications along with the availability of both its Cloud Service and GraphStudio, TigerGraph's visual software development kit (SDK).
Posted September 20, 2017
The "world's first autonomous self-driving database" was announced by Oracle executive chairman of the board and CTO Larry Ellison during a live event at the company's Redwood City headquarters. In addition to the database, which he said he plans to showcase in an Oracle OpenWorld presentation in October, Ellison also discussed Oracle's emphasis on automation in platform services, and the decision to be much more aggressive in simplifying and lowering the pricing of automation around those platform services with two programs—Bring Your Own License to PaaS and Universal Credits.
Posted September 20, 2017
Syncsort is releasing a new platform that will deliver an agile, efficient, and powerful solution that will improve data stored and processed in data lakes. Trillium Quality for Big Data integrates Trillium data quality capabilities with the Intelligent Execution (IX) technology from its DMX-h Big Data integration solution.
Posted September 19, 2017
Redgate Software is releasing a new version of SQL Toolbelt, its portfolio of database development software, that will let developers and administrators see database deployment errors. This portfolio addresses a long standing issue that, when database deployments are made, it is vital to monitor their impact in case they lead to SQL Server problems. In many busy organizations, however, it may not be immediately obvious that a deployment has been made, or that the deployment is the cause of resultant issues that arise.
Posted September 14, 2017
InterSystems has announced the InterSystems IRIS Data Platform, a new data platform that aims to provide capabilities for rapidly developing data-intensive and mission-critical applications, including advanced data management, interoperability, transaction processing, and analytics. IRIS stands for Interoperable, Reliable, Intuitive and Scalable - four attributes that InterSystems says are required to capitalize on the growing volumes of data entering organizations every day.
Posted September 14, 2017
Munbo Software has launched a new application development platform to ease the pain of developers working with complex multi-tiered architectures. Headquartered in Sydney, Australia, Munbo was founded in 2010 by Angelo Doukas and Stephen Gregan, and has been developing the platform for the past 7 years.
Posted September 14, 2017
BDNA, a provider of comprehensive technology asset information, is entering an agreement with Amazon Web Services (AWS) to develop BDNA Cloud Asset Insights, a new solution that provides discovery and normalization for commercial software assets deployed on Amazon Elastic Compute Cloud (Amazon EC2).
Posted September 13, 2017
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