Su	Mo	Tu	We	Th	Fr	Sa
31	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	1	2	3	4

Indexing, Querying and Analyzing Text with SQL Server 2012-2014 [repost]

Posted By: ParRus

Date: 13 Dec 2016 18:14:30

Indexing, Querying and Analyzing Text with SQL Server 2012-2014 [repost]

Working with textual data in SQL Server involves indexing, querying and analyzing texts. Improve transactional and analytical applications with Full-Text Search and analyze texts with Semantic Search and Text Mining.

It is hard to imagine searching for something on the Web without modern search engines like Bing or Google. However, most contemporary applications still limit users to exact searches only. For end users, even the standard SQL LIKE operator is not powerful enough for approximate searches. In addition, many documents are stored in modern databases; end users would probably like to get powerful search inside document contents as well. Text mining is also becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understand the meaning of documents. Finally, the Term Extraction and Term Lookup components from SQL Server Integration Services also helps with text analysis.

Content:

01. Introduction
01. Introduction.mp4
02. Modules.mp4

02. Creating Full-Text Search Catalogs and Indexes
01. Introduction.mp4
02. FtsSsComponents12.mp4
03. FtsSsComponents34.mp4
04. FtsSsComponents56.mp4
05. DemoSetup.mp4
06. PropertyStop.mp4
07. CataIdx.mp4
08. DemoCreate.mp4
09. Demo2012.mp4
10. Summary.mp4

03. Queries with Full-Text Search Predicates
01. Overview.mp4
02. Introduction.mp4
03. Contains1Simple.mp4
04. Contains2Prefix.mp4
05. Contains3Proximity.mp4
06. DemoContains1.mp4
07. Contains4Inflectional.mp4
08. Contains5Synonyms.mp4
09. Contains6DocProperties.mp4
10. Freetext.mp4
11. DemoContains2Free.mp4
12. Demo2012.mp4
13. Summary.mp4

04. Full-Text and Semantic Search Table-Valued Functions
01. Overview.mp4
02. Introduction.mp4
03. FTSFunctions.mp4
04. ContainsTable.mp4
05. FreetextTable.mp4
06. DemoFTSFun.mp4
07. SemKeyPhrase.mp4
08. SemSimDetails.mp4
09. SemSimTable.mp4
10. DemoSSFun.mp4
11. Demo2012.mp4
12. Performance.mp4
13. Summary.mp4

05. Extracting Terms from Texts
01. Overview.mp4
02. Introduction.mp4
03. TermExt1.mp4
04. DemoTECroSlo.mp4
05. TermExt2.mp4
06. TermExt3.mp4
07. DemoTEEn.mp4
08. FTSDMFun12.mp4
09. FTSDMFun34.mp4
10. DemoFTSDMFun.mp4
11. Demo2012.mp4
12. Summary.mp4

06. Looking Up for Terms in Texts
01. Overview.mp4
02. Introduction.mp4
03. Term Lookup 1 Basics.mp4
04. Term Lookup 2 Advanced.mp4
05. Demo Term Lookup.mp4
06. SSIS Issues Basic Analysis.mp4
07. Demo SSRS PowerPivot.mp4
08. Advanced Analysis.mp4
09. Demo Data Mining.mp4
10. Demo2012.mp4
11. Summary.mp4

also You can watch my other last: Programming-posts

MediaInfo:

General
Complete name : 04. ContainsTable.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 5.27 MiB
Duration : 2mn 4s
Overall bit rate mode : Variable
Overall bit rate : 355 Kbps
Encoded date : UTC 2014-02-06 20:42:27
Tagged date : UTC 2014-02-06 20:42:35
Writing application : HandBrake 0.9.8 2012071700

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Baseline@L3.1
Format settings, CABAC : No
Format settings, ReFrames : 2 frames
Format settings, GOP : M=1, N=50
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 2mn 4s
Duration_FirstFrame : 67ms
Bit rate : 227 Kbps
Width : 1 024 pixels
Height : 768 pixels
Display aspect ratio : 4:3
Frame rate mode : Constant
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.019
Stream size : 3.36 MiB (64%)
Writing library : x264 core 120
Encoding settings : cabac=0 / ref=2 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=0 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=0 / weightp=0 / keyint=50 / keyint_min=15 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=20.0 / qcomp=0.60 / qpmin=3 / qpmax=69 / qpstep=4 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2014-02-06 20:42:27
Tagged date : UTC 2014-02-06 20:42:35
Color range : Limited
Color primaries : BT.709
Transfer characteristics : BT.709
Matrix coefficients : BT.709

Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 2mn 4s
Bit rate mode : Variable
Bit rate : 127 Kbps
Maximum bit rate : 151 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 1.88 MiB (36%)
Title : Stereo
Language : English
Encoded date : UTC 2014-02-06 20:42:27
Tagged date : UTC 2014-02-06 20:42:35

Screenshots