Archive for ‘Databases’

Stanczyk is working out a rather difficult piece of analysis. This jester uses Social Network Analysis (#SNA) to assert a familial relationship or connection. It is labor intensive / data intensive process. Prior analyses have been very excellent at predicting valuable lines of research that have led to many further finds.

The moikrewni.pl tool for mapping names (shown in the image above) — shows that Pieszczochowicz is a rather rare name and only exists for some 20 people. The locales, I cannot draw conclusions from, but the numbers say that most if not all PIESZCZOCHOWICZ are closely related by its scarcity. So the name Pieszczochowicz enters my family tree in the following way:

Leon Pieszczochowicz (b. 7-NOV-1865in Górek, Strożyska, Kielce Gubernia, Poland), son of Konstanty Pieszczochowicz & Maryanna Rzepała. Leon married Jozefa Leszczyńska (b. about 1861 in Biechów, Kielce Gubernia, Poland), daughter of Tomasz Leszczyński & Julianna Kordos. I am sur ethey many children, but I only know of one child: Edward Pieszczochowicz. Now, Edward, comes to the USA from his father Leon in 1910 (who was living in Busko) to his uncle Jan Pieszczochowicz in West Seneca, NJ. Edward, continues onto to Toledo, Lucas County, Ohio. He will move on to Lackawanna, Erie County, NY in later life. But while in Toledo, he becomes the God Father of my own uncle: Stephen Edward Eliasz (son of Joseph Eliasz & Waleriya Leszczynska) at St Anthony’s Church on Nebraska Ave. in Toledo, OH in 1916. Edward Pieszczochowicz’s own God Parents were: Wladyslaw Fras (husband of Agnieszka Leszczynska) & Antonina Leszczyńska (probably nee Sieradzka, married to Jan Leszczyński). So what we see from this one affiliated family is what I considered a very highly connected value to my LESZCZYNSKi research and even so far as to connect my own ELIASZ line as well. We also see the FRAS (aka FRASS) affiliated family and the I believe the SIERADZKI affiliated family.

When I first captured Edward Pieszczochowicz at the birth/baptism of my uncle Steve, I had no idea who Edward was and had thought him a family friend [not a family member]. So you see over the span of time the collected data and SNA analysis of other data can connect disparate data points and prove out relativity.

Let me end today’s blog article, by returning to the fact that since PIESZCZOCHOWICZ is rather rare, that I am now seeking out Jan Pieszczochowicz and two others: Boleslaw & Stanley Pieszczochowicz (these two also show up in Toledo, OH at 3224 Maple Street). Will this family lead me to my LESZCZYNSKI roots? Time will tell.

Today’s blog is a three page posting, or rather a re-posting of a Facebook posting I made in Polish Genealogy Facebook page. This is just the GenBaza data for old Gubernia: Kielce/Kieleckie. This is a long read — hence the read “More …” breaks.

About two years ago Stanczyk wrote about a website, special because it was a Polish-German joint effort at Reconciliation. The website I am referring to is: http://www.straty.pl/index.php/szukaj-w-bazie — Which takes you to a database search page where you can search for, “Victims of Oppression“. It for searching for victims of World War II inside Poland. Originally, I kind of ignored it because I did not have family who was sent to a Concentration Camp nor did any of mine get forced relation after the war. So I MISTAKENLY thought this database was not for me. Last week I learned a few things.

Today’s blog is about the Mash-up of Geneteka database, Using Straty.pl (the above database of oppression) and a website of Concentration Camps, with a smidgeon of Genbaza.pl thrown in for good measure.

Here is my Mash-Up …

I went to straty.pl (use above link, for Polish) or paste the above link into Google’s Translator (for English). I put ‘Elijasz’ into the field named “Nazwisko” (Surname) and clicked on the button “Szukaj” (Search). It returned four results for me:

Notice the third row, with Stanislaw Elijasz, whose “Miejsce urodzenie” (birth place) was Pacanów. When I clicked on the button with the number “3”. Remember his birthdate: 1906-04-17 ; We will use this data in Geneteka to get the Akt # and in GenBaza.pl to get the image of the birth record. When I clicked on the number “3” button, I got a lot more info:

I immediately, understood my mistake. The oppression database returned data about my ancestor, Stanislaw Elijasz who was a soldier in the Polish Army when World War II started (1-SEP-1939). He is listed as a victim of the September 1939 Campaign, he was caught, in “Russland” [I presume they mean in the Russian Occupied territory as opposed to the German Occupied Poland.], he was the equivalent of a Lance Corporal in a Signal Corps Battalion. At any rate, he was interred in POW Camp (the 1st of three) on September 17, 1939. Imagine that, he spent the entire World War II as a prisoner of war.

The other details were vague and not clear to me from the data. Lucky for me in Facebook, I have a friend, named Jozef Taran (in Poland). He provided me a website for concentration camps:

This second mash-up link was website of German Stalags (Concentration Camps) in Poland, Ukraine and Western Russia. This website and wikipedia pages gave me the details to understand the data returned by straty.pl for Stanislaw. You World War II military buffs take note !

Ok, but now I wanted to find which Stanislaw Elijasz of Pacanow, born on or about 17-APRIL-1906 was this data about. So I went to:

Geneteka.pl — to see if Stanislaw was indexed and what his birth record number (Akt #) might be to help me in my search of GenBaza.pl and to confirm the birth date. I found on result number 46, a result for Stanislaw born in 1906 Pacanow with an Akt # 77. Now I had enough info to locate his birth record in:

GeneBaza.pl — That link takes you directly to Stanislaw Elijasz, born in Pacanow on 17-April_1906, Akt #77 [assuming you have a GenBaza login id and you are logged in]. This gives the the church birth record image:

Now we have a complete picture of our Polish ancestor by the mash-up of websites:

What I noticed besides he was very busy indexing things and putting them online for searches is two things:

In my 1st thought I noticed, “Collections” (each a menu to a page of resource links)

My 2nd thought was Logan added a Latin-to-Cyrillic feature

I do not mention his excellent little piece of code to implement a keyboard for implementing whatever language’s special characters that are a might difficult to type on American keyboards. That I posted about before.

Obviously this is the Gubernia of my paternal ancestors. So I was excited and I knew it was in Russian (i.e. Cyrillic characters) — a challenge. AH, … now we see the need for the 2nd thoughtful feature, ‘Add Latin->Cyrillic’. This feature automatically adds the equivalent Cyrillic characters to the Latin characters you are searching for, in order to locate the equivalent, transliterated string in the Russian Directories. That is well thought out! Indeed Genius!

So my thanks to Logan for his fine piece of programming and history/genealogy indexing that he has done. If you have not done so, you owe it to yourself and your research to check out Genealogy Indexer. Add it to your social network (Facebook and Twitter) and bookmark the website in your browser.

Stanczyk was Reading Eastman’s Online Newsletter. Today he informed me that there is an app for “that”. Now it is becoming a running joke — so I laughed when I read that Icelanders needed an app to know if they were dating a cousin or not (already available for Android and this jester asked about an app for iPhone/iOS − will update later when a reply is received).

Now this jester has known for some time that if you want to research closed genealogical populations, particularly for DNA, you study the American Amish and you study Iceland. According to the CIA Factbook (for Iceland), there will be a projected population of slightly over 317,000 this July. A common settlement date of 874 C.E. is accepted to be earliest time, but there is new evidence that Iceland may have been settled even a bit earlier than that. Almost everyone dates from the original settlers (Iceland has a very low immigration population).

In a previous article about this, back in 2007 (which I see was updated January 2014). The websiteislendingabok.is (online database), which hosts the online registry Íslendingabók (“The Book of Icelanders”). Íslendingabók is the product of a cooperation between Icelandic company deCODE Genetics and Fridrik Skúlason.

Genealogists in Iceland say all Icelanders are descendants of the bishop Jón Arason and according to islendingabok.is. Arason and his partner, Helga Sigurdardóttir, had at least nine children who were all quite fertile, while many of the other members of the then 65,000 population weren’t. So experts argue all Icelanders alive today probably derive from the good bishop. On the website of the University in Iceland this argument is supported by their mathematical formula.

The Getty Museum released on 14th-August-2013 over 4,000 images into public domain (i.e. free). According to the ArtObserved article on the museum’s public release made public on their Getty Iris blog, this is part of their, “Open Content” commitment of their digital resources.

Stanczyk, knows what you’re thinking, “I am too busy on my genealogy to search through museum images”. But I politely urge you to reconsider. While I was searching their images, I found a genealogical family tree, of Duke Ludwig I of Brzeg (amongst many other images he commissioned). A Polish noble of house Piast. So if your family tree intersects, get thee to the Getty Museum. For those curious, I have posted the images to this blog. The text is Fraktur looking, gothic, German script.

Oracle’s newest database (version 12c) has many new features, the discussion of which are too big for a single blog article (or even a series of blogs). The substantial high-level bulleted list of new features is in the 12c New Features Manual. But the concepts and low level SQL language details show a much larger change then you might perceive.

Multitenant Database

The new paradigm shift, Multitenant Databases, will stop DBAs pretty quick, particularly in Windows where the installer creates a Container DB. Previous to 12c, all databases were Non-Container DBs. With 12c you can create a Non-Container DB or a Container DB. The Container DB can have zero, one, or more Pluggable DBs within. A Non-Container DB can never have a Pluggable DB. So that becomes an upfront database creation decision.

I first relaized the Oracle Installer had created a container database for me when I went through the normal process of creating a database user using the same old techniques I always did and received an Oracle Error: ORA-65096. WHAM, I slammed right into the new paradigm without me even knowing it existed. The error description and the necessary action introduced to another part of the Multitenant Database paradigm: Comon User vs. Local User. That quickly led to Containers. Of course, with any new features, comes an array of new database schema tables like, v$pdbs for example. You will also probably use a new Sql*Plus command a LOT: SHOW CON_NAME to know what container (root or pluggable database) you are connected to. Some DBA commands must be done in the root container (CDB$ROOT). Your pluggable databases (in Windows) will be by default: PDB$SEED and PDBORCL. Every container database has precisely one seed pluggable database from which all pluggable databases are created from.

This paradigm shift will be seriously disorienting feeling to long time DBAs, especially if were not aware this was coming. Fortunately, there are many DBA bloggers out there sharing their 12c experiences. They were a help for me to gather the necessary jargon. But it was not until I discovered that Oracle had created a tutorial on Multitenant Databases and I had spent an hour or two playing with the tutorial on my newly created sandbox database (on Windows) which was by default a Container DB. This tutorial is an excellent way to jump start your understanding of the new paradigm.

By the way, I think either the default should be a NON-CONTAINER DB (so you are backwards compatible) or the Oracle Intsaller needs to make it clear that a CONTAINER DB will require new DBA processes (i.e. a learning curve) and give you an OVERT option to create a NON-CONTAINER DB for backwards compatibility.

Conclusion

Read the Oracle Introduction to Multitenant Databases to understand the concepts. Then immediately work your way through the tutorial in a test database that is a Container DB. Ultimately, I think Container DBs are the way to go. I think this is what you want to do to implement a CLOUD or in a Virtualized Environment.

Stanczyk has been a bit busy this past week with Oracle 12c (database) ! So forgive me if I play a bit of catch-up on my genealogy.

I have analyzed the data from GENEALODZY.PL in their GENESZUKACZ database for Pacanów Births (1875-1908). So now I need some help (pomoc). In my notes column I have noted the ELIASZ that I have in my family -or- my guess. The empty notes fields are ELIASZ that I need help with. If you are a genealogist with these people in your family tree then please email me your info and if possible any images of church records or family photos.

#

Year

/ Rok

Rec#

/ Akt

Imię

Nazwisko

NOTES

1

1875

110

Wacław

Eliasz

in my tree; son of Wojciech Eliasz & Agnieszka Pyszkow; [image]

2

1876

109

Marianna

Eliasz

daughter of Ludwik & Elz. Miklaszewski

3

1878

59

Katarzyna

Eliasz

4

1879

20

Roman

Eliasz

son of Ludwik & Elz. Miklaszewski

5

1880

52

Jan

Eliasz

son of Jozef Eliasz & Petronella Zwolski

6

1880

160

Jan

Eliasz

My grand-uncle Jan; son of Jozef Eliasz & Marianna Paluch

7

1881

28

Jan

Eliasz

Martin Eliasz’s (& Julianna Odomski) son

8

1881

30

Julianna

Eliasz

9

1881

130

Tomasz

Eliasz

son of Ludwik & Elz. Miklaszewski

10

1882

128

Wincenty

Eliasz

son of Jozef Eliasz & Petronella Zwolski

11

1882

157

Marianna

Eliasz

Martin’s (Julianna Odomski) daughter

12

1882

185

Katarzyna

Eliasz

A Grand-Aunt

13

1883

25

Roman

Eliasz

14

1884

33

Apolonia

Eliasz

Martin’s daughter

15

1884

71

Marianna

Eliasz

16

1885

46

Józef

Eliasz

My Grandfather; Have Birth Record

17

1885

125

Marianna

Eliasz

18

1886

189

Jan

Eliasz

19

1886

238

Szczepan

Eliasz

20

1888

104

Julianna

Eliasz

A Grand-Aunt

21

1888

123

Teofila

Eliasz

22

1889

71

Józefa

Eliasz

23

1889

109

Antoni

Eliasz

??possibly son of Ludwik & Elzbieta M.

24

1890

24

Katarzyna

Eliasz

25

1890

149

Marianna

Eliasz

26

1890

181

Stanisław

Eliasz

Martin’s son, dies in Detroit (Stanislaw Elyasz in October 1923)

27

1891

186

Stanisław

Eliasz

28

1891

190

Franciszka

Eliasz

29

1892

68

Wincenty

Eliasz

30

1892

83

Władysław

Eliasz

My Grand-Uncle

31

1892

206

Marianna

Eliasz

32

1893

143

Anna

Eliasz

33

1893

237

Marianna

Eliasz

34

1893

261

Agnieszka

Eliasz

??? Agnieszka Marianna E. that marries S. Hajek (Cleveland) ???

35

1895

30

Marianna

Eliasz

36

1895

230

Tomasz

Eliasz

My Grand-Uncle (Dorota’s grandfather); Have birth record

37

1896

164

Wacław

Eliasz

38

1897

8

Julianna

Eliasz

39

1897

236

Julianna

Eliasz

A Grand-Aunt

40

1898

103

Anna

Eliasz

41

1899

63

Balbina

Eliasz

42

1899

79

Zygmunt

Eliasz

??? Zygmunt Elijasz son Jozef E. & Theresa Siwiec??? PROBABLY not since Zygmunt was born in Biechow in 1898 (April 19)

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.

—

GreenPlum

Oracle

MPP platform

MPP – RAC(aka Oracle parallel server)

Full SQL (Postgres)

Full SQL (Oracle, ANSI)

Compression

Compression since 11g, ADO/ILM 12c

B-Tree / BitMap Indexes

B-Tree / BitMap Indexes

JDBC/ODBC/OLE

JDBC/ODBC/OLE/Pro*C (etc.)

Parallel Query Optimizer

Parallel Query Optimizer

External Tables

External Tables

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:

CONCLUSIONSo 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.

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 .

So what data is in this database …

If click on the FamilySearch.org link, then query on Isaac Asimov, you will see:

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!

Meanwhile on:

♥ 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.

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.

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.

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:

Write to Pacanow parish and request specific records (since I have year, Akt#),

Write to Polish National Archive (again with detailed info),

Hire a genealogist in Poland,

Go on a genealogical tour to Poland.

The year range 1875-1908 is not completely in LDS microfilm. Although 1875-1884 is in LDS MF #’s:

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)!

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.

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!