Az Eszterházy Károly Tanárképző Főiskola Tudományos Közleményei. 2004. Sectio Mathematicae. (Acta Academiae Paedagogicae Agriensis : Nova series ; Tom. 31)

RADVÁNYI , T. , Examination of the MSSQL server considering data insertion

Examination of the MSSQL server considering data insertion 71 Fields: ID Int (Identity) The subscriptors unique identifier. A serial number given by the system. Vnev Varchar(25) The subscribers family name (from the SVezeteknev table) Knev Var char (20) The subscribers christian name (from the Skeresztnev table) Lakhely Varchar(25) The city where he lives (from the SHelysegnev table) Utca Varchar(25) Street (from the SUtcanev table) SzulDatum Datetime Date of birth Szemig Char (8) ID Cards number (a randonly created series of characters) Telszam: phone numbers that belong to t lie costumers Fields: Tszam Char (12) Unique phone number IDElofiz Int, The ID of the subscriber, foreign key, have cpnnection with the Elofiz table. The connection between the two tables is one-more, as one subscriber may have more phone numbers, but one number can only belong to 1 subscriber. Hmod: Type of call (line, cell, inland) Fields: ID Int (Identity) Unique identifier, primary key, a serial number given by the system. Típus Varchar(20) To differentiate the many district numbers in the case of cell phones and to differentiate the line phone. Hungarian specific. Cel Varchar(l) The destination of the inland or foreign call. Forg: The t raffic table that serves as the base of test, storing information about the calls. Approximately 10 million items were inserted into this table during the test. It 11 will have a basic role during the experimentation of the requests.