mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Summaries
  • What is a Summary and when should I use them?
Back to Manual

What is a Summary and when should I use it?

 

A Summary is an application that differs from all other application types because it does not display data on the screen, but rather writes the dataset back to the database in the form of a new table. Generally speaking, end users will never run a Summary, but instead Summaries will be scheduled to be run (hourly, nightly, monthly, etc.) so the data can be refreshed. Once the Summary has been run, it exists as a table like any other, available for use in Retrievals, Reports, or even Maintenance. While there are several uses for Summary applications, the three most common uses include:

· Optimization of large data sets — Perhaps the data set spans across many tables, or is comprised of millions of records. Alternatively, maybe a data set has non-unique fields that need to be unique (such as needed when creating an Web 2.0 Option List). In these situations, using a Summary to first "optimize" the data set prior to creating the desired application can help immensly.

· History tables — There may also be a business need within your company for audit trails of data, or storing volatile data that changes on a day to day basis. In these scenarios, creating a Summary can append to a single table in order to create a history, or audit view of your data.

· Duplicate tables — There could be times where it is needed to join a table to itself, or to join out to the same table twice. This is not allowed in m-Power, however creating a Summary over this table essentially duplicates the table, which would allow for this behavior. Note: While this works, bear in mind that Summary files are not "live" in the sense that they will not be updated when the underlying data is, but rather remain as is until the Summary application is re-run.

Learn more about Summaries by clicking here.

Created: October 31, 2013

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Tomcat Excel Dropdowns Summaries Record Selections Calculations Maintainer Administration Production Getting Started Java Data Dictionary SQL mrc-Productivity Series Bar Graphs Admin DB2 Email Application Properties Form Validation Build Process Reports Prompt Screens Dates Retrievals Video Retrieval Advanced Freemarker External Objects Database App Properties Graphs Report Compiling Graph Properties Parameters Popular Graphing RPG Bootstrap Templates Security Maintainers m-Painter Performance

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.