Archive for ‘Internet’

August 12, 2013

Oracle 12c – Multi-Tenant Databases — #STEM, #Oracle

by C. Michael Eliasz-Solomon

Oracle12c

Oracle 12c

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.

You can and you should read the Oracle Intro to Multitenant Databases .

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.

August 8, 2013

Wordless Wednesday — #Oracle, #12c, #STEM, #GEEK

by C. Michael Eliasz-Solomon

Oracle 12c installed . Getting my #GEEK on this week.

 

Ora12c_Installed

August 7, 2013

Oracle v 12c … vs. Greenplum MPP — #STEM, #Oracle, #Greenplum, #BigData

by C. Michael Eliasz-Solomon

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:

LINK: http://docs.oracle.com/cd/E27101_01/doc.10/e27365/directhdfs.htm

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...)
                      );

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

August 6, 2013

This Jester Has Been Consulting the Oracle — #STEM, #ILM, #ADO, #Oracle

by C. Michael Eliasz-Solomon

Dateline 06 Aug 2013 — 

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

ILM_ora

Source:  Oracle Documentation

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.

Tags: , , , ,
July 28, 2013

FamilySearch.Org — #Genealogy, #STEM, #Database

by C. Michael Eliasz-Solomon

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 .

So what data is in this database …

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

Asimov

July 14, 2013

A Bit of Blog Bigos … #Genealogy, #Polish

by C. Michael Eliasz-Solomon

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.

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

 

SzukajArchiwum_June

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.

Enjoy the bigos. Smaczne (delicious)!

June 2, 2013

Polish Vital Records On-line — A Survey #Genealogy, #Polish

by C. Michael Eliasz-Solomon

Metryka_Urodzenia_Births

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.

Cut— — — — — — — — — —

Poland – Archives & Genealogical Societies

AGAD Księgi metrykalne – Eastern Borderlands (Ukraine, Russia Jewish Pale, etc.) —

http://www.agad.gov.pl/inwentarze/testy.html

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

GeneSzukacz  / Geneteka (indexes, some scans) –  http://www.geneszukacz.genealodzy.pl/      &      http://geneteka.genealodzy.pl/

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

Family Search.Org 

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

Other (Inne)

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.

May 21, 2013

Pacanow 1875-1908 Index

by C. Michael Eliasz-Solomon

St. Martin -  Pacanow Church about 1918

St. Martin – Pacanow Church about 1918

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:

  1. Write to Pacanow parish and request specific records (since I have year, Akt#),  
  2. Write to Polish National Archive (again with detailed info),
  3. Hire a genealogist in Poland,
  4. 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:

1192351 Item 10,    1192352 Items 1-2,   1807621 Items 8-11,    1807622 Items 1-3

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.

May 19, 2013

Genealodzy.pl – Geneszukacz Database, Pacanow 1875-1908 — #Polish, #Genealogy, #Pacanow

by C. Michael Eliasz-Solomon

Genealodzy_plOn http://genealodzy.pl/  Stanczyk  saw that they have an updated GENESZUKACZ database.

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.

BIRTHS

MARRIAGES

See Also:

Domagala, Hajek, Kedzierski, Odomski, Paluch, Poniewierski, Siwiec, Wlecial, Wojtys, Zasucha, Zdziebko, Zwolski

May 12, 2013

♥ Happy Mothers Day ♥ — #Genealogy, #German, #Croatia, #Vespek

by C. Michael Eliasz-Solomon

VespekVendelin_Birth18581108_SarvasCroatia_GGrandfather

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.

NOTES:

Croatia, Church Books, 1516-1949 Roman Catholic (Rimokatolička crkva), Sarvas

Corresponding LDS MF #’s – 1739003 Items 4-5,  1739004 Items 1-7

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]

URL:  Tenje

P.S.

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)

May 5, 2013

Sanborn Insurance Maps online …

by C. Michael Eliasz-Solomon

LisaCookeLisa Cooke (@LisaCooke) tweeted …

