Record based code structure

• US 8,171,045 B2
• Filed: 07/31/2008
• Issued: 05/01/2012
• Est. Priority Date: 07/31/2008
• Status: Active Grant

• Current Assignee: Group-A Auto Sports Incorporated
• Original Assignee: Xsevo Systems, Inc.
• Inventors: Adler, Dustin Kurt
• Primary Examiner(s): Wong, Leslie
• Application Number:
  US12/183,823
• Publication Number:
  US 20100030745A1
• Time in Patent Office: 1,370 Days
• Field of Search: 717/110, 717/114, 717/115, 717/118, 717/132, 717/140, 717/145, 717/148, 707/758, 707/769, 707/E17.014, 707/999.003, 707/999.101, 707/999.107
• US Class Current: 707/769
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor

Abstract

The compiled code of a computer program is stored in multiple pieces within a database. Each piece is optionally stored within a separate data record. Execution of the computer program includes using database queries to retrieve pieces of the compiled code for execution. The database and associated database management logic are used to provide numerous advantages in execution and management of the computer program. For example, in some embodiments, database queries are used to help facilitate program flow logic.

Claims

1. A system comprising:

a computing device;

operating system logic configured to run on the computing device and stored on a non-transitory computer readable media of the computing device;

a database stored on a non-transitory computer readable media and including data records configured to store compiled code of a computer program;

code management logic configured for modifying the compiled code and further configured to provision an application to the computing device by sending the database to the computing device via a network;

database management logic configured for accessing the database; and

code execution logic configured to retrieve the compiled code from the data records by executing one or more queries on the database management logic, and to execute the retrieved code on the operating system logic.

2. The system of claim 1, wherein at least part of the compiled code is stored as a function.

3. The system of claim 1, wherein at least part of the compiled code is configured to control a device external to the database.

4. The system of claim 1, wherein the compiled code includes compiled python code, compiled Microsoft .NET Common Intermediate Language code, Perl, PHP, Ruby, or compiled Java code.

5. The system of claim 1, wherein the database further includes data records configured to store non-compiled code.

6. The system of claim 1, wherein the database further includes data records configured to store source code of the compiled code.

7. The system of claim 1, wherein the database further includes data records configured to store hypertext markup language, a script, or extended markup language.

8. The system of claim 1, wherein the code execution logic is further configured to execute a computer program by making a plurality of queries on the database and to execute a plurality of compiled code returned as a result of these queries.

9. The system of claim 8, wherein a program flow of the computer program is dependent on the queries.

10. The system of claim 1, wherein the code execution logic is further configured to determine the queries, the queries being based on conditional program flow logic.

11. The system of claim 1, wherein the code management logic is configured to be accessed via a browser.

12. The system of claim 1, wherein the code management logic is configured to edit source code within the database at a level of individual records.

13. The system of claim 1, wherein the code management logic is configured to edit and recompile the code on a record-by-record basis.

14. The system of claim 1, wherein the code management logic is remote from the computing device.

15. The system of claim 1, further comprising code compilation logic configured to generate the compiled code from source code.

16. The system of claim 15, wherein the code execution logic is further configured to execute a database query to determine if part of the compiled code is available in the database, and to use the code compilation logic to generate the part of the compiled code if the part of the compiled code is not available in the database.

17. The system of claim 16, wherein the code execution logic is further configured to cache a copy of the generated part of the compiled code in the database.

18. A system comprising:

a computing device;

operating system logic configured to run on the computing device and stored on a non-transitory computer readable media of the computing device;

a database stored on a non-transitory computer readable media and including data records configured to store compiled code of a computer program;

code compilation logic configured to operate alternatively in a production mode and a development mode, a greater amount of the compiled code being recompiled in the production mode relative to the development mode after modification of the code;

database management logic configured for accessing the database; and

code execution logic configured to retrieve the compiled code from the data records by executing one or more queries on the database management logic, and to execute the retrieved code on the operating system logic.

19. The system of claim 18, wherein the code compilation logic is configured to automatically compile code prior to storage in the database.

20. A system comprising:

a computing device;

operating system logic configured to run on the computing device and stored on a non-transitory computer readable media of the computing device;

a database stored on a non-transitory computer readable media and including data records configured to store compiled code of a computer program;

code management logic configured for modifying the compiled code and further configured to index the data records based on program flow logic in source code;

database management logic configured for accessing the database; and

code execution logic configured to retrieve the compiled code from the data records by executing one or more queries on the database management logic, and to execute the retrieved code on the operating system logic.

21. A method comprising:

receiving, from a computing device, a request to execute a computer program;

executing a first query to identify a first database record, of a database, in which a subset of a compiled code of the computer program is stored;

modifying the compiled code and adding the modified compiled code to the database;

provisioning an application to the computing device by sending the database to the computing device via a network;

retrieving first code from the identified first database record as a result of the first query;

providing the retrieved first code to an operating system for execution;

generating a second query based on a result of the execution of the retrieved first code;

using the generated second query to identify a second database record, of the database, in which compiled code of the computer program is stored;

retrieving the compiled code from the second database record as a result of the second query; and

providing the retrieved compiled code to the operating system for execution.

22. The method of claim 21, wherein the request is received over a computing network.

23. The method of claim 21, wherein the second query is based on conditional program flow logic of the computer program.

24. The method of claim 21, wherein the compiled code in the second database record consists of a compiled function.

25. The method of claim 21, further comprising determining that a part of the compiled code is not available in the database, generating the unavailable part of the compiled code, and storing the generated part in the database.

26. The method of claim 21 wherein source code is stored in the database.

27. A system comprising:

a first computing device;

operating system logic configured to run on the first computing device and stored on a non-transitory computer readable media of the first computing device;

a database stored on a non-transitory computer readable media of a second computing device and including data records configured to store source code of a computer program;

database management logic configured for accessing the database;

code compilation logic configured to run on the first computing device and to retrieve the source code from the data records by executing one or more queries on the database management logic, and to compile the retrieved source code on the operating system logic; and

code management logic configured for modifying the compiled code and further configured to provision an application to the first computing device by sending the database to the first computing device via a network.