Term
Data dictionary:
definition |
|
Definition
| A detailed description of all the data used in the database |
|
|
Term
Data dictionary:
can include: |
|
Definition
oName of item
oAliases/other names to describe item
oRange of values
oType (alpha/ numeric)
oAmount of storage for item
oNotation of who updates & various users
oList of reports that use data item
oDescription of data flows |
|
|
Term
Data dictionary:
they help: |
|
Definition
oMaintain an efficient database that eliminates redundancy & makes modification easy
oProgrammers create the code to access data |
|
|
Term
Data warehouse:
definition |
|
Definition
| A large database that collects business information from many sources in the enterprise, covering all aspects of the company’s processes, products, and customers, in support of management decision making |
|
|
Term
|
Definition
•Provide users with multidimensional view
•Allow managers to drill down for more detail or roll up for reports
•Specifically designed for decision making not transaction processing
-Stores historical data from operational systems and external data sources that is cleaned up
•Can accept data from RFID technology |
|
|
Term
Distributed processing:
definition |
|
Definition
| An approach to processing wherein processing devices are placed at remote locations but are connected to each other via a network |
|
|
Term
Distributed processing:
helps to |
|
Definition
oAllocate data to locations that can process most efficiently
oMinimized the consequences of a catastrophic event at one location while ensuring uninterrupted systems availability |
|
|
Term
Electronic funds transfer:
definition |
|
Definition
| A system of transferring money from one bank account directly to another without any paper money changing hands. |
|
|
Term
Electronic funds transfer:
used for: |
|
Definition
•Credit transfers (pyrl pymts)
•Debit transfers (mortgage pymts) |
|
|
Term
Electronic funds transfer:
benefits: |
|
Definition
oReduced administrative costs
oIncreased efficiency
oSimplified book-keeping
oGreater security |
|
|
Term
Electronic funds transfer:
2 primary components |
|
Definition
oWire transfer
oAutomated clearing house (ACH) |
|
|
Term
|
Definition
| A general class of people, places, or things for which data is collected, stored, and maintained |
|
|
Term
|
Definition
| A field or set of fields in a record that is used to identify the record. |
|
|
Term
Entity relationship (ER) diagrams:
definition |
|
Definition
| Data models that use basic graphical symbols to show the organization of the relationships between data |
|
|
Term
| Entity relationship (ER) diagrams: symbols of a diagram |
|
Definition
| •Boxes indicate data items contained in data tables •Diamonds show relationships between data items and ________ |
|
|
Term
|
Definition
| A simple database program whose records have no relationship to one another. |
|
|
Term
|
Definition
- Often used to store and manipulate a single table or file They do NOT use database models
- Many spreadsheets & word-processing programs have these capabilities
- Sort tables & make simple calculations & comparisons
|
|
|
Term
|
Definition
| A database model that describes data in which all data elements are placed in two-dimensional tables called relations, which are the logical equivalent of files. |
|
|
Term
|
Definition
| Manipulating data to combine two or more tables. One of the three basic data manipulations in a relational database. |
|
|
Term
| Metropolitan area network (MAN): |
|
Definition
| A telecommunications network that connects users and their computers in a geographical area that spans a campus or a city. Redefines many networks into a single larger network or connects several LANs into a single campus LAN. |
|
|
Term
|
Definition
| Software that allows various systems to communicate and exchange data. |
|
|
Term
|
Definition
•Often developed to address situations in which a company acquires different types of information systems through mergers, acquisitions, or expansion and wants the systems to share data and interact.
•Serves as interface between the internet and private corporate systems. |
|
|
Term
|
Definition
| A device that combines data from multiple data sources into a single output signal that carries multiple channels, thus reducing the number of communications links needed and lowering telecommunications costs. |
|
|
Term
|
Definition
| •Commonly used on long-distance phone lines, combining many individual phone calls onto a single long-dstance line without affecting speed or quality of an individual call. |
|
|
Term
Front-end processors:
definition |
|
Definition
| Special-purpose computers that manage communications to and from a large computer serving hundreds or even thousands of users. |
|
|
Term
| Front-end processors: they poll user devices to see if they: |
|
Definition
oHave messages to send
oFacilitate efficient, error-free communications
oPerform message and transaction switching
oProvide multiplexing and transaction security |
|
|
Term
Front-end processors:
They provide |
|
Definition
| end-to-end transaction management and reporting—important functions needed to support mission-critical transaction environments |
|
|
Term
Front-end processors:
relieves... |
|
Definition
| •Relieves the primary computer system of much of the overhead processing associated with telecommunications |
|
|
Term
Network management software:
definition |
|
Definition
| Software that enables a manager on a networked desktop to monitor the use of individual computers and shared hardware (such as printers); scan for viruses; and ensure compliance with software licenses. |
|
|
Term
Network management software:
functions |
|
Definition
•Simplifies process of updating files & programs on computers on the ntwrk
•Protects software from being copied, modified, or downloaded illeagally,
•Locate telecommunication errors and potential ntwk problems |
|
|
Term
Network management software:
benefits |
|
Definition
•Fewer hours spent on routine tasks
•Faster response to problems
•Greater overall ntwk cntl |
|
|
Term
| Object–oriented database: |
|
Definition
| A database that stores both data and its processing instructions |
|
|
Term
|
Definition
| In an object-oriented database, it is another word for procedure or action |
|
|
Term
| Object-oriented database management system (OODBMS) |
|
Definition
| A group of programs that manipulate an object-oriented database and provide a user interface and connections to other application programs. |
|
|
Term
|
Definition
| Design standard created by the Object Database Management Group for developing object-oriented database systems |
|
|
Term
Operating system (OS):
definition |
|
Definition
A set of computer programs that controls the computer hardware and acts as an interface with applications.
Can control one or more computers, or they can allow multiple users to interact with one computer. |
|
|
Term
Operating system (OS):
various combinations |
|
Definition
oSingle computer w/single user
oSingle computer w/multiple simultaneous users
oMultiple computers w/multiple users
oSpecial-purpose computers |
|
|
Term
Planned data redundancy:
definition |
|
Definition
| A way of organizing data in which the logical database design is altered so that certain data entities are combined, summary totals are carried in the data record rather than calculated from elemental data, and some data attributes are repeated in more than one data entity to improve database performance. |
|
|
Term
Planned data redundancy:
This is done.... |
|
Definition
| to improve the system performance so that user reports or queries can be created more quickly. |
|
|
Term
|
Definition
| Powerful tools for manipulating and analyzing numbers and alphanumeric data. |
|
|
Term
|
Definition
•Formulas
•Statistical analysis
•Built-in business functions,
•Graphics
•Limited database capabilities
•Optimization= a max or min constraint to figure desired result |
|
|
Term
|
Definition
Calculation of depreciation
Present value
Internal rate of return
Monthly payment on a loan |
|
|
Term
|
Definition
| The process of managing tasks through its life cycle. It involves planning, testing, tracking and reporting. It can help either individuals achieve goals, or groups of individuals collaborate and share knowledge for the accomplishment of collective goals. Tasks are also differentiated by complexity, from low to high. |
|
|
Term
| Very small aperture terminal (VSAT): |
|
Definition
A satellite ground station with a dish antenna smaller than 3 meters in diameter.
Sends a type of microwave transmission in a Wide Area Wireless Network. |
|
|
Term
|
Definition
| Visual programming uses a graphical or “visual” interface combined with text-based commands. |
|
|
Term
|
Definition
| Drag and drop can be used for graphical objects. Next, capabilities of those objects can be defined by using a programming language in a separate code window. The truest form of _____ programming ______ creates software by manipulating programming elements only graphically. |
|
|
Term
|
Definition
| Technology that enables users to send, receive, and store verbal messages to and from other people around the world. |
|
|
Term
| Workgroup application software: |
|
Definition
| Software that supports teamwork, whether team members are in the same location or dispersed around the world. |
|
|
Term
|
Definition
| •At the receiving end, a de_______ finds the correct destination |
|
|
