📄 booksellanalysis.asdatabase
字号:
<Name>Price</Name>
<SourceColumnID>Price</SourceColumnID>
</Column>
</Columns>
</MiningModel>
</MiningModels>
</MiningStructure>
<MiningStructure>
<ID>BookAssociation</ID>
<Name>BookAssociation</Name>
<CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
<LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
<Annotations>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>
<Value>dbo_Customer</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
<Value>true</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>
<Value>
<dds xmlns="">
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-4446" scrolltop="-1116" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="12356" y="15055" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_BookSell (dbo.V_BookSell)" left="20" top="7400" logicalid="1" controlid="1" masterid="0" hint1="0" hint2="0" width="3000" height="5000" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000b80b000088130000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dbo_V_BookSell" vartype="8" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Customer (dbo.Customer)" left="20" top="0" logicalid="2" controlid="2" masterid="0" hint1="0" hint2="0" width="3000" height="5000" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000b80b000088130000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dbo_Customer" vartype="8" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="1121" top="4501" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="3199" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobj>
<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="dataSet.Relations[V_BookSell-Customer]" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="1" sourceattachpoint="5" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
<point x="1520" y="5000" />
<point x="1520" y="7400" />
</connector>
</ddscontrol>
</dds>
</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>
<Value>false</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>
<Value>true</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>
<Value>-4446</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>
<Value>-1116</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>
<Value>20</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>
<Value>0</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>
<Value>100</Value>
</Annotation>
</Annotations>
<LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
<State>Unprocessed</State>
<Source xsi:type="DataSourceViewBinding">
<DataSourceViewID>Book Sell</DataSourceViewID>
</Source>
<Columns>
<Column xsi:type="ScalarMiningStructureColumn">
<ID>ID</ID>
<Name>ID</Name>
<IsKey>true</IsKey>
<Type>Long</Type>
<Content>Key</Content>
<KeyColumns>
<KeyColumn>
<DataType>Integer</DataType>
<DataSize>-1</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_Customer</TableID>
<ColumnID>ID</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
</Column>
<Column xsi:type="TableMiningStructureColumn">
<Annotations>
<Annotation>
<Name>MDXFilterComponent</Name>
</Annotation>
</Annotations>
<ID>V Book Sell</ID>
<Name>BookSell</Name>
<ForeignKeyColumns>
<ForeignKeyColumn>
<DataType>Integer</DataType>
<DataSize>-1</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_V_BookSell</TableID>
<ColumnID>CustomerID</ColumnID>
</Source>
</ForeignKeyColumn>
</ForeignKeyColumns>
<Columns>
<Column xsi:type="ScalarMiningStructureColumn">
<ID>Book ID</ID>
<Name>Book ID</Name>
<IsKey>true</IsKey>
<Type>Long</Type>
<Content>Key Sequence</Content>
<KeyColumns>
<KeyColumn>
<DataType>Integer</DataType>
<DataSize>-1</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_V_BookSell</TableID>
<ColumnID>BookID</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
</Column>
<Column xsi:type="ScalarMiningStructureColumn">
<ID>Name</ID>
<Name>Name</Name>
<Type>Text</Type>
<Content>Discrete</Content>
<KeyColumns>
<KeyColumn>
<DataType>WChar</DataType>
<DataSize>256</DataSize>
<Source xsi:type="ColumnBinding">
<TableID>dbo_V_BookSell</TableID>
<ColumnID>Name</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
</Column>
</Columns>
</Column>
</Columns>
<MiningModels>
<MiningModel>
<ID>BookAssociation</ID>
<Name>BookAssociation</Name>
<CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
<LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
<LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
<State>Unprocessed</State>
<Algorithm>Microsoft_Sequence_Clustering</Algorithm>
<AlgorithmParameters>
<AlgorithmParameter>
<Name>CLUSTER_COUNT</Name>
<Value xsi:type="xsd:int">0</Value>
</AlgorithmParameter>
</AlgorithmParameters>
<Columns>
<Column>
<ID>ID</ID>
<Name>ID</Name>
<SourceColumnID>ID</SourceColumnID>
<Usage>Key</Usage>
</Column>
<Column>
<ID>V Book Sell</ID>
<Name>BookSell</Name>
<SourceColumnID>V Book Sell</SourceColumnID>
<Columns>
<Column>
<ID>Book ID</ID>
<Name>Book ID</Name>
<SourceColumnID>Book ID</SourceColumnID>
<Usage>Key</Usage>
</Column>
<Column>
<ID>Name</ID>
<Name>Name</Name>
<SourceColumnID>Name</SourceColumnID>
<Usage>Predict</Usage>
</Column>
</Columns>
</Column>
</Columns>
<AllowDrillThrough>true</AllowDrillThrough>
</MiningModel>
</MiningModels>
</MiningStructure>
</MiningStructures>
<DataSources>
<DataSource xsi:type="RelationalDataSource">
<ID>Book Sell</ID>
<Name>Book Sell</Name>
<CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
<LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
<ConnectionString>Provider=SQLNCLI.1;Data Source=GLZ;Integrated Security=SSPI;Initial Catalog=BookSell</ConnectionString>
<ConnectionStringSecurity>Unchanged</ConnectionStringSecurity>
<ImpersonationInfo>
<ImpersonationMode>ImpersonateServiceAccount</ImpersonationMode>
<ImpersonationInfoSecurity>Unchanged</ImpersonationInfoSecurity>
</ImpersonationInfo>
<Timeout>PT0S</Timeout>
</DataSource>
</DataSources>
<DataSourceViews>
<DataSourceView>
<ID>Book Sell</ID>
<Name>Book Sell</Name>
<CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
<LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
<Annotations>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
<Value>true</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CurrentLayout</Name>
<Value>_ALL_TABLES_</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:NameMatchingCriteria</Name>
<Value>3</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:SchemaRestriction</Name>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:RetrieveRelationships</Name>
<Value>true</Value>
</Annotation>
<Annotation>
<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:Layouts</Name>
<Value>
<Layouts xmlns="">
<Diagram>
<Name>_ALL_TABLES_</Name>
<DiagramLayout>
<dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="12" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-210" scrolltop="-244" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="13732" y="16536" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Customer (dbo.Customer)" left="0" top="0" logicalid="6" controlid="1" masterid="0" hint1="0" hint2="0" width="4324" height="7276" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -