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
  • Starting with m-Power
  • Basic Database and m-Power Terms
Back to Manual

Basic Database and m-Power Terms

 

Please review the following database and m-Power terms:

Database Terms

Database A collection of stored data in a structured format. A Data Dictionary is a collection of tables and fields and the applications you build over them. It is your m-Power work environment.
Table A set of data values that is organized using a model of vertical columns and horizontal rows. A table is analogous to a spreadsheet document, like those maintained by Microsoft Excel.
Column A set of data values of a particular type, sometimes called a field.
Row A single structured data item in a table, representing a set of related data, sometimes called a record.

m-Power Terms

m-Power Software to automate application development and rapidly create powerful enterprise-class Web applications.
Data Dictionary A collection of tables and the applications built over them. It is an m-Power work environment.
Application A complete Web application created with m-Power, including interface screens, logic, and database access.
Template A program shell that defines the program layout and functionality. The template is combined with the application specifications to create a generated program.
Retrieval An application that retrieves data from the database and displays it to a browser.
Report An application similar to a retrieval that includes additional features like a prompt page for selecting runtime parameters, the ability to list data at detail/subtotal/grand total levels, graph the data set, output to various formats, and run in batch processes.
Summary An application that reads in data from existing tables and outputs to a brand new table, often useful for data warehousing.
Maintenance An application that allows end users to insert, update, and delete data in database tables.
Calculation A work field in an application that is derived from database fields, system values, or external business logic.
External Object An outside function that executes business logic. It might accept parameters from the application and return values to the calling application. It can be written in any high-level language like SQL, Java, C, COBOL, or RPG.
SmartLink A link between m-Power-generated applications that automatically passes appropriate parameters, for the purpose of creating larger, complex systems.
Synonyms A field pair that can be used for joining tables and linking applications.
m-Power Users People who can make applications with m-Power. Developers and business users familiar with their data can be m-Power Users.
End Users These are the users for which the m-Power Users develop applications. End Users run existing applications, but do not create their own.

Learn more about the m-Power Data Dictionary by clicking here.

Created: January 20, 2010 | Modified: August 1, 2016

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

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

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.