OLAP Database Structure for Online Advertising Data Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database structures and front ends for online advertising data become cumbersome and slow to access as data volume increases, discouraging timely report generation for non-technical sales and marketing personnel.
Innovation Solution
An improved database structure utilizing an online analytical processing (OLAP) database with hierarchical tables and a user-friendly front end that allows dynamic selection of values, offloading processing to minimize data access time and adapt to changing data volumes.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If a conventional database structure is used to store online advertising data, then the database can store large volumes of consumer data, but data access time increases and report generation becomes slower as data volume grows
Solution Approach 1:
The patent segments the database into multiple tables with hierarchical relationships (e.g., consumer profiles, campaign data, demographic information stored in separate related tables). This segmentation allows the system to handle large data volumes by organizing data into manageable, interconnected units that can be accessed efficiently without loading entire datasets into memory.
Solution Approach 2:
The patent introduces a front-end interface layer that adds a new dimension to data access. This front end provides multiple access points and viewing angles (dimensions) for querying the database, allowing users to retrieve information from different hierarchical levels and perspectives without directly querying the underlying complex database structure, thereby reducing access time.
2Adaptability or versatility
If the number of selection choices in the front end increases to provide more comprehensive database access, then more data can be retrieved, but the front end becomes harder to use for non-technical personnel
Solution Approach 1:
The front end is designed with dynamic characteristics where the interface adapts to user needs and data states. Selection choices are dynamically generated based on user preferences, previous selections, and current data context, allowing the system to provide comprehensive data retrieval capabilities while maintaining simplicity for non-technical users through context-aware interface adjustments.
Solution Approach 2:
The patent introduces an intermediary layer between the user and the database that translates complex database queries into user-friendly interface interactions. This intermediary front end handles the complexity of data retrieval operations internally while presenting simplified selection options to users, bridging the gap between comprehensive data access needs and ease of operation requirements.
3Loss of information
If reports are generated from a large unstructured database, then comprehensive advertising analysis can be performed, but report generation takes longer and may miss timely deadlines
Solution Approach 1:
The patent implements preliminary action by pre-organizing database data into structured hierarchical tables with pre-defined relationships and indexes before report generation is requested. This preliminary structuring of data allows the reporting system to quickly retrieve and analyze relevant information without having to process unstructured data from scratch, maintaining comprehensive analysis capabilities while significantly improving report generation speed and timeliness.
Data Source
AI summary
In one embodiment, a method of analyzing online advertising information includes the steps of receiving consumer data from client computers, creating a database based on the consumer data, receiving user selected values from a front end, and extracting data from the database based on the user selected values. The front end may have a selection area with user selectable values that change depending on an initially selected value. In one embodiment, the database comprises an online analytical processing (OLAP) database.