hr

Three Learnings Small Businesses Should Take From 2020 Into 2021

1. Have an adaptable business model
2. Diversify supply chain operations
3. Create an omnichannel customer experience




hr

Three Learnings Small Businesses Should Take From 2020 Into 2021

The United States has seen an increase in new businesses formed this year. According to the United State Census Bureau, in week 50, there were over 86,000 new business applications nationwide — representing a 38% increase over filings during the same week in 2019. The challenges small businesses have experienced in 2020 have led to some core lessons that those in the business community need to apply — whether they own an established small business or a newly formed one.




hr

Python Challenge answers 0 thru 4... in clojure

The Python Challenge is a nifty site that presents you with a series of puzzles that it asks you to solve using python; getting each answer allows you to move on to the next puzzle.

Python is a cool language and it's a good tool for this job1 However, I'm learning clojure right now, so I thought it would be fun to try and solve a few of them in clojure. Here's my answers for challenges 0 thru 4 (warning: if you want to do these puzzles yourself, reading further now might ruin the fun)

Challenge #0 (the "Warmup")

Asks you to solve 2 to the 38th power:

(clojure.contrib.math/expt 2 38)

i.e. just use the exponent function in clojure contrib.

Challenge #1

This one throws some scrambled text at you and a clue on what the key is (ROT 2):

