Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-12-11
2007-12-11
Fleurantin, Jean Bolte (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C717S106000, C717S114000
Reexamination Certificate
active
11016240
ABSTRACT:
A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.
REFERENCES:
patent: 5297279 (1994-03-01), Bannon et al.
patent: 5437027 (1995-07-01), Bannon et al.
patent: 5696961 (1997-12-01), Briscoe et al.
patent: 5826077 (1998-10-01), Blakeley et al.
patent: 5864862 (1999-01-01), Kriens et al.
patent: 5900870 (1999-05-01), Malone et al.
patent: 6047291 (2000-04-01), Anderson et al.
patent: 6070174 (2000-05-01), Starek et al.
patent: 6108004 (2000-08-01), Medl
patent: 6112024 (2000-08-01), Almond et al.
patent: 6199100 (2001-03-01), Filepp et al.
patent: 6199195 (2001-03-01), Goodwin et al.
patent: 6223344 (2001-04-01), Gerard et al.
patent: 6338056 (2002-01-01), Dessloch et al.
patent: 6370541 (2002-04-01), Chou et al.
patent: 6434554 (2002-08-01), Asami et al.
patent: 6505211 (2003-01-01), Dessloch et al.
patent: 6519597 (2003-02-01), Cheng et al.
patent: 6556983 (2003-04-01), Altschuler et al.
patent: 6564205 (2003-05-01), Iwata et al.
patent: 6578046 (2003-06-01), Chang et al.
patent: 6671687 (2003-12-01), Pederson et al.
patent: 6708196 (2004-03-01), Atkinson et al.
patent: 6772178 (2004-08-01), Mandal et al.
patent: 6785690 (2004-08-01), Davidson
patent: 2002/0091702 (2002-07-01), Mullins
patent: 2002/0152422 (2002-10-01), Sharma et al.
patent: 2002/0198891 (2002-12-01), Li et al.
Yang et al., Data redistribution using MPI user-defined types, IEEE, Nov. 2002, 47-53.
Andrew Eisenberg et al., SQL: 1999, formerly known as SQL3, Mar. 1999, SIGMOD Record, vol. 28, No. 1, 131138.
Wesley W. Chu et al., Associative Query Answering via Query Feature Similarity, 1999, IEEE, 405-409.
Findler, R.B. et al., “Cpntract Soundness for Object-Oriented Languages”,ACM Conference on Object-Oriented Programming Systems, Languages, and Applications, OOPSLA, 2001, 15 pages.
Harrison, C.J. et al., Structure Editors: User-Defined Type Values and Type Inference,IEEE, 2000, 241-247.
Andrews, T. et al., “Combining Language and Database Advances in an Object-Oriented Development Environment”,OOPSLA Proceedings, Oct. 4-8, 1987, 430-440.
Bhattacharya, S. et al., “Coordinating Backup/Recovery and Data Consistency Between Database and File Systems”,ACM SIGMOD, Jun. 4-6, 2002, 500-511.
Biliris, A., “The Performance of Three Database Storage Structures for Managing Large Objects”,ACM SIGMOD, 1992, 276-285.
Buneman, P. et al., “Inheritance and Persistence in Database Programming Languages”,ACM, 1986, 4-15.
Hsiao, H.I. et al., “DLFM: A Transactional Resource Manager”,MOD, 2000, 518-528.
Khan, L. et al., “A Performance Evaluation of Storing XML Data in Relational Database Management Systems”,WIDM, 2001, 31-38.
Leontiev, Y. et al., “On Type Systems for Object-Oriented Database Programming Languages”,ACM Computing Surveys, Dec. 2002, 34(4), 409-449.
Melton, J. et al., “SQL and Management of External Data”,SIGMOD Record, Mar. 2001, 30(1), 70-77.
Papiani, M. et al., A Distributed Scientific Data Archive Using the Web, XML and SQL/MED,SIGMOD Record, Sep. 1999, 28(3), 56-62.
Seshadri, P., “Enhanced Abstract Data Types in Object-Relational Databases”,The VLDB Journal, 1998, 7, 130-140.
Varlamis, I. et al., “Bridging XML-Schema and Relational Databases. A System for Generating and Manipulating Relational Databases Using Valid XML Documents”,DocEng 'OL, Nov. 9-10, 2001, 105-114.
Yoshikawa, M. et al., “XRel: A Path-Based Approach to Storage and Retrieval of XML Documents Using Relational Databases”,ACM Transactions on Internet Technology, Aug. 2001, 1(1), 110-141.
Michael Stonebraker, “Inclusion of New Types in Relational Data Base Systems”,IEEE International Conference on Data Engineering, 1986, 1-19.
Berg, C., “How Do I Create Persistent Java Objects?”,Dr. Dobb's Journal, 1997, 22(4), 98-101.
Chien, A.A., “Concurrent Aggregates (CA)-Design and Experience with a Concurrent Object-Oriented Language Based on Aggregates”,J. Parallel and Distributed Computing, 1995, 25(2), 174-196.
Darby, C., “Object Serializatin in Java 1.1. Making Objects Persistent”,Web Techniques, 1997, 2(9), 55, 58-59.
Frost., “Binary-Relational Storage Structures”,The Computer Journal, 1982, 25(3), 358-367.
Fuh, Y-C. et al., “Implementation of SQL3 Structured Types with Inheritance and Value Substitutability”,Digital Symposium Collection, 2000, Abstract Only, 2 pages.
Haverlock, K., “Object Serialization, Java, and C++”,Dr. Dobbs. Journal, 1998, 23(8), 32, 34, 36-37.
King, et al., “TriStarp-An Investigation into the Implementation and Exploitation of Binary Relational Storage Structures”,Proc. 8 Suppl BNCOD(British National Conference on Data Bases), 1990, 64-84.
Blakeley Jose A.
Carlin Peter A.
Fang Jun
Rathakrishnan Balaji
Sezgin Beysim
Fleurantin Jean Bolte
Microsoft Corporation
Woodcock & Washburn LLP
LandOfFree
System and method for providing user defined types in a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for providing user defined types in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for providing user defined types in a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3832139