Abstract: Various systems and methods determine a distance, magnitude, and azimuthal angle describing the location of an anomaly within a geologic formation. For example, a method involves identifying an electrical characteristic (e.g., resistivity or conductivity) at each of several sensors in a measurement-while-drilling (MWD) tool. Based on the electrical characteristic, information identifying a formation property of the anomaly is generated. The information includes at least one magnitude and at least one distance. Information information identifying an azimuthal angle is also generated based upon the electrical characteristic. The azimuthal angle relates a position of the anomalous formation to a position of a first sensor in the MWD tool.

Abstract: Various systems and methods determine a distance, magnitude, and azimuthal angle describing the location of an anomaly within a geologic formation. For example, a method involves identifying an electrical characteristic (e.g., resistivity or conductivity) at each of several sensors in a measurement-while-drilling (MWD) tool. Based on the electrical characteristic, information identifying a formation property of the anomaly is generated. The information includes at least one magnitude and at least one distance. Information information identifying an azimuthal angle is also generated based upon the electrical characteristic. The azimuthal angle relates a position of the anomalous formation to a position of a first sensor in the MWD tool.

Abstract: A system emulation tool and method provides a user interface having various options that are selectable by a user for exporting environment information from one or more target database systems. The user interface in one arrangement includes multiple screens that are invoked in response to user action. Exported data from the one or more target database systems is stored in corresponding files. The user interface of the system emulation tool also provides options to enable a user to import the environment information to a test system. In the test system, the environment information is used to create an environment that emulates the environment of the target database system.

Abstract: An execution plan of a query for a parallel database system is determined. In one arrangement, the parallel database system is a relational database management system. The execution plan of the query is determined by an optimizer program. Execution plans are inserted into one or more explain tables that are accessible by a visual explain and compare module to display the steps of the execution plan in a graphical user interface. Parallel execution of steps of the execution plan can be depicted in the graphical user interface. Further, plural execution plans for a given query under different conditions may be compared.

Abstract: Implementations of a partitioned database system and a method of using a database system are disclosed. One system implementation includes storage facilities. Each storage facility includes data from database table rows. The database table rows in each storage facility that correspond to a specific database table are logically ordered according to a row identifier (row ID). The row ID includes a first value that is based on one or more columns of the table. The row ID also includes a second value that is based on one or more columns of the table, which may be different from or the same as those on which the first value is based. The first value of the row ID is predominate in determining the order of the rows in the storage facilities. The second value determines the order of those rows with identical first values.

Abstract: A method for performing a join of a first table and a second table is disclosed. In one instance, each of the plurality of first table rows is grouped into one of a plurality of first table partitions. It is determined that a partitioning column of the first table is specified in an equality condition of the join. One of the plurality of second table rows is selected, and a partition number is generated for the selected one of the plurality of second table rows. For a second table row for which a partition number was generated, a first table partition with a partition number that matches the generated partition number is identified, and a product join is used to join the one or more first table rows in the matching partition with the selected one of the second table rows.

Abstract: A method for joining two value-ordered primary index tables T1 and T2 in response to a join command is disclosed. T1 and T2 each include rows. T1 and T2 each have a first row. A subset of the rows of T1 is loaded into memory. The subset is consecutive and includes the first row of T1. The first row of T2 is loaded into memory. The loaded row of T2 is compared to the loaded rows of T1. If there is a match, it is output. If there is not a match, that lack is recorded. A next consecutive row of T2 is loaded into memory. The comparison, output, recording, and loading of consecutive T2 rows is repeated. New rows of T1 are loaded into memory. The new rows are consecutive and are consecutive with the previously loaded rows of T1. The combination of a repetition of comparison, output, recording, and loading of consecutive T2 rows with loading new rows of T1 into memory is repeated.

Abstract: An execution plan of a query for a parallel database system is determined. In one arrangement, the parallel database system is a relational database management system. The execution plan of the query is determined by an optimizer program. Execution plans are inserted into one or more explain tables that are accessible by a visual explain and compare module to display the steps of the execution plan in a graphical user interface. Parallel execution of steps of the execution plan can be depicted in the graphical user interface. Further, plural execution plans for a given query under different conditions may be displayed for comparison.

Abstract: A method and computer system for copying a portion of a database structure associated with a query are disclosed. The database includes one or more database objects. The method includes recursively retrieving object definitions for one or more database objects associated with a query to produce an ordered set of object definitions. It also includes building a copy of the database structure using the ordered set of object definitions.

Abstract: A method, computer program, and computer system are disclosed for indexing database table rows. A first set of one or more columns of the database table is chosen. A second set of one or more columns of the database table is chosen. An index record is generated for each unique result of applying a second function to a value corresponding to the second set for the database table rows. In each index record, only a single copy of each unique result of applying a first function to a value corresponding to the first set for the database table rows having the result of applying the second function to a value corresponding to the second set for that index record is included. The first set is not identical to the second set. At least two rows of the database table rows have the same result of applying the second function to a value corresponding to the second set and have the same result of applying the first function to the value corresponding to the first set.