Digitized historic Sanborn Fire Maps are available from the Digital Public Library of America … a t:  http://pinterest.com/pin/14847873744179015/

At first I was hopeful, but alas only maps from GA, KY (only Frankfurt?), and San Franciso (CA). For genealogists in those locales these are a treasure trove of info about the historic residences.

See Also:

Library Of Congress – http://www.loc.gov/rr/geogmap/sanborn/

Wikipediahttp://en.m.wikipedia.org/wiki/Sanborn_Maps

April 30, 2013

Michigan, Death Certificates, 1921-1952 — #Genealogy, #Michigan

by C. Michael Eliasz-Solomon

Stanczyk, was overjoyed at the announcement of the newest FamilySearch.org database:

Michigan, Death Certificates, 1921-1952

The URL / Link is:  https://familysearch.org/search/collection/1968532 [bookmark it]

FamilySearch_MIDeathCerts_1921_1952

They just published it 29 April 2013 [after some issues were discussed]. No your eyes are not playing tricks, the FamilySearch.org website has had a makeover recently. It may be a unsettling if you have not visited the site in a while, but persevere, it is worth it.

Hurry and grab your dead relatives in case any controversy causes this database to disappear!

 

April 28, 2013

Another Leszczynski Branch in Koprzywnica ???

by C. Michael Eliasz-Solomon

On  24 March 2013, I wrote about Gazetteers … and showed an index map of the Polish War Institute.

To follow along, visit … P46_S33_SANDOMIERZ map to see where Koprzywnica town is and its parish(es). Koprzywnica is near enough to my ancestral villages to merit an interest.

On 11 April 2011, in Ancestry.com, there was posting in the genealogy forums on a thread that I had participated related to the LESZCZYNSKI magnate family (and specifically King Stanislaw Leszczynski). This woman said that her family had a family lore about being related to King Stanislaw. Since this jester has that folklore in my family that has been echoed by 2nd/3rd cousins who also have Leszczynski blood,  I thought I might investigate her (Ms. Rice) ancestors to see if there were any overlap with my own. Also since Koprzywnica was near enough  that this could be a branch my LESZCZYNSKICH, I was off on another tangent.

I started with an Ignatz Leszczynski (the grandfather of Ms. Rice ??) who also happened to live Philadelphia (nice synergy with Stanczyk), because his bride happened to be a Sadowski (Leokadya Sadowski). So I found this Ignatz (Philadelphia) Leszczynski’s ship manifest and he was from Koprzywnica and was coming from his mother Zuzanna (a fairly uncommon Polish name).

On a lark, I said let me see if PTG’s website, genealodzy.pl has any data in their GENESZUKACZ or METRYK project databases for an Ignacy (i.e. Ignatz) Leszczynski from KOPRZYWNICA. Well they did and the year was a close match to the ship manifest. Well GENRSZUKACZ gave me the Akt# (Record #) and the year in KOPRZYWNICA, so I asked if the METRYK project had any image of that record … AND it did! Little Ignacy, was b. 1883 in Akt# 32 and his parents were:

WALENTY LESZCZYNSKI b. about 1849 given his age in 1883 &

ZUZANNA z. GAWRONSKI

Well that was some strong circumstantial evidence that I had found the correct parents for IGNACY LESZCZYNSKI of  KOPRZYWNICA. The year match was good match to ship manifest and the mother was named Zuzanna, a match,  and the birth parish matched the ship manifest.

IgnacyLeszczynski_1883Birth_WalentyZuzanna_32

Ignacy’s record is on the left page (na lewo)

