Database Management Articles
Envorso, a provider of business transformation solutions, is entering a strategic partnership with Signafire Technologies, an industry-leading fusion and content analysis company. The partnership will allow Envorso to offer enterprise data fusion solutions.
Posted August 17, 2018
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
Oracle CTO and chairman Larry Ellison announced the availability of the company's latest Autonomous Database Cloud Service, Oracle Autonomous Transaction Processing. Leveraging machine learning and automation capabilities, the company says the new transaction processing service delivers cost savings, security, availability, and productivity, and can support a complex mix of high-performance transactions, reporting, batch, IoT, and machine learning in a single database.
Posted August 15, 2018
The concepts of Agile methodology and continuous delivery have become popular in software development, yet they are somewhat less mature among DBAs and database developers. Shay Shmeltzer, director of product management for Oracle Cloud Development Tools, discussed how database administrators (DBAs) and SQL developers can take advantage of newer development approaches while also dealing with the unique challenges that exist in the world of database development.
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
At Data Summit 2018, Jeff Fried, director of product management at InterSystems, gave attendees a primer on how multi-model databases reduce data modeling complexity in his session, "Polyglot Persistence Versus Multi-Model Databases."
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
A brand new study fielded among Database Trends and Applications readers and members of the Independent Oracle Users Group reveals that database professionals are being tasked with managing more database instances and platforms, and in greater sizes, than ever before - both on premises and in the cloud. As a result, it's no surprise that the biggest priorities for database teams this year are improving database performance, database upgrades, and data integration.
Posted August 08, 2018
Providing an integrated environment that simplifies software development, these solutions are valued for their ability to improve database development with an end-to-end approach that helps developers stay on top of the latest technology innovations and build modern applications. For database development teams, maximizing competence, performance, adaptability, and readiness, will help simplify development and allow automation to achieve repeatable processes, all while avoiding potential risks that create downtime.
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
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. Businesses are utlizing highly complex, data environments with multiple data platforms across physical data centers and the cloud, managing systems and processes manually is no longer sufficient. What is needed is the ability to manage and monitor business-critical assets with automated precision.
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
Storage solutions provide critical services for backup and archiving, content storage and distribution, big data analytics, and disaster recovery. Increasingly also there are smarter storage solutions, enabling greater efficiency and cost reduction through data compression, information lifecycle management, and tiered storage strategies.
Posted August 08, 2018
While the data growth rate, number of database instances, and number of platforms that each DBA must support has not changed radically in the last few years, the database infrastructure has become more complicated. Two key factors are at play in the increasing complexity.
Posted August 08, 2018
As a key component to data integration best practices, change data capture (CDC) is based on the identification, capture, and delivery of the changes made to enterprise data. CDC helps minimize access to both source and target systems. It also supports the ability to keep a record of changes for compliance, and is a key component of many data processes.
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
At Data Summit 2018, Jeff Fried, director of product management at InterSystems, discussed how to create and maintain both polyglot and multi-model databases in his session, "Polyglot Persistence Versus Multi-Model Databases."
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