Newsletters




Database Management

Relational Database Management Systems (RDBMSs) continue to do the heavy lifting in data management, while newer database management systems are taking on prominent roles as well. NoSQL database systems such as Key-Value, Column Family, Graph, and Document databases, are gaining acceptance due to their ability to handle unstructured and semi-structured data. MultiValue, sometimes called the fifth NoSQL database, is also a well-established database management technology which continues to evolve to address new enterprise requirements.



Database Management Articles

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

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

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 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

The votes have been counted and the results are in. Now, it's time to offer congratulations as Database Trends and Applications magazine unveils the 2018 Readers' Choice Awards winners. Many of the vendors and products are well-known with market-leading positions established over many years.  However, there are also newer names in the mix, representing the rapidly evolving nature of information technology solutions and services.

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

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 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

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

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

These days migrating from on-premise to cloud-based architectures are a no brainier. However, even though this process increases IT agility, it also increases business risk. DBTA recently held a webinar with Brian Walters, director of solution engineering, Percona, who discussed best practices for managing this balance and mitigating risk as much as possible.

Posted July 31, 2018

Modern architecture has evolved beyond the traditional data warehouse to include logical data warehouses, data lakes, distribution hubs, data catalogs, analytical sandboxes, and data science hubs, along with both self-service data preparation and BI. At Data Summit 2018, Richard Sherman, managing partner, Athena IT Solutions, reflected on the need to build a data architecture for modern business intelligence and analytics that supports structured, unstructured, and semi-structured sources and hybrid integration and data engineering as well as analytical uses by casual information consumers, power users, and data scientists.

Posted July 31, 2018

Machine learning continues to grow with the advent of new technologies and solutions. It has emerged as a truly revolutionary technology innovation across all verticals and industries; according to analyst firm IDC, spending on machine learning will grow from $12B to $57.6B by 2021.

Posted July 30, 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

The big data landscape is constantly changing and the latest IOUG study is reflecting those changes as organizations continue to flock to the cloud, changing the role and mission of IT teams. DBTA recently held a webinar with Lee Levitt, director, business development, Oracle, who discussed how companies are navigating the change and capitalizing on the benefits cloud brings when it comes to data management and getting more out of analytics.

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

Silicon Valley has achieved an almost mythical status in both modern American popular culture as well as the annals of world economic history, write Don Sullivan and Michael Corey in their latest Cloud Currents column for Big Data Quarterly. But, in truth, they note, Silicon Valley spans the continent, as pervasive in historic eastern cities as it is embedded in New Age Pacific-Northwest locations.

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

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81

Sponsors