Ignacy’s Church Record (#32) in 1883 also had a marginalia that was significant. It had Ignacy’s death date: 9th-November-1963 (Akt#57) in KOPRZYWNICA. So it appears that Ignacy moved back to Poland (before 1963). Also for those who tracing LESZCZYNSKI genealogy, I have outlined in a red box what LESZCZYNSKI looks like in CYRILLIC handwriting. I also red-underlined the Leszczynski name of the father so you would be sure that this is indeed a LESZCZYNSKI record.

It turns out that METRYK had the marriage record image form Walenty Leszczynski & Zuzanna Gawronski in 1876 (Akt #22) in Koprzywnica too. So now I had a Piotr Leszczynski as father of Walenty (Franciszka Bogunski was the mother). I found Walenty’s birth in 1849 (Akt# 26). From Piotr’s age it appears he was born about 1795. I did find a Teodora Leszczynska, daughter of Piotr Leszczynski & Franciszka Bogunska being born in 1835 (Akt #143). That was how I knew Piotr had a birth year about 1795. I could not find Piotr & Franciszka’s marriage record, so perhaps they were married elsewhere. I also did not find any other children of Piotr & Franciszka (other than Teodora & Walenty).

WalentyLeszczynski_ZuzannaGawronski_1876Marriage_22

Walenty Leszczynski marries Zuzanna Gawronski in 1876 (Akt #22)

OK, so Stanczyk has found another Leszczynski family (albeit a common name). It is close enough that Piotr Leszczynski (father of Walenty, grandfather of Ignacy) could possibly be a father or an uncle of my great-grandfather Tomasz Leszczynski — but I am still a LONG ways away from ever proving that. My only saving grace is that Leszczynski in that neck of the woods, is not so common a family name. Right now, it is only a dream or a hope. But, I wanted to throw it out there and see if I get any hits from other genealogists. Email me!

April 28, 2013

Tsarnaev Genealogy — #Genealogy, #Russian

by C. Michael Eliasz-Solomon

Did you read Stanczyk’s blog from yesterday commenting on the AP Breaking News of the Russian Secret Service having tapes of Zubeidat and Tamerlan Tsarnaev (Царнаев) discussing jihad. I believe the Russians also indicated they had tape of the mother speaking to other person of interest to the FBI also. So go read yesterday’s blog then come back …[I'll wait for you]

TsarnaevSchoolRegister_2001

Tsarnaev / Tsarnaeva – Lines 9,10,11,12

Perhaps you may have missed a link from yesterday on the fine work by Business Insider. They are a fine source of news for what happens in Europe, for those who want yet another viewpoint on which to be informed. You should click on that link (also here) if you wish to see pictures of the family before they came to the US. After I had read that I thought I would write a blog on the school register, which seems to confirm the children (only four, although I have read another account of a fifth child, an unnamed  married daughter in Chechnya). Alas, the AP Breaking News story over ran my composing a story of a school register. But here it is, albeit belatedly …

Line 9 - Bela Tsarnaeva, born 1988, female, Chechen, Arrived In School 2001, 7th grade, from Kyrgyzstan

Line 10 - Alina Tsarnaeva, born 1990, female, Chechen/Avar, Arrived In School 2001, 5th grade, from Kyrgyzstan

Line 11 - Dzhokhar Tsarnaev, n/a, male, Chechen, Arrived In School 2001, 1st grade, from Kyrgyzstan

Line 12 - Tamerlan Tsarnaev, 1986, male, Chechen, Arrived In School 2001, 8th grade, from Kyrgyzstan

The handwriting is in Cyrillic. So if you are trying to learn to read Russian, here is a modern version (much easier than old church registers in Old Russian characters/handwriting) — albeit still difficult for Latin Alphabet readers to discern.

So all children entered the Dagestan school system in 2001. They all came from Kyrgyzstan. We now have credible ages for the daughters and confirmation on their names (Bela/Bella, Alina/Ailina).

It is interesting that one daughter (Alina) had a notation of Chechen/Avar. Her mother was an Avar. Previously, all children were listed as being born in Kyrgyzstan. Why does this one child have Avar by ethnicity? Aren’t all of the Tsarnaevich children Chechen/Avar really — since they all have the same mother.

Even though Dzhokhar’s birth was not given, we know his birthdate from other documents (see also the first story) which indicates: 22-July-1993.

So for those genealogists following the genealogy, those are the best birth dates (or birthyears)  so far that I have seen in news accounts. This data is also from a good source document, not just someone’s notes (or memory). Genealogy in the news.

 

April 23, 2013

FamilySearch Indexing: They Reached A Billion

by C. Michael Eliasz-Solomon

FamilySearch Indexing reached their first billion records online. Congratulations FamilySearch!

logo.gif FamilySearch Indexing: Thanks A Billionopen.aspx?ffcb10-fe561074726701757613-fde81c797d6506787c167670-fe6315707166057a711d-fe5a17707266007a701d-fe2c13767767017b761770-ffcf14&d=10026

Thanks A Billion

The winners
Thank you for contributing to the billion! We did it! We reached a major milestone of one billion records indexed and arbitrated since the launch of FamilySearch indexing in September of 2006. We are grateful for the many volunteers who dedicate their time and efforts to make these records freely available for online research. Languages

Deutsch Italiano
Español Русский
Français Português
日本語 Polski
Nederlands Svenska

BillionsBadge_EN.pngKenneth B. (California, United States), Brittney S. (Idaho, United States), and April R. (Alberta, Canada) were the lucky ones to index and arbitrate the billionth record! They will receive a FamilySearch backpack stuffed with FamilySearch goodies. We also want to thank all the volunteers who have contributed to the billion records with a FamilySearch indexing badge. You can download your free badge at https://familysearch.org/node/2113.

It took us seven years to reach the first billion. How long do you think it will take us to reach the next billion? The advances of technology and the dedication of our volunteers have increased the speed in which we can process and deliver records for publication. Join the global effort to make the next billion records available for family history research. Start indexing now! familysearch.org/indexing

Sincerely,

FamilySearch indexing

FamilySearch.org is the largest free collection of online resources for family history research. With billions of historical records, powerful search tools, family trees, and an active community, FamilySearch.org helps everyone discover, preserve, and share their family history.You received this message because you are a registered volunteer with FamilySearch indexing, signed up to receive e-mails, or received this as a forward. The original was sent to mike.

If you have questions, comments, or concerns, please contact FamilySearch at support.

LDS Logo

I have been an intermittent contributor to this and other genealogy indexing projects. Doing RAOGK helps others and because of the interconnectedness of our family trees, it may ultimately help our own families. Congratulations again to FamilySearch!

April 21, 2013

The Sad Saga of the Tsarnaevich — #Family, #Law, #Terrorism, #Boston, #Tsarnaev

by C. Michael Eliasz-Solomon

Stanczyk has not been riveted by a story since the DC Sniper story of October 2002. So today, I chronicle the sad saga of Tsarnaevs (царнаев Tsarnaev in Russian Cyrillic). My story source materials are listed at the end. There are similarities to the DC Sniper story, both were on the east coast. Both had an older man and a younger man dynamic (Allen/Boyd, Tamerlan/Dzhokhar). Both were senseless killings of people. Let’s see what motive Dzhokhar ascribes for his and his brother’s actions. John Allen Muhammad (JAM) said his motive was an Islamicist jihady-thing.

Possibly estrangement played/plays a role in both stories. The DC Sniper case was not allowed to prosecute a case based upon JAM’s estrangement from his wife/kids. Tamerlan/Dzhokhar seemed to be separated from their father and estranged from an aunt and two uncles in the US/Canada. Tamerlan said he was estranged from America, unable to form any friendships (except for a murdered friend?). That estrangement of the brothers Tsarnaev may have been felt more strongly when their father left America to go have a brain hematoma operated on … in Russia. Why not the US? Was it a stroke or a tumor. Someone said it was brain cancer — albeit a tumor could be interpreted as an early stage of cancer. Certainly Anzor, thought he was going to die [perhaps he wanted to die on Russian soil], perhaps the sons thought he would too. In 2011, the FBI asked questions of Tamerlan, at the behest of some foreign nation, if he was involved with a terrorist organization (which the FBI had cleared him and his family of). Perhaps an aunt who is(or will be) a lawyer and two uncles who are doctors made the brothers Tsarnaev feel inadequate (or maybe only Tamerlan). Perhaps Tamerlan was feeling angry and tied down by a wife and daughter and rueing his inability to compete in Olympic boxing.

Anzor (Анзор) Tsarnaev (Царнаев) fled Chechnya for the neighboring safe-harbor of Kyrgyzstan. After a few years of this self-imposed exile, he moved his family to Dagestan, and a year later he comes to the USA in March 2002, under refugee status; This was with help from his sister, Maret (a lawyer or studying law in Canada). Ruslan & Alvi the two brothers of Anzor are doctors (MDs) living in Maryland. In 2003, Tamerlan and his sisters (Bella & Ailina) emigrate to the US and rejoin their family.

The Tsarnaev (Царнаевых) Family (Father, Mother, Tamerlan (Тамерлан), Dzhokhar (Джохар), and two daughters, Bella & Ailina) relocated to USA in 2002/2003 under refugee status with the aid of the aunt (Maret).

Timeline

October 1986 Tamerlan Tsarnaev born, Kyrgyzstan

About 1987 Bella Tsarnaev born, Kyrgyzstan

About 1990 Allina Tsarnaev born Kyrgyzstan

22 July 1993 Dzokhar Tsarnaev born, Kyrgyzstan

Before 1993 Ruslan Tsarnaev (brother of Anzor, uncle to the alleged bombers) emigrates to US

2001 Family moves to Makhachkala, Dagestan (Russian Federation)

2002 Maret Tsarnaeva – after she helped them [Anzor, her brother and his family] apply for refugee status to the US. [source: Maret’s words, from Wash. Post article 4/19/2013]

March 2002 Family moves to US, apply for refugee status (Exact Location unknown), Except Tamerlan & two sisters; [Dzhokhar’s principal said they left March 2002 for US; source: http://www.freeinews.com/global/alvi-and-ruslan-tsarni-two-uncles-speak-on-bombing-suspects]

2003 Tamerlan & two sisters come to US

2003 Tsarnaev family move to Boston area (source: uncle Ruslan in MD)

2006-2008 Tamerlan at Bunker Hill Community College; 2007 Tamerlan becomes legal permanent resident [source: NBC].

2011 Dzokhar graduates Cambridge Rindge & LatinSchool, Receives $2,500 Cambridge city grant, enrolls in UMASS-Dartmouth pre-med program.

about 2011 Anzor returns to Russia [after treatment in Russia for brain cancer or a brain hematoma?]

September 2011 Tamerlan’s friend Brendan Mess is murdered in Waltham, MA

January 2012 Dzokhar visits Dagestan [his father? for operation ??]. It appears Tamerlan went too and stayed for six months in Dagestan area.

13 June 2012 Mother (Zubeidat Tsarnaev) is arrested for alleged shoplifting at Lord & Taylors store

11 Sept 2012 Dzhokhar becomes a Naturalized US citizen (at TD Banknorth Garden, Boston)

15 April 2013 2:50PM Tsarnaevs are alleged to have planted and exploded two bombs at Boston Marathon.

18 April 2013 Photos, Videos place both brothers at scene of crime, Eye Witness and Victim Jeff Bauman witnesses a suspect (Tamerlan) drop bag which blows up 2 minutes later and identifes him to FBI. FBI releases photos & video of two suspects.

19 April 2013 1:35am Tamerlan Tsarnaev dies of wounds: gunshots, explosive burns, injuries from being run over and dragged by car by his younger brother Dzhokhar Tsarnaev according to eye witness accounts.

19 April 2013 8:45pm Dzhokhar is captured after a final shoot-out at his hide-out in boat; Captured alive, conscious & transported to hospital.

What does the father say?

Анзор Царнаев, отец Джохара и Тамерлана Царнаевых (Aznor Tsarnaev, father of Dzhokar & Tamerlan — the brothers Tsarnaevich).

The father is sowing the seeds of misinformation in the Russian Federation in a predominantly Muslim state. He has claimed the US has framed his sons (a charge echoed by the Canadian aunt, Maret). Read the Interview from Izvestia. The FBI should, look at the timeline of the father’s comments and the phone records and translate them. Notice the father never came back to the US and supported his children (who had become adults, though Dzhokhar was too young to live alone with an older brother, who was young and married and had a baby, with no adult relatives for support). Stories of 20-April-2013 indicate the mother is in Dagestan. I did not see whether the charges against the mother were resolved (was she innocent or guilty of the crime? Was she deported?). Now the father wants permission to enter the US again??? After his fomenting dissent abroad, I do not think we can risk the father coming back to the US. What crime might he commit because his one son is dead and his other son faces numerous capital crime charges. There is a reason that the doctor brothers have disassociated from the rest of the family. These men are doctors. We must think about their safety too. Who knows what the father might do. The father spoke poorly of our nation to his nation/peoples. We cannot let that kind of radical inside the US, not under the present circumstances. Every American needs to write/call/email their Congressperson and let them know we do not want ANZOR TSARNAEV back in the USA. I also think that MARET TSARNAEV should not be allowed back in for similar reasons, even though she appears to live in Canada.

http://youtu.be/MZIb5xMSoLE (Youtube of father, see translated Interview [below] in Izvestia newspaper with the father from 19-April-2013 about 5:00am EST). The father is either lying or woefully misinformed about his family. Sad.

Izvestia newspaper interview (URL: http://izvestia.ru/news/549078), translated:

Father of Tsarnaevich brothers, some years living in Dagestan, is confident that his sons were not involved in bloody events that took place a few days ago in Boston in the United States. The eldest son of Tamerlane, he said, was happily married – with his American wife, that he raised his daughter. And the younger Johar – honors and pride of the family. Tsarnaev Anzor, who lost one son, fears that security forces would kill both.

[Anzor] – My children just set up. One killed, how could they? The same intelligence agencies. They had to hold it simple. Now I’m afraid for the second son. I keep in touch with them. Yes, I live far away, but I know what my kids are doing.

Q: When was the last time you spoke with your sons?

- With Tamerlane, immediately after the terrorist attack in Boston. As soon as I heard on TV, how awful it happened, I immediately dialed the phone the elder son answered, I asked, “Were you there? Since you did not happen? “He said, ‘Dad do not worry, we did not go there. Weare alive and well. “

Q: When you last saw sons?

- A year ago. But all the time we called each other. They talked with myself, I know what my kids are doing. The elder son – a boxer, four-time champion of America, one of the versions[twice Golden Gloves]. In the U.S. everyone knows he is a celebrity [before the Boston Marathon bombing]. Tamerlane is also a musician, playing the piano jazz. Once wanted to become a professional boxer, we tried to dissuade him, we said, what about permanent injury, why do you need it? And then he got married and had a daughter, now she is three and a half years. And he changed his mind to go to the professionals [actually dropped out from accounting studies at Bunker Hill Community College].

Q: He worked somewhere?

- No, he studied at the acting school, and sat with the child. He has worked as a wife. In a social institution – do not remember the name – took care of the disabled. My son did not have any free time. Always is on the clock.

Q: And Johar? When did you last talk to him?

- Three days ago. I Called and asked how things and said that he should come here for a vacation. He agreed. After all, he is the last time the child was, when we left, so he never returned. I briefly talked to him, he was in a hurry to go to class.

- It is known that he went to Cambridge?

- Yes, my youngest – the pride of the family. Always straight A student, dreamed of becoming a great doctor. He received a scholarship to study as the most talented. Never in any radical groups did not participate, hate talkers. With the money he has, of course, there were problems. But I helped him, sent a little bit, and he himself worked. In his free time, got a job as a pool lifeguard. He did not have time for all sorts of nonsense. And then, he could not go for it against the will of Tamerlane and his older brother would not allow to deal with such things.

- You yourself why left the U.S.?

- I went back home to die. I had a hematoma of the brain. I was sure – this is the end. But it has taken out, literally at my grave. And my sons were there.

- They became citizens of the United States?

- No, both of them – the citizens of Russia. For Tamerlane, his wife – an American, but he himself Russian. And Johar too. I fear for my second son. I am afraid that they will kill him, too. But I know – they[my sons] are not to blame.

My Opinion

Neither the mother, the father, nor the aunt should be granted access to travel to the US. The father and mother both have sown the seeds of dissent against the US in a predominantly Muslim state of the Russian Federation. The aunt in Canada (Maret) I am on the fence about whether the aunt should be allowed into the US for access to the trial or to support Dzhokhar Tsarnaev. Her rhetoric is inflammatory and this trial will already be a sensation and tension-filled event wherever it is held and we will have to have extra security if the aunt is allowed in her due to her remarks.

I think the presence of the father, mother, and aunt presents an element of risk and the potential to foment further violence, if not actually commit actual crimes [in the case of the parents].

I think Ruslan and his brother Alvi are fine/decent/honorable Americans and we should protect both of them as valuable members of American society who are estranged from their brother Anzor (and his sons). The presence of these other Tsarnaevs on US soil, risks injury to these two valuable Americans who are medical doctors. The two daughters might also be harmed by violent rhetoric if these Tsarnaevich are allowed to re-enter the US. The safety and the protection of our society will be at risk throughout the resulting trial of Dzhokhar Tsarnaev; There is no need to increase that risk further.

I wish Ruslan and Alvi and their families well. I feel empathy for Tamerlan’s widow and 3 year old daughter. I hope for the best for the two sisters who remain in the US.   The rest of the sad Tsarnaevich in this saga we should not support or entertain upon US soil. Dzhokhar the naturalized US citizen is due his legal rights — but those rights do not include the support of those who foment dissent against the US in nations abroad and then wish to egress to our nation afterwards and use the media focus of a sensational event for their own purposes.

What do you say, my fellow Americans? Say it loud enough to be heard in Washington D.C. !

Source Materials

  1. A Quick Search of Ancestry.com for “Tsarnaev
  2. Google.RU search on Анзор, джохар , царнаев (Anzor/Dzhokhar , Tsarnaev) in Russian Cyrillic
  3. NYT/USA Today articles
  4. Washington Post/Baltimore Sun articles
  5. Boston Globe articles, timelines
  6. Izvestia Interview, Youtube Videos (Anzor, Ruslan)
  7. MyLife.com pages on Tsarnaevich with public declared names, ages
April 6, 2013

Holocaust Remembrance Day (Yom HaShoah) — #Genealogy, #Jewish, #Polish

by C. Michael Eliasz-Solomon

RemembranceHolocaust Remembrance Day (Yom HaShoah) 2013 begins in the evening of: Sunday, April 7
and ends in the evening of: Monday, April 8. In the Hebrew Calendar is 27 Nisan (see Stephen Morse’s Jewish Calendar Conversion tool) is Yom HaShoah and varies in the Gregorian calendar across the Months of April/May.

To honor my wife Teréza and our children let me add a Jewish Genealogy blog post. It is for a Polish village in the AP Grodzisk (Warsaw, Blonie) and is called: Góra Kalwaria. Góra Kalwaria can be found in PRADZIAD database. What is great about this news is that there is yet another project beyond the ones I have previously written about (SzukachwArchiwum.pl and Metryk in PTG). This village and its images can be found in: Metryki.GenBaza.pl (AP Gordzisk) for :

This is just one of many congregations (Catholic & Jewish) that they have scanned. There appear to be about 110 villages in total so far this Polish National Archive in Grodzisk (a branch office of Warsaw).  I picked this village because it is all about the Jewish congregation (that I provided the Pradziad link for). The records run from 1826 – 1910 inclusive and there no missing years. This is a remarkably complete/intact record of a Jewish congregation in Poland. The scanned records from 1826-1867 are written in Polish and then starting in 1868 the records are written in Russian all the way through 1910.

So for the Jewish-Polish genealogists who read this blog, here is a treasure trove to research. In actuality, many of the 110 villages have Jewish records. Look for the abbreviation ‘moj’ (short for mojżeszowe). So I hope this is a joyful news for the remembrance of this solemn occasion.

Good genealogy to all my readers!

–Stanczyk

.

April 5, 2013

AP Kielce, An Inventory of the National Archive in Kielce, Poland — #Genealogy, #Polish, #Archive

by C. Michael Eliasz-Solomon

APKielce

From a forum at genealodzy.pl  Stanczyk saw a PDF document mentioned. When I looked at it, I saw it was an inventory (in progress) of the holdings of  the National Archive in Kielce (AP w Kielcach). So I have produced a condensed version of their work-in-progress. Yes, most of these are related to Stanczyk’s family tree. For their complete inventory list (which was 424 items), see the link (URL) at the bottom of this table.

Now I mention this particular AP (National Archive) because it is the archive that covers the Russian-Poland partition that my ancestors were from. There may be other inventories for other archives.

AP KIELCE

 # Nr zespołu – # Rec. Group Stan na dzień (as of) 2013-02-01 Nazwa daty skrajne – date range księgi – books metry ilość sfotografowanych ksiąg – number of books photographed ilość zrobionych zdjęć – number of photos taken Braki – deficiencies
1 388 Beszowa 1875-1911 54 71 58 3770 oddział Sandomierz
2 341 Biechów 1875-1908 55 0.83 55 2 538
3 146 Kazimierza Wielka 112 1.03
4 353 Oleśnica 1875-1911 61 0.97 69 3 506
5 812 Opatów 1825,1890-1906 14 0.39 11 2369 oddział Sandomierz
6 152 Opatów 120 1.31
7 658 Opatów-gr 1834-1836 4 0.04 4 36 oddział Sandomierz
8 44 Opatów-moj 1831-1910 46 0.95 47 6860 oddział Sandomierz
9 814 Opatów-pr 1896-1915 19 0.23 20 573 oddział Sandomierz
10 871 Ożarów 1890-1910 3 0.06 4 445 oddział Sandomierz
11 45 Ożarów-moj 1826-1909 43 0.61 43 3419 oddział Sandomierz
12 355 Pacanów 1875-1908 62 0.91 64 3 703
13 373 Pacanów moj 51 0.76
14 245 Połaniec 1810-1910 106 2.05 106 12507 oddział Sandomierz
15 252 Połaniec-moj 1826-1910 88 0.99 92 3425 oddział Sandomierz
16 246 Staszów 1810-1910 103 1.65 103 10146 oddział Sandomierz
17 253 Staszów-moj 1826-1910 84 1.33 86 6236 oddział Sandomierz
18 362 Stopnica 48 0.88
19 374 Stopnica moj 46 1.29
20 582 Stopnica pr 3 0.02
21 97 Tumlin 189 1.67
22 370 Zborówek 1875-1908 58 0.66 65 2 295

Source: http://s6.genealodzy.pl/pliki/asc/apkielce.pdf

I tried to provide a reasonable translation (using Google Translator with some hand-tweaks) of the Polish Column Headings in English.

LEGEND (3rd Column):

A suffix of moj or -moj indicates Jewish records.

pr – Orthodox Catholic

ew – Evangelical

gr – Greek Orthodox

The rest (or any with  rk) would indicate Roman Catholic.

I believe the Column Heading METRY indicates the actual shelf space of storage this record group physically occupies. I believe the units would be in Meters (m). Remember Europe uses ‘,’ where America uses a decimal point. Some appear to be missing the decimal point. In most cases, it appears that Excel has translated the comma to decimal point, but if you look at the source document, you should be aware of this cultural difference.

Follow

Get every new post delivered to your Inbox.

Join 428 other followers

%d bloggers like this: