15K. A MicroStrategy cube is an in-memory copy of the results of an SQL query executed against your data warehouse. Some key benefits include: Mapbox maps use vector tiles instead of image tiles used by many competitors, which enables much smoother and more customizable zooming. Select an Environment from the upper-left drop-down. Once an Intelligent cube is created and then published. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Strong semantic layer to define all the business rules and tightly coupled. Public folder or a specific user folder can be selected for the creation of intelligent cubes in MicroStrategy. 3. • Created Intelligent Cubes and performed sharing to reduce the database load and decreasing the report execution time by using the cube services. This can be done by selecting Run Report in the toolbar. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. 50. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Following are the features, which make intelligent cubes useful. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". One of the key elements to providing analytical sophistication in business intelligence applications is MicroStrategy’s ability to generate multi-pass SQL. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. Restart the MicroStrategy Intelligence Server. To schedule the publication of Intelligent Cubes. Mention the features that are not supported by intelligent cube? Ans: Features that are not supported by intelligent cubes are: Prompt. e. idx file is cleaned up. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. The book starts by detailing. •Develop a future state pilot that demonstrates the enterprise-ready value of the MicroStrategy Intelligence Platform and. Click OK. 19. 4. 0. Companies of all sizes use this platform to assess, visualise, and build dashboards. The template level metric condition on Aggregate From Base derived metrics have been corrected, so it is no longer is ignored during Data Blending. At this point, the Month attribute can be removed from the cube to reduce the publication time and size of the Intelligent Cube within memory. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Expand Intelligent Cubes, and then select General. We will examine which of the two offers the best in each round and determine the overall winner at the end based on those results. 4, Command Manager script for listing. Mention what are the business benefits of Microstrategy Narrowcast Server? Ans: The business benefits of Microstrategy Narrowcast Server is that it provides an inexpensive way to send corporate information to. " maps to the Intelligence Server working directory (when using default locations, this will be C:\Program Files (x86)\MicroStrategy\Intelligence Server). Right-click a project and select Project Configuration. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. Run the Report and check the SQL View. 40. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Select data population for Intelligent Cubes. 39. Replace a slice of data in an Intelligent cube using a single incremental cube refresh step. From the Partition Attribute drop-down, select the partition attribute for the Intelligent Cube. Build a cube of customer data that’s relevant to all employees and publish it. It must be ensured that the Windows NT account used to run the MicroStrategy Intelligence Server on every node has access to the shared folders. 4. KB440835: In MicroStrategy 10. KB32540: Intelligent Cube Population methods in MicroStrategy. 16: Intelligent Cube dirty. Defining the partition for Super Cubes. Source: MicroRooster. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. Prerequisites to creating Intelligent Cubes. Under VLDB settings > Query Optimizations > Data Population for Intelligent Cubes admins need to test all the following options: - Normalize Intelligent Cube data in the database. This is set to 32,000 by default. 5 GB, the Data Transfer from Datasource(s) time is 77. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. For example, the attributes Year and Region and the metrics Cost and Revenue are included in the Intelligent Cube shown in the image above. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. 4. It will remain available, but the setting will not. Explain the process of creating intelligent cubes in MicroStrategy? Public folder or a specific user folder can be selected. Sharing data. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. MicroStrategy 2021 Update 9 introduces the ability to create Intelligent cube reports based on an Intelligent cube. Enable users to interact with personalized chat for further product discovery. Query Generation. They can save you time and make your Intelligent Cubes more effective for your reporting environment: Define your business query: Before you can determine what objects to place on an Intelligent. 3. Browse to the folder location to store Intelligent Cubes, and then click OK. Right-click the dataset, and choose Schedule. . 4. After a report. However, users. Con: The copy of report data in Intelligence Server memory only applies to a single report. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Stand out in a crowd. Choose Data > Configure Intelligent Cube. ACTION: A fix for this issue is included in MicroStrategy 10. This can improve the performance of. Intelligent Cubes are a more aggressive form of caching and allow multiple reports to be stored in the Cube (which is effectively a large cached report stored in memory on the. The solution discussed in this article is a python application that leverages the MicroStrategy API suite to provide an external scheduler, i. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. 8 and earlier using 'Live' Intelligent Cubes. Normalize Intelligent Cube data in the Database. Together with the Reports API, this API is often referred to as the JSON Data API. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. The default value is 256 megabytes. The MicroStrategy Intelligence Server 9. The Intelligent Cube Options dialog box opens. Traditionally, this type of requirement was hard to achieve as there was not an event that could be triggered right after the execution of an. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Find out what your peers are saying about Microsoft, Tableau, Amazon and others in BI (Business Intelligence) Tools. From the Administration menu, point to Scheduling, and then select Subscription Creation Wizard. The Intelligent Cube Monitor provides information about published Intelligent Cubes, as well as Intelligent Cube usage statistics. NAME: The name of the Intelligent Cube, returned as a string. Overview. More about Feature flags can be found in this article. MicroStrategy 9. 20. 2, when an Intelligent Cube is published, it is loaded into memory only on the node where the cube is published. 4. MicroStrategy is an enterprise BI application software. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Choose File > New > Report. Sharing data. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesExpand Intelligent Cubes, and then select General. ACTION This issue was reviewed by our Technology team for feasibility and will not be scoped for a code fix in any upcoming MicroStrategy release. MicroStrategy vs. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. They have to log into the platform. The. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. Dynamic Sourcing. It turns data into reports for making and executing key organization decisions. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 1 or above, to pick up the fix, enable project level setting "Data Engine. the project configuration: ACTION . In MicroStrategy Developer, log into a project as a user with full administrative privileges. The MicroStrategy platform uses a single common metadata for consistency and streamlined maintenance. The New Grid dialog box opens. Users don’t have to mention the cube to which they want to connect. The Full Refresh option is the default. Defining Intelligent Cube refresh settings. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The Intelligent Cube is opened in the Report Editor. Prerequisites to creating Intelligent Cubes. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. Typically, a long duration is seen in the Data Transfer time which indicates the time it takes to fetch data from the warehouse. KB47254: How to create a subscription to refresh Intelligent Cubes using MicroStrategy Command Manager 9. Providing Intelligent Cube data. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. 20. In either case, the Intelligence Server is responsible for determining the lists of distinct attribute elements, and this operation is always case sensitive. It allows users to customize data visualizations and build personalized real-time dashboards. If you are upgrading to MicroStrategy 11. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Incentivized. An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Both products' features range. The Report Editor opens. 4: Persisted. These VLDB properties control the method by which the report data are normalized. Following are the methods by which we can reflect it in 3 tier. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. x environments. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. Browse to and select a previously saved Intelligent Cube on which to build your report. This will reduce the memory usage from 150GB to 100GB. Multi-pass SQL is required to answer analytical questions that cannot be. Select other schedule options as required, and click OK. Right-click the project and select Project Configuration. Watch the Product team review. 0. Instead of always executing against the data warehouse. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. This defect is addressed in MicroStrategy 11. From the Data menu, select Configure Intelligent Cube. You can also supply a MicroStrategy Enterprise Manager file to include more information on the performance benefits of each Intelligent Cube. Recommends Intelligent Cube definitions for Intelligent Cubes that could be connected to by reports using dynamic sourcing. HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer. The solution has a very non-logical user usage part. The most obvious workflows where you can expect to see performance improvements: Project loading during MicroStrategy Intelligence server startup Intelligent cubes are generated automatically when a new report is run against the data warehouse. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. Users don’t have to mention the cube to which they want to connect. xCreate Intelligent Cube Reports. You may have an existing entry, other than unlimited. Using the Tableau connector since MicroStrategy 2019 Update 2 requires the Use Application Tableau privilege. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Recommends and creates Intelligent Cubes that could provide data to reports using dynamic sourcing. If the Intelligent Cube must be re-processed based on a metric. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Project Configuration: Intelligence Cubes -> General 2. All the data requirements of a. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. ACTION:The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. In versions prior to MicroStrategy Intelligence Server 9. Intelligent Cubes are part of the OLAP Services features in Intelligence Server. Published: Jun 1, 2017. Defining the partition for Super Cubes. Learn more about it at MicroStrategy. Performed system checks like licensing, functionality, managing user privileges of the system. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Set the path for the cube cache file directory to . (Intelligent Cube configuration is not relevant in MicroStrategy 8. This can. An Intelligent Cube is an In-Memory data structure which. In the Drilling area, clear the Use default settings check box. MicroStrategy Web is composed of a multi-layered architecture that clearly separates functionality from presentation. 4. In most cases, the automation in the semantic layer provides more considerable resource savings than maintaining multiple custom SQL query Intelligent Cubes in memory that do not relate to each other. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. Intelligent Cube Technology is used by MicroStrategy. Before 10. In the Data Source column, select the checkboxes for the tables to update. Installed, upgraded and managed MicroStrategy 7. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. Please also see this article for more details: Data Engine changes in MicroStrategy 2021 release Acronym used: "CSI", which stands for "Cube Subsetting Instruction". Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. For example, analyzing the MicroStrategy Tutorial project creates a Cube Advisor results file named MicroStrategy Tutorial. You can also define when Intelligent Cubes. Select Intelligent Cubes > General > Intelligent Cube File directory. arrow_forward Explore the use of computational systems in the field of artificial intelligence and machine learning,. If an attempt to load an Intelligent Cube is made that would exceed the limit, an Intelligent Cube is removed from Intelligence Server memory before the new Intelligent Cube is loaded into memory. 49. Cube Advisor provides the following features for creating and supporting a dynamic sourcing strategy: Analyzes reports to determine if their report definitions can support the use of dynamic sourcing. 3 - Check the Make Intelligent. Publish the cube. Intelligent cubes are generated automatically when a new report is run against the data warehouse. If you do not use connection mapping, leave this check box cleared. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. HIDDEN: Whether or not the Intelligent Cube is hidden, returned as a boolean value. 6, when users created a Dashboard or a Document using a Connect-Live Cube, using Metric Qualification with an output level that is lower than the template level and created at least 2 layers of nested aggregation on top of the cube metrics, the iServer crashes. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. Normalize Intelligent Cube data in the Database using. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. To publish an Intelligent Cube, see. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Cube Advisor provides the following features for creating and supporting a dynamic sourcing strategy: Analyzes reports to determine if their report definitions can support the use of dynamic sourcing. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. Telcos using MicroStrategy can run. Right-click the dataset, and choose Schedule. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. This status can appear due to an environment issue such as the network, database connection, or a PC resource usage issue. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. The Intelligent Cube Options dialog box opens. In the left panel, click Cubes. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. The Report Editor opens. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. What are the advantages of cubes in MicroStrategy? Ans: The advantages of cubes are: Supports derived metric creations;. Run a dossier based on the cube. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. The Intelligent Cube Options dialog box opens. Right-click an Intelligent Cube and select Delete. ACTION: This issue has been fixed in MicroStrategy 10. To effectively create a HyperIntelligence dataset, your data must have attributes with either one-to-one relationships or many-to-one relationships. Cube Advisor opens. The first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. By default, the report template used is the same as the Intelligent Cube's template. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Intelligent Cube file directory Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. 3. com Format: A MicroStrategy Online Training Video blog. Import and filter data from a OlapCube, SuperCube or Report into a Pandas DataFrame (see code. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. table_name: is the name of a table. Flex Builder 3 support for creating powerful Internet applications with robust business intelligence. Number of Views 1. Choose File > New > Intelligent Cube. Use Case 4. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Micro Strategy also supports mobile BI. MicroStrategy administrators can automatically ensure that business users always have the most current information by configuring the Intelligent Cube data to expire or. L’éditeur Cube intelligent permet de contrôler les propriétés avancées. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. the scheduler that manages the data lake updates, the ability to initiate an on-demand cube refresh immediately after the data lake update is complete. These segments, called partitions, are processed simultaneously, distributed across the processor cores of your Intelligence Server. Users don’t have to mention the cube to which they want to connect. Then the warehouse will have to repeat similar calculations for each report. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. KB255633. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. Provides the last Intelligent cube size in KB recorded by the Intelligence Server. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. What are advantages of cubes? It perform fast; It Schedule the Cube; It is used for Drilling; It helps in Data Sharing; 41. In the Drilling area, clear the Use default settings check box. · Update the schema in 2-tier and reload the project from the Project Monitor. You must belong to the System Administrators group to use this feature. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. Creates the Intelligent Cubes you decide should be created. The ability to view or edit certain settings is determined by a user's privileges. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . ; In-depth knowledge of fundamental data warehousing concepts such as entity relational modelling, dimensional modelling, star and snowflake schemas, modelling data marts, front and back room architectures, security and. Since accessing Intelligent Cubes for OLAP analysis does not require runtime processing on the data warehouse and can use schedules to reduce IT management, users have. Drive revenue growth with memorable app workflows and AI features that really speak to the user. Pros and Cons. Easily add or change pre- and post- SQL statements. Cube index generation will increase cube size. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. blogspot. In MicroStrategy Web 9. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. This report is prompted on time. 2987. The default value is 256 megabytes. Provides information about how many jobs were executed, with numbers of hits for caches and Intelligent Cubes. CAUSE: This is a known issue in MicroStrategy 10. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. However, Intelligent cube publishing performance may be affected with the agent enabled. In the left pane, click Intelligent Cubes. This means any report you create will have caching enabled by default. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. In Developer, log in to a project with a user account with administrative privileges. 3. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. What are the features which the Intelligence cube doesn’t support generally? This is basically a trick question and is generally asked from those who have experience in the Microstrategy tool. OLAP services: Derived metrics and viewed filters cannot be supported. Multi-pass SQL . The. Case A: Security Filter attribute is related to attributes placed on the grid. Select other schedule options as required, and click OK. From these results it can be determined that the Month attribute is not being used within any of the view Reports, Documents, Dossiers that reference this Intelligent Cube. However, if the. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Create an Intelligent Cube with attributes Year, Month and Region; 4. For the time being the only suggestion we may offer is to not use both data base functions and intelligence cubes in conjunction. You can create and analyze new reports in real time. This copy of report data is stored in Intelligence Server memory only. Create a report based on above Cube and add the prompt in view filter. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. 46K. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. This article also provides a workaround to avoid this behavior. The Intelligent Cube Options dialog box opens. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Additionally, when using Teradata as MicroStrategy Metadata, the Teradata ODBC driver options should be set as follows. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions. number_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer. The following table summarizes the test results of some test scenarios against Oracle 19c. When these Intelligent Cubes are cached in memory, report manipulations, such as adding derived metrics and derived elements, formatting, and drilling within the Intelligent Cube, take considerably less time. This data can be used to create a. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. To Create a Report that Accesses an Intelligent Cube. Select a schedule from the Schedule drop-down list. Some of the obvious benefits of this tool are its excellent data analytics capabilities, extreme scalability, and superior results. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Using Database Write-back Functionality to Enable Decision-Making.