Readers' Choice Awards 2018
Subscribe to the online version of Database Trends and Applications magazine. DBTA will send occasional notices about new and/or updated DBTA.com content.
Trends and Applications
The 2018 DBTA Readers' Choice Awards Winners
Best Change Data Capture Solution
The big focus in analytics today is on access for all, and the ability to not only see what happened in the past but what is going on now or about to take place. A recent survey by Forbes Insights and Dun & Bradstreet of more than 300 senior executives across a broad range of industries confirmed that the goal of many organizations is to develop a data-driven culture, but also finds there is still plenty of work to be done to make that a reality.
Best Data Governance Solution
Today, data is both the output and the fuel of companies. For many however, the process of becoming a data-driven organization is hindered inflexible systems that were created years and even decades earlier.
Best Data Modeling Solution
Today, data quality solutions are available in the cloud as software as a service as well as on premise, and support the necessary data integrity for critical systems such as customer relationship management, master data management, data governance initiatives, and database management, as well as for regulatory compliance initiatives—including the E.U.'s new General Data Protection Regulation (GDPR).
Best Data Replication Solution
Cyberattacks are becoming the number-one risk to businesses, brands, operations, and financials, according to recent "SonicWall Cyber Threat Report" (March 2018). There were 9.32 billion malware attacks in total in 2017, representing an 18.4% increase over 2016. On the other hand, Verizon's Data Breach Investigations Report (DBIR) shows that more a quarter of the time, data breaches across the world originated from an organization's "insiders." But the report notes, malicious employees looking aren't the only insider threat you face. Errors were at the heart of almost one in five (17%) breaches.
Best Data Storage Solution
Best Data Virtualization Solution
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.
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.
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.
Best Database Development Solution
Best Database Performance Solution
After more than 10 years, there is no technology more aligned with advent of big data than Hadoop. The Apache Hadoop framework allows for the distributed processing of large datasets across compute clusters, enabling scale up from single commodity servers to thousands of machines for local computing and storage. Designed to detect and handle failures at the application layer, the framework supports high availability.
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.
MultiValue database technology continues to boost a strong following of loyal supporters. This NoSQL database technology is found in many industry verticals, including retail, travel industry, oil & gas, healthcare, government, banking, and education. Highly customized, mission-critical applications have been built on MultiValue database technology, which is sometimes called the fifth NoSQL database technology. The MultiValue database dates back to the mid-1960s, with Don Nelson and Dick Pick widely credited as the founding fathers of the technology. Also referred to as Pick or MultiDimensional, a key advantage of MultiValue, is the database structure's use of attributes that can have multiple values, rather than one single value as with relational technology.
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.
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.
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.