(defn translate [text]
  (let [lookup (vec (map char (range 97 123)))]
    (letfn [(letter? [c] (and (>= (int c) 97) (<= (int c) 122)))
            (shift-2 [c] (mod (+ 2 (- (int c) 97)) 26))]
      (apply str (map #(if (letter? %) (get lookup (shift-2 %)) %) text)))))

Create a lookup table of the chars, a predicate to test if a char is a letter. & a function to get the index of 2nd to next letter (the index loops, essentially making lookup as a ring buffer), then map across the given text, shifting by 2 if its a letter or just returning the char if its not.

Challenge #2

This one throws a big hunk of random data at you and suggests you pick out the 'rare' characters:

(defn filter-file [path]
  (let [fs (line-seq (clojure.contrib.io/reader path))
        lookup (set (map char (range 97 123)))]
    (apply str (mapcat #(filter lookup %) fs))))

A quick visual scan of the text led me to a strong hunch the "rare"2 characters were lowercase alpha, so:

Re-use our lookup table from the last challenge; this time make it a set, then use the set to filter each line of the file denoted by 'path' (I first saved the text to a file to make it easier to work with); use mapcat to flatten the lines out (this has the effect of stripping empty lines altogether); apply str to the resulting sequence to get the answer.

Challenge #3

This one's a big hunk of text too, so a quick refactoring of our last solution results in a more abstract (and higher-order) function that takes a filter function as an additional parameter:

(defn filter-file [filter-fn path]
    (apply str (mapcat filter-fn (line-seq (io/reader path)))))

the filter from challenge #2 thus becomes an argument; partial works nicely here:

(filter-file (partial filter (set (map char (range 97 123)))) "path/to/file")

Now we can make a new filter for challenge #3. This one will need to find character patterns that look like this: ABCxDEF. We'll need grab x. This one just screamed regex at me, so here's a filter that gives us the answer:

#(second (re-find #"[^A-Z][A-Z]{3}([a-z])[A-Z]{3}[^A-Z]" %)))

An anonymous function3 that uses re-find to match: "not-cap followed by 3 CAPS followed by not-cap followed by 3 CAPS followed by not-cap"; the second element of the resulting vector (because we use parens to create a group) produces x; mapcat et al do the rest.

Two big assumptions/limitations here: assumes each target is on its own line, and that the target pattern wasn't on the beginning or end of the line (which was good enough to get the answer).

Challenge #4

This challenge requires one to follow a url call chain, passing a different number as the argument to a 'nothing' parameter each time. The resulting page text provides the next number to follow (and/or some noise to keep you on your toes) until eventually we get the answer.

This one gets kinda ugly.

This is the kind of problem scripting languages are made for (e.g. perl, python & ruby coders would all make short work of this problem). Still, it's possible to write procedural code in clojure, and it's still reasonably straightforward.

One decision I had to make is how to GET the url's - my weapon of choice for this sort of thing is clj-http:

(require '[clj-http.client :as client])
(require '[clojure.contrib.string :as string]

(defn follow-chain [base-url number]
  (let [result (:body (client/get (str base-url number)))
        idx (.indexOf result "and the next")]
    (cond
      (re-find #"^Yes" result) (do
                                 (println result)
                                 (follow-chain base-url (/ (Integer/parseInt number) 2)))
      (= -1 idx)               result
      :else                    (let [result-vec (string/split (subs result idx) #" ")
                                     next-number (last result-vec)]
                                 (println result)
                                 (recur base-url next-number)))))

Take the url as a base & the first number to follow; use client-http/get to grab the page; extract the body of the page; get the index of the phrase "and the next" using the java "indexOf" method - we'll use the index later to parse out the end of the text and get the next number...

...unless of course, we get text that tells us something else (like a message saying "Yes" and then instructing us to divide the last number by two and continue on as before) so...

...we set up a switch using the cond macro: If the result starts with "Yes" make a recursive call dividing the last number by two; if indexOf otherwise came up empty, that's our answer, so return it; else pick the next number out of the result by splitting the end of the string into a vector (using clojure.contrib.string/split) and recur (tail recursively call the function again).

The println's could be removed, although they were essential when figuring out what the code needed to do.

Conclusion

This was a fun exercise; clojure's holding up pretty well so far, though clojure would not be my weapon of choice for that last one; if I choose to do the next five, I'll post them in a future article.

Footnotes

[1] It's also the darling of the hipster crowd right now -- in many cases the same people who snubbed python when ruby was the hip language about a decade ago... python abides.

[2] The official challenge answers also tackle ways to deduce "rare"; knock yourself out

[3] #() defines a function where % %2 etc represent positional parameters; the (fn [arg]) syntax would work here too




hr

For Two Nights Only: A Christmas Carol

Thirteen years ago, I put on a Victorian Suit and a false beard and I read Dickens' prompt copy of A Christmas Carol at New York Public Library. It was a wonderful, sold out performance, introduced by Molly Oldfield, who told us all about Dickens's reading routine.


I looked a bit like this.


And the book looked a bit like this.



The reading of A Christmas Carol has become the most popular of the NYPL's audio downloads, and they repost it regularly. Here's the one from 2019:
https://www.nypl.org/blog/2019/12/19/listen-neil-gaiman-reads-christmas-carol

For years people have been asking if I was ever going to do it again. This year, back while the writers of the WGA were on strike, my assistant Rachael asked if I'd do it, and if I did, could she document it? I said yes, and it's becoming a thing.




It's going to be a Christmas Extravaganza, with carol singers and suchlike, signed books for sale and all sorts of goodies planned. I'm hoping we can get Molly Oldfield over to New York to introduce it once again.

When I was a boy, I saw Welsh actor Emlyn Williams being Charles Dickens on stage, a one man show I've never forgotten.

Here's the town Hall page for the 18th: https://thetownhall.org/event/neil-gaiman-performs-a-christmas-carol-12-18

Here's the page for the 19th: https://thetownhall.org/event/neil-gaiman-performs-a-christmas-carol-12-19

The ticket presale starts on Thursday Nov 2nd at 12 pm, and regular tickets go on sale on Friday at 10:00 am.




hr

DVD Talk Interviews Director Chris Weitz

DVD Talk Interview - Director Chris Weitz Director Chris WeitzDVD Talk writer and film critic Neil Lumbard recently interviewed filmmaker Chris Weitz (About a Boy, American Pie) about his latest film as a director, Operation Finale. The film has...




hr

COPD (Chronic Obstructive Pulmonary Disease)

Title: COPD (Chronic Obstructive Pulmonary Disease)
Category: Diseases and Conditions
Created: 12/31/1997 12:00:00 AM
Last Editorial Review: 5/6/2022 12:00:00 AM




hr

Deep Vein Thrombosis (DVT, Blood Clot in the Legs)

Title: Deep Vein Thrombosis (DVT, Blood Clot in the Legs)
Category: Diseases and Conditions
Created: 2/15/2000 12:00:00 AM
Last Editorial Review: 7/28/2022 12:00:00 AM




hr

Christopher Vogt: Die Sicherheit der Brücken muss oberste Priorität haben




hr

KORREKTUR: Christopher Vogt: Die Sicherheit der Brücken muss oberste Priorität haben




hr

Christopher Vogt: Klimafreundlicherer Straßenverkehr funktioniert nicht über grüne Planwirtschaft




hr

Schleswig-Holsteinischer Landtag stärkt die nordische Zusammenarbeit - Jahrestreffen des Nordischen Rates auf Island




hr

SPD-Fraktion: Serpil Midyatli mit großer Mehrheit als Oppositionsführerin wiedergewählt




hr

Ole-Christopher Plambeck: Oktober-Steuerschätzung schafft zusätzlichen Handlungsbedarf




hr

Heiner Garg: Schallende Ohrfeige für die Kita-Reformpläne von Schwarz-Grün




hr

Christopher Vogt: Landesregierung muss dringend wirtschaftspolitische Impulse setzen




hr

Serpil Midyatli und Kianusch Stender: Schwarz-Grün muss ihre Hausaufgaben erledigen




hr

Menschenrechte sind unteilbar. Requiem zum Gedenken der Toten an den Grenzen Europas am 20. November, 18 Uhr in Lübeck




hr

Landtagspräsidentin Kristina Herbst liest am diesjährigen Bundesweiten Vorlesetag in der Grundschule Dänischenhagen vor




hr

Christopher Vogt: Für den A20-Weiterbau braucht es mehr als schwarz-grüne Formelkompromisse




hr

Chromotherapy in Cancer

In 2007, I posted two articles on this site suggesting that cancer had something to do with the energy mechanism of the human body. I am coming back to this through a comment on one of those articles by Viorel Bungau, a family medical doctor in Romania. The two previous articles are: Cancer and ATP: The Photon Energy Pathway Could cancer be a functional deviation of the cellular energy production mechanism that is open to correction by relatively simple means instead of a genetic mutation that is passed down through cell division? Heinrich Kremer, MD, says that this is indeed the case. His hypothesis of a photon-mediated cellular energy pathway may turn out to substantially add to our understanding of what cancer is, and why such natural substances as curcumin may be effective cancer fighting agents. Cancer: The ATP-Photon Hypothesis Could cancer be a result of the functional degradation of a cellular photon absorption pathway that is basic to the production of ATP, the cellular energy molecule? And could tumor cells merely be executing an age-old survival program they retained from the time of unicellular existence? An interesting new hypothesis of cancer causation spells out why some cells all of a sudden start dividing to form tumors, and how that urge to sustained growth could likely be 'switched off. Chromotherapy: The healing power of colors (image found here) Here (with some minor edits) is what Dr Bungau originally posted as a comment on the second article... CHROMOTHERAPY IN CANCER Dear Professor, Medical practitioner, I am passionate about cancer research. After years of study, we came to a hypothesis to be verified experimentally in collaboration with a field center. After many attempts (direct approach), no one has agreed to do this experiment. Please help make this research proposal possible. If proven true, it would change the medical approach to diagnosis and treatment of cancer and beyond. Yours sincerely, Dr.Viorel Bungau...




hr

The anthropomorphism of religion

I might deduce one final consequence of a skepticism in regards to temporality and causality. If our only experience of the world is of an existent reality, such that something uncreated or destroyed is literally unimaginable, the superfluity of religion becomes very evident. Since it is on the basis of a parallel between finite objects, which are presumed to be necessarily created, and the universe in its totality, which in turn therefore needs its Creator, that modern religions ultimately justify themselves, if creation, rather than lack of creation, is taken to be the phenomenon unjustified by experience then the concept of God is unwarranted.




hr

Beamten-Dreikampf für Fortgeschrittene: Beschließen, Ausfertigen, Verkünden

Lochen, Heften und Ablegen sind selbst für einen kleinen Beamten keine ernsthafte Herausforderung. Einen wahren Extremsport scheint hingegen das korrekte Inkraftsetzen eines Bebauungsplans darzustellen, zumindest in Nordrhein-Westfalen. Jedenfalls finde ich in der




hr

Führerscheintourismus einmal anders

Die Polizei in Irland ist einem geheimnisvollen polnischen Verkehrsrowdy auf die Spur gekommen, der landauf, landab die Straßen unsicher zu machen schien - denn gegen den seltsamen Herr Pravo Jazdy liefen Dutzende von Verfahren wegen Schnellfahrens und Parkverstößen. Und irgendwie schaffte es Pravo Jazdy immer, sich der Justiz zu entziehen, indem er eine falsche Adresse angab. Nun hat die Polizei dar Rätsel allerdings gelöst, wenn auch mit dem Ergebnis, dass sie die Bußgelder wohl in den Kamin schreiben kann. Zur Auflösung hier nur so viel: Es wäre nicht weiter verwunderlich, wenn auch ein französischer Adliger namens Permis de Conduire auf der Fahndungsliste stünde.




hr

Google Chrome 130.0.6778.70

Google Chrome is a browser that combines a minimal design with sophisticated technology to make the web faster, safer, and easier. One box for everything, type in the address bar and get suggestions for both search and web pages. [License: Freeware | Requires: 11|10|8|7|Linux|macOS | Size: Size Varies ]




hr

Google Chrome Portable 130.0.6778.70

Google Chrome Portable is a web browser that runs web pages and applications with lightning speed. It's designed to be simple and stylish. It's packaged as a portable app, so you can take yo... [License: Freeware | Requires: 11|10 | Size: 2 MB ]




hr

Parsley Sound, "Twilight Mushrooms"

A bit of an oddity for their label, Mo Wax, Parsley Sound was, at their most effective, a bit of dreamy indie-pop coming from a downtempo production approach. Sweet and gentle, a little twee, heavily filtered and electrified, despite pursuing a color palette that's au naturel, creaky, sun-bleached.

Perhaps this is what would've happened if Lemon Jelly had gotten Elliott Smith in the studio.




hr

Revival Now Pt7: A New Christlike Movement

Can we have a move of God that doesn't resemble Christ? Obviously not, but is Christ-likeness our emphasis in the church and as individuals? Do we look like Jesus? Do we sound like Jesus? In Part 7 of 'Revival Now', David Legge, using two fruit of the Spirit - Gentleness and Kindness - shows that what the church and the world most needs are Christians that look like Christ and exhibit His attributes to all, even our enemies. We will see real change in the church and society when people see Jesus in us through 'A New Christlike Movement'. This message is available at https://www.preachtheword.com now in MP3 audio format...



  • Religion & Spirituality

hr

Twas the Night Before Christmas by Lobotomy Boy

It's Christmas and Lobotomy Boy has a special version of "The Night Before Christmas" for everyone!

Enjoy this special Holiday Edition of Bedtime Stories My Kids Love.



MP3 File - Click Here to Download Podcast




GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com





hr

Christmas 2014 Pictures

Kate - 10, Claire - 8, Henry - 7, Jack - 5, Sims - 3, Miles - almost 2, Luke - 2 months
I couldn't figure out how to turn the self timer on so we didn't get a family picture - maybe next year.

   










hr

Alexa echoes through our home (Thanks Amazon)

When Amazon announced the Echo, I immediately requested access to purchase one. I read some skeptical blog posts about it, but had high hopes. We received ours back in December and since then it has become increasingly useful.

I will not list out everything we love about "Alexa", but I wanted to highlight one thing we do that has proven helpful. We have one iPad to share among the entire family and that can be problematic with 7 children. My wife came up with the idea of having the kids set a 20 minute timer on Alexa each time they begin using the ipad. It is simple and has changed our lives. The constant questions, "Mommy, can I have the ipad now," stopped immediately. And the amount of time on the iPad for each child was reduced without parental intervention.

Children are happier when they know their boundaries. This makes parents happier too. Alexa was just the tool we needed to reduce the amount of time kids were spending on the ipad and to ensure everyone has a turn.

The kids have also had their eyes opened to how easy it is to stay on the ipad for a really long time without noticing. It's a win all across the board. Thanks to Amazon and "Alexa". And thanks to my wife for the ingenious idea.




hr

Vijesti :: Potpisan sporazum o suradnji između Akademije za umjetnost i kulturu u Osijeku i Hrvatske komore dentalne medicine

Autor: Redakcija 031 Naslov: Potpisan sporazum o suradnji između Akademije za umjetnost i kulturu u Osijeku i Hrvatske komore den
Postano: 12.11.2024. 11:59 (GMT 1) Dana 11. studenog 2024., točno u 11 sati i 11 minuta, u Svečanoj dvorani Akademije za umjetnost i kulturu u Osijeku potpisan je sporazum o suradnji između Akademije i Hrvatske komore dentalne medicine. Sporazum su uime institucija potpisali dekanica Akademije, akademkinja Helena Sablić Tomić, i dr. sc. Hrvoje Pezo, predsjednik Komore.

Sporazum označava početak suradnje između jedinstvene umjetničko-znanstvene institucije u zemlji i strukovne organizacije koja predstavlja dentalnu medicinu u Hrvatskoj. Cilj je sporazuma objediniti znanje i resurse kako bi se postigli viši standardi u razumijevanju i unaprjeđenju zajedničkih područja djelovanja koji se protežu kroz edukaciju, zdravstvo, kulturu i interdisciplinarne projekte koji se razvijaju na specijalističkom studiju Kreativnih terapija pri Akademiji za umjetnost i kulturu u Osijeku.

Ovim partnerstvom želimo otvoriti nove mogućnosti suradnje u području obrazovanja i profesionalnog razvoja te omogućiti razmjenu iskustava između umjetničko-znanstvene zajednice i medicinske struke“, istaknula je akademkinja Helena Sablić Tomić. „Akademija i Komora mogu se zajedničkim naporima baviti istraživanjem novih pristupa u edukaciji kao i poticanjem šireg društvenog dijaloga o važnosti holističkog pristupa zdravlju.

Predsjednik Komore dr. sc. Hrvoje Pezo naglasio je da sporazum predstavlja jedinstvenu priliku za razvoj novih standarda u edukaciji o zdravstvenoj kulturi i prevenciji. „Spoj umjetničkog i znanstvenog pristupa, uz medicinsku ekspertizu, omogućuje nam da dublje sagledamo utjecaj koji zdravlje ima na svakodnevni život, ali i na kulturu i društvenu dinamiku. Vjerujemo da će se kroz ovu suradnju razvijati inovativni pristupi obrazovanju i informiranju javnosti,“ izjavio je dr. Pezo.


Tekst i foto: Akademija za umjetnost i kulturu u Osijeku




hr

Događaji - najave i recenzije :: Predstavljanje knjiga "Suvremeni hrvatski haiku - Nova antologija" i "Dosje i druge priče"

Autor: knjizaraNOVA Naslov: Predstavljanje knjiga "Suvremeni hrvatski haiku - Nova antologija" i "Dosje i druge p
Postano: 13.11.2024. 14:09 (GMT 1) Društvo hrvatskih književnika i Klub knjižare Nova pozivaju Vas na predstavljanje knjiga "Suvremeni hrvatski haiku - Nova antologija" i "Dosje i druge priče".

Na predstavljanju sudjeluju: Nikola Đuretić, Tomislav Maretić i Mirko Ćurić.

Predstavljanje će se održati u Klubu knjižare Nova (Trg Ante Starčevića 4, Osijek) u subotu, 16. studenoga u 11 sati.

Radujemo se Vašem dolasku!




hr

Vijesti :: Svaki četvrti Hrvat pati od ‘nevidljive’ kronične bolesti, pitali smo liječnika kako prepoznati simptome

Autor: Redakcija 031 Naslov: Svaki četvrti Hrvat pati od ‘nevidljive’ kronične bolesti, pitali smo liječnika kako prepoznati simp
Postano: 13.11.2025. 20:15 (GMT 1) Ne postoji jedna tableta koja će smanjiti probavne tegobe i mogućnost razvoja probavnih bolesti, kaže nam odmah prof. dr. sc. Silvio Mihaljević, specijalist gastroenterologije iz Croatia poliklinike u Osijeku.

Kako navodi, stres, neredovita prehrana, hrana s puno masnoća i koncentriranih ugljikohidrata su sve redom faktori koji mogu dovesti do prolaznih probavnih tegoba, a, ako su pacijenti duže vremena izloženi nepravilnom stilu prehrane, mogu dovesti i do razvoja ozbiljnih bolesti, kao što su GERB, ulkusna bolest želuca i dvanaesnika, NASH, upalne bolesti crijeva, i slično.

Učestalost ovih problema pritom je sve veća. Primjerice, više od pola milijuna ljudi u Ujedinjenom Kraljevstvu ima upalnu bolest crijeva, od kojih su dva glavna oblika Crohnova bolest i ulcerozni kolitis. One nastaju kada imunološki sustav napadne crijeva, uzrokujući niz iscrpljujućih simptoma od bolova u trbuhu i gubitka težine do proljeva i krvi u stolici.

Vrlo često se gore navedene bolesti razvijaju tijekom dužeg vremenskog razdoblja s vrlo nespecifičnim tegobama u samom početku bolesti. Upravo je zato izuzetno važno obratiti pažnju na preventivne preglede, kaže prof. dr. sc. Mihaljević, jer postavljanje dijagnoze u ranoj fazi bolesti značajno doprinosi kraćem trajanju liječenja, manjom mogućnošću za razvojem brojnih komplikacija, a samim time i boljom kvalitetom života i puno kraćim izostankom s posla.

Uzmimo za primjer samo nealkoholnu bolest masne jetre, jednu od najčešćih uzroka kronične bolesti jetre te najbrže rastuće bolesti probavnog sustava. Prema posljednjim podacima, svaki četvrti građanin Hrvatske ima nealkoholnu masnu jetru kao posljedicu nezdrave prehrane, konzumacije alkohola i nekretanja. Prof. dr. sc. Mihaljević navodi stoga da je iznimno bitna redovita kontrola laboratorijskih nalaza koji ukazuju na funkciju jetre jer kronične bolesti nemaju značajnije probavne tegobe, nego samo blage i nespecifične smetnje kao brzo umaranje i opća slabost.

Te nespecifične simptome pacijenti ignoriraju tako da se vrlo često brojne kronične bolesti jetre pronađu u poodmakloj fazi kada je liječenje manje uspješno. Zbog svega navedenog redovite kontrole jetrenih nalaza su najbitnije u ranom otkrivanju kroničnih bolesti jetre”, kaže specijalist gastroenterologije.

Kako bi potaknula građane na preventivnu brigu o zdravlju, Croatia Poliklinika u Osijeku do kraja studenog omogućuje 20 posto popusta na endoskopske zahvate - gastroskopiju bez i s anestezijom i kolonoskopiju bez ili s anestezijom. Naime, osobe koje u anamnezi imaju rak nekog od organa probavnog sustava trebali bi u ranijoj životnoj dobi obavljati preventivne preglede svake dvije godine, a osobe starije životne dobi jednom godišnje. Brojni ljudi pritom odgađaju ranije spomenute endoskopske zahvate zbog neugodnosti ili straha, zbog čega prof. dr. sc. Mihaljević ističe da je važno pacijentima objasniti važnost obje pretrage jer se promjene koje se nađu tim pretragama vrlo često ne mogu dokazati nikakvim drugim laboratorijskim i radiološkim pretragama.

Kada im se objasni važnost navedenih pregleda te mogućnost dokumentiranja određenih promjena puno lakše će se odlučiti za navedene preglede. Prije gastroskopije možemo lokalno dati anestetik koji će u znatnoj mjeri umanjiti neugodnost samog pregleda, a prije kolonoskopije savjetujem uzimanje pola sata prije pregleda spazmolitika kako bi usporili peristaltiku crijeva i na taj način umanjili tegobe. Za one najzahtjevnije i najkompliciranije, oba pregleda možemo raditi u općoj anesteziji”, navodi prof. dr. sc. Mihaljević.


[Sponzorirani članak]




hr

Three impossibilities with partitioned indexes

articles: 

There are three restrictions on indexing and partitioning: a unique index cannot be local non-prefixed; a global non-prefixed index is not possible; a bitmap index cannot be global. Why these limitations? I suspect that they are there to prevent us from doing something idiotic.

This is the table used for all examples that follow:

CREATE TABLE EMP
      (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,
       ENAME VARCHAR2(10),
       JOB VARCHAR2(9),
       MGR NUMBER(4),
       HIREDATE DATE,
       SAL NUMBER(7,2),
       COMM NUMBER(7,2),
       DEPTNO NUMBER(2) )
PARTITION BY HASH (EMPNO) PARTITIONS 4;

the usual EMP table, with a partitioning clause appended. It is of course a contrived example. Perhaps I am recruiting so many employees concurrently that a non-partitioned table has problems with buffer contention that can be solved only with hash partitioning.

Why can't I have a local non-prefixed unique index?
A local non-unique index is no problem, but unique is not possible:

orclz> create index enamei on emp(ename) local;

Index created.

orclz> drop index enamei;

Index dropped.

orclz> create unique index enamei on emp(ename) local;
create unique index enamei on emp(ename) local
                              *
ERROR at line 1:
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index

You cannot get a around the problem by separating the index from the constraint (which is always good practice):

orclz> create index enamei on emp(ename) local;

Index created.

orclz> alter table emp add constraint euk unique (ename);
alter table emp add constraint euk unique (ename)
*
ERROR at line 1:
ORA-01408: such column list already indexed


orclz>

So what is the issue? Clearly it is not a technical limitation. But if it were possible, consder the implications for performance. When inserting a row, a unique index (or a non-unique index enforcing a unique constraint) must be searched to see if the key value already exists. For my little four partition table, that would mean four index searches: one of each local index partition. Well, OK. But what if the table were range partitioned into a thousand partitions? Then every insert would have to make a thousand index lookups. This would be unbelievably slow. By restricting unique indexes to global or local prefixed, Uncle Oracle is ensuring that we cannot create such an awful situation.

Why can't I have a global non-prefixed index?
Well, why would you want one? In my example, perhaps you want a global index on deptno, partitioned by mgr. But you can't do it:

orclz> create index deptnoi on emp(deptno) global partition by hash(mgr) partitions 4;
create index deptnoi on emp(deptno) global partition by hash(mgr) partitions 4
                                                                *
ERROR at line 1:
ORA-14038: GLOBAL partitioned index must be prefixed


orclz>
This index, if it were possible, might assist a query with an equality predicate on mgr and a range predicate on deptno: prune off all the non-relevant mgr partitions, then a range scan. But exactly the same effect would be achieved by using global nonpartitioned concatenated index on mgr and deptno. If the query had only deptno in the predicate, it woud have to search each partition of the putative global partitioned index, a process which would be just about identical to a skip scan of the nonpartitioned index. And of course the concatenated index could be globally partitioned - on mgr. So there you have it: a global non-prefixed index would give you nothing that is not available in other ways.

Why can't I have a global partitioned bitmap index?
This came up on the Oracle forums recently, https://forums.oracle.com/thread/2575623
Global indexes must be prefixed. Bearing that in mind, the question needs to be re-phrased: why would anyone ever want a prefixed partitioned bitmap index? Something like this:

orclz>
orclz> create bitmap index bmi on emp(deptno) global partition by hash(deptno) partitions 4;
create bitmap index bmi on emp(deptno) global partition by hash(deptno) partitions 4
                                       *
ERROR at line 1:
ORA-25113: GLOBAL may not be used with a bitmap index

orclz>

If this were possible, what would it give you? Nothing. You would not get the usual benefit of reducing contention for concurrent inserts, because of the need to lock entire blocks of a bitmap index (and therefore ranges of rows) when doing DML. Range partitioning a bitmap index would be ludicrous, because of the need to use equality predicates to get real value from bitmaps. Even with hash partitions, you would not get any benefit from partition pruning, because using equality predicates on a bitmap index in effect prunes the index already: that is what a bitmap index is for. So it seems to me that a globally partitioned bitmap index would deliver no benefit, while adding complexity and problems of index maintenance. So I suspect that, once again, Uncle Oracle is protecting us from ourselves.

Is there a technology limitation?
I am of course open to correction, but I cannot see a technology limitation that enforces any of these three impossibilities. I'm sure they are all technically possible. But Oracle has decided that, for our own good, they will never be implemented.
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com




hr

cormoran feeder hrengel

cormoran speciland feeder medium 13''/ 3.90cw 25-80 grincl. 3 tipsincl. tanager 2000 rd molen




hr

Miers' Faith In Christ Made Her a Republican



According to an article in the New York Times, Supreme Court candidate Harriet Miers, born Roman Catholic, became an evangelical Christian and began identifying more with Republicans than with the Democrats who had long held sway over Texas politics.

She later joined the missions committee of her church, which is against legalized abortion, and friends and colleagues say she rarely looked back at her past as a Democrat. Miers attended "two or three" anti-abortion fund-raising dinners in the early 1990's, but has otherwise been active in the anti-abortion movement. According to one of Miers' colleagues:

"You can be just as pro-life as the day is long and can decide the Constitution requires Roe to be upheld".
That's an interesting theory, but why (or how) could somebody who has such deeply held values uphold a law that she is in a moral conflict with? Or for that matter, why would she even want the job?

That's quite a conundrum for anybody, and would be the first question I would be asking if I were on the Senate Judiciary Committee.




hr

Musical Christmas Love Greeting Cards, Romantic Christmas Cards

Share romantic Christmas love cards with music from RiverSongs.com with spouse or boyfriend or girlfriend! Send I Love You Christmas ecards for email, mobiles, whatsApp, Facebook and Twitter!




hr

Musical Christmas Cards, Merry Christmas Greeting Cards

Send the best Merry Christmas Ecards with music to friends and family! Listen to Christmas carols, share the Christmas Countdown Card and watch Christmas videos.




hr

Discover the Thrill of the Knubian Promotional 3-Point Contest

Participants of the Knubian contests often praise the organization of the events. Each contest is efficiently managed to ensure that players can focus on their performance without any logistical hassles.




hr

Award winning mushrooms in 1891 Railway Tunnel Tasmania

Photo: Off the Table Award winning mushrooms grown in 1891 Railway Tunnel in Tasmania Grown in a 1891 Railway Tunnel in Tasmania. Tunnel Hill Mushrooms Hidden under the surface at Mt Rumney on Hobart’s Eastern Shore in Tasmania is an old 1891 railway tunnel. It was opened in 1892, and closed in 1926. Since the...




hr

Nahost-Liveblog: ++ US-Militärhilfe wird nicht eingeschränkt ++

Die USA werden ihre Militärhilfe für Israel nicht einschränken. Washington hatte dies vor einem Monat angedroht. Israel will offenbar erneut Einberufungsbefehle für Ultraorthodoxe ausstellen. Die Entwicklungen vom Dienstag zum Nachlesen.




hr

Millionenentschädigung für drei Folteropfer aus Abu-Ghraib-Gefängnis

Fotos von gefolterten Häftlingen im Gefängnis Abu Ghraib im Irak sorgten vor rund 20 Jahren für Entsetzen. Elf US-Soldaten wurden seitdem verurteilt. Jetzt wurde drei früheren Häftlingen eine Millionenentschädigung zugesprochen.




hr

Panne an Flugzeug verzögert Rückkehr von Habeck aus Lissabon

Bislang ist Wirtschaftsminister Habeck von Pannen in Regierungsflugzeugen verschont geblieben. Doch bei der Rückreise von einer Tech-Konferenz hat es den Vizekanzler nun erwischt. Dabei hätte er Termine im Bundestag gehabt.




hr

Pentagon-Leaks: US-Nationalgardist zu 15 Jahren Haft verurteilt

Ein junger IT-Spezialist des US-Militärs hatte wiederholt geheime Dokumente im Internet veröffentlicht. Unter anderem ging es um Erkenntnisse zum Ukraine-Krieg. 2023 wurde er festgenommen. Jetzt ist er zu 15 Jahren Haft verurteilt worden.




hr

Wirtschaftsweisen legen ihr Jahresgutachten vor

Kurz nach dem Scheitern der Ampel und mitten in der Konjunkturflaute stellen die Wirtschaftsweisen ihr Jahresgutachten vor. Was hilft der Wirtschaft in der aktuellen Situation? Von Hans-Joachim Vieweger.




hr

Republikaner wollen Führungsposten im US-Kongress besetzen

Die US-Wahl ist gerade eine Woche her, und schon dreht sich das Personalkarussell in hohem Tempo. Heute wollen die Republikaner Führungsposten im Kongress besetzen und zeigen, dass sie die neue Macht im Kapitol sind. Von Katrin Brand.




hr

Video: Chris Sloan's "UHF" camera prop

On the TTM YouTube Channel: my onscreen bit about the camera supplied by Chris Sloan to the RSUTV "UHF" telethon last Saturday.




hr

British Maltese Biker Cross Throw Pillow

British Union Jack Flag Maltese Biker Cross Pillow for those that are into British motorcycles and choppers like Triumph, Norton and BSA - British Union Jack Maltese Biker Maltese Iron Chopper Cross t-shirts, sweatshirts and other cool stuff for British bikers, chopper riders, motorcyclists and fans of British motorcycles and the freedom motorcycling brings. Excellent gift for fans or riders of Triumph, Norton and BSA or custom built choppers and motorcycles.




hr

Jesus Is My Happiness Throw Pillow

This Throw Pillow can help you share the message of peace, love, hope, and happiness that can only be found in Jesus Christ our Lord and Savior - Is Jesus your happiness? Does Jesus make you smile? Does Jesus fill you with happiness? Does having Jesus within you and Jesus' arms around you bring you peace and security? Does the knowledge of Christ in your heart and life bring you joy? Whatever the reason is that Jesus Christ's salvation, love, peace, grace and mercy does for you, you know it is great, warm, wonderful, full of His love and makes you smile. The fish with a smiley face in the middle can mean several things to different people. It can mean "Jesus is my happiness", it can mean "Jesus the hope of glory" or "There is true happiness only through Jesus", "With Jesus, don't worry only be happy". Whatever it is to you, you can help share the message of peace, love and happiness that can only be found in Jesus Christ our Lord and Savior with the Christian fish symbol and the classic smiley face in the middle.




hr

Ace Biker Iron Maltese Cross Throw Pillow

The Ace Biker Iron Maltese Cross Throw Pillow is for bikers, chopper riders, custom bike builders, motorcyclists, motorcycle enthusiasts and anyone who enjoys the freedom that motorcycling brings - The Playing Card Ace Biker Iron Maltese Cross for bikers, chopper riders, custom bike builders, motorcyclists, motorcycle enthusiasts and anyone else who enjoys the freedom that motorcycling brings