Microsoft Technology Licensing, LLC (Redmond, WA)

The schema of a database is processed and the table tree structure is constructed to define the data relationships that are identified within the schema. The structure of the table tree not only accommodates relationships between main tables of the data but also permits side tables and circular references between tables, if encountered while processing the schema. The table tree structure that is generated is then absorbed by a migration mechanism which iteratively moves data according to the rules. Each layer of the table tree structure are moved in a sequence, with referenced layers being moved before referencing layers. Temporary null values are used to accommodate circular links, while side tables are included during the migration of tables that reference the primary table. This method provides completeness and fault tolerance/failure recovery.

The relational database is a widespread device that can store and retrieve data. A relational database permits an entry to reference or “relate” to another entry through points or keys. Forexample, individual data entries may contain information regarding individual clients, like the customers’ first and last names, mailing addresses, birth dates and similar information. The storage of this information in a relational database canbe visualized by using an array of tables that includes table columns that correspond to individual categories of information like first names, last names and so on, as well as table rows that correspond to the individual entries in the data. In the above example one data entry, containing information about a single customer, could be identified with an identifier, such as a customer identifier, which could also be visualized in the form of the column of data within the table. Data entries that are not related to the above-referenced customer entries using the customer identifier. A data entry that corresponds to a particular order can be used to identify the customer who placed the order simply by providing the customer’s ID. The relational database permits the establishment of relationships between customers, orders and other information. This makes it possible to perform various data analysis functions such as determining what orders have been placed by specific customers.

The individual fields of data, the relationships between data fields as well as the data structures in which the data is kept and similar elements of relational databases are generally specified in one or several schemas that define the way that a relational database stores data and connects the data it stores to each other. Sometimes it is necessary to move certain data from one database to another. For example, a source relational database may need totransfer certain data to a destination relational database to ease a workload in storage or computing with the source relational database. Another example is that a particular customer of an organization that provides relational databases may seek tomove some or all of their information to an alternative relational database.

Methods of migrating a clearly defined collection of data from a relational source database to a target relational database are usually dependent on the schemas used by the relational databases. The migration processes can be complicated and difficult to check and fix.

To address the problems of complexity and schema-specific relational database migration mechanisms, a schema agnostic mechanism to migrate delineated data from relational databases is presented. The schema of the database is parsed and a table tree structure created to delineate the connections between the data within the schema. In addition to accommodating relationships between primary tables of data, the table tree structure is also able to accommodate possible side tables of data and possible circular references between tables in the event that such references are discovered while parsing the schema. The structure of the table tree is then used by a migration mechanism, which iteratively moves data according to the structure. The layers that are referenced are moved before individual layers. Circular links are accommodated through temporary null values, and side tables are accommodated during migrationof the main table that is referencing. This process is complete and fault tolerance/failure recuperation.

This Summary is intended to present a variety of concepts in a simplified form that are further described in the detailed description. The Summary is not intended to identify the key features or essential characteristics of the subject matter claimed. It also is not intended to limit claims.

Additional advantages and features are highlighted in the following detailed description that follows with reference to the accompanying drawings.

Click here to view the patent on USPTO website.


Get Patents with PatentPC

What is a patent?

A patent is granted by the government to safeguard the invention. It grants the inventor the exclusive right to create, use and market the idea. Society gains when new technologies are introduced to the market. The benefits can be in directly, in that it can allow individuals to achieve previously unattainable things, or indirectly, by the economic benefits (business growth and employment) that the innovation offers.

Many drug companies and university researchers seek patent protection for their work and research. Patents can be granted for products, processes, or method of making new materials. To be granted patent protection the invention must be novel, useful and not be obvious to others in the same area.

Patents reward inventors who have commercially successful inventions. They provide a reason for inventors to create. Patents allow entrepreneurs and inventors to know that there’s the possibility that they’ll get a profit on their time, effort and money spent on the development of technology. It means that they can earn money from their work.

Patents are a crucial part of businesses with the ability to:

Protect your innovative products and services

Enhance the value, popularity, and appeal of your products market;

Make your company and your products stand out from others;

Access to business and technical knowledge and data;

Beware of accidentally using content from third parties or losing valuable information, original outputs, or any other outputs that are creative.

Patents convert knowledge of the inventor into a valuable asset which opens up new opportunities to create jobs by licensing joint ventures and joint ventures.

Investors who are involved in the commercialization and development of technology may find small businesses with patent protection to be more attractive.

Patents can result in innovative ideas and inventions. This information could be patent-worthy.

Patents are a way to stop untrustworthy third-party companies from earning from the invention’s efforts.

Patent-protected technology revenues that are commercially viable can be used for financing technological research and development (R&D), which will increase the odds of developing better technology in the near future.

Intellectual property ownership is a way to convince investors and lenders that there are real chances to commercialize your product. Sometimes, a powerful patent can lead to multiple financing opportunities. Patents and other IP assets are able to be used as collateral or as security for debt financing. Investors may also be able to see your patent assets to increase the value of your business. Forbes and others have pointed out that each patent can increase the value of a company by anything from $500,000 to $1 Million.

