{"id":82,"date":"2010-01-20T03:45:55","date_gmt":"2010-01-20T09:45:55","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/legacy\/?page_id=82"},"modified":"2016-08-01T14:23:43","modified_gmt":"2016-08-01T19:23:43","slug":"basic-database-terms","status":"publish","type":"page","link":"https:\/\/www.mrc-productivity.com\/legacy\/getting-started\/basic-database-terms","title":{"rendered":"Basic Database and m-Power Terms"},"content":{"rendered":"

<\/p>\n

Basic Database and m-Power Terms<\/h1>\n

 <\/p>\n

Please review the following database and m-Power terms:<\/p>\n

Database Terms<\/strong><\/p>\n\n\n\n\n\n
<\/td>\nDatabase<\/td>\nA 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.<\/td>\n<\/tr>\n
<\/td>\nTable<\/td>\nA 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.<\/td>\n<\/tr>\n
<\/td>\nColumn<\/td>\nA set of data values of a particular type, sometimes called a field.<\/td>\n<\/tr>\n
<\/td>\nRow<\/td>\nA single structured data item in a table, representing a set of related data, sometimes called a record.<\/td>\n<\/tr>\n<\/table>\n

m-Power Terms<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/td>\nm-Power<\/td>\nSoftware to automate application development and rapidly create powerful enterprise-class Web applications.<\/td>\n<\/tr>\n
<\/td>\nData Dictionary<\/td>\nA collection of tables and the applications built over them. It is an m-Power work environment.<\/td>\n<\/tr>\n
<\/td>\nApplication<\/td>\nA complete Web application created with m-Power, including interface screens, logic, and database access.<\/td>\n<\/tr>\n
<\/td>\nTemplate<\/td>\nA program shell that defines the program layout and functionality. The template is combined with the application specifications to create a generated program.<\/td>\n<\/tr>\n
<\/td>\nRetrieval<\/td>\nAn application that retrieves data from the database and displays it to a browser.<\/td>\n<\/tr>\n
<\/td>\nReport<\/td>\nAn 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.<\/td>\n<\/tr>\n
<\/td>\nSummary<\/td>\nAn application that reads in data from existing tables and outputs to a brand new table, often useful for data warehousing.<\/td>\n<\/tr>\n
<\/td>\nMaintenance<\/td>\nAn application that allows end users to insert, update, and delete data in database tables.<\/td>\n<\/tr>\n
<\/td>\nCalculation<\/td>\nA work field in an application that is derived from database fields, system values, or external business logic.<\/td>\n<\/tr>\n
<\/td>\nExternal Object<\/td>\nAn 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.<\/td>\n<\/tr>\n
<\/td>\nSmartLink<\/td>\nA link between m-Power-generated applications that automatically passes appropriate parameters, for the purpose of creating larger, complex systems.<\/td>\n<\/tr>\n
<\/td>\nSynonyms<\/td>\nA field pair that can be used for joining tables and linking applications.<\/td>\n<\/tr>\n
<\/td>\nm-Power Users<\/td>\nPeople who can make applications with m-Power. Developers and business users familiar with their data can be m-Power Users.<\/td>\n<\/tr>\n
<\/td>\nEnd Users<\/td>\nThese are the users for which the m-Power Users develop applications. End Users run existing applications, but do not create their own.<\/td>\n<\/tr>\n<\/table>\n

Learn more about the m-Power Data Dictionary by clicking here<\/a>.<\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":58,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-82","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/82","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=82"}],"version-history":[{"count":13,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/82\/revisions"}],"predecessor-version":[{"id":8271,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/82\/revisions\/8271"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/58"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=82"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}