{"id":82,"date":"2010-01-20T03:45:55","date_gmt":"2010-01-20T09:45:55","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=82"},"modified":"2021-09-27T14:00:11","modified_gmt":"2021-09-27T19:00:11","slug":"basic-database-terms","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/basic-database-terms","title":{"rendered":"Basic Database and m-Power Terms"},"content":{"rendered":"

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

Database Terms<\/h3>\n\n\n\n\n\n\n
Database<\/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
Table<\/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
Column<\/td>\nA set of data values of a particular type, sometimes called a field.<\/td>\n<\/tr>\n
Row<\/td>\nA single structured data item in a table, representing a set of related data, sometimes called a record.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

m-Power Terms<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
m-Power<\/td>\nSoftware to automate application development and rapidly create powerful enterprise-class Web applications.<\/td>\n<\/tr>\n
Data Dictionary<\/td>\nA collection of tables and the applications built over them. It is an m-Power work environment.<\/td>\n<\/tr>\n
Application<\/td>\nA complete Web application created with m-Power, including interface screens, logic, and database access.<\/td>\n<\/tr>\n
Template<\/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
Retrieval<\/td>\nAn application that retrieves data from the database and displays it to a browser.<\/td>\n<\/tr>\n
Report<\/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
Summary<\/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
Maintenance<\/td>\nAn application that allows end users to insert, update, and delete data in database tables.<\/td>\n<\/tr>\n
Calculation<\/td>\nA work field in an application that is derived from database fields, system values, or external business logic.<\/td>\n<\/tr>\n
External 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
SmartLink<\/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
Synonyms<\/td>\nA field pair that can be used for joining tables and linking applications.<\/td>\n<\/tr>\n
m-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
End 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<\/tbody>\n<\/table>\n

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

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

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…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[247],"ht-kb-tag":[],"class_list":["post-82","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-getting-started"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/82","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=82"}],"version-history":[{"count":15,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/82\/revisions"}],"predecessor-version":[{"id":12336,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/82\/revisions\/12336"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=82"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=82"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=82"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}