Database Management Articles
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
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 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
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 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
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 07, 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 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
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 02, 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
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 July 30, 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
Hitachi Vantara has announced hardware and software enhancements across the Hitachi Unified Compute Platform (UCP) family of converged, hyperconverged and rack-scale systems, including NVMe SSD caching and GPU processor-based server options. New certified applications ecosystem solutions optimized for mission-critical environments include Oracle databases, SAP HANA, VMware, and big data analytics frameworks.
Posted July 25, 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 July 25, 2018
MemSQL is updating its flagship platform, advancing its performance along with adding capabilities to accelerate time to insight. MemSQL 6.5 delivers an integrated database for data capture, management, and operations that integrates seamlessly with existing systems, infrastructure, and employee skills. This allows customers to get faster time to value and reduces cost and complexity.
Posted July 25, 2018
Panzura, a provider of enterprise hybrid cloud NAS and multi-cloud data management, has launched Panzura Freedom Cloud NAS on the Google Cloud Platform (GCP) Marketplace. According to the vendor, Panzura Freedom replaces traditional NAS with scalable and durable cloud attached storage (CAS) without sacrificing performance or re-writing applications running in the data center, allowing customers to consolidate their unstructured data across data islands into "a single source of truth" in GCP.
Posted July 23, 2018
Sumo Logic, provider of a cloud-native, machine data analytics platform is unveiling 11 new Google Cloud Platform (GCP) applications as well as integration with Google Cloud's open source machine learning library, TensorFlow. The applications will enable real-time collection and analytics of machine data emitted by all major GCP services.
Posted July 23, 2018
SolarWinds, a provider of IT management software, is launching SolarWinds Log Manager for Orion, a new, powerful log management tool for on-premises IT environments. Fully integrated with the SolarWinds Orion Platform, Log Manager is designed to provide the essential components an IT operations team needs for improved log monitoring, troubleshooting, and performance management.
Posted July 19, 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 July 18, 2018
BlueData, provider container-based software for AI and Big Data workloads, will undertake a new open source Kubernetes initiative: BlueK8s. The company also introduced the first open source project in the BlueK8s initiative, Kubernetes Director (aka KubeDirector), for deploying and managing distributed stateful applications with Kubernetes.
Posted July 17, 2018
The dbKoda team has released dbKoda 1.0, the first production release of its open source integrated development environment (IDE) for MongoDB. dbKoda offers features for developing MongoDB applications and for managing and tuning MongoDB databases.
Posted July 17, 2018
Periscope Data is launching a new machine learning (ML) solution that leverages Amazon SageMaker as part of a comprehensive offering for data teams looking to solve complex problems. Periscope Data's new functionality with Amazon SageMaker will allow data analysts to tackle ML problems in one seamless workflow, from data prep to model training to reporting.
Posted July 16, 2018
Snowflake Computing, the data warehouse built for the cloud, is releasing its data warehouse-as-a-service on Microsoft Azure for preview. Customer demand for Azure, and the need for large organizations to have flexibility across their cloud strategy, has prompted Snowflake to offer Azure as a cloud computing option to run Snowflake's cloud-built data warehouse.
Posted July 12, 2018
Pure Storage, an all-flash storage platform, is releasing Pure Service Orchestrator, delivering container storage-as-a-service. Pure Service Orchestrator equips customers with effortless, self-managed storage that drives data centric architecture with public cloud-like agility on-premises, backed by all-flash speed and enterprise reliability, according to the vendor.
Posted July 06, 2018