Systems and methods to facilitate utilization of database modeling

• US 7,885,978 B2
• Filed: 03/01/2005
• Issued: 02/08/2011
• Est. Priority Date: 07/09/2004
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Lvovitch, Oleg, Conlon, Thomas P., Carroll, Matthew E., Sanders, Paul J., Petculescu, Cristian, Netz, Amir, Dumitrascu, Adrian
• Primary Examiner(s): Vital; Pierre M
• Assistant Examiner(s): Nguyen; Loan T
• Application Number:
  US11/069,480
• Publication Number:
  US 20060010157A1
• Time in Patent Office: 2,170 Days
• Field of Search: None
• US Class Current: 707/802
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06F 8/31 Programming languages or programming paradigms

Abstract

The subject invention relates to systems and methods that extend the network data access capabilities of mark-up language protocols. In one aspect, a network data modeling system is provided. The system includes a protocol component that employs a computerized mark-up language to facilitate data interactions between network components. An extension component operates with the protocol component to support the data transactions, where the extension component supplies various commands above standard network and database protocols. An object model is provided as a wrapper to the extensions in order to support various online and offline database development applications.

Claims

1. A computer-readable storage medium encoded with a computer program to facilitate online database manipulations and offline authoring of database application, the computer program when executed by a processor provides:

a protocol component employs computerized mark-up language to facilitate data interactions between network components;

an computerized mark-up language extension component operates with the protocol component to support the data transactions; and

an object model wraps the computerized mark-up language extensions inside a procedural programming language that supports online database application development features and offline database application development features, wherein the object model provides to isolate online and offline application development from the protocol component details of the server components,

wherein the offline database application development features comprise;

storing intermediate, and incomplete states of objects in one or more data files instead of a server; and

providing direct object editing, versioning support, object distribution and object sharing by utilizing an XML format, and

wherein the online database application development features comprise;

providing a capture mode to capture XML generated by the object model;

an object dependency calculator that assists a programmer in determining which objects are dependent upon other objects;

an allowed bindings helper that provides information to the programmer regarding what bindings to data sources are valid for the object in a particular context; and

generating XML scripts to define server objects to apply different operations to the scripting of the object.

2. The computer-readable storage medium of claim 1, wherein the online database application development features further comprise supporting command options as override arguments to method calls or as properties on one or more objects.

3. The computer-readable storage medium of claim 1, the object model deploys a stored procedure by loading a file.

4. The computer-readable storage medium of claim 1, the object model enables recording of at least one software buffer trace event.

5. The computer-readable storage medium of claim 1, the object model supports a capture mode to examine code generated by the object model.

6. The computer-readable storage medium of claim 1, the object model includes at least one option to apply different database operations to an object scripting operation.

7. The computer-readable storage medium of claim 1, the object model enables a system impact analysis.

8. The computer-readable storage medium of claim 1, the object model determines a server load on one or more object demands.

9. The computer-readable storage medium of claim 1, the object model is associated with a validate method that is called on objects without server interaction.

10. The computer-readable storage medium of claim 1, further comprising an offline development tool to at least one of create, define, and save new objects.

11. The computer-readable storage medium of claim 10, the offline development tool further comprising at least one configuration file to enable concurrent object development.

12. The computer-readable storage medium of claim 10, further comprising a deployment utility to deploy offline applications to a server.

13. A computer system including a processor and system memory, a computer-implemented method for interacting with a database, comprising:

employing a base analysis protocol to communicate between database components;

adding one or more extensions to the base analysis protocol;

creating a list of additional objects required based on objects selected; and

wrapping the extensions in a procedural language to isolate database applications from implementation details within the database components, wherein wrapping the extensions in a procedural programming language that supports online database application development features and offline database application development features, wherein the object model provides to isolate online and offline application development from the protocol component details of the server components,

wherein the offline database application development features comprise;

storing intermediate, and incomplete states of objects in one or more data files instead of a server; and

providing direct object editing, versioning support, object distribution and object sharing by utilizing an XML format, and

wherein the online database application development features comprise;

providing a capture mode to capture XML generated by the object model;

an object dependency calculator that assists a programmer in determining which objects are dependent upon other objects;

an allowed bindings helper that provides information to the programmer regarding what bindings to data sources are valid for the object in a particular context; and

generating XML scripts to define server objects to apply different operations to the scripting of the object.

14. The system of claim 13, further comprising providing an offline development tool to enable object development in an application that is remote from an online database.

15. A computer implemented system, the system including a processor and memory, comprising:

means for extending a base analysis protocol to communicate between one or more network components;

means for defining at least one parameter extension for the base analysis protocol; and

means for wrapping the parameter extension in an object model protocol that supports online database application development features and offline database application development features, wherein the object model provides to isolate online and offline application development from the protocol component details of the server components,

wherein the offline database application development features comprise;

storing intermediate, and incomplete states of objects in one or more data files instead of a server; and

providing direct object editing, versioning support, object distribution and object sharing by utilizing an XML format, and

wherein the online database application development features comprise;

providing a capture mode to capture XML generated by the object model;

an object dependency calculator that assists a programmer in determining which objects are dependent upon other objects;

an allowed bindings helper that provides information to the programmer regarding what bindings to data sources are valid for the object in a particular context; and

generating XML scripts to define server objects to apply different operations to the scripting of the object.

16. A computer-implemented system for interacting with a database, comprising:

a processor and memory;

an application program executed by the processor, the application program comprising;

a protocol component that employs computerized mark-up language extensions to facilitate data interactions between network components; and

an object model that wraps the computerized mark-up language extensions inside a procedural programming language that supports online database application development features and offline database application development features, wherein the object model provides to isolate online and offline application development from the protocol component details of the server components,

wherein the offline database application development features comprise;

storing intermediate, and incomplete states of objects in one or more data files instead of a server; and

providing direct object editing, versioning support, object distribution and object sharing by utilizing an XML format, and

wherein the online database application development features comprise;

providing a capture mode to capture XML generated by the object model;

an object dependency calculator that assists a programmer in determining which objects are dependent upon other objects;

an allowed bindings helper that provides information to the programmer regarding what bindings to data sources are valid for the object in a particular context; and

generating XML scripts to define server objects to apply different operations to the scripting of the object.