WO2000043916A3 - Database item versioning - Google Patents

Database item versioning Download PDF

Info

Publication number
WO2000043916A3
WO2000043916A3 PCT/US2000/001472 US0001472W WO0043916A3 WO 2000043916 A3 WO2000043916 A3 WO 2000043916A3 US 0001472 W US0001472 W US 0001472W WO 0043916 A3 WO0043916 A3 WO 0043916A3
Authority
WO
WIPO (PCT)
Prior art keywords
versioning
stored procedure
databases
database item
database
Prior art date
Application number
PCT/US2000/001472
Other languages
French (fr)
Other versions
WO2000043916A9 (en
WO2000043916A2 (en
Inventor
Steve Kruy
Bill Ramos
Patrick Dengler
Zhenglei Pan
Original Assignee
Microsoft Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority to AU34721/00A priority Critical patent/AU3472100A/en
Application filed by Microsoft Corp filed Critical Microsoft Corp
Publication of WO2000043916A2 publication Critical patent/WO2000043916A2/en
Publication of WO2000043916A3 publication Critical patent/WO2000043916A3/en
Publication of WO2000043916A9 publication Critical patent/WO2000043916A9/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • G06F16/2443—Stored procedures
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases
    • G06F16/219—Managing data history or versioning
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99944—Object-oriented database structure
    • Y10S707/99945—Object-oriented database structure processing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99951—File or database maintenance
    • Y10S707/99952—Coherency, e.g. same view to multiple users
    • Y10S707/99954—Version management

Abstract

Database item versioning, such as items like stored procedures found in databases such as Standard Query Language (SQL) databases. In one embodiment, a program such as an editor, a database, a source and a mechanism. An editor program provides for editing a stored procedure. The databases include the stored procedure. The SCC system stores versions of the stored procedure. The mechanism checks in and checks out the stored procedure to provide for effective versioning thereof.
PCT/US2000/001472 1999-01-21 2000-01-21 Database item versioning WO2000043916A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU34721/00A AU3472100A (en) 1999-01-21 2000-01-12 Database item versioning

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US09/235,038 US7296037B1 (en) 1999-01-21 1999-01-21 Database item versioning
US09/235,038 1999-01-21

Publications (3)

Publication Number Publication Date
WO2000043916A2 WO2000043916A2 (en) 2000-07-27
WO2000043916A3 true WO2000043916A3 (en) 2001-02-15
WO2000043916A9 WO2000043916A9 (en) 2002-05-02

Family

ID=22883828

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2000/001472 WO2000043916A2 (en) 1999-01-21 2000-01-21 Database item versioning

Country Status (3)

Country Link
US (2) US7296037B1 (en)
AU (1) AU3472100A (en)
WO (1) WO2000043916A2 (en)

Families Citing this family (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6931630B1 (en) 2000-09-27 2005-08-16 International Business Machines Corporation Method of, system for, and computer program product for providing automatic identification of a computer program code candidate for web deployment or a stored procedure
US7110936B2 (en) * 2001-02-23 2006-09-19 Complementsoft Llc System and method for generating and maintaining software code
JP2008533544A (en) * 2004-09-20 2008-08-21 コダーズ，インコーポレイテッド Method and system for operating a source code search engine
US20070299825A1 (en) * 2004-09-20 2007-12-27 Koders, Inc. Source Code Search Engine
US20070168975A1 (en) * 2005-12-13 2007-07-19 Thomas Kessler Debugger and test tool
US7818660B2 (en) 2006-01-29 2010-10-19 Litera Technology Llc Method of compound document comparison
US8166003B2 (en) * 2006-05-05 2012-04-24 Microsoft Corporation Permission-based document server
US7979450B2 (en) * 2008-09-15 2011-07-12 Xsevo Systems, Inc. Instance management of code in a database
US8566294B2 (en) * 2008-12-29 2013-10-22 International Business Machines Corporation Database element versioning system and method
US10685177B2 (en) * 2009-01-07 2020-06-16 Litera Corporation System and method for comparing digital data in spreadsheets or database tables
US8136031B2 (en) 2009-03-17 2012-03-13 Litera Technologies, LLC Comparing the content of tables containing merged or split cells
US8386429B2 (en) 2009-03-31 2013-02-26 Microsoft Corporation Generic editor for databases
US8983983B2 (en) 2010-02-04 2015-03-17 Network State, LLC State operating system
US9436727B1 (en) * 2013-04-01 2016-09-06 Ca, Inc. Method for providing an integrated macro module
US11080462B2 (en) 2017-11-13 2021-08-03 Workshare Ltd. Method of comparing two data tables and displaying the results without source formatting
US11263193B2 (en) * 2018-11-19 2022-03-01 Clover Health Generating tables using data records
US11354118B2 (en) * 2020-06-05 2022-06-07 Cross Vista, Inc. Version control system
US11294664B2 (en) * 2020-06-05 2022-04-05 CrossVista, Inc. Version control system

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0769739A2 (en) * 1995-10-20 1997-04-23 Sun Microsystems, Inc. System and method for integrating editing and versioning in data repositories

Family Cites Families (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4558413A (en) * 1983-11-21 1985-12-10 Xerox Corporation Software version management system
US4809170A (en) * 1987-04-22 1989-02-28 Apollo Computer, Inc. Computer device for aiding in the development of software system
CA2025142A1 (en) * 1989-09-28 1991-03-29 John W. White Portable and dynamic distributed applications architecture
US5861895A (en) * 1991-01-09 1999-01-19 Canon Kabushiki Kaisha Ink jet recording method and apparatus controlling driving signals in accordance with head temperature
US5386559A (en) * 1992-07-16 1995-01-31 International Business Machines Corporation Variant domains and variant maps in a versioned database management system
US5652884A (en) * 1994-11-14 1997-07-29 Object Technology Licensing Corp. Method and apparatus for dynamic update of an existing object in an object editor
US5724556A (en) * 1995-04-14 1998-03-03 Oracle Corporation Method and apparatus for defining and configuring modules of data objects and programs in a distributed computer system
US6349407B1 (en) * 1995-12-29 2002-02-19 Sun Microsystems, Incorporated Method and apparatus for re-introducing version control
US5950209A (en) * 1996-10-02 1999-09-07 Alcatel Usa Sourcing, L.P. Software release control system and method
US6112024A (en) * 1996-10-02 2000-08-29 Sybase, Inc. Development system providing methods for managing different versions of objects with a meta model
US6145119A (en) * 1997-03-31 2000-11-07 International Business Machines Corporation Programming development environment for intranet and internet applications employing unique project data structure
US6094684A (en) * 1997-04-02 2000-07-25 Alpha Microsystems, Inc. Method and apparatus for data communication
US6226652B1 (en) * 1997-09-05 2001-05-01 International Business Machines Corp. Method and system for automatically detecting collision and selecting updated versions of a set of files
US5966707A (en) * 1997-12-02 1999-10-12 International Business Machines Corporation Method for managing a plurality of data processes residing in heterogeneous data repositories
US6260040B1 (en) * 1998-01-05 2001-07-10 International Business Machines Corporation Shared file system for digital content
US6279151B1 (en) * 1998-01-20 2001-08-21 International Business Machines Corporation Method and apparatus for remote source code inclusion
US6393437B1 (en) * 1998-01-27 2002-05-21 Microsoft Corporation Web developer isolation techniques
US6457176B1 (en) * 1999-06-25 2002-09-24 International Business Machines Corporation System and method for source code processing
US6449624B1 (en) * 1999-10-18 2002-09-10 Fisher-Rosemount Systems, Inc. Version control and audit trail in a process control system

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0769739A2 (en) * 1995-10-20 1997-04-23 Sun Microsystems, Inc. System and method for integrating editing and versioning in data repositories

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
ANONYMOUS: "Managing a Program's Set of SQL Statements in a Database Environment.", IBM TECHNICAL DISCLOSURE BULLETIN, vol. 34, no. 3, 1 August 1991 (1991-08-01), New York, US, pages 465, XP002154478 *
DAVE MENDLEN: "Versioning Stored Procedures with Visual Studio 6.0 and SQL Server 7.0", MICROSOFT, XP002154479 *
EISENBERG A: "NEW STANDARD FOR STORED PROCEDURES IN SQL", SIGMOD RECORD,US,ASSOCIATION FOR COMPUTING MACHINERY, NEW YORK, vol. 25, no. 4, 1 December 1996 (1996-12-01), pages 81 - 88, XP000702070 *

Also Published As

Publication number Publication date
US7444363B2 (en) 2008-10-28
AU3472100A (en) 2000-08-07
WO2000043916A9 (en) 2002-05-02
US7296037B1 (en) 2007-11-13
WO2000043916A2 (en) 2000-07-27
US20040230616A1 (en) 2004-11-18

Similar Documents

Publication Publication Date Title
WO2000043916A3 (en) Database item versioning
BR0111192A (en) System and method for automatically generating database queries
EP0373132A3 (en) Database management system and method
AU2001239784A1 (en) System and method for automatic loading of an xml document defined by a document-type definition into a relational database including the generation of a relational schema therefor
EP1313037A3 (en) X.500 System and methods including searching
AU3573100A (en) Natural language interface for searching database
AU2296302A (en) Performing spreadsheet-like calculations in a database system
AU4995200A (en) System and method for searching and processing databases comprising named annotated text strings
DE69222169T2 (en) METHOD AND DEVICE FOR RECOVERY OF DATA IN MULTI-STAGE DATABASE SYSTEMS
WO1999050732A3 (en) System and method for rewriting relational database queries
AU2003248830A1 (en) Vertical stent cutting process and system
WO2004036365A3 (en) Dividing a travel query into sub-queries
EP1227411A3 (en) Method and system for importing data
ZA200105302B (en) Method and apparatus for executing pl/sql stored code objects in a database.
EP0501180A3 (en) Dynamic, finite versioning for concurrent transaction and query processing
AU2001271891A1 (en) Methods and system for generating and searching ontology databases
CA2324741A1 (en) Method for providing a system maintained materialized functionally dependent column for a database management system
WO2001095154A8 (en) Object-relational mapping for tables without primary keys
AU1435795A (en) Database versioning with output only of data changed from the previous version
ITMI951510A0 (en) EMULATOR FOR A RELATIONAL DATABASE IN SQL LANGUAGE
WO2002033587A3 (en) Database linking method and apparatus
WO2002021422A3 (en) System and method for representing and manipulating biological data using a biological object model
WO2001001294A8 (en) Biological data processing
WO2001077902A3 (en) Directory searching method and system
WO2000072184A3 (en) A platform independent system of specifying an embedded user interface

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AL AM AT AU AZ BA BB BG BR BY CA CH CN CR CU CZ DE DK DM EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
AK Designated states

Kind code of ref document: A3

Designated state(s): AE AL AM AT AU AZ BA BB BG BR BY CA CH CN CR CU CZ DE DK DM EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A3

Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

COP Corrected version of pamphlet

Free format text: PAGES 1/4-4/4, DRAWINGS, REPLACED BY NEW PAGES 1/3-3/3; DUE TO LATE TRANSMITTAL BY THE RECEIVING OFFICE

122 Ep: pct application non-entry in european phase