Database Management Articles
The latest release of Oracle Database (12.1.0.2) offers a unique set of features that portend increases in application workload execution, especially for analytics and data warehousing queries. This release, debuts Oracle Database In-Memory which provides a new columnar format - the In-Memory Column Store (IMCS) - for data that is likely to be accessed regularly for aggregation or analysis, as well as other features such as In-Memory Aggregation and In-Memory Joins that potentially offer several orders of magnitude of performance improvement. Finally, the new In-Memory Advisor makes short work of determining exactly which database objects are most likely able to take advantage of the IMCS.
Posted May 04, 2016
Being able to assess the effectiveness and performance of your database systems and applications is one of the most important things that a DBA must be able to do. This can include online transaction response time evaluation, sizing of the batch window and determining whether it is sufficient for the workload, end-to-end response time management of distributed workload, and more. But in order to accurately gauge the effectiveness of your current environment and setup, service level agreements, or SLAs, are needed.
Posted May 04, 2016
Redmonk's annual programming language rankings - based on GitHub and StackOverflow traffic - were recently released and to no one's surprise, JavaScript was ranked as the most popular programming language.
Posted May 04, 2016
Many thought it was an early April Fool's Day prank, but it was no joke: On March 7, 2016, Microsoft announced the beta release of SQL Server on Linux with the intention of shipping a full release of the product by April of 2017.
Posted May 04, 2016
Oracle has entered into a definitive agreement to acquire Opower, a provider of customer engagement and energy efficiency cloud services to utilities, in a transaction valued at approximately $532 million. Separately, Oracle also announced another agreement to acquire Textura, a provider of construction contracts and payment management cloud services for in a deal valued at approximately $663 million.
Posted May 04, 2016
What makes an IT organization static or dynamic? What triggers an organization to move from one to the other? The transformation is not easy and it certainly does not happen quickly. These questions can also be asked at a personal level. As an IT professional, are you more likely to be static or dynamic?
Posted May 04, 2016
Say what you will about Oracle, it certainly can't be accused of failing to move with the times. Typically, Oracle comes late to a technology party but arrives dressed to kill.
Posted May 04, 2016
Qlik is unveiling the next version of its Qlik Sense Enterprise platform, combing enterprise readiness and governance with visualization and data preparation capabilities, according to the company.
Posted May 03, 2016
TimeXtender, a provider of data warehouse automation (DWA) software for Microsoft SQL Server, is partnering with Qlik to offer a complete data warehouse and business intelligence package to users across the globe.
Posted May 03, 2016
Analytics provider Lavastorm is partnering with Qlik, a provider of visual analytics software, to offer an integrated solution for a broader swath of users of all skill levels through Qlik Sense.
Posted May 03, 2016
Led by Pivotal, GE Ventures, and GTD Capital, SnappyData has secured $3.65 million in Series A funding that will help it grow and further its technologies.
Posted April 29, 2016
Accenture and Splunk have formed an alliance that integrates Splunk products and cloud services into Accenture's application services, security, and digital offerings. The goal is to help customers improve business outcomes by mining vast amounts of application and operational data to identify trends and opportunities for improvement that were previously difficult to detect.
Posted April 28, 2016
Snowflake Computing, a provider of cloud-based data warehousing, and MicroStrategy, a provider of enterprise software platforms, are teaming up to provide cloud-enabled analytics. The collaboration will build on Snowflake's certified connectivity with MicroStrategy 10 through further product integration and go-to-market collaboration.
Posted April 28, 2016
Magnitude Software, a provider of Enterprise Information Management (EIM) software, unveiled a new a master data management offering designed to fuel business processes with accurate customer data for informed decision making.
Posted April 27, 2016
Database as a service, also known as DBaaS, offers a solution to some key issues that have vexed enterprise database shops for years. That is, how to maintain and update back-end technologies; how to integrate data from multiple, changeable sources without the need to rewrite the applications that depend on them; and how to make data readily accessible to end users who need it regardless of the device they are using.
Posted April 27, 2016
BackOffice Associates, a provider of information governance and data modernization solutions, is acquiring CompriseIT, a U.K. consulting firm specializing in helping enterprises adopt SAP Business Suite 4 SAP HANA (SAP S/4HANA). BackOffice Associates' acquisition of CompriseIT is the latest initiative in move to strengthen its expertise in helping customers as they embark on their journey to implement SAP S/4HANA.
Posted April 27, 2016
Cisco is launching an appliance that includes the MapR Converged Data Platform for SAP HANA, making it easier and faster for users to take advantage of big data. The UCS Integrated Infrastructure for SAP HANA is made easy to deploy, speeds time to market, and will reduce operational expenses along with providing users with the flexibility to choose a scale-up (on-premises) or scale-out (cloud) storage strategy.
Posted April 27, 2016
OpenText, a provider of enterprise information management (EIM) solutions, is releasing an enhanced version of its namesake platform, addressing key areas of the user experience, machine-to-machine integration, automation, and more.
Posted April 27, 2016
Microsoft has been on a tear for the past couple of years. It has been pushing forward with a very steady stream of powerful new features and capabilities, even entire product lines, within its Data Platform business. But while Microsoft has been hard at work on this deluge of new technologies, it would be completely forgivable if you haven't noticed. The reason it's OK is that Microsoft is advancing on multiple fronts, both in the on-premises product line and even more dramatically with the Azure cloud-based products.
Posted April 27, 2016
Analytics software firm FICO has introduced its Decision Management Suite 2.0, an expanded, cloud-based suite of analytic tools and applications for prescriptive analytics and decision management. The new release is an update to the suite which was first launched in 2013. The updated suite tackles problem the company says is common to many big data deployments - the gap between taking the vast amount of available data and translating it in to useful insights to support business decisions.
Posted April 27, 2016
BackOffice Associates, a provider of information governance and data modernization solutions, has launched version 6.5 of its flagship Data Stewardship Platform (DSP). The company is also introducing an updated application for business process governance and application data management.
Posted April 26, 2016
The COLLABORATE 16 conference for Oracle users kicked off with a presentation by Unisphere Research analyst Joe McKendrick who shared insights from a ground-breaking study that examined future trends and technology among 690 members of three major Oracle users groups.
Posted April 25, 2016
The greatest power in using IoT-derived insights is the ability respond to opportunities or threats immediately. However, enterprises largely have focused on historical reporting and will need to significantly modernize their analytics capabilities—both in understanding current events and predicting future outcomes—to take advantage of the new insights that IoT data can bring.
Posted April 25, 2016
The core reason for implementing in-memory technology is to improve performance. To help accelerate adoption of in-memory technologies and provide a universal standard for columnar in-memory processing and interchange, the lead developers of 13 major open source big data projects have joined forces to create Apache Arrow, a new top level project within the Apache Software Foundation (ASF).
Posted April 24, 2016
SAS has launched Viya,, a new analytics and visualization architecture designed to help make analytics accessible to a greater swath of users. According to the vendor, Viya, represents the foundation for a suite of offerings including machine learning, and will help speed the time between early-stage analytical exploration and resulting business value for users of all skill levels.
Posted April 22, 2016
MemSQL, provider of a distributed in-memory database that enables processing of transactions and running of analytics in real time, has closed its series C financing, raising $36 million. This latest MemSQL funding round brings the total amount raised to $85 million.
Posted April 21, 2016
Percona, a provider of MySQL and MongoDB solutions and services, is releasing an updated version of Percona Server for MongoDB .
Posted April 21, 2016
It seems every week there is another data breach in the news, which translates to millions and millions of personal records, credit card numbers, and other pieces of confidential information stolen each month. The victims of these breaches include important companies with professional IT staff. Now, you may be thinking: "Shouldn't the network guys be responsible for security?"
Posted April 20, 2016
When users require access to multiple databases on multiple servers distributed across different physical locations, database security administration can become quite complicated. The commands must be repeated for each database, and there is no central repository for easily modifying and deleting user security settings on multiple databases simultaneously. At a high level, database security boils down to answering four questions.
Posted April 19, 2016
Sumo Logic, a provider of cloud-native, machine data analytics services, is unveiling a new platform that natively ingests, indexes, and analyzes structured metrics data, and unstructured log data together in real-time.
Posted April 18, 2016
Teradata, the big data analytics and marketing applications company, is making key investments in the Internet of Things (IoT) and the Analytics of Things (AoT), along with updating its signature platforms.
Posted April 18, 2016
Hortonworks is making several key updates to its platform along with furthering its mission as being a leading innovator of open and connected data solutions by enhancing partnerships with Pivotal and expanding upon established integrations with Syncsort.
Posted April 15, 2016
First created as part of a research project at UC Berkeley AMPLab, Spark is an open source project in the big data space, built for sophisticated analytics, speed, and ease of use. It unifies critical data analytics capabilities such as SQL, advanced analytics, and streaming in a single framework. Databricks is a company that was founded by the team that created and continues to lead both the development and training around Apache Spark.
Posted April 14, 2016
Lavastorm is releasing its Accelerators Library solution at no cost to users, offering an array of preconfigured components that make it easier and faster for all Lavastorm users to build analytic applications regardless of technical acumen.
Posted April 14, 2016
IDERA is releasing its SQL Inventory Check platform for free to allow database administrators (DBAs) to easily discover servers on the network and verify versions to keep them properly maintained or to prepare for migrations.
Posted April 13, 2016
Qubole, a big data-as-a-service company, is open sourcing its Quark platform, a cost-based SQL optimizer. The Quark project is also available in a SaaS implementation via the Qubole Data Service (QDS).
Posted April 07, 2016
Delphix is making major updates to its data operations platform, delivering enhancements to strengthen secure application development in the data center and in the cloud. "One of the main bottlenecks that we hear about over and over is management of all of this data," Dan Graves, vice president of product marketing. "That's where Delphix comes in. Our core value is unlocking that data in a secure way to allow businesses to a have fast, fresh, full production environment."
Posted April 06, 2016
Sisense has announced improvements in its In-Chip Analytics software to help business users and data analysts more easily gain insights from complex data with disparate datasets. According to the vendor, when tested with Intel's recently-released 6th Generation Intel Core vPro processor, it was able to deliver a 300% improvement in speed over older chips.
Posted April 05, 2016
PASS (the Professional Association for SQL Server) is planning its fourth conference focused on business analytics.
Posted April 04, 2016
Databricks, the company behind Apache Spark, is releasing a new set of APIs that will enable enterprises to automate their Spark infrastructure to accelerate the deployment of production data-driven applications.
Posted April 01, 2016
ManageEngine is introducing a new application performance monitoring solution, enabling IT operations teams in enterprises to gain operational intelligence into big data platforms. Applications Manager enables performance monitoring of Hadoop clusters to minimize downtime and performance degradation. Additionally, the platform's monitoring support for Oracle Coherence provides insights into the health and performance of Coherence clusters and facilitates troubleshooting of issues.
Posted April 01, 2016
It's become almost a standard career path in Silicon Valley: A talented engineer creates a valuable open source software commodity inside of a larger organization, then leaves that company to create a new startup to commercialize the open source product. Indeed, this is virtually the plot line for the hilarious HBO comedy series, Silicon Valley. Jay Krepes, a well-known engineer at LinkedIn and creator of the NoSQL database system, Voldemort, has such a story.
Posted March 31, 2016
The traditional information engineering approach advocates the placement of as much business logic as possible inside the database management system (DBMS). But, more recently, under the umbrella of service-oriented architecture (SOA), folks are arguing for placement of that business logic in a layer of code outside the DBMS. Occasionally, those who favor locating business logic outside the DBMS have even gone so far as to say that this logic "naturally" belongs in a non-DBMS-supported layer.
Posted March 31, 2016