Abstract: A method, computer system, and computer program are claimed for selecting rows from first and second tables each having rows containing values in columns. In at least the first table, the rows are divided into partitions at least one of which is populated by one or more rows. The method, computer system, and computer program include creating a plurality of partition contexts, each partition context corresponding to a populated partition and storing at least a first value associated with a row. The lowest first value stored by the partition context is determined. Rows with a particular first value are identified by reading the partition contexts, creating a temporary file context corresponding to one of the partition contexts, the temporary file context including location data for a data block of rows in memory, and reading rows in memory.

Abstract: A database system for selecting rows from a partitioned database table is disclosed. The partitioned database table includes rows and columns and is divided into partitions with at least one of the partitions in the table being populated by one or more rows. The system includes one or more nodes, each of the one or more nodes providing access to one or more CPUs. Each of the one or more CPUs provides access to one or more virtual processes. Each process is configured to manage data, including the partitioned database table, stored in one of a plurality of data-storage facilities. The system also includes a partitioned table access component configured to select rows from the table by creating a file context, which stores at least location data for a row and a first value associated with the row, for each populated partition, determining the lowest first value stored by the file contexts, and identifying rows with a particular first value by reading the file contexts.

Abstract: A method for reorganizing rows from a partitioned database table is disclosed. The partitioned database table includes a plurality of populated partitions. Rows are organized in each of the populated partitions in accordance with a first value associated with each row. A file context is created for each partition of a subset of the populated partitions, each file context stores at least location data for a row in the partition and the first value associated with the row. Rows and merged from the subset of partitions into a single first-merge partition in order of the first value associated with each row. The creation of file contexts and merging of rows in the corresponding partitions is repeated until the subsets have included all populated partitions.

Abstract: System and method for borehole compensation. The method includes simultaneously transmitting at least two modulated signals from one or more transmitters; receiving the at least two modulated signals by at least one receiver; and processing the received at least two modulated signals to determine a phase difference and an amplitude attenuation of the transmitted modulated signals, the processing providing borehole compensated data.

Abstract: A method of performing a join includes identifying a join that identifies a first table and a second table. The first table includes a plurality of first table rows. Each of the plurality of first table rows are grouped into one of a plurality of first table partitions. The second table includes one or more second table rows. Each of the plurality of second table rows are grouped into one or more second table partitions. A determination is made as to whether the first table and the second table are joined on equality constraints. The one or more first table rows are joined with the one or more second table rows using a rowkey merge join where equality exists.

Abstract: System and method for borehole compensation. The method includes simultaneously transmitting at least two modulated signals from one or more transmitters; receiving the at least two modulated signals by at least one receiver; and processing the received at least two modulated signals to determine a phase difference and an amplitude attenuation of the transmitted modulated signals, the processing providing borehole compensated data.

Abstract: A method and apparatus for a downhole antenna comprising a housing having an outer surface and a longitudinally bored inner cavity, the outer surface having a first slot and a corresponding second slot extending from the outer surface to the longitudinally bored inner cavity; a first removable downhole antenna segment disposed in the first slot in a first transverse cross section of the housing, the first removable downhole antenna segment comprising at least one coil to inductively couple a signal from the longitudinally bored inner cavity to the earth formation. A second removable downhole antenna segment, interchangeable with the first removable downhole antenna segment, disposed in the corresponding second slot, the second slot in a second transverse cross section of the housing, the second removable downhole antenna segment comprising at least one coil to inductively couple a signal from the earth formation to the longitudinally bored inner cavity.

Abstract: A method and apparatus for a downhole antenna comprising a housing having an outer surface and a longitudinally bored inner cavity, the outer surface having a first slot and a corresponding second slot extending from the outer surface to the longitudinally bored inner cavity; a first removable downhole antenna segment disposed in the first slot in a first transverse cross section of the housing, the first removable downhole antenna segment comprising at least one coil to inductively couple a signal from the longitudinally bored inner cavity to the earth formation. A second removable downhole antenna segment, interchangeable with the first removable downhole antenna segment, disposed in the corresponding second slot, the second slot in a second transverse cross section of the housing, the second removable downhole antenna segment comprising at least one coil to inductively couple a signal from the earth formation to the longitudinally bored inner cavity.

Abstract: An apparatus and method is disclosed for induction logging of electrical properties of earth formations that operates at low frequencies while remaining resistant to skin effect and maintaining mutual balancing. The apparatus includes a plurality of transmitter coils that are at a plurality of distances from a measure point located at an end of the apparatus, and a receiver coil array coupled to receive induced voltages resulting from currents induced in the earth formations by one or more transmitters of the plurality of transmitter coils, wherein the common measure point is located within the receiver coil array, and wherein one or more of the plurality of distances from the measure point are determined according to a function of one or more frequencies associated with one or more transmitters of the plurality of transmitters. According to an embodiment, the function includes determining the distance that is inversely proportional to a square root of the frequency associated with the one or transmitter.

Abstract: System and method for borehole compensation. The method includes simultaneously transmitting at least two modulated signals from one or more transmitters; receiving the at least two modulated signals by at least one receiver; and processing the received at least two modulated signals to determine a phase difference and an amplitude attenuation of the transmitted modulated signals, the processing providing borehole compensated data.