Database Management Articles
IDERA, a provider of database productivity tools, is releasing SQL Diagnostic Manager with the new SQL Query Tuner, optimizing SQL queries and indexes for SQL Server. The release also adds MySQL support to its flagship SQL performance monitoring capabilities.
Posted August 16, 2018
SnapLogic is introducing dedicated DevOps and automation capabilities, including new integration with GitHub and support for Mesosphere in its latest platform update. These new enhancements to the SnapLogic Enterprise Integration Cloud provide the company's growing customer base with self-service application and data integration to streamline and accelerate the software development lifecycle.
Posted August 15, 2018
The Bitfury Group has launched "BE BIG," a global education initiative that will advance the adoption of blockchain as the technology of digital trust.
Posted August 15, 2018
SAP is updating its cloud platform, boosting the solution with the ability to extend and customize applications with multicloud and mobilization choices. The enhancements include SAP Cloud Platform Blockchain, which will enable enterprises to build and extend business solutions with blockchain technologies.
Posted August 15, 2018
The hype around blockchain technology as it relates to cryptocurrencies such as bitcoin is reaching an all-time high, but enterprise organizations are taking a longer-term, more measured approach.
Posted August 15, 2018
Shark attacks and ice cream sales follow the very same trajectory when charted. When ice cream sales go up, so do shark attacks. When ice cream sales decrease, shark attacks decrease. With a correlation coefficient of very close to 1, we can deduce that sharks like to attack after we've recently had ice cream!
Posted August 15, 2018
During a presentation at Oracle headquarters in Redwood Shores, in which Oracle CTO and chairman Larry Ellison unveiled the company's latest Autonomous Database Cloud Service, Oracle Autonomous Transaction Processing, he also sought to alleviate concerns that database automation will eliminate the jobs of longstanding Oracle database administrators. "I have got some bad news for you: No early retirement," he said. "A lot of the tedious things you were doing—allocating disk storage and upgrading the OS—you don't have to do. However, there is a lot more to do."
Posted August 15, 2018
Tredence, an analytics services company, is launching the AI Data Cleanser to use machine learning and deep learning technology to uncover reliable data. The AI Data Cleanser is a data cleansing and enrichment solution using machine learning/deep learning techniques to cleanse and enrich any master data.
Posted August 14, 2018
CognitiveScale Inc., a provider augmented intelligence and AI software, is being selected by Dell to help transform customer experience and marketing productivity through AI. Dell chose CognitiveScale and its Cortex 5 software to power and transform the core of their customer journeys.
Posted August 14, 2018
IBM Security has announced X-Force Red Labs, a network of four secure facilities dedicated to testing the security of devices and systems including consumer and industrial IoT technologies, automotive equipment, and ATMs. The new labs are operated by X-Force Red, an autonomous team of veteran hackers within IBM Security, and will be located in Austin, TX; Hursley, England; Melbourne, Australia; and Atlanta, GA.
Posted August 13, 2018
CLS, a market infrastructure group delivering settlement, processing, and data solutions, and IBM are collaborating on a proof of concept for LedgerConnect—a distributed ledger technology (DLT) platform for the financial services industry. The platform is designed to enable banks, buy and sell side firms, FinTechs, and software vendors to deploy, share, and consume services hosted on a shared distributed ledger network.
Posted August 13, 2018
EnterpriseDB, developer of a Postgres-based database platform, is releasing the beta version of its EDB Postgres Migration Portal, an automated online tool for moving Oracle databases to the EDB Postgres Platform.
Posted August 13, 2018
DBI Software, a provider of Db2 LUW performance solutions, has introduced new capabilities in its pureFeat V7 Performance Management Suite for IBM Db2 LUW. With this release, DBI is elevating performance monitoring to help DBAs and management teams to cope with the volatility of agile environments, said Scott Hayes, president and founder of DBI.
Posted August 13, 2018
Amazon Web Services, Inc. (AWS), an Amazon.com company, unveiled Amazon Aurora Serverless., a new deployment option for Amazon Aurora that automatically starts, scales, and shuts down database capacity with per-second billing for applications with less predictable usage patterns. Amazon Aurora Serverless offers database capacity without the need to provision, scale, and manage any servers.
Posted August 10, 2018
Alation Inc., the data catalog company, is launching the Alation Partner Program which will be dedicated to the successful enterprise-wide deployment of data catalogs. One focus of the partner program is fulfilling the needs of customers to achieve success with enterprise-wide metadata management.
Posted August 09, 2018
In the big data world of today, issues abound. People discuss structured data versus unstructured data; graph versus JSON versus columnar data stores; even batch processing versus streaming. Differences between each of these kinds of things are important. How they are used can help direct how best to store content for use. Therefore, deep understanding of usage is critical in determining the flavor of data persistence employed.
Posted August 08, 2018
We are living in the age of polyglot persistence, which really just means that it makes sense to store data using the technology that best matches the way the data will be used by applications. The age of trying to force everything into a relational DBMS is over, and we now have NoSQL, NewSQL, in-memory, and Hadoop-based offerings that are being used to store data. But you really should also be looking at the algorithmic approach offered by Ancelus Database.
Posted August 08, 2018
In my previous IOUG Observations column, I wrote about the Oracle Database Security Assessment Tool (DBSAT) and its value when performing security reviews. However, we should also be cognizant of DBSAT's cousin utility, ORAchk, which is used to perform more general health checks against a variety of components in the Oracle technology stack. Similar to DBSAT, ORAchk is available from Oracle's support site with no additional licensing requirements.
Posted August 08, 2018
This year is an expansive one for the database ecosystems that have evolved around the major platforms. Artificial intelligence (AI), machine learning, the Internet of Things (IoT), and cloud computing are now mainstream offerings seen within the constellations of database vendors, partners, and integrators.
Posted August 08, 2018
This may seem contradictory at first glance: Fresh data from the database user community finds that data lakes continue to increase within the enterprise space as big data flows get even bigger. Yet, at the same time, enterprises appear to have pulled back on Hadoop implementations.
Posted August 08, 2018
Still a relatively new solution coming into its own streaming platforms allow individuals to see data in real-time batches. Streaming solutions can help businesses analyze data in motion, simplify the development of applications, and extend the value of existing systems by integrating with already implemented applications along with supporting both structured and unstructured data.
Posted August 08, 2018
A relational database is a set of formally described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. The standard user and application programming interface (API) of a relational database is the Structured Query Language (SQL). SQL statements are used both for interactive queries for information from a relational database and for gathering data for reports.
Posted August 08, 2018
Database downtime can inflict a fatal wound on the life of a business and 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. With long downtimes simply unacceptable, organizations seek solutions with capabilities such as the ability to manage backups seamlessly, manage and monitor backups, ensure data integrity, scale efficiently restore quickly to any point in time, and provide security features to stay in compliance with local geographic and industry mandates.
Posted August 08, 2018
Companies are increasingly looking for the right database for the data storage need at hand. That might mean NoSQL, NewSQL, in-memory databases, and cloud databases—also known as database as a service—approaches.
Posted August 08, 2018
Today's data visualization tools go beyond the standard charts and graphs used in Excel spreadsheets, displaying data in more sophisticated ways such as infographics, dials and gauges, geographic maps, sparklines, heat maps, and detailed bar, pie and fever charts. The images may include interactive capabilities, enabling users to manipulate them or drill into the data for querying and analysis.
Posted August 08, 2018
Pick Cloud, Inc. and 3phi Solutions Inc. are forming a strategic partnership to sell phiReport Cloud edition exclusively in North America. phiReport is a suite of reporting tools based on the PICK/MultiValue DBMS. The application is built using AccuTerm GUI, allowing any Windows user with a current AccuTerm terminal emulator to define and generate attractive Excel worksheets from a graphical user interface.
Posted August 08, 2018
At the close of a presentation in which he announced general availability of the company's latest Autonomous Database Cloud Service, Oracle Autonomous Transaction Processing, Oracle CTO and chairman Larry Ellison also previewed new capabilities of Oracle Database 19c. With the upcoming 19c release, machine learning eliminates performance regression testing, and Oracle will offer an additional deployment option.
Posted August 08, 2018
Redgate Software is adding Nexus Technology to its worldwide partner roster to help organizations successfully introduce DevOps to their database development. Redgate's software is already used by 91% of companies in the Fortune 100, and the new partnership with Nexus now means companies in the Channel Islands are in the ideal position to explore how too they can take advantage of database DevOps.
Posted August 07, 2018
Instana, a provider of application monitoring for containerized microservice applications, is releasing a set of customization features across their solution, creating a personalized APM experience for users. The new capabilities, called Application Perspectives, go beyond traditional custom dashboarding to deliver an automated personal guided APM experience.
Posted August 07, 2018
Today, data is understood to be the fuel that propels companies' growth and success. As a result, safeguarding that valuable resource is more important—but also harder—than ever.
Posted August 07, 2018
The way that many organizations approach the backup process has failed them, as evidenced by the hundreds of millions of dollars they have spent on ransomware to retrieve their data.
Posted August 02, 2018
Informatica, the enterprise cloud data management provider, is launching new customer success offerings that leverage big data, AI, and machine learning. Informatica's new program boasts faster business value with consistent and superior experiences to customers worldwide.
Posted August 01, 2018
SAP is deepening its partnership with Google and Intel to offer GCP virtual machines supporting the upcoming Intel Optane DC Persistent Memory for SAP HANA workloads. These GCP VMs will be powered by the future Intel Xeon Scalable processors (code-named Cascade Lake) thereby expanding VM resource sizing and providing cost benefits for customers.
Posted August 01, 2018
CargoSmart Limited, a global shipment management software solutions provider, is developing a blockchain solution for shipment documentation to improve complex supply chain processes. Powered by Oracle's blockchain cloud platform, the solution will establish a digital baseline for trusted shipment documentation management across the shipping and logistics industry.
Posted August 01, 2018
Oracle has announced the release of the Oracle TimesTen Scaleout online transaction processing (OLTP) database that the company says is capable of massive scaleout, extreme transaction processing throughput, and ultra-low response times.
Posted August 01, 2018
Redgate Software is upgrading SQL Prompt, elevating it from helping to develop and standardize new code to discovering problems in legacy code. The latest update to SQL Prompt allows users to analyze an entire script of legacy code, no matter how large, and see a list of all the issues contained within it.
Posted July 31, 2018
Silwood Technology Ltd., provider of self-service metadata discovery software, is entering a global reseller agreement with IDERA, a provider of database productivity tools. Through this agreement, IDERA will market and resell Safyr to complement its ER/Studio data modeling and architecture product suite.
Posted July 31, 2018
Datawatch has announced that Datawatch Swarm, its enterprise data intelligence platform, is offering new deployment options to fuel self-service analytics. The new release aligns with enterprises' needs for collaborative infrastructure and also provides multi-tenancy and SaaS deployment options for Datawatch partners.
Posted July 27, 2018
Splice Machine is releasing its intelligent application platform on the Microsoft Azure cloud service, giving customers another way to use the data platform while have the choice to deploy on-prem, AWS, or Azure. Splice Machine is a scale-out SQL data platform that can run fast OLTP and in-memory OLAP on the same platform, along with machine learning and streaming.
Posted July 26, 2018
A distributed cloud database is a database in which operational data is spread across different physical locations—for example, across different data centers, across hybrid clouds (such as private and/or public clouds), different public cloud regions of a public cloud, or even different public clouds.
Posted July 26, 2018
Magnitude Software, Inc., a provider of unified application data management, is acquiring Every Angle Software Solutions, a provider that enables users of SAP-run organizations to optimize their operational performance. Every Angle's self-service solution works on any SAP system (ECC and HANA) and hides the complexity of SAP's data structure, allowing end users to quickly identify and resolve key business issues.
Posted July 25, 2018
There's a new generation of technologies reshaping data management as we know it. To explore some of the game-changing technologies or approaches that are having the most profound impact on today's enterprises, DBTA asked industry experts and leaders to cite what they see as having the most positive impact. The following are eight areas effecting the most change.
Posted July 25, 2018