لطفا منتظر باشید ...
M
macro
A type of coding that is used like a function but actually consists of a set of instructions.
maintainability
A measure of the ease of maintaining a system.
Make Table query
A query (SQL statement) that creates a new table and then creates rows in it by copying rows from an existing table.
many-to-many relationship
A relationship between two tables in which rows in each table have multiple matching rows in the related table. Many-to-many relationships are maintained by using a third table called a junction table and by adding the primary key columns from each of the other two tables to this table.
many-to-one relationship
A relationship between two tables in which one row in one table can relate to many rows in another table.
MAPI
See Messaging Application Programming Interface (MAPI).
Master database
The database that controls the operation of each instance of SQL Server. This database installs automatically with each instance of SQL Server and keeps track of user accounts, remote user accounts, and remote servers with which each instance can interact. This database also tracks ongoing processes, configurable environment variables, system error messages, tapes and disks available on the system, and active locks.
master definition site
See Publisher.
master file
The file installed with earlier versions of SQL Server that is used to store the Master, Model, and Tempdb system databases and transaction logs and the pubs sample database and transaction log.
master site
See Distributor.
MDX
See multidimensional expressions (MDX).
measure
In a cube, a set of values that are based on a column in the cube's fact table and are usually numeric. Measures are the central values that are aggregated and analyzed. See also dimension.
measurement
In English Query, an option in the Adjective Phrasing dialog box. By using a measurement, you can specify some measurement that is represented in an entity.
media description
The text describing the media set. See also media set.
media family
All media in a set written by a single device (for example, an initial medium and all continuation media, if any). See also media set.
media header
A header that provides information about the backup media.
media name
The descriptive name for the entire backup media set.
media set
All media involved in a backup operation. See also media description, media family.
member
An item in a dimension representing one or more occurrences of data. A member can be either unique or nonunique. For example, 1997 and 1998 represent unique members in the year level of a time dimension, whereas January represents nonunique members in the month level because there can be more than one January in the time dimension if it contains data for more than one year. See also virtual dimension.
member delegation
A modeling concept that describes how interface members are mapped from one interface to another.
member group
A system-generated parent of a collection of consecutive dimension members. See also dimension.
member key column
A dimension level's property that specifies the identifiers of the members of the level. The value of this property can specify a column that contains the identifiers or an expression that evaluates to the identifiers. See also member name column, member variable.
member name column
A dimension level's property that specifies the names of the members of the level. The value of this property can specify a column that contains the names or an expression that evaluates to the names. See also member key column, member variable.
member property
Information about the members of a dimension level in addition to that contained in the dimension (for example, the color of a product or the telephone number of a sales representative). See also virtual dimension.
member variable
The value used internally by Analysis Services to identify a dimension member. The MemberKeyColumn property specifies the member variables for a dimension. For example, a number from one through 12 could be the member variable that corresponds to a month of the year. See also member key column, member name column.
memo
A type of column containing long strings of text, typically more than 255 characters. A memo is the Access equivalent of a SQL Server text data type.
merge
The operation that combines two partitions into a single partition.
merge replication
A type of replication that allows sites to make autonomous changes to replicated data (and, at a later time, merge changes and resolve conflicts when necessary). See also snapshot replication, transactional replication.
message number
A number that identifies a SQL Server 2000 error message.
Messaging Application Programming Interface (MAPI)
An e-mail application programming interface (API).
metadata
Information about the properties of data, such as the type of data in a column (numeric, text, and so on) or the length of a column. Metadata can also be information about the structure of data or information that specifies the design of objects such as cubes or dimensions.
method
A function that performs an action by using a COM object, as in SQL-DMO, OLE DB, and ActiveX Data Objects (ADO). See also Component Object Model (COM).
mining model
An object that contains the definition of a data mining process and the results of the training activity. For example, a data mining model can specify the input, output, algorithm, and other properties of the process and hold the information gathered during the training activity, such as a decision tree.
mining model training
The process that a data mining model uses to estimate model parameters by evaluating a set of known and predictable data. Also, this term refers to the act of causing a mining model to evaluate training data. See also training data set.
mirroring
The process for protecting against the loss of data due to disk failure by maintaining a fully redundant copy of data on a separate disk. Mirroring can be implemented at several levels: in SQL Server 2000, in the operating system, and in the disk controller hardware.
Mixed Mode
Combines Windows Authentication and SQL Server Authentication. Mixed Mode allows users to connect to an instance of SQL Server through either a Windows NT 4.0 or Windows 2000 user account or through a SQL Server login.
model
In English Query, a model is the collection of all information that is known about the objects in the English Query application. This information includes the specified database objects (such as tables, fields, and joins); semantic objects (such as entities, the relationships between them, and additional dictionary entries); and global domain default options.
Model database
A database installed with SQL Server that provides the template for new user databases. SQL Server 2000 creates a new database by copying in the contents of the model database and then expanding it to the size requested.
model dependency
A relationship between two or more models in which one model is dependent on the information of another model.
module
A group of objects in a project. You can move objects between modules in a project, thus organizing those objects for a dispersed development environment.
modulo
An arithmetic operator that provides the integer remainder after a division involving two integers.
MOLAP
See multidimensional OLAP (MOLAP).
money data type
A SQL Server system data type that stores monetary values from 2^63 (922,337,203,685,477.5808) through 2^63 1 (+922,337,203,685,477.5807) with accuracy to a ten-thousandth of a monetary unit.
multidimensional expressions (MDX)
A syntax used for defining multidimensional objects and querying and manipulating multidimensional data.
multidimensional OLAP (MOLAP)
A storage mode that uses a proprietary, multidimensional structure to store a partition's facts and aggregations or a dimension. The data of a partition is completely contained within the multidimensional structure. See also hybrid OLAP (HOLAP), relational OLAP (ROLAP).
multidimensional structure
A database paradigm that treats data not as relational tables and columns but as information cubes that contain dimension and summary data in cells. Each cell is addressed by a set of coordinates that specify a position in the structure's dimensions. For example, the cell at coordinates {SALES, 1997, WASHINGTON, SOFTWARE} would contain the summary of software sales in Washington in 1997. See also cube.
multiple inheritance
A modeling term that describes how an interface receives the characteristics of more than one parent interface.
multiple instances
Multiple copies of SQL Server running on the same computer. There can be one default instance, which can be any version of SQL Server. There can be multiple named instances of SQL Server 2000. See also default instance, named instance.
multithreaded server application
An application that creates multiple threads within a single process to service multiple user requests at the same time.
multi-user
The capability of a computer to support many users operating at the same time while providing the computer system's full range of capabilities to each user.
