ࡱ> XZW7 bjbjUU MB7|7|pEl $ PLZD _2lpb>B1111111$ 4 )62 2 2   "  1 1  "N-B z0 Pol ./0z0d/20_2&0T77z0 CS327 dbViZ title \* Mergeformat Use-Case Specification: Import Schema Version 1.1 Revision History DateVersionDescriptionAuthor22/Oct/021.0Draft for the Use Case of Loading the SchemaSonia KauraDecember 10, 20021.1Rename to Import Schema. Review by Brian Sidharta.Sonia Kaura/Abhay Sathe Table of Contents  TOC \o "1-3" \h \z  HYPERLINK \l "_Toc27277112" 1. Import Schema  PAGEREF _Toc27277112 \h 4  HYPERLINK \l "_Toc27277113" 1.1 Brief Description  PAGEREF _Toc27277113 \h 4  HYPERLINK \l "_Toc27277114" 2. Flow of Events  PAGEREF _Toc27277114 \h 4  HYPERLINK \l "_Toc27277115" 2.1 Basic Flow  PAGEREF _Toc27277115 \h 4  HYPERLINK \l "_Toc27277116" 2.2 Alternative Flows  PAGEREF _Toc27277116 \h 4  HYPERLINK \l "_Toc27277117" 2.2.1 No supported data source is available  PAGEREF _Toc27277117 \h 4  HYPERLINK \l "_Toc27277118" 2.2.2 Import of Schema fails (Implemented by extension or specialization use cases)  PAGEREF _Toc27277118 \h 4  HYPERLINK \l "_Toc27277119" 3. Special Requirements  PAGEREF _Toc27277119 \h 4  HYPERLINK \l "_Toc27277120" 3.1 Response time  PAGEREF _Toc27277120 \h 4  HYPERLINK \l "_Toc27277121" 4. Preconditions  PAGEREF _Toc27277121 \h 5  HYPERLINK \l "_Toc27277122" 4.1 Availability of Data Source  PAGEREF _Toc27277122 \h 5  HYPERLINK \l "_Toc27277123" 5. Post conditions  PAGEREF _Toc27277123 \h 5  HYPERLINK \l "_Toc27277124" 5.1 The Schema in dbViZ  PAGEREF _Toc27277124 \h 5  HYPERLINK \l "_Toc27277125" 6. Specialization Points  PAGEREF _Toc27277125 \h 5  HYPERLINK \l "_Toc27277126" 6.1 Import from a flat SQL file  PAGEREF _Toc27277126 \h 5  HYPERLINK \l "_Toc27277127" 6.2 Import from a Database  PAGEREF _Toc27277127 \h 5  HYPERLINK \l "_Toc27277128" 7. Extension points  PAGEREF _Toc27277128 \h 5  HYPERLINK \l "_Toc27277129" 7.1 Load Saved ER Diagram  PAGEREF _Toc27277129 \h 5  title \* Mergeformat Use-Case Specification: dbViZ Import Schema Brief Description This use case describes the user level operation of the system when the user wants to import a Schema from a data source such as an SQL file or an Oracle database Flow of Events Basic Flow The user Selects File->Import Schema.. from the Menu dbViZ shows a list of all supported and available data sources, ad offers a choice to select one of them. The user selects one of the data sources and clicks OK. The appropriate dialog for connecting to the data source opens. If we were importing from SQL file, the dialog would be a file-browsing dialog. If the source is a live database, dbViZ needs to connect to a database. (The dialog then will prompt for location and authentication information) (Implemented by the Extension or specialization use case) The user enters appropriate information and clicks Import. (Implemented by the Extension or specialization use case) dbViZ shows progress and status of the import operation. Alternative Flows No supported data source is available 2a. The dbViZ supports a limited set of data sources. Each supported data source needs to be registered with dbViZ. 2a1: The choice list for the data source selection is empty. 2a2: User is shown a warning about no source being available and a pointer on how to add data source support is displayed. Import of Schema fails (Implemented by extension or specialization use cases) 6a: Schema import can fail due to a number of reasons, including, but not limited to, incorrect authentication information, corrupted file or data source, Unsupported file format for SQL file, Number of entities in Schema beyond the supported limit of dbViZ etc. 6a1. dbViZ displays a status window that lists the cause of schema import failure 6a2. User is brought back to step 1. Special Requirements Response time The system should import the data in a reasonable time (<30 seconds). Progress bar should be shown while importing to alleviate user anxiety (this is implemented in extension or specialization use cases) Preconditions Availability of Data Source A data source (SQL file in the supported format or Database) exists. Post conditions The Schema in dbViZ After the successful completion of the use case, a schema containing one or more tables exists in the dbViZ. The list of tables is visible. Specialization Points The following two use cases are specializations of the generic Import Schema use case Import from a flat SQL file This use case is executed if the user selects an SQL file from the choice list of available data sources. The dialog shown is a file-browsing dialog Import from a Database This use case is executed if the user selects a Database from the choice list of available data sources. The dialog shown is a dialog for specifying location and authentication information. Extension points One special use case exists as an extension point Load Saved ER Diagram This use case shows the user saving an ER Diagram created from the imported schema. The save operation allows the user to save partially complete work of drawing a good ER-Diagram so he/she can return to he work later and start where he/she left off. CS327 dbViZ subject \* Mergeformat Database Visualizer Version: 1.1title \* Mergeformat Use-Case Specification: dbViZ Date: 10/dec/02UseCase:ImportSchema Publicsymbol 211 \f "Symbol" \s 10 DOCPROPERTY "Company" \* MERGEFORMAT UIUC CS327,  DATE \@ "yyyy" 2002Page page 5   #$IJLXnWXlmnoനനxjqUmHnHu&j>*B*UmHnHphuj{UmHnHujUmHnHumHnHuCJaJmHnHu&j>*B*UmHnHphu mHnHu0J/mHnHuj0J/UmHnHu5CJ jU/ KLXYZ[\]ns{ $$Ifa$$a$p 89:o iiiioiiiioi$If$$Ifl\ $  04 la :;<=>?@ABCDWiige$$Ifl\ $  04 la$If Wf w c f  j % y   / 1$1$. @  123467EFG`abcdefghԺԲԐԲj]UmHnHu&j>*B*UmHnHphujgUmHnHumHnHu&j>*B*UmHnHphu mHnHu0J/mHnHuCJaJmHnHuj0J/UmHnHujUmHnHu+     ()*+01VWXqrstuvwxyŹūŹץבŹŃŹץoŹ&j>*B*UmHnHphujIUmHnHu&j>*B*UmHnHphu mHnHujSUmHnHujUmHnHumHnHuCJaJmHnHu0J/mHnHuj0J/UmHnHu&j>*B*UmHnHphu+     ()*+-.BCD]^_`abcdeѿѿǿѿѿǿuѿj+UmHnHu&j>*B*UmHnHphuj5UmHnHu&j>*B*UmHnHphu mHnHu0J/mHnHuCJaJmHnHuj0J/UmHnHujUmHnHuj?UmHnHumHnHu.         # $ % & ) * E F G ` a b c d e f g h ĸĪĸĸĂĸn&j >*B*UmHnHphuj UmHnHu&j >*B*UmHnHphu mHnHuj! UmHnHujUmHnHumHnHuCJaJmHnHuj0J/UmHnHu&j>*B*UmHnHphu0J/mHnHu+       . / 0 1 3 4 I J K d e f g h i j k ооƾооƾtj UmHnHu&j~ >*B*UmHnHphuj UmHnHu&j >*B*UmHnHphu mHnHu0J/mHnHuCJaJmHnHuj0J/UmHnHuj UmHnHumHnHujUmHnHu-k l     ! " # $ % & ' B C D E G H n&j`>*B*UmHnHphujUmHnHu&jj>*B*UmHnHphuj UmHnHujUmHnHumHnHuCJaJmHnHuj0J/UmHnHu&jt >*B*UmHnHphu mHnHu0J/mHnHu+H X Y Z s t u v w x y z {  GprȾȾ~wtCJ 6B*ph5\6] jUjCJOJQJUjUmHnHu&jV>*B*UmHnHphu mHnHuCJaJmHnHuj0J/UmHnHujUmHnHujUmHnHumHnHu0J/mHnHu+ " a "G+90u'1$^`1$1$ & F'=G^-_upqr~ oD($If]D$If $&dPa$ $dN1.^r~345QRSU|}0JmHnHu0J j0JU mHnHuOJQJ jUCJ5CJ$OJQJ&*+,X8V$$Ifl$V%04 la$Ifi$$Ifl0$k 04 la+,-4b`Z^|$$IflF H$Z Z Z 0    4 la $$Ifa$ $$Ifa$ h$If]h &0P/ =!"#$%0#0 P/ =!"#$%{DyK  _Toc27277112{DyK  _Toc27277112{DyK  _Toc27277113{DyK  _Toc27277113{DyK  _Toc27277114{DyK  _Toc27277114{DyK  _Toc27277115{DyK  _Toc27277115{DyK  _Toc27277116{DyK  _Toc27277116{DyK  _Toc27277117{DyK  _Toc27277117{DyK  _Toc27277118{DyK  _Toc27277118{DyK  _Toc27277119{DyK  _Toc27277119{DyK  _Toc27277120{DyK  _Toc27277120{DyK  _Toc27277121{DyK  _Toc27277121{DyK  _Toc27277122{DyK  _Toc27277122{DyK  _Toc27277123{DyK  _Toc27277123{DyK  _Toc27277124{DyK  _Toc27277124{DyK  _Toc27277125{DyK  _Toc27277125{DyK  _Toc27277126{DyK  _Toc27277126{DyK  _Toc27277127{DyK  _Toc27277127{DyK  _Toc27277128{DyK  _Toc27277128{DyK  _Toc27277129{DyK  _Toc272771292 i:@: Normal 1$d_HmH sH tH \@\ Heading 1'$ & F0x<@&^`05CJOJQJ4@4 Heading 2  & F@&CJ:@: Heading 3  & F@& 56CJ88 Heading 4  & F@&5CJDD Heading 5 & F@ <@&^@ CJHH Heading 6 & F@ <@&^@ 6CJ@@ Heading 7 & F@ <@&^@ DD Heading 8 & F@ <@&^@ 6J J Heading 9 & F@ <@&^@ 56CJ<A@< Default Paragraph FontHOH Paragraph2$P^a$B*mH sH u:>@: Title$da$5CJ$OJQJHJ@H Subtitle $<a$6CJ$OJQJmH sH u>@"> Normal Indent|^`|6`6 TOC 1 $<]6`6 TOC 2 $]^2`2 TOC 3 $`^`,@b, Header  !, @r, Footer  !&)@& Page Number@O@ Paragraph3$dP^a$@O@ Paragraph4$dP^a$.O. Tabletext $x6B@6 Body Text$x^&`& TOC 4 X^X&`& TOC 5  ^ &`& TOC 6 ^&`& TOC 7 ^&`& TOC 8 !x^x&`& TOC 9 "@^@O2 Bullet1p# & FP>T?^`POB Bullet2p$ & F>Th?^`B* 8Y@R8 Document Map%-D OJQJ<&@a< Footnote ReferenceCJH*^@r^ Footnote Text&'$$h((&d^h` CJOJQJPOP Main Title($d<a$5CJ KHOJQJ8O8 Paragraph1)$dPa$0P@0 Body Text 2*6B*FC@F Body Text Indent +^ 6>*B*@O@ Body,$dx1$a$OJQJtH uZOZ Bullet4-$ & FQ hdx1$]h^a$OJQJ6O6 InfoBlue.x^6B*(U@( Hyperlink>*B*L^@L Normal (Web)0ddd1$[$\$CJaJDR@D Body Text Indent 2 1^]]B(B KLXYZ[\]ns{ 89:;<=>?@ABCDWf w cfj%y /" a " G +90u'=G^-_up*+,-400000000`000000000000000000000000000000000000000000000000.0 0 00 0 0 0 0 0 0 0 0 0( 0 0 0 0 0 ( 0 0G 0G 0G  0 00+0+ 0 00 0 0uu0 00P 0PP.0 0PP10p 00E 0EE0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0@0 0DDDG k H r:W '+  #IWlm3Facdf  *Wrtuw  *C^`ac%Facdf 0Jeghj "#%DYtvwy  tX%tX%tX%tX%tX%tX%tX%tX%tX%tX%tX%tX%tX%tX%tX%tX%tX%tX%t̕*>Zq +07=?G9UT! _Toc423410237 _Toc425054503 _Toc423410238 _Toc425054504 _Toc27277112 _Toc27277113 _Toc423410239 _Toc425054505 _Toc27277114 _Toc423410240 _Toc425054506 _Toc27277115 _Toc423410241 _Toc425054507 _Toc27277116 _Toc27277117 _Toc27277118 _Toc423410251 _Toc425054510 _Toc27277119 _Toc27277120 _Toc423410253 _Toc425054512 _Toc27277121 _Toc27277122 _Toc27277123 _Toc27277124 _Toc27277125 _Toc27277126 _Toc27277127 _Toc27277128 _Toc27277129   G +u'G_   ... ***8/<],tp)  &p3Wkt$&==1>DHoppr} )-34abhayoC:\users\abhay\ntu\SE510Q - Software Engineering\Project_dbViZ\ElaborationDocs\useCases\ImportSchemaUseCase.docabhaylC:\Documents and Settings\abhay\Application Data\Microsoft\Word\AutoRecovery save of ImportSchemaUseCase.asdabhaylC:\Documents and Settings\abhay\Application Data\Microsoft\Word\AutoRecovery save of ImportSchemaUseCase.asd SG" p  m :D" NcK- E,1 Q+2 Hu3}tqT6 {B pI +sdO NsR F}/m *q 6t Pau |wl4{ @.@.@..@...@ ....@ .....@ ......@ .......@ ........* hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo( hh^h`OJQJo(h^`.hpp^p`.h@ L@ ^@ `L.h^`.h^`.hL^`L.h^`.hPP^P`.h L ^ `L. hh^h`OJQJo(Hu34{NsR+sdOlSG"Paup qT6Q+26tE,1m*qpI:D"{BNcK-F}/m|w@h 8^8`OJQJo(x @h ^`OJQJo(         ]ns{ 89:;<=>?@ABCp*+-4@%%t%%@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New5& z!Tahoma;& z HelveticaABook Antiqua"Ah*PlFsRlF:H^.\ Im"20d 2QfC:\users\abhay\ntu\SE510Q - Software Engineering\Project_dbViZ\ElaborationDocs\useCases\rup_ucspec.dot%Use-Case Specification: Import SchemaDatabase Visualizer Sonia KauraabhayOh+'0 0 @L h t  &Use-Case Specification: Import Schemat Database Visualizer Sonia Kauraonionirup_ucspec.dotiabhaysp58aMicrosoft Word 9.0@ @@}@2BQl^.՜.+,D՜.+,l( px   CS327 -dbViZ2d\ &Use-Case Specification: Import Schema Title 8@ _PID_HLINKSAl5k _Toc272771295e _Toc272771285_ _Toc272771275Y _Toc272771265S _Toc272771255M _Toc272771245G _Toc272771235A _Toc272771225; _Toc2727712155 _Toc272771206/ _Toc272771196) _Toc272771186# _Toc272771176 _Toc272771166 _Toc272771156 _Toc272771146  _Toc272771136 _Toc27277112  !#$%&'()*,-./0123456789:;<=>?@ABCDEFHIJKLMNPQRSTUVYRoot Entry F!ol[Data "L1Table+7WordDocumentMBSummaryInformation(GDocumentSummaryInformation8OCompObjjObjectPool!ol!ol  FMicrosoft Word Document MSWordDocWord.Document.89q