MIS Glossary Terms

2. Variable length data type for holding character data.
5. Command used to remove an object from the database, such as a table or a view.
6. Re-define a temporary name for a column or a table in your query.
10. Concept of true or false or represented as 1 or 0.
13. The metadata modeling tool for building eReports in Cognos and contains data organized into packages
14. Linking two tables together on related field, so a query can retrieve data from two tables.
15. A keyword that means a SELECT statement will eliminate duplicate records from the result set.
16. Software application used for issue tracking and project management.
17. Reports only requiring a date range change and are NOT to be run on an ongoing basis.
19. Person through which report requests, questions and report issues are communicated to the MIS team.
20. SELECT query that is run inside another query.
21. Organized collection of structured information, typically modeled in rows and columns in a series of tables.

1. Function that takes many parameters and returns the first parameter that is not NULL.
3. Also referred to as eReports.
4. Oracle SQL function for joining two strings together.
7. Keyword that allows you to compare data on partial strings, often used in the WHERE clause with wildcards.
8. Column on a table where every value is not unique but it exists on another table as a primary key.
9. A dummy table in Oracle databases.
11. The act of saving a transaction to the database permanently.
12. Can be specified as one to one, one to many, or many to many. Refers to how many unique values are in a column.
18. Allows you to specify how the data should be grouped in the SELECT query’s output.