Database Management Articles
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
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 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
Redgate Software, a Cambridge, UK-based database tools provider, has launched a new one-stop resource to help software professionals find the information and advice they need faster and easier.
Posted August 09, 2017
BackOffice Associates, a provider of information governance, data stewardship, and data migration solutions, has announced that Bridge Growth Partners, a private equity firm, has signed an agreement to make a majority equity investment in the company.
Posted August 03, 2017
Accenture has acquired Search Technologies, a Herndon, Virginia-based technology services firm specializing in the design, implementation and management of big data and search analytics. Terms of the transaction were not disclosed. Kamran Khan, president and CEO of Search Technologies, will lead a new Content Analytics team within Accenture Analytics.
Posted August 03, 2017
Creative Media Works, operating as BBM Messenger has selected Pythian to help them migrate to the Google Cloud Platform. Pythian, a global IT services company that helps businesses adopt technologies to better compete, will help BBM Messenger move its mission-critical IT infrastructure for Android, iOS and Windows consumer BBM from BlackBerry on-prem data centers in Canada to Google Cloud Platform (GCP) in Asia.
Posted August 03, 2017
IDERA, a provider of database, development, and test management tools, announced it is acquiring AquaFold, a provider of cross-platform database tools. AquaFold will join IDERA's database development and management portfolio, enabling the company to expand its multi-platform support.
Posted August 02, 2017
Streaming data solutions can evaluate data quickly and enable predictive analytics based on sources of rapidly changing data—including social media, sensors, and financial services data, to head off future problems, machine failures, natural disasters, and take advantage of unfolding opportunities.
Posted August 02, 2017
Change data capture (CDC) is a function within database management software that makes sure data is uniform throughout a database. CDC identifies and tracks changes to source data anywhere in the database, and then applies those changes to target data in the rest of the database.
Posted August 02, 2017
In today's always-on economy, database downtime can inflict a mortal wound on the life of a business. That's why 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. Today, close to one-fourth of organizations have SLAs of four nines of availability or greater, meaning they require less than 52 minutes of downtime per year, according to a recent Unisphere Research survey.
Posted August 02, 2017
If data is the new oil, then getting that resource pumped out to more users faster with fewer bottlenecks is a capability that must be achieved. The issue of under-performing database systems cannot be seen as simply an IT problem. Remaining up and running, always available and functioning with lightning speed today is a business necessity.
Posted August 02, 2017
Geographically spread-out development teams with varied skill levels and different areas of proficiency, ever-faster software development cycles, multiple database platforms—all this translates to a challenging development environment that database development solutions providers seek to streamline.
Posted August 02, 2017
As data stores grow larger and more diverse, and greater focus is placed on competing on analytics, processing data faster is becoming a critical requirement. In-memory technology has become a relied-upon part of the data world, now available through most major database vendors. In-memory can process workloads up to 100 times faster than disk-to-memory configurations, which enables business at the speed of thought.
Posted August 02, 2017
Addressing the need to store and manage increasingly large amounts of data that does not fit neatly in rows and columns, NoSQL databases can run on commodity hardware, support the unstructured, non-relational data flowing into organizations from the proliferation of new sources, and are available in a variety of structures that open up new types of data sources, providing ways to tap into the institutional knowledge locked in PCs and departmental silos.
Posted August 02, 2017
The rise of new data types is leading to new ways of thinking about data, and newer data storage and management technologies, such as Hadoop, Spark, and NoSQL, are disruptive forces that may eventually result in what has been described as a post-structured world. But while Hadoop and NoSQL are undoubtedly growing in use, and a wider array of database management technologies in general is being adopted, the reality is that at least for now the relational database management system is still reigns supreme and is responsible for storing the great majority of enterprise data.
Posted August 02, 2017
Coined over a decade ago, the term "polyglot persistence" has come to be seen as a shorthand phrase in the database world for using the best tool for the job, or in other words, the right database for the data storage need at hand. Today, that might mean NoSQL, NewSQL, in-memory databases, and cloud databases—also known as database as a service—approaches.
Posted August 02, 2017
Oracle is adding hundreds of new capabilities to Oracle Cloud Applications with Release 13. Key enhancements are aimed at enhancing the user experience and supporting business users across the organization through greater personalization, productivity, insight, and collaboration. Supply chain is a key focus of the release.
Posted August 02, 2017
Workiva, a provider of solutions for enterprise productivity and Gold-level member of Oracle PartnerNetwork, has announced data integration between its Wdesk platform and more than 100 cloud, SaaS and on-premise applications, including Oracle Enterprise Resource Planning (ERP) Cloud.
Posted August 02, 2017
TIBCO Software, a provider of integration, API management, and analytics, is acquiring nanoscale.io, a provider of microservices technology and tooling. The acquisition extends and enhances TIBCO's leadership in the development of microservices and APIs that connect and integrate with a more expansive on-premises or hybrid cloud environment, and bolster its Connected Intelligence platform.
Posted July 27, 2017
It's been long acknowledged that data is the most precious commodity of the 21st-century business, and that all efforts and resources need to be dedicated to the acquisition and care of this resource. Lately, however, executives have become enamored with the vision of transforming their organizations into "data-driven" enterprises, which move forward into the future on data-supported insights. So, what, exactly, does the ideal "data-driven enterprise" look like?
Posted July 27, 2017
EnterpriseDB has released EDB Postgres Enterprise Manager 7. Part of the EDB Postgres Platform, EDB Postgres Enterprise Manager 7 provides a new web client and tools to give DBAs greater ability to improve database performance across large installations.
Posted July 27, 2017
InfluxData has announced general availability of the InfluxData platform, version 1.3 of its open source platform built from the ground up for metrics and events.
Posted July 24, 2017