Oracle 12c installed . Getting my #GEEK on this week.
… A Muse — ing
Studying up on Oracle v. 12c. As usual, there are many new features to recommend migrating or deploying to the new version of Oracle. Last blog, I talked about just a few: ILM, ADO, HEAT_MAP and how these buzz-worthy acronyms were related to compression inside the database. Before, I get into today’s topic, I wanted to talk about a bit more about the Automatic Data Optimization (ADO).
I failed to make clear yesterday, that the ADO, automatically relocates your cold data or compresses your data as it ages through its Lifecycle automatically. That is the magic. You define the policies and the database will relocate or compress a segment(s) or a row(s) to save space or to clear space on more expensive hard disk, by relocating to slower/less accessible disk storage media. Pretty nifty idea.
By the way, you may be wondering … 8i, 9i, 10g, 11g, 12c what is the pattern or meaning of these major release versions from Oracle.? Well, “8i / 9i” were from the era, when Oracle was the “Internet” database (you know like iPhone, or i-<Anything>). Then “10g / 11g” were to be the “Grid”. Grid never really achieved buzz-worthy status. Now we have “12c”. It should not surprise you that we are now in the “Cloud” era. So Oracle’s letters are for: Internet, Grid, and Cloud . Now you know.
That Cloud and yesterday’s ADO will figure in today’s blog too. You see, I was recently asked about Greenplum. Could I use it? As is my wont, I took a step back and studied the question. Here is my answer.
MPP – RAC(aka Oracle parallel server)
Full SQL (Postgres)
Full SQL (Oracle, ANSI)
Compression since 11g, ADO/ILM 12c
B-Tree / BitMap Indexes
B-Tree / BitMap Indexes
Parallel Query Optimizer
Parallel Query Optimizer
GreenPlum HD (HDFS)
External Tables using an HDFS
I believe that as an Oracle expert (28+ years from v2.0-11g inclusive), that I could effectively use Greenplum on a project. If you look at the above chart, I think you will see what I am about to explain.
Green is an MPP platform. Very nice acrhitecture. Oracle can sit on top of any architecture (MPP, SMP, or any cluster or Highly Available or Fault-Tolerant Failover set of servers) you can setup.
Both use FULL SQL. That means ANSI compliance and with enhancements (POSTGRES for Greenplum and ORACLE, uh, for Oracle).
B-Tree and Bit Map Indexes for both — yawn old hat. Parallel Query Optimizer – been there, seen that for a while.
Greenplum has JDBC/ODBC/OLE interfaces. Oracle has those too, plus a full complement of Pro*C (or many other languages) embedded pre-compiled 3GL languages. Oracle is well supported by Shell Scripts like PHP or PERL that have their interfaces to Oracle. Slight advantage to Oracle. But the point is, Oracle professionals have done this for more than a decade.
External Tables too are a feature in both databases. GreenPlum HD uses the External Table to provide HDFS access in GreenPlum via SQL or other in-database features. Now I had not previously thought to try and use HDFS with Oracle. But the External Table is precisely the feature I would use. Can it be done? A look at Oracle’s documentation answers that:
CREATE TABLE [schema.]table ( column datatype, ... ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY directory ACCESS PARAMETERS ( PREPROCESSOR HDFS_BIN_PATH:hdfs_stream access_parameters ... ) LOCATION (file1,file2...) );
So I recommend that companies fell free to utilize Oracle consultants on Greenplum databases. There is an awful lot of overlap that the Oracle specialist can leverage from his/her background and transfer to the Greenplum database.
Of course, for companies without Greenplum, it looks like you can use many of the same features already in Oracle including using HDFS filesystems with External Tables.
So get to that BigData, your friendly Oracle expert can help you.
Dateline 06 Aug 2013 —
If you are the same age as Stanczyk, then when you see the acronym, ILM, you probably think of George Lucas’ Industrial Light & Magic. But this article is about the Oracle of Larry Ellison. Oracle has released its latest version of its database, 12c, on June 25th, 2013.
So the ILM, of this blog is about Information Lifecycle Management. I thought you might need a buzz-word upgrade too — hence this blog. In the latest 12c, Oracle is advancing its ILM paradigm to make Automatic Data Optimization (ADO) a differentiator in Data / Databases. You see data storage is eating the planet or at least the IT budgets of many large companies. That Big Data has to live somewhere and the costs to house that data is very significant. Ergo, Oracle is giving you a way to Tier your data storage amongst differing costs media (hi to low) and using differing levels of compression, depending on your data’s lifecycle. Hence ILM.
The idea is that data ages from very active, to less active, to historical, to archival. You ideally would want to place the most active data on the fastest, most reliable, … most costly hardware. Likewise, as the data ages, it would be preferable to place on less costly storage devices or in a more compressed state to save space and costs. How can you do that effectively and without a large staff of IT professionals? This is where the ADO comes in.
Using your familiar create table or alter table commands you can add an ILM policy to compress or relocate your data. Oracle provides segment level or even row level granularity for these policies. How do you know what data is active vs inactive? Oracle has implemented a HEAT_MAP facility for detecting data usage. HEAT_MAP is a db parameter. Set it on in your init.ora file or via an alter session command in sql*plus (to do it on a session basis instead of database wide.
ALTER SESSION SET HEAT_MAP=ON;
You can check on things via:
SELECT * FROM V$HEAT_MAP_SEGMENT;
There is even a PL_SQL stored package: DBMS_HEAT_MAP.
So this is a quick update on ILM, ADO, and HEAT_MAP in Oracle 12c database. Go to the Oracle yourself and see what you can get on this new technology.
Dateline 22 Jul 2013 — FamilySearch.Org New Database
FamilySearch.Org has some new databases (don’t they always — they are amazing). One in particular caught this jester’s eyes.
United States, National Register of Scientific and Technical Personnel Files, 1954-1970,
By training and long years in the field, Stanczyk is a STEM worker. So I was drawn to this database. But who did I know had a degree and was a professional in 1954-1970 ? How about one of my favorite authors … in a register of Science / Technical professional? Well, yes — if you thought of Isaac Asimov .
If click on the FamilySearch.org link, then query on Isaac Asimov, you will see:
Stanczyk muses on the notion, does the British Royal Family need a court jester ? Perhaps, Harry would not want a competitor. Did you notice that the Duke & Duchess of Cambridge had a baby by any chance ? The Internet and CATV seems to have invested some bandwidth to this little story.
Here is the family tree from King George VI, through his daughter, HRH Queen Elizabeth II, Prince Charles (of Wales), Prince William (of Cambridge) and the latest addition, Prince George Alexander Louis.
Did you know that the “royals” get to pick their last name ? If you look closely at the tree you will see a variety of last names. We still do not know the new prince’s last name. His father Prince William’s name is at present, William Wales. So the new prince could be George Cambridge (or Windsor or Tudor or Mountbatten or Wales etc.). We are still waiting on the Duke & Duchess for the full name. By the way, I notice only three given names. I believe there may yet be a fourth given name as well as the surname. I also do not think he can be Prince … of Cambridge, since that is his father. Is it not true that each prince must have their own principality?
By the way, the baby prince might not be King George VII. The young prince’s great-great grandfather became George VI at coronation. King George VI ‘s birth name was: Albert Frederick Arthur George. So George was his fourth given name. Might the baby be King Louis ? That name seems to be a bit too French for the Britains to accept.
Royal Genealogy – so many traditional formalities. Just Fascinating.
Do any of you, my regal readers, have any Polish Royal Blood in your family tree? Any Szlachta out there?
Email me this poor jester (without a court) !
Stanczyk has been a bit busy since the 4th of July! So forgive me if I play a bit of catch-up on my blog.
A bit of bigos (recipe) !!
Let me point out that in June the Polish Archive completed their latest update on: ♥ http://szukajwarchiwach.pl/ .
Unfortunately, it did not include anything from the old wojewodztwo: Kielce (now in SwietoKrzyskie). See the image of the drop down menu below (not full listing but to give you an idea on what is in and how that is somewhat limited for researchers like Stanczyk. I hope another phase will commence soon!
♥ genealodzy.pl - They added the death records from 1875-1908 for Pacanow parish to their Geneszukach database. Previously they had added the Birth and Marriage records. These are transcription / indexes, not actual church record images such as you find in their Metryki database.
Still I have found dozens of Eliasz (and … Gawlik, Gronek, Hajek, Kedzierski, Leszczynski, Major, Paluch, Wlecial, Zasucha, etc.) that I was previously unaware of. Now I will need to get the actual images in order to make sense of these indexes and the new people in order to add them to the family tree.
Enjoy the bigos. Smaczne (delicious)!
Yesterday’s (1st July 2013) Philadelphia Inquirer [go to your local library] had a reproduction of their newspaper from 1863 commemorating the 150th anniversary of the Battle of Gettysburg.
This is running now along with the Welcome America Festival in Philly. There are Civil War reenactments this week in Gettysburg.
Happy Fourth of July!
Stanczyk sees that the good people of the PGSM are promoting a genealogical tour — The Historical Tour of Mt. Olivet Cemetery in Detroit, on Saturday, June 8th, begins at 2 p.m. They are commemorating the cemetery’s founding (1888) and 125th Anniversary.
Check Out the Facebook page and albums. The Cemetery is located at:
17100 Van Dyke Detroit, MI 48234
Stanczyk is a bit uncertain. It seems like every day there are some new vital records indexes or even actual register scans themselves made available from congregations all over the Central European — Jewish, Catholic (Roman & Greek), Orthodox, Lutheran/Evangelical lands that make up Poland or a land that was once within the Polish-Lithuanian Commonwealth (the 1st Republic) or any of the variations between those times. So I thought I would step back and take stock of what was available. Yes, I know this will be out of date by tomorrow. But here is a quick & dirty, handy reference list of where to go looking. Clip & Save.
AGAD Księgi metrykalne – Eastern Borderlands (Ukraine, Russia Jewish Pale, etc.) —
(scans by Sygn.: http://www.agad.gov.pl/inwentarze/KMLw301.html#idp1765776 )
Prussian Poland Parishes
BASIA - http://www.basia.famula.pl/en/ - State Archives in Poznan, the Wielkopolska Genealogical Society (WTG “Gniazdo”) project.
Poznan Marriage Project - http://poznan-project.psnc.pl/
Pomorskie Towarzstwo Genealogiczne - http://www.ptg.gda.pl/
All Poland & Eastern Borders (PTG)
METRYKI (parish register scans)– http://metryki.genealodzy.pl/
Szukajwarchiwach (Poland’s National Archives online) - http://szukajwarchiwach.pl/
This is the latest project and is shooting to have 5.8 Million records by the end June (this month) scanned and on-line by Polish Archive or National Museum.
Jewish Record Indexing (JRI) – http://www.jewishgen.org/jri-pl/jriplweb.htm
The venerable project with new life provides indexes to registered users (free) and then you can purchase the actual church record. Great for Jewish Pale & Russian Poland, plus so much more.
Metryk.GenBaza.pl - http://metryki.genbaza.pl/genbaza,list,4,1 (AP GRODZISK). Archive in Grodzisk Mazowiecki (Russian Poland parishes near Warsaw).
Besides the 5 parishes below, you might want to have a look at holdings for:
Austria, Germany, Russia & Ukraine
|Poland, Częstochowa Roman Catholic Church Books, 1873-1948||Browse Images||14 Feb 2013|
|Poland, Gliwice Roman Catholic Church Books, 1599-1976||Browse Images||14 Feb 2013|
|Poland, Lublin Roman Catholic Church Books, 1784-1964||99,510||14 Feb 2013|
|Poland, Radom Roman Catholic Church Books, 1587-1966||18,916||21 Apr 2013|
|Poland, Tarnow Roman Catholic Diocese Church Books, 1612-1900||1,002,155||6 Jan 2012|
Did I miss any? Email Me … Proszę !
http://regestry.lubgens.eu/news.php - from Valerie Warunek (PGSM). Database of Indexed church records (birth/urodzenia, marriage/malzenstwa, death/zgony) from Lubelskie wojewodztwo. No scans (skans), but it does have record (akt) #’s.
Happy Birthday Matolek, sto lat. Koziolek Matolek (Matolek the Billy-goat) was born in 1933. You might say he put Pacanow “on the map”. You see Matolek wanted to go to Pacanow because he heard that you could get good (goat) shoes in Pacanow.
Now this charming character has always had a special place in Stanczyk’s heart, because my great-grandfather, Tomasz Leszczynski was a shoe-maker (szewc) / inn keeper. So perhaps Matolek would have bought his shoes from my great-grandfather. Did he ever find Pacanow? I do not know.
Well, it is now 80 years later and Pacanow is celebrating this cult-favorite May 31st – June 2 this year! Their program can be found here . Like Matolek, I too have been trying to get to Pacanow.
Dateline — Philadelphia’s Ellis Island 1913 — Emigration to Philadelphia peaked in 1913. Good thing for this jester, as my aunt Alice (Aleksandra) and my Busia (grandmother) arrived September 15th, 1913.
100 years later her grandson is here! Full circle. Eliasz in America.
15 – September – 1913 - Prinz Adalbert
Chelsea Handler, Kelly Clarkson, Zooey Deschanel,
Cindy Crawford, Christina Applegate, Chris O’Donnell, plus two more ?
Now I have 36 more Eliasz / Elijasz to factor into this tree:
Birth Year Birth Akt# FULL NAME
Are one of these your grandfather / grandmother ? Email me.
Stanczyk, has been sifting through the Index created on genealodzy.pl in their Geneszukacz database. Alright, only the Births Index, so far.
I see they have a total of nearly 7,300 people from those years (1875-1908) in their Birth Index. From Adam … Żyp . There were 58 ELIASZ in their index.Notice they used ELIASZ and not ELIJASZ. I found that interesting. They removed ‘J’ when they produced the index. Was that an error? Or was the indexer an expert? Because, in my heart of hearts, I believe the name (at least back to 1690) was ELIASZ.
It was only since 1869 when the Russian Empire forced Poland to keep records in Russian (Cyrillic) that the ‘J’ appeared from the Russian character ‘я’ (Ya) that ELIASZ became элияшъ . элияшъ is transliterated in a Latin alphabet as ‘Elijasz’.
I only wanted to mention this as while I believe the translated properly produced the index with respect to ELIASZ; You will need to realize that finding the record in Russian/Cyrillic, you will need to look for a different translation (i.e. ELIJASZ/элияшъ) in the indexes and the actual church records.
So now I have an index of ELIASZ born in Pacanow in the years 1875-1908. Now what? I compared the list of 58 with what I already had/knew. I saw an overlap of 22 people. So I have 36 new ELIASZ to resolve and add into the family tree. My options are:
The year range 1875-1908 is not completely in LDS microfilm. Although 1875-1884 is in LDS MF #’s:
So doing research in a local Family History Center or at the Family History Library (Salt Lake) is not an option for the remaining 36. So I now have better options for remote research.
My List of 58 ELIASZ.
My ancestral village, PACANOW, was indexed for BIRTHS (1875-1908). I was able to verify it was correct with my grandfather (whose Birth Record I have) and a few others. I also found some I did not know about !!! I only wish they had the images (like in METRYKI database). Thank you: Wojciech Liśkiewicz (who I think was the indexer)!
Later in the day they(he) also added MARRIAGES(1875-1908) too.
Stanczyk loves the history of our nation (USA). The U.S. history is much younger than our European ancestral villages. But, in 2013, we will celebrate and remember the Battle of Gettysburg July 1-3rd, 1863 on its 150th anniversary.
Philadelphia is the cradle of American Civilization. During the Fourth of July Celebration (Welcome America), in addition to the normal July 4th celebrations, there will be additional events this year, the 150th after the battle of Gettysburg.
Philadelphia ‘a living monument’ to the Civil War [Philadelphia Inquirer article]
There are so many historical and genealogical things to experience beyond the fireworks & concerts:
Stanczyk, was not intending to write a blog post today. I hope Genealogy Moms are having a wonderful day today … too.
Yesterday, I was researching on FamilySearch.org. On a lark, I thought I would look at Croatia. In particular at Tenje. I did that because my maternal grandmother, Roza Göttler (aka Gottler/Goettler/Gettler). From her ship manifest, I knew her to come from Tenje (which was Austria-Hungary, then Jugoslavia, now presently Croatia). This explains the ever changing ethnicity throughout the US Federal Censuses. I did indeed find Gottlers in Tenje. I did not find my grandmother’s parents or my grandmother … unfortunately the years available online would not meet my needs. But something unusual happened. I found other affiliated family names: Eisenbeiser and Elter. So I am now convinced that Tenje (the Roman Catholic records) is where I will find my maternal grandmother.
That was so uplifting, on a lark, I thought I’d search for my maternal grandfather’s village. His was a bit of a problem too. Differing country names (like Roza Gottler), but his village name changed often too, so even though I had ship manifest, Declaration of Intent, and finally a Petition for Naturalization, I was still uncertain where he was from. I was pretty sure he was from the same area as Roza Gottler. My paternal grandparents were both married once, before they married each other and had my mother. So my grandfather emmigrated alone and my grandmother emmigrated with her first husband (John Reiner). Over the years, I developed many clues which I collected even though they did not fit together. This weekend, the clues came together! These stray clues allowed me to verify that the records I was viewing were my own family. What a gift on Mother’s Day weekend. I found both of her family parents’ families this weekend!
It turns out that my grandfather was born in Sarvas (now in Croatia) and in the same district as Tenje. So all those sources: Sawas is from Ship Manifest , then Storvish is from Declaration of Intent, and Dowash is from the Petition for Naturalization. The first Vespek birth record I found spelled the village as Starvas. These are all the same place! Some were slightly misspelled. Now I can see it. So in the same FamilySearch project in two different villages I found my maternal lines. Some direct lines, some indirect branches, others are affiliated families.
So I have set a fairly high level of confidence in these findings. As such, I believe I have found my Great-Grandfather Vendelin Vespek’s birth record. This is not 100% certain and I have to find 1 or 2 missing pieces to make it a 100% certain. For those who are second (or 3rd) cousins researching in the Vespek family tree pay attention to the remainder and download the image at the top.
Croatia, Church Books, 1516-1949 Roman Catholic (Rimokatolička crkva), Sarvas
Sarvaš Births (Rođeni) 1847-1865 [for Vespek, Kasper, Kantner, Fechtig, Emert, Platz, Zorn]
URL: FamilySearch Sarvas, Croatia [image 66 of 298]
Birth 8th / Baptism 9th – November – 1858
Vendelin son of Vendelin Vespek & Catherine Kaschper (aka Kasper)
born in Sarvas, House #43
Godparents: Tobias Jobst & Joanna Kreines
See Also …
Tenje (Osijek) – FamilySearch.org [for Gottler, Eisenbeiser, Elter]
Even though most of the records are in Latin, there are still records in Croatian.So for my Polish genealogy researchers, I would hasten a tip. As I was doing this I saw month names that were close to month names for Polish. Croatian is a Slavic language (albeit Southern Slav). So when I saw LISTOPAD (Croatian), I was immediately thinking NOVEMBER (in English), because LISTOPAD in Polish = November in English. But in Croatian, LISTOPAD = October. Surprise!
From Google Translator:
January, February, …, December – (English)
Sijecanj, Veljaca, Ozujak, Travanj, Svibanj, Lipanj, Srpanj, Kolovoz, Rujan, Listopad, Studeni, Prosinca – (Croatian)