![]() ![]() This feature accelerates complex reporting because queries can run faster on a flattened table compared to a standard or optimized join. Flattened Tables allow users to exploit columnar design for ad-hoc reporting by creating very large tables which include columns that get their values by querying other tables. This allows ivi to run a development and testing environment without requiring additional Vertica licenses.Īt the same time, ivi is upgrading to the latest Vertica Version 9.1, which contains many additional features that will enhance their data warehousing applications and tasks, including Flattened Tables. The company is pleased with Vertica’s licensing model because it is purely based on the amount of data being analyzed rather than hardware parameters or number of users. The old three machine cluster will still be leveraged as a development and testing environment. The Vertica implementation is expanding to accommodate data growth and the production environment is migrating to a new cluster of five servers. The company has grown, and the number of employees relying on analytical data has increased four-fold,” says Dmitry Antonov. Since we’ve introduced Vertica we are producing much more timely and accurate data analysis. We have the flexibility to work with the data we accumulate and the scope to manage one-off queries: the data is still stored in the raw format and can be studied from a wide variety of angles. The diversity and depth of our analytics has increased massively. “Vertica has been a real revelation for us. ![]() The data is transferred from the billing system and ingested by Vertica from the system logs of the servers where the advertising and the content view data is recorded.īy introducing Vertica, ivi has significantly improved its data analytic performance. “This is critical information, and the analysis should be carried out as quickly and accurately as possible,” says Dmitry Antonov. Vertica collects and analyzes advertising and content data, as well as payment information. The ivi team also tested Vertica’s compatibility with Microsoft services as a potential extension of their reporting system. In addition, Vertica has its own data ingestion tools and report-loading modules. Tableau is used for reporting and data visualization and Vertica integration is implemented through ODBC drivers. Over time, ivi migrated to Vertica Version 7, deployed on the same three servers and without the need for external storage. Report preparation is now much simpler, and we are able to generate a huge range of reports fast for the business,” says Dmitry Antonov. “We made sure there were no problems with data loss or connection to visualization tools. IVI PRO HIGHEST VIDEO QUALITY SETTINGS LICENSETransitioning from Vertica Community Edition to a commercial license took approximately six months, with ivi experts thoroughly testing all reports to ensure they were delivering accurate results. The primary requirements for a new analytics platform were high performance, responsive report generation, and fast data-loading capabilities. “We were looking for a solution that would allow us to work flexibly with information, keeping raw data about every advertising or content display to make data analytics as convenient as possible, while delivering comprehensive reports,” recalls Dmitry Antonov, Head of the Technical Analytics Department for ivi. Given the central role data analytics plays in content and ad optimization, ivi knew the company needed to switch to a more modern DBMS platform specifically designed for highly performant, large-scale data analytics. Poor performance issues, low productivity, and lack of system flexibility prevented ivi and its partner analysts from accessing the insights they needed to make business decisions in a timely manner. ivi’s previous PostgreSQL-based data warehouse was used to manage all key statistics for content consumption and advertising placements and conversions, which were provided to ivi’s business partners, including advertisers and content copyright holders. Understanding exactly what content consumers want, when they want it and on which device is critical for ivi to develop an engaging online streaming service that effectively connects advertisers with the right audience. Ensuring accurate payments to copyright holders and advertisers by leveraging a more informative and flexible data analytics approach. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |