tag:blogger.com,1999:blog-8677649049588007585.post2144215107306445960..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: Some Changes in Championship Rules (and more)Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-8677649049588007585.post-7922466773506298312013-07-03T13:56:16.344+01:002013-07-03T13:56:16.344+01:00Thanks for your ideas, Iudith. For this championsh...Thanks for your ideas, Iudith. For this championship, though, I am going to "stick" with the one time slot.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-42158638011658821942013-07-03T13:55:42.428+01:002013-07-03T13:55:42.428+01:00[From Iudith/comment deleted accidentally]
Hello ...[From Iudith/comment deleted accidentally]<br /><br />Hello Steven, All,<br /><br />The problem with 2 playing times, even with 12 hours between them, is that, in any way you choose them, there will always exist certain regions on the globe for which both of them could be considered "reasonable".<br /><br />For example, if you take 04:00 UTC and 16:00 UTC, then for my region, which is ( UTC + 03:00 )<br />both of them are "morning or evening" times, not "night" times.<br /><br />So, even if you rely on the country information, you will have to take a decision about which of the two times will have to be used for the players of that country.<br /><br />For example, you can calculate the for each of these 2 time points, the "average time interval" between the daily playing times of a player across the quarter and that fix time point, and then choose the time point for which this average interval is the smallest.<br /><br />And, if this leads to different results (different time points chosen) for players from the same (declared) country, then choose for all those players the one that represents the majority of the results, considering that in this case, probably, both time points are "normal enough" for all the players of that country.<br /><br />Just an "idea of automation" ... maybe it could work.<br /><br />Thanks a lot & Best Regards,<br />IudithSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-80515711753534362712013-07-03T13:51:57.860+01:002013-07-03T13:51:57.860+01:00Ingimundur, that will be more than sufficient. I w...Ingimundur, that will be more than sufficient. I will add that to the FAQ and rules as well.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-11201420796158780622013-07-03T13:20:47.976+01:002013-07-03T13:20:47.976+01:00Hi Steven,
Just to follow the point that João men...Hi Steven,<br /><br />Just to follow the point that João mentioned. I don't use my work e-mail for PLSQLChallenge, as I work in a government institution and am technically not allowed to use my email for private things. Therefore I use my gmail for the account. I can of course put my work e-mail as a comment somewhere so that you can see it for the purposes of deeming if I am a real person or not. Hope this is enough.<br /><br />Regards,<br />IngimundurIngimundurhttps://www.blogger.com/profile/03109127982618084355noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-20718067991087713682013-07-02T13:42:47.330+01:002013-07-02T13:42:47.330+01:00Thanks, Iudith. Yes, I could probably sort it out ...Thanks, Iudith. Yes, I could probably sort it out - manually. But I don't see a good way to automate the process - which scares me. :-)Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-86853051915873980492013-07-02T10:12:08.977+01:002013-07-02T10:12:08.977+01:00Hello Steven,
Regarding the IP address versus loc...Hello Steven,<br /><br />Regarding the IP address versus location ... I am sure that the CIA probably has a method <br />of relating the two precisely.<br /><br />But, anyway, if you take the statistic distribution of all the playing times of a player across a quarter,<br />( earliest, latest, vast majority ), you can probably identify at least from which "half globe" he was playing ...<br /><br />A pity that we cannot adopt the Middle Age "plain globe" variant to make everybody happy :):)<br /><br />Best Regards,<br />Iudith<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-79614144444129660612013-07-02T05:00:54.242+01:002013-07-02T05:00:54.242+01:00Hi Steven,
I live in Singapore (UTC +8). I like t...Hi Steven,<br /><br />I live in Singapore (UTC +8). I like the idea of two time slots 4:00 utc and 16:utc. that way I will be able to take up the playoff quiz (if I am selected) at 4:00 utc. The timings also ensure that only 1 slot is ideal for anyone depending on their region.<br /><br />AjaykumarAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-67423751515022858332013-07-01T13:15:28.164+01:002013-07-01T13:15:28.164+01:00@niels
Re: IP address...I did some checking and ...@niels <br /><br />Re: IP address...I did some checking and apparently there is no way to use IP address reliably to identify/confirm location. I will give it some more thought, but right now I am inclined to keep things at a single time slot for this championship and we will see how that works out.<br /><br />@joao<br /><br />We will let you know if the information you provide is not good enough. Put in the data you feel best represents you and we will let you know if there is a problem. Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-74536094416176561882013-07-01T10:59:48.659+01:002013-07-01T10:59:48.659+01:00Hi Steven,
Just want to know: how do we know that...Hi Steven,<br /><br />Just want to know: how do we know that the information we provided is enough? Is the information "You are being ranked." enough?<br />I am asking this because you state: "Your company website, combined with an email address in the same domain, is acceptable." - I do not have that information in LinkedIn (and I don't want to use my that e-mail address as primary).<br /><br />Thanks,<br />JoãoJoão Borges Barretohttps://www.blogger.com/profile/09625758342698621527noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-26466419745237400542013-07-01T08:52:34.359+01:002013-07-01T08:52:34.359+01:00Steven, the idea of two timeslots comes from your ...Steven, the idea of two timeslots comes from your idea that all players should play at only one point of time. I thought that it would be hard for some people if this time would be, for example, 04:00 at their local time zone and so I come to the idea that there should be at least two timeslots with a difference of 12 hours.<br /><br />And I'm also happy that it is sufficient, when the domain of the email-address is identical to the domain of the company a player is working for, because when you look at the poll "Where Do You Play Quizzes?" you will also see that 84% of the players do it on the job (during or outside of the working hours).<br /><br />Kind regards, NielsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-5506421385865632452013-06-30T19:48:32.901+01:002013-06-30T19:48:32.901+01:00Niels, you raised the idea of two time slots. I as...Niels, you raised the idea of two time slots. I assume you propose that so some people would not have to play at an ungodly hour in the morning. It is very worthwhile concern.<br /><br />What do you think of this idea:<br /><br />We have two time slots, but at 4:00 and 16:00, and you can play the 4:00 time slot if your country (and IP address) is in the Asia/Pacific region. Otherwise you play at 16:00.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-67586239938628033842013-06-28T12:10:04.064+01:002013-06-28T12:10:04.064+01:00CONSEQUENCES!
I am adding this to the main post (...CONSEQUENCES!<br /><br />I am adding this to the main post (and eventually to the rules/FAQ): <br /><br />If a player who qualifies to win a prize or compete in the Championship does not provide the necessary information, their status will be set to "Not Ranking" for the previous quarter. Rankings for the quarter will be adjusted and new players eligible.<br /><br />Complicated? Well, sure, but only if players don't provide a very reasonable amount of information.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-80655671594725854942013-06-28T12:08:18.849+01:002013-06-28T12:08:18.849+01:00Niels, why do you think there should be at least t...Niels, why do you think there should be at least two playing times? If two, why not four, as we do now?<br /><br />The homepage of your company, along with an email address with that domain, should be sufficient as well. I will add this to the rules, which will be placed in the FAQ as well.<br /><br />Regarding the interpretation that "We think the minority of people in the wrong timezones should be made to work harder than others to overcome our arbitrary restrictions - they should feel privileged that we even let them compete.", that stung!<br /><br />:-)<br /><br />It's tough when your audience is such a logical bunch.<br /><br />Well, tell me what you would do. We have players all over the world, but the vast majority of those who compete in the Championship live in the US and Europe. I hate to inconvenience anyone, but I also want to ensure a great content. I am not for a "tyranny of the majority" but it's not like I am violating anyone's basic human rights here. Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-42968169083345645742013-06-28T07:54:51.455+01:002013-06-28T07:54:51.455+01:00I think that there should be at least two playing ...I think that there should be at least two playing times, e.g. 0:00 UTC and 12:00 UTC.<br /><br />Regarding the websites: I also don't have a LikedIn account but after I saw there user agreement that you must confirm that every content you upload (even if it was accidentely) you automatically grant them the worldwide and unrevokable privilege to use it for whatever they want - and that's an absolute no-go for me.<br /><br />When you go to my website you will only see a message from my provider that the domain is registered for a customer (I use it for email accounts) and I don't know if I will have the time to create a real home page until the next playoff).<br /><br />I have also added the homepage of the company I work for (even when you can't see that I'm working for the company on it) and I think it should also be sufficient to show that you are a real human if the email address belongs to the company (even when this would be very bad for people working at google, GMX, ... :-( ).<br /><br />Kind regards,<br />Niels Hecker<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-1272414031862227722013-06-27T22:34:35.647+01:002013-06-27T22:34:35.647+01:00Fine with me!
Kind regards,
Milibor JovanovicFine with me!<br /><br />Kind regards,<br />Milibor JovanovicAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-4193518372739768762013-06-27T02:21:21.393+01:002013-06-27T02:21:21.393+01:00"We realize that this could cause hardship fo..."We realize that this could cause hardship for some players (I'm thinking about the Pacific nations mostly), but we figure that if you are sufficiently honored and excited to be in the championship, you'll make it work."<br /><br />By this logic, you should set the competition time to be 4am, US EST.<br /><br />In other words, "We think the minority of people in the wrong timezones should be made to work harder than others to overcome our arbitrary restrictions - they should feel privileged that we even let them compete."<br /><br />- anonymous cowardAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-60273773280124367352013-06-26T19:17:31.183+01:002013-06-26T19:17:31.183+01:00Hello All,
Just another idea:
What about keeping...Hello All,<br /><br />Just another idea:<br /><br />What about keeping the several playing times in place, but under the restriction that all the participants<br />from the SAME COUNTRY should play at the SAME TIME ?<br />That "single time per country" could be chosen either by a vote of the majority of the players from that country,<br />or simply fixed by choosing "a reasonable time" for each country ?<br /><br />This way no one would be forced to play at midnight, and the "equal footing" is ensured at least<br />at the country level ... though, of course, in a world where nothing is 100% reliable,<br />why would the country information itself be ?<br /><br />The weekend idea has a nice point in it, namely that you don't have to also play a daily quiz in the same day ...<br />but this is the only one.<br /><br />Just as not everyone has a web site or a LinkedIn account , also not everyone has access <br />to a database at all on weekends ... and, however we look at it, this puts to a definite advantage<br />those players who do have a database ...<br /><br />Cheers to @SiimKask, I am also a "real human" ( or at least I still hope so ... )<br />without a personal web page, without a laptop and without a personal/home database ...<br /><br /><br />Thanks a lot & Best Regards,<br />Iudith<br />( not Anonymous, but I cannot logon to my profile )<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-82457317324279409152013-06-26T15:23:04.700+01:002013-06-26T15:23:04.700+01:00That is a very interesting idea, Thierry. Play the...That is a very interesting idea, Thierry. Play the championship on the weekend....hmmmm....I like it very much, though of course it will still be tough for someone who has to play at 4 AM.<br /><br />I will set up a poll.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-55104177181850497962013-06-26T15:15:25.412+01:002013-06-26T15:15:25.412+01:00Hi,
I can agree with all the new rules : You give ...Hi,<br />I can agree with all the new rules : You give the prizes (and much much more than only that), you make the rules, simple as that.<br /><br />The only thing I would really hate is the "time of play". Even with 4 options it's sometimes difficult to align it with work & family.<br />Maybe the Championships could move to the weekends? (new poll? :)<br /><br />regards,<br />Thierry Poels.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-72084676253601599672013-06-26T12:05:48.721+01:002013-06-26T12:05:48.721+01:00@ingimundur I have changed the post above to ask f...@ingimundur I have changed the post above to ask for at least one website. If you cannot list three, no worries. As for not having a LinkedIn account, is it a problem to establish one? <br /><br />@anonymous - Regarding the time of play, I recognize that some people will play in less optimal circumstances, and I am sorry about that. But won't the chance to play be so exciting that your adrenalin rush will overwhelm such as concerns as playing after midnight? Where, by the way, are you located?<br /><br />@frank - It is not a technical issue. We simply feel that this will be a better way to ensure that everyone plays on an equal footing.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-63646008779793664572013-06-26T11:52:12.185+01:002013-06-26T11:52:12.185+01:00Dear Steven,
to be honest, I'm not very happy...Dear Steven,<br /><br />to be honest, I'm not very happy about your decision to force every playoff participant to play at the same time. <br />Could you please explain why you no longer offer multiple times for the playoffs? Are there any technical reasons for this? Or is it to prevent cheating (e.g. one player taking the playoffs at the earliest possible time and giving the questions to another player participating at the lateset possible time)?<br /><br />Kind regards,<br />Frank SchmittAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-40051851634660057942013-06-26T09:09:46.615+01:002013-06-26T09:09:46.615+01:00Hei Steven,
I have a little bit of problem with t...Hei Steven,<br /><br />I have a little bit of problem with those websites, I don't have a LinkedIn account, my own website or anything that can show who I am or what I work with. The only one that can confirm all that is my works website, but that's only one website.<br /><br />Regards,<br />Ingimundur K. GudmundssonIngimundurhttps://www.blogger.com/profile/03109127982618084355noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-89947753997628493632013-06-26T07:50:21.693+01:002013-06-26T07:50:21.693+01:00I would definitely be excited and honoured to be p...I would definitely be excited and honoured to be part of the championship playoff. But, living in GMT +8.00 timezone I am afraid I will be forced to work my brain after midnight. Not an ideal situation.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-74296411238439228742013-06-26T07:25:14.270+01:002013-06-26T07:25:14.270+01:00I don't see the point of requiring 3 web pages...I don't see the point of requiring 3 web pages. I do have a LinkedIn page, but I have not updated it for years. Should I put my employer's webpage in the second field? I hope I am still allowed to exists as "real human" without having 3 different webpages.<br /><br />I do not have Facebook, I have not filled my Google account, no Twitter, Picasa etcsiimkaskhttps://www.blogger.com/profile/16786222546215308551noreply@blogger.com