Startups require a carefully-crafted business plan that builds on the IP to demonstrate that your product or service is unique and superior or ingenuous. Investors will also be impressed if your IP rights are secured or are in the process of becoming secure, and that they support your business plan.

It is essential to keep an invention secret prior to filing for patent protection. Public disclosure of an invention, before filing it could often sabotage its originality and invalidate it. Thus, disclosures that are filed prior to filing (e.g. for testing-marketing investors, investors, or for other business partners) should only be made upon signing a confidentiality contract.

There are a variety of patents, and understanding the different types is crucial to protect your invention. Utility patents cover new methods and inventions made by machines. Design patents cover ornamental designs. Patents for utility are the most effective since they protect the proprietor from copycats as well as other competitors. Frequently the utility patents are issued for alterations or improvements to existing inventions. Utility patents also cover improvements and changes to existing inventions. A process patent will describe the methods or actions to perform a specific action. But, a chemical composition would include an amalgamation of ingredients.

How long does a patent last? Patents for utility last for 20 years after the earliest date of filing, however their expirations can be extended because of patent office delays, for example.

Are you considering the patentability of your ideas? Patents are granted only to the first applicants to file therefore you need to file your patent application quickly. Call PatentPC now to have your patent application approved!

When you’re writing your patent application it is recommended to conduct a patent search, as it will provide you with an insight into the other applicants’ ideas. You’ll be able reduce the nature of your invention. It is also possible to find out about the current latest developments in your area of invention. This will allow you to understand the scope of your invention as well as prepare you for filing the patent application.

How to Search for Patents

The first step to get your patent is to do an internet search for patents. You can do a google patent search or do a USPTO search. Patent-pending is the name used to describe the product that has been covered by the patent application. It is possible to search for the public pair to locate the patent application. When the patent office has endorsed the application, you will be able to conduct a patent number search to locate the issued patent which means that your product has been granted patent. You can also utilize the USPTO search engine. See below for details. For assistance, consult a patent lawyer. In the US Patents are granted by the US trademark and patent office, or the United States patent and trademark office, which is also responsible for examining trademark applications.

Are you interested in finding similar patents? Here are the steps to follow:

1. Create a list of terms that describe your invention based upon its purpose, composition, and usage.

Write down a short detailed description of the invention. Do not use generic terms like “device”, “process” or “system”. Instead, look for synonyms to the terms you chose initially. Also, keep track of significant technical terms, as well as keywords.

Use the questions below to help you find key words or concepts.

  • What is the objective of the invention? Is it a utilitarian device or an ornamental design?
  • Is the invention a way of making something or carrying out some function? Does it constitute an item?
  • What is the composition of the invention? What is the physical structure of the invention?
  • What’s the objective of the invention?
  • What are technical terms and phrases that define the characteristics of an invention? To help you find the appropriate terms, use the technical dictionary.

2. These terms will enable you to look for relevant Cooperative Patent Classifications at Classification Search Tool. If you’re unable to find the right classification for your invention, look through the class Schemas (class schedules) and try again. If you don’t see any results using the Classification Text Search, you may want to consider replacing the words for describing your invention using synonyms.

3. Examine the CPC Classification Definition for confirmation of the CPC classification you found. The link to a CPC classification definition is provided in the event that the title of the chosen classification contains a blue box with “D” on the left. CPC classification definitions will aid you in determining the classification’s scope , so you can pick the one that is the one that is most appropriate. The definitions could also contain some search tips or other recommendations which could prove useful in further research.

4. The Patents Full-Text Database and the Image Database allow you to retrieve patent documents that include the CPC classification. By focusing on abstracts and drawings that are representative, you can narrow down your search for the relevant patent documents.

5. This collection of patent publication is the best to examine for similarity to your invention. Be sure to read the specification and claims. You may find additional patents by referring to the patent examiner and the applicant.

6. It is possible to find the patent application that has been published and match the CPC classification you picked in Step 3. It is possible to use the same search strategy in Step 4 to narrow your results to the relevant patent application by looking at the abstract as well as the drawings on each page. Next, examine the patent applications that have been published carefully and pay particular attention to the claims and other drawings.

7. Find other US patent publications by keyword searches in PatFT and AppFT databases, classification search of non-U.S. patents using the below, and searching for non-patent patent disclosures in the literature of inventions using web search engines. Here are some examples:

  • Add keywords to your search. Keyword searches may turn up documents that are not well-categorized or have missed classifications during Step 2. For example, US patent examiners often supplement their classification searches with keyword searches. Think about the use of technical engineering terminology rather than everyday words.
  • Search for foreign patents using the CPC classification. Then, re-run the search using international patent office search engines such as Espacenet, the European Patent Office’s worldwide patent publication database of over 130 million patent publications. Other national databases include:
  • Search non-patent literature. Inventions can be made public in many non-patent publications. It is recommended that you search journals, books, websites, technical catalogs, conference proceedings, and other print and electronic publications.

To review your search, you can hire a registered patent attorney to assist. A preliminary search will help one better prepare to talk about their invention and other related inventions with a professional patent attorney. In addition, the attorney will not spend too much time or money on patenting basics.