BACK

twitter sesrch

Twitter Search in Plain EnglishFirst, a quick message from Common Craft.,This video comes in version

Common Craft

Updated on Jan 17,2023

Twitter Search in Plain English

First, a quick message from Common Craft.,This video comes in versions designed to be used in training, and in education.,Find them at CommonCraft.com,It seems like everyone is using Twitter these days.,You know, sharing little messages with each other on phones and computers.,It turns out that all these little messages, if you look at them all at once, become an,easy way to find people, news and trends.,Let's get started by visiting Twitterville.,This town represents all the people using Twitter.,There are millions of them and they're constantly talking to each other and sharing information,140 characters at a time.,The typical townsperson only sees part of the messages, or "tweets" and that's fine,- there are way too many to follow them all.,But if all the tweets could be captured and organized all the time, amazing things could,be possible.,The town would have a resource for knowing what's interesting and who's talking about,it.,This is what Twitter Search has done for Twitter - it captures and organizes every tweet so,that it's possible to find people and specific information in real time.,For instance, meet Roy of Ice Cream by Roy.,Other than the people who come to his store, he could never hear what customers said about,his ice cream.,However, because everyone in the town uses twitter, he can now search for "Ice Cream,By Roy" and see tweets from people who mention his product.,Then, he can reply to say thanks or follow their future updates.,Twitter search helps Roy listen to customers and make the flavors they want.,It's also a great way to learn about news.,When an explosion is heard outside of town, the townspeople report it in real time.,This means that Roy can check Twitter search to find a constant stream of information,,sometimes from the very people who experienced it.,He can even limit the results to tweets near a specific location.,It's news as it happens.,Every minute of every day on Twitter, people are using some words more than others.,Maybe the town has a new mayor, a concert came to town, or the same joke is being told,over and over.,If the most popular words could appear on a sign, a person just arriving in town could,get a feel for what was interesting to the residents at the moment.,On Twitter, the most used words are known as trends and they're a great way to see what's,interesting on Twitter.,You can always find up to the minute trends on your Twitter profile, or search.twitter.com.,Clicking a trending topic shows the most recent tweets that include that word or phrase.,Sometimes, Twitter members work together and use a specific key word, called a hash tag,,to connect related tweets.,For example, people talking about elections may use the hashtag #vote to create the connection.,The way, by including the #vote tag, Roy can make sure his tweet is part of the discussion.,If enough people use the tag, it may become a trend, attracting even more people to the,conversation.,Of course tracking these conversations is easy because Roy can search right on his Twitter,profile.,And if he wants to see results over time, he can save the search.,With Twitter, all the small messages are useful when shared between people, but by organizing,all the tweets and making them searchable, we can learn what's on the minds of millions.

The above is a brief introduction to twitter sesrch

Let's move on to the first section of twitter sesrch

Let Tikstar's experts help you find the best TikTok product on your Shopify business!

Find Influencer (It's Free)

No difficulty

No complicated process

Find influencer

3.5K Ratings

WHY YOU SHOULD CHOOSE Tikstar

Tikstar has the world's largest selection of social media to choose from, and each social media has a large number of influencer, so you can choose influencer for ads or brand marketing without any hassle.

twitter sesrch catalogs

Twitter advanced search tutorial
How To Search By Date On Twitter Tutorial
Twitter advanced search: 6 tips to get the most from your twitter account
Twitter System Design - Part II - System Design Twitter Search
Saving Twitter search results to a spreadsheet with Zapier
Twitter's HIDDEN search tools - twitter tutorial - advanced twitter search - twitter marketing
TWITTER SEARCH SYSTEM DESIGN | HOW TWITTER SEARCH WORKS ? | B+ TREES | DATABASE DESIGN

Twitter advanced search tutorial

hey everyone today I just wanted to do a,quick tutorial on the Twitter advanced,search function that's a feature that,some of you know about some of you don't,but it's a very powerful tool that,allows you to find any given tweet that,you might be looking for I don't know if,maybe you've tried to find a tweet you,sent out before and had trouble locating,it well the Twitter advanced search,function allows you to search very,specifically through any account for any,tweet I'm gonna be doing the tutorial on,my windows-based PC using a Firefox,browser I know a lot of you use your,phones and the app I don't use the app,there's no particular reason for that I,just don't really care for it so I use a,browser both on my phone and on my,laptop if I get enough requests I will,download the app and do a version of,this tutorial for the app on the phone,I'm not even sure if you can do the,advanced search on the app to be honest,with you I just haven't investigated,that okay so how do you get to the,Twitter advanced search feature once,you've logged into your account the,easiest fastest way I found to do it is,to open another tab in your browser and,just google the term excuse me,Twitter Advanced Search,and you can see it pulls up a couple of,options right off the bat on the evil,Google the first one is the one you,usually need which goes to the advanced,search feature in Twitter itself Twitter,Help Center also has a little link down,here on how to use the advanced search,and then other miscellaneous articles as,you go down so I'm gonna go ahead and,click on the Twitter advanced search,link and since I'm already logged into,Twitter it's going to pull up another,instance of my Twitter account with this,box and what this box is is it allows,you to search based on any number of,criteria one of the most common uses is,to find from a particular account so if,you scroll down to where it says,accounts you can do from these accounts,to these accounts or mentioning these,accounts so let's say I want to do from,my own account which is at bear you know,and I want to look for a particular set,of words I'm gonna look for any tweet,containing both Nancy and Pelosi,so what I'm doing is I'm searching my,entire account for any tweet containing,both of these words all of these words,and there we have all the tweets from me,involving Nancy Pelosi,so a lot of times people can use this if,they're trying to find a tweet they did,a long time ago and they can't find it,they've lost it in the vast amount of,information flowing to their account and,you can see up here in the search box,that it has put it in command line form,so if you are the type of person that,likes to just type in your commands,directly this is the format you can use,search for Nancy and Pelosi and then in,parentheses from colon account name I'm,pretty lazy so I tend to just use the,box you can look for tweets from one,account to another account to see who's,tweeting at who you can look for say,anything from real Donald Trump that,mentioned me,sadly enough he has not mentioned to me,but I know he's busy I'm not mad,you can also further refine your search,by checking this which is on by default,that includes all replies so it's not,just tweets that they tweet it out to,their main timeline its replies to other,people,tweets that contain links you can,restrict it show only replies only,things with links you can scroll down,further for engagement that means let's,say I want to see only tweets that have,a thousand replies or a thousand likes,or a minimum you know 500 retweets,whatever particular parameter you want,to define it just allows you to filter,out some of the lower volume stuff a,little bit more fine-tuning for refining,your search you can also go for certain,dates you can go from December of 2007,to January or September 2008 say you,remember vaguely a time when a tweet was,sent out by you or someone else you can,help narrow the search criteria if you,get too many results by using the date,function so that's it in a nutshell,it's very very useful it allows me to go,in and find a tweet I sent out literally,in a matter of seconds I'm sure there's,a lot more you can do with this but,since this is just a basic tutorial I'm,gonna leave it at that,remember you can always go to the,Twitter help and they will give you a,breakdown on exactly what you can do,with the Twitter advanced search alright,thank you very much I appreciate it if,you've enjoyed the video I would,appreciate a subscribe and/or like and,you have any particular requests drop,them in the replies below and I will try,to make it happen for you,thanks again have a great one

After seeing the first section, I believe you have a general understanding of twitter sesrch

Continue the next second section about twitter sesrch

How To Search By Date On Twitter Tutorial

hi in today's tutorial i'm going to show,you how to search tweets by dates on,twitter,first of all,of course you'll need a twitter,application on your phone,if you don't have that just go and,download it through play store if you're,using an android or app store if you're,using an iphone,then all you need to do just go sign in,to create your account if you already,have an account ignore all of that,log into your account and let's just,open,twitter,so here first of all all you need to do,just go and click at the search,option or search button it's at the,bottom right,just go and click on that and here all,we need to do just go here to the search,box search twitter and all you need to,do is just type from,so if you want to talk to search a tweet,from a user so let's just do this,from this two dots and,user name so here you just type the,username,of the person that you want to search,tweets about but if you want to,to search,tweets by date all we need to do just do,the same from two dots,enter the year so maybe 2009,then,the month,like month three and,don't forget the dates,then all you need to do is just type,into wait,of course you'll need space,and so,then two dots,then click or type the date that you,want so let's just do,2010,month one,day,three and hit the search box,or the search button so here as you can,see,if you say on the top here you will not,find this,or you will not find what you want,exactly,so as we said as you can see here,nothing appeared to us because this,option is not available on twitter,application,but let me just,copy that,just click its copy then all you need to,do just go to your browser,and open your twitter,from your browser,here all you need to do but just wait,first all you need to do,just go here,and hit this desktop site so it's it,will turn into,a desktop like you're using twitter from,pc,then all you need to do,just remove that as you can see here hit,the search button,down there,speed is that hard to hit at all,and just click on it,let's just go to search twitter,and paste that,search,so as you can see here i'm getting,notifications from or sorry,i enter a tweet,so here i'm guessing not a notification,sorry i'm getting tweets from 2012,until 2014,14. so as you can see if you scroll down,here you'll find all the tweets between,this two dates that you entered and here,you will find us because that is not,available on the twitter application yet,so that will be it for the video i hope,you guys like it thanks for watching and,goodbye

After seeing the second section, I believe you have a general understanding of twitter sesrch

Continue the next third section about twitter sesrch

Twitter advanced search: 6 tips to get the most from your twitter account

the most powerful feature that twitter,has is the advanced search even though,i've been on twitter for more than 10,years until recently i hadn't actually,heard of advanced search but now i use,it all the time here are six features of,twitter advanced search that will,revolutionize the way that you search,for your information on twitter,so before we get into these twitter,advanced search features you might be,wondering why you need them at all well,the reason is that when you look at your,twitter feed it actually only shows you,what is happening now and what,information is available now there is a,whole wealth of gold right there in all,the archives of all the people you,follow of all the amazing experts that,are online and if you can work out how,to use the twitter advanced search,feature well you will be able to find,all the information you need and you'll,be make sure that you are reading stuff,that is relevant and useful to you from,the people that you love and whose,advice and experience you value and,here's how you do it any of these,twitter advanced search features can be,typed right into the search bar that,appears on your mobile app or on your,twitter desktop app you don't need to go,to the special advanced search page,which they do have on desktop but not on,mobile but actually twitter makes it,quite tricky to find it so right in your,regular search bar you can put any of,this text and it'll work let's get into,it number one when you want to see,tweets from a particular person and,maybe tweets from them to a particular,person there's a really easy way to do,that you just put from colon their,username into the search box so if it,was me you just put from colon tessa r,davis and if you wanted to see tweets i,had made to andrew tag for example one,of my buddies then you could put from,colon tessar davis to colon andrew jtag,and that would show you the interactions,that we've had on twitter you could do,this with any username and it works a,treat number two find tweets on,particular topics so if you wanted to,see what i've been saying on twitter,about presentations for example you,would put in the search bar from colon,tessa r davis and then you put,presentations and you'll see all the,tweets from me with the word,presentations in it if you want to,exclude a particular term like for,example you want to see stuff that i've,said on twitter about presentations but,you don't want to read about zoom you,would use the hyphen so the hyphen means,you're excluding certain terms so you'd,put from colon tessa r davis,presentations and then hyphen zoom there,you'd see everything i've tweeted about,presentations and it would exclude all,the tweets about him if you put your,search term in inverted commas it will,show the exact search term rather than,the phrase or things that are similar to,it so if you just wanted presentations,with no variation you would put that in,inverted commas if you take it out of,inverted commas then it will be more,flexible on the use of the search term,you've put in number three find tweets,that are popular so sometimes you might,want to look only at tweets that are,particularly popular from someone you,follow maybe to see what your own most,popular tweets are or to look at popular,tweets on a given topic and you can do,this easily using advanced search so you,can do this by looking at the number of,retweets the number of likes or the,number of replies that a tweet has had,and you can set the minimum value you,want to see so there's three terms you,need here it's min underscore retweets,men underscore faves and men underscore,replies and you use each of these with a,color after and then put the number that,you want so if you want to see any,tweets that i've made that have got more,than 2 000 likes for example you would,write from colon tessa r davis men,underscore faves colon 2000 and if you,wanted them to be on a particular topic,you would then put the name of the topic,next to it so presentations so that will,show you all the tweets i've made on,presentations that have a minimum of,2000 likes there may be none number four,sometimes you might only want to see,particular types of tweets and there's a,few options that you have here you can,do it look for tweets that have links in,them you can look for tweets that have,media files attached to them you do this,using filter colon so you put filter,call on links filter colon images filter,colon media and again combine these with,all of your search terms that we've,discussed already to put whatever row of,text you want in the search box and it,will combine all of these together to,give you your advanced search this is,particularly useful if you've got,graphic or image that you've seen on,twitter before that someone's posted and,you cannot manage to find it so for,example i post a video of my dog at a,polling station on twitter if you really,wanted to see murphy when he cast his,vote you could put in the search terms,from colon tessa r davis an

After seeing the third section, I believe you have a general understanding of twitter sesrch

Continue the next fourth section about twitter sesrch

Twitter System Design - Part II - System Design Twitter Search

hey guys welcome back this is the second part of designing tutor service it took me some time to ,upload this video because first of all I was six almost two week and then later on I didn't find ,enough motivation to upload the video and that is why I would ask you to please like my videos and ,do comments on my videos because your comments and your engagement actually motivate me a lot ,to upload more useful content for you guys also I will be uploading my next video soon and that ,video will be this about designing uber service so if you'd like to get notified when I upload my ,next video please subscribe to my channel and click the bell icon also I would like you to ,meet someone actually my dear old daughter I want you to know what I am doing in this room so Sarah ,can you see hi hey subscribe to our Channel okay thank you okay so that's enough okay now you can ,go and let me make good use okay then I will come back down okay okay bye okay cool let's go so in ,the last video we discussed first of all what are the functional and non functional requirements of ,Tudor service then we discussed the high level API design and then we discussed the high level ,micro service architecture of twitter service and we discussed that we directly applies of ,several micro services like the search service to its service user timeline home timeline and ,social graph fan out and of course is a data store and caching layer as well in the last video that ,you can find here we actually go deep down into designing the TWiT service the user time line ,service and the social graph service in today's video we will be discussing how the fan-out ,service works and how the home time line service works and we will also design the internals of ,the such service so let's go so now first we when designed the fan-out service the fan-out ,service is responsible for actually sending all the tweets that a user post to the home timeline ,service of other users which follow that user or also the search service if you see in this high ,level architecture of twitter service you will see that days are there is an arrow from that ,quit service with a user timeline service so so what is happening is that when a user post at to ,it the to its service dadly forward that to it to the user timeline service but to its service uses ,the fan-out service to forward the tweet to the home timeline service and to the search service ,so why is that so why are we designing like that why the TWiT serve it is not dadly forwarding the ,tweet to the search service or the home timeline service let me know in the comments below what ,do you think fan-out service is possible for forwarding that to it from the tweet service to ,search service and the user home timeline service in case there are other components or micro ,services in the to the service architecture for example notification or trending service it is the ,fellow service which is possible for forwarding the tweets to those services as well defended ,service comparison of multiple distributed queues as follows whenever tweet service receive a tweet ,from a user it passes the tweet to the fan-out service by calling an API exposed by the fan or ,service which is called push tweet the push to it API insert to it in one of these distributed ,queues the distributed queues at the first stage are charted by the hash of the user ID ,of the user who posted the tweet the function pushed to it returns immediately after posting ,that weight to one of the distributed queues now there could be multiple agents or workers ,who are actually listening to these distributed queues these agent retrieve the tweet from the ,queue and then perform the following functions first they pass the tweet to the search service ,secondly the QV the social graph service to Cooley the list of all the followers of the ,user who posted the tweet for example if there are 500 followers for a user then the query the ,social graph service to retrieve the list of those 500 followers and then they insert 500 messages in ,these distribute goose one for each follower third is they forward the tweets to any other services ,like trending service or notification service if they exist in the system in our case right ,now we only have the search service so that's why they are all only forwarding to such service but ,if there are other services like push notification or trending services then these workers will be as ,possible for forwarding a tweet to those services as well there are now second set of workers which ,are listening to this second set of distributed queues these workers process the messages in these ,distribute queues and then forward those messages to the home timeline service so these two sets of ,distributed queues can always start with minimum of let's say 3 distributed queues and then we can ,always increase the number of distributed que

After seeing the fourth section, I believe you have a general understanding of twitter sesrch

Continue the next fifth section about twitter sesrch

Saving Twitter search results to a spreadsheet with Zapier

hey there somebody asked me recently on,Twitter if I could show how to create a,Twitter search that would then save the,results that come up into a spreadsheet,in Google sheets and use zapier to do it,so I figured I would go ahead and show,how to do this I'm gonna be using a few,things here I'm gonna use a beer so I go,to my zaps we're gonna end up creating a,news app that will search Twitter for,people mentioning certain keywords and,then we're gonna save those keywords or,the results of those keywords to a new,spreadsheet so I'm gonna go ahead and,create my new spreadsheet and that way,maybe you could use this for a few,things I mean you could do this to,collect let's say people looking for job,listings so if you want to like look for,companies that we're tweeting or people,tweeting about jobs that might match,your certain criteria or let's say you,want to search for local news that,affects your neighborhood maybe you put,in some streets around you you could use,it to keep up with mentions of your name,online or people who mentioned your,website so actually that's what I'm,gonna do in this case we're gonna set up,a twitter search that will get anybody,who mentions anything around CFPs,because I've run a CFP website called,CFP land so let's go ahead and do that,now first I'm gonna show you something,that a lot of people don't know in,Twitter there's this thing called an,advanced search so twitter.com slash,search - advanced and I think there's a,way to get to it through the UI although,it's a little bit confusing so what you,can do with the advanced search is you,can do all these different kinds of,filters like all of these words must be,in it or an exact phrase must be in it,or any of these words or,none of these words certain hashtags you,can filter right language you can say,they're from specific accounts or to,specific accounts so if you want to,collect mentions of certain accounts you,can do that as well,you can filter out replies things with,links are without links so you could if,you want to look for job listings you,could use this to get only tweets with,links this can be really useful for a,lot of things you can and then the,engagement stuff is interesting too so,if you want to make sure that things,have a certain number of replies before,you put them into your sheet you could,do that as well,yeah so a lot of cool things you can do,with this you can think of all sorts of,interesting stuff to build with Twitter,as your sort of data source and then,connecting that in through zapier to a,spreadsheet or to air table lots of good,stuff there but I am just going to do a,couple things here I'm going to look for,all of these words cfp and the exact,phrase call for proposals so let's,search now the important thing to do,here is to note how twitter created this,so we're gonna go ahead and let's go,ahead and create our sap so go to zap,here we will create a sap and we will do,Twitter as our trigger let's say a,search yeah search mention,okay and now you have to link your,Twitter account I'm gonna do it from,I'll just do this one from my personal,account but you could do it from a,business account now Twitter will,customize the results based on who is,the person searching so keep that in,mind anyway,it's support so when it says it supports,query operators that's the things that,Twitter is putting here so these,operators are all the things that show,up in here you also can note the URL,changes as you look for things so this,is also another way to kind of tell what,all twitter has applied to a specific,search anyway I'm just gonna do the same,search here hit continue okay let's test,this trigger and it's gonna find some,recent entries okay found a few now,there's a lot of data in this in each,tweet you know 10 surprising tweets are,just like a little bit of text and a,little bit of a link and maybe the user,who created it but actually Twitter,includes a ton of data here so we're,gonna in the next step when we grab the,data we actually care about will filter,through that look at it okay so in sap,here we've got search mentions so,whenever that specific key phrase that I,put in is mentioned cfb with call for,proposals then what do we want to do and,let's do a Google sheet so we're gonna,create a spreadsheet row that means,every time this mentioned happens that,we're gonna add a new sprite new road to,that spreadsheet use this account and,let's call this tweet tracker I'm gonna,refresh real quick because I think,zapier is gonna need to go search for,that spreadsheet now camera when that,happens maybe I didn't need to refresh,whatever,nope spreadsheet there is tweak tracker,worksheet I think we can just do yeah,she cheat one didn't see any headers,that okay so let's do something let's,see what data we want to collect let's,do the URL the text and the user who,tweeted it yeah there we go,okay so what's cool as zapier knows that,those first that first rows headers and,so basically here what I'm going to do,is I'm goi

After seeing the fifth section, I believe you have a general understanding of twitter sesrch

Continue the next sixth section about twitter sesrch

Twitter's HIDDEN search tools - twitter tutorial - advanced twitter search - twitter marketing

hey everybody clay archer ceo dpc,technology,on this long holiday weekend i'm sure,some of you will be at home on the,internet so this week we're going to do,a tech tip,on the how to use the advanced search,features inside of twitter i quickly,want to give a shout out to palmetto,technology group ptg they actually,had this tech tip on their blog a few,months back maybe six months ago,and i found myself using it all the time,so let's jump in real quick and we're,going to look at how to use the advanced,search feature inside of twitter,and probably before i get too deep into,it i should explain to you why i would,why you would use this um obviously,twitter being a stream,things come by really quickly and then,they're gone they're actually still,there but you know you don't see them,anymore,and uh every once in a while i find,myself going man,where did where i remember that somebody,said this,or somebody posted an article about this,and i want to go back and read it or see,it or listen to it or whatever it is,but it's almost impossible to find it by,just searching through people's threads,so this is a way to be able to quickly,use some different criteria to search,back through those things we'll start,off by how do you find the advanced,uh search feature you're going to notice,that there it is not available anywhere,when you're looking around inside of,twitter so,there's a couple different ways the,first one is you could simply just,search,twitter advanced search and the first,result there in,google will be twitter advanced search,and it'll bring you right up to the,advanced search page,i don't go that way i typically just in,the search bar,will just search for anything and,as soon as you search for anything you,can just click on advanced search and it,will bring you up into the advanced,search,window so in here basically there's a,bunch of different search,methods that you can do so basically at,the top here,are all the different words and the way,you can uh can search the words so,you can do all of these words meaning,that it has,all of these words in the in the phrase,that you're searching for,then you can do an exact phrase meaning,those words are exactly together in a,phrase,any of these words just meaning that,it's got any of these or some of these,words,in it or you can exclude words by the,nun of word none of these words,you can also do it by hashtags i mean,this is kind of where the more powerful,part for me is,that i can do it by accounts so i can,search for certain people's accounts,whether it is they wrote the tweet or,the tweet was written to,them or they were mentioned in a tweet,so,all three of those are pretty powerful,there are some filters that you can do,you can have ones that only have replies,you can do,ones that only have links outside of it,and there's one more thing that i think,is really kind of super,helpful at least for me is especially if,you have somebody that tweets a lot,and they have some really popular posts,you can really kind of weed it out by,their most popular post,so you can put in a number of likes or a,number of wheat retweets,try and say that five times faster,number reach retweets,and then you can you know filter it out,by that you can also do it by dates but,let's,jump right in and i'm going to do a,couple of quick examples,one thing i use it for all the time i'm,a formula one fan um and there are a few,things that i'm looking for schedules,obviously uh formula one happens all,over the world so sometimes it's in the,middle of the night,and you miss things there's a thing,called paddock pass it's just um,them basically walking around the pit,lane and kind of talking about the race,that's coming up that weekend they talk,to the drivers and stuff,um and i know that is gonna be gonna be,from the f1 account,you know every race weekend or i listen,to it every race weekend whether it's on,a podcast or whether it's on a video,and you can see it brings up paddock,pass from formula one formula one's,super popular,so the first uh one will be the top one,and so obviously i'm not looking for,october 19th or october 12th uh i'm,looking for the latest which would have,been a couple weeks ago when they were,in turkey,and there you go if i click latest,turkey paddy pass and i can just listen,to that podcast and i can,scroll back and i can see they typically,do one or two or three,i can see the different ones for the,weekend or the previous week in emela,or you know i can scroll back through,all of them and i can find them all i,also do this for the tv schedule for,formula one,which is also kind of all over the place,so formula one if i just went into,formula one's account if i just click on,formula one,you'll see that they tweet a bazillion,things a day and i'm never gonna find,uh something from two weeks ago inside,of here because you know they post every,hour on the hour so,that's a great example of where i,typically use it i also,use twitter for a lot of content driven,stuff,so i g

After seeing the sixth section, I believe you have a general understanding of twitter sesrch

Continue the next seventh section about twitter sesrch

TWITTER SEARCH SYSTEM DESIGN | HOW TWITTER SEARCH WORKS ? | B+ TREES | DATABASE DESIGN

now how will the query access this,database what would be the query,patterns like what would the person,search it will be a random search it,will be some with filters the person,will search on uh for a particular user,or the person will search on just,generic text so all these things we have,to think about,hello everyone welcome back to my,channel i hope you're all doing great,so in one of the community posts that i,did someone mentioned that i should,basically make a video on twitter search,like how does something like twitter,search works so i did a little bit of,research and try to make this video i,hope you like this one,so let's see how this video search works,so like if you would have used twitter,or you know about twitter so twitter is,basically a kind of a status website,everyone just write a small tweet and,post it there like kind of their status,what they are thinking whatever is that,so every day there are billions of,tweets that are happening on twitter now,and,it is let's suppose there are 400,million beats which are happening each,day,now let's calculate what would be the,average size of this tweet,now this tweet would have a tweet id,which is around let's say 8 bytes,a user id suppose 32 bytes text 140,bytes and some media like someone also,includes an image so let's suppose,that's 10 kb now this can be large,because the images are also large so,let's say the total is around 10 kv but,let's say it is something bigger so,let's take it around 1 mb or something,like that,so we have this 150 tb of new content,created every month so now this number,is also very low that we are considering,just 10 kb per beat now this would be in,or,like i am absolutely sure it will not be,in terabytes it mostly will be in,petabytes or even higher numbers,now,we are basically talking about search,now you have these many number of tweets,like why i shared this data is because,we have these many number of tweets on,which we have to perform our search,and we have around let's suppose four,thousand search requests per second like,many users at a time this is also a very,low consideration that only just four,thousand searches are being named but,let's take this assumption for now,now there are 15 billion tweets per,month and 10 billion searches per month,so,you can see how many,searches are being being performed and,on how much,data these searches are being performed,now,the first point that comes into our mind,to give the search basically we would,have to provide the search on the tweet,itself,uh which kind of database would you use,uh you would use a sql database or a new,visual database like i'm thinking what,would twitter engineers would have,thought they would always have taught,this but like what kind of,uh database what they need,the second thing is how will the query,access the database and how will the,query time decrease so basically you,have to query this data fast because,you're providing a search the search,cannot be slow now how will the query,access this database what would be the,query patterns like what would the,person search it will be a random search,it will be some with filters the person,will search on for a particular user or,the person will search on just generic,text so all these things we have to,think about,now let's go back to the history now uh,like on the various articles the twitter,has thought that they have used mysql,database,now twitter is a quite old website like,it was there since 2008 i think so at,that time they used a mysql database and,i think they are still using it,so they use the mysql database but how,do they provide search in a mysql,database,so,just to provide a little context mysql,database internally,is a relational database like you all,know the data is arranged in form of,rows and columns uh in like in,internal implementation the this data is,stored in the form of a b plus tree so,in the form of a b plus tree this data,is stored,now how would you basically search a,particular term in this mysql database,would you do a parallel scan like you're,scanning the complete database you're,scanning a complete b,now that search would really suck,because,that would not be able to perform a,search fast now how would you like,improve the speed of this search,now to improve the speed of this search,what is the basic norm in our database,so whenever in a database we have to,increase the speed we create an,now what does this index mean and what,does this index do,we'll talk about this now what does an,index do an index basically or like we,discussed we have a b plus 3 okay,now what does this index do it is,basically suppose this is a b plus tree,that you have,now this this is the kind of data like,in this a b c d f these are the leaf,nodes and then there are above nodes and,then there is a final topmost,root node which we call,now when you create this,index,it is basically what it does it creates,another b plus tree now there was a b,plus c actually containing the data now,when you aga

Congratulation! You bave finally finished reading twitter sesrch and believe you bave enougb understending twitter sesrch

Come on and read the rest of the article!