Replication system with methodology for replicating database sequences is described. In one embodiment, for example, in a database system, a method of the present invention is described for replicating a sequence object from a primary database to a replicate database, the method comprises steps of: monitoring changes to table data at the primary database for capturing information sufficiently characterizing the sequence object to allow its replication, the table data being logged to a log file; reading the log file, for determining changes to apply to the replicate database for replicating the sequence object; and reconstructing the sequence object at the replicate database based on the determined changes.
Jianbing Zhu - Shanghai, CN Stephen C. Shepherd - Lakewood CO, US
Assignee:
Sybase, Inc. - Dublin CA
International Classification:
G06F 17/30
US Classification:
707610, 707615, 707638, 707640, 707648
Abstract:
System, method, computer program product embodiments and combinations and sub-combinations thereof for replication resynchronization are provided. An embodiment includes providing a mode of operation in a replication control system for repopulating a replicated version of a primary database that does not affect an ability to continue activity in the primary database. Further included is managing the repopulating of the replicated version with attention to at least a resynchronization marker.
Chengzi Xu - Shanghai, CN Stephen C. Shepherd - Lakewood CO, US
Assignee:
Sybase Inc. - Dublin CA
International Classification:
G06F 17/00
US Classification:
707638
Abstract:
Systems, methods and computer program product embodiments for auto-correction in database replication are disclosed herein. An embodiment includes receiving a log record of one or more database row changes on a table marked for replication. From the received log record, one or more insert operations on the marked table are identified. Each identified insert operation is automatically replaced with a first pair of operations, where each first pair comprises a delete operation associated with a new insert operation. Each first pair, when executed at a replicate database, acts to delete data at a first location identified by each identified insert operation prior to inserting data of the new insert operation at the first location. The embodiment further includes identifying, from the log record, one or more update operations on the marked table, and automatically replacing each identified update operation with a second pair of operations, where each second pair comprises a new delete operation associated with a new insert operation.
Mihnea Andre - Issy les Moulineaux, FR Yanhong Wang - San Ramon CA, US Rajkumar Sen - Pune, IN Heping Shang - Walnut Creek CA, US Stephen Shepherd - Lakewood CO, US Jian Yang - San Ramon CA, US Peter John Dorfman - Belmont MA, US Johan Nicolaas Schukkink - Utrecht, NL Xiao-Yun Wang - Vaucresson, FR Teja Mupparti - San Ramon CA, US Andrew D. Scott - San Ramon CA, US
Assignee:
Sybase, Inc. - Dublin CA
International Classification:
G06F 17/30
US Classification:
707611, 707802, 707687, 707613, 707E17005
Abstract:
System, method, computer program product embodiments and combinations and sub-combinations thereof for a distributed data cache database architecture are provided. An embodiment includes providing a scalable distribution of in-memory database (IMDB) system nodes organized as one or more data fabrics. Further included is providing a plurality of data granularity types for storing data within the one or more data fabrics. Database executions are managed via the one or more data fabrics for a plurality of applications compatible with at least one data granularity type.
Non-Disruptive Data Movement And Node Rebalancing In Extreme Oltp Environments
Mihnea ANDRE - Issy les Moulineaux, FR Xun Cheng - Dublin CA, US Yanhong Wang - San Ramon CA, US Elton Philip Wildermuth - Oakland CA, US Heping Shang - Walnut Creek CA, US Stephen C. Shepherd - Lakewood CO, US
Assignee:
Sybase, Inc. - Dublin CA
International Classification:
G06F 17/30
US Classification:
707827, 707E1701
Abstract:
Systems and methods for non-disruptive cache startup, shutdown, data partition movement, and node rebalancing for a data fabric within a data grid in a database environment. The data grid is a clustered in-memory database (IMDB) cache comprising one or more data fabrics including multiple IMDB cache nodes. The method takes a time tag and moves data from source to destination nodes while allowing updates to data on the source nodes. The method propagates updates occurring after the time tag to destination nodes from source nodes and switches applications and ownership to the destination nodes. Another method slices data for a partitioned fabric and stores slices on nodes. Another method starts a data fabric by moving data from a grid backend to the nodes. In an embodiment, another method rebalances nodes in a non-disruptive manner. When a fabric is shutdown, the method saves data from the nodes to the grid backend.
Replication Support For Procedures With Arguments Of Unsupported Types
Ping Zhou - Shanghai, CN Stephen Shepherd - Lakewood CO, US
Assignee:
Sybase, Inc. - Dublin CA
International Classification:
G06F 7/00
US Classification:
707610, 707E17005, 707E17044
Abstract:
A method, system and computer readable storage medium for replicating procedures with unsupported table data type arguments such as Boolean arguments. The method includes identifying the argument of an unsupported table data type in a procedure to be replicated, mapping the argument to an equivalent supported value, and creating a table containing a column representing the argument as the supported table data type and sending data corresponding to the unsupported table data type argument to a replication server.
Jianbing Zhu - Shanghai, CN Stephen Shepherd - Lakewood CO, US
Assignee:
Sybase, Inc. - Dublin CA
International Classification:
G06F 17/30
US Classification:
707626, 707E17005
Abstract:
System, method and articles of manufacture for filtering a data definition language (DDL) command. The method includes providing a filtering function with one or more rules for filtering the DDL command. The method further includes receiving the DDL command for replication. The method also includes filtering the DDL command from replication based on the one or more rules.
Ping Zhou - Shanghai, CN Stephen Shepherd - Lakewood CO, US
Assignee:
Sybase, Inc. - Dublin CA
International Classification:
G06F 7/00
US Classification:
707634, 707610, 707E17005, 707E17044
Abstract:
A method, system and computer readable storage medium for replicating structured data stored in a database. The method includes identifying the stored structured data, mapping the data to an unstructured data type, and sending the mapped data to one or more replicate databases as unstructured data.
Shepherd Marketing LLC since Mar 2013
Marketing Consultant, Owner
Echelon Energy Jan 2010 - Mar 2012
Partner, Director of Sales and Marketing
Velimpex Marketing Inc 2008 - 2009
Sales and Marketing
ADP Screening and Selection Services 2006 - 2008
Territory Sales
Education:
Northern Arizona University 1998 - 2001
BS, Advertising
The Anschutz Corporation Aug 2009 - Aug 2013
Senior Network Engineer
The Anschutz Corporation Aug 2009 - Aug 2013
Director of Infrastructure and Security
The Anschutz Corporation Aug 2000 - Aug 2009
Network Engineer
Sans Institute May 2003 - Aug 2003
Gsec and Giac Mentor Program Instructor
Omnium Worldwide Mar 1995 - Aug 2000
Information Systems Manager
Education:
University of Nebraska at Omaha 1990 - 1997
Bachelor of Applied Science, Bachelors, Computer Science, Applied Science
Metropolitan Community College 1988 - 1990
Associates, Computer Programming
University of Nebraska - Lincoln 1986 - 1987
Bachelor of Applied Science, Bachelors
Skills:
Network Engineering It Strategy It Service Management Project Management Virtualization Network Architecture Network Design Operating Systems Security Itil Process Implementation Disaster Recovery Network Administration Information Technology Strategic Planning Data Center Operations Data Center Architecture Information Security Integration Infrastructure Cloud Computing Vendor Management It Management Data Center Cisco Routers Emc Storage Fiber Optic Networks Digital Certificates
Languages:
English Spanish
Certifications:
Gsec/Giac Itil Foundation Mcse Mcp Cne Cna Sans Consulting Services, Inc. Itsmf Usa Microsoft Novell
James Azzaro, Anne Dunlap, Jeff Deangelis, Pamela Murray, Tina Demasi, Jeffrey Mehalic, Elizabeth Burns, Jerry Lorenze, Ricardo Genatios, Lana Pavone, Melynda Decosta, Mike Stewart
Elois Eck, Gene Sweatt, Mike Zarrella, Bill Pecha, Betty Gower, Ann Helterbrake, Steve Laubhan, Alice Munyon, Lynnette Anderson, Glenda Palmer, Flora Norton
Freiwald Lab, Rockefeller Laboratory of Neural Systems - Postdoctoral Fellow Ghazanfar Lab, Princeton Neuroscience Institute - Postdoctoral Fellow Platt Lab, Duke Neurobiology - Graduate Student Allman Lab, Caltech Biology (CNS) - Research Technician
About:
I research social and cognitive neuroethology
Bragging Rights:
Cover art stolen from the very talented http://www.gregadunn.com/
Stephen Shepherd
Work:
Moody Broadcasting Network
Education:
Newcastle University
Stephen Shepherd
Education:
Northwood University
Tagline:
I love to meet people and make friends.
Stephen Shepherd
Education:
Ryerson - Rita
Stephen Shepherd
Education:
Wake Forest University - Business
Stephen Shepherd
Education:
Newcastle University - Medicine
Stephen Shepherd
Education:
University of Utah - Philosophy
About:
I am a Cabinetmaker with 40 years experience in the trade. I specialize in 19th Century American Woodwork, I have published 5 books and have written for Muzzleloader magazine, Woodworker's Journa...
Stephen Shepherd
Work:
Dunnhumby
Youtube
"taken" (april 2003), stephen shepherd
stephen reads (and, in formatting for youtube, observes that tagging p...
Category:
Entertainment
Uploaded:
16 Jan, 2009
Duration:
1m 8s
Ben Howard plays "Diamonds" at St Stephen's, ...
Ben Howard plays "Diamonds" at St Stephen's, Shepherd's Bush, London, ...
Category:
Music
Uploaded:
24 Feb, 2011
Duration:
4m 44s
"to your end" (2003), stephen shepherd
stephen reads...
Category:
Entertainment
Uploaded:
16 Jan, 2009
Duration:
1m 1s
Matthew and the Atlas play "I Followed Fires"...
Matthew and the Atlas play "I Followed Fires" at St Stephen's, Shepher...
Category:
Music
Uploaded:
24 Feb, 2011
Duration:
4m 7s
Stephen Shepherd Dancing
stephen shepherd dancing at home really funny and he's sober
Category:
Comedy
Uploaded:
19 Feb, 2008
Duration:
2m 29s
Stephen Shepherd Interview
In spring 2010, University of Wisconsin-Platte... academic staff memb...